Surely a bit field will need 0 or 1, not a string? Or was that not what you meant?
----- Original Message ---- From: Nicki Tabb <vnt...@alaska.edu> To: cf-talk <cf-talk@houseoffusion.com> Sent: Fri, 18 February, 2011 15:32:19 Subject: Re: Invalid Precision Value from SQL Server & CF9 The default is NO so it always has a value > What is the value of #FORM.LoanerYN# when you try to insert it in the > bit field? > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:342433 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm