query AND/OR for textboxes

gilgalbiblewheel · February 4th, 2005, 08:18 PM

I have 6 textboxes where if I fill them up I want the query to search if either one of them has results found. I have this but it's not working:

Code:

  SQL = "SELECT * FROM bible WHERE "
  SQL = SQL & "text_data LIKE '%" & Keyword & "%' OR "  
  SQL = SQL & "text_data LIKE '%" & Keywordb & "%' OR "
  SQL = SQL & "text_data LIKE '%" & Keywordc & "%' OR "  
  SQL = SQL & "text_data LIKE '%" & Keywordd & "%' OR "
  SQL = SQL & "text_data LIKE '%" & Keyworde & "%' OR "  
  SQL = SQL & "text_data LIKE '%" & Keywordf & "%' AND "
  SQL = SQL & "book_spoke = '" & spoke_number & "'"

iCounter = iCounter + 1

(I would like to know the use of the iCounter since I use it from other examples but don't know why it's there.)

I've tried this too but this gives every record within
"book_spoke = '" & spoke_number & "'"

Code:

  SQL = "SELECT * FROM bible WHERE "
  SQL = SQL & "book_spoke = '" & spoke_number & "'"
  SQL = SQL & " AND ("
  SQL = SQL & "text_data LIKE '%" & Keyword & "%' OR "  
  SQL = SQL & "text_data LIKE '%" & Keywordb & "%' OR "
  SQL = SQL & "text_data LIKE '%" & Keywordc & "%' OR "  
  SQL = SQL & "text_data LIKE '%" & Keywordd & "%' OR "
  SQL = SQL & "text_data LIKE '%" & Keyworde & "%' OR "  
  SQL = SQL & "text_data LIKE '%" & Keywordf & "%'"
  SQL = SQL & " )"

Learning of our true origins.

I feel sorry:

http://www.infowars.com/articles/wor...eknowledge.htm

Foreknowledge of A Natural Disaster
Washington was aware that a deadly Tidal Wave was building up in the Indian Ocean

om_prakash · February 4th, 2005, 09:10 PM

This will work in most of the cases for "book_spoke = '" & spoke_number & "'" because if any of the keyword is blank then u will get all records for book_spoke, for specific id.

SQL = "SELECT * FROM bible WHERE "
  SQL = SQL & "book_spoke = '" & spoke_number & "'"
  SQL = SQL & " AND ("
  SQL = SQL & "text_data LIKE '%" & Keyword & "%' OR "
  SQL = SQL & "text_data LIKE '%" & Keywordb & "%' OR "
  SQL = SQL & "text_data LIKE '%" & Keywordc & "%' OR "
  SQL = SQL & "text_data LIKE '%" & Keywordd & "%' OR "
  SQL = SQL & "text_data LIKE '%" & Keyworde & "%' OR "
  SQL = SQL & "text_data LIKE '%" & Keywordf & "%'"
  SQL = SQL & " )"

Before creating SQL string, check if there is any data in "Keyword". if there is data, then only add in the SQL query..

Hope this helps

Om Prakash