RE: [CFTALKTor] AUTO_INCREMENT

[Bob Silverberg]

Oops, then the reply that I just sent is incorrect.

 

I believe the correct answer is:

 

<cfquery name="create_table" datasource="xx_renters">

 

CREATE TABLE user (
     user_id      COUNTER NOT NULL PRIMARY KEY,
     user_name    VARCHAR (20)     NOT NULL,
     password     VARCHAR (20)     NOT NULL,
     UNIQUE (user_id)
     )
</cfquery>

 

You use COUNTER as the datatype, instead of INTEGER.

 

Bob

 

 -----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Erik Fenkell
Sent: Tuesday, 5 March 2002 9:02 a.m.
To: [EMAIL PROTECTED]
Subject: RE: [CFTALKTor] AUTO_INCREMENT

I am using access.

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of [EMAIL PROTECTED]
Sent: Monday, March 04, 2002 2:55 PM
To: [EMAIL PROTECTED]
Subject: RE: [CFTALKTor] AUTO_INCREMENT

The query to create the table will be database specific as to what to call the "autoinc" primary key.

 

eg  MS Access autonumber

Postgres  serial

etc...

 

what database are you using?

 

Terry Fielder
Network Engineer
Great Gulf Homes / Ashton Woods Homes
[EMAIL PROTECTED]

 

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Erik Fenkell
Sent: Monday, March 04, 2002 2:35 PM
To: [EMAIL PROTECTED]
Subject: [CFTALKTor] AUTO_INCREMENT

Hello All,

 

I am trying to create a table whose primary key AutoIncrements. Creating the table is not a problem, making the primary key auto increment is.

 

Here is the query.

 

-------------------------

<cfquery name="create_table" datasource="xx_renters">

 

CREATE TABLE user (
     user_id      INTEGER          NOT NULL PRIMARY KEY,
     user_name    VARCHAR (20)     NOT NULL,
     password     VARCHAR (20)     NOT NULL,
     UNIQUE (user_id)
     )
</cfquery>

------------------------

 

I have tried all means of syntax for autoincrement but with no luck.

 

Thanks for any advice.

 

Best,

Erik