Yep sorry I left out 1 # Glad its working.
Paul On Aug 16, 2009, at 9:35 PM, John Barrett wrote: > > 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:4715 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
