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 & "'"" )

 

[BlackDice]

It doesn't look as if there's any space between your ampersand and your line continuation character at the end of your lines; there has to be. Change this: (&_) to this:
(& _) and it should work fine

bdiamond

 

[MarkSweetland]

...and remove the extra double quotes at the end...

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 & "'[red]""[/red] )"



Mark

"You guys pair up in groups of three, then line up in a circle."
- Bill Peterson, a Florida State football coach

 

[catalystunderx]

thanks for the help so far but no joy!! this ones been frustrating me for a few hours now : (

 

[vidru]

The could be that DESC is a reserved word in whatever database you're using. Try this:

sqlString = "INSERT INTO Products ( ProductName, ProductCode, UnitPrice, [Desc], Download, Weight, DownloadLink, UnitsInStock, ProductCategory, ImageFront, ImageBack, ImageZoom )

-dave

 

[catalystunderx]

you got it mate, thanks so much