just mark something as an identity in the design table form.
chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com
-----Original Message-----
From: Arden Weiss [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 02, 2001 9:58 AM
To: CF-Talk
Subject: RE: [Oracle Auto-Increment]
What about SQL Server -- how to auto-increment??
^
/ \__
( @\___
/ O
/ (_____/
/_____/
Whoof...
410-757-3487
-----Original Message-----
From: Alex [SMTP:[EMAIL PROTECTED]]
Sent: Monday, April 02, 2001 9:45 AM
To: CF-Talk
Subject: Re: [Oracle Auto-Increment]
create a sequence then in your INSERT sql type sequencenqme.next_val.
not sure on specific syntax
Jamie Symonds <[EMAIL PROTECTED]> wrote:
Hi - I am inserting results of a form into an Oracle 8
database - in the past, while using Access, I would set the
first field of the table ("id") to "auto-number" for my
primary key. Oracle does not have an auto-increment feature
- how do I go about this? Thanks.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists