This content has been marked as final. Show 4 replies
If you cfdump your query, do you appear to be getting the data?
dont know how to do a cfdump, but it cfoutputs fine, just need to sort out showing all model numbers for each product
Do you know how to use the group attribute of cfoutput? There is an excellent example in the cfml reference manual. Google <cfoutput> and you should find it quickly.
Google <cfdump> also. It's a handy development tool.
Hi Dan, yes i am using the group in cfoutput but because i only want to display Part Numbers that only have the model numbers that the user has selected.
so if a user selects model EXH130
it will show all Part No like this
034444 model EXH130, 150, GFF170
034445 model EXH120, EXH130, GFF170
so it shows all model numbers not just the users selection what it is now
in my query i have
AND MT.Model_ID = '#session.ModelNo#'
this stops all the model numbers showing, can i have something instead saying
where '#session.ModelNo#' appears in MT.Model_ID