And just to make his option set complete, he could add a column to the query AFTER it is returned to CF.
<cfset myColFiller=arrayNew(1)> <cfset temp=ArraySet(myColFiller, 1, myQuery.recordCount, '24')> <cfset temp=QueryAddColumn(myQuery, 'myCol', myColFiller)> Again, this is not the best way. Jerry Johnson >>> [EMAIL PROTECTED] 05/20/02 11:29AM >>> I think he doesn't want to alter the table... just the results. And it's not during the query, it's after you get the results... right? Otherwise you could query like select col1, col2, col3, '24' as myCol from mytable -----Original Message----- 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 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 this query: Col1 Col2 Col3 1 a 10 2 b 11 3 c 12 4 d 13 5 e 14 6 f 15 But I'd like to add a column to this query later in the process, so I'd have this: Col1 Col2 Col3 myCol 1 a 10 24 2 b 11 24 3 c 12 24 4 d 13 24 5 e 14 24 6 f 15 24 Is there a queryAppend, or something I can use to add a column to a query in MSSQL? If it makes a difference, every value in the added column will be the same. Thanks for any help. Ryan ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists