SQL help

date posted 13th April 2001 12:01

Hi all,

Pretty new to SQL and i am having a problem

I keep getting this error:


" Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC Microsoft Access Driver] Syntax error in string in query
expression ''trete WHERE customer_id=10'.

/clear_solution/manageprogress.asp, line 111 "

Around line 111 there is this code:

IF updateprogress "" THEN

sqlString = "UPDATE Progress SET " &_
"customer_name='" & fixQuotes( companyname ) & "'," &_
"customer_eta='" & fixQuotes( customereta ) & "'," &_
"customer_progress='" & fixQuotes( progressreport ) & "'," &_
"product_jobname='" & fixQuotes( jobtitle ) & " WHERE " &_
"customer_id=" & customerid

Con.Execute sqlString
%> 's Progress report on has been updated in
the database.


Any help would be very much appreciated,
Cheers,
Ry.