unlcosed quote near

[eNerGiZer0101]

Hi,
Error message : unclosed quote near for the line
Rs.Open sql, Conn

Here is my asp page:

<%
Dim ID
ID = Request.Form("ID")
if ID="" then
Response.Write "You did not select a name to delete!"
Else
Dim Conn
Dim Rs
Dim sql
Set Conn = Server.CreateObject("ADODB.Connection")
Set Rs = Server.CreateObject("ADODB.Recordset")
Conn.Open "DRIVER={MYSQL Connector/ODBC v5};SERVER=localhost;DATABASE=inse6120project;UID=root;PWD=root; OPTION=3; PORT=1433;"
sql= "Delete * FROM files WHERE file_number='" & ID
Rs.Open sql, Conn
Conn.Close
Set Conn = Nothing
Response.Write "Successfully Deleted"
End If
%>

Does anyone have an idea what the problem is ?

 

[eNerGiZer0101]

Resolved.

 

[gbaughma]

Let me take a guess....

sql = "DELETE FROM files WHERE file_number='" & ID & "'; "





Just my 2¢
-Cole's Law: Shredded cabbage

--Greg

http://parallel.tzo.com