Too few parameters. Expected 1

Author Message
jonathan52988

  • Total Posts : 34
  • Scores: 0
  • Reward points : 0
  • Joined: 4/12/2005
  • Location: USA
  • Status: offline
Too few parameters. Expected 1 Tuesday, May 10, 2005 4:17 AM (permalink)
0
I am new to ASP and i am having an error can someone help me find it
Error
Too few parameters. Expected 1

My code:
html>
<head>
<title> Delete </title>
</head>
<body bgcolor = "white" text = "black">
<%
Dim adoCon
Dim rsDeleteEntry
Dim strSQL
Dim IngRecordNo

lngRecordNo = CLng(Request.QueryString("ID"))
Set adoCon = Server.CreateObject("ADODB.Connection")
adoCon.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("/jon52988/db/guestbook.mdb")
Set rsDeleteEntry = Server.CreateObject("ADODB.RecordSet")
strSQL = "SELECT * FROM tblComments WHERE ID_no=" & "IngRecordNo"
rsDeleteEntry.LockType = 3
rsDeleteEntry.Open StrSQL, adoCon
rsDeleteEntry.Delete
rsDeleteEntry.Close
Set rsDeleteEntry = Nothing
Set adoCon = Nothing
Response.Redirect "/jon52988/guestbook/delete_select.asp"
%>
</body>
</html>
New To ASP
 
#1

    Online Bookmarks Sharing: Share/Bookmark

    Jump to:

    Current active users

    There are 0 members and 1 guests.

    Icon Legend and Permission

    • New Messages
    • No New Messages
    • Hot Topic w/ New Messages
    • Hot Topic w/o New Messages
    • Locked w/ New Messages
    • Locked w/o New Messages
    • Read Message
    • Post New Thread
    • Reply to message
    • Post New Poll
    • Submit Vote
    • Post reward post
    • Delete my own posts
    • Delete my own threads
    • Rate post

    2000-2012 ASPPlayground.NET Forum Version 3.9