Hi Yarko, I think you misunderstood SQLTable for SQLTABLE.
When using SQLFORM(db.mytable) you have the showid=False option to escape the 'id' field in the form. I was asking if there is a similar option for SQLTABLE but in this very moment I see that you do not really need this; I have just to call: SQLTABLE(db().select (db.mytable.field1,db.mytable.field2,db.mytable.field3)) and not SQLTABLE(db().select(db.mtable.ALL)) sorry for my stupid question. carlo On 20 Mar, 21:59, Yarko Tymciurak <[email protected]> wrote: > not sure what you are asking... > there is no way to disable the 'id' field from being part of a table in the > DAL; if you are using an existing table, first be sure to set migrate=False > in your table definition: > > db.define_table('some_existing_table', SQLField('some_field'), > migrate=False) > > If your existing table does not have a field called 'id', then the best > thing to do right now is to create a VIEW in your database server, and map > whatever the primary key is in your table to be called "id" in this view, > then create a web2py table definition which refers to this view. > > Hope that helps.... > > - Yarko > > On Fri, Mar 20, 2009 at 12:21 PM, carlo <[email protected]> wrote: > > > What's the best way/trick to have showid=False in SQLTABLE either? > > > thank you > > > carlo --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
