URL parameter and repeat regions

[Moragreid]

has anyone got an idea why when i do a URL parameter to return records
containing a certain word from a record and go to a detail page it works fine -
but...when i put on a repeat region it it starts displaying the text from the
database from the first place it shows this word then pulls through all the
rest of the records... Even if this word doesn't appear?
Ive shown the link below...an i being thick?!
[url]http://localhost/test/anniemos/content/furniture_d_l.asp?rhm_code=sofas[/url]

[Paul Whitham TMM]

It all depends on how you have set up the SQL statement on the results page,
rather than what is being passed.

--
Regards

Paul Whitham
Macromedia Certified Professional for Dreamweaver MX2004
Valleybiz Internet Design
[url]www.valleybiz.net[/url]

Team Macromedia Volunteer for Ultradev/Dreamweaver MX
[url]www.macromedia.com/support/forums/team_macromedia[/url]

"Moragreid" <webforumsuser@macromedia.com> wrote in message
news:d2u7ti$5pe$1@forums.macromedia.com...

> has anyone got an idea why when i do a URL parameter to return records
> containing a certain word from a record and go to a detail page it works

fine -

> but...when i put on a repeat region it it starts displaying the text from

the

> database from the first place it shows this word then pulls through all

the

> rest of the records... Even if this word doesn't appear?
> Ive shown the link below...an i being thick?!
> [url]http://localhost/test/anniemos/content/furniture_d_l.asp?rhm_code=sofas[/url]
>

[Moragreid]

ok - so here is my detail page - does this help in why its not working?

<%@LANGUAGE="VBSCRIPT"%>
<!--#include file="../Connections/conn_anniem.asp" -->
<%
Dim rs_maintext__bedroom
rs_maintext__bedroom = "bedroom"
If (request("bedroom1") <> "") Then
rs_maintext__bedroom = request("bedroom1")
End If
%>
<%
Dim rs_maintext
Dim rs_maintext_numRows

Set rs_maintext = Server.CreateObject("ADODB.Recordset")
rs_maintext.ActiveConnection = MM_conn_anniem_STRING
rs_maintext.Source = "SELECT * FROM fur_table WHERE acc_type='" +
Replace(rs_maintext__bedroom, "'", "''") + "' ORDER BY ID"
rs_maintext.CursorType = 0
rs_maintext.CursorLocation = 2
rs_maintext.LockType = 1
rs_maintext.Open()

rs_maintext_numRows = 0
%>
<%
Dim Recordset1__lounge
Recordset1__lounge = "lounge"
If (request("bedroom") <> "") Then
Recordset1__lounge = request("bedroom")
End If
%>
<%
Dim Recordset1
Dim Recordset1_numRows

Set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.ActiveConnection = MM_conn_anniem_STRING
Recordset1.Source = "SELECT * FROM fur_rhm WHERE LHMenu='" +
Replace(Recordset1__lounge, "'", "''") + "' ORDER BY RHMtitle ASC"
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 1
Recordset1.Open()

Recordset1_numRows = 0
%>
<%
Dim MM_paramName
%>
<%
' *** Go To Record and Move To Record: create strings for maintaining URL and
Form parameters

Dim MM_keepNone
Dim MM_keepURL
Dim MM_keepForm
Dim MM_keepBoth

Dim MM_removeList
Dim MM_item
Dim MM_nextItem

' create the list of parameters which should not be maintained
MM_removeList = "&index="
If (MM_paramName <> "") Then
MM_removeList = MM_removeList & "&" & MM_paramName & "="
End If

MM_keepURL=""
MM_keepForm=""
MM_keepBoth=""
MM_keepNone=""

' add the URL parameters to the MM_keepURL string
For Each MM_item In Request.QueryString
MM_nextItem = "&" & MM_item & "="
If (InStr(1,MM_removeList,MM_nextItem,1) = 0) Then
MM_keepURL = MM_keepURL & MM_nextItem &
Server.URLencode(Request.QueryString(MM_item))
End If
Next

' add the Form variables to the MM_keepForm string
For Each MM_item In Request.Form
MM_nextItem = "&" & MM_item & "="
If (InStr(1,MM_removeList,MM_nextItem,1) = 0) Then
MM_keepForm = MM_keepForm & MM_nextItem &
Server.URLencode(Request.Form(MM_item))
End If
Next

