ZSQL and variables in attribute tags in <dtml-sqlvar> ...
Hi all, Ive been working on a ZSQL method that looks up in a supplied data structure to determine how to insert.. the argument to VALUES looks like: values ( <dtml-in "REQUEST.SESSION.get('p_dict')" prefix="loop"> <dtml-if "loop_sequence_item['type'] == 'nb'"> <dtml-sqlvar "form[loop_sequence_item['name']]" type=nb> <dtml-elif "loop_sequence_item['type'] == 'int'"> <dtml-sqlvar "form[loop_sequence_item['name']]" type=int> <dtml-elif "loop_sequence_item['type'] == 'float'"> <dtml-sqlvar "form[loop_sequence_item['name']]" type=float> <dtml-elif "loop_sequence_item['type'] == 'string'"> <dtml-sqlvar "form[loop_sequence_item['name']]" type=string> </dtml-if> <dtml-if sequence-end> <dtml-else>, </dtml-if> </dtml-in> ) .... which is not the best.. what I want to do is: [...] <dtml-in "REQUEST.SESSION.get('p_dict')" prefix="loop"> <dtml-sqlvar "form[loop_sequence_item['name']]" type="<dtml-var "loop_sequence_item['type']">"> </dtml-in> [...] but this doesn't work of course ;)... are there any suggestions on how to refine? Many thanks and regards, Adam
participants (1)
-
adam