i 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:
Host 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 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?
I 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>"
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.
the code above - I want to send the email and then I want the window to close, however, everytime I do it, a messahe comes up saying: "Object Moved. This object may be found here." The email itself opens but the window doesn't close.
i have an Update button. according to flow operation, after customer clicks the button, the new data will be saved and i want to close the current window automatically. how to that?
I would like to capture window close event, i.e. when user clicks "X" button of the browser, I would like to close all open dataabse connections.
Also, I would like this to apply when a user tries to close browser using File > Exit or when the user tries to type another website URL in the browser.
I have a datagrid displaying data. There's an "edit" button, which I use Javascript to create a popup window where I can change the information. There's a "save" button on the pop up window.
Currently, I have to click the save button, and the the close button to close the pop-up window, go back to the calling page and refresh it before the information is updated in the calling page.
I would like to be able to use the "save" button on the pop-up window to close the pop-up AND reload the parent page. Is that possible?
I am maintaining a list of members of my site in a database. All members have an expiry date column in a table which is in mm/dd/yyyy format. I want that every members should be emailed on the day of their expiry automatically. I dnt wanna search for members and then mail then manually or if I m out on vacation it should do the work for me.
I have heard this can be done using triggers, but not sure how to use it.
Can u help me? also is there any other way apart from using triggers?
My requirement is to trigger an exe in the client. Once I click a button it should trigger an exe in the client machine itself. Any way of achieving this?
Is there a way I can call VB.net code from a stored procedure? I need to schedule a sql job (stored procedure) and in the logic of the stored procedure, I need to call vb.net code to generate a pdf document.
i wan to do a page at the backend,when the date is end of this year(12/31/2007) then will execute the code (such as add the new total leave with the current balance leave automatically without regresh the page or login into the system.)
i heard that the MS SQL SERVER got this triggered function, but unfortunately..the MS SQL SERVER hosting that i used(third party) didnt provide this function. i jz can store data in the table and create database..no more others component that i can use.
I know I've seen a tutorial on this, but can't locate it. I have a form that I've written that submits into a SQL database. I'd like it to fire off a notification email as well when an entry is submitted. Can someone point me to a tutorial that explains how I can do this?
What I want is for an action to be triggered when a user selects something on a dropdown box.
The something would actually be two variables. One 'static' in that the drop down would be 1, 2, 3, 4 the other being a variable in the true sense e.g. if selection A is 2 and selection B was 3 then the variable is 5 and this variable is the one I want to use to trigger events.
Using themes I could maybe do it but I am hoping there is a easier, more dynamic way to do it.
I made a Ventrilo Status script which basically when the user hits the page for the first time it initiates a batch file which triggers the creation of a text file in the wwwroot: Code:
1. I have a form, with a textbox and a button. I have to enter a value in the text box and then i have to click the button, which opens a popup window. Here i want to pass the value of the text box which is entered in the parent window to popup window.
I have to use that value in the popup window's form_load event in the Code behind, and i have to take the values from the database using the value which i have entered in the parent window. Code:
i am trying to insert a record into my database when a session times out, but the Session_OnEnd doesn't seem to be called... i read somewhere that it is not called but i didn't pay attention to it, and now it seems to be true.
Basically session_onend will not fire in my global.asa files! I have just made a very simple test to prove its not my programming and it still doesnt fire. Session_onstart works a treat but onend will not work even if you force the session to expire with abandon. I have tried on 2 of our servers now and it doesnt work on either.
my simple test is this:
Sub Session_OnEnd application("test") = "hello" End Sub
Now surely that should work. i obviously have a page that writes that test variable to the page but its always empty.
In my site I have a users system, when a user loges in his ID is placed in his cookies (cookies("uid")) so what I am trying to do is write a code in the Global.asa that will write in my DB whenever a loged user session starts and ends.
my problem is that the Session_OnEnd event does not support the use of cookies and even worse then that it does not support the CreateObject method in the Server Object with wich I connect to my DB.
So this is my code in the Global.asa, If you guys have any idea on how to make this code work, despite the disadvantages the Session_OnEnd Event has...
<script language="vbscript" runat="server"> Sub Application_OnStart Dim dbpath dbpath = Server.Mappath("data") & "db.mdb" application("CnStr_Main") = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & dbpath End Sub
sub Session_OnStart If request.cookies("uid")<>"" then Dim tmpconn,tmpRS,tmpDSNName,tmpsql Set tmpconn = Server.CreateObject("ADODB.Connection") Set tmprs = Server.CreateObject("ADODB.Recordset") tmpDSNName = application("CnStr_Main") tmpconn.Open tmpdsnname tmpsql = "SELECT * FROM users WHERE id=" & request.cookies("uid") tmprs.open tmpsql,tmpconn,3,3 if not tmprs.EOF then tmprs(12) = 1 tmprs.update end if tmprs.close tmpconn.close end if end sub
sub Session_OnEnd If request.cookies("uid")<>"" then Dim tmpconn,tmpRS,tmpDSNName,tmpsql Set tmpconn = Server.CreateObject("ADODB.Connection") Set tmprs = Server.CreateObject("ADODB.Recordset") tmpDSNName = application("CnStr_Main") tmpconn.Open tmpdsnname tmpsql = "SELECT * FROM users WHERE id=" & request.cookies("uid") tmprs.open tmpsql,tmpconn,3,3 if not tmprs.EOF then tmprs(12) = 0 tmprs.update end if tmprs.close tmpconn.close end if end sub </script>
So when *does* Session_OnEnd fire in my Global.asa file? Does it fire when they click a link to leave the site? Does it fire when the session times out?
I have an ASP application that is a electronic purchase orders system. My problem is that only 3 people can authorise a purchase order. When a purchase order is selected I update the table to show that the field is locked. If they complete the form then the database is updated and the lock is removed, all though at this stage the record moves into another part of the system and the lock becomes redundant. If however they dont complete the form the record is left in a permanent locked state, it could be that they decided to look at the record then navigated away or closed the browser. So i thought maybe i could stick some code that updates the database into the session_OnEnd in the global.asa, so after 20 minutes when the session has ended the lock will free. I don't however have any experience with this and don't even know if this will work. The code won't be a problem its just whether this process will actually work. I am thinking that I code put the order_id into a session variable then when the session variable ends i run a sub in the .asa file that gets the session variable and updates the table.
