|
 |
asp_web_howto thread: DB Connection Question
Message #1 by "Sidney James P. Fuerte" <fuertsj1104@y...> on Tue, 12 Feb 2002 00:12:22 +0800
|
|
Hi everyone,
I just want to know if the Database Connection terminates if you transfer
into another page. To elaborate this question further... Let's assume i'm in
page1.asp, i made a connection to the database from this page(page1.asp) if
I transfer to another page, lets say page2.asp, will the connection I made
in page1.asp still connected when I'm already at page2.asp? does this sound
confusing? I'm am cufused my self either :)
I'd appreciate any ideas about this :)
Thanks/Regards
Sidney
Message #2 by "Craig Flannigan" <ckf@k...> on Mon, 11 Feb 2002 16:06:02 -0000
|
|
Yes, it terminates.
When you leave the page, the connection and any objects are destroyed.
When you get to page2.asp, you'll need to re-establish the connection again.
-----Original Message-----
From: Sidney James P. Fuerte [mailto:fuertsj1104@y...]
Sent: 11 February 2002 16:12
To: ASP Web HowTo
Subject: [asp_web_howto] DB Connection Question
Importance: High
Hi everyone,
I just want to know if the Database Connection terminates if you transfer
into another page. To elaborate this question further... Let's assume i'm in
page1.asp, i made a connection to the database from this page(page1.asp) if
I transfer to another page, lets say page2.asp, will the connection I made
in page1.asp still connected when I'm already at page2.asp? does this sound
confusing? I'm am cufused my self either :)
I'd appreciate any ideas about this :)
Thanks/Regards
Sidney
$subst('Email.Unsub').
_____________________________________________________________________
This message has been checked for all known viruses by Star Internet
delivered through the MessageLabs Virus Scanning Service on behalf of
Kingfield Heath Ltd. For further information visit
http://www.star.net.uk/stats.asp
_____________________________________________________________________
This message has been checked for all known viruses by Star Internet
delivered through the MessageLabs Virus Scanning Service on behalf of Kingfield Heath Ltd. For further information visit
http://www.star.net.uk/stats.asp
Message #3 by "Sidney James P. Fuerte" <fuertsj1104@y...> on Tue, 12 Feb 2002 00:18:58 +0800
|
|
Thanks Craig! Thanks a lot =)
-----Original Message-----
From: Craig Flannigan [mailto:ckf@k...]
Sent: Tuesday, February 12, 2002 12:06 AM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: DB Connection Question
Yes, it terminates.
When you leave the page, the connection and any objects are destroyed.
When you get to page2.asp, you'll need to re-establish the connection again.
-----Original Message-----
From: Sidney James P. Fuerte [mailto:fuertsj1104@y...]
Sent: 11 February 2002 16:12
To: ASP Web HowTo
Subject: [asp_web_howto] DB Connection Question
Importance: High
Hi everyone,
I just want to know if the Database Connection terminates if you transfer
into another page. To elaborate this question further... Let's assume i'm in
page1.asp, i made a connection to the database from this page(page1.asp) if
I transfer to another page, lets say page2.asp, will the connection I made
in page1.asp still connected when I'm already at page2.asp? does this sound
confusing? I'm am cufused my self either :)
I'd appreciate any ideas about this :)
Thanks/Regards
Sidney
$subst('Email.Unsub').
_____________________________________________________________________
This message has been checked for all known viruses by Star Internet
delivered through the MessageLabs Virus Scanning Service on behalf of
Kingfield Heath Ltd. For further information visit
http://www.star.net.uk/stats.asp
_____________________________________________________________________
This message has been checked for all known viruses by Star Internet
delivered through the MessageLabs Virus Scanning Service on behalf of
Kingfield Heath Ltd. For further information visit
http://www.star.net.uk/stats.asp
$subst('Email.Unsub').
Message #4 by "Alfredo Yong" <alfredo_yong_linux@h...> on Mon, 11 Feb 2002 12:53:04 -0500
|
|
I'm almost sure that the connection is lost. Anyway the variables don't
survive in the redirected page, so only way to do this is viaa session
variable. BUT, for a number of reasons, storing objects in session variables
is a bad practice.
So open the connection again. I believe that there is some kind of "cache"
for connections, so closing and reopenning a connection is not as slow as
openning the connection for the first time.
-Alfredo
--
=================================================================
Alfredo_Yong@h...
Freelance Developer - Web systems
Expertise in ASP, DHTML, CSS, jscript, php, SQL & etc.
Available to contract.
Sidney James P. Fuerte <fuertsj1104@y...> escribió en el mensaje de
noticias 145035@a..._web_howto...
>
> Hi everyone,
>
> I just want to know if the Database Connection terminates if you transfer
> into another page. To elaborate this question further... Let's assume i'm
in
> page1.asp, i made a connection to the database from this page(page1.asp)
if
> I transfer to another page, lets say page2.asp, will the connection I made
> in page1.asp still connected when I'm already at page2.asp? does this
sound
> confusing? I'm am cufused my self either :)
>
> I'd appreciate any ideas about this :)
>
> Thanks/Regards
> Sidney
>
>
>
|
|
|
View Cart
