Problem Updating mySQL Record

Andrew Kluthe andrew at rjdfarm.com
Wed Feb 10 09:40:35 EST 2010


The ANDs were jacking my query up. Commas used instead makes it work just as
it should.


UPDATE tleasepayments SET LeasePaymentDollars=21337.0000 ,
CropSharePercent='0' , Notes='PUT SOME NOTES HERE' WHERE LeaseID='1214'

grr, COMMAS!!!!! You win this time...
-- 
View this message in context: http://n4.nabble.com/Problem-Updating-mySQL-Record-tp1475274p1475880.html
Sent from the Revolution - User mailing list archive at Nabble.com.



More information about the Use-livecode mailing list