Marin, After some tinkering, SQLCustomType is working nicely for my purposes. Thanks for your help!
On Saturday, July 27, 2013 1:00:29 PM UTC-4, Marin Pranjić wrote: > > 1. SQLCustomType > > > http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Custom-Field-types-(experimental) > > 2. filter_in and filter_out > > http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#filter_in-and-filter_out > > > Marin > > > On Sat, Jul 27, 2013 at 6:53 PM, Woody <[email protected] > <javascript:>>wrote: > >> I have a legacy sqlite3 database that is tied to an application that uses >> 1/0 to represent boolean values. Sqlite doesn't have a boolean data type; >> 1/0 is the conventional representation. I want to define these fields as >> boolean in w2p so they will show up as checkboxes in SQLFORM, but when I do >> that, the values get updated as T/F, which doesn't work in my application. >> >> Is there a way I can make these fields show up as checkboxes in SQLFORM, >> but have the data stored as 1/0? >> >> -- >> >> --- >> 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] <javascript:>. >> For more options, visit https://groups.google.com/groups/opt_out. >> >> >> > > -- --- 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.
