Well, that's what I thought. But with a really huge table you have to cache this query, because it takes time, at least on a PIII :>
Tim, thanks. Daniel At 03:47 PM 12/14/2001 -0600, you wrote: >we do this... hopefully it makes sense > ><cfquery name="qGetNumMsgs" datasource="#ds#"> >select count(imessageid) as msgcount from messages where >ithreadid=#threadid# ></cfquery> > >then you have the number of messages and it only returned one record to do >it. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. ------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
