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] To: 'asp52' [EMAIL

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 !- #include file=C:\PROGRAM FILES\COMMON FILES\SYSTEM\ADO\adovbs.inc - % dim email,objrs,strsql,strconn email=Request.Form (email) strconn = DSN=ebyte strsql=select * from log