2 Replies Latest reply on Aug 16, 2007 11:49 PM by Newsgroup_User

    goto Detail Page does not work right

    Level 7
      Hi there,

      DM CS3 and PHP with mySQL database. I have downloaded from
      http://www.dengjie.com wich appears to work fine.

      I got this right but after upgrading to CS3 from version 8, my goto
      detail page does not work.

      I have a results page which works fine.
      I have a link on the results page that says: mere details >>
      For this "Goto Details page" I have used the SB above.
      When I hover my mouse over the link, it displays the correct ID of the
      products who's details I want to display.

      BUT, when clicking on the more details >> link, it takes me to the very
      first record; everytime.

      Can someone please shed some light here for me, please. It's very
      frustrating getting this right a couple of times and now cannot find the
      fault.

      Regards,
      Deon
        • 1. Re: goto Detail Page does not work right
          Level 7
          Going to the first record is usually improper filtering of the SQL statement
          or an improper request.


          --
          Nancy Gill
          Adobe Community Expert
          Author: Dreamweaver 8 e-book for the DMX Zone
          Co-Author: Dreamweaver MX: Instant Troubleshooter (August, 2003)
          Technical Editor: Dreamweaver CS3: The Missing Manual,
          DMX 2004: The Complete Reference, DMX 2004: A Beginner's Guide
          Mastering Macromedia Contribute
          Technical Reviewer: Dynamic Dreamweaver MX/DMX: Advanced PHP Web Development

          "Deon" <deonNOSPAM@sincro.co.za> wrote in message
          news:Xns998F3D98EA71EdeonNOSPAMsincrocoza@216.104.212.96...
          > Hi there,
          >
          > DM CS3 and PHP with mySQL database. I have downloaded from
          > http://www.dengjie.com wich appears to work fine.
          >
          > I got this right but after upgrading to CS3 from version 8, my goto
          > detail page does not work.
          >
          > I have a results page which works fine.
          > I have a link on the results page that says: mere details >>
          > For this "Goto Details page" I have used the SB above.
          > When I hover my mouse over the link, it displays the correct ID of the
          > products who's details I want to display.
          >
          > BUT, when clicking on the more details >> link, it takes me to the very
          > first record; everytime.
          >
          > Can someone please shed some light here for me, please. It's very
          > frustrating getting this right a couple of times and now cannot find the
          > fault.
          >
          > Regards,
          > Deon


          • 2. Re: goto Detail Page does not work right
            Level 7
            "Nancy - Adobe Comm. Expert" <nancy@webwish.com> wrote in
            news:fa3d9p$mgl$1@forums.macromedia.com:

            Nancy,
            thank you, I think I fixed this.
            Next problem ... Details page does not show any data.
            I have a details page. This is the SQL for the details page:
            SELECT *
            FROM alternators
            WHERE p_ID = colname

            Variables as follows:
            Name: colname
            Type: Text
            Default Value: -1
            Runtime-Value: $_GET['p_ID']

            The mySQL DB has a Primary Key for p_ID.
            My go to details page has the correct link, but it displays no data. I
            did bind words to the different fields in the RS.

            I will really appreciate any suggestions.

            Regards,
            Deon