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'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.
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?
One of the fields ("Description") in my MSAccess database table contain text formated by HTML tags (<b>, <i>, etc) I now need to display it on asp page, but not as formated text, but as it is stored in my database:
Not like Description of this product is good.
but as <b>Description</b> of this product <i>is</i> good.
I just inhereted a website. I made a change to a simple SQL string in a ..aspx.vb page. If I don't have Visual Studio, is there a way to "publish" the pages and show my changes?
I'd like to write a bunch of queries from a SQL Server 2000 database in my ASP page and have a way of copying this information into an excel workbook in specific cells. Writing the queries isn't the problem, I just need to place it in a file in different specific cells.
Is there a way to do this? Do you have to use VBA code or something? the *.iqy technique isn't going to work, cause I have to place the data in a sepcific excel file, in sepcific cells. I am not sure how to do this or if it's possibly, if anyone has any ideas on where to start or find some sample code I'd REALLY appreciate it.
I am trying to call a field value from my database - which gets open in an included file (all work on database must be done in that included file), if i use response.write(rst("pagename") it would print fine in the page when I call the sub i.e <% call pageNameFind() %>
But i want to get the field value to appear like this <% PageTitle = pagename %> where pagename comes from the included sub pageNameFind pagename = rst("pagename")
It doesn't pick this up however - how would I do this? This value will then be sent on to another included file at later stage. and I must have the <% PageTitle = myvalue %>.
The most pressing issue at the moment is that my browser does not display the page; it displays the ASP code. I built the page for a questionnaire that was going to be placed on my schools server so that participants could access it online, but I submitted my request too late in the semester.
I decided that the best course of action was to collect these data offline using the computers that I had bought for my lab. The laptops are running Windows 2000 Professional and are using IIS. After configuring ISS and Dreamweaver MX, I built the questionnaire. Then, I uploaded the questionnaire to the “server”—the wwwroot folder.
Now, the index page (the instructions to the questionnaire) opens flawlessly, but when the link to the questionnaire is pressed to open the ASP page, the browser displays the code and not the questionnaire itself.
When I explained this problem to people, they tell me that my server does not support server site scripting, but I’m using a Windows machine, using Windows server software, and Windows database software (Access 2000). Moreover, when I preview the page through Dreamweaver MX, Internet Explorer displays it without a problem. Code:
How can I hide VB Script code in the ASP Page? Even though the display.asp includes the script_functions.asp, when I click on View Source from IE, I can still the VB Script code? What can I do to hide the code from the people who use display.asp?
The employees who use it are not allowed access to the server it's requried to sit on which means that my username and password have to be included in the logon.asp page which I HATE! So when this fails, it publishes my usernanme and password on the screen for the user to see...brilliant!
Since nobody is willing to create a dummy account is there a way that I can keep that line of code from displaying if in error? I've added the code to this thread...
inserting dynamic page code in .html page? i.e. i would like to insert a code which will display links. where my homepage link extension is .html. if it is .asp it would have been very easy. and also i would have worked fine. but now the problem is the homepage index file extension is .html.
so if i insert the code it is not displaying the links. i tried inserting the code in a separate file and saved as file.inc and gave the link from home page <!--#include file="file.inc"--> but still the link is not showing and not working.
When I send a database to server it changes all of my special charters to unicod charterset, I suposed that server is on american charter set, I would like it to change to central europien windows - 1250 code page, is it posible and how? it is very importand to me.
I have a password-protected area on my site. I'm not using any server authentication methods: Instead I prompt the user for a username and password using an HTML form and check these against a database of registered users.
I was thinking that this page should be returning a HTTP status code of "401 Unauthorized" instead of its current "200 OK". My reasoning being that this would let search engines know what's going on when they request a protected page and get redirected to the "Access Denied" page.
I experimented with adding response.status = "401 Unauthorized" to the "denied" page, but now it displays a (Windows/IE) username & password prompt instead. The HTTP sniffer shows that the www-authenticate field is set to "Basic".
My question: How can I indicate to the search engines that the page it is requesting requires authentication, yet have it not display the login/password dialog box?
I created a web page from Excel2000, using "Save as web page..."...Publish function. then, I moved htm file to my IIS web server. Then I added a form control, and submit button.
How can get the data on the excel file using ASP from server side? For example, the value of Cell(1,2), Cell(2,3)....
What I want to be able to do is create a user control that will display an entire page page within it. Does anyone know how to do this or better yet have any same code?
I like to know how to write this specifc function on ASP where the user eg: display a set of records on the webpage. Example the data are ID, Name and address.
Lets say i display the data on the webpage and i set the Name as the <a href>. So when i click on the name, it will move to another page with the id of the specific name. Code:
I have an ActiveX control in my ASP page that has not been signed yet, so currently just for testing I set the Security for Intranet to "Low". When I run the ASP page on my machine (the IIS is in my machine), I have no problem, except the page prompted me with "An ActiveX control on this page might be unsafe to interact with other parts of the page. Do you want to allow this interaction?"
But, when I run the ASP page on another machine (even though the other machine is also a development machine that already has the ActiveX control and I set the Security for Intranet to "Low"), it did not prompt me the above message, and I got an error when accesing any method of the AX control (e.g Object doesn't support this property or method 'myAXControl.method').
Is this because I have to create a CAB file and mark the AX control as safe for scripting ?To create a CAB file for this AX control, do I need to create my own VB AX Control project that contains this control and then create a cab file for this VB project ?
This is a standard ASP application that has several pages at the root withthe global.asa. I set a session variable session("accountid") = "123456" within an asp page and then response.redirect to the next page and immediately response.write session("accountid") and I get back nothing.
But if I set a session variable session("accountid") = "123456" within an asp page and response.redirect to a page in a sub directory and immediately response.write session("accountid") I get back 123456 on the screen.
I am having a problem with a site that I am developing - my aim is for it to validate as XHTML Strict however, I am running into a couple of problems validating it; in my Response.Write ASP script, I am not including " 's to define page element tags as they keep throwing up errors in the page. Code:
I've a strange problem with Windows Vista, running an ASP page on local machine (http://localhost/test.asp), the page does not give me any error but the asp code is not executed (simple code : <% response.write("hello") %), it show me a blank page, I think I've put all the setttings correctly, but maybe I must do something obvious to fix that.
I encounter a page reload situation in ASP. It is I need a way to differentiate whether the current page - "Application_Result.asp" got reloaded itself when user click on the browserRefresh button or is requested by the previous page "Application_Form.asp".
I tried using <%if Request.ServerVariables("REQUEST_METHOD") = "POST" then%> <!--it is requested from "Application_Form.asp, do something--> <%else%> <!--Application_Result.asp refreshed itself(such as user clicks on the browser Refresh button, do something else--> <%end if%>
However, in both cases, the IF statement above all evaluated as true. how to differentiate this two different behavior (Page Refresh versus Page requested by another Page) ?
I have page for user to update his/her details. What i want is after idle for more than 20 mins, the page will redirect to login page automatically. So that the user knows that his/her session already expired and need to login again.
But it doesn't working. This is because if he/she update the details (after idle more than 20 mins), and click the Submit button, it will go to login page and all the data will be lost. Code:
I am working with a developer, on two portions to a site, he is working in PHP and my work is done in ASP.
Is it possible for my pages to request data from a cookie that was written by his pages that are PHP but residing on the same server? Just want to make sure before I spend too much time planning out the development on my end.
I have an application which allow users to search our database. Quite a lot of search fields pull data from other tables. I don't want to populate the dropdowns (total 14 of them) from the database everytime as it slow the page load.
Instead I would like to have a link next to the text field which a user and click and the choices can be displayed and whatever the user click in the pop up I want to transfer it to the text box and close the popup.
For example there is a Textbox called country. The user can either type in the country name or click on the link which will pull all the countries from table in the database and which ever country user selects, the textbox is popluated with the country name and the pop up closes automatically. Code:
I'm trying to write an asp page line by line, as one would create a text file, only my file will end in .asp.
One line simply writes a close ASP code tag, or
FILECONTENTS=FILECONTENTS & "%>"
When this line processed, an error occurs saying that the string was never terminated because the asp page attempting to write this line of code to a NEW asp page reads that close ASP tag (%>), as an actual close asp tag for itself, instead of a STRING value.
How do I write this %> symbol to a new asp file, while still maintaining its purpose to close a group of asp code in the newly created page?
But as i carry some data from previous previous page, when i use (window.opener.location = window.opener.location), it can't capture my data as it just load the page. It will pop up error as no data captured :
Microsoft VBScript runtime error '800a000d' Type mismatch: '[string: ""]'
I am looking for a way to pass an ADO recordset that has been retrieved in an ASP page to another HTML-page. Is there someone who can provide me with a small sample or a link to see how this is done?
i am facing a problem with CrystalReports for visual basic.Net 2003. I have passed almost through all the problems but still i get a message when i view some reports "Page header or footer longer then a page".
I am using ASP.net with VB and the developing muchien is running windows XP. the program works correctly to my computer but when i transfer it to the server machine i get the error .
The server machine is running windows 2000 server. It has the service pack on it and framework 1.1 with all the updates. Does anyone have a clwe?