Jaesin
asked on
drilling down data using coldfusion, whats the best approach?
First, thank you for having a look at my question..
I have recently began playing with CF8 using the developers edition on my local machine, and am trying to find the best way to perform a data drill down.
I have a fairly complex Access database (it will be converted to MSSQL eventually) that contains my products database and all of the products attributes. Being fairly large, I am in need of a way to select the product attributes I am looking for and drilling down the product list.
In example If I select attribute #1, I wish to see a list of only products that contain attribute 1, if I choose a additional attribute #5, then only products containing both attributes would be shown.
I am working on hetting this first test deployed, and then will work on being able flag the drilled product field for display.
I am new to CF, so any direction written or shown is greatly appreciated. I had heard that this place was a great resource to a begginer with questions.
Thank you again.
I have recently began playing with CF8 using the developers edition on my local machine, and am trying to find the best way to perform a data drill down.
I have a fairly complex Access database (it will be converted to MSSQL eventually) that contains my products database and all of the products attributes. Being fairly large, I am in need of a way to select the product attributes I am looking for and drilling down the product list.
In example If I select attribute #1, I wish to see a list of only products that contain attribute 1, if I choose a additional attribute #5, then only products containing both attributes would be shown.
I am working on hetting this first test deployed, and then will work on being able flag the drilled product field for display.
I am new to CF, so any direction written or shown is greatly appreciated. I had heard that this place was a great resource to a begginer with questions.
Thank you again.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Scott Bennett
Just noticed that I didn't put a submit button on my example =) you would probably want to add that. Also if you have a lot of products you would also probably want to add pagination to the results.
ASKER
Thanks for the corrction on the term "drill down", I was not quite sure if it was the rigt terminilogy for what I needed, however I am quite surprised that a form may just do the job or me, and I thank you for the snippet of code that helps me see a basic structure to do this. I was under the impression that I would have to incorporate AJAX and/or Javascript to get this to work for me.
I have one additional question:
My database has allot of fields to filter down, trying to add them all to a form looks like I likely would just run out of realestate on the page. Any recomendations on how i should go about this?
I have one additional question:
My database has allot of fields to filter down, trying to add them all to a form looks like I likely would just run out of realestate on the page. Any recomendations on how i should go about this?
You could separate the filters for into a page of its own instead of having them at the top of the page and show the results on a second page. for example, If you take a look at pretty much any realestate/apartment search site you can do an "advanced seach" that will give you a whole page full of check boxes to filter by different ammenities the property has to offer.
Then when they submit the form, save their search criteria in the session scope and use that while you are paginating them throught the results.
Then when they submit the form, save their search criteria in the session scope and use that while you are paginating them throught the results.