I need to populate a select form input (combo box) with about 22,000 rows of data. This is taking an unacceptable amount of time to load. And this data is only going to grow in the future.
I'm using a stored procedure to get the data. Not sure if that's the most efficient. I'm using classic asp. I'm open to any suggestions because I'm not even sure where to look to get options.
I am using couple of dropdowns on a form which pulls data from one of our
tables.
The data list is quite large (500+) and it takes users a lot of time to find
the correct item. Users are getting quite frustrated using the dropdowns as
they have to scroll for a long time.
I will need to send bewteen 2 asp pages very large amounts of data
what is the best way to send it and to read it?
for ex. I know this method:
For i = 1 To Request.QueryString.Count - 1
Response.write(Request.QueryString.Key(i))
Next
unable to reterive large amount of data(100k) from a textarea control using request object in ASP. It gives runtime error.
View Replies View RelatedHow would I limit the amount of Characters that show in the display:
<% =objRS("Title")%>
Like a Left Trim I only want 12 to 20 characters to show.
i would like to sum the total of the Daily Sum Total Field name. Code:
View Replies View RelatedIs there a way to put a cap on the amount of lines you can type into a textarea?
View Replies View RelatedHow would I limit the amount of Characters that show in the display:
[ <% =objRS("Title")%> ]
Like a Left Trim I only want 12 to 20 characters to show.
i have a textbox that has a value $6.00 for example the user has
to enter a dollar value which has to be less then $6.00 so for example if the user enters 4.00 an alert should be fired telling him he has forgotten his dollar sign ("$") then when he enters it properly like this $5.00 i have to check the value is less then $6.00 and it has to be done in javascript
the textbox which holds the $6.00 value is called saleprice
the textbox which holds the $5.00 or value less then $6.00 is called userprice
I've been working on a script that finds and updates a record in
database based on the user's input. When I try it I get this error:
Active Server Pages, ASP 0113 (0x80004005)
The maximum amount of time for a script to execute was exceeded. Yo
can change this limit by specifying a new value for the propert
Server.ScriptTimeout or by changing the value in the IIS administratio
tools.As I can't post a message for some reason whenever I try to include m
script in this message, see attached .txt file for code.
I want to calculate the sum of all invoices so to be displayed total sum of them
I'm trying with this: Code:
How would I limit the amount of Characters that show in the display:
<% =objRS("Title")%>
Like a Left Trim I only want 12 to 20 characters to show.
Is it possible to run a script after specified amount of time after login. I made an online test tool. I want to end the test after 20 minutes.
At present one who is writing the exam clicks this endtest script. I want to handle this from software, if he takes more than the given time.
I have three text boxes. One text box holds a beginning date, a second holds an end date, and the third box holds the number of days in between. I would like the page to figure out the number of days in between the two dates without having to type in the number of days.
Is that possible to do without having to use some kind of confirmation page. I mean using a confirmation page would work also, but I wanted to cut out the number of steps that a user needs to complete the assigned task.
Text Box 1: Beginning Date
Text Box 2: Ending Date
Text Box 3: Number of Days in Between
Is there a way to limit the number of characters shown from a db field on a web page. In other words, instead of showing the entire title of a work order, I may only want to show the first 30 characters followed by .... Does anyone know how to do this?
View Replies View RelatedI have been writing a photoalbum in ASP and I am trying to receive an undetermined amount of files.
A more detailed explanation:
The client side (Javascript) generates a new file upload box as soon as the file in the first box is selected...the name of the file upload boxes is bestand[] so that the input is received in an array.
Now I am trying to receive all the files with ASP and store them on the server....
how can I make an if condition where the condition checks has the user inputted atleast 3 numbers in the text field. Code:
if variable1 < 3Numbers then
response.redirect "error.asp"
else
execute something
I have fought with this problem all day long and I can not get this work.
I have an ASP app that allows administrators to add articles to a database for viewing by the public. What I want to do is display a summary of the article and give the user the visitor to the website the option to click "more..." to view all of the article.
View Replies View RelatedI am looking to return the first 50 characters from a database field. Does anyone know if there is a SQL function that returns a defined amount of characters from a database field?
View Replies View RelatedThis is my first asp form so please be gentle with me It's a publications ordering form. I've got the form and the asp code setup, when the form is sent the name of the publication comes through but not the amount ordered - i'm sure i've made a simple mistake somewhere - can anyone spot why the order amount isn't coming through. Code:
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:
The following is the error keep getting while running web application.
Tools used: HTML, ASP, DLL's(written in Delphi).
Application Error: dllhost.exe - Application Error
---------------------------
The instruction at "0x00000000" referenced memory at "0x00000000". The
memory could not be "read".
Click on OK to terminate the program
I am updating over 100 fields in 7 tables with SQL in VB 6.0. The values will mostly come from check boxes. Do I need a VB variable to hold each value for my SQL query?
Also, what is the syntax for skipping an optional field? Do I just skip it and use comma's? I will never know which values are checked off so I cannot write code that will only insert my true values.
we are rebuilding a large website and we want to make sure it doens't lose it good ranking within the search engines. So we were thinking of using 301 to tell google where the pages have moved to.
The problem is I'm not really sure where to start to impliment something this. We have a website that has 26,200 indexed pages, so I need to come up with somekind of solution that would work across the board.
I am a PHP programmer and trying to do a site in asp but one feature I can't figure out how to do in ASP is large variables.
In PHP it is
$fullpage = <<<EOT
THE ENTIRE PAGE OF HTML
EOT;
EOT can be anything it just uses that as a starting and ending point so I can have quotes, apostrophes, variables etc inside the page. Is there any way at all to do this in ASP? Code:
I am trying to upload large images ( around 4 mb) from the server to show on
the client. Currently I'm using an http handler to do it and breaking it
into chunks sending it 1 mb at a time. Sometimes I'm getting errors, like
the page won't load. Any solutions on how this is done right?
I am trying to do some calculations on large numbers (ie
7,768,489,957,892,578,474,792,094 / 12,280) and no matter what I do it
doesn't get it quite right. Its always somewhere between 10 and and 5000 out
:(
I have a suspition is could be down to one of the number functions I am
using along the way but im not sure.
I am using forms authentication to protect all content as described in the
kb article below.
http://support.microsoft.com/defaul...kb;en-us;893662
This works fine except for files that are larger than about 40 or 50mb at
which point the user gets a 404 error and the httperr log indicates
connection_dropped status.
This is a w2k3 server with SP1 and all security patches installed.
Has anyone seen this before? I have been reading various posts online but
none seem to fit this symptom. Also have tried tuning various meta-base
properties to no avail.
It seems to me that I generally use two types of Functions:
Type #1-Ones that any page on my site might use
Type #2-Ones that only a single page would ever use
Logically, it seems that I should put the Type #1 functions in the GLOBAL.ASA file and the Type #2 functions in the pages that use them. I would like to, however, just go ahead and include ALL of my functions in the GLOBAL.ASA file.
Comments on this? Is this a good idea?
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 am attempting to use the technique in KB 812406
(http://support.microsoft.com/?kbid=812406) to transfer
large files via Response.OutputStream.Write.
It works GREAT in in debug mode. But whenever I set
debug="false" in the web.config file clients get cutoff after about 1.5 minutes.
There is no error raised the client simple gets an incomplete file.I've tried playing around with various timeout settings in web.config and in IIS with no luck.
I am currently developing a download centre for a hardware manufacturer which has alot of firmware and other software available to it's clients. Most of these are less than 10mb and with their internet connection I'm thinking a browser upload through the admin tools will be fine. However there are files on the current site of up to 100mb, how would be best to handle uploading these?
I was thinking maybe an ftp component would handle bigger files better than an normal http upload? Does anyone know of any components that allow some kind of background uploading so they can continue to use the admin for other tasks while this continues?
Or just any other suggestions full stop! Maybe I would need to come up with some way of taking them out of the system and loading a windows ftp with the correct directories etc.. predefined?
I want to count number of data available depending upon the conditions in the large database the database table rows are approximately 3 lakhs and there are multiple table to be searched and records need to be displayed in ASP pages.
Kindly suggest the best scripting method as i am always getting error like "Script Time Out" Error in Active Server Pages (ASP)
please suggest how to avoid or in sql server i can create some pre defined script and just call from asp pages