Re: Sort many tables Problem!

Mon, 10 Jul 2000 16:25:40 -0700 


--------------397562645314B88D00B60DAB
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Haha, I'd like to amend this :

was

> <incorrect>  [EMAIL PROTECTED] </incorrect>
>

is
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.

Thank you again.

Jared Clinton wrote:

> --------------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&nbsp; 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.&nbsp; 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&amp;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.

--------------397562645314B88D00B60DAB
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit

<!doctype html public "-//w3c//dtd html 4.0 transitional//en">
<html>
Haha, I'd like to amend this :
<p>was
<blockquote TYPE=CITE>
<pre>&lt;incorrect>&nbsp; [EMAIL PROTECTED] &lt;/incorrect></pre>
</blockquote>

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

--------------397562645314B88D00B60DAB--

------------------------------------------------------------------------------
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.

Reply via email to