I need to know how long it takes my ASP code to fetch a rows from sql server 2000 database. how can i print the time it takes on the page? I need a code wich count the seconds from the time the page loading start and the time all the rows are printed.
View Repliesi distribute a website on IIS which is programmed with C# HttpHandler,then i pragram a Winform client to send empty call to the website and record the time that the call return to client.
when the webform and website are both on the same machine,it will waste below 50 millisecond. but when the webform is on other machine in the same local network,it will
waste above 150 millisecond. why?
Anyone know what might cause my ASP to start running slow? It's been running fine until today. Today when I pull a repost, it takes forever to for the code to create the page.
When I go into the Access database itself and run the individual queries, they run just fine. It only takes a fraction of a second for the data to apprear. When I run the ASP code to see it on the webpage,it takes around 30 seconds!
Anyone got any recommandations on what I need to check? It just doesn't make any sense that all the sudden it runs flat out SLOW.
Is there any way to delay a response.redirect for say one or two seconds?
View Replies View Related<a target="_blank"
href="IndividualGamePerformances.asp?MatchID=<%=RS("MatchID")%>&TeamID=<%=Request("TeamID")%>">
Can anyone please tell me what to enter after Response.Write to write the above to the HTTP Response body.
I would like to display the difference between the logging time
[Session("start"] and the current time [now]. In hours minutes and seconds,
I have tried a couple of things but all I see is gobbledy gook.
I have a website that I subscribe to that allows me to track tasks. I have an extra computer with a big monitor that i want to always display the task list. the problem is after so many hours I get logged out.
I need to need to reload that sign in url every few hours Code:
there i was just windering how do i compare a date/time vlaue in sql server agaisnt the computers' date/time.
for example, if computer date/time is two months or 2 weeks before the database date/time do something
Currently working on a ASP for a friend, which requires the date and
time on it. It pulls in entries from an Access Database with dates and
times in the format of:
"Fri Oct 17 18:02:46 2003"
However my date and time on the ASP page is displayed as:
"Friday, October 17, 2003 18:02:46"
using the script:
"<%Session.LCID = 1033%>
<%=FormatDateTime(Date(), vbLongDate)%>
<%Session.LCID = 2057%>
<%=time()%>"
Anyone know how to change this script, fully or partly to produce the
date and time on the format that's in the access database i.e. "Fri Oct 17
18:02:46 2003" Code:
I am working on a database that collects information about incidents. One of the fields that people enter is the time of the incident. I am trying to convert that string that people enter into a OdbcType.Time and I am at a lost.
View Replies View RelatedHow will we convert the system date & time to other timezone for eg: Eastern Time zone using ASP?
View Replies View RelatedWhen the Form is submitted I use the Date() and Time() functions to put the date and time into the Body part of the e-mail. The time reported is three hours earlier than the time at which the Form is actually submitted.
I understand these functions are evaluated on the server so the server must be in a time zone three hours earlier than where I am . Is there any way I can get the local time at the location where the user is actually located. ?
Any some tools or sample codes drop down asp script execute time and
database connection time ?
I'm trying to do a very simple code that converts the server time into a time zone of your choice.
<%
dim h 'Current Hour
dim i ' Time Zone Increase - add or subtract hours
dim r 'Result Here
h = Hour(Now)
i = + 2
r = h + i
%>
but obvisouly i'm having trouble with the time zone convert.
I am trying to compare the NOW time with a "deadline" time. Please help. Just not sure why this is not working. I need to be able to say IF IT'S BEFORE 9:30 TODAY, IT'S OKAY TO ADD SOMETHING. IF IT'S AFTER 9:30 TODAY, YOU MUST ADD IT TOMORROW.
CODE:
nowtime=now()
deadlinetime=formatdatetime(now(),2) + " 8:30:00 AM"
response.write "NOW: " & nowtime & "<BR>"
response.write "Deadline: " & deadlinetime & "<BR>"
if nowtime<deadlinetime then response.write "can send out today" end if
if nowtime>deadlinetime then response.write "must send out tomorrow" end
if
RESULTS:
NOW: 1/18/2007 8:51:43 AM
Deadline: 1/18/2007 8:30:00 AM
can send out today
As you can see, NOW is GREATER THAN Deadline, so it should must send out tomorrow.
i want to calculate the total time between to dates and time.
Example: Total time elapsed from date 1 time 1 to date 2 time 2.
27/09/2004 11:00 - 28/09/2004 10:30
The user enters a record and then later comes back and closes it. I need to know the time it took from when they entered the record until the time it was closed.
Is there any point in having response.end after response.redirect?
View Replies View RelatedThe following code checks to see if user is an Admin...if not then the user get redirected to another page.
If(accountType <> "Admin") Then
response.redirect "message.asp?msg=20"
Response.End
End if
.
.
.
Code
.
.
My question is:
Do I need Response.End?
Can a user (not an admin) stop the browser from redirecting and execute the code after the if statement?
after looking at someone elses code here I noticed that he
always does a Response.End after a Response.Redirect. I was under the
impression that code execution would stop on the current page as soon as the
Response.Redirect statement appeared, but the guy reckons that the code will
continue running on the current page before starting the new one. Can
someone give me the definitive answer on this?
I must admit I always forget to use "response.end"
and I also forget to "set objects = nothing"
how important are these things.
I know my application run fine without them probably because I usually have
plenty of processing power and ram.
My understanding is that a small peace of ram will be tied up for a set
period of time, and then it will be returned for use.
What is wrong with this line?
response.write <img src="http://mine.web.site/persPictures/" & rs("LastName") & "_" & rs("FirstName") & ".jpg" width=85 border=1>"
I have placed an include to "security.asp" at the top of each .asp page in the Members Area of my client's web site.
When the following code in "security.asp" is executed, the user is redirected to the "join.asp" page but the url in the browser address bar still shows the last page's url.
My first question was, can I hide a form field and make it visible upon
selecting a particular value on a dropdown select field? Hoping for your
immediate response.
I have a page which runs a script. When it gets to the end of the page I want it to do 2 things:
1) take some variables from the page and create an Outlook email with the subject, body and To fields populated with those variables.
2) send the page to another page.
This is roughly the theory:
Response.Redirect("mailto:me@here.com")
Response.Redirect("mypage.asp")
1) I like to know when a problem is solved. When the original person posts a "thank you that solved my problem" message and I see it I know that what they did worked. The macromedia site allows people who opened the thread to close it as "solved" Then you can search for a topic and request only "solved" threads.
2) When I am stuck on something for a long time and someone finally gives me the info. I've been stressing out over. I would feel guilty if I did not thank the helpful person. My parents' good upbringing must have burned into me the idea that you need to say "please" and "thank you".
Just my two cents. Also the Macromedia forum is not a better forum, unless it is a specific question about one of their products. Even then
In my html page to update a table I am forwarding request to a ASP apge bys using form.action="test.asp", and form.submit(). In asp I am doing database update. Response of this I want to show alert box to user whether operation is succesful.
I donot want ot redirect to some other page and I do not want to disturn existing view. I mean I want get only response such as true or false and based on respose I will display alert in front end. I want some thing like this,
form.action="test.asp";
var result=form.submit()
if( result="successfull")
alert("Succesful")
else
alert("failed")
This is my current URL after the process takes place. I want to add in the URL after intCatID & . This additonal paramater [AL = "intAL"], then the error but I forgot how to do this.
<%
Response.Redirect "FileMaintenance.do?CatName=" & strCatName & "&CatID=" & _
intCatID & "&Error=" & Server.URLEncode(intCount & " files were successfully added to the Package.")
%>
I have a Popup window where a user inputs soem data.
On successfully entering this data I redirect the user to
a page in the same popup indicating that the form has
submitted successfully.
I want to resize the page that I redirect the user to.
Is this possible in ASP?
I have a page called createWordDoc.asp, that starts with the line <% Response.ContentType = "application/msword" %>.
What it does, is receicves information from a form on the previous page, formats everything using html, and saves it as a word document.
Everything is working ok, except when I open the word document, there should be a picture in amongst the text, but it isn't there.
Does anyone know about creating word docs from asp, or has anyone had simliar problems?
I've come across some weird bug with Response.Cookies. Or maybe it will be
called "by design" but for the life of me I can't figure out what purpose it
would serve. If you're setting a cookie (say Response.Cookies ("TEST")) and
you have a query string variable &test=x or &Test=x and you get
Request.QueryString to parse the query string, the cookie that gets dropped
matches the case of the query string, not what your code says. In other
words even though the code says Response.Cookies ("TEST"), it drops
Response.Cookies ("test") instead.
Anyone have any idea what's going on here? There's an example below. Try
it with http://127.0.0.1/cookieTest.asp?test=x and without the query string
variable.
<%@Language=Jscript Enablesessionstate=false%>
<%var exp = new Date();
exp.setTime(exp.getTime() + (2 * 365 * 24 * 60 * 60 * 1000))
var expDate = (exp.getUTCMonth()+1) + "/" + exp.getUTCDate() + "/" +
exp.getUTCFullYear()
var x = Request.QueryString ("dummy");
Response.Cookies("TEST") = "This is a test";
Response.Cookies("TEST").Expires = expDate;
%>
Having just migrated to w2k from NT4, I've stumbled across an oddity with
cookie handling - at least, that's what it appears to be.
I (was) using response.buffer with .addheader to write two cookies into a
the http header for a particular page . Worked fine for three years.
After the upgrade, I'm finding that two copies of the same cookie appear,
one with blanks for values, the other with values filled in; this has the
effect of logging the user into the page if the first copy isn't blank....
So, I changed the code to use response.cookie, which is fine, but the
names/values get encoded, and unfortunately the software vendor uses dashes
in the name part.
Is there any way to force .cookie to not encode the '-'?
or do I need to look at javascript to write the cookie?
I am trying to add some basic security to my asp web pages. I have a logon screen which, when the logon and password are checked for validity, passes the user on to a registration screen using the code
response.Redirect "user_reg.asp?User=" & Request.Form("UserName")
I then inserted the following line before the redirect
response.Cookies("ValidUser") = "ValidUser"
I have the following check at the start of the user_reg.asp page
<%
if request.Cookies("ValidUser") <> "VaildUser" then
response.redirect "user_login.asp"
End if
%>
All that happens now is that when I log in validly user_login.asp is
redisplayed rather than the user_reg.asp.
Perhaps this is not sufficient to set the cookie? I have looked for it but
can't see it amoungst other cookies dated today.
I want to know whether a certain function on the database such as add or delete record is successful or not to be indicated after the transaction.
E.g. if a record was not found, or not deleted, the next page should indicate the event. If deleted it should indicate as well.