Window 2003 Web Edition, R:Tango 5.0 I am having trouble with the following DBMS action:
update VariableValues SET Var_Value = <@sq><@var request$VarValue encoding=sql><@sq> from VariableValues v1, Variables v2 where ((v1.SiteID = <@var request$Site[1,SiteID]>) and (v2.Var_Name = <@sq><@var request$VarName><@sq>) and (v1.Var_ID = v2.Var_ID)) The DBMS action is preceded by <@assign noSQLEncoding true> and followed by <@assign noSQLEncoding false> I get the following info with debug: [Query] [517] update VariableValues SET Var_Value = 'Up North Sports carries a large selection of snowmobile products and accessories. Let Up North Sports earn your business and you won''t be disappointed.' from VariableValues v1, Variables v2 where ((v1.SiteID = 1) and (v2.Var_Name = 'DefPgDesc') and (v1.Var_ID = v2.Var_ID)) [Error] [518] 2059 [RBTI][Oterro ODBC Driver][CatSite]-WARNING- No rows exist or satisfy the specified clause. (2059) HY000 [Error] [519] 2038 [RBTI][Oterro ODBC Driver][CatSite]-ERROR- Var_Value is an undefined table. (2038) 42S02 [Error] [519] -101 General error during data source operation. [Error] [519] -101 General error during data source operation. It updates other variables just fine and will update this if I take the apostrophe out of won't Thanks Steve Fogelson Internet Commerce Solutions ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
