www.adopenstatic.com/faq/80040e10.asp

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: <m_sra@y...>
Subject: [access_asp] No value given for one or more required parameters


: Hi,
: This is the first time I'm posting to any group ever so please excuse me
: if I miss out on any courtesy protocols. I have an access database and I'm
: creating a search form that leads to a result page in Ultradev. My search
: form has a textfield and 2 drop down lists. When I enter a keyword to
: search and hit submit I get the following error:
:
: Microsoft JET Database Engine (0x80040E10)
: No value given for one or more required parameters.
: /testSite/resultsearlier.asp, line 100
:
: Line 100 in the code is:
: <%
: set rsQryDisplayFields = Server.CreateObject("ADODB.Recordset")
: rsQryDisplayFields.ActiveConnection = MM_demoOLE_STRING
: rsQryDisplayFields.Source = "SELECT nameID, taxonName,
: commonName, seasonName, countyName FROM QryDisplayFields " & sqlString
: rsQryDisplayFields.CursorType = 0
: rsQryDisplayFields.CursorLocation = 2
: rsQryDisplayFields.LockType = 4
: Line 100:rsQryDisplayFields.Open()
: rsQryDisplayFields_numRows = 0
:
: I read up and searched other newsgroups and all seem to say that I have a
: syntax error in my sql or my field names do not match. I have checked all
: that time and again. My sql works inside of access and also through
: Ultradev. I am totally stumped. Being a beginner in ASP I would appreciate
: any help in solving my problem.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Misha,
As pointed out in Ken's FAQ, I wondered what your "sqlString" containing
your WHERE clause was...perhaps there is a problem with this?
All for now.
Dean

-----Original Message-----
From: m_sra@y... [mailto:m_sra@y...]
Sent: Friday, May 31, 2002 2:37 PM
To: Access ASP
Subject: [access_asp] No value given for one or more required parameters


Hi,
This is the first time I'm posting to any group ever so please excuse me 
if I miss out on any courtesy protocols. I have an access database and I'm 
creating a search form that leads to a result page in Ultradev. My search 
form has a textfield and 2 drop down lists. When I enter a keyword to 
search and hit submit I get the following error:

Microsoft JET Database Engine (0x80040E10)
No value given for one or more required parameters.
/testSite/resultsearlier.asp, line 100

Line 100 in the code is:
<%
	 set rsQryDisplayFields = Server.CreateObject("ADODB.Recordset") 
	 rsQryDisplayFields.ActiveConnection = MM_demoOLE_STRING
	 rsQryDisplayFields.Source = "SELECT nameID, taxonName, 
commonName, seasonName, countyName FROM QryDisplayFields " & sqlString
	 rsQryDisplayFields.CursorType = 0
	 rsQryDisplayFields.CursorLocation = 2
	 rsQryDisplayFields.LockType = 4
Line 100:rsQryDisplayFields.Open()
	 rsQryDisplayFields_numRows = 0

I read up and searched other newsgroups and all seem to say that I have a 
syntax error in my sql or my field names do not match. I have checked all 
that time and again. My sql works inside of access and also through 
Ultradev. I am totally stumped. Being a beginner in ASP I would appreciate 
any help in solving my problem.

I can post more code if needed!

Thank you for your time.
Misha