Hi John,
<cfquery datasource="myDSN#">
INSERT INTO test( someDate )
VALUES ( <cfqueryparam cfsqltype="cf_sql_timestamp"
value="#now()" )
</cfquery>
Will work. The earlier screen shot of your DB did not show dateTime
at the type though you may want to re-check that.
Paul
On Aug 16, 2009, at 8:08 PM, John Barrett wrote:
>
> Hi paul,
> thanks so much for your help.
> yes the database is set to dateTime.
>
> I removed the cfqueryparam for now as I am just trying to get it
> working. I figured I would add that later, after the form is
> functional.
>
> Do you have a example that simply writes the date to a DB? or should
> my example actually work?
> Thanks again for your help,
> John
>
> On Aug 16, 2009, at 2:03 PM, Paul Kukiel wrote:
>
>>
>> John is the type on the database for the date "DateTime"
>>
>> Also it is a very good idea to use cfqueryparam for every item you
>> are
>> inserting into he database.
>>
>> Paul..
>>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:4713
Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
