http://www.teamallaire.com/tutorials/maxID.cfm
___________________________________________
Sean Brown <[EMAIL PROTECTED]>
http://www.westcar.com/
"Either way you get your dog back"
-Anonymous
___________________________________________
-----Original Message-----
From: Scott Forler [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 09, 2000 7:27 PM
To: [EMAIL PROTECTED]
Subject: autogenerated keys
Hello All:
Is there a way to determine the auto-generated primary key generated by
Access when using CFInsert? I am trying to create two records, one that
creates a key (auto numbering turned on) and another that uses the key that
was just created.
I suppose I could save a unique predetermined key at the same time as I
create the first record and use this to query the table for the value of the
autocreated key but this seems like a forced solution. Is there a better
way? Am I going about this wrong?
Thanks,
Scott
PrairieWeb Internet Marketing, Inc.
Web Development and Marketing
Phone: 630-393-1419 x11
Fax: 630-393-1487
http://www.pwim.com
----------------------------------------------------------------------------
--
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.
------------------------------------------------------------------------------
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.
