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