RE: OT (SQL): Add column to query?

2002-05-20 Thread Andre Turrettini
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

Re: OT (SQL): Add column to query?

2002-05-20 Thread Jerry Johnson
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

RE: OT (SQL): Add column to query?

2002-05-20 Thread Adrian Lynch
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

RE: OT (SQL): Add column to query?

2002-05-20 Thread Ryan Pieszak
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

RE: OT (SQL): Add column to query?

2002-05-20 Thread Andy Ewings
... -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

RE: OT (SQL): Add column to query?

2002-05-20 Thread Hoag, Claudia (LNG)
]] 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

RE: OT (SQL): Add column to query?

2002-05-20 Thread Ryan Pieszak
-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

RE: OT (SQL): Add column to query?

2002-05-20 Thread Joshua Tipton
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

RE: OT (SQL): Add column to query?

2002-05-20 Thread Ryan Pieszak
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

RE: OT (SQL): Add column to query?

2002-05-20 Thread Hoag, Claudia (LNG)
[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

RE: OT (SQL): Add column to query?

2002-05-20 Thread Jerry Johnson
- 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

RE: OT (SQL): Add column to query?

2002-05-20 Thread Jeff Beer
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

RE: OT (SQL): Add column to query?

2002-05-20 Thread Ryan Pieszak
, 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

RE: OT (SQL): Add column to query?

2002-05-20 Thread Ryan Pieszak
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