8 Jun
2001
8 Jun
'01
1:38 p.m.
Build the query string in the namespace that has your variables, then pass it as a string to the ZSQL method. Or build a list of the fields in that namespace, and pass the list of fieldname:fieldvalue pairs to the ZSQL method. Tom P [Chas Wareing]
this still appears to have fixed variable names- my variable names are dynamic, based on sql column names so I can't predefine their existance in the ZSQL 'arguments' box-
this is my qryInsert object as of tonight (this morning) - it would work in the proper namespace-
field is a sql column, as in 'firstname' or 'address'. _[field] is then its value, which is set in a previous http post form- the ZSQL method bombs out when it can't see the post variables