On Mon, 16 Aug 1999, Evan Simpson wrote: [lot of useful things snipped]
Most often, you will want the values for your parameters to come from request data (a submitted form, environment variables, etc.) In this case you *must* include them in the ZSQL Method's parameter list. If your parameter list is "name email", and REQUEST contains "name" and "email" values, then you can do the following:
I want to write a general ZSQL method like this: insert into <!--#var table sql_quote upper --> ( <!--#in EinAusgabe --> <!--#unless sequence-start -->,<!--#/unless --> <!--#var name --> <!--#/in -->) values <!--#in EinAusgabe --> <!--#unless sequence-start -->,<!--#/unless --> <!--#var expr="_[name]" fmt=sql-quote-->" <!--#/in -->) Where EinAusgabe is a TinyTable describing the field for the form like this: columns: name label ftype length:int default auto data: "event_id", "Event-Nr", "int", 10, "", "max" "art", "Event-Art", "string", 20, "kino", NULL "veran_id", "Veranstalter-ID", "string", 8, NULL, NULL "veran_ort", "Ort", "string", 40, NULL, NULL "veran_title", "Titel", "string", 80, NULL, NULL "veran_link", "Link", "string", 40, "http://", NULL "datum_von", "von", "date", 10, NULL, NULL "datum_bis", "bis", "date", 10, NULL, NULL "zeiten", "Zeiten", "string", 60, NULL, NULL and nothing in the parameter list. This actually works, except, that I have to name the arguments in the list. How can I avoid that ? Can I use dtml-tags in the argument list ? Gruß Joachim Schmitz WWW-Consultant email: js@ac-copy.net tel: +49-241-89491-0 fax: +49-241-89491-29