Hola,
If you need to manipulate/sort the same data over and over you might be
better off saving the recordset as a structure or wddx in a session or
client or cookie variable (or as wddx in a temp db table).
You would need to stick it in a structure first.
If you are using HTML4 browsers you could manip this data client side WDDX +
javascript or IE4 cvs control using a dynamically generated data file..
Hope that helps
Justin
> Thanks!
>
> In my case, going back to the DB again would waste a lot of time as the
> query is rather complex and gets the information from several tables. I�m
> sure a custom tag will greatly increase performance anyway!
>
> Thanks again!
>
>
> -----Mensaje original-----
> De: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
> Para: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
> Fecha: martes 25 de julio de 2000 14:24
> Asunto: RE: Query manipulation
>
>
> >There are a number of CF components for sorting queries (including one by
> >me), with varying features. See
>
>http://devex.allaire.com/developer/gallery/SearchResults.cfm?keywords=query
> +
> >and+sort&search=search. Note that these won't have the advantage of
> prebuilt
> >indexes that your database should have, and so may not actually be faster
> >than going back to the DB; I've used them mostly in cases where the DB
> >cannot perform the sort.
> >
> >
> >-----Original Message-----
> >From: Francisco Montes; Spain on Line [mailto:[EMAIL PROTECTED]]
> >Sent: Tuesday, July 25, 2000 8:08 AM
> >To: [EMAIL PROTECTED]
> >Subject: Query manipulation
> >
> >
> >This is a multi-part message in MIME format.
> >
> >------=_NextPart_000_0266_01BFF641.C4C81FA0
> >Content-Type: text/plain;
> > charset="iso-8859-1"
> >Content-Transfer-Encoding: quoted-printable
> >
> >Hi all!
> >
> >I would like to order the results present in a query by one of its =
> >fields. In order to optimise application performance i would like to =
> >avoid further accesses to the database in order to retrieve the same =
> >results again ordered by the field i want.
> >
> >Is there a way i could do it? I=B4ve read about ArraySort but i=B4m not =
> >sure of how could i apply this function to my query (i suspect i would =
> >have to convert it to a structure first).
> >
> >Thanks a lot in advance.
> >
> >Francisco
> >
> >
> >------=_NextPart_000_0266_01BFF641.C4C81FA0
> >Content-Type: text/html;
> > charset="iso-8859-1"
> >Content-Transfer-Encoding: quoted-printable
> >
> ><!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">
> ><HTML>
> ><HEAD>
> >
> ><META content=3Dtext/html;charset=3Diso-8859-1 =
> >http-equiv=3DContent-Type>
> ><META content=3D'"MSHTML 4.72.3110.7"' name=3DGENERATOR>
> ></HEAD>
> ><BODY bgColor=3D#ffffff>
> ><DIV><FONT size=3D2>Hi all!</FONT></DIV>
> ><DIV> </DIV>
> ><DIV><FONT size=3D2>I would like to order the results present in a query
=
> >by one of=20
> >its fields. In order to optimise application performance i would like to
=
> >avoid=20
> >further accesses to the database in order to retrieve the same results =
> >again=20
> >ordered by the field i want.</FONT></DIV>
> ><DIV><FONT size=3D2></FONT> </DIV>
> ><DIV><FONT size=3D2>Is there a way i could do it? I´ve read about =
> >ArraySort=20
> >but i´m not sure of how could i apply this function to my query (i
=
> >suspect=20
> >i would have to convert it to a structure first).</FONT></DIV>
> ><DIV><FONT size=3D2></FONT> </DIV>
> ><DIV><FONT size=3D2>Thanks a lot in advance.</FONT></DIV>
> ><DIV><FONT size=3D2></FONT> </DIV>
> ><DIV><FONT size=3D2>Francisco</FONT></DIV>
> ><DIV><FONT size=3D2></FONT> </DIV></BODY></HTML>
> >
> >------=_NextPart_000_0266_01BFF641.C4C81FA0--
> >
>
>---------------------------------------------------------------------------
> -
> >--
> >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.
>
>---------------------------------------------------------------------------
> ---
> >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.
>
> --------------------------------------------------------------------------
----
> 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.
>
>
------------------------------------------------------------------------------
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.
