What is the value of #FORM.LoanerYN# when you try to insert it in the bit field?
On Thu, Feb 17, 2011 at 8:19 AM, Nicki Tabb <vnt...@alaska.edu> wrote: > > I am testing some code on CF9 before we move all our sites from CF8 and have > come upon this issue. The page that runs the query below is returning an > Invalid Precision Value error. > > <cfqueryparam cfsqltype="cf_sql_bit" value="#FORM.LoanerYN#">, > > I am using SQL Server 2008 (driver is SQL Native client 10.0). This query > works fine on CF8 with the same database but gives the error on the CF9 > installation. From what i can find through searching, this is usually due to > a numeric value or using an Access database. > > Since I am not inserting any numeric values and it's not Access, I'm baffled ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:342418 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm