In 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 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'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 Relatedyes 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 RelatedI 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?
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.
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 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 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 RelatedI'll admit my ASP skills are very rusty, and come seeking help.
I'm currently using a dictionary object to store a multi-dimensional array.
I want to pass this dictionary object to an object, which holds an array of dictionary objects.
However I'm finding that the array is not getting set, thus I'm having great issue with dynamically resizing the object's property for every new dictionary object I'm adding.
I have a VC++ COM object which fires an event. I've written VB EXE apps against it and they receive the event notification.
I've now built a simple VB COM object which uses the VC++ COM object internally.
My question is, assuming the ASP page which loads the object does not immediately exit, will the VB COM object be able to receive the events from the internal object?
We are using .net 1.1 on windows 2003 server. This is we are facing in our
production server.
When we are doing the load testing we are getting the bellow error. While
the load testing this error is not coming frequently. When we run 20 threads
for 3 mins we are getting this error message 2 or 3 times. But this line of
code is executed by all the threads. Code:
I want to open a recordset object on an .asp page. When I open the recordset I would like to use a stored procedure that expects a parameter to be passed for the stored procedure. I will then use the recordset to loop thru the recordset, update values from the recordset and then update the database by passing parmeters to another stored procedure.
I would like to use the recordset object but can it be used to pass a parameter to a stored procedure? Do I need to use a command object to open the records instead in
order to pass the parameter to a stored procedure?
I have a custom function for checking if a variable has been set or not to make the code easier to read, as well as to keep it shorter.
However, I'm getting errors that "Object Variable not Set", even after I've already checked for null and empty. Code:
A three-tier user authentication system was running without a problem for almost a year and now is suddenly dysfunctional. We don't know of any changes to any of the servers. It's quite maddening. The details:
1) We know the COM+ app is instanced on the COM+ server (Win 2000). The component graphic spins when CreateObject is called.
2) The proxy is installed on an IIS server (Win 2000) with delivers the interface, written in ASP, to the client PC.
3) These are the error messages displayed when a method of DAMS is called: Code:
I have one column in my access database named 'picture'. I uploaded the pictures in the database using OLE Object. Now I want to have a picture of an employe in my ASP form.
It gives me an error. The page works without that code-line where picture is mentioned. Code:
I have an xml data that I want to store in a database.
I want the following fields
1. Account-id
2. order-number
3. first-name
4. last-name
5. address-line
6. address-line-2
7 city
8, state
9 postal-code
10 total-points-spent
11 the list of items that were purchased which are in the section
item-redeemed
And this is the asp code that I use to move through the list. right now all
I can get is the redemption top-level, but I cannot seem to go down to the
subitems. Code:
I am creating an e-mail using the CDO object and using the AddAttachment method to attach a file from a URL. I am having a problem in that the file file attached is given a random name (something along the lines of ATXX412.pdf)
Does anyone know if it is possible to rename/assign a name to attached file before the e-mail is sent?
I am writing a function to take a recordset as parameter, and print a HTML Select element according to the record in the recordset. I would like to check if the input object a RecordSet before processing, how can i acheived that?
View Replies View Relatedhow to find the size of a pdf which is located on the server i know i have to use filesystemobject
View Replies View RelatedI have a table called "Document" which has 3 columns
Doc_ID
Doc_Name
Doc (this is a word doc stored as an OLE object in ms access)
Now in my asp if the user selects a document it should open the word file.
I have my case statement that looks like as follows which I think might need some
modifications to open a word file: Code:
we have NT 4.0 server now, will be moving to WIN2K and ASP TO ASP.NET. Right now we have java.jmail.....
View Replies View RelatedI have an E-mail ASP Web form that is using a CDO Mail
Object. This form has to be filled out before the
customer can download our demo. Currently, the customer
fills out the form, clicks to submit and a message appears
to the customer telling them it was successful and to
click on a picture on the form to download the demo. My
problem is that many of the customer don't read the
message. I want to modify the code so that after the
customer clicks SUBMIT, the info is submitted and then the
download immediately begins without them having to take
further action.
What is the code I should add to begin downloading a file
after the form is successfully submitted. Here's some of
the code I am currently using:
how to create dao.tabledef object in asp:
I need to convert the following code into asp:
Dim tdf As DAO.TableDef
Dim db As DAO.Database
Dim fld As DAO.Field
Set db = OpenDatabase("C:Mydb.mdb")
Set tdf = db.TableDefs("Table1")
Set fld = tdf.CreateField("Field2", dbText, 10)
tdf.Fields.Append fld
just trying to add a product to cart although this error has occured!
Microsoft VBScript runtime error '800a01a8'
Object required: ''
/djfubar/addCart.asp, line 75
this is the addcart script Code:
i have this form sitting on my website that all the data submited trough it goes directly to an access database - what i would like to know is how could i also send an email with the data entered to the recipent? my server does not support CDONTS .
View Replies View Related