do a google search on alter table
-Original Message-
From: Ryan Pieszak [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 20, 2002 9:13 AM
To: CF-Talk
Subject: OT (SQL): Add column to query?
I know this is OT, but I've seen some SQL on this list lately, so I figured
I ask:
Let's say I have
Do you want it in the table, or just in the returned query?
Jerry Johnson
[EMAIL PROTECTED] 05/20/02 11:12AM
I know this is OT, but I've seen some SQL on this list lately, so I figured
I ask:
Let's say I have this query:
Col1Col2Col3
1 a 10
2 b 11
3
ALTER TABLE table_name
ADD column_name datatype
Or
ALTER TABLE table_name
DROP COLUMN column_name
-Original Message-
From: Ryan Pieszak [mailto:[EMAIL PROTECTED]]
Sent: 20 May 2002 16:13
To: CF-Talk
Subject: OT (SQL): Add column to query?
I know this is OT, but I've seen some SQL
just in the returned query
-Original Message-
From: Jerry Johnson [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 20, 2002 11:31 AM
To: CF-Talk
Subject: Re: OT (SQL): Add column to query?
Do you want it in the table, or just in the returned query?
Jerry Johnson
[EMAIL PROTECTED] 05/20
...
-Original Message-
From: Adrian Lynch [mailto:[EMAIL PROTECTED]]
Sent: 20 May 2002 16:26
To: CF-Talk
Subject: RE: OT (SQL): Add column to query?
ALTER TABLE table_name
ADD column_name datatype
Or
ALTER TABLE table_name
DROP COLUMN column_name
-Original Message-
From: Ryan Pieszak
]]
Sent: Monday, May 20, 2002 11:12 AM
To: CF-Talk
Subject: RE: OT (SQL): Add column to query?
do a google search on alter table
-Original Message-
From: Ryan Pieszak [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 20, 2002 9:13 AM
To: CF-Talk
Subject: OT (SQL): Add column to query?
I know
-Talk
Subject: RE: OT (SQL): Add column to query?
ALTER TABLE table_name
ADD column_name datatype
Or
ALTER TABLE table_name
DROP COLUMN column_name
-Original Message-
From: Ryan Pieszak [mailto:[EMAIL PROTECTED]]
Sent: 20 May 2002 16:13
To: CF-Talk
Subject: OT (SQL): Add column to query
1 as column name
-Original Message-
From: Ryan Pieszak [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 20, 2002 11:29 AM
To: CF-Talk
Subject: RE: OT (SQL): Add column to query?
just in the returned query
-Original Message-
From: Jerry Johnson [mailto:[EMAIL PROTECTED]]
Sent
this is exactly right, just the query, not the table, and after I get the
results. thanks for clarifying.
-Original Message-
From: Hoag, Claudia (LNG) [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 20, 2002 11:30 AM
To: CF-Talk
Subject: RE: OT (SQL): Add column to query?
I think he
[mailto:[EMAIL PROTECTED]]
Sent: Monday, May 20, 2002 11:39 AM
To: CF-Talk
Subject: RE: OT (SQL): Add column to query?
this is exactly right, just the query, not the table, and after I get the
results. thanks for clarifying.
-Original Message-
From: Hoag, Claudia (LNG) [mailto:[EMAIL
-
From: Andre Turrettini [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 20, 2002 11:12 AM
To: CF-Talk
Subject: RE: OT (SQL): Add column to query?
do a google search on alter table
-Original Message-
From: Ryan Pieszak [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 20, 2002 9:13 AM
To: CF-Talk
QueryAddColumn(query, column-name, array-name)
Check the CF Docs :)
-Original Message-
From: Ryan Pieszak [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 20, 2002 11:39 AM
To: CF-Talk
Subject: RE: OT (SQL): Add column to query?
this is exactly right, just the query, not the table
,
for the help. A GREAT response on this list.
-Original Message-
From: Jerry Johnson [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 20, 2002 11:52 AM
To: CF-Talk
Subject: RE: OT (SQL): Add column to query?
And just to make his option set complete, he could add a column to the query
AFTER
before it gets back to the CF page and add
this column. Does that make it any clearer? Thanks.
-Original Message-
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 20, 2002 11:31 AM
To: CF-Talk
Subject: RE: OT (SQL): Add column to query?
This physically alters a table
14 matches
Mail list logo