myid = 10L sql_str = "xxx .... where id=%s;" % (str(myid)) db.executesql( sql_str )
examples: https://web2py.wordpress.com/tag/db-executesql/ On Friday, November 20, 2020 at 7:56:07 AM UTC+3 alexg...@gmail.com wrote: > for example > > where mytable.id = someWeb2PyVariable > > thanks, > > Alex Glaros > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- 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 web2py+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/web2py/1888eac3-dab9-4182-97a6-dc5bb3caa84fn%40googlegroups.com.