Saturday, March 20, 2010

Calendar

<< Jul 2007 >>

S	M	T	W	T	F	S
1	2	3	4	5	6	7
8	9	10	11	12	13	14
15	16	17	18	19	20	21
22	23	24	25	26	27	28
29	30	31

Categories

• Acrobat (3) [RSS]
• Adobe (90) [RSS]
• AdobeMAX06 (45) [RSS]
• AdobeMAX07 (59) [RSS]
• AdobeMAX08 (66) [RSS]
• AdobeMAX09 (39) [RSS]
• AdobeMAX10 (1) [RSS]
• AIR (219) [RSS]
• Appearances (191) [RSS]
• Books (72) [RSS]
• CFEclipse (15) [RSS]
• ColdFusion (1381) [RSS]
• Data Services (34) [RSS]
• Fish Tank (5) [RSS]
• Flash (197) [RSS]
• Flex (498) [RSS]
• Home Automation (5) [RSS]
• Jobs (116) [RSS]
• JRun (14) [RSS]
• Labs (43) [RSS]
• LiveCycle (34) [RSS]
• MAX (232) [RSS]
• Mobile (120) [RSS]
• Regular Expressions (17) [RSS]
• RIA (21) [RSS]
• SQL (40) [RSS]
• Stuff (536) [RSS]
• Tips (CF Studio) (80) [RSS]
• Tips (CF) (795) [RSS]
• Tips (Dreamweaver) (91) [RSS]
• Tips (Flex Builder) (2) [RSS]
• Using CF (162) [RSS]

Other BLOGs

• Charlie Arehart
• Lee Brimelow
• Ray Camden
• Christophe Coenraets
• Sean Corfield
• Mihai Corlan
• Cornel Creanga
• Mark Doherty
• John Dowdell
• Danny Dura
• Enrique Duvos
• Steven Erat
• Kevin Hoyt
• Serge Jespers
• Adam Lehman
• Duane Nickull
• Miti Pricope
• Andrew Shorten
• Ryan Stewart
• James Ward
• Greg Wilson
• Full As A Goog

RSS Feeds

• Feed
• Subscribe

Join my mailing list and find out about new books and other topics of interest.

Thoughts, ideas, tips, musings, and pontifications (not necessarily in that order) by Ben Forta ...
NOTE: This is my personal blog, and the opinions and statements voiced here are my own.

Viewing By Entry / Main

July 6, 2007

ColdFusion 8 Can Return Identity Values

Posted At : 12:21 PM
Related Categories: ColdFusion :

Here's another ColdFusion 8 goodie that I just learned about yesterday ...

If you are using a database table with an identity (auto-increment) field, ColdFusion 8 can automatically return the newly created field value for you, without needing a trigger or a subsequent <CFQUERY>. All you need to do is look in the <CFQUERY> optional RESULT structure, and if available the value will just be there. This feature is very DBMS and driver specific (and unfortunately does not seem to be supported by Apache Derby), and the name of the structure member containing the generated value is different based on the DBMS being used. Here are the ones you should be aware of:

SQL Server: result.IDENTITYCOL
Oracle: result.ROWID
Sybase: result.SYB_IDENTITY
Informix: result.SERIAL_COL
DB2: result.KEY_VALUE
MySQL: result.GENERATED_KEY (MySQL 4 and 5 only, MySQL 3 does not support this feature)

Very nice indeed!

TrackBacks

[Add Trackback]

Yet another example of how ColdFusion makes coders’ lives easier
I just read about a new feature of ColdFusion 8 on Ben Forta’s blog that blew me away - not because it was ground-breaking or tricky or a major feature people had been begging for, but because it illustrates exactly what’s cool about ColdFusion...

Tracked by kay lives here | Tracked on 7/8/07 12:56 AM

No trackback URL. Trackbacks are only allowed via interactive form.

[Add Trackback]

Comments

[Add Comment] [Subscribe to Comments]

Why not make a coldfusion specific variable that could encompass all of these variable names... seems like that would be a lot smarter than having all these different variables to check depending on your DBMS. Or just leave them and add one that is CF specific ie: result.resultID or something.

# Posted By Steven Ross | 1/5/10 12:17 PM

IDENTITYCOL is not present in my result struct. I see CACHED, EXECUTIONTIME, RECORDCOUNT, SQL and SQLPARAMETERS but no IDENTITYCOL. I'm using SQL Server 2000 sp4 and I do have an identity column defined on the table. Do I need to enable this somewhere?

# Posted By Bernie | 2/18/10 11:08 AM

[Add Comment]