iRev mySQL and a Revdberr?

[John Patten]

Ah! Thanks Dave! They are. I'll make the change and see if that helps.

John Patten
SUSD

Sent from my iPad

On Jul 29, 2011, at 5:40 PM, Dave Cragg <dave.cragg at lacscentre.co.uk> wrote:

> 
> On 30 Jul 2011, at 00:28, John Patten wrote:
> 
>> Hi All!
>> 
>> I have a basic insert mysql query in an irev file. It manages to insert the new record but it returns a revdberr too.
>> 
>> The table consists of 5 fields with the last field auto-updated incrementally.
>> 
>> put "INSERT INTO opentrades (sendtoid, traderid, traderitem, tradeeitem) VALUES (" & "'" & tTradeeID & "'" &  "," &  "'" & tPlayerID & "'" & "," & "'" & tMyItem & "'" &  "," &  "'" &  tTheirItem & "'"  & ")"   into tSQL
> 
> Just a guess, but are the fields "sendtoid" and "traderid" integer fields. If so, the values shouldn't be quoted.
> 
> Dave
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode