Witango-Talk: SQL (OT)

[Fogelson, Steve]

Worked in R:Base, moving this last DB to MySQL. I think I need a SELECT in
here.



R:Base



UPDATE VariableValues

SET Var_Value = '1'

FROM VariableValues v1, Variables v2

WHERE

 ((v1.SiteID = 69) and

 (v2.Var_Name = 'AllowCoupons') and

 (v1.Var_ID = v2.Var_ID))



This seems to work. But I would like to make sure



MySQL



UPDATE `mycatsites`.`variablevalues` v1

SET Var_Value = '1'

WHERE (v1.SiteID = 69) AND

(SELECT Var_ID

FROM  `mycatsites`.`variables` v2

WHERE (v2.Var_Name = 'AllowCoupons') and (v1.Var_ID = v2.Var_ID))



Thanks



Steve Fogelson

Internet Commerce Solutions



----------------------------------------

To unsubscribe from this list, please send an email to lists...@witango.com 
with "unsubscribe witango-talk" in the body.