Re: HELP! Dynamic SQL statements in SPL???

Posted in 1998

Chris Dornsife — Thu, 29 Oct 1998 08:09:48 -0800 — source: Informix-list mailing list archive (1991-1998)

Jonathan Leffler wrote in message <363806B6.3422@earthlink.net>... >Gareth Edwards wrote: >> I'm using IUS 9.14 with the web datablade in a web application that >> requires a mail to be sent. The contents of the mail are dependant >> on user selection, and the body is stored in a LVARCHAR. Snip >> I can get the 'synamic' SQL statement built in a >> variable, but I can't find any way to execute it. >> >> Can anyone help me here? build the query in the web-datablade and execute it. <?mivar name="sql1">select $colNames from $tabName where $someWhere<?/mivar> <?misql sql="$sql1;"> $(IF,$(=,1,$1),Do True,Do False) <?/misql>