Hi there

Can anyone see what is wrong with this?

I keep getting a syntax error....

strSQL = "INSERT INTO Vehicles (CategoryID, Header, Detail, Price, VAT, DateAdded, Thumb1, Thumb2, Thumb3, Thumb4, Thumb5, Thumb6, Deleted) VALUES('" & request(strCat) "', '" & request(strHeader) "', '" & request(strDetail) "', '" & request(intPrice) "', 0, '" & request(strDateA) "', '" & request(strImage) "', '" & request(strImage2) "', '" & request(strImage3) "', '" & request(strImage4) "', '" & request(strImage5) "', '" & request(strImage6) "', 0) where CategoryID = '" & request("Cats") & "'"


any help greatly appreciated.

Cheers

Adam

You have quite a few &'s missing, e.g. after HTH,

Chris

thanks Chris, that's great - a bit of an oversight!