Hi, actually, I couldn't see the reason of that :-P but anyway this seems to work q=db( db.clients.id > 0).select( db.clients.clientuuid, '%s' % 1)
Paolo On Thursday, May 30, 2013 5:23:34 PM UTC+2, Zach wrote: > > Hi guys, > > I am trying to run something in the form of : > > select clientuuid, 1 from clients ; > > q=db( db.clients.id > 0).select( db.clients.clientuuid, 1) > > I can settle for select clientuuid, 'Y' from clients ; > > however web2py is bing picky and weird and complains that > > AttributeError: 'int' object has no attribute 'type' in the former case > and > > OperationalError: (1054, "Unknown column 'y' in 'field list'") in the > latter. > > Is there a workaround I can use in that situation ? Ideally I would not > like to add fields with constants to my tables. > > Thanks a lot for your time. > > Kind regards, > Zach > -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
