Syntax Error, Cant Find It

[catalystunderx]

sqlString = "INSERT INTO Products ( ProductName, ProductCode, UnitPrice, Desc, Download, Weight, DownloadLink, UnitsInStock, ProductCategory, ImageFront, ImageBack, ImageZoom ) VALUES ( " &_
" '" & ProductName & "', " &_
" '" & ProductCode & "', " &_
UnitPrice & ", " &_
" '" & Desc & "', " &_
" '" & Download & "', " &_
Weight & ", " &_
" '" & DownloadLink & "', " &_
UnitsInStock & ", " &_
" '" & ProductCategory & "', " &_
" '" & ImageFront & "', " &_
" '" & ImageBack & "', " &_
" '" & ImageZoom & "'"" )

 

[dragonwell]

Have you tried a VB forum? This would be a lot easier if you used a parmeterized query.

 

[catalystunderx]

I havn't no, I'll try that as well

Thanks

 

[tektipdjango]

I highlighted the missing chars :

sqlString = "INSERT INTO Products ( ProductName, ProductCode, UnitPrice, Desc, Download, Weight, DownloadLink, UnitsInStock, ProductCategory, ImageFront, ImageBack, ImageZoom ) VALUES ( " &_
" '" & ProductName & "', " &_
" '" & ProductCode & "', " &_
UnitPrice & ", " &_
" '" & Desc & "', " &_
" '" & Download & "', " &_
Weight & ", " &_
" '" & DownloadLink & "', " &_
UnitsInStock & ", " &_
" '" & ProductCategory & "', " &_
" '" & ImageFront & "', " &_
" '" & ImageBack & "', " &_
" '" & ImageZoom & "'"[highlight] &_[/highlight]
" )"

[highlight]Django[/highlight]
bug exterminator
tips'n tricks addict