Snitz Forums 2000

Snitz Forums 2000

All Forums

Community Forums

Code Support: ASP (Non-Forum Related)

InStr and non-case sensitive

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!
Before posting, make sure you have read this topic!

Screensize:

UserName:

Password:

Format Mode:

Format:

Message:

* HTML is OFF
* Forum Code is ON

Smilies

Check here to include your profile signature.

T O P I C R E V I E W
bobby131313	Posted - 11 September 2009 : 21:25:34 I need to find any instance of Yandex regardless of case in "AffAgent" which is the user agent. Did some Googling and came up with the following but I don't think it's working. Dim AffAgent : AffAgent = Request.ServerVariables("HTTP_USER_AGENT") If InStr(1, AffAgent, "Yandex", VBTextCompare) > 0 Then Do something End If Does it look like it should or did I google some bum info?
8 L A T E S T R E P L I E S (Newest First)
bobby131313	Posted - 15 September 2009 : 13:07:39 Thanks everyone. It appears my code is working. The clicks were due to IE5 downloading for "off-line" viewing. Got that addressed now after trudging through the logs.
AnonJr	Posted - 15 September 2009 : 11:39:37 quote: Originally posted by Carefree An alternate approach is to do a forced lower-case comparison like this: if inStr(lcase(AffAgent),"yandex") then Using vbTextCompare makes it a case-insensitive comparison... If you don't have some test data that has known positives and known negatives, it doesn't matter what you try as you will never know if its working.
Carefree	Posted - 15 September 2009 : 01:59:23 An alternate approach is to do a forced lower-case comparison like this: if inStr(lcase(AffAgent),"yandex") then
AnonJr	Posted - 14 September 2009 : 15:42:36 quote: Originally posted by Doug G You can control whether instr does a case-sensitive comparison or not Looks like he already is since he's using vbTextCompare...
Doug G	Posted - 13 September 2009 : 23:49:34 quote: Originally posted by Doug G You can control whether instr does a case-sensitive comparison or not http://msdn.microsoft.com/en-us/library/wybb344c(VS.85).aspx EDIT: Hmm, snitz here doesn't seem to like the above URL, textually it's http://msdn.microsoft.com/en-us/library/wybb344c(VS.85).aspx copied from my firefox address bar while viewing the page. EDIT2: Sheesh! Even inside CODE tags the url tries to become a broken link.
Doug G	Posted - 13 September 2009 : 23:48:43 You can control whether instr does a case-sensitive comparison or not http://msdn.microsoft.com/en-us/library/wybb344c VS.85 .aspx
bobby131313	Posted - 11 September 2009 : 23:16:09 quote: are you sure its not working? No, not positive. Just figured I'd check that first. This code is to intercept ignorant bots that follow affiliate links and send them through a non-affiliate link so my stats don't get skewed. One of my sites that usually get about 400 clicks a day to this particular affiliate is now at over 1,100 for today with about 4 hours left. Guess I'll be going through some log files tomorrow. I may just have a new ignorant bot on my hands. Thanks for your help!
AnonJr	Posted - 11 September 2009 : 22:49:32 It looks like it should... are you sure its not working? I ask only because I spent an hour today troubleshooting "missing" records that were missing because I mis-typed the date range... As a side note, I tend to use <> 0 instead of > 0 - not that it should matter.

Snitz Forums 2000

This page was generated in 0.32 seconds.