Wrox Programmer Forums
|
BOOK: Beginning Dreamweaver MX/MX 2004 MX ISBN: 978-0-7645-4404-0; MX 2004 ISBN: 978-0-7645-5524-4
This is the forum to discuss the Wrox book Beginning Dreamweaver MX by Charles E. Brown, Imar Spaanjaars, Todd Marks; ISBN: 9780764544040
Please indicate which version of the book you are using when posting questions.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning Dreamweaver MX/MX 2004 MX ISBN: 978-0-7645-4404-0; MX 2004 ISBN: 978-0-7645-5524-4 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old December 15th, 2005, 03:50 AM
Authorized User
 
Join Date: Aug 2005
Posts: 20
Thanks: 0
Thanked 0 Times in 0 Posts
Default Results Page Error

Looking for suggestion.

Have a results.asp page and detail.asp page.

Results page shows 4 results on every search.

When clicking on the detail link the same results come up every time.

Eg:
- Result = Fred Lamone
- Detail Page Result = Fred Lamone 21 Mithel St Hawthorn.

- Result = Trish Baily
- Detail Page Result = Fred Lamone 21 Mithel St Hawthorn.

- Result = Troy Gale
- Detail Page Result = Fred Lamone 21 Mithel St Hawthorn.

Note the Detail results are the same. They should all be different.
 
Old December 15th, 2005, 04:48 AM
Imar's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

Hi Katachi,

Is this related to the book Beginning Dreamweaver MX 2004? If not, you might be better off posting these kind of questions in the Dreamweaver forum located here: http://p2p.wrox.com/forum.asp?FORUM_ID=51

That said, are you passing the right Id from the list page to the details page? How does your code look like?

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
 
Old December 15th, 2005, 05:26 AM
Authorized User
 
Join Date: Aug 2005
Posts: 20
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi
Pages I have are enquiry.asp, results.asp, & productdescription.asp pages. Do you mean am I passing the right Id from the results page to the productdescription page?

This is the code for the Go To Detail Page.

<A HREF="productDescription.asp?<%= MM_keepNone & MM_joinChar(MM_keepNone) & "CustomerName=" & rsSearchResult.Fields.Item("CustomerName").Value %>">More
Details</A>

 
Old December 15th, 2005, 05:33 AM
Imar's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

You seem to be passing the CustomerName to the details page. Is that the best option? Does the Customer have a unique ID? It's better to pass an ID because the name can contain spaces or other characters that can mess up the query.

Then in the details page, use the ID from the query string to query the right customer record.

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
 
Old December 15th, 2005, 06:31 AM
Authorized User
 
Join Date: Aug 2005
Posts: 20
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I see, so by the detail page are you are refering to the productDescription.asp page?

 
Old December 15th, 2005, 06:56 AM
Imar's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

Yeah, I think so, but only you can be sure about that. In your first post you mentioned detail.asp but later you used productDescription.asp so I can only assume you're talking about the same page....

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
 
Old December 15th, 2005, 07:10 AM
Authorized User
 
Join Date: Aug 2005
Posts: 20
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hmmm

Rather than pass the customer name from the Bindings pannel I have passed instead the idCustomer field. Still get the same result, but rather than seeing the customer name I see the customer id number.

Eg: Name: 5



 
Old December 15th, 2005, 07:19 AM
Authorized User
 
Join Date: Aug 2005
Posts: 20
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Very strange.

Also in the URL i get the correct result that the detail page is looking for.

/html/productDescription.asp?CustomerName=Bobs%20Consult ing.

But the details on the page are incorrect.





 
Old December 15th, 2005, 04:57 PM
Imar's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

I think you better post the relevant parts of the code for both the list and details pages....

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
 
Old December 16th, 2005, 03:44 AM
Authorized User
 
Join Date: Aug 2005
Posts: 20
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Ok.

Are you talking about the recordset code for the list page and the details page ?






Similar Threads
Thread Thread Starter Forum Replies Last Post
Search box on a Database results page meichmann ASP.NET 2.0 Basics 3 April 2nd, 2008 10:25 AM
Easier page navigation of search results gs99 Forum and Wrox.com Feedback 0 February 2nd, 2007 09:38 PM
next and previous page results mikeuk PHP Databases 1 July 19th, 2004 05:15 AM
X Results per Page acdsky Classic ASP Databases 2 June 21st, 2004 10:38 AM
Results Page always returns '0 found' jonrayworth Dreamweaver (all versions) 4 November 9th, 2003 05:48 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.