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:304183
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
