there IS an explaination for this problem, you don't just have to use the
CFQuery ...
ColdFusion uses a validation scheme whenever it sees certain suffixes on
fieldnames. the suffixes are recognized by seeing an underscore "_" and
then the cooresponding word, in your specific case, it is "_date". i can't
tell you (because i don't know) what exactly it thinks it's doing when it
doesn't add the data and keeps chuggin through the code, but it's irritating
when first learning.
bottom line for resolution to this problem, don't make field names with
certain suffixes that i'll list below. for example, try naming fields
"Date_Foo", "FooDate" or something like "DateofFoo" ... you get the point ;)
let the list (or me) know if you need more help!
here to help & learn,
</wd>
// listing of validation suffixes
// _integer
// _float
// _range
// _date
// _time
// _eurodate
// you can confirm this info (and learn more) for yourself by going to
// the ColdFusion Studio (4.0+) help system:
// -- Help References
// ---- Developing Web Applications with ColdFusion
// ------ Chapter 06 Updating Your Data
// -------- Validating the Data that Users Enter In Form Fields
----- Original Message -----
From: "st�s" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, April 19, 2000 10:51 AM
Subject: Problem with CFUPDATE
Hello,
I am updating a record with form results, and there are a couple of date
fields. For some reason, any changes on the form with those date fields do
not get updated in the database. I would use a regular update, but each
record has about 30 fields, and I don't want to type the whole thing
manually. Does anybody know what might cause this, as I am not getting any
errors, the records just don't get updated. The database is Oracle8i on
Solaris, and I'm connecting via ODBC. Thanks.
----------------------------------------------------------------------------
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
