Recordset - passing multiple parameters

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
>



--