Lloyd Logan Posted January 17, 2014 Share Posted January 17, 2014 Why doesn't this work, it tells me I am returning a string value? serial = getPlayerSerial(source) x, y, z = getElementPosition(newveh) a, b, c = getElementPosition(source) dbQuery ( server, "INSERT INTO accounts (x, y, z, cx, cy, cz) VALUES (?, ?, ?, ?, ?, ?)", tostring (a), tostring (b), tostring (c), tostring (x), tostring (y), tostring (z)" WHERE serial = '".. serial .."'")--THIS BIT HERE! Link to comment
Castillo Posted January 17, 2014 Share Posted January 17, 2014 That doesn't make any sense, why do you even use "WHERE" in a insert query? serial = getPlayerSerial(source) x, y, z = getElementPosition(newveh) a, b, c = getElementPosition(source) dbExec ( server, "INSERT INTO accounts (serial, x, y, z, cx, cy, cz) VALUES (?, ?, ?, ?, ?, ?, ?)", serial, tostring (a), tostring (b), tostring (c), tostring (x), tostring (y), tostring (z) ) Link to comment
Lloyd Logan Posted January 17, 2014 Author Share Posted January 17, 2014 That doesn't make any sense, why do you even use "WHERE" in a insert query? serial = getPlayerSerial(source) x, y, z = getElementPosition(newveh) a, b, c = getElementPosition(source) dbExec ( server, "INSERT INTO accounts (serial, x, y, z, cx, cy, cz) VALUES (?, ?, ?, ?, ?, ?, ?)", serial, tostring (a), tostring (b), tostring (c), tostring (x), tostring (y), tostring (z) ) Infact, what the hell am I thinking, disregard this! Link to comment
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now