That sounds like a good solution.  How do you export a query to Excel?
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, February 21, 2002 1:15 PM
Subject: [CFTALKTor] Netscape Query


> I have experienced similar issues that are not necessarily browser
> dependant.  Basically, if your output exceeds a certain number of rows,
you
> will overwhelm the client's browser.  The number may be higher for IE, but
> it will not be infinite.
>
> The way I dealt with it was as follows,
>
> On the search page, offer the user the option of exporting to Excel.
>
> If the user chooses to not export the results, I do a record count.  If it
> exceeds a certain number ( 1000 I think), I display a message telling him
> he has too many  records and that he can either tighten up his search
> parameters (usually start and end date), or export the results to Excel.
>
> If you are talking about many thousands of rows, you may want to take the
> maximum number of rows in Excel into account.
>
>
> *********************
>
> Hello All,
>
> I have an issue with a query that I have running on a particular page.
The
> query brings back a large number of records, the query works in Exporer
but
> seems to make netscape crash.  I thought about just showing a number of
> records and having a next button for the next records.  But my client
wants
> to print off this report.
>
> They have to use netscape IE is not an option.  Is there a way to output a
> large number of records to netscape so that the results can be printed
out?
>
> -
> You are subscribed to the CFUGToronto CFTALK ListSRV.
> This message has been posted by: [EMAIL PROTECTED]
> To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/
> Manager: Kevin Towes ([EMAIL PROTECTED])
http://www.CFUGToronto.org/
> This System has been donated by Infopreneur, Inc.
> (http://www.infopreneur.net)
>


-
You are subscribed to the CFUGToronto CFTALK ListSRV.
This message has been posted by: "Mike" <[EMAIL PROTECTED]>
To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/
Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/
This System has been donated by Infopreneur, Inc.
(http://www.infopreneur.net)

Reply via email to