' create the Form + URL string and remove the intial '&' from each of the
strings
MM_keepBoth = MM_keepURL & MM_keepForm
If (MM_keepBoth <> "") Then
MM_keepBoth = Right(MM_keepBoth, Len(MM_keepBoth) - 1)
End If
If (MM_keepURL <> "") Then
MM_keepURL = Right(MM_keepURL, Len(MM_keepURL) - 1)
End If
If (MM_keepForm <> "") Then
MM_keepForm = Right(MM_keepForm, Len(MM_keepForm) - 1)
End If

' a utility function used for adding additional parameters to these strings
Function MM_joinChar(firstItem)
If (firstItem <> "") Then
MM_joinChar = "&"
Else
MM_joinChar = ""
End If
End Function
%>
<html><!-- InstanceBegin template="/Templates/inside1.dwt"
codeOutsideHTMLIsLocked="false" -->
<head>
<title>home.jpg</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<!--Fireworks MX 2004 Dreamweaver MX 2004 target. Created Fri Apr 01 09:24:48
GMT+0100 (GMT Daylight Time) 2005-->
<style type="text/css">

<!--
body {
background-color: #000000;
margin-left: 0px;
margin-top: 0px;
margin-right: 0px;
margin-bottom: 0px;
}
-->





-->
</style>
<link href="../alltest.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
body {
margin-left: 0px;
margin-top: 0px;
margin-right: 0px;
margin-bottom: 0px;
background-color: #FFFFFF;
background-image: url(../images/bg_1.gif);
}
-->
</style></head>
<body>
<table width="759" height="100%" border="0" cellpadding="0" cellspacing="0"
bgcolor="#ffffff">
<!-- fwtable fwsrc="HOMEPAGE.PNG" fwbase="home.jpg" fwstyle="Dreamweaver"
fwdocid = "742308039" fwnested="0" -->
<tr>
<td><img src="../images/space1r.gif" width="161" height="1" border="0"
alt=""></td>
<td><img src="../images/space1r.gif" width="598" height="1" border="0"
alt=""></td>
<td><img src="../images/space1r.gif" width="1" height="1" border="0"
alt=""></td>
</tr>
<tr>
<td colspan="2" valign="top"><!-- #BeginLibraryItem "/Library/menubar.lbi"
-->
<link href="../alltest.css" rel="stylesheet" type="text/css">
<table width="756" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="91" valign="bottom" bgcolor="#FFFFFF"><a href="../index.htm"
target="_self"><img src="../images/logo.jpg" alt="Annie Mos Logo" name="Logo"
width="158" height="46" border="0" id="Logo"></a></td>
</tr>
</table>
<table width="761" height="30" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="4" height="30" bgcolor="#FFFFFF">&nbsp;</td>
<td width="181" bgcolor="#A3B390">&nbsp;</td>
<td width="64" bgcolor="#A3B390" class="offwhite"><a
href="../index.htm" target="_self" class="offwhite">home</a></td>
<td width="174" align="center" bgcolor="#A3B390" class="offwhite"><a
href="story.htm" target="_self" class="offwhite">the story of annie
mo's</a></td>
<td width="139" align="center" bgcolor="#A3B390" class="offwhite"><a
href="location.htm" target="_self" class="offwhite">our locations </a></td>
<td width="199" align="center" bgcolor="#A3B390" class="offwhite"><a
href="wedding.htm" target="_self" class="offwhite">our alternative wedding list
</a></td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td bgcolor="#FFFFFF"><img src="../images/spacer1.jpg" width="7"
height="3"></td>
</tr>
</table>
<!-- #EndLibraryItem --></td>
<td><img src="../images/space1r.gif" width="1" height="121" border="0"
alt=""></td>
</tr>
<tr>
<td width="161" valign="top" background="../images/home1_r3_c1.jpg"><table
width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td bgcolor="#FFFFFF"><table width="100%" border="0" cellspacing="0"
cellpadding="0">
<tr>
<td><table width="100%" border="0" cellspacing="0"
cellpadding="0">
<tr>
<td width="3">&nbsp;</td>
<td><table width="152" height="152" border="1"
cellpadding="0" cellspacing="0" bordercolor="#C5CEBA">
<tr>
<td> <!-- InstanceBeginEditable name="furniture" -->
<table width="152" height="151" border="0"
cellpadding="0" cellspacing="0">
<tr>
<td width="10" rowspan="2"
bgcolor="#C5CEBA">&nbsp;</td>
<td height="30" valign="bottom"
bgcolor="#C5CEBA" class="offgreen"><a href="furniture.htm" target="_self"
class="ondarkgreen">furniture</a></td>
</tr>
<tr>
<td valign="top" bgcolor="#C5CEBA"><!--
#BeginLibraryItem "/Library/fur_bedroom.lbi" --><table width="100%" border="0"
cellspacing="0" cellpadding="0">
<tr>
<td height="20" class="offwhite"><a
href="fur_lounge.asp" target="_self" class="offwhite">lounge</a></td>
</tr>
<tr>
<td height="20" class="offwhite"><a
href="fur_dining.asp" target="_self" class="offwhite">dining room</a></td>
</tr>
<tr>
<td height="20" class="offwhite"><a
href="fur_bedroom.asp" target="_self" class="whiteselected">bedroom</a></td>
</tr>
<tr>
<td height="20" class="offwhite"><a
href="fur_hallway.asp" target="_self" class="offwhite">hallway</a></td>
</tr>
</table><!-- #EndLibraryItem --></td>
</tr>
</table>
<!-- InstanceEndEditable --></td>
</tr>
</table>
<table width="152" height="3" border="0" cellpadding="0"
cellspacing="0">
<tr>
<td><img src="../images/menu_spacer.gif" width="3"
height="3" alt=""></td>
</tr>
</table></td>
</tr>
</table></td>
<td width="3"><img src="../images/spacer22.jpg" width="3"
height="3"></td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><table width="100%" border="0" cellspacing="0"
cellpadding="0">
<tr>
<td width="3">&nbsp;</td>
<td><table width="152" height="152" border="1"
cellpadding="0" cellspacing="0" bordercolor="#C5CEBA">
<tr>
<td> <!-- InstanceBeginEditable name="accessories"
-->
<table width="152" height="151" border="0"
cellpadding="0" cellspacing="0">
<tr>
<td width="10" rowspan="2">&nbsp;</td>
<td height="30" valign="bottom"
class="offgreen"><a href="accessories.htm" target="_self"
class="ondarkgreen">accessories</a></td>
</tr>
<tr>
<td valign="top">&nbsp;</td>
</tr>
</table>
<!-- InstanceEndEditable --></td>
</tr>
</table>
<table width="152" height="3" bord

