I have an application in asp; in my form I have a combo and a textbox, the combo is fill in from a database query. I cannot do the following: when selecting an item from the combo, it should send the ID of the combo to a textbox. In other words, when selecting an item, it must send the ID to a query and the result of this query send it to the textbox. I need to do this using vbscript and the onchange method.
View RepliesIs there a way to format a textbox such that when the user types in the number 4000 it will be automatically formatted to $4,000?
View Replies View RelatedI have a list box containing:
Ford
Vauxhall
Nissan
Honda
Volvo
How can I select certain names and have them transferred to a text box ie.
if I click Ford, Honda, Volvo I want it to update the textback like [ Ford
Honda Volvo ] when I click each one (like in hotmail when your select email
addresses.
I 'm trying to display a combo box (which datas are coming from a database) depending on the select of another combo box in the same form. I think I should use the property onChange of JavaScript but don't know what to give in parameters.
In fact, I have an ASP function which generate a table containing the Strings obtained thanks to a request in a database. Then I'd like to put the Strings contained in the table, to a combo box. The combo box should refresh each time the user select another field in the former list. It must be developped dynamically.
There are many comboboxes. One of them is where a user can select a
"State".
Based on the state, I want to select a "County". The form should populate
only the counties that apply to that State
I know how to do the JOIN if needed, but not quite sure how to pass the
value of the "State" combobox to the query that will be populating "County"
SELECT County
FROM Census
WHERE County = (value of the combobox "State")
Here is the code from the combobox "State" Code:
Can someone tell me why my "select2" menulist disappears??
Code:
I have a dropdown box getting data from a database, and I send the data to the database on form submition, But, I need to send another data to another column to the database according with the user dropdown box selecion. Example.
Dropdown option 1: DELL Corp.
Dropdown option 2: IBM Corp.
Dropdown option 3: Avante Systems
If the user select DELL Corp., it will send 'DELL Corp.' to the database but I need it to send dell.jpg to another column too. I have the code to send the data, but the relationship of the boxes is 'the thing'.
A solution almost like bellow is what I am looking for, but instead of, the selection in the first combo should point to another selecion in the second combo (so the second combo will have the dell.jpg value): http://forums.aspfree.com/code-bank...own-137839.html
i have a form and i need the selection from the first dropdown to influence the results on the second dropdown.The first dropdown will have a list of guesthouses and based on the guesthouse chosen, the second dropdown will give the rooms available in that chosen guesthouse.
View Replies View Relatedcurrently need to do a dependent checkbox, mean when i choose 1st check box, 2nd check box will become visible and if i never choose it, 2nd checkbox will become blur and unclickable. may i know how to do it?
View Replies View RelatedI have three listboxes
1 : company
2 : department
3 : function
I want the following functionality. when i choose a company all the available departments in that company must appear in listbox2 and when i choose a department all the available functions must appear. how can i do this with Java?
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:
provide me a sample code for dependent drop down lists?I need to create a few drop down lists and they are dependent of each other. Their relations are very complex as 1 drop down list may affect 2 drop down lists.
View Replies View RelatedI have a set of dynamic dependent list boxes that are populted from a database. When I select the first box the second box is populetd with the correct items. If the first item is the desired selection another option has to be selected and then the first item has to be reselected for the list to work properly to update the next dynamic list box. To include the --Select-- in the second and third list box table would add several thousand rows to the table. If I added the --Select-- in the table it would add several thousand rows to the database.
View Replies View Relatedhow to give dependent listboxes in asp code.
View Replies View RelatedI've gotten the dependent drop down boxes to work except, when I fill out the form, and get to where I click the first drop down box and make a selection, the page refreshes and all of the fields turn blank, except for the second drop down box, which displays the correct records based on what was chosen in the first box in the entire form. Also the first drop down box returns to the first record in the list.
View Replies View Relatedi am trying to link list boxes for a mini intranet. I have created a booking database for our staff to add bookings into for a business and it is all based around dates etc. I want people to be able to select the year in the first box and then in the next list select the month and then the date.
Can you give me a sample code on how to link the lists so that they are dependent? i can get single drop down lists just cant link them.
I'm working on a form where if a client makes an entry in one field, it causes another field to become unusable. The fields most likely will be drop-down lists. The form will be filled out online then mailed to me using the post method.
View Replies View RelatedI want to have dependent dynamic dropdown lists where the person can select the state, then county, then zip code, and all 3 of these menus will be populated by a database. I have a page that Ive been working on but I just cant get it. The page I am working on also refreshes when you select the state, then when you select the county it refreshes again but instead of populating the zipcode list it just takes the state name and inserts it into the city menu. Code:
View Replies View Relatedi'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 am working on a survey form. I need to create multiple-multiple dependent istboxes...I need to allow the user to make multiple selection from a categoryListbox and as the user select from categoryListbox must display and add available subcategories into the subCategoryListbox and allow to select multiple subcategoris.
View Replies View Relatedi have three dependent dropdown list.when select city in first box then 2nd list will show all company for selected city. 3rd will show all jobs of co. any suggestion?
View Replies View RelatedI am trying to create a drop down list that I have populated. But what I want to do is to populated the other drop down based on the selection in the first one, I am getting an error when I try to make the selection. here is the error that I recieved
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '='.
/reportrequest/admin/ReportRequest.asp, line 233
and here is my code:
I have a created a cost reporting system which shows a level-breakdown
report. There are three levels in the report the lowest level holds the cost
items that are entered by the user these records also have an Entry Date.
The level above that is a Sum of the lowest level and the top level is the
Sum of the second level. I created the solution using three queries in
Access. I then use the queries in ASP to generate the report. But now I need
to use the Entry Date at the lowest level to re-generate the report with
values from the StartDate to the EntryDate (which is entered by the user).
Question is, can I do this using the construction I use, or do I have to
pull my queries to the ASP code and include the dynamic EntryDate? How do I
solve this?
In our legacy asp/web-application, we have
date/time-input form in USA style
(i.e. mm/dd/yyyy and 12hour-scale time with AM/PM).
There is also some validation code on client side,
and then submitted data are used in MSSQL queries.
Now I would like to know about how to generate locale-dependent
HTML form layout, and what ready-made ASP code could I borrow
for this task.
I would like to have div tag over combo box, not combo box over div tag. I have this problem on many pages usually when I use drop down menus. I try to solve this problem with z-index but it doesn't work. Have anybody some idea? Code:
View Replies View RelatedIf I click the "Update" button on my form below, I can retrieve the value of
my combo by using code in the FORM RESULTS section below. Therefore, if I
choose the "Inside" option in my combo, I would get "1" as the value of my
combo box.
Is there any way to retrieve the Name associated with the value? So not only
retrieve the combo value of 1, but also retrieve the name "Inside" after
submitting my form? Code:
I have a form which enables users to search a database. Currently they can use a series of checkboxes and a text area. I would like to incorporate a combo box in this form. The values would be hard-coded. The user selects an option, which is included in the SQL statement along with those from the other form elements.
I'm not sure how to get the values form the combo box into a variable. There would be up to 40 values. Can anyone show me how to do this?
I'd like to know if any of you guys have found tools to, search in PDFs. create PDFs on the fly. preferly in pure asp, or in pure .net, so no component installing. I searched for it but found nothing good on the matter. I know there are some nice tools to do these things php. So I'd like to know your experiences in these things, cause clients start to ask more and more for PDF functions on their sites.
View Replies View RelatedCurrently I can add/delete records from this form I have on an ASP page. But I can't get images to upload for anything. Here is the crazy part...I also have a Linux webserver for my php sites right.
I'm thinking about doing my image upload function on my linux box and upload it to the windows 2K3 image folder of my we directory. So I cause my question is: 1) Is that possible? 2) Can php talk to my access DB, and 3) Am I crazy? Code:
I've got a combo box with a list of alphanumeric data extracted from database. When i type 'c' the combo box shows a list of items beginning with the letter c. then when i press '8' the combo box shows a list of items beginning with the number 8. But what i want is for the combo box to list items that begin with 'c8'. is it possible?
View Replies View RelatedThis is the code for a combo box, and I would like to make certain value the default value, so that appears unless users select somthing else.
call rs.Open("SELECT * FROM Trim.dbo.luDecisionMaker ORDER BY DecisionMakerName" _
, myCon)
do while not rs.EOF
Response.Write("<OPTION value=" & rs("DecisionMakerID"))
if rs("DecisionMakerID") = nDecisionMaker then
Response.Write(" selected")
end if
Response.Write(">" & _
rs("DecisionMakerName") & "</OPTION>" & Chr(10))
rs.MoveNext
loop
rs.Close
It comes from a table and has PropertyDetailsID(1,2,3,4) and PropertyDetailsname(Fee, 5,10,Other) and for example "Fee" needs to be the dafault value.
I have a search page where i have like 10 combo boxes and some radio buttons and check boxes.
Now when the page loads, i do some selection in the combo boxes and when i press reset button it clears all data in the form elements.
But when i select things in combo boxes and do a search by clicking OK button then the search results are displayed there and now if i want to clear all the form elements , i tried to click reset button, but when ever i did a search ie click ok button and after than press reset button reset button is not clearing the form elements.
Reason for this problem:
Reset button resets the form to it's state when it was loaded (as opposed to clearing the values) so if the page loaded with the search values in it, when you hit Reset nothing will happen if you haven't changed anything. Code:
I want to take a text box that is in a grid and make it a combo box: Here is what the first part of the HTML looks like now:
<input type="text" name="txt_SERVICE_SN"
onkeypress="filterNonNumeric()" size="5" maxlength="3"
style="text-align:right"
onchange="fieldEdited(this.parentNode.parentNode)">
I tried switching the "text" to be "combobox" and that doesn't work.
I saw some other code for other combo boxes (not in the grid) and saw something like this:
<select id="test2"></select>
This will make a combo box. But I don't know why. I can't see anything in there that uniquely identifies this as a combo box.