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