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 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.
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?
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 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 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 need to do a string comparison (in asp) that checks to see if "META" is contained somewhere/anywhere in the string. Can anyone tell me the syntax for doing this?
View Replies View Related<% Response.Write "" & FormatDateTime(now,2) & "" %>
Gives me the date in MM/DD/YYYY. How can I reformat this to DD/MM/YYYY?
I'm hoping for an easy solution to this that I'm not seeing that
someone more experienced will.
All I want to do it mark an option tag as selected....
<%
hourCounter = 1
Do WHILE hourCounter <= 12 %>
<option value="<%=hourCounter%>" <%If hourCounter =
hour(rsCalendarEdit("fld_calendar_DateTime")) Then Response.write "
selected" End If %>><%=hourCounter%></option>
<% hourCounter = hourCounter + 1
Loop
%>
The trouble is if the time is "PM" I have a problem as you can see. Is
there a method or property here I can implement that I'm not seeing?
why asp is retarded compared to some other server side scripting languages? or am i just the retard? Code:
<% If Session("auth") = "1" And Session("userid") <> "" Then %>
// Show user information box....
<% Else %>
// Show login form....
<% End If %>
in my head, what i just wrote should equal something like if the session variable "auth" equals 1 and the session variable "userid" does not equal nothing, then do this.well, i haven't set any session variables, and it's processing the chunk of code right after the above if/then. either shows a user information box or a login form.it shows the user information box, instead of the form.
really baffles me considering i haven't set any session variables. i guess this is why i like php better, but i'm trying to get a grasp on asp, it just seems to hard to do something simple. can anyone tell me why that code is returning the wrong block of code?
Using ASP & Access. So I am having a total brain-fade. I am trying to pull up data out of a table. But I want a "select all" option. What should the value be for the "select all" option of the form? What should the WHERE statement be in the query?
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?
<%= objrs ("age"), 2)%>????
how do i get it to only display the first 2 numbers?
I am having trouble with our server host they are saying that the php
upload limit is 20 mbs but using the code below with my flash file I
can only get it to do 8mbs. I know that asp is allowing for up to
20mbs though so I was hoping that someone would be able to change this
code to ASP(I am not very good at either php or asp). I think that
should be pretty easy:
<?php
if (is_uploaded_file($_FILES['Filedata']['tmp_name'])) {
$uploadDirectory = "uploads/";
$uploadFile = $uploadDirectory .
basename($_FILES['Filedata']['name']);
copy($_FILES['Filedata']['tmp_name'], $uploadFile);
}
?>
I am just trying to take pieces out of the sql statement individually and display them. I get this error:
ADODB.Recordset (0x800A0CC1)
Item cannot be found in the collection corresponding to the requested name or ordinal
There is data there in the table and I'm not sure what's going on. Code:
Im making an asp website for a rotary club what would be the best script to create a website something like a CMS without all the forums and stuff.
What is the easiest way to create a graph in either asp or html code? Is there one? I am doing several SQL queries the result of which I will give me a number. I need to put this number into some kind of graph (bar graph) on the page. THe number will vary so it must be some type of dynamicly created graph.
I would prefer to not use a thrid party tool to do this if possible ......
I'm working on a system that requires alot of date handling, and i'm getting pretty tired of doing custom calculating when modifying dates, so i hope someone would be able to help me. Is there any easy way to do re-calculating of dates? such as adding 2,11
or 36 months to a date, and have it automatically checking whether or not it should increase months or year, and by how much?
Like, if i have to add 11 months to the date right now, i have to check which month it's in to see whether or not i could just take one month lesser the next year and so on.
Basicly I have a table that gets contact info and stores it from a form AND emails me...
Problem is I want to just email a link to the ContactInfo.. which should be referenced via the unique PK so whwn i view it, it would be nice to reference the row just inserted...
ala view.asp?emailpk=141
figured there woudl be something like recaffected out there.
I need to write an application which should work as web application (ASP.NET) and it should have its counterpart for winforms - (they would do the same thing). My question is... what kind of pattern shall I use (MVP or MVC) for writing these apps to minimize overhead of rewriting code (e.g. I'll start writing winform app and then create similar web app )?
View Replies View RelatedI 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 RelatedI've searched the forum for the answer to this..it's probably on here somewhere but in a different guise to my particular question and I don't know enough to figure it out.
If I have a basic form to mail ie
strEmail = request.form("Email")
and
mail = "me@me.com"
can I simply do this to get my form to be sent to 2 email addresses?
mail = "me@me.com, you@me.com"
I have a "tell a friend" form and the backend sends the information just fine, however in the bodytext I want the "comments" box text to be added to the e-mail. User fills in his name, his email, friends email, comments box (name=message) and the email is sent except the text from the comments box. My code for the body tag is:
objNewMail.Body = sendersName & " (mailto:" & sendersEmail & ") thought you would be interested in this article " & vbcrlf & vbcrlf & vbcrlf & "Link:" & vbcrlf & request.ServerVariables("HTTP_REFERER")
How can I insert the comments box text in there?
My thought was:
objNewMail.Body = sendersName & " (mailto:" & sendersEmail & ") thought you would be interested in this article " & vbcrlf & vbcrlf & message & "Link:" & vbcrlf & request.ServerVariables("HTTP_REFERER") but it does not work.
The database is used for referencing filename, there located folder, id, order shown, but also there are some fields say "location_1" up to "location_4" which have a 0 , 1 or 2 in them. 0 means that file not needed for that section. 1 means needed for that section, and 2 means mandantory (must be seen before exit).
firstly selecting a location from a html radio box, drop down menu (not decided yet) will return whats needed so not showing pages what aint needed and wasting time.
Here it is though in order on the left i wish it to build a menu, but more advanced than plain links would be good. drop down like windows explorer etc. Code:
i would like to create the following one, but nor I know as. One index.asp that db catches one information as heading, hour of entrance and station time and shows in the page index. An example, let us assume that now they are 23:00, then the shown information will be inserted in the page index.asp in accordance with the current hour.
If it will have something registered in cadastre in db that it starts the 23:00 and it finishes the 01:00 will be in index, passing the hour it leaves and it enters another message with programmed hour.
If I have in db a message that would have to be shown of the 09:00 the 11:30, and now I am 11:20, the system analyze and show the information, until he is 11:31, when then I enter another one, and thus successively, they are menmsagens that in accordance with enter the hour of the server.