If anyone knows of how to do this programmatically using MS access, that would be good to know. I haven't gotten it to work yet...
thx, carina ----- Original Message ----- From: [EMAIL PROTECTED] Sent: Monday, March 04, 2002 2:54:41 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 - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: [EMAIL PROTECTED] To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ This System has been donated by Infopreneur, Inc. (http://www.infopreneur.net)
