Thanks for the feedback. I believe it is the apostrophe as if I update it with 1234 instead of the phrase with an apostrophe, it updates fine. There are many other variables as well that update fine that don't have an apostrophe.
Var_Value is a column not a table as the error indicates. Somehow with the apostrophe in there it thinks it is a table. Steve -----Original Message----- From: Ben Johansen [mailto:[EMAIL PROTECTED] Sent: Thursday, February 12, 2004 1:45 PM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: Apostrophe problem in DBMS statement Are you sure it is the apostrophe? The errors are NO ROW and Unknown TABLE Does a simple select statement using the where clause results with any rows? Ben Johansen - http://www.pcforge.com Authorized Witango & MDaemon Reseller Available for Witango Developement -----Original Message----- From: Fogelson, Steve [mailto:[EMAIL PROTECTED] Sent: Thursday, February 12, 2004 2:37 PM To: Witango User Group (E-mail) Subject: Witango-Talk: Apostrophe problem in DBMS statement 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 ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
