Word of warning, though, you will have to loop through the record set and add the value one record at a time. Not a big deal for small stuff, but I ran into the same problem and it was prohibitively slow with a large (5000+) records. Always better to let the db do stuff like that if possible.
OR Is if possible to do every column at once? I've tried QofQ, but that doesn't allow update statements, which would be super. Or is there to do a querySetCell(), but have if affect all records, and have it set it to each records information like SET col3 = col1 + col2 ???? Matthew P. Smith Web Developer, Object Oriented Naval Education & Training Professional Development & Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] >>-----Original Message----- >>From: Brian Scandale [mailto:[EMAIL PROTECTED]] >>Sent: Monday, September 23, 2002 12:09 PM >>To: CF-Talk >>Subject: Re: Add Column to Query... >> >>That looks very promising! and jeeze... right under my nose the whole >>time. That's embarrassing. Thanks Jochem >> >>At 01:53 AM 9/23/02, you wrote: >>>Brian Scandale wrote: >>>> How do I go about adding a column to a query dataset? >>> >>>QueryAddColumn()? >>> >>>Jochem >>> >>> >> ______________________________________________________________________ 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