Maybe a auto-normalizer to coalesce 'us', 'usa', and 'united states'?
In your SELECT clause....
IF(state IN ('us', 'usa', 'united states'), 'usa', state) AS state
cheers,
banreyb
On 8/1/06, Matt Williams <[EMAIL PROTECTED]> wrote:
> Had an issue with state. I fixed it and added in what I could based on City.
>
> On 8/1/06, Andy Matthews <[EMAIL PROTECTED]> wrote:
> >
> > Looks like the state is either not being saved, or not being displayed.
> >
> > Just FYI.
> >
> > <!----------------//------
> > andy matthews
> > web developer
> > certified advanced coldfusion programmer
> > ICGLink, Inc.
> > [EMAIL PROTECTED]
> > 615.370.1530 x737
> > --------------//--------->
> >
> > -----Original Message-----
> > From: Matt Williams [mailto:[EMAIL PROTECTED]
> > Sent: Tuesday, August 01, 2006 11:36 AM
> > To: CF-Talk
> > Subject: Unofficial CF Developer Salary Survey
> >
> >
> > Come one, come all...
> > An anonymous salary survey is available at
> >
> > http://keysym.org/cfs
> >
> > I didn't bother with any validation, so if you try to break it, you
> > probably
> > will. :)
> >
> > I'll leave it up for a few days so people will have time and for those in
> > other time zones, etc.
> >
> > Matt
> >
> >
> > On 8/1/06, PETER SHEATS <[EMAIL PROTECTED]> wrote:
> > >
> > > Wow, all this for me? Thanks =)
> > >
> > > I don't think I should answer it since it'll bring the average way
> > > down...
> > >
> > > Peter Sheats
> > >
> > >
> > --
> > Matt Williams
> > "It's the question that drives us."
> >
> >
> >
> >
> >
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:248502
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
