In Oracle, you have a separate sequencing table, and you reference it to
insert your next record number.
Dave
----- Original Message -----
From: Mark Warrick <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Sent: Wednesday, September 27, 2000 12:49 PM
Subject: RE: Autonumber?
You don't have to, and in fact you shouldn't. Databases do that for you.
In Access, use the field type "Autonumber".
In SQL, create an INT field, NO NULLS, IDENTITY, IDENTITY SEED (some
starting number), IDENTITY INCREMENT (some number increment). With SQL 7.0,
this is all very obvious. With 6.5 you may have to do some reading.
With Oracle, you would create a stored (shoot what do you call it?)
auto-incrementing stored procedure of some sort (help me out here guys -
it's been a while). But anyway, you call a stored procedure of some sort
with Oracle. That's one difference between that platform and Microsoft's
stuff.
---mark
--------------------------------------------------------------
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--------------------------------------------------------------
> -----Original Message-----
> From: HappyToad.com [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, September 27, 2000 7:44 AM
> To: CF-Talk
> Subject: Autonumber?
>
>
> How can I have Cf create a unique order id for each order placed
> though the
> store I am building?
>
>
> Thanks,
> Rich
>
> ------------------------------------------------------------------
> ------------
> Archives: http://www.mail-archive.com/[email protected]/
> 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.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=sts&body=sts/cf_talk or send
a message to [EMAIL PROTECTED] with 'unsubscribe' in the
body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
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.
