14 Jan
2004
14 Jan
'04
3:45 p.m.
Hi Everyone, I want to run a zsql select statement from a python script. I want to specify the column headings to include in the SQL statement in the python script before executing the script. I have tried using <dtml-sqlvar my_column_headings type="string"> but this puts quotes around them. ZSQL: select <my_column_headings> from applicant In my python I want to specify the headings as a variable, eg. my_column_headings = title, surname The variable is passed to the ZSQL and executed as: select title, surname from applicant. Do you see what I mean, is thgis possible? If so could someone point me in the right direction. Kind Regards, Rob