Why not?
What's wrong with grabbing and reserving the next number from the database?
If they fail to check out, that tells you something.
---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 8:19 PM
> To: CF-Talk
> Subject: RE: Autonumber?
>
>
> I want the autonumber id to be displayed as a query on the
> checkout page for
> the customer as well. I can't do this if I let the database assign the
> number.
> Rich
>
> -----Original Message-----
> From: Mark Warrick [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, September 27, 2000 12:50 PM
> To: CF-Talk
> 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_tal
k 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.
------------------------------------------------------------------------------
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.
