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 20, 2009

Notice that you have used two different formats. From DW bindings :
recordset inspect the way DW makes the var's naturally (MMColParam).
On your second var remove the extraneous

like: WHERE Price > MMColParam AND Price < MColParam

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
>

--