It worked like a charm
gil
-----Original Message-----
From: Matt Robertson [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 22, 2003 2:36 PM
To: CF-Talk
Subject: RE: alter table
May wrote:
>I know how to add and delete columns, but how does one
>change the properties of a column using Access
Like this:
<cfquery datasource="#request.myDSN#">
ALTER TABLE myusers ALTER Status text(255) NULL ;
</cfquery>
In my CMS' installer tests, Access XP was found to throw an error when
ALTER
statements are combined into a single cfquery. So I do one ALTER per
cfquery if I have to alter multiple fields in a single table. This
combined way is what I used to do (note it adds fields rtather than
altering existing ones):
<cfquery datasource="#request.myDSN#">
ALTER TABLE mytopics
ADD myKeywords text(255) NULL,
ADD myDescr text(255) NULL,
ADD myRevision memo NULL,
ADD myProc text(255) NULL ;
</cfquery>
HtH,
--------------------------------------------
Matt Robertson [EMAIL PROTECTED]
MSB Designs, Inc. http://mysecretbase.com
--------------------------------------------
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
