Hi Paul,
I changed it to this (to match my DB):
<cfquery datasource="#REQUEST.dataSource#">
INSERT INTO test(date_entered)
VALUES(<cfqueryparam cfsqltype="cf_sql_timestamp"
value="#now()#")
</cfquery>
I think that you were missing the hash on the now function.
When I runt he example I get a ")" invalid token. I tried with the
parenthesis around the VALEUS, and with ' instead of "
Thanks,
John
On Aug 16, 2009, at 2:33 PM, Paul Kukiel wrote:
> <cfquery datasource="myDSN#">
> INSERT INTO test( someDate )
> VALUES ( <cfqueryparam cfsqltype="cf_sql_timestamp"
> value="#now()" )
> </cfquery>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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-newbie/message.cfm/messageid:4714
Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
