/John
Fogelson, Steve wrote:
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
________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
