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?sidebarRsts&bodyRsts/cf_talk or send a message
to [EMAIL PROTECTED] with 'unsubscribe' in the body.
