Comparing RecordSet value to Querystring value 1

[Maldini]

Hi,

Is this possible?
What I'm trying to do is a simple:

If Rst1("ID") = Request.Querystring("PassedID") Then
// Run some code
Else
// Run something else
End If

However, I've tried replacing the querystring with a variable, wrapping the recordset with quotes, but nothing seems to work.

Any tips?

Thanks.

Maldini

 

[DotNetGnat]

Try this:

rid=Trim(Rst1("ID"))
If Request.Querystring("PassedID")=rid Then

-DNG

 

[FesterSXS]

If the value is an integer and not a string then you will need to convert the querystring value into an integer before you make the comparison:

If Rst1("ID") = [red]CInt([/red]Request.Querystring("PassedID")[red])[/red] Then
// Run some code
Else
// Run something else
End If

Tony
_______________________________________________________________

http://www.SpiraxSarco.com/

 

[Maldini]

Thanks, the conversion to integer was exactly what was lacking; it works now.
Maldini