General Discussion - comparing strings

Print Page | Close Window

comparing strings

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: General Discussion
Forum Description: General discussion and chat on any topic.
URL: https://forums.webwiz.net/forum_posts.asp?TID=4743
Printed Date: 29 March 2026 at 5:01pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: comparing strings

Posted By: CyberBless
Subject: comparing strings
Date Posted: 04 August 2003 at 8:51pm

I'm trying to compare two strings. One is an imput from a form the other comes from a record source from a SQL 2000 database. Here is where I am stuck.

if request.Form("formVariable") = rs("rsvariable") then
code code

end if

Is it possible to do it like this. If not what are my alternatives. Any help would be appreciated.

Replies:

Posted By: ljamal
Date Posted: 04 August 2003 at 9:02pm

There is also the strComp function.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/script56/html/vsfctstrcomp.asp - strComp Information @ Microsoft

-------------
L. Jamal Walton

http://www.ljamal.com/" rel="nofollow - L. Jamal Inc : Web/ Print Design and ASP Programming

Posted By: KCWebMonkey
Date Posted: 04 August 2003 at 9:16pm

what about something like this:

Dim var1, var2

var1 = Request.Form("formVariable")
var2 = rs("rsVariable")

IF var1 = var2 THEN
...code here....
END IF

Posted By: CyberBless
Date Posted: 06 August 2003 at 7:50am

ljamal,

That strComp did the trick, thank you. I knew there was a function that would do it I just didn't know what it was. It's nice to see that MSDN is worth something. I think I'll use it more often.

Thanks again

Cyber "the mad scientist"

Posted By: CyberBless
Date Posted: 06 August 2003 at 7:53am

KCWebMonkey,

what you suggested would not give me the results I wanted. It compared the strings but paid no attention to uppercase or lowercase. The strComp is what I was looking for.

Thanks though,

Cyber "the mad scientist"