Too few parameters. Expected 1

Forums

My Profile

Inbox

Address Book

My Subscription

My Forums

Too few parameters. Expected 1

Logged in as: Guest

arrSession:exec spGetSession 2,4,2938

	Active Users: There are 0 members and 0 guests.
	Users viewing this topic: none

Printable Version

All Forums >> [Scripting] >> ASP.NET >> Too few parameters. Expected 1
Do you like VisualBasicScript.com? Link to us and help spread the word about our forum. Thanks!

Page: [1]

Message

<< Older Topic Newer Topic >>

Too few parameters. Expected 1 - 5/10/2005 3:17:42 AM

jonathan52988

Posts: 34
Score: 0
Joined: 4/12/2005
From: USA
Status: offline

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