I created another test table and it works fine....soooooo now I just need to
figure out why the Numeric fields in my production table is different than
the Numeric in my test table....
Thanks for all the help/suggestions..
Adrian
-----Original Message-----
From: Caulfield, Michael [mailto:[EMAIL PROTECTED]]
I've actually run the query successfully from 4.5 and 5.0b1 -- I'm thinking
we might be in bug territory.
Rename the column from switch to something else, in case there is some CF
confusion regarding switch-case (i.e. a bug in 4.01). I know that sounds
implausible, but I can't replicate the error here with later versions, and
I'm out of ideas.
And I would also run Dave's example, (SELECT LEFT(123456,3) + '1' +
right(123456, len(123456) -4) as test) to see if the problem is specific to
your table, or if it's the syntax that's bombing.
HTH,
Michael Caulfield
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
