missing semicolon!

[Forecaster71]

I get an error that I cannot solve. As far as I know it should not be there

this is the row:

Set rsUser = objConnection.Execute(SQLQuery)

should there be a semicolon and if so where?

 

[Golom]

What does "SQLQuery" contain?

The VB statement doesn't need a semicolon but the SQL might.

 

[Forecaster71]

The SQL query contains:
QLQuery = "INSERT INTO users(userAbout) VALUES ('"&info&"') WHERE userID = "&Request.Cookies("Database")("userID")&

 

[r937]

you cannot use WHERE with VALUES

are you sure you want INSERT and not UPDATE instead?

r937.com | rudy.ca

 

[Forecaster71]

What should I do if I where to use UPDATE instead?
I haven't used that mutch...

 

[r937]

QLQuery = "UPDATE users SET userAbout = '"&info&"' WHERE userID = "&Request.Cookies("Database")("userID")&""

r937.com | rudy.ca

 

[Forecaster71]

Thankyou ^^ Now it works.