I get this error:
Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC SQL Server
Driver]Invalid precision value
With this query:
<cfquery name="qry" datasource="#this.DSN#" result="qryResult">
INSERT INTO contest
(
name,email,phone,age,score,addeddate
)
VALUES
(
<cfqueryparam cfsqltype="CF_SQL_VARCHAR"
value="#ARGUMENTS.userName#" />,
<cfqueryparam cfsqltype="CF_SQL_VARCHAR"
value="#ARGUMENTS.userEmail#" />,
<cfqueryparam cfsqltype="CF_SQL_VARCHAR"
value="#ARGUMENTS.phone#" />,
<cfqueryparam cfsqltype="CF_SQL_INTEGER"
value="#ARGUMENTS.age#" />,
<cfqueryparam cfsqltype="CF_SQL_INTEGER"
value="#ARGUMENTS.score#" />,
<cfqueryparam
value="#createodbcdatetime(now())#" cfsqltype="CF_SQL_TIMESTAMP">
)
</cfquery>
If I remove the addeddate column it works. I have done this before without
issue. It is an odbc socket connection.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327147
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
