--=====================_27595197==_.ALT
Content-Type: text/plain; charset="us-ascii"
oh-oh...
If this is right, then each user will clobber the previous user's query.
Does Cold Fusion cache queries per user session or globally at the server level?
Can I explicitly tell Cold Fusion to cache a query in the session scope instead of the
server scope?
At 03:02 PM 8/1/00 -0700, Scott Weikert wrote:
>Have your query grab the entire range of rows you're looking to show from
>the get-go - no MAXROWS - but cache it. Perhaps use a dynamically-generated
>query name so that two people hitting the page at the same time won't
>overwrite each other's query results.
>
>Then, instead of doing a straight out <CFOUTPUT QUERY="queryname">, do a
>loop for however many items you want to show - and refer to your query rows
>like you would an array - "queryname.firstname[1]". Use your loop variable
>in the brackets. Since you know how many items you're showing on each page,
>you can pass a page number of some sort back and forth, and calculate the
>start/end values.
>
>Say you've got 95 items in a query, and you want to show 20 at a time... so
>you'd have "1 2 3 4 5" as your links. "1" would pass an start variable of 1,
>"2" would pass 21, "3" 41, etc. and you'd use those variables as the "FROM"
>values in your loops, and "TO" would be that plus 19.
>
>> -----Original Message-----
>> From: Peter Theobald [mailto:[EMAIL PROTECTED]]
>> Sent: Tuesday, August 01, 2000 9:46 PM
>> To: [EMAIL PROTECTED]
>> Subject: Paging query results
>>
>>
>> --=====================_18393762==_.ALT
>> Content-Type: text/plain; charset="us-ascii"
>>
>> What is the accepted "best" method of paging query results?
>>
>> I am using STARTROW and MAXROWS to display one page at a
>> time, and calling the same page with different arguments to
>> change the page I am displaying... BUT this reexecutes the
>> query each time. This query searches through a large database
>> and takes a little time. This is a pretty inefficient way to
>> do it (I think).
>>
>> This must be a VERY common thing to do, so what is the
>> recommended way of doing it?
>> I don't want to pass hundreds or thousands of rows of data in
>> a variable...
>>
>> At 10:40 AM 8/1/00 -0700, Ray, James A wrote:
>> >Is there a way in a <FORM> to force Upper Case while using a <INPUT
>> >type="text">?
>> >
>> >Thank you.
>> >
>> >Jim Ray
>> >
>> >
>> >
>> >
>> >
>> >-------------------------------------------------------------
>> -----------------
>> >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>> >To Unsubscribe visit
>> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=list
>> s/cf_talk or send a message to
>> [EMAIL PROTECTED] with 'unsubscribe' in the body.
>>
>>
>> --------------------------------------------------------------
>> -------------
>> Peter Theobald, Chief Technology Officer
>> LiquidStreaming http://www.liquidstreaming.com
>> [EMAIL PROTECTED]
>> Phone 1.212.545.1232 Fax 1.212.679.8032
>>
>> --=====================_18393762==_.ALT
>> Content-Type: text/html; charset="us-ascii"
>>
>> <html>
>> <font size=3>What is the accepted "best" method of
>> paging query
>> results?<br>
>> <br>
>> I am using STARTROW and MAXROWS to display one page at a time, and
>> calling the same page with different arguments to change the page I am
>> displaying... BUT this reexecutes the query each time. This query
>> searches through a large database and takes a little time. This is a
>> pretty inefficient way to do it (I think).<br>
>> <br>
>> This must be a VERY common thing to do, so what is the
>> recommended way of
>> doing it?<br>
>> I don't want to pass hundreds or thousands of rows of data in a
>> variable...<br>
>> <br>
>> At 10:40 AM 8/1/00 -0700, Ray, James A wrote:<br>
>> <blockquote type=cite cite>Is there a way in a <FORM> to force
>> Upper Case while using a <INPUT<br>
>> type="text">?<br>
>> <br>
>> Thank you.<br>
>> <br>
>> Jim Ray<br>
>> <br>
>> <br>
>> <br>
>> <br>
>> <br>
>> --------------------------------------------------------------
>> ----------------<br>
>> Archives:
>> <a
>> href="http://www.mail-archive.com/cf-talk@houseoffusion.com/"
>> eudora="autourl">http://www.mail-archive.com/cf-talk@houseoffu
>> sion.com/</a><br>
>> To Unsubscribe visit
>> <a
>> href="http://www.houseoffusion.com/index.cfm?sidebar=lists&
>> ;body=lists/cf_talk"
>> eudora="autourl">http://www.houseoffusion.com/index.cfm?sideba
>> r=lists&body=lists/cf_talk</a>
>> or send a message to [EMAIL PROTECTED] with
>> 'unsubscribe' in the body. </font></blockquote><br>
>>
>> <font size=2><b><br>
>> --------------------------------------------------------------
>> -------------<br>
>> Peter Theobald, </b>Chief Technology Officer<br>
>> </font><font size=3 color="#0000FF"><b>LiquidStreaming
>> </b></font><a href="http://www.liquidstreaming.com/"
>> eudora="autourl"><font size=2
>> color="#0000FF"><u>http://www.liquidstreaming.com</a><br>
>> </u></font><font size=2>[EMAIL PROTECTED]<br>
>> <b>Phone</b> 1.212.545.1232 <b>Fax</b> 1.212.679.8032<br>
>> </font></html>
>>
>> --=====================_18393762==_.ALT--
>>
>> --------------------------------------------------------------
>> ----------------
>> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>> 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/cf-talk@houseoffusion.com/
>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.
---------------------------------------------------------------------------
Peter Theobald, Chief Technology Officer
LiquidStreaming http://www.liquidstreaming.com
[EMAIL PROTECTED]
Phone 1.212.545.1232 Fax 1.212.679.8032
--=====================_27595197==_.ALT
Content-Type: text/html; charset="us-ascii"
<html>
<font size=3>oh-oh...<br>
<br>
If this is right, then each user will clobber the previous user's
query.<br>
Does Cold Fusion cache queries per user session or globally at the server
level?<br>
Can I explicitly tell Cold Fusion to cache a query in the session scope
instead of the server scope?<br>
<br>
At 03:02 PM 8/1/00 -0700, Scott Weikert wrote:<br>
<blockquote type=cite cite>Have your query grab the entire range of rows
you're looking to show from<br>
the get-go - no MAXROWS - but cache it. Perhaps use a
dynamically-generated<br>
query name so that two people hitting the page at the same time
won't<br>
overwrite each other's query results.<br>
<br>
Then, instead of doing a straight out <CFOUTPUT
QUERY="queryname">, do a<br>
loop for however many items you want to show - and refer to your query
rows<br>
like you would an array - "queryname.firstname[1]". Use your
loop variable<br>
in the brackets. Since you know how many items you're showing on each
page,<br>
you can pass a page number of some sort back and forth, and calculate
the<br>
start/end values.<br>
<br>
Say you've got 95 items in a query, and you want to show 20 at a time...
so<br>
you'd have "1 2 3 4 5" as your links. "1" would pass
an start variable of 1,<br>
"2" would pass 21, "3" 41, etc. and you'd use those
variables as the "FROM"<br>
values in your loops, and "TO" would be that plus 19.<br>
<br>
> -----Original Message-----<br>
> From: Peter Theobald
[<a href="mailto:[EMAIL PROTECTED]"
eudora="autourl">mailto:[EMAIL PROTECTED]</a>]<br>
> Sent: Tuesday, August 01, 2000 9:46 PM<br>
> To: [EMAIL PROTECTED]<br>
> Subject: Paging query results<br>
> <br>
> <br>
> --=====================_18393762==_.ALT<br>
> Content-Type: text/plain; charset="us-ascii"<br>
> <br>
> What is the accepted "best" method of paging query
results?<br>
> <br>
> I am using STARTROW and MAXROWS to display one page at a <br>
> time, and calling the same page with different arguments to <br>
> change the page I am displaying... BUT this reexecutes the <br>
> query each time. This query searches through a large database <br>
> and takes a little time. This is a pretty inefficient way to <br>
> do it (I think).<br>
> <br>
> This must be a VERY common thing to do, so what is the <br>
> recommended way of doing it?<br>
> I don't want to pass hundreds or thousands of rows of data in <br>
> a variable...<br>
> <br>
> At 10:40 AM 8/1/00 -0700, Ray, James A wrote:<br>
> >Is there a way in a <FORM> to force Upper Case while using
a <INPUT<br>
> >type="text">?<br>
> ><br>
> >Thank you.<br>
> ><br>
> >Jim Ray<br>
> ><br>
> ><br>
> ><br>
> ><br>
> ><br>
>
>-------------------------------------------------------------<br>
> -----------------<br>
> >Archives:
<a href="http://www.mail-archive.com/cf-talk@houseoffusion.com/"
eudora="autourl">http://www.mail-archive.com/cf-talk@houseoffusion.com/</a><br>
> >To Unsubscribe visit <br>
>
<a href="http://www.houseoffusion.com/index.cfm?sidebar=lists&body=list"
eudora="autourl">http://www.houseoffusion.com/index.cfm?sidebar=lists&body=list</a><br>
> s/cf_talk or send a message to <br>
> [EMAIL PROTECTED] with 'unsubscribe' in the body.
<br>
> <br>
> <br>
> --------------------------------------------------------------<br>
> -------------<br>
> Peter Theobald, Chief Technology Officer<br>
> LiquidStreaming
<a href="http://www.liquidstreaming.com/"
eudora="autourl">http://www.liquidstreaming.com</a><br>
> [EMAIL PROTECTED]<br>
> Phone 1.212.545.1232 Fax 1.212.679.8032<br>
> <br>
> --=====================_18393762==_.ALT<br>
> Content-Type: text/html; charset="us-ascii"<br>
> <br>
> <html><br>
> <font size=3>What is the accepted &quot;best&quot;
method of <br>
> paging query<br>
> results?<br><br>
> <br><br>
> I am using STARTROW and MAXROWS to display one page at a time,
and<br>
> calling the same page with different arguments to change the page I
am<br>
> displaying... BUT this reexecutes the query each time. This
query<br>
> searches through a large database and takes a little time. This is
a<br>
> pretty inefficient way to do it (I think).<br><br>
> <br><br>
> This must be a VERY common thing to do, so what is the <br>
> recommended way of<br>
> doing it?<br><br>
> I don't want to pass hundreds or thousands of rows of data in
a<br>
> variable...<br><br>
> <br><br>
> At 10:40 AM 8/1/00 -0700, Ray, James A wrote:<br><br>
> <blockquote type=cite cite>Is there a way in a
&lt;FORM&gt; to force<br>
> Upper Case while using a &lt;INPUT<br><br>
> type=&quot;text&quot;&gt;?<br><br>
> <br><br>
> Thank you.<br><br>
> <br><br>
> Jim Ray<br><br>
> <br><br>
> <br><br>
> <br><br>
> <br><br>
> <br><br>
> --------------------------------------------------------------<br>
> ----------------<br><br>
> Archives:<br>
> <a <br>
>
href="<a href="http://www.mail-archive.com/cf-talk@houseoffusion.com/"
eudora="autourl">http://www.mail-archive.com/cf-talk@houseoffusion.com/</a>"
<br>
>
eudora="autourl"><a
href="http://www.mail-archive.com/cf-talk@houseoffu%3E%20sion.com/%3C/a%3E%3Cbr%3E%3E%20To%20Unsubscribe%20visit%3E%20%3Ca%20%3E%20href=%22http://www.houseoffusion.com/index.cfm?sidebar=lists&amp>
;body=lists/cf_talk" > eudora="autourl"
eudora="autourl">http://www.mail-archive.com/cf-talk@houseoffu<br>
> sion.com/</a><br><br>
> To Unsubscribe visit<br>
> <a <br>
>
href="http://www.houseoffusion.com/index.cfm?sidebar=lists&amp<br>
> ;body=lists/cf_talk" <br>
>
eudora="autourl</a>"><a
href="http://www.houseoffusion.com/index.cfm?sideba"
eudora="autourl">http://www.houseoffusion.com/index.cfm?sideba</a><br>
> r=lists&amp;body=lists/cf_talk</a><br>
> or send a message to [EMAIL PROTECTED] with <br>
> 'unsubscribe' in the body.
</font></blockquote><br><br>
> <br>
> <font size=2><b><br><br>
> --------------------------------------------------------------<br>
> -------------<br><br>
> Peter Theobald, </b>Chief Technology Officer<br><br>
> </font><font size=3
color="#0000FF"><b>LiquidStreaming <br>
> </b></font><a
href="http://www.liquidstreaming.com/" <br>
> eudora="autourl"><font size=2 <br>
>
color="#0000FF"><u><a href="http://www.liquidstreaming.com/"
eudora="autourl">http://www.liquidstreaming.com</a></a><br><br>
> </u></font><font
size=2>[EMAIL PROTECTED]<br><br>
> <b>Phone</b> 1.212.545.1232 <b>Fax</b>
1.212.679.8032<br><br>
> </font></html><br>
> <br>
> --=====================_18393762==_.ALT--<br>
> <br>
> --------------------------------------------------------------<br>
> ----------------<br>
> Archives:
<a href="http://www.mail-archive.com/cf-talk@houseoffusion.com/"
eudora="autourl">http://www.mail-archive.com/cf-talk@houseoffusion.com/</a><br>
> To Unsubscribe visit <br>
<a href="http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk"
eudora="autourl">http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk</a>
or<br>
send a message to [EMAIL PROTECTED] with 'unsubscribe' in<br>
the body.<br>
------------------------------------------------------------------------------<br>
Archives: <a href="http://www.mail-archive.com/cf-talk@houseoffusion.com/"
eudora="autourl">http://www.mail-archive.com/cf-talk@houseoffusion.com/</a><br>
To Unsubscribe visit <a
href="http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk"
eudora="autourl">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. </font></blockquote><br>
<font size=2><b><br>
---------------------------------------------------------------------------<br>
Peter Theobald, </b>Chief Technology Officer<br>
</font><font size=3 color="#0000FF"><b>LiquidStreaming </b></font><a
href="http://www.liquidstreaming.com/" eudora="autourl"><font size=2
color="#0000FF"><u>http://www.liquidstreaming.com</a><br>
</u></font><font size=2>[EMAIL PROTECTED]<br>
<b>Phone</b> 1.212.545.1232 <b>Fax</b> 1.212.679.8032<br>
</font></html>
--=====================_27595197==_.ALT--
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
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.