move to next record / wildcard search

Report · Mar 29, 2007

Hi
Hope you can understand this explanation..
I have searchable database for Holiday & Residential property here
http://www.roomtobreathesl.com (search facility in the navigation menu)

The results page for this search works fine for when you specify a certain
area, certain amount of beds etc as it only shows a small amount of
properties.

However when you do a search for any area / any amount of rooms / any type,
the query brings up over 40 results, so a move to next record is used. This
is where the problem lies. You cannot move to next record as the 'Next
record' link is looking for another wildcard search (see status bar).

Any ideas how to remedy this?

Thanks for any help

Gary

Report · Mar 29, 2007

I have always used Recordset Navigation Suite for Dreamweaver, its a
commercial extension and is $40 but one that i tend to use most often. Tom
supports all his products.

http://www.tom-muck.com/extensions/help/RecordsetNavigationSuite/

k

"woodywyatt" <woodywyatt@fuerteventura.com> wrote in message
news:eug7pl$o81$1@forums.macromedia.com...
> Hi
> Hope you can understand this explanation..
> I have searchable database for Holiday & Residential property here
> http://www.roomtobreathesl.com (search facility in the navigation menu)
>
> The results page for this search works fine for when you specify a certain
> area, certain amount of beds etc as it only shows a small amount of
> properties.
>
> However when you do a search for any area / any amount of rooms / any
> type, the query brings up over 40 results, so a move to next record is
> used. This is where the problem lies. You cannot move to next record as
> the 'Next record' link is looking for another wildcard search (see status
> bar).
>
> Any ideas how to remedy this?
>
> Thanks for any help
>
> Gary
>
>

Report · Mar 29, 2007

Thanks for the swift reply.
Is this likely to remedy the problem?
Gary

"twocans" <aaa@bb.com> wrote in message
news:eug8kp$p8k$1@forums.macromedia.com...
>I have always used Recordset Navigation Suite for Dreamweaver, its a
>commercial extension and is $40 but one that i tend to use most often. Tom
>supports all his products.
>
> http://www.tom-muck.com/extensions/help/RecordsetNavigationSuite/
>
>
> k
>
>
>
>
>
> "woodywyatt" <woodywyatt@fuerteventura.com> wrote in message
> news:eug7pl$o81$1@forums.macromedia.com...
>> Hi
>> Hope you can understand this explanation..
>> I have searchable database for Holiday & Residential property here
>> http://www.roomtobreathesl.com (search facility in the navigation menu)
>>
>> The results page for this search works fine for when you specify a
>> certain area, certain amount of beds etc as it only shows a small amount
>> of properties.
>>
>> However when you do a search for any area / any amount of rooms / any
>> type, the query brings up over 40 results, so a move to next record is
>> used. This is where the problem lies. You cannot move to next record as
>> the 'Next record' link is looking for another wildcard search (see status
>> bar).
>>
>> Any ideas how to remedy this?
>>
>> Thanks for any help
>>
>> Gary
>>
>>
>
>

Report · Mar 29, 2007

Use Request instead of Request.Form for runtime parameters.

--
Jules
http://www.charon.co.uk/charoncart
Charon Cart 3
Shopping Cart Extension for Dreamweaver MX/MX 2004

Report · Mar 29, 2007

Hi Jules
I did a search and replace for Request.Form to Request but results page
doesn't display
Gary

"Julian Roberts" <nospam@charon.co.uk> wrote in message
news:eugcuu$13u$1@forums.macromedia.com...
> Use Request instead of Request.Form for runtime parameters.
>
> --
> Jules
> http://www.charon.co.uk/charoncart
> Charon Cart 3
> Shopping Cart Extension for Dreamweaver MX/MX 2004
>
>
>
>
>

Report · Mar 29, 2007

What code have you got for the recordset on the results page?

--
Jules
http://www.charon.co.uk/charoncart
Charon Cart 3
Shopping Cart Extension for Dreamweaver MX/MX 2004

