Hi! I had that problem too. What I did is created a DBMS query and store it in variable i.e. @@SQL3 then in DBMS window I put <@VAR SQL3 encoding="none"> and it solved the problem.
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Chuck Lockwood Sent: Wednesday, August 28, 2002 1:10 PM To: Multiple recipients of list witango-talk 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
