 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussion GroupsGeneralPHPASPPerlColdFusionFlashHTML, CSS, ScriptsBrowsers |
Webmaster Forum / ASP / Database Access / October 2006access not case sensitive?
i have an asp page with a form that takes an email address and writes it to an access DB. if i enter someone@somewhere.com and on a different page SELECT email addresses that equal SOMEONE@SOMEWHERE.COM, my results are returned. i was expecting this query to not return anything because the case is different. can anyone shed some light here? > i have an asp page with a form that takes an email address and writes > it to an access DB. if i enter someone@somewhere.com and on a > different page SELECT email addresses that equal > SOMEONE@SOMEWHERE.COM, my results are returned. i was expecting this > query to not return anything because the case is different. can > anyone shed some light here? JetSQL is not case-sensitive. You can do case-sensitive searches by using the VBA strComp() function (I think this is one of the allowed functions ...), but why would you in this instance? Email addresses aren't case-sensitive either, are they?  SignatureMicrosoft MVP -- ASP/ASP.NET Please reply to the newsgroup. The email account listed in my From header is my spam trap, so I don't check it very often. You will get a quicker response by posting to the newsgroup. >> i have an asp page with a form that takes an email address and writes >> it to an access DB. if i enter someone@somewhere.com and on a [quoted text clipped - 7 lines] > functions ...), but why would you in this instance? Email addresses > aren't case-sensitive either, are they? no no ... i was just thinking that if someone enters a lowercase email address, and i later search for that email address but type in caps, i need to make sure ill always find the match. so should i do a UCase() either before writing it to the db or perhaps a UCase() before i search? or should i leave it alone becasue Access wont care either way? >>> i have an asp page with a form that takes an email address and writes >>> it to an access DB. if i enter someone@somewhere.com and on a [quoted text clipped - 13 lines] > either before writing it to the db or perhaps a UCase() before i search? > or should i leave it alone becasue Access wont care either way? >>> i have an asp page with a form that takes an email address and >>> writes it to an access DB. if i enter someone@somewhere.com and on a [quoted text clipped - 14 lines] > before i search? or should i leave it alone becasue Access wont care > either way? Just leave it alone because Access won't care either way. SignatureMicrosoft MVP -- ASP/ASP.NET Please reply to the newsgroup. The email account listed in my From header is my spam trap, so I don't check it very often. You will get a quicker response by posting to the newsgroup. >>> i have an asp page with a form that takes an email address and writes >>> it to an access DB. if i enter someone@somewhere.com and on a [quoted text clipped - 13 lines] > either before writing it to the db or perhaps a UCase() before i search? > or should i leave it alone becasue Access wont care either way? Why would you search with Caps Lock on? Why would you consider defiling your data to make it all upper case, rather than turn caps lock off? And since <quote> JetSQL is not case-sensitive</quote> haven't you answered your own question? -- Mike Brind where do they grow this guy? he must be God with that attitude >>>> i have an asp page with a form that takes an email address and writes >>>> it to an access DB. if i enter someone@somewhere.com and on a [quoted text clipped - 21 lines] > -- > Mike Brind You read an attitude that wasn't intended. I had my tongue in my cheek, but forgot to put a suitable emoticon in. SignatureMike Brind > where do they grow this guy? > he must be God with that attitude [quoted text clipped - 24 lines] >> -- >> Mike Brind aahhh... yes, someone needs to invent a way to show facial expression and body language in email and ng posts > You read an attitude that wasn't intended. I had my tongue in my cheek, > but forgot to put a suitable emoticon in. [quoted text clipped - 27 lines] >>> -- >>> Mike Brind |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.