Problem Updating mySQL Record

Andrew Kluthe andrew at
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:
Sent from the Revolution - User mailing list archive at

More information about the Use-livecode mailing list