Update SQL Problem

[lastowl]

Im trying to add the userID to the db on each login so i came up with:

Code:
Enabled = res.userId
var dbID = row.getItem("Enabled");
dbase.executeCommand("UPDATE dbID='" + Enabled + "'" FROM login WHERE Username='" + nick + "'" );


It looks wrong to me, but something similar worked in a different sql environment i use but it also comes up with no error and doesn't work in unity.
I tried quite a few variations this is where my ideas ended, Its most likely badly wrote SQL but its after working a long stretch and i would appreciate someone pointing out my stupidity

[BigFIsh]

Try:

Code: Select all

dbase.executeCommand("UPDATE dbID='" + Enabled + "' FROM login WHERE Username='" + nick + "'" );

You had a double quote just before 'FROM' - maybe that was it?

[lastowl]

thanks ill try that,

Edit that hasn't fixed everything but I'm having a complete re-look at everything first