Steve, Witango is probably "doubling" your explicit single quotes, defaulting to SQL encoding. Check to see for sure by turning on debugging, or putting the <@SQL> tag in your results html while you debug.
Replace the explicit quotation characters with the <@SQ> tag: >UPDATE VariableValues > SET Var_Value = <@SQ><@var local$VarValue><@SQ> > FROM VariableValues v1, Variables v2 > WHERE ((v1.SiteID = <@var local$Site[1,SiteID]>) > AND (v2.Var_Name = <@SQ><@var local$VarName><@SQ>) > AND (v1.Var_ID = v2.Var_ID)) Bill On Fri, 12 Dec 2003 16:05:51 -0600, Fogelson, Steve wrote: >Direct DBMS Action in R:Tango. VarValue is TEXT, SiteID is INTEGER, VarName >is TEXT, Var_ID is INTEGER. >UPDATE VariableValues > SET Var_Value = '<@var local$VarValue>' > FROM VariableValues v1, Variables v2 > WHERE ((v1.SiteID = <@var local$Site[1,SiteID]>) > AND (v2.Var_Name = '<@var local$VarName>') > AND (v1.Var_ID = v2.Var_ID))
