Gettin' Data Into A Listbox/menu
Is i t possible to get data into a list/menu from a specific field in a db table like "date"?
View Replies
ADVERTISEMENT
Passing Dynamic Data From Listbox
I've created a page that has a dropdown listbox with values derived from a recordset. That is working fine. What I want to do is take a value selected from the dropdown listbox and pass it to another page that is pulling a report based on the parameter I'm selecting in the dropdown listbox.
I'm able to do this with a textbox being used to accept the parameter, but I want the client to select from a list of actual values, which will then "filter" their report.
Changing Values In 1 Listbox When Selecting Records In Another Listbox
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?
Gettin' Top 3
I'm havimg an database table with 10 users (ID) who play golf. They insert there score everytime they play using the ID, which means that there can be several of records with ID=1 and so on. I'm then getting the average of all there scores depending on the ID using a line like this.
strSQL = "SELECT AVG(brutto) as brt from Score WHERE ID=1"
So far so good. Now i would like to get the 3 best averages to be displayd. How the hell do i do that?
Gettin Average Of Last 10 Records
I have little golfclub with a leaderboard where each member gets point after each match (1 - 20 points). Is it possible to get the average point of the last 10 records, and what if they only played 7 matches can i get the average of that.
View Replies View RelatedDrop Down Menu Include Data
I am currently working on a project and i need to have drop down menus on a form which include data from tables in a database. There will be a number of drop down menus on this form as well as text boxes. I'm struggling with the code and need to know how to code a drop down menu that would include all the records from a drop down menu.
Is it possible to use all the values in the form, including the drop down menus to insert the values into a relational database. I'm assuming i would have to use variables to pass the information into the database using an SQL insert, but i am once again unsure how to code this.
Gettin Table Names From A Ms Access Database
Ive got an accces database with a couple of table in it at the moment but this will grow to 5 tables pretty soon then maybe more after that.
I would like to be able to populate a drop down menu with all the table names in the database any ideas how to do this or if its even possible.
Sorting Data Based On Dynamically Created Drop Down Menu
i have a page which displays a list of events searched for by a particular date. we usually have a lot of events and i don't want the user to have scroll through all of them, especially if they're interested in a particular type of event.
i have created a dynamic drop down menu which consists of all the event types. how can i got about displaying the events returned by the query to a specific event for that date.
so for example, if some one searches for 03/08/2005, they will initially get a list of all events for that day. if they click on "Closed" from the drop down menu, it will display all the "Closed" events for 03/08/2005.
Pop Out Menu / Sub- Menu In Frame
does frame support pop out menu? Thanks....
View Replies View RelatedAsp Form Menu With Sub Menu
Can any one help with code for form menu in which sub menu appear on selecting the main menu. This is one field of an access database to be submitted by user.. Now I have code only for selecting from main menu. Code:
View Replies View RelatedASP _ Listbox
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.
View Replies View RelatedListbox With Two Columns?
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.
View Replies View RelatedValue From Listbox In Hyperlink
Rather than doing this:
<A HREF="editpatient.asp?ID=1>View</A>
Can i do something like this instead? - and make it work
<A href="EDITPATIENT.asp?ID=" & LISTBOXPATIENT & ">View</A>
where LISTBOXPATIENT refers to a database populated listbox
The idea being that when the user is completing a form they can look up additional data on a patient by clicking the hyperlink next to the listbox.
Listbox Size
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>
Listbox Width
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
Listbox Selections
Does anyone know how to make a form take you to different pages depending on what is selected from a list box ? im using asp /sql / and dreamweaver ..
View Replies View RelatedPopulate Listbox
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.
Figure Out Listbox
I want to select a value from a ListBox, and depending on that value, if it is the right one, it disables a textbox? Can this be done with Javascript?
View Replies View RelatedListBox Problems
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:
ListBox Control
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.
Updating A Listbox
I wanna update a listbox via another listbox and sending new values into database.How can i do it in asp vbscipt?
View Replies View RelatedListbox Item
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?
'Autocompleting' Listbox
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.
Get The Value Of A Disabled Listbox
I found out that I can't get the value of a disabled field with Request("myField"). An alternative could be 'readonly', but my field, that is a listbox <select>, doesn't have this attribute.
View Replies View RelatedListBox Query
I have a listbox whose MULTIPLE selected values are retrieved using
Request.Form("<listboxname>")
This returned a comma separated array.I am gonna display these values one below the other on the screen. When i retrieve the values from the array using ArrayName(0),ArrayName(1),etc.. the values along with the COMMA are also displayed. When i Remove the Comma with a function like this..
somevariable=Instr(ArrayName(0),",") -1
It errs....
How to remove the comma while displaying?anyother method?
Update One Listbox From Another
I have 2 tables in my database, AUTHORITY and AREA. I have 2 listboxes on my ASP page. The first one selects all from AUTHORITY. I have one recordset so far, obviously pulling out these values from AUTHORITY.
What I want is to have listbox 2 automatically populate with values from AREA where a field = the value of AUTHORITY. I know this can be done with onChange events in Javascript but I can't work it out.
Borders In A ListBox
How do I get rid of the borders in a ListBox? There are atributes for TextBox and Image but I can find no way to do it for ListBox. What is CssClass artibute? If its the Css style it does not work either. Unless it has to be somewhere else rather then on the page, I tried it few times.
View Replies View RelatedListbox From Asp To Access
i have this form, which contians list boxes. wen a user selects his choice n clicks submit button. it gives an error of type mismatch. wat changes shud i make in my database table's datatype wen recieving data from a listbox? i tried selecting TEXT but it didnt work. cud there b another reason for this error?
View Replies View RelatedPage 2 - Listbox
You should know the difference between the javascript and asp error. When the page cannot be displayed then it is ASP error and the line number mentioned will be the one in the actual asp file. When the page can be displayed and the error pop up then it is the javascript error, for this kind of error you have to check the source file for the line number.
I hope now u will be able to differentiate the error and to look for the correct line which is causing the error. Back to the error you have mentioned. Does the main_head.asp have the javascript function called alterTab()? Remove this include file and try whether it cause the same error.
Dynamic Dependent ListBox
I have a database table called Pumpdata. This table contains all the different pumps available. I had to make 2 other related tables one called pumpType which is just a description of Pump Types. ie.. (single, double, mixer etc..) and the other table is PumpManufacturer which contains a list of Pump Manufacturers.. the 2 tables are related to the pumpdatatable based on the TypeID (in PumpType) and MfgID(in PumpManufacturer)..
Ok the problem I'm faced with Is I need to create a form to get a particular pump based on the Pump Type, The manufacturer, and then the specific Model Number..
The First list box alllows the user to select the Pump Type, The second ListBox allows the user to select the manufacturers based on the pump selection. (Note in the pumpdata table there could be an occurance where a particulatar PumpManufacturer could have several Pumps of the same type (I just need to show one occurance of the PumpManufacturer here). Code:
Updating Listbox With 2 RecordSets (ASP And SQL)
I am creating an update user module. and the dropdown boxes are DB driven. But when i pass the user details to this form i have problem highlighting the selected option in the listbox.
I would like to create a DB driven listbox. one recordset is used to list all the countries into the list. the 2nd recordset is used to add the selected value. But I could only list all the countries into the box and not able to preselect the country. Below is my code and hope someone could highlight to me my mistake. Code:
First Record Not Loading In Listbox(es)
I joined the group few days ago after discovering that this forum has a lot to offer and the forum threads also pops up on my google desktop almost every 5mins giving me an update on the forum.
Actually,i have a problem here.After fighting with the code found below for several weeks,it turned out to be successful.
The code is suppose to automatically load dropdown boxes from a database based on a given value from previous page,say from 1 to infinity,but after loading,it ignores the first record in each of the listboxes.Can someone help me out with this?What have i done wrong?
Code:
Populate Textbox From Listbox
I have created this array...
For x = 0 To rs.fields.count - 1
Response.Write("sampleValues[" & x & "] = '" & rs.fields.item(x).value & "';")
Next
because I need to x values to get the indexes of rs.fields.item(x).value into my asp page for use on the next page. Further down the page
I have a number listboxes created thus....
Code: