Alternatively, you can add _test=True as a param to your select/udpate
queries
db.select('some_table',_test=True);
<sql: 'SELECT * FROM some_table'>
On Wed, Jan 30, 2013 at 5:04 PM, xiaobing jiang <s7v7nisla...@gmail.com>wrote:
> web.webapi.config['debug_sql']= True
>
> On Sat, Jan 26, 2013 at 7:31 AM, David Lewis <
> sleeping.drag...@googlemail.com> wrote:
>
>> conn = web.database(dbn = 'mysql', db = 'database_name', user =
>> 'db_user_name', pw = "db_password") db_rows = db.conn.query("SELECT *
>> FROM table WHERE value=$my_value AND string=$username", vars={'my_value':
>> 17, 'username':"String"}) for row in db_rows: etc
>
>
>
> --
> You received this message because you are subscribed to the Google Groups
> "web.py" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to webpy+unsubscr...@googlegroups.com.
> To post to this group, send email to webpy@googlegroups.com.
> Visit this group at http://groups.google.com/group/webpy?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>
--
You received this message because you are subscribed to the Google Groups
"web.py" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to webpy+unsubscr...@googlegroups.com.
To post to this group, send email to webpy@googlegroups.com.
Visit this group at http://groups.google.com/group/webpy?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
