when creating a webpage that must display a large result set, the page load time is unbearable. Unfortunately, there are a lot of records and they all need to be displayed, at once, on this one page.
To reduce file size, I have minimized the amount of HTML tags used to dislay these records. My only other idea is to write javascript matrix to hold the data, and then to use dom to create the page on the client side. Are there any tried and true ways of speeding up page loads?
I'm very interested in finding out what ways you experts out there have made your data dips more efficient in your asp (not asp.net) code.
I have a wizard-type application that dips into the database with each page, I know there's a better way to do this out there, just pressed for time and can't think right now.
We have a report page which deals with more than 3000 records and 80 columns. The records are displayed on a third party control VS flexgrid versioned 7.0.
Currently we are having a client side array populated from the server side using response.write . Is there any other means to optimize the performance on this page?
I have a multidimensional array that is actually 1 dimension (it comes from a recordset.getrows that returns 1 column). My goal is to put every single line of the recordset in a textfile. currently, here is my code Code:
for i = 0 to UBound(Res,2) fileContent = fileContent & res(0,i)) Next createTxtFile(path,fileContent)
I have 5000 lines and it takes about 10 minutes. I was thinking of doing a Array.Join but I don't think that works with multidimentional array. Also thinking of converting my useless multidimentional array into a sing dimensional array but how?
I have a multidimensional array that is actually 1 dimension (but it comes from a recordset.getrows). My goal is to put every single line of the recordset in a textfile.
currently, here is my code:
for i = 0 to UBound(Res,2) fileContent = fileContent & res(0,i)) Next createTxtFile(path,fileContent)
The problem is, I have 5000 lines and it takes about 10 minutes. I was thinking of doing a Array.Join but I don't think that works with multidimentional array. Also thinking of converting my useless multidimentional array into a sing dimensional array but how?
i want to have a search application wherein it returns a results page and arranged based on the most relevant word. can you please give me an idea with this or point me to any info.
The delete method of the FileSystemObject.FileObject does not return a result. If permissions disallow deletion, it will not raise an error. Conversely, if the delete method does succeed, a call to FileExists directly afterward may return true because the system hasn't updated yet (or whatever actually goes on). Is there any way to accurately check the result of a deletion?
why my results page is not coming back with anything?? I have set up a simple form in dreamweaver, it connects to a access database and IIS web server. When i test the recordset it works ok (returning the desired affect).
It uses a post method therefore the recordset uses form variable. But when i preview in browser(either IE or Firefox or Netscape) and enter text the browser comes back with something like the page does not exist or can't be found? It's not the recordset and result page so is there something else i'm missing?
i want to left join result sets together coming from two different databases based on a common field storenumber. They are separate databases as per management design.
Basically it should match rows based on the store number, those who don't have matches should display only the storenumber and no other info like: Code:
Store Q1 Q2 Q3 Q4 1 x x x x 2 x x x x 3 <--No data in 3, just display storenumber 4 x x x x
I have a search form that display result based on the user search criteria. the result displayed through paging when the user select a specific product description to look at then go back to the search result the user will lose it's place.
my question is: How can I let the user search the database for all the products that I have then select a specific product to read the description of it then be able to go back to the original search. I have the first part working fine but to be able to go back to the original search that I need your help. Code:
My web page is calling a result set that is displayed on the page. If I click refresh, it pops a warning saying, "The page cannot be refreshed without resending the information." I then have to click RETRY in order to refresh the page.
Is there anyway to automatically perform that action so that my users will not have to be prompted?
i am trying to make a search/result page(using asp, dreamweaver,iis,winnt,miscrosoft access database) wherein the results page brings up the most relevant words or phrases and not in alphabetical order.
I'm working on a application where I've created a couple of Sub routines I call them from my ASP page.
But I would love to put the hole HTML including my "call showOffers" in my database and when I get the result set do I want to execute the "call showOffer". Is this possible?
I am struggling to come up with a way to save a forms' results, to a text file, but the name of the text file comes from the input of a user name on another forms...
ex. john doe enters pg1 & enters his name in a space on the page (form) . this links him to the next page, pge_form. I need the results of page_form to be named johndoe.txt
We have completed a clean install of Microsoft Server 2003 on our Web Server and are using frontpage 2002 for our web site. On our asp page (www.dgf.k12.mn.us/contactus.asp) we are getting the following error:
Database Results Error Description: Syntax error in query. Incomplete query clause. Number: -2147217900 (0x80040E14) Source: Microsoft JET Database Engine www.dgf.k12.mn.us/contactus.asp
We cannot find any kind of documentation on this error. Has anyone else seen this kind of error, and know how to fix it?
This is my first post to this newsgroup, I have question regarding showing resultset to html. Let's say I have in resultset 200 rows, and I'd like to show on each page 10 of them, so it could look like for example google search results:
Results 1 - 10 of about 17,700 for "asp search engine" [results] Result Page: [1] 2 3 4 5 6 7 8 9 10 Next
I have a question about looping in a recordset. I'm actually showing some actualities in a page, based on a start and end date. All is working well. My problem is that I put a <hr> between each news, but I don't want a <hr> at the end of the last news. I would like to count how many results I have in my recordset so I would be able not to show the last <hr>.
i have a command object that executes an insert for a billing system.i also have a recordset object that creates a cursor to check. the credits status before. Another to check the credits status after.however, both appear to be the same when i do a response.write .How could i check the credits before and the credits after online and realtime ?
I have a SQL query to generate the report for me in SQL Query Analyzer. I would like to create an ASP page that has a link, and when people click on that link, it will prompt a download message (open or save) in Excel format. Is there any codes can do this?
I have a search page that allows user to search a SQL database and want the result page to display on a search page. How do I get the result page to display on a search page when user clicks a search button. Have you got any sample codes to demonstrate this?
I am using SQL Server 2000 and I want to be able to list out all the field names and their datatypes from a particular table. I found out that sp_help does that but unfortunately when using a recordset, I could only get the first of the 3 tables.
Is there anyway to get the second table using a recordset because that is the one with all the info about the fields and their datatypes? Or is there another way of finding out the datatypes of the fields?
Eu gostaria de criar a seguinte página e gostaria da ajuda de todos. I have a data base (jogos.mdb) that he has a name table (resultados). In the table resulted I have the
fields: data | time1 | resultado1 | time2 | resultado2
I want to create a command that goes to show these information nu'ma line of a page any. Example of as he will have to be shown: 12/03/2006 São Paulo 1 x Saints 0 . I would like to not only call these information a data base that goes to be in another site and in that the data base will be housed. I do not have idea of as I can make this. They can help me to create this page.
we have a MSAccess database of products with titles, short descriptions, long descriotions, bulletpoints etc contained for each product. we currently search the database looking for the target keyphrase within the fields, but this doesnt give any accurate results as for example a product that is compativle with "widget 1" is shown before "widget 1" . anyone know of a process that will give us better, more relevant search results?
check the "keyword"s in the attachment? For some reason it's not coming on top of the iframe as I expected to. Could it be that the "action" in the <form> is missing or what?
Can you please check the "keyword"s in the attachment? For some reason it's not coming on top of the iframe as I expected to. Could it be that the "action" in the <from> is missing or what?
