Case sensitivity

2002-12-19 Thread asp52
Hi, I have been searching tables based on search values which turn up tobe fine, however the results dont reflect case sensitivity. what i mean, if i run following query select field1 from table1 where name='text1'; this works fine but returns the same result set with text1 values of 'USER' or

Re: Case sensitivity

2002-12-19 Thread asp52
Thanks, Just worked it out with binary statement in my query. all fine. Would it be wise to use binary type table? didnt try that as i wanted a flexible table of type varchar to perserve space. what would be its impact? cheers. Adamji From: "Mike Grabski" <[EMAIL PROTECTED]

ASP/MYSQL

2002-11-04 Thread asp52
Hello members, I'm new to mysql and need to conect to from ASP pages. I have written the following code in ASP script <% dim email,objrs,strsql,strconn email=Request.Form ("email") strconn = "DSN=ebyte" strsql="select * from log where email=('" & email & "');" set objrs=server.CreateObject (