the problem was that coldfusion was caching the database structure so it didn't know that field was there. After the cache was cleared, everything works.
At 11:38 AM 11/12/2010, you wrote: >That table has USER ID (varchar) , PASSWORD (varchar) and a bunch of >bit fields (default value (0)). No dates. > >Regardless, the error just went away. > >Thanks > >Robert B. Harrison >Director of Interactive Services >Austin & Williams >125 Kennedy Drive, Suite 100 >Hauppauge NY 11788 >P : 631.231.6600 Ext. 119 >F : 631.434.7022 >http://www.austin-williams.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339162 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm