Data Loss?

[BeeDubya]

I'm having problem with dropped data between the Coldfusion 6.1 server and the
DB server.
Submitting using cfinsert:
cfinsert datasource="mydatasource" tablename="MYTABLE"
to insert to an Oracle 10g database. However, there appears to be some data
loss when inserting into the table. To test things I added a cfdump to the form
page to make sure the data was making it to the submit form, and it is. The
form works when submitting from the dev edition on my workstation, but has
problems when I move it to the production server. I have also had the same
problem when submitting to an Access DB residing on the Coldfusion server, so I
don't think it's a connectivity problem or a DB driver problem.
I've even tried reinstalling Coldfusion.
Any help would be greatly appreciated.

[Dan Bracuk]

What is the nature of the problem?

page crashes?
record not inserted?
some fields inserted, some not?

[paross1]

As a generic word of advice, I would avoid using CFINSERT and CFUPDATE, as
there have been longstanding problems with these tags over numerous versions of
CF. Using CFQUERY give you much more control, and fewer headaches.

Phil

[BeeDubya]

The problem is some fields inserted, some not. It's not completely consistant which fields are missed, but usually the FNAME & LNAME fields (VARCHAR2).

[sdupre]

I think this is bug 52972 and was fixed in the 6.1 updater.

When CFINSERT or CFUPDATE is used with a table with certain column names, some
FORM fields are not correctly mapped to the table column names. This happens
intermittently.

The problem only occurs when one column name is a portion of another, longer
column name. For example, the three column names: JOB, FIRSTJOB, JOBTYPE

(OK in 7.0)

6.1 hotfix here:
[url]http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_18952[/url]

Stephen Dupre
Macromedia QA

[BeeDubya]

That would make sense. I have columns named LNAME, FNAME, TLNAME, and TFNAME.
Thanks!