«

How can I do the following:

If recordset is empty, redirect to page1 but if recordset has something in,
redirect to page 2.

Thanks

valTemp = rst.RecordCount
Select Case valTemp
Case 0
Response.Redirect "nothing_in_there.asp"
Case Else
Response.Redirect "something_in_there.asp"
End Select

--

Regards

Steven Burn
Ur I.T. Mate Group
www.it-mate.co.uk

Keeping it FREE!


"Keith" <@.> wrote in message news:#...
> How can I do the following:
>
> If recordset is empty, redirect to page1 but if recordset has something
in,
> redirect to page 2.
>
> Thanks
>
>

set rs = conn.execute(sql)
if rs.eof then
response.redirect("page1.asp")
else
response.redirect("page2.asp")
end if


--
http://www.aspfaq.com/
(Reverse address to reply.)




"Keith" <@.> wrote in message news:#...
> How can I do the following:
>
> If recordset is empty, redirect to page1 but if recordset has something
in,
> redirect to page 2.
>
> Thanks
>
>

> valTemp = rst.RecordCount
> Select Case valTemp
> Case 0
> Response.Redirect "nothing_in_there.asp"
> Case Else
> Response.Redirect "something_in_there.asp"
> End Select

Except, RecordCount isn't available with the default cursor (-1 is the
default), so your Else will probably always fire.

The EOF property will tell you if the resultset is empty without having to
rely on a count.

A

I actually generally use;

If rst.RecordCount > 0 then
'// Something
End If

Just figured I'd be creative \

--

Regards

Steven Burn
Ur I.T. Mate Group
www.it-mate.co.uk

Keeping it FREE!


"Aaron [SQL Server MVP]" <> wrote in message
news:#...
> > valTemp = rst.RecordCount
> > Select Case valTemp
> > Case 0
> > Response.Redirect "nothing_in_there.asp"
> > Case Else
> > Response.Redirect "something_in_there.asp"
> > End Select
>
> Except, RecordCount isn't available with the default cursor (-1 is the
> default), so your Else will probably always fire.
>
> The EOF property will tell you if the resultset is empty without having to
> rely on a count.
>
> A
>
>

How (if possible) could I modify this so that it redirects to page 1 if RS
was NOT eof OR if a sessionvariable1 contained value1

If the session variable containes any other value or if the rs IS eof then
redirect to page 2

Thanks


"Aaron [SQL Server MVP]" <> wrote in message
news:%...
> set rs = conn.execute(sql)
> if rs.eof then
> response.redirect("page1.asp")
> else
> response.redirect("page2.asp")
> end if
>
>
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
>
>
> "Keith" <@.> wrote in message news:#...
> > How can I do the following:
> >
> > If recordset is empty, redirect to page1 but if recordset has something
> in,
> > redirect to page 2.
> >
> > Thanks
> >
> >
>
>

set rs = conn.execute(sql)
if not rs.eof or sessionvarible1 = "1" then
response.redirect("page1.asp")
else
response.redirect("page2.asp")
end if

--

Regards

Steven Burn
Ur I.T. Mate Group
www.it-mate.co.uk

Keeping it FREE!


"Keith" <@.> wrote in message news:u$...
> How (if possible) could I modify this so that it redirects to page 1 if RS
> was NOT eof OR if a sessionvariable1 contained value1
>
> If the session variable containes any other value or if the rs IS eof then
> redirect to page 2
>
> Thanks
>
>
> "Aaron [SQL Server MVP]" <> wrote in message
> news:%...
> > set rs = conn.execute(sql)
> > if rs.eof then
> > response.redirect("page1.asp")
> > else
> > response.redirect("page2.asp")
> > end if
> >
> >
> > --
> > http://www.aspfaq.com/
> > (Reverse address to reply.)
> >
> >
> >
> >
> > "Keith" <@.> wrote in message
news:#...
> > > How can I do the following:
> > >
> > > If recordset is empty, redirect to page1 but if recordset has
something
> > in,
> > > redirect to page 2.
> > >
> > > Thanks
> > >
> > >
> >
> >
>
>

Keith wrote:
> How can I do the following:
>
> If recordset is empty, redirect to page1 but if recordset has
> something in, redirect to page 2.

if (RS.EOF) {
<<< do stuff, close connection, etc. >>>
Response.Redirect("p1.asp")
}

<<< do other stuff, close RS & CN >>>
Response.Redirect("p2.asp")



--
Dave Anderson

Unsolicited commercial email will be read at a cost of $500 per message. Use
of this email address implies consent to these terms. Please do not contact
me directly or ask me to contact you directly for assistance. If your
question is worth asking, it's worth posting.

Again, this use of RecordCount requires the use of an expensive cursor type.
Use the EOF property instead (as Aaron correctly suggested):

'//immediately after opening the recordset:
If not rst.EOF then
'//recordset is not empty
else
'//recordset is empty
end if

Bob Barrows

Steven Burn wrote:
> I actually generally use;
>
> If rst.RecordCount > 0 then
> '// Something
> End If
>
> Just figured I'd be creative \
>
>
> "Aaron [SQL Server MVP]" <> wrote in message
> news:#...
>>> valTemp = rst.RecordCount
>>> Select Case valTemp
>>> Case 0
>>> Response.Redirect "nothing_in_there.asp"
>>> Case Else
>>> Response.Redirect "something_in_there.asp"
>>> End Select
>>
>> Except, RecordCount isn't available with the default cursor (-1 is
>> the default), so your Else will probably always fire.
>>
>> The EOF property will tell you if the resultset is empty without
>> having to rely on a count.
>>
>> A

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

Been taking a look into it since Aaron mentioned it ;o) (so far, I can't see
the difference as far as performance is concerned?)

--

Regards

Steven Burn
Ur I.T. Mate Group
www.it-mate.co.uk

Keeping it FREE!


"Bob Barrows [MVP]" <> wrote in message
news:...
> Again, this use of RecordCount requires the use of an expensive cursor
type.
> Use the EOF property instead (as Aaron correctly suggested):
>
> '//immediately after opening the recordset:
> If not rst.EOF then
> '//recordset is not empty
> else
> '//recordset is empty
> end if
>
> Bob Barrows
>
> Steven Burn wrote:
> > I actually generally use;
> >
> > If rst.RecordCount > 0 then
> > '// Something
> > End If
> >
> > Just figured I'd be creative \
> >
> >
> > "Aaron [SQL Server MVP]" <> wrote in message
> > news:#...
> >>> valTemp = rst.RecordCount
> >>> Select Case valTemp
> >>> Case 0
> >>> Response.Redirect "nothing_in_there.asp"
> >>> Case Else
> >>> Response.Redirect "something_in_there.asp"
> >>> End Select
> >>
> >> Except, RecordCount isn't available with the default cursor (-1 is
> >> the default), so your Else will probably always fire.
> >>
> >> The EOF property will tell you if the resultset is empty without
> >> having to rely on a count.
> >>
> >> A
>
> --
> Microsoft MVP - ASP/ASP.NET
> Please reply to the newsgroup. This email account is my spam trap so I
> don't check it very often. If you must reply off-line, then remove the
> "NO SPAM"
>
>