• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

Results Output

Guest
Jan 16, 2007 Jan 16, 2007

Copy link to clipboard

Copied

Hi i have a results page which i need a little help with,

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

this show results that match what the user selected which is what i want

but i want to display all the range and models for the product as shown here
http://www.southerncooling.com/ProductResults.cfm

ie if a user selects EXD-170 it needs to show products like this

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

showing the other models aswell, i have tried outer joins but still no luck

any ideas what i need to do

many thanks

John
TOPICS
Advanced techniques

Views

372

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Jan 16, 2007 Jan 16, 2007

Copy link to clipboard

Copied

If you cfdump your query, do you appear to be getting the data?

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Guest
Jan 16, 2007 Jan 16, 2007

Copy link to clipboard

Copied

Hi Dan

dont know how to do a cfdump, but it cfoutputs fine, just need to sort out showing all model numbers for each product

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Jan 16, 2007 Jan 16, 2007

Copy link to clipboard

Copied

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.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Guest
Jan 16, 2007 Jan 16, 2007

Copy link to clipboard

Copied

LATEST
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

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

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

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Resources
Documentation