WIth Oracle you can set up a "sequence" which gives you
the same kind of functionality.
eg CREATE SEQUENCE mytab_seq ON mytab INCREMENT BY 1;
then in your insert statement you can say
INSERT INTO mytab(....)
VALUES (mytabseq.nextval, ....)
Nick
-----Original Message-----
From: Jamie Symonds [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 02, 2001 2:37 PM
To: CF-Talk
Subject: Oracle Auto-Increment
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.
**********************************************************************
Information in this email is confidential and may be privileged.
It is intended for the addressee only. If you have received it in error,
please notify the sender immediately and delete it from your system.
You should not otherwise copy it, retransmit it or use or disclose its
contents to anyone.
Thank you for your co-operation.
**********************************************************************
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
