Using an Access table, I have a template with an INSERT and a MAX(ID), plus
a CFLOCATION routine within a
CFTRANSACTION. I've tried it with both SQL INSERT and CFINSERT and, either
way, the autonumber field is
incremented, but no data is inserted in the record.
If I use either insert method on its own, without a CFTRANSACTION, the
record is inserted correctly. I wonder if someone
could steer me to possible sources for this problem. With other databases,
this method works fine using essentially the same
code, so I'm wondering if there might be a setting in the database, itself,
in the ODBC settings, or possibly in my
APPLICATION.CFM (code below, if it helps).
This has had me stymied for days. I would sure appreciate any direction you
can give.
Thanks
--John
APPLICATION.CFM
<cfapplication
name="Employee"
clientmanagement="Yes"
sessionmanagement="Yes"
sessiontimeout="#CreateTimeSpan(0,0,30,0)#"
applicationtimeout="#CreateTimeSpan(0,0,30,0)#"
setclientcookies="Yes">
<CFERROR TYPE="REQUEST"
TEMPLATE="error_handler.cfm"
MAILTO="[EMAIL PROTECTED]">
<!--- set datasource for this application --->
<CFSET dsn = 'empl_dbc'>
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
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.
