I have tested the query using 0 instead of No for the default form value (see
reply thread) and I am still receiving the Invalid Precision Value error.
In the error, it highlights the last line as the issue (although sometimes that
is deceiving)
<cfqueryparam cfsqltype="cf_sql_varchar" value="#FORM.Notes#" maxlength="1000">
I've seen forums that say this error is seen when using MS Access, but I am
using SQL Server 2008.
thanks,
nicki
> 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:342473
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
