Try the SQL Server function "GETDATE()" instead of a queryparam On Tue, Oct 13, 2009 at 3:01 PM, Matthew Smith <[email protected]>wrote:
> > 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:327148 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
