Hall of Fame

1. jason11783,500
2. carrzkiss2,080
3. duncancu...2,000
3. easynow...2,000
3. SidFishes2,000
3. Jonbysoft2,000
3. azadisaryev2,000
8. _agx_1,775
9. guswebb1,500
10. ChetOS821,250
11. glumlun1,000
11. quizengine1,000
11. 8080_...1,000
14. acperkins700
15. Jones911600
16. gawai500
16. Morcalavin500
16. LZ1500

1. ericpete29,154
2. ryancys14,760
3. hongjun13,850
4. jason117810,500
5. sherly6,630
6. inthe3,280
7. fabianm3,000
8. ravi_raj1...2,750
9. Bit_Twid...2,500
10. F3502,190
11. carrzkiss2,080
12. duncancu...2,000
12. BraveBrain2,000
12. MediaMac...2,000
12. Rouchie2,000
12. easynow...2,000
12. Smart_Man2,000
12. SidFishes2,000
12. bluV11t2,000
12. gamebits2,000
12. smidgie822,000
12. D3SIGN3R2,000
12. Jonbysoft2,000
12. eszaq2,000
12. azadisaryev2,000

	[x] Posted via EE Mobile
	Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.

Question

	[x] Attachment Details

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

5.8

going to detail page not showing correct data

Asked by morya in Macromedia UltraDev

Tags: asp, variable

I'm new to working with asp, but have worked with UltraDev 4 for awhile. Here is my problem:

I have a product_list.asp page that lists, among other things, the merchant and the product title. Both are clickable links.

Clicking on the merchant link correctly takes one to the merchant_detail.asp page with all content/data shown correctly.

Clicking on the product title correctly take me to the product_details.asp page but on that page I also have the merchant name displayed.

The problem I am having is that the merchant name is not showing up accurately. It is not giving me the merchant name that correctly corresponds to the product title. I'm just getting a name out of the database and it is the same name regardless of what product title I click on in the product_list.asp page.

If you would like to look at the code UltraDev generates here is the top section of product_list.asp:

<%
set rsProducts = Server.CreateObject("ADODB.Recordset")
rsProducts.ActiveConnection = MM_dsnMarketplace_STRING
rsProducts.Source = "SELECT Merchants.Merchants, ProductList.Image, ProductList.ProductID, ProductList.ProdTitle, ProductList.Description, ProductList.CategoryID, ProductList.SupplierID, ProductList.SerialNum, ProductList.ProdType, ProductList.SalePrice, ProductList.UnitPrice, ProductList.ProdTitle, * FROM Merchants INNER JOIN ProductList ON Merchants.SupplierID = ProductList.SupplierID WHERE (([ProductList]![CategoryID]='Angel')) ORDER BY ProductList.ProdTitle"
rsProducts.CursorType = 0
rsProducts.CursorLocation = 2
rsProducts.LockType = 3
rsProducts.Open()
rsProducts_numRows = 0
%>
<%
Dim Repeat1__numRows
Repeat1__numRows = 10
Dim Repeat1__index
Repeat1__index = 0
rsProducts_numRows = rsProducts_numRows + Repeat1__numRows
%>
<%
' *** Go To Record and Move To Record: create strings for maintaining URL and Form parameters

' create the list of parameters which should not be maintained
MM_removeList = "&index="
If (MM_paramName <> "") Then MM_removeList = MM_removeList & "&" & MM_paramName & "="
MM_keepURL="":MM_keepForm="":MM_keepBoth="":MM_keepNone=""

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

' add the Form variables to the MM_keepForm string
For Each Item In Request.Form
NextItem = "&" & Item & "="
If (InStr(1,MM_removeList,NextItem,1) = 0) Then
MM_keepForm = MM_keepForm & NextItem & Server.URLencode(Request.Form(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)
if (MM_keepURL <> "") Then MM_keepURL = Right(MM_keepURL, Len(MM_keepURL) - 1)
if (MM_keepForm <> "") Then MM_keepForm = Right(MM_keepForm, Len(MM_keepForm) - 1)

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

and here is the body:

<%=(rsProducts.Fields.Item("CategoryID").Value)%> Product List:
<table width="90%" border="0" cellspacing="0" cellpadding="3">
<tr>
<%
While ((Repeat1__numRows <> 0) AND (NOT rsProducts.EOF))
%>
<td>
<img src="<%=(rsProducts.Fields.Item("Image").Value)%>">
 
Title: <A HREF="product_details.asp?<%= MM_keepNone & MM_joinChar(MM_keepNone) & "ProductID=" & rsProducts.Fields.Item("ProductID").Value %>"></A><%=(rsProducts.Fields.Item("ProdTitle").Value)%> 
Type: <%=(rsProducts.Fields.Item("ProdType").Value)%> 
Created By: <A HREF="merchant_detail.asp?<%= MM_keepNone & MM_joinChar(MM_keepNone) & "SupplierID=" & rsProducts.Fields.Item("SupplierID").Value %>"><%=(rsProducts.Fields.Item("Merchants").Value)%></A> 
  
</td>
<%
Repeat1__index=Repeat1__index+1
Repeat1__numRows=Repeat1__numRows-1
rsProducts.MoveNext()
Wend
%>

Thank you for your help.
Michael

View the Solution FREE for 30 Days

going to detail page not showing correct data

Asked by morya in Macromedia UltraDev

Tags: asp, variable

About this solution