On Sun, 2004-02-01 at 07:09, Stuart Kidd wrote:
> Hi guys,
>
> I'm inserting a record to a database, but once I have inserted the
> record I want to email the user their details including their UserID
> which is an autonumber (primary).
>
> To grab the last inserted row should I use the CFLOCK
Simon Horwith said:
> even with serializable database transactions, the return is not
> accurate 100% of the time. If you follow the link to the
> devnet article from the URL I posted, it explains this.
If I follow the link from your message I read:
"The only way to be 100% sure that the unique
EMAIL PROTECTED]
Sent: 01 February 2004 15:56
To: CF-Talk
Subject: RE: CFLOCK:Sunday (still not left computer all weekend,
flatmates will start thinking i have problems)
Simon Horwith said:
> actually, the use of and together is the
> recommended practice... under extremely
lto:[EMAIL PROTECTED]
Sent: 01 February 2004 15:27
To: CF-Talk
Subject: Re: CFLOCK:....Sunday (still not left computer all weekend,
flatmates will start thinking i have problems)
> Hi guys,
>
> I'm inserting a record to a database, but once I have inserted the
>
> Hi Dave,
>
> Thanks for that. I'll stick with the simple stuff until I get a bit
> better at this stuff. I've put in the necessary code but I'm getting a
> "Element PROPERTYAGENTID is undefined in GETUSERID." Error.
>
> Can you see what I'm doing wrong?
>
>
>
>
> INSERT INTO PropertyAgent
>
Stuart Kidd said:
>
>
>
> INSERT INTO PropertyAgent
> (PropertyAgentCompanyName, PropertyAgentFlatNumberHouseName,
> PropertyAgentStreetNumber, PropertyAgentStreetName,
> PropertyAgentVillageTown, PropertyAgentCountyState,
> PropertyAgentPostcodeZip, PropertyAgentCountry,
> PropertyAgentTelep
Simon Horwith said:
> actually, the use of and together is the
> recommended practice... under extremely heavy load
> doesn't return the proper unique id to the client 100% of the time
Make the transaction serializable.
> but does.
Only if CF is the only application manipulating the database
ertyAgentID)
FROM
PropertyAgent
#GetUserID.PropertyAgentID#
Thanks,
Stuart
-Original Message-----
From: Dave Carabetta [mailto:[EMAIL PROTECTED]
Sent: 01 February 2004 15:27
To: CF-Talk
Subject: Re: CFLOCK:Sunday (still not left computer all weekend,
flatmates will start thinking i h
Sent: 01 February 2004 15:27
To: CF-Talk
Subject: Re: CFLOCK:Sunday (still not left computer all weekend,
flatmates will start thinking i have problems)
> Hi guys,
>
> I'm inserting a record to a database, but once I have inserted the
> record I want to email
> Hi guys,
>
> I'm inserting a record to a database, but once I have inserted the
> record I want to email the user their details including their UserID
> which is an autonumber (primary).
>
> To grab the last inserted row should I use the CFLOCK around my query
> and my cfmail? Is there such a th
Hi guys,
I'm inserting a record to a database, but once I have inserted the
record I want to email the user their details including their UserID
which is an autonumber (primary).
To grab the last inserted row should I use the CFLOCK around my query
and my cfmail? Is there such a thing as Las
11 matches
Mail list logo
