cfoutput group

[Guest]

Hi i have a webpage

http://www.southerncooling.com/NEW.cfm

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?

[Zanzibar96]

Tried to look at page link but you have a "Could not connect to JRun server"

[Guest]

hi should be ok now

[Zanzibar96]

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.

[Guest]

ok many thanks

if you look now at
http://www.southerncooling.com/NEW.cfm

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?

[Zanzibar96]

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

[Guest]

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
</cfquery>