Category drop-downs? Don't you split those up into their own
separate tables? If you're using distinct to create them, it
sounds like you need some more normalization to your db.
Jon Hall wrote:
>
> I hope for one that CFSQL supports the DISTINCT statement. Would make those
> category drop downs a breeze...
>
> jon
> ----- Original Message -----
> From: "Dave Watts" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Tuesday, December 05, 2000 6:03 PM
> Subject: RE: ColdFusion for Dummies revision - CF5 features
>
> > > Absent good information we've been speculating about the
> > > CF5 ability to query a query. It may not be written to
> > > emulate anything and to do no more than allow simple
> > > look-ups and other low-level ops that are not currently
> > > part of the functions toolbox. Has anyone stated that
> > > we are getting a full blown inline analyzer? Could be just
> > > an expansion of Queryxxx function set.
> >
> > It could be, but they're calling it "CFSQL", so that sounds like SQL
> > statements to me.
> >
> > Dave Watts, CTO, Fig Leaf Software
> > http://www.figleaf.com/
> > voice: (202) 797-5496
> > fax: (202) 797-5444
> >
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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