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.
<cfquery name="addVRRF" datasource="eworfs">
INSERT INTO VRRFs (RequestDateTime, Name, Email, Phone, Department, ENum,
MilesHours, Urgency, VLocation, RepairDate, LoanerYN, Notes)
VALUES (<cfqueryparam cfsqltype="cf_sql_timestamp" value="#now()#">,
<cfqueryparam cfsqltype="cf_sql_varchar" value="#FORM.name#" maxlength="50">,
<cfqueryparam cfsqltype="cf_sql_varchar" value="#FORM.email#" maxlength="150">,
<cfqueryparam cfsqltype="cf_sql_varchar" value="#FORM.phone#" maxlength="12">,
<cfqueryparam cfsqltype="cf_sql_varchar" value="#FORM.Department#"
maxlength="50">,
<cfqueryparam cfsqltype="cf_sql_varchar" value="#FORM.ENum#" maxlength="50">,
<cfqueryparam cfsqltype="cf_sql_varchar" value="#FORM.MilesHours#"
maxlength="50">,
<cfqueryparam cfsqltype="cf_sql_varchar" value="#FORM.Urgency#"
maxlength="10">,
<cfqueryparam cfsqltype="cf_sql_varchar" value="#FORM.VLocation#"
maxlength="150">,
<cfqueryparam cfsqltype="cf_sql_timestamp" value="#FORM.RepairDate#"
null="#iif((FORM.RepairDate eq ""), de("yes"), de("no"))#">,
<cfqueryparam cfsqltype="cf_sql_bit" value="#FORM.LoanerYN#">,
<cfqueryparam cfsqltype="cf_sql_varchar" value="#FORM.Notes#"
maxlength="1000">)
</cfquery>
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.
Any ideas greatly appreciated!
Thanks,
Nicki
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:342384
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