[Paul Whitham TMM]

The problem is that a like

rs_maintext__bedroom = request("bedroom1")

is not specific enough to tell the system where to find this value and so it
is looking for a form field. To grab this from a URL parameter then it needs
to be

rs_maintext__bedroom = request.querystring("bedroom1")


--
Regards

Paul Whitham
Macromedia Certified Professional for Dreamweaver MX2004
Valleybiz Internet Design
[url]www.valleybiz.net[/url]

Team Macromedia Volunteer for Ultradev/Dreamweaver MX
[url]www.macromedia.com/support/forums/team_macromedia[/url]

"Moragreid" <webforumsuser@macromedia.com> wrote in message
news:d303pf$q2v$1@forums.macromedia.com...

> ok - so here is my detail page - does this help in why its not working?
>
> <%@LANGUAGE="VBSCRIPT"%>
> <!--#include file="../Connections/conn_anniem.asp" -->
> <%
> Dim rs_maintext__bedroom
> rs_maintext__bedroom = "bedroom"
> If (request("bedroom1") <> "") Then
> rs_maintext__bedroom = request("bedroom1")
> End If
> %>
> <%
> Dim rs_maintext
> Dim rs_maintext_numRows
>
> Set rs_maintext = Server.CreateObject("ADODB.Recordset")
> rs_maintext.ActiveConnection = MM_conn_anniem_STRING
> rs_maintext.Source = "SELECT * FROM fur_table WHERE acc_type='" +
> Replace(rs_maintext__bedroom, "'", "''") + "' ORDER BY ID"
> rs_maintext.CursorType = 0
> rs_maintext.CursorLocation = 2
> rs_maintext.LockType = 1
> rs_maintext.Open()
>
> rs_maintext_numRows = 0
> %>
> <%
> Dim Recordset1__lounge
> Recordset1__lounge = "lounge"
> If (request("bedroom") <> "") Then
> Recordset1__lounge = request("bedroom")
> End If
> %>
> <%
> Dim Recordset1
> Dim Recordset1_numRows
>
> Set Recordset1 = Server.CreateObject("ADODB.Recordset")
> Recordset1.ActiveConnection = MM_conn_anniem_STRING
> Recordset1.Source = "SELECT * FROM fur_rhm WHERE LHMenu='" +
> Replace(Recordset1__lounge, "'", "''") + "' ORDER BY RHMtitle ASC"
> Recordset1.CursorType = 0
> Recordset1.CursorLocation = 2
> Recordset1.LockType = 1
> Recordset1.Open()
>
> Recordset1_numRows = 0
> %>
> <%
> Dim MM_paramName
> %>
> <%
> ' *** Go To Record and Move To Record: create strings for maintaining URL

