matching a querystring to a checkbox field?

[Nathon Jones]

Hi,

(ASP/VBScript, Access, DWMX)

I have a page that has a set of links


<a href="resultspage.asp?residential=1">Residential</a>
<a href="resultspage.asp?commercial=1">Commercial</a>

These links point to an ASP results page, which has a recordset that
contains data from a table in Access that has checkboxes for Residential,
Commerical, Lease etc. I'm having trouble establishing what my SELECT
statement should be on the results page...

SELECT *
FROM datatable
WHERE residential = varResidential OR commercial = varCommercial

varResidential 0 Request.QueryString("residential")
varCommercial 0 Request.QueryString("commercial")

Problem is, when I click one of the links, it is showing me both Residential
and Commercial? I had assumed that, if I only passed 1 variable through the
querystring, it would assume that all other values would be 0 (Default
Value), and therefore would not show them?

I know I'm making a mountain out of a mole hill here, so what is the best
way to do this?

Thanks, in advance, for any help offered.
Regards
Nath.

[darrel]

> SELECT *

> FROM datatable
> WHERE residential = varResidential OR commercial = varCommercial
>
> Problem is, when I click one of the links, it is showing me both

Residential

> and Commercial?

What I usually do is add a response.write to my page:

response.write (myQueryString)

and then run the page to see exactly what is being passed to the database.

-Darrel