I have an active server page that is supposed to get results from a previous
page. When I don't specify any database criteria, the entire list of what I
am looking for is returned. I expected this as I did not specify anything.
However, when I place a criteria on to what I want retuned, based on the
results from the previous asp, I receive the message I inserted for the "no
records returned" condtion. Does anyone have any suggestions? TIA.

Bill Beshlian

RE: Database Criteria Returning No Records. by swalt

swalt
Mon Nov 06 14:28:01 CST 2006

What are you using to link to the second page. Do you have parameters set ?


"Bill Beshlian" wrote:

> I have an active server page that is supposed to get results from a previous
> page. When I don't specify any database criteria, the entire list of what I
> am looking for is returned. I expected this as I did not specify anything.
> However, when I place a criteria on to what I want retuned, based on the
> results from the previous asp, I receive the message I inserted for the "no
> records returned" condtion. Does anyone have any suggestions? TIA.
>
> Bill Beshlian

Re: Database Criteria Returning No Records. by Kathleen

Kathleen
Mon Nov 06 20:11:40 CST 2006

Are you sure you're posting to the second page correctly? Take a look at
this: http://www.spiderwebwoman.com/resources/dbrwtipsandtricks.asp#return

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/


"Bill Beshlian" <BillBeshlian@discussions.microsoft.com> wrote in message
news:6354280F-9D29-4DBC-8455-ACE67768F7AB@microsoft.com...
>I have an active server page that is supposed to get results from a
>previous
> page. When I don't specify any database criteria, the entire list of what
> I
> am looking for is returned. I expected this as I did not specify
> anything.
> However, when I place a criteria on to what I want retuned, based on the
> results from the previous asp, I receive the message I inserted for the
> "no
> records returned" condtion. Does anyone have any suggestions? TIA.
>
> Bill Beshlian