Works like a charm!  Thanks, guys!

Rick

> -----Original Message-----
> From: Dominic Watson [mailto:[EMAIL PROTECTED]
> Sent: Thursday, April 24, 2008 12:39 PM
> To: CF-Talk
> Subject: Re: Need some advice on speeding up query...
> 
> Yup, not sure I'd call it a variable, but yes ;) (perhaps dataset cell
> / column, dunno!). Try adding it to your big ol Union query (will have
> to be in each table) and run it - should then make perfect sense.
> 
> Dominic
> 
> On 24/04/2008, Rick Faircloth <[EMAIL PROTECTED]> wrote:
> > Oh, wait... perhaps I'm missing the obvious.
> >
> > In:
> >
> > SELECT   sa.*,
> >               'acr' as propertyType
> > FROM     smlc_acr sa
> >
> > You're just explicitly assigning the value acr
> > to the variable, "propertyType".  Right?
> >
> >
> > Rick
> >
> >
> >
> > > -----Original Message-----
> > > From: Dominic Watson [mailto:[EMAIL PROTECTED]
> > > Sent: Thursday, April 24, 2008 12:02 PM
> > > To: CF-Talk
> > > Subject: Re: Need some advice on speeding up query...
> > >
> > > > I don't understand that, Dominic.
> > > >
> > > > What does the 'acr' refer to?
> > >
> > > It's just a string, it doesn't *refer* to anything and it could be set
> > > to anything you want - I set it to 'acr' because the table was called
> > > smlc_acr.
> > >
> > > So what I am doing there is selecting a 'propertyType' based on the
> > > table that I am selecting from.
> > >
> > > Make sense?
> > >
> > > Dominic
> > >
> > > --
> > > Blog it up: http://fusion.dominicwatson.co.uk
> > >
> > >
> >
> >
> 
> 

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304192
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Reply via email to