and

> Form parameters
>
> Dim MM_keepNone
> Dim MM_keepURL
> Dim MM_keepForm
> Dim MM_keepBoth
>
> Dim MM_removeList
> Dim MM_item
> Dim MM_nextItem
>
> ' create the list of parameters which should not be maintained
> MM_removeList = "&index="
> If (MM_paramName <> "") Then
> MM_removeList = MM_removeList & "&" & MM_paramName & "="
> End If
>
> MM_keepURL=""
> MM_keepForm=""
> MM_keepBoth=""
> MM_keepNone=""
>
> ' add the URL parameters to the MM_keepURL string
> For Each MM_item In Request.QueryString
> MM_nextItem = "&" & MM_item & "="
> If (InStr(1,MM_removeList,MM_nextItem,1) = 0) Then
> MM_keepURL = MM_keepURL & MM_nextItem &
> Server.URLencode(Request.QueryString(MM_item))
> End If
> Next
>
> ' add the Form variables to the MM_keepForm string
> For Each MM_item In Request.Form
> MM_nextItem = "&" & MM_item & "="
> If (InStr(1,MM_removeList,MM_nextItem,1) = 0) Then
> MM_keepForm = MM_keepForm & MM_nextItem &
> Server.URLencode(Request.Form(MM_item))
> End If
> Next
>
> ' create the Form + URL string and remove the intial '&' from each of the
> strings
> MM_keepBoth = MM_keepURL & MM_keepForm
> If (MM_keepBoth <> "") Then
> MM_keepBoth = Right(MM_keepBoth, Len(MM_keepBoth) - 1)
> End If
> If (MM_keepURL <> "") Then
> MM_keepURL = Right(MM_keepURL, Len(MM_keepURL) - 1)
> End If
> If (MM_keepForm <> "") Then
> MM_keepForm = Right(MM_keepForm, Len(MM_keepForm) - 1)
> End If
>
> ' a utility function used for adding additional parameters to these

strings

> Function MM_joinChar(firstItem)
> If (firstItem <> "") Then
> MM_joinChar = "&"
> Else
> MM_joinChar = ""
> End If
> End Function
> %>
> <html><!-- InstanceBegin template="/Templates/inside1.dwt"
> codeOutsideHTMLIsLocked="false" -->
> <head>
> <title>home.jpg</title>
> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
> <!--Fireworks MX 2004 Dreamweaver MX 2004 target. Created Fri Apr 01

09:24:48

> GMT+0100 (GMT Daylight Time) 2005-->
> <style type="text/css">
>
> <!--
> body {
> background-color: #000000;
> margin-left: 0px;
> margin-top: 0px;
> margin-right: 0px;
> margin-bottom: 0px;
> }
> -->
>
>
>
>
>
> -->
> </style>
> <link href="../alltest.css" rel="stylesheet" type="text/css">
> <style type="text/css">
> <!--
> body {
> margin-left: 0px;
> margin-top: 0px;
> margin-right: 0px;
> margin-bottom: 0px;
> background-color: #FFFFFF;
> background-image: url(../images/bg_1.gif);
> }
> -->
> </style></head>
> <body>
> <table width="759" height="100%" border="0" cellpadding="0"

cellspacing="0"

> bgcolor="#ffffff">
> <!-- fwtable fwsrc="HOMEPAGE.PNG" fwbase="home.jpg"

fwstyle="Dreamweaver"

> fwdocid = "742308039" fwnested="0" -->
> <tr>
> <td><img src="../images/space1r.gif" width="161" height="1"

border="0"

> alt=""></td>
> <td><img src="../images/space1r.gif" width="598" height="1"

border="0"

> alt=""></td>
> <td><img src="../images/space1r.gif" width="1" height="1" border="0"
> alt=""></td>
> </tr>
> <tr>
> <td colspan="2" valign="top"><!-- #BeginLibraryItem

"/Library/menubar.lbi"

> -->
> <link href="../alltest.css" rel="stylesheet" type="text/css">
> <table width="756" border="0" cellspacing="0" cellpadding="0">
> <tr>
> <td height="91" valign="bottom" bgcolor="#FFFFFF"><a

href="../index.htm"

> target="_self"><img src="../images/logo.jpg" alt="Annie Mos Logo"

name="Logo"

> width="158" height="46" border="0" id="Logo"></a></td>
> </tr>
> </table>
> <table width="761" height="30" border="0" cellpadding="0"

cellspacing="0">

> <tr>
> <td width="4" height="30" bgcolor="#FFFFFF">&nbsp;</td>
> <td width="181" bgcolor="#A3B390">&nbsp;</td>
> <td width="64" bgcolor="#A3B390" class="offwhite"><a
> href="../index.htm" target="_self" class="offwhite">home</a></td>
> <td width="174" align="center" bgcolor="#A3B390"

class="offwhite"><a

> href="story.htm" target="_self" class="offwhite">the story of annie
> mo's</a></td>
> <td width="139" align="center" bgcolor="#A3B390"

class="offwhite"><a

> href="location.htm" target="_self" class="offwhite">our locations

</a></td>

> <td width="199" align="center" bgcolor="#A3B390"

class="offwhite"><a

> href="wedding.htm" target="_self" class="offwhite">our alternative wedding

list

> </a></td>
> </tr>
> </table>
> <table width="100%" border="0" cellspacing="0" cellpadding="0">
> <tr>
> <td bgcolor="#FFFFFF"><img src="../images/spacer1.jpg" width="7"
> height="3"></td>
> </tr>
> </table>
> <!-- #EndLibraryItem --></td>
> <td><img src="../images/space1r.gif" width="1" height="121"

border="0"

> alt=""></td>
> </tr>
> <tr>
> <td width="161" valign="top"

background="../images/home1_r3_c1.jpg"><table

> width="100%" border="0" cellspacing="0" cellpadding="0">
> <tr>
> <td bgcolor="#FFFFFF"><table width="100%" border="0"

cellspacing="0"

> cellpadding="0">
> <tr>
> <td><table width="100%" border="0" cellspacing="0"
> cellpadding="0">
> <tr>
> <td width="3">&nbsp;</td>
> <td><table width="152" height="152" border="1"
> cellpadding="0" cellspacing="0" bordercolor="#C5CEBA">
> <tr>
> <td> <!-- InstanceBeginEditable

name="furniture" -->

> <table width="152" height="151" border="0"
> cellpadding="0" cellspacing="0">
> <tr>
> <td width="10" rowspan="2"
> bgcolor="#C5CEBA">&nbsp;</td>
> <td height="30" valign="bottom"
> bgcolor="#C5CEBA" class="offgreen"><a href="furniture.htm" target="_self"
> class="ondarkgreen">furniture</a></td>
> </tr>
> <tr>
> <td valign="top" bgcolor="#C5CEBA"><!--
> #BeginLibraryItem "/Library/fur_bedroom.lbi" --><table width="100%"

border="0"

> cellspacing="0" cellpadding="0">
> <tr>
> <td height="20" class="offwhite"><a
> href="fur_lounge.asp" target="_self" class="offwhite">lounge</a></td>
> </tr>
> <tr>
> <td height="20" class="offwhite"><a
> href="fur_dining.asp" target="_self" class="offwhite">dining room</a></td>
> </tr>
> <tr>
> <td height="20" class="offwhite"><a
> href="fur_bedroom.asp" target="_self"

class="whiteselected">bedroom</a></td>

> </tr>
> <tr>
> <td height="20" class="offwhite"><a
> href="fur_hallway.asp" target="_self" class="offwhite">hallway</a></td>
> </tr>
> </table><!-- #EndLibraryItem --></td>
> </tr>
> </table>
> <!-- InstanceEndEditable --></td>
> </tr>
> </table>
> <table width="152" height="3" border="0"

cellpadding="0"

> cellspacing="0">
> <tr>
> <td><img src="../images/menu_spacer.gif"

width="3"

> height="3" alt=""></td>
> </tr>
> </table></td>
> </tr>
> </table></td>
> <td width="3"><img src="../images/spacer22.jpg" width="3"
> height="3"></td>
> </tr>
> </table>
> <table width="100%" border="0" cellspacing="0"

cellpadding="0">

> <tr>
> <td><table width="100%" border="0" cellspacing="0"
> cellpadding="0">
> <tr>
> <td width="3">&nbsp;</td>
> <td><table width="152" height="152" border="1"
> cellpadding="0" cellspacing="0" bordercolor="#C5CEBA">
> <tr>
> <td> <!-- InstanceBeginEditable

name="accessories"

> -->
> <table width="152" height="151" border="0"
> cellpadding="0" cellspacing="0">
> <tr>
> <td width="10" rowspan="2">&nbsp;</td>
> <td height="30" valign="bottom"
> class="offgreen"><a href="accessories.htm" target="_self"
> class="ondarkgreen">accessories</a></td>
> </tr>
> <tr>
> <td valign="top">&nbsp;</td>
> </tr>
> </table>
> <!-- InstanceEndEditable --></td>
> </tr>
> </table>
> <table width="152" height="3" bord