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
