[ic] if-sql-param question

JT Justman jt at airdelights.com
Fri Jun 10 15:59:52 EDT 2005

jeff at hisgirlfridays.com wrote:

>I am using the following syntax and it is behaving oddly.  Upon further 
>research, I am not even sure that if-sql-param can be used in this way:
>[if-sql-param food eq 'steak']
>        [tmp myscratch]bad[/tmp]
>        hello<br>
>The issue I am encountering is that sql-param food is not equal to 
>'steak', but myscratch is still being set to bad, however, "hello" is 
>never output.  This is just plain weird to me and usually when ITL acts 
>weird it is because I am doing something syntactically incorrect.
>If this syntax is incorrect, what is the optimal way to perform this
I don't see if-PREFIX-param in the docs. You could probably use
something like:

 [if type=explicit compare="[sql-param food] =~ /steak/"]



More information about the interchange-users mailing list