I am getting ODBC MS Access Driver Error
"Too few parameters. Expected 1"
I am trying to select records matching search criteria.

Here is SQL:
SELECT login_name, mem_date, city, tblAge.Age, gender_name
FROM member_info, tblAge, tblCountry, tblGender, tblState
WHERE tblAge.AgeID = member_info.age AND member_info.age > varAgemin AND member_info.age < varAgemax AND member_info.country = tblCountry.country AND member_info.gender = tblGender.gender AND member_info.gender = varGender AND member_info.state = tblState.state AND member_info.city LIKE varCity

Everything works fine until I add last line -
"member_info.city LIKE varCity"

varCity is a string:
default value: Moscow
run-time value: Request("txtCity"

I tried putting all sorts of quotation marks around default value and nothing works.

This brings the second question: How to make default value equal to empty string or anything - it would not take " " or * or "*"???!!!

did you try putting single quotes around the variable:

LIKE 'varCity'

then that way, if it's empty, it will see '' instead of ... nothing, th us causing a syntax error.

Joel Martinez [ ]
----------
E-Commerce Concepts with Ultradev...pre-order yours at
www.basic-ultradev.com/ecomm_concepts/

Yes, single quotes worked! What was I thinking???

Thanks again, Joel

Valentina