I am trying to run a query after the browser window is closed. I need it to delete a value from the database when window is closed.
If it deletes it minutes after its closed that is fine as well. I just need some way to automatically delete information from the table when the user leaves the site.
I have an asp page (parent) which opens a new window (child) with "window.open()". What i want is, when the child window is closed with "self.close()" then the parent window has to be refreshed. Any of you guys know how to do this?
View Replies View Relatedmy objective is to click on an image and use the file path of the image as the variable in the next query, hence re running the same query but with "WHERE imageb " and not "WHERE imagea " with the value of imageb replacing min_vsim on the next query. this query can be excecuted preferebaly by a mouse click on the url of the image. Code:
View Replies View Related1. 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:
yes i did close the connection, infact ultradev did this for me. This works before, I mean in other files and I am using the same format to build new pages.
View Replies View Relatedhow to make a window explorer closed tiself like after 1 min? I think I rem there is such function available but I had forgotten the function/code...
View Replies View RelatedIn my page I run one sp to retrieve client details, loop through that and use another to retrieve details relating to each client. The first sp returns records correctly but i get the message "Operation is not allowed when the object is closed" .
when i try to use the second one. I have checked permissions and connections. I have printed out the variables i am passing as parameters and have tried running the sp from sql and it works fine.
I have to do an ASP page with sort of an SQL command to insert in data stored in a access database.
So, I whipped up a simple web page just for visitors to my web to key in name, email and comments about my page, and then it'll save these to a access database. And i got this error: Code:
Recently, I've been encountering some problems with one of my VB Scripts.
Very often, the results that is generated from running the script is truncated. (The results are written into a text file on the server and is picked up by another program for printing).
I've looked through the code at least a hundred times but do not seem to know where the problem lies.
After questioning the users more closely, I discovered that they switched the computer off while the script is still running (it tends to take about an hour or so due to intensive searches on very big sized databases).
My question is : will the script still run to completion in this case? I'm at my wits end trying to figure out what went wrong.
In asp is it possible to set the see if a user closed their browser.
Example if a user logged in but closes his browser I want it to say he is logged off.
As well does any one know how transfer data form a database to flash using ASP?
So I have this database working JUST fine for a week, then I add another table to it and then this is where things starting getting crazy. Here is my db conn code:
View Replies View RelatedI have several pages ( ASP) that were working OK on NT4. We moved it to Server 2003. At random , it appears that the Server.CreateObject fails.
I've looked through the code and it looks OK. Is there an easy way to make sure I have Closed all CONNECTIONS RecordSets etc.
I am getting the error 3704 "Operation is not allowed when the object is closed.Operation is not allowed when the object is closed." The problem is when no record is returned from the stored procedure. If there is a record, I do not get this error. Here is the portion of the code giving me problems.
rs.open strSql, strConnect
if rs.eof = true or rs.bof = true then
bEof = true
end if
The line in red is what gives me the error. If I take out that section, I do not receive an error. Any suggestions? I can easily get around this by putting in an on error resume next, but I'm trying to get this to work without errors first.
ADODB.Recordset error '800a0e78'
Operation is not allowed when the object is closed.
/apply/reporting/report.asp, line 22
I am trying to return a recordset from a stored procedure into an ASP page with the following code.... Code:
I have several pages ( ASP) that were working OK on NT4.
We moved it to Server 2003. At random , it appears that the
Server.CreateObject fails.
I've looked through the code and it looks OK.
Is there an easy way to make sure I have Closed all
CONNECTIONS
RecordSets
etc.
I want to provide a lookup facility for users to select a code from a list. I want this to be done in a small popup window, which, when a code is selected, will close down and return the selected value to the main form. Can this be done ??
View Replies View RelatedI'am not familiar wit ASP but I have to maintain an application. In a window there are some text selection fields and a search button. If you press on the search button record list is build according to what is filled in the selection fields. You can select a record and then a detailed window is shown or in another occasion a popup window is shown.
The request is now if the opened window or popup window is closed, then the opener window has to be opened with the same content (content selection fields + record list) as it was before the window or popup is opened.
Now I thought that I have read that every window which is opened gets an ID and that it is possible to call up that window by the ID from the cache again. Is that right? And if so? Or has somebody a better idea. Code:
I'm working on a quick wrapper so that I can connect to a database, run a quick query, get the needed info and pass it on to the next page that needs it. I've been programming for a long time but not with ASP/VBscript and think it's just something stupid that I've overlooked. Code:
View Replies View RelatedI have the following stored procedure:
[code....]
I'm getting the error "operation is not allowed when the object is closed" on the following line:
<% If Not rsAlloAmts.EOF Or Not rsAlloAmts.BOF Then %>
I haven't dealt we this particular type of situation and not sure how I can bind the necessary values to the page based on what is passed in to the procedure. I'm not sure how to handle this type of logic on the page?
I have a problem with my programm and get the error above. In the file I've commented the relevant lines with **** and normaly the SQL-statement are in one row but there is a better overview when it looks like this.
View Replies View RelatedMy code retrieves a username and a password from a form. Then this information is compared to some usernames and passwords that are stored in a database. The important thing here is that the comparison must be case sensitive meaning that "passWord" is not the same thing as "password"
I have this code, working fine in access 2003
SQL = "SELECT * FROM users WHERE StrComp(username_column,'" & entered_username_in_form & "',0) = 0 AND StrComp(password_column,'" & entered_password_in_form & "',0) = 0"
but get the following error when I run it against my sql 2005 database.
[Microsoft][SQL Native Client][SQL Server]'StrComp' is not a recognized built-in function name.
I don't know the corresponding t-sql for the query.
I am running a querry on an access database and have set the number of records/page displayed at 20. if there are more than 20 records returned, then 1st page will show the first 20, the next page will show next 20 and so on....
The trouble:
the count of total records displayed is correct and the first page is displayed correctly. But when i click on *Next* to go to the next page, all the records of the database get displayed (not the 2nd page of records from the query).
I am using ASP/MS ACCESS to see how I can query the same database, via 2 formfields.
{name: - search}Textfield 1: - Search by Category
AND/OR By
{name: - searchT}Textfield 2: - Location
Currently,
strSearchwords = Trim(Request.QueryString("search")); where "search" is the name of Textfield1
Which is fine, but how can I set it so that on Submit, the string from search, and searchT are somehow joined together into one string?
In Access you use "*" + [passed variable] + "*", + can be replaced with &
Calling a parameterized query in Access requires % be used in place of *,
however, all that I have read show dynamic SQL passed to Access:
WHERE [some column] LIKE '" & ASPvar & "' % ORDER BY ...
However, my call is similar to:
conn.qMyLookup strVar, rs
If I modify the query in Access to:
"%" & [passed variable] & "%"
I get all records. If I only put it at the end, as suggested, I only get
matches at the end, not throughout the column. Code:
i am opening a file by window.open by clicking on a button.
how i can validate that button is clicked or not.
means file is opened or not through javascript.
all time button.clicked returns false although file is already opened the code is:
if(document.frmBuyers.bankbtn.Clicked!=true)
{ alert("Enter The Bank Details") document.frmBuyers.bankbtn.focus();
return false;}
how to Positioning new Window near the button i've made, in this case i have a Calendar Button, but the position window that open the calendar can't be fixed, so when I scrolled the page behind calendar window, the calendar window moving too....
I've read from the MSDN, but there's no way too fixed the coordinate point to the calendar button
I have a simple asp page that draws 3 fields and a hidden "Row_Id" from the Database.
I want to be able to click a "more info" link and take the Row_Id over to a new page
which displays all the info for that particlular user.
Would I use a response write method?
I can get it to work using a form button but It wont open in a pop up.
Is it possible to have a pop up window come up once someone logs in. Inside this window, it have a video of another person with a greeting, and other information? Has anyone ever done something like or similar? Other than ASP, what other technology is needed, FLASH?
Come someone show me an example of something like this? All help is greatly appreciated. The thought is to distribute these pop up windows (or better solution if someone knows of something better) to all our dealers across the nation. Each dealer will have its own personal inside sales rep and direct line for personal assistance.
i have to pop-up some reminders in a new window to the users . it is just like when we open a website ads related to that site come in new window.
what i have to do that , when a specific user logs in , a new window will open to remind him about some thing. i think , you will be getting my requirement.
Is there a way to set the window size on a
<form action="add.ASP" method="POST">
<input type="hidden" name="AComputer" value="<% =AC %>">
This open in a full window
I have this other way without using the form
<input type="submit" value="ARecord" name="Add"
onClick="window.open('add.asp','add','width=500,height=300' )">
This sizes it for me nice, but I can't pass the values I need.
I want to pass AC and have the window size 500 X 300
Is this possible?
I am developing an web application in asp.net using visual studio 2003, where a user have to fill some description. Along with simple text, the user may need to paste some hyperlinks and images. (like a yahoo composer window).
View Replies View RelatedCan 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 Related