Hello,

I am a newbie in ASP, I am trying to list a specific record and update it from the db table. But I keep getting this error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '='.
student_edit.asp, line 105
Thanks for your help.

Here is my code:

<%
function fixStr( theString )
    fixStr = replace( theString, "'", "''")
end function

Set oConn = Server.CreateObject("ADODB.Connection")
oConn.Open strConnect
%>

<%
sqlString = "select * from jenny where ID =" & ID
Student name: <input type="text" name="name" value="<%=Student_name%>"><br />
Country: <input type="text" name="country" value="<%=country%>"><br />
Phone: <input type="text" name="phone" value="<%=phone%>"><br />
Email: <input type="text" name="email" value="<%=email%>"><br />

<%
sqlString = "update jenny set " &_
    "Student name ='" & fixStr( Student_name ) & "', " &_
    "Country ='" & fixStr( Country ) & "', " &_
    "Phone ='" & fixStr( Phone ) & "', " &_
    "Email ='" & fixStr( Email ) & "' where ID =" & ID

    dbCon.Execute sqlString
%>

http://www.asiafuns.com/asian_friends/

__________________
---------------------
There is NO stupid question.

Syntactally speaking, your SQL code statement looks fine, however it is relying on variables for its values so it is possible that a ' is being passed into your sql statement which is causing it to fail.

Do a response.write sqlString and see what the literal value is. That should give you an idea as to where the problem is coming from.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========

thanks.

http://www.asiafuns.com/asian_friends/