Comparing two strings with wildcards (LIKE?)

[bgreenhouse]

Hi Everybody

This is driving me crazy because I know how to do it, but can't get it right. I want to check where the user came from, and am using request.servervariables("HTTP_REFERER&quot to see. I'm trying to build an if statement that compares it to where they "should have" come from, and then perform different actions based on their origin. The problem is, I don't want to hard code the whole URL in there in order to avoid problems when we switch between servers (development to production, etc...). So I'm trying to say something like

IF request.servervariables("HTTP_REFERER") LIKE filename.asp THEN

I know that LIKE is SQL, so I've tried wild cards (% and *), and can't get it to work. HELP!!!!!

Ben

 

[JohnYingling]

Maybe?
strReferer = Trim(request.servervariables("http_REFERER&quot)
if Len(strReferer) > 0 and _
0 < Instr(strReferer,strLikeFileName,1) THEN

http://www.VBCompare.com

Compare Code (Text)

http://www.VBSortGen.com

Generate Sort in VB or VBScript

 

[JohnYingling]

Change the Instr to add start of 1.
Maybe?
strReferer = Trim(request.servervariables(&quot;http_REFERER&quot)
' Case Insensitive Compare
if Len(strReferer) > 0 and _
0 < Instr(1,strReferer,strLikeFileName,1) THEN

http://www.VBCompare.com

Compare Code (Text)

http://www.VBSortGen.com

Generate Sort in VB or VBScript

 

[bgreenhouse]

Thanks John! That worked great!

Ben