Hello,
I previously (cfserver 4) used cftransaction and cflock to rollback any
errors when inserting a record and then selecting the last insert using
AX( ). eg:
<cflock name="FindUser" timeout="20">
<cftransaction>
<cfquery Datasource="#DSN1#">
INSERT INTO
Customers(Title,FirstName,LastName,Address,Suburb,State,PostCode,Country,Pho
ne,EmailAddress)
VALUES ('#form.Title#', '#form.FirstName#', '#Form.LastName#',
'#form.Address#', '#Form.Suburb#', '#form.State#', '#PostCode#',
'#form.Country#', '#form.Phone#', '#form.EmailAddress#')
</cfquery>
<cfquery datasource="#DSN1#" name="getLastID">
SELECT MAX(CustomerID) as UserID
FROM Customers
</cfquery>
</cftransaction>
</cflock>
I have upgraded to cfserver 4.5.1 and now it doesn't seem to work. the
insert works, (though it shouldn't if the select doesnt?) and then i get an
error, but cfserver doesn't show it. I have debugging on, but this is what i
get (look at bottom of message):
it is lopped off at the start!!!! i dont know what the error is...
So the problems are:
Cftransaction not working
Debugging error message cut off.
Something causing this error - maybe max() doesn't work anymore....i
dont know...
could anyone help me...?
-----------------------start of error message---------------------------
site administrator that this error has occurred (be sure to include the
contents of this page in your message to the administrator).
----------------------------------------------------------------------------
----
----------------------------------------------------------------------------
----
Execution Time
32 milliseconds
----------------------------------------------------------------------------
----
Parameters
Form Fields:
ADDCUSTOMER=Add Customer
ADDRESS=24 cow street
COUNTRY=Australia
[EMAIL PROTECTED]
FIELDNAMES=TITLE,FIRSTNAME,LASTNAME,ADDRESS,SUBURB,POSTCODE,STATE,COUNTRY,PH
ONE,EMAILADDRESS,ADDCUSTOMER
FIRSTNAME=John
LASTNAME=Arachnid
PHONE=45678765
POSTCODE=3000
STATE=NSW
SUBURB=Arachnid
TITLE=Mr
Chris Carpenter
WebMaster/IT Manager
ABC Interactive
http://www.abcinteractive.com.au
------------------------------------------------------------------------------
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.
