Could anyone show me how to build a query with a computed field that consists of a constant and a value of the ID of the records. The constant is an URL and the value is the ID of the row.
I tried this (among several other attempts). rowsb=db.executesql("SELECT 'dikke bmw' as caption, startdate as start, '../rentals_manage/'+ %s as url, FROM rentals;",as_dict = True,placeholders=('id',)) but that doesn't seem to be valid syntax... the output is needed by Timeline which is actually a very nice widget http://www.simile-widgets.org/timeline/ Danki -- 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. For more options, visit https://groups.google.com/d/optout.