Ah, Oracle - you have to love it! More and more corporations it seems are
using this DBMS!
For good reason - it is very capable.
>From a development point of view, especially with a frequently absent
database administrator in between, it can be a nightmare.
Why you are using this:
ChgDate = {ts '2003-09-16 16:08:22'}
Instead of a native ColdFusion function like CreateODBCDateTime(Now()) or
something is beyond me.
Your quotes could also be an issue, try double rather than single quotes.
Also the CFUPDATE function negates the need for the SQL - just ensure the
data going in is valid beforehand - eg:
<cfupdate datasource="#Request.DataSourceName#" tablename="ACTCFUG_News"
formfields="NewsID,NewsTitle,NewsBody,NewsBodyTemp,NewsUpdated,NewsLocked,Ne
wsReleased,NewsApproved,NewsCompleted" username="#Request.DataSourceUser#"
password="#Request.DataSourcePassword#">
The "formfields" are validated before going to the database - an error could
be trapped and handled by CFTRY or some other error handler.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics.
http://www.fusionauthority.com/signup.cfm
