ASP/javascript with a drop down populated by an access database. The drop down works fine but I cant figure out how to get it to change a value of a text field.
I want the value in the text field to change to reflect the data in another column in the table, same row. Code:
I have a menu box with dynamic values from a recordset (value = 'Size' column)
I then have a textbox for which I want to display the 'Price' column according to the record selected in the menu box.
What I would like to happen on this page is that when a user selects a company name from a drop down list, his selection autopopulates the cID field based on the selection. The drop down list is getting its choices from the customer table.
As I am still a novice, I am sure there is a way to do it I have not been able to get it right. Code:
I have a survey/member form that gathers information. I would like to have a drop down list on a page that a user selects, either 1, 2 or 3.If 2 or 3 I would like to show on the form another field for information gathering ie:if a user has 1 cat, fields for cat name, sex & age show.
if a user has 2 cats, 2 fields show instead of one for each, and the same
for 3.....
I am working on a small application for senior users, so I want to limit the option for incorrect input whatsoever. I have a drop down box that is populated from a query and I want to make it so that when an option is selected, the pertinent text fields are populated based on the selection.
All the info I need is already being extracted from the query so its just a matter of displaying the right info based on the selection. I have been looking for examples of code but they all seem to use javascript. I am not too strong in javascript so I kinda avoided those. if there is a pure asp example, that would be fine!
I writing an asp application that uses three listboxes. the first one lists departments ids the second list box populates either users or supervisors based on which button is pressed ( users button and supervisors button).
If a user is selected from the list the submit button redirects to page1.asp. if a supervisor is selected the same submit button redirects to page2.asp My question is how can I submit the form without using more than one submit button.
I would like to be able to setup a link on my page that will change in value depending on the index # in the listbox that is selected. Here is the code i have for the link:
<a href="editproduct.asp?Action=Edit&id=<%=Request("id")%>&cat=??????"> List It </a>
I would like it to be - cat=(list index that is selected)
I need to have my ASP form "post" action=? pass to a different confirmation page based on a radio button selection on the form, after submit.
Depending on which radio button they click on, they will receive the same confirmation but then be redirected to a selection specific page, based on the radio button selection. I'm assuming I need to create several different action pages, each with a different redirect, then have the radio button determine which action page the form is directed to based on the radio button selection.
I've tried several different options, such as creating a variable on the form, sDirectionVar, with redirect conditions, but I don't know how to call that on submit? I'm not sure I'm even going in the right direction.
We have a web site IIS 5 (on Win2000k) with Oracle 9i backend (Sun unix).
There is 1 user ID to oracle(APT_W3) that is used by all users (50).
We have a global.asa file that has one APP Start connection string using OLE
DB:
Application("dbConnString")="Provider=MSDAORA.1;Password='SDERSD';User
ID=APT_W3;Data Source=CCEWSDD1_new;Locale Identifier=1033;OLE DB services=-1"
The first page that a user sees asks that they select the area they want to
see (western, northern, etc) from a dropdown menu. Once they select it and
hit save they can go to other pages, session varibles indicating what area
they selected are then passed to pages. Currently all areas are in one
database.
What we want to do is have areas in separate dbs, a northern one, a western
one.etc. Each will have separate user ids (APT_W2N, APT_W3W,etc).
We want the users to have the web page presented to them where they select an
area. Based on the area they select, the appropriate conneciton string will
be used (the one in the global asa). Code:
I want to have two pull down menus, 1 for continents and the other for
countries. On selecting the continent how can I change the menu of another
pulldown or how to display the list of corresponding countries in that. And if no continent is selected then nothing should appear in countries pulldown.
I can use to rotate images based on the date. I have a number of logo images that I want to appear in the same location of my web page. However, I want to determine which one is "active/viewable" depending on the date. I'm somewhat of a noob although I know how to manipulate canned scripts to get them to work. Any scripts out there that do such a thing?
View Replies View RelatedI have 2 drop down menus with data populated dynamically from a database.
Category
Subcategory
If i select an appropriate category the subcategory should change instantly to show the subcategories relating to the selected category. But i can't use a form submit, because before the forms are other textboxes with other values that i don't want to wipe on a page refresh.
I need to somehow preload the categories and their related subcategories. I've been trawling through examples, most are harcoded combobox values which won't work for me.
I have a series of tables, within one database, which each hold unique information, all of which relates to one main table.
I would like to have 4 DropDownMenu's populate themselves based upon the choice of the previous menu.
Example.
Menu A contains four names - John, Henry, Larry, Ed.
When user selects Henry from Menu A, Menu B will show the following choices - Bread, Peanuts, Pickles, Chips.
When user selects Chips from Menu B, Menu C will show the following - BBQ, Ranch, Plain.
When user selects Plain from Menu C, Menu D will show the following - 1 oz., 5 oz., 8 oz.
All of those fields relate to individual tables that all contain a relationship to the main table. Is there a particular way in which I can populate multiple tables based upon the preceeding menu?
Let's say I have a dynamic list/menu, which gets its values from a
database table, for example a list of contact people where the value is
an ID number and the label is the name. However, if the value the user
wants is not in the list I would like to place a hyperlink which
will...
(1) open a small window, with an ASP form to allow the user to add a
new entry
(2) save the entry to the database
(3) add that value to the list/menu in the parent window and make it
the selected option
(4) close the small window and return to the original window.
I can handle the code for 1,2 and 4, but 3 is what I'm not sure about.
I don't like the idea of forcing the user to leave the current screen,
go to some other form, add the entry they need to the lookup table,
then come back; this seems like a logical approach, but just wondering
how to make it work.
This seems like a common enough situation; anyone have any code samples
or suggestions about how to do this?
Is it possible (and if so, how?) to have an asp form page that based upon a user's selection on a field, would generate a input field b that the user selects?
For example:
User selects "name" in a select statement which would list the possible names to select from or if the user selects "telephone" in the same select statement then it would list the possible telephone numbers to select from.
Or simpler:
If user selects A then show P to select from or
if user selects B then show Z to select from.
I have a design form where a user can select a quantity, layout and color of the text they would like on their business cards. When a user selects the ink color, I would like the font color to change when it displays the preview of the card.
Attached is the sample code. The response.write is probably incorrect. I have the information writing to the table that displays the users input and would like the text to show up in the preview with the color that the chose from the drop-down menu. Code:
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.
I have a input form with 5 fields. One of the fields is MajorNo and the other is named Description.
I have a reference table in my MS Access database (tblMajor)that lists the major numbers and their descriptions.
I would like to have the description field in my ASP automatically filled based on the major number entered on the form, so the user will only need to input the major number when submitting to the Access table (tblSalesTotal).
have form on asp page with an email address field, when the user enters
their email address I want it to populate another field automatically on the
same page, some kind of OnBlur event. Have worked extensively with dropdown
OnChange events but cant get my head around this one.
I have being working with making an edit field over the past few days. The edit function is now working fine. The edit fields that i have are for id, subject, notes, timedate.
All of the edit screens are one line text screens. What I want to do now is increase the size of the notes box to a larger textarea type box to make it easier to edit notes. The notes field in the db is a textarea field. Code:
I've been searching for an answer to this for quite some time now and have found nothing, so maybe (hopefully) someone out there will be able to help me.
At my work, we have a lot of folders for different jobs we've done. And right now, we have more than one person making the folders for all the new jobs that we get. I am trying to make a database were it will only show the jobs that have not had folders made. In order to do this, I've created a field titled "Initials". I want the webpage to pull up all the records where the Initials field is empty, but I'm having trouble doing that. I've tried a few different things and have found no success.
I'm not having a problem accesses the database or updating it, just displaying the right information. I'll give a little illustration (because I'm never good with words):
Say I have 3 jobs: Job #1, Job #2, and Job #3. Someone has already made job folders for Job #1, but Job #2 and Job #3 still need to be made. Since Job #1 has been made, that means there are initials in the initials field of the database and thus, I do not want that Job being displayed on the "To Be Made" page. Job #2 and Job #3 do not have initials in the initials field and as such, I want to display those jobs....
How does one return records in a recordset based on a time/date field. If todays date is 8/25/04, how could i return all those records from 8/25/04. Mind you, i have long date format ex. "8/25/2004 4:46:45 pm"
I dont want to user a form for this i simply just want these time- sensative records to be returned in the recordset .
I have an access db called boards and a table in it called notes. I have 3 fields in the table ID, subject, and notes. I have code to search the db and display the results in the notes field.. This code works very well. I wanted to modify this code so that I can use a dropdown menu instead of type in the search field but i cannot get the dropdown menu code to display the search results. Code:
View Replies View RelatedIn my db, I have a date field wich as the format yyyy-mm-dd but when I receive the value from the DB, I'd like to change it to dd-mm-yyyy... How can I do this?
View Replies View RelatedDropdown has three choices. If the third is chosen, the next field needs to be hidden. is there an ASP version of a show/hide script?
View Replies View Relatedmy question is regarding using ASP to loop through the results of a sql query and calculate a monthly total based on a date field.
I am using the following query to total the number of train rides for a given branch by day type (weekday, Sat., Sun.) and create a 3 month rolling avg. (to diminish large fluctuations in the data). I am using Oracle 9i to store the data.
Please see below for the database query, the query output, and the desired output using ASP to sum the rides for each month. Code:
I am using dreamweaver to make an ASP page. I have a table of data
from a MSSQL database that is currently showing on the ASP page. I
want the ability to change the color based on a priority number that's
in the MSSQL database (same recordset that the data comes from).
I
don't have the priority field out on the page but can put it out if
need be. I have 3 different priority numbers and if the first row is
priority 1 I want the font to be red and if the second row is priority
2 I want the color to be yellow and so on.
I have an asp page that displays informaton from an Access database. I want to create a form that allows users to display only data that matches their search criteria.
I have made many forms like this in Front Page with the Database results wizard, but I want to manually code it. Code:
Anyone know how to create a drop down menu where the user can enter text
also?
If they do not want to choose an answer from the drop down menu, the
users can just enter their own answers in the drop down box. Anyone
know if this is possible?
I have a combo which has 2 values.I want when its value is changed then its value should be display in a text box.
View Replies View RelatedI would like to know if I can change the text value of an item in javascript ie:
<script language='javascript'>
function restore_BG(the_Id) {
if (the_Id == 'Arts') {
document.getElementById(the_Id).??? //what code needs to be here to change 'Hallo' to 'Bye' for eg.
}
}
</script>
<tr onmouseover="javascript:restore_BG('Arts')">Hallo</tr>
I have a access database that has data where the people entered their name all in upper case or in various forms of upper and lower case. Can a change all the data so it is in a proper format. Example: This is Joe Smoe. Or change it to be all lower case for email addresses?
View Replies View RelatedI have 10 text boxes... first 5 text boxes e visible , rest of the 5 are hidden... once i clicked the button , the hidden boxes should be visble.. can anyone help me hpw to write script?
View Replies View Related