6 Replies Latest reply on Jan 24, 2007 1:38 PM by JohnGree

    cfoutput group

    JohnGree Level 1
      Hi i have a webpage


      the first model "505350 Tank Beige" should show EXH-130, 150, 170, 190, 210, EXD-150, 170, 210

      but i am get duplicates

      any ideas why this is?
        • 1. Re: cfoutput group
          Tried to look at page link but you have a "Could not connect to JRun server"

          • 2. Re: cfoutput group
            JohnGree Level 1
            hi should be ok now
            • 3. Re: cfoutput group
              Zanzibar96 Level 1
              Try taking all your outputting code out and add them all back one by one. I believe the multiple CFoutputs are causing the duplicates to show. You could also test SQL statement in DB to see what results are as inner joins can sometimes bring back multiple results.

              Start with SQL statement. If it doesn't bring back dupes then it's Cfoutput code.

              Hope this helps.
              • 4. Re: cfoutput group
                JohnGree Level 1
                ok many thanks

                if you look now at

                the first record should show

                505350 EXH-130, 150, 170, 190, 210 EXD-130, 150, 170, 190, 210

                but it only shows the first one EXH-130, 150, 170, 190, 210,

                as soon as put a cfoutput in i get a totlly wrong result, is my query ok?
                • 5. Re: cfoutput group
                  Zanzibar96 Level 1
                  I get an error when I go to the page. Try building query with just the first select and from part and then add one inner join to see if you get the correct result. I know a few times in my past I had inner joins that were pulling duplicate information. It could be so simple as exchanging what is being inner joined.
                  If you want to send me a copy of the db you can do so here: alfior73 at yahoo.com
                  • 6. Re: cfoutput group
                    JohnGree Level 1
                    ok thanks i will forward u a copy, should i just do a cfdump of the mysql database?

                    i have played around with the query this is want i have now but still only shows 1 result for each partno

                    <cfquery name="Products" datasource="#application.ds#">
                    SELECT *
                    FROM Products_Table PT

                    INNER JOIN Range_Model RM
                    ON RM.Product_ID64 = PT.Products_ID

                    INNER JOIN Range_table RT
                    ON RM.Range_ID64 = RT.Range_ID

                    INNER JOIN Model_Table MT
                    ON MT.Model_ID = RM.Model_ID64

                    ORDER BY Range_Name