ASP Programming
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed Forums > Programming Languages - More > ASP Programming
Reload this Page

String Compare

Discuss String Compare in the ASP Programming forum on Dev Shed.
String Compare ASP Programming forum discussing Active Server Pages coding techniques and problem solving methods. Use VBScript or Jscript to make dynamic web applications.

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
« Previous Thread | Next Thread »  
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
Stay one step ahead of the competition. Evaluate and give feedback on some of the hottest web development tools on the market today. Make your opinion heard! Click Here
  #1  
Old August 18th, 2003, 03:56 AM
secondpost secondpost is offline
Junior Member
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Aug 2003
Posts: 6 secondpost User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
String Compare
Below I have some code to compare an input time (starttime="13:35") to the records in the SQL database. When I run the code on my site I get this response:

13:05 13:35 1
13:15 13:35 1
13:25 13:35 1
13:35 13:35 -1
13:45 13:35 -1
13:55 13:35 -1
14:05 13:35 -1
14:10 13:35 -1
14:20 13:35 -1
14:30 13:35 -1
14:50 13:35 -1

Why isn't the comparison of 13:35 with 13:35 = 0?

While Not objRecSQLDBInfo.EOF
test=objRecSQLDBInfo("CCBtime")
Response.Write test
strtest=strComp(starttime, test, vbTextCompare)
Response.Write starttime & " "
Response.Write strtest & "<br>"
objRecSQLDBInfo.MoveNext
Wend
Reply With Quote
  #2  
Old August 18th, 2003, 06:08 AM
unatratnag unatratnag is offline
Average Intelligence
Dev Shed Novice (500 - 999 posts)
  
Join Date: Apr 2003
Location: Ohio/Chicago
Posts: 678 unatratnag User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 5 m 54 sec
Reputation Power: 6
Send a message via AIM to unatratnag
typecast them both to string first, cstr(variable)
Reply With Quote
  #3  
Old August 19th, 2003, 04:10 AM
secondpost secondpost is offline
Junior Member
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Aug 2003
Posts: 6 secondpost User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
While Not objRecSQLDBInfo.EOF
test=objRecSQLDBInfo("CCBtime")
test=cstr(test)
starttime=cstr(starttime)
Response.Write test
strtest=strComp(starttime, test, vbTextCompare)
Response.Write starttime & " "
Response.Write strtest & "<br>"
objRecSQLDBInfo.MoveNext
Wend

Like this? There's no change in result.
Reply With Quote
  #4  
Old August 19th, 2003, 07:32 AM
aspman aspman is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Aug 2003
Location: Ashburn,VA
Posts: 105 aspman User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 7 h 22 m 40 sec
Reputation Power: 5
you may have trim the time you are getting from the db to hours and minutes only.

i mean reformat it like

timeformat(rs(time),'hh:mm')

something like that

--------------------------------------------------------------
Reply With Quote
  #5  
Old August 19th, 2003, 07:36 AM
unatratnag unatratnag is offline
Average Intelligence
Dev Shed Novice (500 - 999 posts)
  
Join Date: Apr 2003
Location: Ohio/Chicago
Posts: 678 unatratnag User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 5 m 54 sec
Reputation Power: 6
Send a message via AIM to unatratnag
well, he isn't trimming the output

13:25 13:35 1
13:35 13:35 -1

so if he's printing out the two and they look like this that shouldn't be the issue....
Reply With Quote
  #6  
Old August 19th, 2003, 07:42 AM
secondpost secondpost is offline
Junior Member
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Aug 2003
Posts: 6 secondpost User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Comparing 13:35 to 13:35 should give 0 not -1 right?
Reply With Quote
  #7  
Old August 19th, 2003, 07:49 AM
Vlince Vlince is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Jun 2003
Location: Canada, Quebec, Montreal
Posts: 410 Vlince User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 5
Here's the definition:


StrComp
Returns a value indicating the result of a string comparison.

Syntax
StrComp(string1, string2[, compare])

The StrCompsyntax has these arguments:

Part Description
string1 Required. Any valid string expression.
string2 Required. Any valid string expression.
compare Optional. Numeric value indicating the kind of comparison to use when evaluating strings. If omitted, a binary comparison is performed. See Settings section for values.


Settings
The compare argument can have the following values:

Constant Value Description
vbBinaryCompare 0 Perform a binary comparison.
vbTextCompare 1 Perform a textual comparison.
vbDatabaseCompare 2 Not supported.


Return Values
The StrComphas the following return values:

If StrComp returns
string1 is less than string2 -1
string1 is equal to string2 0
string1 is greater than string2 1
string1 or string2 is Null Null
Reply With Quote
Reply

Viewing: Dev Shed Forums > Programming Languages - More > ASP Programming > String Compare

« Previous Thread | Next Thread »

Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Linear Mode Linear Mode
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump

 Free IT White Papers!
 
Accelerating Trading Partner Performance
One in five. That's how many partner transactions have at least one error. That is an amazing statistic, particularly given the extraordinary leaps in innovation across the global supply chain during the past two decades. Download this white paper to learn more.
 
Competing on Analytics
This Tech Analysis is designed to help identify characteristics shared by analytics competitors, and includes information about 32 organizations that have made a commitment to quantitative, fact-based analysis.
 
Cost Effective Scaling with Virtualization and Coyote Point Systems
An overview of the industry trend toward virtualization, how server consolidation has increased the importance of application uptime and the steps being taken to integrate load balancing technology with virtualized servers.
 
Five Checkpoints to Implementing IP Telephony
Implementation planning for IP PBX software and IP telephony has become vital as businesses replace discontinued legacy PBX phone systems. This informative whitepaper outlines five "checkpoints" for any implementation plan that will help make IP communications a successful proposition.
 
Hosted Email Security: Staying Ahead of New Threats
In the last two years, email has become a fierce battleground between the nefarious forces of spam and malware, and the heroes of messaging protection. The spam volumes increased alarmingly every month, bringing clever new forms of phishing and virus propagation attacks.
 

Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 1 hosted by Hostway.