What I'm thinking, from this thread and others I've read in the past,
is that if keeping your code database-independent is priority.
inserting some unique identifier and then querying for that in a second query
might be the best option.
Or do you folks find that you can't really stay
If you decide to go in this direction, I would suggest not just using the
'datetime' added column. create a truly unique identifier such as: datetime
(MMDDHHMMSS)+ user ip address (or username if logged in) plus a random
sequence. This way you will know you can search on the unique and
I've tried using the result.identitycol trick with CF8 and MSSQL and for
me, it doesn't work. I just get an error.
Not that it is the best approach, but the result.identitycol trick is a little
'tricky'
eg. cfquery name=queryname datasource=nameddatasource
if you cfdump queryname, you will
This is more of a how would you do it question.
I have a simple set of queries that are currently inside an cfif
statement, the if block inserts a record, grabs the id of the just
inserted record, and there's an optional update that runs if some one
else is entering there record.
I know I can
Separate methods might make sense if you need to do this from more than one
method. If it is specific to that method it might not be worth breaking it
up.
Be aware though that inserting a record and then selecting the MAX id can
result in an incorrect ID if more than one thread runs this code at
Be aware though that inserting a record and then selecting the MAX id can
result in an incorrect ID if more than one thread runs this code at the same
time. You'd probably be better off getting the last inserted ID from the
cfquery itself if you are on CF8, or looking at using a native database
You can generally avoid the problem with a cftransaction tag if you're
doing the MAX(id) thing, but the other solutions are better
(especially the new CF8 goodies which, for example, are a life saver
for Oracle).
On Tue, Aug 19, 2008 at 11:12 PM, Scott Stewart [EMAIL PROTECTED] wrote:
Be
James Holmes wrote:
You can generally avoid the problem with a cftransaction tag if you're
doing the MAX(id) thing, but the other solutions are better
(especially the new CF8 goodies which, for example, are a life saver
for Oracle).
I've tried using the result.identitycol trick with CF8 and
While it probably won't happen often, depending on load, even the Now()
logic can result in two records with the same value if they come in at the
same time. And cftransaction will only work if you go all the way to
serializable for isolation level, which essentially single-threads access
and,
tblLocations has an identity column that is)
Cheers,
Craig.
-Original Message-
From: RobG [mailto:[EMAIL PROTECTED]
Sent: 19 August 2008 16:26
To: CF-Talk
Subject: Re: CFC Best Practices
James Holmes wrote:
You can generally avoid the problem with a cftransaction tag if you're
doing the MAX(id
On Tue, Aug 19, 2008 at 10:44 AM, Craig Dudley [EMAIL PROTECTED] wrote:
Rob, if you are using MSSQL why don't you use @@IDENTITY?
Just to be clear, @@identity returns the most recent inserted id of
all tables. So if you had a trigger that when a table gets an insert,
another table also gets an
Actually if you are using MSSQL 2000 or 2005 or up, you should be using
VALUES();
SELECT SCOPE_IDENTITY() AS id
-Original Message-
From: Craig Dudley [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 19, 2008 11:45 AM
To: CF-Talk
Subject: RE: CFC Best Practices
Rob, if you
.
Craig.
-Original Message-
From: Matt Williams [mailto:[EMAIL PROTECTED]
Sent: 19 August 2008 16:57
To: CF-Talk
Subject: Re: CFC Best Practices
On Tue, Aug 19, 2008 at 10:44 AM, Craig Dudley [EMAIL PROTECTED] wrote:
Rob, if you are using MSSQL why don't you use @@IDENTITY?
Just to be clear
Sandra Clark wrote:
Actually if you are using MSSQL 2000 or 2005 or up, you should be using
VALUES();
SELECT SCOPE_IDENTITY() AS id
Okay, I just added this to my insert function, and got this:
[Macromedia][SQLServer JDBC Driver][SQLServer]'SCOPY_IDENTITY' is not a
recognized
Try SCOPE_IDENTITY() instead of SCOPY_IDENTITY()
Sandra Clark wrote:
Actually if you are using MSSQL 2000 or 2005 or up, you should be using
VALUES();
SELECT SCOPE_IDENTITY() AS id
Okay, I just added this to my insert function, and got this:
[Macromedia][SQLServer JDBC
William Seiter wrote:
Try SCOPE_IDENTITY() instead of SCOPY_IDENTITY()
D'OH!
Man and I even went over it to be absolutely certain it wasn't something
stupid.
Rob
~|
Adobe® ColdFusion® 8
;)
William Seiter (mobile)
Have you ever read a book that changed your life?
go to: http://www.winninginthemargins.com
and use passcode: GoldenGrove
-Original Message-
From: RobG [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: 8/19/2008 9:55 AM
Subject: Re: CFC Best
For MSSQL there's a native function to give you the id. In a CFQuery
tag it works like this:
cfquery name=Insert datasource=#variables.dsn#
SET NOCOUNT ON
INSERT into Tablename
( email, firstname, lastname ) VALUES
(
To what CF8 goodies do you refer? I do everything in ORACLE (mostly using
stored procs) but I haven't had a chance to do a deep dive into CF8 yet...
Thanks!
Warren Koch
~|
Adobe® ColdFusion® 8 software 8 is the most
http://livedocs.adobe.com/coldfusion/8/htmldocs/Tags_p-q_17.html
result_name.ROWID; Oracle only. The ID of an inserted row. This is
not the primary key of the row, although you can retrieve rows based
on this ID.
This means we can now insert a row and then query the DB on the ROWID
to get the
If I have an object loaded in the Application scope and want to use it in
another object/component ,should I pass it in as a variable or should I call
it directly from the Application scope. Assume that the object will always
be loaded in memory.
TIA
G
--
As an adolescent I aspired to lasting
If I have an object loaded in the Application scope and want to use it in
another object/component ,should I pass it in as a variable or should I
call
it directly from the Application scope. Assume that the object will always
be loaded in memory.
TIA
G
I would advise against accessing
Subject: RE: CFC Best practices question
If I have an object loaded in the Application scope and want to use it
in
another object/component ,should I pass it in as a variable or should I
call
it directly from the Application scope. Assume that the object will
always
be loaded in memory
On Wed, Mar 5, 2008 at 3:43 PM, Gerald Guido [EMAIL PROTECTED] wrote:
If I have an object loaded in the Application scope and want to use it in
another object/component ,should I pass it in as a variable or should I call
it directly from the Application scope. Assume that the object will
that are meant to stay private to the function and you cache
your component.
RUss
-Original Message-
From: Rich [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 05, 2008 4:53 PM
To: CF-Talk
Subject: RE: CFC Best practices question
If I have an object loaded
I have seen it set in the init and set to the variables scope. and then
called from individual functions.
So if the passed object is local to *only one* function should I pass it to
just that one function?
Or if it used multiple times in the object I should store it as part of the
object (in the
I think you're starting to see where ColdSpring (or Lightwire) might
come in handy :)
On Wed, Mar 5, 2008 at 2:24 PM, Gerald Guido [EMAIL PROTECTED] wrote:
I have seen it set in the init and set to the variables scope. and then
called from individual functions.
So if the passed object is
Yep... that light bulb just went off. thanx.
On Wed, Mar 5, 2008 at 5:29 PM, Charlie Griefer [EMAIL PROTECTED]
wrote:
I think you're starting to see where ColdSpring (or Lightwire) might
come in handy :)
On Wed, Mar 5, 2008 at 2:24 PM, Gerald Guido [EMAIL PROTECTED]
wrote:
I have seen it
I'll second this. When you use ColdSpring, you end up having it passed
in as an init() parameter and then put it in the VARIABLES scope, so
it's available to all methods inside your object.
On Thu, Mar 6, 2008 at 7:29 AM, Charlie Griefer
[EMAIL PROTECTED] wrote:
I think you're starting to see
I think you're starting to see where ColdSpring (or Lightwire) might
come in handy :)
I second that - spend 30 mins getting a very basic ColdSpring setup running;
you won't look back, it is a beautiful answer to this question.
ColdSpring uses an XML file as a configuration for all your
Thanx for the insight gentlemen. I am getting all wound up with the light
bulbs going off at once.
Prolly wont get much sleep tonight. :)
On Wed, Mar 5, 2008 at 5:42 PM, Dominic Watson
[EMAIL PROTECTED] wrote:
I think you're starting to see where ColdSpring (or Lightwire) might
come in
Thanx for the insight gentlemen. I am getting all wound up with the light
bulbs going off at once.
Lol best bit of being a codee geek init ;)
Dominic
--
Blog it up: http://fusion.dominicwatson.co.uk
~|
Adobe® ColdFusion®
Lol best bit of being a codee geek init ;)
yep... nothing quite like the high from intellectual discovery. It is hard
to explain to non-geeks/science nerds.
GF: Oh, what are you all excited about?
Me: I just figured out dependency injection.
GF: Huh?
Me: Nothing.
--
As an adolescent I
Lmao, my gf would pretend to listen for a 10 minutes or more as I explained
things to her. At the end of the lecture she'd say that's nice dear, what's
for tea? or some such.
On 05/03/2008, Gerald Guido [EMAIL PROTECTED] wrote:
Lol best bit of being a codee geek init ;)
yep... nothing quite
Can somebody give me some cfc best practices? I'm new to them and I
want to get started on the right foot. One thing that is really
bothering me is how to organize my CFCs and where to put them.
I've searched the web but I'm still not satisfied with every things I've found.
--
Phillip B
Subject: cfc best practices
Can somebody give me some cfc best practices? I'm new to them and I
want to get started on the right foot. One thing that is really
bothering me is how to organize my CFCs and where to put them.
I've searched the web but I'm still not satisfied with every things I've
for MachII
And would be called like so:
CreateObject(component,model.org.camden.Blog)
- Calvin
-Original Message-
From: Phill B [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 08, 2005 9:59 AM
To: CF-Talk
Subject: cfc best practices
Can somebody give me some cfc best practices? I'm
Thanks you guys. I have several sites that call to the same CFCs so I
just mapped them for ease of use.
So what is the best way to handle errors in a CFC?
On Tue, 8 Mar 2005 10:22:53 -0500, Brian Kotek [EMAIL PROTECTED] wrote:
Check out the Macromedia CF coding guidelines and Mach-II
So what is the best way to handle errors in a CFC?
Throw it? That's what I've been doing... Then document what you will
throw so that any calling code can catch any errors and decide what to
do.
Hopefully I'm on track with that one :)
--
dc
Thats what I'm trying to do but I can't get things to work the way I
want them to.
Lets say something gets by all my validation and a bad variable makes
it to a query in a CFC method. Now I have an error. So I put a try
catch around the query to control the errors in the CFC. Since I need
the
Lets say something gets by all my validation and a bad
variable makes it to a query in a CFC method. Now I have an
error. So I put a try catch around the query to control the
errors in the CFC. Since I need the results from the CFC
query, I'll get an error on the page calling it because
In the third part of our CFUN-04 interview series, Michael Smith interviews
Raymond Camden, co-founder of the CFLib.org amd CFCzone.org sites, who will be
presenting on CFCs at CFUN-04.
Michael Smith: Ray, I am intrigued about your CFC Best Practices, Tips and
Tricks talk at CFUN-04. Why
42 matches
Mail list logo
