the data type is identity for ms sql
----- Original Message -----
From: "Arden Weiss" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, April 02, 2001 8:58 AM
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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
