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
Update SQL Problem
Try:
You had a double quote just before 'FROM' - maybe that was it?
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?
Smartfox's forum is my daily newspaper.
Return to “Server Side Extension Development”
Who is online
Users browsing this forum: No registered users and 15 guests