Recordset - passing multiple parameters

Report · Jan 18, 2009

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

Report · Jan 19, 2009

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