CodingForums.com - View Single Post - Arguments are of the wrong type, are out of acceptable range, or are in conflict with

Old Pedant · 09-26-2012, 09:45 PM

Oh, heck. I can't stand it.

Code:

<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<%
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "DRIVER={MySQL}; SERVER=#####; DATABASE=temple; User=#####;PASSWORD=#####; OPTION=3;"

id = 0
On Error Resume Next
   id = CLNG( Request("id") )
On Error GoTo 0

SQL = "SELECT * FROM orders WHERE orderid = " & id
Set Recordset1 = conn.Execute( SQL )
If Recordset1.EOF Then
     conn.Close
     Response.Write "Invalid id passed from previous page."
     Response.End
End If

... now work with the recordset ...
%>