Hello All,

I used the tutorial for the Search Page and being new to it all it help alot. I have the Keyword search working but when I select the drop downs I get the following error...

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E07)
[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.
/results.asp, line 160

I am not sure what I am missing. Can anyone please help?
I have put the ASP code in a text format at

Search Page
www.rebelshockey.com/asphelp/search.txt
Results Page
www.rebelshockey.com/asphelp/results.txt

If anyone can shead some light on my lack of knowledge. THANKS!
~Broberts

I also get this error on all the drop downs but the one calling to the CM Number ...

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'ID <>-1 AND Request_Type = Hardware Request'.
/results.asp, line 160

LOL! I figured out what it was after a few hours looking at the code since I posted it.

Example of what I had...

AndTypeString = " AND Request_Type = " & sType

This is what it should have looked like...
AndTypeString = " AND Request_Type = '%" & sType "%'"

Once I made these changes it works 100% now.

Again Thanks for the TUTORIAL that help me get this far in the first place!

~Broberts