Report · Mar 30, 2007

Hi Julian
Here's the code -
<%
Dim rsResults
Dim rsResults_numRows

Set rsResults = Server.CreateObject("ADODB.Recordset")
rsResults.ActiveConnection = MM_YotShop6_STRING
rsResults.Source = "SELECT * FROM YotStock WHERE Area LIKE '" +
Replace(rsResults__MMColParam, "'", "''") + "' AND bedrooms LIKE '" +
Replace(rsResults__ysbed, "'", "''") + "' AND type LIKE '" +
Replace(rsResults__MMColParam3, "'", "''") + "' ORDER BY price ASC"
rsResults.CursorType = 0
rsResults.CursorLocation = 2
rsResults.LockType = 1
rsResults.Open()

rsResults_numRows = 0
%>

"Julian Roberts" <nospam@charon.co.uk> wrote in message
news:eugsps$l3d$1@forums.macromedia.com...
> What code have you got for the recordset on the results page?
>
> --
> Jules
> http://www.charon.co.uk/charoncart
> Charon Cart 3
> Shopping Cart Extension for Dreamweaver MX/MX 2004
>
>
>
>
>

Report · Mar 30, 2007

What's the code above that bit. The code that defines the parameters being
sent to the recordset.

--
Jules
http://www.charon.co.uk/charoncart
Charon Cart 3
Shopping Cart Extension for Dreamweaver MX/MX 2004

Report · Mar 30, 2007

Hi Julian
I've uploaded the whole code for you to look at. Perhaps that will shed some
light..
http://www.roomtobreathesl.com/asp_code.html

Thanks
Gary

Report · Mar 30, 2007

>> Use Request instead of Request.Form for runtime parameters.

You haven't done it :)

--
Jules
http://www.charon.co.uk/charoncart
Charon Cart 3
Shopping Cart Extension for Dreamweaver MX/MX 2004

Report · Mar 30, 2007

oops!
Sorry sent you the previous version that's online.
I also tried doing a search and replace and changing all 'Request.Form' to
'Request'
Still didn't work.

This is how it was when it wasn't working.

<%@LANGUAGE="VBSCRIPT"%>

<%
Dim rsResults__MMColParam
rsResults__MMColParam = "1"
If (Request("yscon") <> "") Then
rsResults__MMColParam = Request("yscon")
End If
%>
<%
Dim rsResults__ysbed
rsResults__ysbed = "1"
If (Request("ysbed") <> "") Then
rsResults__ysbed = Request("ysbed")
End If
%>
<%
Dim rsResults__MMColParam3
rsResults__MMColParam3 = "xyz"
If (Request("type") <> "") Then
rsResults__MMColParam3 = Request("type")
End If
%>
<%
Dim rsResults
Dim rsResults_numRows

Set rsResults = Server.CreateObject("ADODB.Recordset")
rsResults.ActiveConnection = MM_YotShop6_STRING
rsResults.Source = "SELECT * FROM YotStock WHERE Area LIKE '" +
Replace(rsResults__MMColParam, "'", "''") + "' AND bedrooms LIKE '" +
Replace(rsResults__ysbed, "'", "''") + "' AND type LIKE '" +
Replace(rsResults__MMColParam3, "'", "''") + "' ORDER BY price ASC"
rsResults.CursorType = 0
rsResults.CursorLocation = 2
rsResults.LockType = 1
rsResults.Open()

rsResults_numRows = 0
%>

"Julian Roberts" <nospam@charon.co.uk> wrote in message
news:euj4if$ici$1@forums.macromedia.com...
>>> Use Request instead of Request.Form for runtime parameters.
>
> You haven't done it :)
>
> --
> Jules
> http://www.charon.co.uk/charoncart
> Charon Cart 3
> Shopping Cart Extension for Dreamweaver MX/MX 2004
>
>
>
>