move to next record / wildcard search

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"%>
<!--#include file="Connections/YotShop6.asp" -->
<%
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
>
>
>
>

>> 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

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

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

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
>
>
>
>
>

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

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
>
>
>
>
>

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

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
>>
>>
>
>

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
>
>