I have a simple data entry form that has text boxes and some drop-down menus per row. My problem is the performance of the page.
I give the user the option of displaying 25, 50 or 100 rows at a time. Each row has 12 text boxes and 4 drop-down menus. The OPTIONS for the drop-down menus are being populated with data from our MS SQL database.
I'm using VIEWS to get the data and place them in recordsets, but how can I increase performance. It's taking way too long for the page to load and if the user clicks submits.. that takes a long time too.
I want to have a drop down menu, that when you select an option, loads data from the database into another drop down menu. So that's one part I don't know how to do. There will be a total of three options from the first dropdown, which represent different tables in the same database. So that's the other problem, how to load, depending on the table selected, into the drop down menu.
I am trying to write a function on a navigation page so I can just include the nav page on my other asp pages this way I only need to edit one file when I need to update the navigation system.
The problem I have is that if I try and do this with the response write statement how I can't use " inside the strings i.e
How do I store " inside a variable called say SP so I can do this?
Response Write "<form name="&SP&"form1"&SP>"
I am am guessing there must be a way you can store an asci value into a variable. But what is the command for this and what is the ascii code for "?
Finally is there I way I can write a drop down menu purely in ASP so I can avoid putting the HTML code inside strings?
The reason I have to have it the ASP code is simply I want to call the function that outputs the drop down menu in other pages, if I did not do a function it would not work as it would output the drop down menu at the top of the or whereever the include statement is.
I have an asp form that submits information to a database. On this form, I have a drop down box with about 15 options, each with thier own value. The selection is down a bit in the form, after user fills out certain information.
On the same form, I have a hidden value stated for "assigned_to" field. Most of the options in my drop down menu need an "assigned_to" value=35 and one option needs an "assigned_to" value=40 . How can I do this?
How do I make a dependant drop box? For example, when a user selects Item5 on the first drop menu the second one populates with the options for Item5? I know it will probably use Java of some sort but I do not know the code.
Im putting my website together, and I have made some simple text buttons that are aligned across the top of my page from left to right.Anyway, I have with this navigation a need to have more navigation options, which I hope to gain by having sub-menus appear when you roll over the button.
What I mean is how do I or can someone point me to a tutorial that will allow me to have a dynamic drop down menu generated via asp with data from a access databse that will allow the user to navigate to that sub menu content.
Hope you can help with a small problem I am having. I have a very simple table displayed on a page -
ID Name 1 x 2 y 3 z
and what I am trying to do is this - Roll over the ID number and display a pop up menu (which has more links to run other ASP scripts) and pass the ID number from the original page, though the pop-up menu and into the final ASP script (as selected on the popup menu) as a parameter for an SQL query.
I am trying to figure out how to pass one selectedIndex value to another select menu on a subsequent page without opening the page in a new window. I know how to pass information from one text field to another using Request.form or a Session, but I am not certain how this works with select menus. I have seen other examples that require you to open a new window, but again I would prefer not to do this.
I have two different select menus. This appears on the first asp page.
The next page has the exact same select menus as above and I would like it to populate the same value the user chooses from the first form page. I should state that the first select menu does redirect the user to different pages, however it should not matter because the above options for the select menus are consistent on all the pages the user is redirected to. I'm assuming the answer to my query will consist of utilizing ASP and JavaScript, however if not, I'm still game.
I currently have a page with car manufacturers in a dynamic form menu. Users can select one and click submit to find available cars by that manufacturer. What i now need is a second menu on the page where when a manufacturer is selected, the models associated with that manufacturer display for a user to choose. For example if Ford is selected:
Menu One Menu Two ------------------ ----------------- Ford Focus Fiesta Ka....
Can i do this with ASP to say "if menu one is ford, menu two contains...."? Or is there a much easier way which i am somehow missing?
i'm trying to create a dependent dropdown menu based on two objects, packages and steps (the steps dropdown will be dynamically updated/populated when a package is selected). the site uses ASP and since ASP is server-side, i am using JavaScript to handle the client-side "dynamic" change.
i've found several snippets of code that create the dependent dropdown; however, the two examples i have use arrays which are statically defined. the data that will populate the dropdowns is coming from a SQL database, and that data will be updated/changed fairly often. my question is this: is there any way to generate the arrays using ASP (outside javascript tags) and use them in the javascript?
or is there a way to use javascript to generate the correct arrays and fill them with data from my SQL tables? can i use a recordset ojbect in javascript? i have heard that you may use PHP inside javascript tags, but i'm unsure if that is what i want to do.. especially since i am using ASP as the main language for this site. Code:
I've got a problem with asp.net i am trying to make a menu control. and have searched the web for serveral controls but they don't work correctly.
I am pretty new to asp.net building. What am i looking for. i am looking for code to make a dynamical menu with submenus The menu items are stored in a MS SQL Table and when by loading the page the items will be created. i have made a asp table. i want my menu on the left cell, in the middle cell i want to change my pages to the menu item choosen. Code:
I have two menu form elements that need to refelect a parent child relationship. There are 85 zones and 2200 zone-network combinations.
I want to bind the networkid element to an xml datasource that contains only the networks related to that zone. I have read about something like this before but have never implemented it.
I have four pull-down menus and a GO button. Each menu contribute a parameter to an URL query string (like asp?a=1&b=2&c=3&d=4) where variable a is return from menu1, b returns from menu2 etc.
I created the four menus using Dreamweaver's INSERT JUMP MENU function and I find it difficult to modify its auto-generated javascript code to suit my needs. Does anyone has the complete code to accomplish this?
The code that I have has 2 drop down boxes dd1 (visible) and dd2 (hidden). Based on the option selected in dd1, dd2 should be visible and populate options. I think I can have OnChange script but how could I return the value and put it in the SQL query (see variable in red in thecode)? Code:
I'm using MSXML2.ServerXMLHTTP to retrieve a webpage. It works, but is unacceptably slow (~20s) when retrieving remote webpages (anything outside our network).Is there any way to improve the performance?
im trying to build some custom shopping cart for a client
what i know about shopping carts is the main idea which is an array stored in the the client's session
also i know that this point (the session) may cause some bad performance and here is my point
any cart contains just the product id and number of items or something like that (some people says data dictionary is good here)
the cart im going to build contains alot od data coz the site client when choose to add some item to his cart must be redirected to some page with a form to add many details about his needs with the product so the session here will carry alot of data ........
so i thought in 2 iedeas
1- array into session 2- some databse table carries all of temporary data with a unique primary key for every session but i need to know the best selution for the best performance
If I a loop that displays a list of records on a page, lets say a list of contacts (lets say 200). The question that I have is does it effect the performance if I add inside the loop the following:
Whether it can improve the execution effciency of ASP by centeralizing the often used code into header files and then including these header files in ASP pages?
I have a 500 page ASP program that takes 1-2 seconds to execute. For some strange reason it takes 20-30 seconds before the first lines executes. How can I make this program behave better?
I have a list box with about 500 users in it. I have to populate that on a site. It causes extreme slowness. I am using classic ASP with MS SQL. What is happening is the users are stored as a number (a user_id) and that number is looked up. Then that number is passed through a simple function to turn the number into a name. The names are stored in the DB in first_name, last_name format. The company wants the list box in first_name last_name format so the function is needed. Should I look into database caching, caching the list box somehow, making another table of the user_id's and names in the correct form, or some other option. Once again, I am not using ASP.NET, but classic ASP instead.
I am running the WebService / CurrentConnections performance counter. It works fine for one site I'm looking at, but not for another. The one it doesn't work for, the polling vertical red line doesn't even move. Is there a setting somewhere that controls whether a web site can be be 'polled' or not? I am using Windows Server 2003 Standard Edition.
I'm maintaining an ASP Classic file that has HTML withing Response.Write methods such as <% Response.Write "<table><tr><td>" Response.Write testVariable Response.Write "</td></tr></table>" %>
Would their be a performance hit if I were to write this instead?
I have a database with 300,000 records. I have two "DATE" columns and I need to calcluate the difference and display the number of days in one of the reports. I was wondering if this calculation of days should be done on the fly or is it OK to have a "Difference Date" column[Contains Number of Days] and retrieve the same
Their will be not more than 50 concurrent users accesing it. However, in the next 6 months the record size is expected to reach 800,000. The database will be hosted on a shared hosting on the internet
how to display the current connection value on a ASP page. Wanted to know how to read this value into ASP page as opposed to going to performance monitor.
any 1 know of any resource that provides Active Server Page performance on differenct server platforms. I am interested to know what the page/sec, concurrent users (on avarage, this of course depends on other factors) is for Dell PowerEdge servers.
I recall that 40page/sec on 800Mhz server a few years ago was really good. What can I expect from a dual PE1750 3GHz Xeon?
I have an asp site that of late is having a very very slow response at the production environment and it is taking 6-7 minutes to do the basic operations that are needed. We have come to know that the performance has deterirated after the recent release.
Going through this thread IIS 6.0 slowing down one of the suggestions listed was to make sure one destroys objects the code creates which I have taken care in all the pages. Actually all the new changes that were to be done involved working with session or local variables and so no com objects were touched.
We are using Windows 2000 server with SP4 at all the environments. Could someone tell me some suggestions on how to identify the problem? This is a problem faced by many at the clients end and this occurs even on server restart. Please let me know if there are any additional details that are needed.
I've been trying to transition an application from an Access db to an Oracle db. I've got the base functionality down, but it's slooow. I'm prety sure that the 8 processor IIS and Oracle servers are more than capable of the low traffic that my code creates.
My question is, what's the most efficient way to do this? I've been and still am doing research on cursors, locktypes, etc... But, I haven't come across something that is similar, so I thought I'd see if anyone here has had the same experience.
Currently my connections/recordsets look like this: Code:
I am writing a page to go into a real large database and pull out the most recent entry and post it to a web page in an ASP document. I think I have the query right, but it is sooooo slow that it isn't a good solution. The code I have to do the query is as follows, but it is soooo slow it doesn't work..
I have another table which is much smaller, where I can find the unique ID values (they only occur once in the other table..) Can I then go to the last record of the larger table and search backwards from there, stopping when I find the each occurance of each ID in the smaller table?
Any ideas how I might go about it? I have searched and searched but haven't been able to come up with something that works yet. Code:
