Microsoft OLE DB error '80040e14'
I'm receiving Microsoft OLE DB error '80040e14'
that states:
Line 1: Incorrect syntax near ';'.
at Line 41 (which begins with the rsOpen statement)
The code is:
<%
aspUser=Request.ServerVariables("AUTH_USER")
aspID=Request.QueryString("ID")
Set conn = Server.CreateObject("ADODB.Connection")
strConnString="Provider=sqloledb;Data Source=devsql;Initial Catalog=CSOSAPhone;User ID=sa"
conn.open strConnString
Set rs = Server.CreateObject("ADODB.Recordset")
sql="SELECT * FROM Phone WHERE ID=" & aspID & ";"
rs.Open sql, conn, 3, 3
%>
<form method="POST" action="c:\inetpub\company\Phone\processChange.asp " name="form">
Can someone help me figure out what is wrong?
|
