Forums
This topic is locked
GoToRelatedPage Problem
Posted 17 Sep 2001 01:11:30
1
has voted
17 Sep 2001 01:11:30 Jim Crowder posted:
This code works except for the problem mentioned initems 1 and 2...
I have a Dynamic "Link" on a table in SupplierProduct.asp with the following code:
javascript: MM_openBrWindow('DisplaySuppliers.asp?<%= MM_keepURL & MM_joinChar(MM_keepURL) & "SupplierName=" & rsSupplierProductsAll.Fields.Item("SupplierName".Value %>','Display','scrollbars=yes,resizable=yes,width=350,height=300')
When I click on the link it Works for all SupplierName EXCEPT the following:
Not sure what this means :
1. "Error on Page" when there is an ' in the SupplierName...
or how to fix this :
2. Page cannot be displayed: (Yes, something is stripping out the &...) and this is the message from the Browser:
GET /ASP/DisplaySuppliers.asp?Pillsbury%20Bakeries%20&%20Foodservice=&SupplierName=Pillsbury%20Bakeries%20&%20Foodservice
But it should be searching for "Pillsbury Bakeries & Foodservice"
What am I doing wrong?
Any help would be greatly appreciated...
Replies
Replied 17 Sep 2001 03:27:17
17 Sep 2001 03:27:17 Owen Eastwick replied:
Presumably the suppliers table has a supplier ID field with a unique number for each supplier. Use this as the link. For example:
<pre id=code><font face=courier size=2 id=code>
MM_openBrWindow('DisplaySuppliers.asp?"SupplierID ="<% = rsSupplierProductsAll.Fields.Item("SupplierID".Value %>
</font id=code></pre id=code>
Then on the results page set up a recordset with an SQL statement something like:
"SELECT *
FROM Supplier details
WHERE SupplierID =" & Request.QueryString("SupplierID"
Regards
Owen.
Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo
<pre id=code><font face=courier size=2 id=code>
MM_openBrWindow('DisplaySuppliers.asp?"SupplierID ="<% = rsSupplierProductsAll.Fields.Item("SupplierID".Value %>
</font id=code></pre id=code>
Then on the results page set up a recordset with an SQL statement something like:
"SELECT *
FROM Supplier details
WHERE SupplierID =" & Request.QueryString("SupplierID"
Regards
Owen.
Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo