Hi all,

Building an e-shop around a CSV database this month. Only trouble is that the database, being a text file, is case-sensitive, so it's screwing up my search function.

Is there a way I can make the filtering line

WHERE Author LIKE '%varAuthor%' AND Title LIKE '%varTitle%'

compare both fields (eg Author and varAuthor) as lower case? I've seen a solution for Oracle that does this, but i can't find one for this...

Cheers! Kit

PS. oh, one more question: can anyone tell me how to redirect if the search yields no results? thanks!



Edited by - kit.allen on 04 Sep 2002 16:46:19

I can help with the redirect:

<% If yourRecordsetName.EOF And yourRecordsetName.BOF Then %>
<%Response.Redirect("your_page_name.asp) %>
<% End If %>

Regards
Vince

Response.write("The best line of code you can ever use"

VBScript | ASP | HTML | SQL | Oracle | Hosting