Which is the most efficient way to hit the database: 1) to open/close the
connection for each call to the database on a page (we have Subs that do
this); 2) or use the same connection and close it at the end? My feeling is
that 2 is better, but just wanted to confirm with the experts.
I'm looking at another developers code and I'm now confused about the correct way to close a database connection and destroy the object. I would normally do it this way: Code:
View Replies View RelatedRather than opening and closing a new connection to the database on every page, I have placed that connection into an Application variable. This has worked fine so far.
My issue is that I have a logoff page where it closes that connection.But this means that users who are on the application will not be able to access that connection.The obvious answer is that I don't close the database connection.But my problem is, I would like to eventually close that database connection.
How can I determine if an application variable (not session variable) exists?How can I determine that there are not any users on the application?
Can I use ASP code to close the current window?
View Replies View Relatedi have quotation_start.asp which was set to be a small window (height=250, width=500). there is a YES button and some data on this page. when user clicks YES, data will be saved into database, quotation_start.asp will be closed automatically and a new page, quotation_admin.asp will appear in the main window at rightFrame. everything is ok except the quotation_start.asp never close. it remains there. here is the code:
View Replies View Relatedi want to know a way to end the session as the user closes the window. As the user closes the reg_conf.asp page, i want the session of this user to end as well. how to do? how to detect the closing of the browser? ive used global.asa.
View Replies View RelatedI made a popup for uploading some files.My popup looks like this:
function openpopup(){
var popurl="upload_tst.asp"
winpops=window.open(popurl,"","width=400,height=400,")
<a href="javascript:self.close()">close </a>
}
</script>
My problem is that I cannot close the popup.
I am trying to set a cut off limit date on my page. For example if the class limit is 40, it should automatically close the registrations. How would I code for that ?
This code was written by someone elase. But I have to add this functionality of setting limits. The code is:
Code:
<td bgcolor="#EEEEEE"><div align="left" class="style26"><span class="style4"><%=(rs_ClassInfo.Fields.Item("ClassLimit").Value)%></span></div></td>
Pls what code can i use to automatically close and asp page after execution.
View Replies View RelatedHost Environment: IIS in window 2003 server, three web servers, one load balance, ASP (not ASP.net) code set.There is part A codes in one asp page (page A) to open a new window (Window B). The new window like a clock non-stop running. There is part B codes in
the page A need to close window B.
There is no problem if the there is only one web server. It works. When there is a load balance and more than one web server, then the window B can not be closed.
I suspect i don't close well my recordset.how can i CLOSE / FREE / RELEASE
recordSets and connections
in order to avoid server memory loss?
When I user decisedes to leave my site.How can I detect that imidietly and trigger code to run from that?
View Replies View RelatedIs it possible to move to all the open RS and connections? I open different recordsets on my page and in the end I need to close them and close connection. Problem is I need a function to do that to have it on every page.
Is it possible to travel through all open recordsets like it is possible to travel through all the querystrings and form data?
i have a exit button...where when i click on it..it should show msg box..asking whether to close the form or not?..if yes it should colse the form and show the main form...if no..it should redirect to the same form..hw to do this using asp.
View Replies View RelatedI have developed an ASp files i have used lot of objects in it like recordset and connection objects, but some of the objects is not being closed.so is it possbile to write a code which automatically closes all the objects opened without mentioning the name given to the object.
View Replies View Relatedhow to close all open database connections without referring to each connection by name across an entire server?
View Replies View RelatedI have a general question. In my asp page, I have DB connection, Recordset,
and some variables like
dim name, conn, rs
set conn = Server.CreateObject("ADODB.Connection")
....
set rs= server.createObject("ADODB.Recordset")
name = rs("username")
I know I need to close the connection like
conn.close
set conn = nothing
Do I need to close the recordset and variables? What is the reason?
When using "window.close", a dialog box ask u to comfirm, how to disable it ?
View Replies View RelatedWhat's the best way to close current window silently after finished a
process.
I'm using the the javascritpt window.close() or top.window.close(), but it
fires a confirmation window.
Just want to close it without any confirmation, seems I done it before, but
can't find where.
I have a system of pages set up on an intranet that uses a top frame and left frame for much of the navigation. But I would like to allow the people viewing the pages to close and reopen the frameset thus allowing more room to view the content. Is there a way that I can make a button either close or just resize the nav frames without losing the content page...
I think that a resize option would be the best that way I can just put a link on the frame and resize it to where only the link is viewable.
I wrote an ASP page to export data from the database to an excel spreadsheet file. The problem is, after the user saved the file to his/her hard drive, the export browser window still remains. How do I close the export window after users saved the file?
View Replies View RelatedI am calling an asp page from my flash file & the asp code is as follows: Code:
View Replies View RelatedI want to close the window without the warning "internet explorer is trying to close..." being displayed. I want to do this with vbscript. I found out that in javascript you can do it by including window.opener='x' followed by the window.close statement.My code is:
Code:
Response.Write "<script type=""text/vbscript"">"
Response.Write "MsgBox ""Hi. see you again"""
Response.Write vbcrlf
Response.Write "window.close"
Response.Write "</script>"
is thr anyway i can get this done in this code?
I use window object with close method to close a web page, this web page is
designed by active server page and VBscript. the code is as follows:
window.close()
however, an alart messege comes from IE. It's details: The Web page you are
viewing is trying to close the windows. Do you want to close this windows?
I want to directly close the window without any alart messege. In VBA, we
can add a declare Application.displayalart =false.
How to do this in html or VBA?
I have a site which has extensive database activity. What I do is for each procedure I open a connection to the database and close it as and when I leave the procedure. However, in long run I find that some connection to the database is not properly closed causing the site to hang. This has become a big headache for me.
Trying to find what is going wrong I logged opening /closing of connections to the database and found that at some points the connections are not closed resulting in large no. of active connections to the database.
But if I go through the script I cannot really understand why that connection was not closed since the script ensure that the connection is closed before exiting the procedure.
Is there any way where I can check the database may be during night time and close all existing connections to the database. I repeat all my connections to the database are done at the procedure level.
Is the following ok, or do I need to add the commented chunk in?: Code:
View Replies View Relatedwhich event is fired when a browser is closed. i want to call asp page which deleet some files on the server. i tired using onunload event but it aslo get fired when a page is refreshed. the thing should work in netsacpe also.
View Replies View RelatedIm writting an asp app that tracks the users scores and info (its a
training app) to a access database, ive disabled the ie toolbars and
everthing so the user must use my nav buttons so i can track what pages
they have been to.
My problem is if the user closes IE with the close button [X], is there a
way i can redirect them to my close database and save results page, i cant
use the unload event as this is trggered every time the use goes to the
next page.
where do I go wrong?I tried closing the first connection and then reopen so that I can view the "results" table. But it doesn't work entirely.
Quote:
ADODB.Recordset error '800a0bb9'
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
I am doing a bit of ASP and I have created a new object, for example:
set sourceDOM=Server.CreateObject("Microsoft.XMLDOM")
When I am done with the code do I need to worry about killing or closing this object? If so, how?
In an asp page I have the following scenario happening (or would like
to happen)
person picks a menu item in main page which opens a popup window that
allows customization of that menu item. Upon submitting that page the
results go to a second page in the popup window for collection into
variables.
I was hoping to just close that second page, but
everything I have tried results in a message window stating the
program is trying to close the page (y or n). I was hoping to get rid
of this, but can't seem to no matter how hard I try.
There are many examples on here that seem rather old and may have
worked with former versions of IE without problem, but none have
worked how I wanted.
Does anyone have suggestions on how I could get the above...or even
modify things so that maybe the original popup window can be
closed...I do wonder if its the fact that a second page has been
opened in the popup window.
I am using JAVA to write a program that will open a socket and print
something to server side.
then I have close the socket in the JAVA already
If I just running the .class file in command mode, it can be close the
socket
but if I using set objJAVA = getObjcet("java:classFile") in ASP
it since cannot close the socket, since the socket status is TIME_WAIT when
I type "netstat -a" after running the ASP.
Can anyone give me a simply and short paragraph answer to the quest : How does ASP close/exit an application?
View Replies View Related