Recordset - passing multiple parameters

simonbelfast wrote:
> Hi,
> I am trying to create a search page that recieves two parameters passed
> through a query string. I am trying to get search results between two numeric
> values ie Minprice and Maxprice. The following code tested in DW CS3 just
> gererates no data, even though there are data in my default ranges.
> Here is my SQL and parameters below. Please can someone help?
>
> SELECT *
> FROM tblProperties
> WHERE Price > MMColParam AND (Price < %MMColParam2% )
>
> Price is the table column and the two paramaters are passed through the url
>
> Parameter Details
>
> Name = MMColParam
> Type = Text
> Value = Request.QueryString("Minprice")
> Default Value = 1
>
> Name = MMColParam2
> Type = Text
> Value = Request.QueryString("Maxprice")
> Default Value = 2000

SELECT *
FROM tblProperties
WHERE Price BETWEEN MMColParam AND MMColParam2

Dooza