SQL Help required

by "Ken Richardson" <krichardson(at)escape.ca>

Date:	Tue, 14 Mar 2000 17:03:06 -0600
To:	"HWG Languages" <hwg-languages(at)hwg.org>
	todo: View Thread, Original

I can't seem to figure out what is wrong with this.

<%
Set datacon = Server.CreateObject("ADODB.Connection")
datacon.Open "Password"

sql ="Select empID, empPW FROM EmpPasswords"&_
" WHERE empID =" & Request.Form("id")

 Set RecordSet = datacon.Execute(sql)
%>

Produces the following error message

Microsoft OLE DB Provider for ODBC Drivers error '80040e10'

[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.

/ASP/testASP/Ex5_1_verify.asp, line 17

I know that id is coming in from the form on the preceding page as I have
been able to access it to print on the page.

Any suggestions.
TIA
Ken

HWG: hwg-languages mailing list archives, maintained by Webmasters @ IWA