That's a good plan. I had thought to break the table into two. Thank you for the brain exercise. Julia "Mark Warrick" <[EMAIL PROTECTED]> wrote: Setup a table to store the "flavor of the month" (the category name). Query that table for the value. Then query the original table in the same manner with the value from that query. That's dynamic. ---mark ------------------------------------ Mark Warrick - Fusioneers.com Email: [EMAIL PROTECTED] Phone: 714-547-5386 http://www.fusioneers.com http://www.warrick.net =================================== > -----Original Message----- > From: Julia Phu [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, May 29, 2001 9:45 PM > To: CF-Talk > Subject: Re: [RE: Advices on dynamic SQL, please] > > > Hi, Mark, > > Yes, it was my thought as well. > > I am trying not to hard code the SQL since the product category, or col2, > change monthly. Furthermore, I'm looking for a way to set up a > select box to > display the 'DISTINCT' col2 since there is more than 30 product > category with > 300 rows. This is Oracle 8i database. > > I'm hoping there is a better way for this, so that I can learn > from the guru. > > > Regards, > Julia > > > "Mark Warrick" <[EMAIL PROTECTED]> wrote: > How about: > > select col1, col2, col3, col4 > where col2 = 'abc' > > > Or am I missing something here? > > ---mark > > ------------------------------------ > Mark Warrick - Fusioneers.com > Email: [EMAIL PROTECTED] > Phone: 714-547-5386 > http://www.fusioneers.com > http://www.warrick.net > ===================================> > > -----Original Message----- > > From: Julia Phu [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, May 29, 2001 1:30 PM > > To: CF-Talk > > Subject: Advices on dynamic SQL, please > > > > > > Hi, guru, > > > > I'm seeking your advices for a better solution on dynamic SQL (I guess). > > > > Users want to select ABC from a form to view anything under ABC. > > What is your > > advices on how to handle it? > > > > Table A: > > col1 col2 col3 col4 > > aa ABC XY description1 > > ab ABC XY description2 > > ac ABC XX description3 > > ad ABC 00 description4 > > ae DEF XY description1 > > af DEF YZ description2 > > ag DEF 00 description3 > > > > Your input is greatly appreciated. > > > > Julia Phu > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
