473,394 Members | 1,663 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,394 software developers and data experts.

Does a response.redirect process the rest of the page?

Pretty straight forward. Reason I'm asking is because I'm not sure if I
should explicitly close my recordset and database connections before each
redirect or get away with having a one time close at the bottom of my page.
Thanks for the help.
Jul 19 '05 #1
3 1552
Seth wrote:
Pretty straight forward. Reason I'm asking is because I'm not sure if
I should explicitly close my recordset and database connections
before each redirect or get away with having a one time close at the
bottom of my page. Thanks for the help.


Redirect does what it says. Nothing else is processed. My practice is to
process database objects first, closing and destroying them when fineshed.
THEN make decisions as to whether to redirect or not.

Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
Jul 19 '05 #2
Bob Barrows [MVP] wrote:
Seth wrote:
Pretty straight forward. Reason I'm asking is because I'm not sure if
I should explicitly close my recordset and database connections
before each redirect or get away with having a one time close at the
bottom of my page. Thanks for the help.


Redirect does what it says. Nothing else is processed. My practice is
to process database objects first, closing and destroying them when
fineshed. THEN make decisions as to whether to redirect or not.

Just to clarify, by "process", I mean:
Assign the data contained in the database objects to variables (including
using GetRows to assign the data to an array, or GetString to create a
string containing the data, if I need to process multiple records). After
this operation, there is no longer any need to keep the database objects
open, so at this point, I close and destroy them.

NOW I process the variables containing the data, writing them to response,
or making decisions as to whether or not to redirect, etc.

Bob Barrows

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
Jul 19 '05 #3
Thanks for the help. Seems like I've got quite a bit of change, I've assumed
that the rest of the page is processed.

"Bob Barrows [MVP]" <re******@NOyahoo.SPAMcom> wrote in message
news:u6**************@tk2msftngp13.phx.gbl...
Bob Barrows [MVP] wrote:
Seth wrote:
Pretty straight forward. Reason I'm asking is because I'm not sure if
I should explicitly close my recordset and database connections
before each redirect or get away with having a one time close at the
bottom of my page. Thanks for the help.


Redirect does what it says. Nothing else is processed. My practice is
to process database objects first, closing and destroying them when
fineshed. THEN make decisions as to whether to redirect or not.

Just to clarify, by "process", I mean:
Assign the data contained in the database objects to variables (including
using GetRows to assign the data to an array, or GetString to create a
string containing the data, if I need to process multiple records). After
this operation, there is no longer any need to keep the database objects
open, so at this point, I close and destroy them.

NOW I process the variables containing the data, writing them to response,
or making decisions as to whether or not to redirect, etc.

Bob Barrows

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

Jul 19 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: CB | last post by:
I have what must be a very common design issue in web programming, probably discussed 2000 times already, but I can never find any mention by searching. In particular I have a web page with a...
6
by: dotnettester | last post by:
Woud this work? ..... Response.end set objConn = nothing set objAnyObject = nothing ?
2
by: RAJ | last post by:
In our multi-tier application, we have several ASP.NET user controls which will update the same data source provided by middle tier logic. In this particular scenario we have one user control...
2
by: Mark Rae | last post by:
Hi, I have a fairly simple site, the vast majority of which is available to everyone on the public internet. However, the site has one section which requires logon via the standard...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.