This content has been marked as final. Show 6 replies
Tried to look at page link but you have a "Could not connect to JRun server"
hi should be ok now
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.
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?
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
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#">
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