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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
