Search pages...

I have created a search page which works fine apart from one thing.

When a user searches for a property with 5 or more bedrooms, the results
return nothing.

How do i get the search page to show only the properties > 5 beds.

"Ben Walker" <bwalker (AT) telephoneland (DOT) com> wrote in news:cbp2jd$sen$1
@forums.macromedia.com:

how are you doing the search?

I have created a search page which works fine apart from one thing.

When a user searches for a property with 5 or more bedrooms, the results
return nothing.

How do i get the search page to show only the properties > 5 beds.

using form drop downs.

each value is 1 2 3 4 5 then i dont know what to put for 5 +.

If i put 5, it pulls only 5 bed properties not greater than.


"s_m_b" <smb20002ns (AT) hotmail (DOT) com> wrote

"Ben Walker" <bwalker (AT) telephoneland (DOT) com> wrote in news:cbp2jd$sen$1
@forums.macromedia.com:

how are you doing the search?

I have created a search page which works fine apart from one thing.

When a user searches for a property with 5 or more bedrooms, the results
return nothing.

How do i get the search page to show only the properties > 5 beds.

"Ben Walker" <bwalker (AT) telephoneland (DOT) com> wrote in
news:cbpdrt$fcg$1 (AT) forums (DOT) macromedia.com:

right, next bit. what code submits the request for the recordset?

using form drop downs.

each value is 1 2 3 4 5 then i dont know what to put for 5 +.

If i put 5, it pulls only 5 bed properties not greater than.


"s_m_b" <smb20002ns (AT) hotmail (DOT) com> wrote in message
news:Xns9516920CE5FC5smb2000nshotrmailcom (AT) 216 (DOT) 104.212.96...
"Ben Walker" <bwalker (AT) telephoneland (DOT) com> wrote in news:cbp2jd$sen$1
@forums.macromedia.com:

how are you doing the search?

I have created a search page which works fine apart from one thing.

When a user searches for a property with 5 or more bedrooms, the
results return nothing.

How do i get the search page to show only the properties > 5 beds.

Manually code a check of the value of the combobox. If it is 5, then
make the where clause of your query >= to the value of the combobox,
if not 5, then make your where clause the value of the combobox. Then
substitute your manually coded query for the DW generated one.

var strsql = "";
if (String(Request.Form("cbox1")) == 5)
{strsql = "SELECT ... WHERE colname >=
String(Request.Form("cbox1"))}
else
{strsql = "SELECT ... WHERE colname = String(Request.Form("cbox1"))}

var Recordset1 = Server.CreateObject("ADODB.Recordset");
Recordset1.ActiveConnection = MM_MYCONN_STRING;

Recordset1.Source = strsql;

Recordset1.CursorType = 0;
Recordset1.CursorLocation = 2;
Recordset1.LockType = 1;
Recordset1.Open();
var Recordset1_numRows = 0;