Is Bigger Than?

[Kings]

I must be stupid or something but with the following code;
[vbs]
If intPageSize < UBound(dbMembers, 2) Then
mlist_length = intPageSize
Else
mlist_length = UBound(dbMembers, 2)
End If
[/vbs]

mlist_length = 398, even though intPageSize = 30 and UBound(dbMembers, 2) = 398.

Can someone tell me wtf is wrong?

[Jeremy W.]

URL?

It'd be good to response.write out the values of the things you are testing so you can literally see them, including converting the datatypes.

J

[DaveMaxwell]

Are they both numeric for sure? And have values right then and there? You might want to do a clng on both of those values just to be sure you're comparing apples to apples...

[Kings]

It isn't online; It's on my localhost. And what do you mean with converting the datatypes?

btw, here are the values when I "response.writed" them,

mlistlength = 398
intPageSize = 30
UBound(dbMembers, 2) = 398

code used for that,
[vbs]
Response.Write "mlistlength = " & mlist_length & "<br>"
Response.Write "intPageSize = " & intPageSize & "<br>"
Response.Write "UBound(dbMembers, 2) = " & UBound(dbMembers, 2)
[/vbs]

[Kings]

bah, it worked. The "clng" did it. Mind telling me what it is and if you have any tutorials/faq/articles for it?

[DaveMaxwell]

clng converts a string or variant to a numeric value. You could also use cint, but that limits you to a size of 32,767 where clng is unlimited (essentially, there is an limit, but don't remember the value).

Basically, what happened was you were comparing a numeric value with a string value so the conversion was changing the value. What you did was force it to compare numeric to numeric.

[Kings]

ah, I understand. Thanks! (Jeremy, Thanks too)

[DaveMaxwell]

Originally posted by Kings
ah, I understand. Thanks! (Jeremy, Thanks too)

Glad I could help and that you got it working....