Hello,
I am trying to select a range of values from a table called Codes. The values are passed from two input boxes on a form.
I am sooooooooooooooo close but sooooooooooooooooooooooo far away. I know the problems is in the request.form() part of my code.
If I insert numbers in place of the request.form() it returns the correct data. Code is defined as a number in the database (Access 2000)

This is the formula for my logic
SELECT "column_name" FROM "table_name"WHERE "column_name" BETWEEN 'value1' AND 'value2'
************************************************** ***********

qry = "SELECT * FROM LA_Codes WHERE Code BETWEEN 10021 AND 10071 "
This works but I need the user to enter the data in a form to search for.
************************************************** *************

line 21
"SELECT * FROM LA_Codes "WHERE Code BETWEEN request.form("searchCode2") AND request.form("searchCode3")

Generates this error:
Microsoft VBScript compilation error '800a0401'
Expected end of statement
/remmdconnect.asp, line 21
qry = "SELECT * FROM LA_Codes "WHERE Code BETWEEN request.form("searchCode2") AND request.form("searchCode3")
-------------------------------^
************************************************** *****
dim code1=request.form("searchCode2")
dim code2=request.form("searchCode3")
line 21
qry = "SELECT * FROM LA_Codes WHERE Code BETWEEN code1 AND code2 "
line 22
Set oRS = oConn.Execute(qry)

Generates this error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e10'
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 2.
/remmdconnect.asp, line 22
************************************************** ******************
line21
qry = "SELECT * FROM LA_Codes WHERE Code BETWEEN 'code1' AND 'code2' "
line 22
Set oRS = oConn.Execute(qry)
Generates this error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e07'
[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.
/remmdconnect.asp, line 22
************************************************** *********
"SELECT * FROM LA_Codes WHERE Code BETWEEN & request.form('searchCode2') AND request.form('searchCode3') "
Generates this error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'Code BETWEEN & request.form('searchCode2') AND request.form('searchCode3')'.
/remmdconnect.asp, line 21
************************************************** ********

qry = "SELECT * FROM LA_Codes WHERE Code BETWEEN '" & code1 & "' AND '" & code2 & "'"
 Microsoft OLE DB Provider for ODBC Drivers error '80040e07'

[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.

/remmdconnect.asp, line 21
Can someone point me in the right direction.
thank you
dink

hi there...

You were so cloooose with this one!!! just take out the ' from your line...
something like:

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========

Thanks Gonzalo! It is so frustrating to be so close and yet so far away.
dink