The following code has run-time error on "divide by 0" error. I expect
"do the work<br>" will not print in the browser, since it happen after
the code that cause the error. However, this is the output: any ideas why?? Or
this is the nature of ASP scripting language that is being executed in
sequential order? Code:
Using ASP, I would like to write down to the HTML the time taken to execute a query. I am trying to optimize my SQL queries in the ASP page. So I want to determine if my SQL query is optimal or not. So how can I determine how much time it took to execute the query and return the results.
For example, something like: It took 5 seconds.
<%Response.Write "Hello"%>
<html>
<head>
<javascript language="javascript">
alert("First");
</script>
</head>
<body bgcolor="#FFFFFF">
<h1>Testing</h1>
</body>
Which code execute first.
I am extrememly new to C (only been playing with it for a few days), and will be am required to be using C and ASP.NET (also a language i have only been using for a couple of days) for work purposes in the next few months. I come from a mostly Java background where it was easy to write JAVA code, and provide web interfaces that made use of that code in JSP.
I would be greatful if anyone can tell me...
a) Is the same effect possible using ASP.net to access / execute etc C/C++ (not interested in c# code - all the explanations of this seem to cover c# only - or is there no difference? - Spot the newbie! lol) code (pretty sure that works - but be good to know incase there is another step in there).
b) Where can i learn more about it? Can you suggest any weblinks or books etc?
Incase it makes any difference - the sort of code i am interested in running would simply respond with results from databases, or extracted content of files etc (command line stuff) - and much of the code is already written in c / c++ so i am not keen on re-writting it specifically for asp.net (does that make sense? hope so!).
i have used content-disposition to force the user to download the file and after saving the file i want to execute some more code i.e i want to enter some records in the database and then redirect to another page but this is not happening. The execution remains on the same page only.
View Replies View RelatedI haven't started to mess with this yet, but is it possible to store
.ASP source script in a Database field, then use ADO to get the string
from the field and then force the scripting host to interpret that
string from the database and flush it into the buffer for output to
the browser? I was thinking you'd have to use EVAL() on the string or
something...Anyone done this yet?
I was working with Vignette story Server a couple of years ago, and
all of the TCL source script and html is stored completely in the
database, only cached pages are in virtual directories.
I have a web form and some additional code i don't want my additional code to execute untill after they hit sumbit on the form. i want to keep all of this on one page. i've tried to just have the page submit to it's self but that doesn't stop my code from executing on load.if anyone could give me some direction on how i should do this it would be great.
View Replies View Related.asp code doesn't execute on LAN IIS, page shows as text of code. Is this an IIS config issue?
View Replies View Relatedi wirte SQL statment to collect information from oracel database but after 5 minutes i got the following measage
Error Type:
Active Server Pages, ASP 0113 (0x80004005) The maximum amount of time for a script to execute was exceeded. You can change this limit by specifying a new value for the property Server.ScriptTimeout or by changing the value in the IIS administration tools. Code:
I'm showing page contents text coming from database, normally the contents are plain text or in html formatting... it works fine.. but I want to add ASP code within page contents, as well... i did try but it dispalys ASP code as it is in the output...
is there any way to execute those asp code lines coming from database...?
I need an asp code/page to run in the background and execute periodically/full time. This code must do some actions based upon time intervals.
For example, The code must keep running and must send an email every 6 hrs. ASP is preferrable.
can a proxy connection be detected when someone is connecting to our web server using a proxy?
View Replies View Relatedi've installed vs.NET 2003 on my pc which is runing window 2000 pro with sp4, but when i'm trying to create new ASP.NET Web appication i got this messages "Visual Studio .NET has detected that the specified Web server is not running ASP.NET version 1.1. You will be unable to run ASP.NET Web applications or services."
View Replies View RelatedHow can I made time released ASP code? I want to make section of code viewable after a certain date. Something to this effect, but this does not work right:
if now() >= "6/24/2005" then
Response.Write ( "here is my new html" )
else
Response.Write ( "for now just show the current information" )
end if
I'm looking to setup a code that will let me put up some code lets say on a friday but won't display it till saturday and will keep displaying it until i take it down. here is something i'm thinking
<% dim h
d=day(now())
response.write("<p>" & now())
response.write(" (Norwegian Time) </p>")
If h<12 then
response.write("Good Morning!")
else
response.write("Good day!")
end if
%>
does anyone got a suggestion?
Whenever i try to accecc HTML page through server.execute, i got this error.
Server object error 'ASP 0228 : 80004005'
Server.Execute Error
server.execute("/folder1/htmls/" & strfilename & "_1.html")
The call to Server.Execute failed while loading the page.
I need a code that will output the elapsed time from a given date until the current date. Obviously if I'm asking you how to do this, I'm ASP stupid, so if you could help me out, it'd be greatly appreciated.
So basically, I need to know how to store the given date, current date, and difference of the days as seperate variables.
I'm getting this useful error '80040e14' when trying to run a select statement in an ASP page. The connection to SQL Server 2000 is ok. The variables in the Select statement, 'area' or 'areaid' are passed through form the previous page ok.The code is below... Any ideas? Is it something obviously dense on my part?? Code:
View Replies View RelatedI am currently running IIS 5.1, Windows XP Pro with service pack 2. When I try to run an ASP page I get an error saying that 403.1 Execut Access Forbidden - IIS. There are no firewalls up and running. I hav given permission and access to everything, every folder that I can thin to give access to. Obviously I must be missing somethin somewhere. anyone have any ideas for me??? The execute permission have been set to scripts only. I have also tried scripts an executables.
I also have a box that I run the same asp pages on and the onl difference that I can find is that I am running Windows XP Pro wit service pack 1. I don't have any problems executing ASP on this box. I have tried to mirror all the setting from box to box and stil nothing.
After commands like:
tmpDBconn.Execute("DELETE * FROM mytable WHERE rc_id = 10" )
How do I check for errors?
Is there a way to check the results?
OR:
Set rsCatCount = tmpDBconn.Execute("SELECT COUNT(*) FROM cat WHERE key_id = 10 AND cat_id = 6")
How do I get the count? Do I use rsCatCount(0)?
I have one activex control which fetches data from database and writes it in text file. This control i am using in my asp page. The page executes perfectly fine on my machine but when i execute it from different machine it gives me following error:
Run-time error '-2147467259(80004005)'
Unspecified error
I tried to display an error detail on my webpage when I got an "HTTP 500 Internal Server Error" of my .asp page, but I was failed I did setup in IIS so it will display debug error on my asp page as well as setting up my browser internet option.
Can you help me how to set it up so I am able to see the error detail on my browser when I get "HTTP 500 Internal Server Error" ( Currently, I just got a blank page with "HTTP 500 Internal Server Error" in the web page title)I run IIS 5.0 and window professional xp browser.
I have a message that scrolls across the top of the page,
it can work, refresh, work, refresh, fail, refresh, work, etc etc
I dont have any control of the permissions, web server etc
just my code and database file.
I can see any reason why it will work 4 out of 5 times.
Any thoughts ? Code:
What causes this?
CDO.Message.1 error '80040212'
The transport lost its connection to the server.
/cardmanagement.asp, line 140
how does one go about fixing a run time error? it pops up an alert box with "run-time" and then gives a line number that doesn't really go anywhere. it is usually referring to some html tag. how can i figure out what line it is actually referring to?
View Replies View RelatedI have spent a fair amount of time creating a company Intranet. Now I have decided to create an admin page that will analyse the automatically created log files. This project is going well so far so good. the time in my log file is 1 hour earlier than the event that it records.
Ie 11.30 am is recorded as 10.30 am. This is true of both my setups (programming/test and working) The time on both computers is correct and if I request the time using ASP the correct time is displayed. While this is not the end of the world I could adjust the time when displaying the data I would like to fix the problem at source.
Microsoft OLE DB Provider for SQL Server error '80040e31'
Timeout expired
/localedit.asp, line 225
here is the query and [Eligible Demo For Contract] is HUGE.
StrSql = "SELECT EPN, D FROM [Eligible Demo For Contract] WHERE SID = (SID) GROUP BY EPN, D"
I am getting the error Time out expired , I have tried every thing increased Server.scripttimeout to 90000 response.buffer=false .. etc even then I m gettin the error.
View Replies View RelatedI am running into a command time out error. I have to retrieve a lot of date thru a complex query. For some reason, I can't change the commandtimeout to more then 30 secs. And yes I have Connectiontime incr4eased to 90 seconds. Code:
View Replies View RelatedWhat is the asp code variable for System Date and System Time? Are they built-in system variables, or is there some code involved to return the values?
View Replies View Relatedi need to calculate the time and date difference between two times and dates.
Example 1 works fine:
Difference between 27/09/04 10:00 and 28/09/04 12:00 gives a correct answer of 1 day and 2 hours.
Example 2 gives an error:
Difference between 9/16/04 1:50 PM and 9/28/04 11:54 AM gives an incorrect answer of 12 days -56 minute(s) .
How do i fix this?
I m getting this error :
Run Time error '-2147217887 (80040e21)':
Multiple-step OLE DB operation generated errors. Check each OLE DB Status value, if available. No work was done.Can anyone tell me the reason why this error comes?
I am using VB with SQL Server 2000 with File-DSN Connection and that VB code (Standard Exe) has more than one insert/update statements.
after "objConn.execute(sql)" the page got error how can i show the error? there is an Object error?
View Replies View Related