I have done this a few times with URL parameters and cfif's in the where clause and had no problems...That is about the easiest way to go about it I think.
Jim Vosika http://tinyclick.com Free URL Shortening! -----Original Message----- From: Yexley Robert D Contr Det 1 AFRL/WSI [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 30, 2002 1:35 PM To: CF-Talk Subject: Filtering query results In the application that I'm working on, I have a need to filter the results of a query that get displayed on the screen, changing the selectable options for the user. I have a default query that populates a SELECT list, and under that list I have three hyperlinks that will allow a user to click on them to execute a different query to show different results in the list for them to choose from. I'm still pretty new to ColdFusion, and I'm not really sure what's the best way to implement this functionality, and was hoping for some ideas from anyone. The query that gets executed is basically the same, only the WHERE clause changes. I've tried just dynamically changing the WHERE clause using <cfif> checking based on a URL parameter, but didn't have much luck with that. Then I tried actually creating the three separate queries, and just changing the query parameter of my loop for the list values, using <cfswitch> checking to set the query parameter based on a URL parameter. That didn't give me much luck either. I'm just not sure how to best go about doing this. Does anyone happen to know of any articles online, or tutorials that might explain something close to how to do this? How to I create a .cfm page to accept a parameter by default to tell it which query to execute? Any help or thoughts would be greatly appreciated. Thanks. ::YEX:: /* || Robert D. Yexley || Oracle Programmer/Analyst || Easylink Services Corporation || Professional Services || Contractor - Wright Research Site MIS || Det-1 AFRL/WSI Bldg. 45 Rm. 062 || (937) 255-1984 || [EMAIL PROTECTED] || <)))>< */ <<Robert D. Yexley (E-mail).vcf>> ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
