Sign in to follow this  
Lloyd Logan

String value

Recommended Posts

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!  

Share this post


Link to post

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) ) 

Share this post


Link to post
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!

Share this post


Link to post

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Recently Browsing   0 members

    No registered users viewing this page.