Filtering by more than one column?

[I Need Help!]

I have a set of links that take you to the same results page but bringing up different
data specific to the particular link clicked.

I know how to create a detail page but this is not the same as there are multiple entries.

I tried adding parameters to the link but every entry in the database appears on the page

e.g . . .

<a
href="results.asp?<%=(rsSales.Fields.Item("state") .Value)%>=Whatever&<%=(rsSales.Fields.It
em("category").Value)%>=Sales">Sales</a>

also tried . . .

results.asp?state=Whatever&category=Sales



What should I be saying in the SQL for the recordset?


I am only a beginner and trying to get my head around this!


Thanks in advance

[Manuel Socarras]

I Need Help! wrote:

> I have a set of links that take you to the same results page but bringing up different
> data specific to the particular link clicked.
>
> I know how to create a detail page but this is not the same as there are multiple entries.
>
> I tried adding parameters to the link but every entry in the database appears on the page
>
> e.g . . .
>
> <a
> href="results.asp?<%=(rsSales.Fields.Item("state") .Value)%>=Whatever&<%=(rsSales.Fields.It
> em("category").Value)%>=Sales">Sales</a>
>
> also tried . . .
>
> results.asp?state=Whatever&category=Sales

st = Request.QueryString("state")
cat = Request.QueryString("category")

"SELECT field1, field2, ... FROM table WHERE state = '" & st & "' AND
cat = '" & category & "'"

i'm assuming your fields in the DB are named state and vategory

HTH,

manuel

> What should I be saying in the SQL for the recordset?
>
>
> I am only a beginner and trying to get my head around this!
>
>
> Thanks in advance