Tango is trying to let you forget about escaping quotes. The default
encoding in a Direct DBMS action is SQL. Tango expects most people will
do something like this in a Direct DBMS:
... where my_column = '<@VAR someVar>' and ...
If someVar contains "D'Angelo" you would want Tango to make this
"D''Angelo" (do SQL encoding.) In your particular case you are composing
SQL in a variable so you want to supress SQL encoding, like so:
... where <@VAR myClause ENCODING=NONE> and ...
By the way, you shouldn't need to escape your single quotes when you use
them as values for your radio button. In a Results action the default
encoding is HTML, which is what you would want in most cases (escape "&"
to "&", etc.)
On Wed, 28 Aug 2002, Chuck Lockwood wrote:
> I am trying to use an argument with embedded single quotes in a direct DBMS
> and it keeps doubling them, regardless to whether I use ' or <@SQ>. So,
>
> <INPUT TYPE=RADIO NAME="zips" VALUE="czip between <@SQ>01<@SQ> and
> <@SQ>99999<@SQ>">
>
> becomes: czip between ''01'' and ''99999'' in the select statement(as seen
> in debug mode).
>
> Any suggestions?
>
> Chuck Lockwood
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> LockData Technologies, Inc.
> 309 Main Avenue, Hawley, Pa 18428
> 570-226-7340 ~ Fax: 570-226-7341
> [EMAIL PROTECTED] ~ www.lockdata.com
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
>
>
> ________________________________________________________________________
> TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
> with unsubscribe witango-talk in the message body
>
________________________________________________________________________
TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
with unsubscribe witango-talk in the message body
