Is it possible to add data to your database with just cfquery? That is no form?
<cfquery name="InsertData" DataSource="#REQUEST.dataSource#">
INSERT INTO Customers (CustomerName,CustomerAge,date_added)
VALUES ('John Barrett',30,'#DateFormat(createodbcdate(now()),'mm/
dd/yyyy')#')
</cfquery>
I get the error, "Element DATASOURCE is undefined in REQUEST." The datsource is
denfined in the Application.cfm as well as the cf admin.
I am trying to learn how to write a date to the db, without the form, that is
to just have a date added field that gets writen to the database.
Thanks,
John
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:3857
Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
