--------------14FFAE88FACB0987D527797F
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Frank,
You can manipulate queries in memory on the CF server, there is even a tag in the dev
exchange where you can sort the existing CF query.
-Construct your in memory query using querynew(columnlist)
-Add a row using queryaddrow(queryname)
-Set the values of each cell in the row using querysetcell()
-and then sort it using the tag from the dev exchange.
In similar situations this has worked well for me in the past, although obviously is
quite server intensive.
Jared Clinton.
advertisement : People interested in hiring me in a full time capacity in Melbourne,
Victoria, Australia please email [EMAIL PROTECTED] I will respond promptly.
Thank you.
Frank Mamone wrote:
> We have several tables containing articles for our Intranet. What we want to
> do is output one list with all the articles sorted by date regardless of
> what table they came from.
>
> Right now we are grouping them and adding a header on the display page for
> each group. We want to get rid of the headers and produce one list.
>
> Any ideas?
>
> ------------------------------------------------------------------------------
> Archives: http://www.mail-archive.com/[email protected]/
> To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
>message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
--------------14FFAE88FACB0987D527797F
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit
<!doctype html public "-//w3c//dtd html 4.0 transitional//en">
<html>
Frank,
<p>You can manipulate queries in memory on the CF server, there is even
a tag in the dev exchange where you can sort the existing CF query.
<br>-Construct your in memory query using querynew(columnlist)
<br>-Add a row using queryaddrow(queryname)
<br>-Set the values of each cell in the row using querysetcell()
<br>-and then sort it using the tag from the dev exchange.
<p>In similar situations this has worked well for me in the past, although
obviously is quite server intensive.
<p>Jared Clinton.
<p>advertisement : People interested in hiring me in a full time capacity
in Melbourne, Victoria, Australia please email [EMAIL PROTECTED] I
will respond promptly. Thank you.
<p>Frank Mamone wrote:
<blockquote TYPE=CITE>We have several tables containing articles for our
Intranet. What we want to
<br>do is output one list with all the articles sorted by date regardless
of
<br>what table they came from.
<p>Right now we are grouping them and adding a header on the display page
for
<br>each group. We want to get rid of the headers and produce one list.
<p>Any ideas?
<p>------------------------------------------------------------------------------
<br>Archives: <a
href="http://www.mail-archive.com/[email protected]/">http://www.mail-archive.com/[email protected]/</a>
<br>To Unsubscribe visit <a
href="http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk">http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk</a>
or send a message to [EMAIL PROTECTED] with 'unsubscribe'
in the body.</blockquote>
</html>
--------------14FFAE88FACB0987D527797F--
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
