This code only allows for 1 date from my database to be added. I need to be able to populate it with all matching dates. I'm not to sure on how to do this.
<select name=""select"" size="1">
<option value="date"><%=get_notes("date")%></option>
</select>
I've been pulling my hair out over this. I've been looking at it so long I'm probably just not seeing it. I'm trying to populate a dropdown list based on a user's leagueID contained in a Access database. Here's my code:
View Replies View RelatedWhat is the best method to insert and retrive image to and from the database?
View Replies View RelatedI need to have three list boxes automatically populating each other, (ie
when region is selected from the first listbox, it will populate
automatically the second one which is the TOWNS and when the town is
selected is should populate the third one AREA) all data is in the database
in one table.
i have a form with fields that contain data from a db. the fields can then be edited, and on the click of the "submit" button, the updated information is returned to the database, replacing the old. a bonus would be arrow buttons allowing navigation from one record to the next, with the information populating the form each time. i'm having a hard time with this.
View Replies View RelatedI am designing a questionaire for my partner for her uni degree, I have done the form, created the database and written the add.asp script so the form data can be added to the database.
When you enter the data and send it, it works and even goes to the thanks.asp page. HOWEVER, when i check the database, the script has created a new autonumber for the new submission but has not filled in any of the data from the form.
I have included the add script below, the database field names match up to. Code:
It gives me a blank dropdown when there are values in the Currency Table and
it also does not display any form element that I place after this code.
<select size="1" name="Currency" >
<%
SQL = "Select CurrSymbol FROM Currency "
SET RS = CONN_STRING.Execute(SQL)
While NOT RS.EOF%>
<option value="<%=RS("CurrSymbol")%>"><%=RS("CurrSymbol")%></option>
<%
RS.MoveNext
WEND
Set RS = NOTHING
%>
</select>
I'm trying to display thousands of people's names so a user can pick
one. Is a dropdown the best way to do this? Is there a better way? I've
never had to deal with that many names, so I don't know how it will affect
performance.
I am trying to list a database (SQL) i a dropdown list but I just cant get it to work... I am writing in ASP. This is some of the code:
mySQL="SELECT ras.raser FROM ras ORDER by raser"
<tr>
<td width="220">Raser</select></td>
<td width="342" height="23">
<select name="idRas">
<%do while not rstemp.eof
pRaser= rstemp("raser")
%>
<option value='??????????' </option>
</select>
</td>
</tr>
I have a dropdown menu (HTML's form->select) i have options in it, and I need as soon as one of the options is chosen (onChange)to update my database's (mdb) field
like this:
mdbVar("some_field")=1
mdbVar.update
that simple, but i cant figureout how to connect the onChange to this code.
An HTML page that have two dropdown list whit different values:
1. Dropdown list 1(tblname1) =values with different location's. After user
has selected one value from the dropdown it should show values from
(tblname2) in the dropdown list2.
2. When user select an value from dropdown list2(tblname2) and click on a
button "GO" it should show all the value's from the database that been
selected in dropdown list1 and 2.
Please someone please help me out with this problem!?
I have two columns in my microsoft access database.
1st column is company_logo (jpg image)
2nd column is company_name (text)
I want to build a form, a dropdown box which I would populate with the help of a sql statement from my database. The both columns from up there are associated.
When the user clicks on that dropdown box, I need that company_logo and company_name to be shown one beside another. It should list all the companies availible (taken from that sql statement or recordset).
Does anyone knows if this could be done?
Maybe I should stick just with the textual part?
how to show a drop down list with a selected value that is derived from the database? Is this correct? When I do this, it shows "Mastercard" always, even when its "Visa" in the database.
<select name="ccType">
<option value="Visa" selected="<%=rs("cardtype")%>" >Visa
<option value="Mastercard" selected="<%=rs("cardtype")%>">MasterCard
</select>
I am creating one web page which contain a drop down list. It use the data from database. Now my problem is when the user select the drop down list value, I want the current selected value update to the database. How to write the code?
View Replies View RelatedI have a category that I will call "company". in my access DB, there are about 6 or so companies. On another table, I have a list of locations that are related to these companies.
What I want to do, is have a drop down menu that lists all the companies. When you select the company, the second drop down menu will automatically populate with the locations of the company you selected in the first dropdown.
Anyone know any links to some examples of this? My google searches have been pretty fruitless since Im having a bit of a problem trying to explain it concisely (as you probably noticed).
I have two recordsets that I want to populate within an array.
The array will always have two columns, but the number of rows is unknown (sometimes 2 rows other times 200 rows). I'm not too familiar working with arrays.
I want populate the array using a loop. How would I define and populate the array within loop so that I don't lose values and each new set of values are populated into the array through each iteration of the loop? Code:
I need to dynamicaly create my javascript as the page loads because as persons add items I need to increase my layers based upon the number of records returned from a recordset. Code:
View Replies View RelatedCan someone point to an example where dynamic drop-downs are populated? I would like to execute a sql statment and populate the items in dropdownbox1. I would also like to retrieve all possible values for dropdownbox2 and use Javascript to build an array that holds these values.
Then, I would like to scroll thru the array to select the correct values for dropdownbox2 based in the selection made in dropdownbox1. At last I would like to save the selected values for dropdownbox1 and dropdownbox2 to the database. I would appreciate very much if someone can give me code examples for each of the things listed above.
I'm orking on an online Catalogue, users are to select from a dropdown menu the finish they wish there goods in. The way I was thinking of doing this is have the finishes availiable stored in a column in the database - lets say 'finish' and the column would contain the finishes seperated by commas.. like red,blue,green,yellow etc, so the pull down menu would need to dynamically populate with these values.. is there an easy way of doing this, or am I going about it the wrong way?
View Replies View RelatedI am populating the few fields values from one of the table. I put series of checkbox having same name but have a different value ( value of checkbox is small int, an autoincrement field of table).
I have to take action against the selection of checkboxes. If the user check one of the checkboxes and select "Approved the things " then the USER will move to some else page and the selection will Approve.
On the contrary, if the user opt delete the things then user move to other page and record will be delete from the table.
Now my problems is...
1) how can I know which checkbox user selected ?
2) Are there someway to get the value of checkbox without making form ?
i am trying to create a drop down with information from a db. i am clueless as to what to do.
View Replies View RelatedI am trying to populate a drop down so that it shows the current date, plus the previous 6 days. Here is some pseudocode. I can't get it to work from here.
<SELECT name=Date>
<%
Dim d
d = Date()
for i=1 to 7
%>
<option><%=d-i%></option>
<% end for %>
</SELECT>
I have a check box, when selected it needs to trigger "something" to populate two drop down lists with default values. I haven't done this before, so I was hoping to see if somebody had a good example willing to share.
I was doing a research now and realized that I also need to mention it needs to populate values straight away not on the submission.
I need to populate a dropdownlistfrom a form and fill it with the numbers from 1 -1000. Obviouly, this would take a considerable amount of time doing it manually so how does one go about populating this list from an array of some sort?
These entries will be stored in a database so would it be better to just populate this form from a database? After mentioning the above situation(s)... (a)How do you fill the dropdownlist from an array? (b) How do you fill the dropdownlist from database explained in it most simplest form?
Is there a way to grab a password entered into a login page, and have it populate a field in my table?
View Replies View RelatedI have a recordset full of a list of courses.I want to create a search page, where the user can select the course from a drop down box, hit go and be taken to a page on that course. But some courses have 3 versions of that course, so for example I have 3 IT courses. so in the list it says
IT
IT
IT
How can I limit this to just display the value once in the drop down?
I am trying to make a page to display a comparison chart. say we have 15-30 products... these products are all similar and we would like to compare them to each other
I would like to have an image (or whatever) of each product and then a check box next to each one. Below the products is a table (with say... 5 columns) with all of the attibutes of the products (this table is EMPTY otherwise)
when the user checks the check box.. the first empty column populates with the info (from a file??) and the user can continue checking boxes until the 5 columns are populated, or the user can uncheck and have the column unpopulate
i have a LITTLE (very little) asp.net exp. but i understand the concept (same with SQL) and plenty of HTML and such... can someone help me put somthing like this together?
I want to populate my ASP page consisting of some form fields as follows.
As the user enters data into the first field. That value is used by say a javascript routine triggered by "onblur" to fetch values from a oracle database and populate rest for the form fields in the ASP page.
Can this be done?
i have several radio buttons and a combobox. i want to know how to make this combobox enabled only once a radio button is checked and populate it with data from access database depending on which button is checked.
View Replies View RelatedI am having some problems populating a drop down menu called province with data.
This is the error I am receving:
ADODB.Recordset error '800a0cc1'
Item cannot be found in the collection corresponding to the requested name or ordinal.
/fairmont/order.asp, line 85
I am sure there is data in the DB. I have attached the file.
I managed to import Microsoft Word table structure into my code, but the problem I'm having is that the field are not being populated. Code:
View Replies View RelatedI have an access database with about 5 tables. One of which i want to populate data to. Specially 1000 enties at one time(In this example im adding employee numbers to a database table. Initially i want to add the for the employee name field " Unassigned" and when i ready to append a real employee name to the fields add if through a script(Can this be done?
Or is there a better way to do this?)This way, in my script i can call one of of those 1000 entries or employee numbers from a dropdowlist (ex. 1-1000). This way if go to use one of those entries from the dropdownlist the database would not get the " EOF/BOF error ". What logical suggestions do you guys have ?
im looking at populating a drop down box with database values when a user selects a value from another drop down box.I have a drop down list that populates from database values, it is a list of manufactures. When a user selects a manufacture i want it to display all the systems for that manufacture which will be stored in a table. I understand that because asp is server side that once an option is selected the page would have to submit and then load the values in.
View Replies View Related