I have the following code snippet in my app:
<fmtcp sandcall "\Pw/=\digit+" DoubleIt>
<capture BIN><sb>$qString</sb></capture>
<$qString=$ret>
The routine DoubleIt is defined as follows:
<a name=DoubleIt EXPORT hit>
<$ret=(2*$hit)>$ret
</a>
When qString, which is a SELECT query string, contains a less than symbol (<), the above snippet of code returns < instead, resulting in a syntax error when the query string is sent to SQL.
For example, if qString contains the following:
"... where convert(PATN_ISD,'date') <= '2008-12-31' ..."
the above snippet of code returns this
"... where convert(PATN_ISD,'date') <= '2008-12-31' ..."
How do I eliminate this side effect?
Thanks
<fmtcp sandcall "\Pw/=\digit+" DoubleIt>
<capture BIN><sb>$qString</sb></capture>
<$qString=$ret>
The routine DoubleIt is defined as follows:
<a name=DoubleIt EXPORT hit>
<$ret=(2*$hit)>$ret
</a>
When qString, which is a SELECT query string, contains a less than symbol (<), the above snippet of code returns < instead, resulting in a syntax error when the query string is sent to SQL.
For example, if qString contains the following:
"... where convert(PATN_ISD,'date') <= '2008-12-31' ..."
the above snippet of code returns this
"... where convert(PATN_ISD,'date') <= '2008-12-31' ..."
How do I eliminate this side effect?
Thanks
