I have a page that is taking way too long to load. The time is around 8 minutes. It is pulling about 2600 records from an SQL database.
The page works properly, and I’ve put a “Please wait” <div> to help, but I’m not sure where to look as to the problem. How much is the way the page is built or the server that is serving up the page? Code:
I have a recordset that has 12 records in it, and about 25 columns. Unfortunately, I have to write the records out as columns in an ASP page, and the columns as rows. So, what I have done is a Do Until myRS.EOF and write all the records in <td></td> tags. I then do a myRS.MoveFirst before going to the next line.
I have one page that is identical in code, just using a different recordset, that is taking about 7 seconds to write per line. The other 2 pages are taking less than a second per line. Has anyone seen anything like this before? Anyone have any suggestions? Below is an example of a loop that is taking so long to run.
do until myRS.EO
Response.Write("<td bgcolor=#eeeeee>" & myRS("OutstandingInCompliance") & "</td>" & vbcrlf
iTotal = iTotal + cdbl(myRS("OutstandingInCompliance")
myRS.MoveNex
loo
I want to divide long HTML page (paging) into smaller pages.I know how to do it if I use recordset but in my project, I dont need to read from a Database, I'm reading a file system wich is a folder and list all files insid it.
View Replies View RelatedIf the content of a db field is too long, (like when the web page ends up being 3 A4 page lengths due to alot of content in the db field), is there a way of say, creating a 'next page', thus splitting the data content over 2 pages?
View Replies View RelatedMy server hangs for a really long time after I run the following code...
It is to serve up 3 types of files: a picture, a word document, and an mp3 file from a directory "/uploads" that is not accessible through the URL. The script works perfectly for the picture and doc file, but nothing loads when it is used for the audio files. The files are a few megs large, but after I run it I can't access ANYTHING on the site for quite some time.
What's wrong? Is it something wrong with M@rco's script? Did I impliment it wrong?
I don't mind if it simply takes a long time for it to load the audio file, but it is killing the entire server it seems like. Code:
I have the following test.asp page which needs one parameter querystr
but my querystr is a very long string value. When I send a long value
the query string is getting truncated after some characters.
Can you please kindly share the code segment to workaround how to pass
such a long string value to a asp page. This is how I invoke the test
page:
http://localhost/?querystr=select ............ from xxxxx
'test.asp
<html>
<body>
<%
response.write("Hello World!")
w=request.querystring("querystr")
response.write "<td><p></td>" & w
%>
</body>
</html>
but part of my query string never gets passed to the asp page appears
asp as a limitation on max string length can you please provide me a
workaround how I can overcome and pass the right string to asp.
I'm using IIS on my localhost and also in some free Brinkster webspace.
The problem I have is that when ever I try to use a script that includes the File System Object (as I want to read/write/copy files etc), the page won't load, the progress bar in the browser just very slowly increases, but never gets anywhere, and nothing ever loads.So I'm thinking it's a set up problem? I've tried the same scripts in my Brinkster webspace, and they don't work there (but I know they do work!) but Brinkster may have some restrictions.
Is an FSO problem like this common? Can I alter some settings on my localhost set up to solve it?
I wanted to know if there is a way to load a asp page in to it self.
View Replies View RelatedI have an asp page that gets data from a form in another page, for this, i am using the GET method to send the data to my asp page, and the page works great.
This asp page, nowadays, is quite big for displaying at once, so i decided to split this page in four new pages. Basically, my old asp page is now the static visible part, and the other four new asp pages, are the ones that will show the dinamic data.
What I tried was to make an <!--#include file... -->, and this works great for me if i have not to pass any values to the pages in the includes, but i have to, so what i want to know is if it possible to do this in any way, or, if i have to make four new diferent pages.
I have a page (with a form on it) and when the form is submitted, if there is an error the page is redirected to an error page (i.e. your attempt was unsuccessful..etc) Once the user is redirected to the error page, after a few seconds the page automatically takes him back to the previous page he/she was on.
This is exactly what I want, HOWEVER, when the user is redirected back to the previous page, I would like for the page to be refreshed so the form can be cleared without the user having to click a reset button or anything like that. Does anyone have any clues to how may be able to go about achieving this?
I'm having some fits with getting this to work but I'm near the end and I'm
hoping this one obstacle is not a huge one to get past.
Here's my scenario:
I have a page where when someone clicks on a dropdown and selects an item,
it will hide 2 other dropdown boxes that are related as the input in those
are applicable. When I save those items, everything gets into the db fine.
The problem is when the page refreshes, those 2 related dropdown boxes that
should be not visible are still visible. Is there a way in VBScript to
hide/show those controls based on the data in dropdown A? Javascript is
handling the actions but I don't think I can call Javascript on page load.
I have a relatively simple ASP page written in javascript, that basically
contains a table, a dropdown list populated by a query, and a button.
The problem is that when first navigating to this page, the progress bar in
IE only shows the page as being 10 or 20% complete, even though the page has
fully loaded.
I originally had a mix of html/jscript/html (in that order), and tried
changing that to html/jscript just to see if the conversion from static to
dynamic to static code was causing a problem, but with no effect.
I have run the output of this page thru two or three different html
validators, none of which show a problem with the final code.
I'm using IIS on W2k server, and IE6 or IE5.5 on client.
I have 2 ASPX files. One is the main, the other a smaller one which is the
center part of the main ASP file.
Now, how do I load the 2nd ASP into the first one?
I have a "Digital Dashboard" that basically has 4 IFrame sections.
The page flows in the following order: Messages, Stocks, Weather, User
Links. Please note that this order needs to stay that way.
Everything but the Stocks section is pulled from our dB. I am using
the server control InetCtls.Inet to obtain the stock data from Yahoo
Finance.
The question I have is can I load the page using the dB driven sources
first and then the external source (e.g., Messages, Weather, Links,
Stocks). In other words, I need to page to render the Stock portion
last. What currently happens is the page loads, then "pauses" while
loading the stock information, and then finally loads the remaining
content. The pause is caused by the "screen scraping." If I can give
the appearance that the page has fully loaded, and then load the
stocks last, that would be perfect. I tried looking at script defer,
but I don't think that is what I want.
In summary, I have 1 asp page that contains 4 IFrames. I need to load
the page out of sequence. Is this possible? Any help would be much
appreciated. We are running IIS 5.0 w/ asp 3.0.
how can i clear the session variables on page load (the first time)
View Replies View Relatedi have a ASP website and a flash on it. on a page, i have a button that links me to this page "pacientes.asp?id=<%=session("adm")%>", so, it returns me the page "pacientes.asp?id=#"... however, i want to control this link through flash.how can i make flash get the "adm" variable and attach to the end of the url?
View Replies View Relatedhow to run one asp page after html file display ion browser for few seconds.when i click on certain href tag the realted link will open in another frame.. before opening the related link i just wanted to show one or two image so the web page will look styley.
View Replies View RelatedI want to load a web page from another server via http into an array or variable, parse it, and pull some data using plain ol ASP / VBScript.an example page to pull:
http://sports.espn.go.com/mlb/players/profile?playerId=4245
I search quite a bit for this info but so many results and not enough knowledge in this area of ASP.
I have 2 ASPX files. One is the main, the other a smaller one which is the center part of the main ASP file. Now, how do I load the 2nd ASP into the first one?
View Replies View Relatedi have an asp.net page that has an iframe in it. i'm using the request to pass parameters to the page, and to the iframe as well, in the on_load function i change the href of the iframe (which also is an asp page)acording to the parameters i received, but it doesn't get them. does anyone knows why? i think it because it loads the page before changing the href. how can i change it?
View Replies View RelatedIs there an event that signifies the end of a page load?
View Replies View RelatedIn the body of my asp page I have :
<input style="LEFT: 800px; WIDTH: 95px; POSITION: absolute; TOP: 485px; HEIGHT: 24px" type=button value='Delete' name=deleteButton onclick=<%agentDelete();%> size=31>
and in the Head section I have a Sub called agentDelete(). In it's current form above when I go into the page I receive an 'Expected end of statement' error. If I place the onclick in quotes, I then get a typemismatch error.
The input line above is hardcoded into the body of the page. In other forms I have the same syntax, but it gets built from the server and they all work fine. I'm not building this from the server because it's a different form.
i need to know how to refresh my page after it loads but only one time. don't ask why
also is there a asp command that displays current url?
How do I via an ASP, load the page, pause for 30 seconds
and reload/refrest the page with no user intervention?
how to Update Record On Page Load. I have one feild in my database that I want to subtract 1 from each time the page is loaded.
View Replies View RelatedI need to play mp3 file when my asp page loads. Now, i want to do it the NICE way by providing stop, pause and play buttons. It is not professional to just start playing audio and not giving control to the user. What are my options?
View Replies View RelatedIs it possible to submit a form as soon as the page it is on loads and then redirect to another page?
View Replies View RelatedThis page takes awhile to load which is probably due to the queries and the way I have it outputed. Anybody have any advice for speeding this up? Code:
View Replies View RelatedI used to have thios bit of code and I have totally forgotton what is was. It set either an expiry for the page forcing the browser to download it from the server or it abandoned something. Anyway I want the page to always check its data and refresh from the server and not use the cache
View Replies View RelatedI currently have my database set up so that when a user uploads a file, it writes it in binary in the database. I know the benefits of having a separate file server and storing the path, but unfortunately, I can not do it that way.
I know how to include the file in, lets say, a hyperlink so that any user can click on the file to view it. But, I would like to know how to include the file (mainly pictures) directly into the page as an <img src> Any suggestions?
P.S.
Once the information is in the database, these are the commands I use to output the file to a hyperlink. The file that this code is in is "file.asp?Id=" Where the Id is taken from the URL and used to obtain the correct file. I left out all the connection/cmd strings intentionally just show I could show the relevant information:
Response.AddHeader "Content-Disposition", "filename=" & _
rs("FileName")
Response.ContentType = rs("ContentType")
Response.BinaryWrite RS("FileData")
How to get test.doc from following string Using VBscript
"Files uploaded:test.doc (54326B)"
File size and file name may vary dynamically,and I have to pick file name with ext from them.
how do i take the four last letters of any given form input? for example hello.asp
i want a function that will give me .asp
I know how to build forms with ASP and process user input. Now i want to take credit card payments via a form. i will then download the details and process them via our credit card
machine.
do i just create a regular ASP form and use a certificate on the server to encrypt the data ? ie https://server/getpaymentform.asp
there is nothing special about the form is there? it is just the same as the form i have been using for user input.