I don't know if you missed my additional comments in the code or not, but just
to re-specify,
You use CFPARAM to set the default to 'na' and when you check the
value (in the else statement) you are checking for 'NA' . Technically, the
two values are different. Does anyone know if the CF default is to check
cases or not? It's the only other idea I can think of...
Michael Ross wrote:
> Yes thats exactly what it should do. But in the first instance I define the
>session.user_name as a unique number. so the next time round it will update the
>table. I know why the query isn't working, it shouldn't be getting the na in the
>first place.
--
Jeff Houser | mailto:[EMAIL PROTECTED]
AIM: Reboog711 | ICQ: 5246969 | Phone: 860-229-2781
--
Instant Cold Fusion 4.5 | ISBN: 0-07-213238-8
Due out 3rd Quarter 2001
--
DotComIt, LLC
database driven web data using ColdFusion, Lotus Notes/Domino
--
Half of the Alternative Folk Acoustic Duo called Far Cry Fly
http://www.farcryfly.com | http://www.mp3.com/FarCryFly
--
Promise me no dead end streets, and I'll guarantee we'll have a road
~~~~~~~~~~~~~ Paid Sponsorship ~~~~~~~~~~~~~
Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free
Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support
Visit SoloServer, https://secure.irides.com/clientsetup.cfm.
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
