verify my query statement

gilgalbiblewheel · July 1st, 2005, 09:06 PM

What's wrong with this?

Code:

SELECT * FROM biblewheel_url INNER JOIN bible ON biblewheel_url.letter_id = bible.book_spoke WHERE ( text_data like '%number%' OR text_data like '%day%' OR text_data like '%forty%' OR text_data like '%year%' ) AND bible.book_spoke = '4' 
Microsoft OLE DB Provider for ODBC Drivers error '80040e07' 

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

/wheelofgod/kjvresp.asp, line 34

Martial Law 9/11 Rise of the Police State is now available! Visit our Martial Law movie section for complete info (click here), or order now by clicking the button below or by calling 888-253-3139
http://www.infowars.com/martial_law_911.htm

happygv · July 6th, 2005, 04:27 PM

What datatype is bible.book_spoke? If that is numeric, then remove the single quotes around it.

_________________________
- Vijay G
Strive for Perfection

gilgalbiblewheel · July 7th, 2005, 01:39 PM

Ok thanks. It works now.

Martial Law 9/11 Rise of the Police State is now available! Visit our Martial Law movie section for complete info (click here), or order now by clicking the button below or by calling 888-253-3139
http://www.infowars.com/martial_law_911.htm