You can do the following <@ASSIGN noSQLEncoding true> DirectDBMS <@ASSIGN noSQLEncoding false>
then quote the information as if you were working directly with the database Ben Johansen - http://www.pcforge.com -Authorized WiTango Reseller http://www.pcforge.com/WitangoGoodies.htm -Authorized Alt-N Reseller http://www.pcforge.com/AltN.htm -----Original Message----- From: Fogelson, Steve [mailto:[EMAIL PROTECTED] Sent: Friday, August 08, 2003 11:18 PM To: Witango User Group (E-mail) Subject: Witango-Talk: I am having trouble with a DBMS When I put single quotes around <@currentdate>, the Where clause in my DBMS comes out with 2 singles quotes on either end of the <@currentdate>. If I remove the single quotes, I don't get any single quotes or double quotes. Both conditions give me an "Invalid TEXT error". <@assign local$Select "( (o1.C_ID=<@var domain$CompanyID>) and (o1.Ord_OrderNumber='<@currentdate format="%Y%m%d">') ) "> DBMS Where <@var local$Select> With single quotes, Gives (o1.Ord_OrderNumber=''20030809'') Without single quotes, Gives (o1.Ord_OrderNumber=20030809) Any suggestions? Thanks Steve Fogelson Internet Commerce Solutions ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
