>It's usually not a good idea to use function names as variable names.
>Date is a function in almost every language. URL is a function in
>quite a few. So I would rename both of those variables.
>
>
>> John
Thanks Maureen:)
I just changed the URL field to webSite.
However, the form is no longer working.
Is it really this hard to write a date to a database? I don't care about the
format.
To write a date to a cfm page:
<cfset date_entered="#CreateODBCDate(Now())#">
<cfoutput>#date_entered#</cfoutput>
out put on the page is - {d '2009-08-16'}
when I try to do this in a cfquery
<cfset date_entered="#CreateODBCDateTime(Now())#">
<!--- Insert tip into the database --->
<cfquery datasource="#REQUEST.dataSource#">
INSERT INTO test(text,webSite,desc,cat,date_entered)
VALUES('#FORM.text#','#FORM.webSite#','#FORM.desc#','health',#date_entered#)
</cfquery>
it does not seem to work.
I would think that writing a date to a database is so common, but I can't find
any examples in the docs, unless I am missing something.
really need to figure this out, and I have been trying for 2 days now.
I get this error (de bugging is turned on):
Error Executing Database Query.
You have an error in your SQL syntax; check the manual that corresponds to your
MySQL server version for the right syntax to use near 'desc,cat,date_entered)
VALUES('CF Talk','http://www.houseoffus' at line 1
The error occurred in
/Users/johnbarrett/Sites/FoodSystems/admin/Test/testing_action.cfm: line 6
4 : <cfquery datasource="#REQUEST.dataSource#">
5 : INSERT INTO test(text,webSite,desc,cat,date_entered)
6 :
VALUES('#FORM.text#','#FORM.webSite#','#FORM.desc#','health',#date_entered#)
7 : </cfquery>
8 :
SQLSTATE 42000
SQL INSERT INTO test(text,webSite,desc,cat,date_entered) VALUES('CF
Talk','http://www.houseoffusion.com','a place to help with your CF
Questions','health',{ts '2009-08-16 13:53:39'})
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:4710
Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
