Snitz Forums 2000 - DB compare integer help

Snitz Forums 2000

Username:	Password:
Save Password
Forgot your Password?

All Forums

Community Forums

Code Support: ASP (Non-Forum Related)

DB compare integer help

New Topic

Topic Locked

Printer Friendly

Author

Topic

es4725
Junior Member

205 Posts

Posted - 28 February 2002 : 12:14:47

here is the code I have to compare text in a db:


Do Until objRS.EOF or bolFound
   If (StrComp(objRS("Name"), strName, vbTextCompare) = 0) Then
    'found it
    bolFound = True
  Else
    objRS.MoveNext
  End If
Loop

I need something to do the same thing with an integer field. I don't recall how to do this right now.

OneWayMule
Dev. Team Member & Support Moderator

Austria
4969 Posts

Posted - 28 February 2002 : 13:17:21

Try this:


Do Until objRS.EOF or bolFound
   If (strValue = objRS("FieldName")) Then
    'found it
    bolFound = True
  Else
    objRS.MoveNext
  End If
Loop

-------------------------------------------------
Installation Guide | Do's and Dont's | MODs

es4725
Junior Member

205 Posts

Posted - 28 February 2002 : 23:37:33

I thought about that - I just wasn't sure if there was something similar to StrComp for integers.
I'll use that though. Thanks.

Topic

New Topic

Topic Locked

Printer Friendly

Jump To:

Snitz Forums 2000

This page was generated in 0.25 seconds.