in the dbms make sure your arg looks like this:
<@arg zips encoding=sql>
that should do the trick
-Atrix
----- Original Message -----
From: "Chuck Lockwood" <[EMAIL PROTECTED]>
To: "Multiple recipients of list witango-talk" <[EMAIL PROTECTED]>
Sent: Wednesday, August 28, 2002 10:09 AM
Subject: Witango-Talk: and I quote, quote, quote ...
> 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
