--=====================_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/[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. 


---------------------------------------------------------------------------
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 &quot;best&quot; 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 &lt;FORM&gt; to force
Upper Case while using a &lt;INPUT<br>
type=&quot;text&quot;&gt;?<br>
<br>
Thank you.<br>
<br>
Jim Ray<br>
<br>
<br>
<br>
<br>
<br>
------------------------------------------------------------------------------<br>
Archives:
<a href="http://www.mail-archive.com/[email protected]/" 
eudora="autourl">http://www.mail-archive.com/[email protected]/</a><br>
To Unsubscribe visit
<a href="http://www.houseoffusion.com/index.cfm?sidebar=lists&amp;body=lists/cf_talk" 
eudora="autourl">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. 
</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/[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