I have an ASP app (developed with Interdev 6) which uses
a DTC listbox (server-side) bound to a recordset to allow
the user to make a selection. This works fine until the
number of records in the record set seems to hit a limit
(not determined the exact limit, but seems to be c. 400).
If there are too many records, the app just hangs until
it hits the scripttimeout limit.
I've tried increasing
both the command timout (I'm using an ADO command object
to generate the recordset) and the scripttimeout to no
avail. Does anyone know whether there IS a defined limit
on the number of entries in a listbox? Also, any better
ideas on how to allow the user to select from a large
number of records (> 1000)?
I was wondering if you could help me with the following problem. I have 2 listboxes in my webpage, 1 has cities, and the other lists the streets of the city from the first listbox.
When I click on a city, I want the 2nd listbox to populate with all streets in the city. The city and streets are saved in a database, so when the user selects the city, I will run a query on the database and populate the 2nd listbox with all streets.
How can I do this with normal ASP? I know how to do this with ASP.NET, but don't know how to activate this with normal ASP?
I have a problem with Insert statement. Though My SQL Statement executed once only, there are 2 records entered in DB. I am using ASP and SQL Server. Does anybody know the solution?
I want to validate client entries into textbox,checkbox controls etc. can u do this with asp. Like, is there onchange and onclick and so on for these controls?
A different question though. Is it possible to delete duplicate entries, where the email address is the same, and only keep one? i.e.. I got say 4 DB entries, all with the same email address, and I want to delete 3. How do I do this?
Does anyone know what sort of command I need to use so that if someone posts an entry to my database with a primary key that's already been used, the old entry is overwritten by the new one
Is there a way of checking whether two entries in a form are the same? Like when you have to enter your password in twice. I'm not actually sure whether it's asp. Sorry if I've posted in the wrong place.
I have a database for projects. Some managers are responsible for multiple projects. I want to dynamically populate a list of project managers, choose a manager, and display a complete list of his/her projects. I have a few problems 1) I cannot figure out how to list a project manager's name only once in and 2) I don't have a clue how to compile all the projects for each manager so that when his/her name is chosen it will display all the records.
I have setup a simple site in which users input data to an access database, and then the database results are shown on another page in a table. One of the fields in the databse is Date Added, using the date/time data type.
I would like the table to show new results with a different background colour for a period of time, say one week? Code:
There are a lot of references on the net on how to delete multiple entries in a database by using a checkbox. What I would like to do is add a checkbox to the output of a query (ie. bunch of names).
Then be able to select some of the names by clicking on a checkbox and when submitted, add those checked names to another database (insert). Similar to a shopping cart selecting multiple products but when submitted, it does not add them to the checkout, it adds them to a database as new inserts.
I have made a forum script and I know this is very basic stuff but how do you go about updating a number with an increment of +1.
Access Database - Two Tables - Topic and Replies.
In Topic there is a column called replies. When a user views a topic there is a reply form at the bottom which is processed by reply.asp which add the information entered to the database in the replies field. Also added is subjectid to each reply so I can link the two together.
Either I want to be able to update the reply number in the topic table by +1 in the appropriate subject row (the id is passed on to the reply page) or count the number of alike subjectid's in replies to the subject in topics. What is the best way and how do I update numbers by +1.
i have a registration form in my website. the requests are going to the database (windows 2003 small business server). I have an other page who the entries are displayied. how i can delete the each entry separately with a button?
I tried the following code to save in a variable, the quantity of entries in my recordset:
if rsEntries.Supports(adApproxPosition) = true then strCount = rsEntries.RecordCount end if
It didn't work for me. It's returning a value of -1 and I have close to 100 entries in my recordset. Is there an alternative to this? What code can I use to accomplish that?
User clicks on a button [BUY NOW], item is added to cart. User can either continue shopping or view cart. The order here doesn't matter. When user views cart, two items are added, the one selected and the last one in the product file. The product file is a CSV file.
The last entry is called BAD-Product. It is a debug entry during site development so the developer knows the product name is entered wrong, i.e. misspelled. If the name was omitted an error would occur so there is a name.
This only happens with Firefox and Netscape. IE experiences no problems. The last entry is not added.
Accidental temporary solution:
In review of the code, a debug line was put in to make validate the product item being returned. After saving the page (.asp add item page), the error disappeared. The debug line was then commented out and the error still has no resurfaced. Code:
I need to loop the recordset and count the occurrences of each entry. The entries will always be numbers.
If entry = 1 then count(1)=count(1)+1 If entry = 2 then count(2)=count(2)+1 ... If entry = 100 then count(100)=count(100)+1
The problem is that there could be 1-100 (or more) different answers stored in the field so coding 100 IFs will work (as long as noone needs to enter 101) but seems silly. How do I create the array above to look something like:
I have a ASP page that returns and manipulates information from an access table. The information it returns is the figures for each month for certain products. Basically the page adds up the results returned from each month and then gives a total for the year so far for each product. So we can view the figues for every year back to 2000 to see how the product did. The problem is that when we choose 2006 it returns no values, and I can't see why. The only difference is that for the months that havnt been completed yet - May onwards, there are no entries, not even a '0'. Would this be a problem when adding using the asp page, adding a number to a returned object that contains nothing?
I have a dbase containing login details for 21,000 members. I also have a forum that I am about to implement.
When the user gets to the main site, he has to login (this is done by checking his credentials against DB1) When he is logged in, all his details are stored in session variables. Clicking on the forum link will take him to the forum where he has to log-in or register. Currently, the forum checks cookies to see if there is a valid name and password and then checks these against it's own DB (herein called DB2) or requires the user to login/register
I plan to modify the forum so that the login is bypassed and the forum accepts the current session name and password as the login. (This is so that all names on the site main site, chat, forum etc are uniform, i.e Dave47 in a chat room, is Dave47 in the forum, is Dave47 in the members area etc)
so...what I need to do (if you're still with me) is.
When a new user registers on the main site, his details are put into DB1 *and* DB2. , can I have two data sources open at once?
The reason I need two DBs is that the information in DB1 is a lot less than is needed by the forum in DB2.
Also how can I copy selected fields from DB1 (name, password for existing users) into DB2? like I said..there's 21,000 and to do it manually would take forever.
Does anybody have a nice method of forcing a user to enter a value into a form using asp?
I think the best is to have a popup when they hit submit that will stay on the same page and then just alert the user to enter something in so and so text box.
I have a database that is for E-Cards. I want it to delete all of the entries that are more than a month old. I have the date stored in a field called "dags" (without the quotes). Please help me on this!
******************************************* Also, I would also like to have an option for "Send the E-Card Later" and then have the options possible dates. What script(s) could I use to do the actual sending on a later date? ********************************************
Is it possible to change the selected default option in a listbox on the 2nd page to the option selected in a listbox on the 1st page which ..i.e preventing the selected option from changing to the default option on the 2nd page (both the list boxes have the same value)...i am having a listbox which gets populated from a database using ASP.
I want to make a listbox which will show the results of two fields (the ID and the Name) of one table , but the one field (ID) will be the one to pass.
I have a drop-down with 40 option values and only one option should be selected of the 40 options. The list size should be 1.
When I click on the list, it drops down 30 options (a very long list) with a scrollbar for the last 10 options.
Is there any way, when I click on the list it drops down only 5 options (as if the list is of size 5) and allow a scrollbar to browse the remaining 35 options.
Code is: <select name="deplist" id="deplist" <option value="Commerce">Commerce</option> <option value="Instru">Instrumentation</option> ... similar such 38 options </select>
I have 6 list boxes and it may or may not have data from db to get fill in. so what happens is whatever has data that comes to the size of the maximum length of the data in that list box and others comes as very small width as there are no data. but what i want is all list boxes width should be of moderate size. how can i make those empty list boxes appear as moderate size. I dont have an option to put an default item in the db to load with that
Im new to asp and I'm having trouble with listboxes. I have two listboxes, the first is populated from a database and I need to fill a second listbox with items from the database that are dependant on what was selected in the first list box.
the listbox on the left contains the names of employees
the listbox on the right contains the names of employees selected from the listbox on the left (ie by hitting the buttons they move across)
when I submit the form which those two list boxes sit on - I want to access the list on the right
currently on use valus=request.form("RListBox") - then I split the returned value from valus etc - however this ONLY works if I select each item in the listbox (making each entry highlighted)
what I would like to do is itinerate through each item in the listbox and get its (option) value. Code:
I would like to create a listbox control in asp.net that has the capability of multiple columns like the Windows.Forms.ListBox control.
I have searched high and low and have only found advice such as concatenating the strings into one or using a ListView which do not seem ideal to me.
Would it be possible(and fairly easy) to create a Custom User Control, fill it with multiple listboxes and then programatically change the selected indexes of all of the ListBoxes when the selectedindex of one is changed?Custom Web Controls is another option but its apparently more complex to implement.
if it is possible to narrow in on an item within a listbox of states. For example, right now if I type "W", I will immediately drop down to those states beggining with "W".
However if I type "WI", I go to the top of the list with those states beginning with "I". I would like to continue to zero in on the state by dropping down to those that begin with "WI". Is this possible and if so, how do I go about doing it?
I would like to be able to use an autocompleting listbox - that is, one where you can select an item in the list by typing the first few characters; the standard IE listbox only responds to the first character.
I'm happy to pay a few quid for a 3rd-party component/activex control if necessary but I imagine something equally good could be done with client-side code.
