I'll
just throw out, for what it's worth, that this whole idea of using SQL to create
or modify tables is something that a lot of CFers never learn about but it can
be very powerful and useful. I wrote a CFDJ article back in July 2000
called "Reconfiguring Remote Databases via SQL", which was about this sort of
SQL DDL (data definition language).
More
to Carina's request, in it I point to a couple of MS sites with
details on data types, DDL sql statements, and more. It's available online at http://www.systemanage.com/cff/articles.cfm.
/charlie
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Bob Silverberg
Sent: Tuesday, March 05, 2002 7:29 PM
To: [EMAIL PROTECTED]
Subject: RE: [CFTALKTor] AUTO_INCREMENTLet me know if it works, because I didn't try it! It's from an MSDN article (http://support.microsoft.com/default.aspx?scid=kb;EN-US;q116145) , but I actually found it via Google. I just did a search on "access create table autonumber" and I found an article on the web, which then had a link to that MSDN article. You generally have to look at at least a few results before you find what you're looking for, but, if it can be found, Google will usually find it. I think the key is coming up with the right search criteria - you need to make it as specific as possible.Bob-----Original Message-----Bob... this is amazing.. i have to try it...
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of carina cojeen
Sent: Wednesday, 6 March 2002 12:47 p.m.
To: [EMAIL PROTECTED]
Subject: Re: [CFTALKTor] AUTO_INCREMENTin the manner of "teaching a man to fish" (was it charlie who said that?),
where the heck is that documented??? Do you have a good "bible" that you refer to, or is there some reference on the web? I don't know about the rest of you but msdn developer search is SO difficult to find anything on!!!!carina
Bob Silverberg wrote:
CREATE TABLE user (- You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: carina cojeen <[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)
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.I am using access.
