I wanted to create an empty data set, just to get the table structure, but to avoid returning any records, due to large size of the table.
I'm using the MySQL and if I do it as bellow, seems that everything goes into an infinite loop, where I thought it will just be as SELECT * from Prod WHERE 1=0, which would usually return "no records" pages = db(1==0).select(db.page.id, db.page.name, orderby=db.page.name) If this is not an option, how would I return an empty data set? Thanks...
