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.
View Replies
ADVERTISEMENT
I am trying to create a page where someone can search an Association directoy by category. The results page should then pull up all the companies that fall under that category and sort the company names alphabetically. The search & results pages are loading, but show no results under all categories. Code:
View Replies
View Related
I have dynamcally populated a drop down menu with data from an access
database using ASP. The values seem fine, however when i pass them to
the next page (using form get method) the whitespaces in the values
are ignored.
For example with <option value=jim jones> then only "jim"
gets passed to the next page not "jim jones". I have viewed the source
created on the dynamic page and the values are populated fine, but
passing to the next page seems to be problematic...
View Replies
View Related
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.
View Replies
View Related
Using preferably Asp or an Asp component, but maybe .NET, here is what I need to do:
A user enters a hex value (Or rgb if need be), which then colors a pixel high, n pixels wide gif and saves it to a folder in the sites directory.
View Replies
View Related
I'm having a problem dynamically creating an UPDATE query that will write the string value of an existing record set field into a data base.To be more concrete, I can generate a string that looks like this:
UPDATE Person SET Person.name='objRS("oldname")'
but when I try to execute it, the literal objRS("oldname")gets written into the oldname field of the Person table, as opposed to the value 'Betty'. (In a separate write statement, I've already checked that objRS("oldname") prints 'Betty'.)
And if I change it to:
UPDATE Person SET Person.name=objRS("oldname")
I get an error saying there is an undefined function 'objRS' in expression. Can anyone help me? If I can get this to work I'll be done with this task.
View Replies
View Related
I have an asp.net application that generates dynamic images (charts). When I run the application in debug mode from visual studio, or refer to the url with localhost in the name, everything works fine. When I try to access the site with the full machine name (not using localhost), or from another machine, the dynamic images only appear as red x's.
I've searched the groups, but can't find anything that seams to relate. I am assuming this is some sort of security setting, which I have messed around with in IIS as
well.
View Replies
View Related
Is it possible to assign permissions on the fly as you are creating a directory structure on the web server?
I want to create a new folder for each new user of this system I built. Each folder will have the same permissions and will be used for uploading images. Should I just have write permissions on the parent folder and have the folder permissions inherited from the parent? Or is there a better way to do it?
View Replies
View Related
I'm using ASP 3.0,IIS and Java script.I have created some text boxes Dynamically using java script.So the text boxes has got the same name. This is the code i'm using for that..
aTable1=document.all('myTableTBody1')
aRow1 = aTable1.insertRow(aTable1.rows.length);
aRow =aRow1
aCell = aRow.insertCell(0);
aCell.align = "Left";
aCell.width = "5%";
aCell.innerHTML = "<input type='text' name='Course' size='20'>";
Problem is that when i'm doing client side validation using javascript its not taking values..Here 2 or 3 or 4 text boxes with the course will be created when i use
this code:
if (document.Qualificationdetails.Course.value == "") {
window.alert ("Enter Course !");
document.Qualificationdetails.Course.focus();
return false;
}
it does not give any validation...
View Replies
View Related
I am trying to create a bookstore WebApplication using c#. I can
display the books (obtained from sql server) on a table in a WebForm.
At the end of each row, I would like to add "add to cart" button.
Therefore, I use
Button bt_add = new Button();
bt_add.Text = "Add to cart";
and put it in a cell which is later placed in each table row. The
Buttons display fine on the WebForm. However, I don't know how to add
the Button_Click function for each of the Button I created since I don't
know the total number of books in advance. Can anyone help me get "add
to cart" button to work?
Note: I try clicking on each Button, the WebForm page loads back to its
original stage (Page_Load function) and my search result is gone.
View Replies
View Related
The code that I have has 2 drop down boxes dd1 (visible) and dd2 (hidden). Based on the option selected in dd1, dd2 should be visible and populate options. I think I can have OnChange script but how could I return the value and put it in the SQL query (see variable in red in thecode)? Code:
View Replies
View Related
I have certain Keywords stored in a table of the Database.All i need is when ever i find the Keyword in the webpage i need to have a link which opens up as a seperate page and give me the detail information from the database for the seleted keyword.
View Replies
View Related
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:
View Replies
View Related
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?
View Replies
View Related
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?
View Replies
View Related
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.
View Replies
View Related
I am somewhat famialiar with ASP.net but I am trying to use ASP. I want to dynamically load drop down lists from an already created MySQL DB. I already have the table build and all the fields, and what not but I can't figure out how to load the values of a drop down list with the records from a column.
View Replies
View Related
I've got three drop down menus which allows the user to select a date on a html form. The day drop down menu has the values 1-31, the month menu has values 1-12 etc etc. However i would like when the page is loaded for the current date to be present as the intially selected value in the menu. How can i apply the selected attribute of the current date.
View Replies
View Related
l've created an Access db with these fields (Title, Body and Section) Section field is Lookup column (About Me, Contact and Links). Also I created a form on add_data.asp to add data from it. On the form there's a Drop Down Menu. The peoblem is how to add from the drop down menu to the database. Here's my code:
View Replies
View Related
we are working with the date of birth and have three drop down menus...my question is in the year because what we want is to make the drop down menu to start in 2006 not in 1906. Code:
<label>Year
<select name="select4">
<%
dim zzzz
dim a
zzzz = year(Date())
for a = CInt(zzzz)-100 to CInt(zzzz)
Response.write("<option value=""" & a & """>" & a & "</option>")
Next
%>
</select>
</label>
View Replies
View Related
I 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.
View Replies
View Related
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?
View Replies
View Related
I want to create two drop down menu. one is for the Main Category and second is for Sub Category. Both value should be come from the database.
when i choose the Main cat. say business then it should load sub cat of business in second drop down menu but is should be done without refreshing the page.
View Replies
View Related
I am trying to generate a dropdown menu form a ms sql database with two columns in it. I need both colums to show in the menu. I can't get it to work for the life of me. Code:
View Replies
View Related
i'm having some difficulty coding my dropdown menu's on a page, i want the contents of one to be dependent upon the value of the selected option of another.
View Replies
View Related
can someone give me an example code for how to retrieve the selected value from a drop down menu in ASP. i have been trying something like this:
<%response.write(request.form("selected"))%>
but it doesn't display anything.
View Replies
View Related
I have a form that I would like to create. My primary concern is 2 drop-down menus. The contents of the second drop down menu depend on the selection of the first drop-down menu.
For example: In the first drop-down menu, I want to select a department, and after a department is selected, I want to be able to select one of that department's employees from the second drop-down menu. Of course the content of the employee menu will depend on which department was selected.
I've been experimenting a little bit with my Access database, but how I design that really depends on suggestions I get here, so let me know what you think.
EDIT: I should also mention that the contents need to be read from the Access database, rather than storing everything in a javascript array. In this way, I can have Human Resources add new departments and employees via a web form so that I don't have to manually edit code every day.
View Replies
View Related
I have an access database called contact.mdb and I have linked to it just fine and used the records held in it to populate a datagrid and can update and delete records.
I don't understand databases that much but I would like to read the values into a drop down menu which are held in the field 'ID' from a table called 'courses'. I have a feeling it is something to do with data sets but am not too hot on these either.
View Replies
View Related
I have created a drop down menu populated from a database. Would this warrant posting?
View Replies
View Related
Below is an extract from a form that i am writing. I need the user to be able to have a drop down menu of languages. How do I use the 'option value' command in ASP like you can do in HTML; so there is a list of languages for one to be selected. If someone could amend my code to give me a couple of language options so I can get an idea of how it is down.
<tr id="r_Lang">
<td class="ewTableHeader"><span>Language<span class='ewmsg'> *</span></span></td>
<td class="ewTableAltRow"><span id="cb_x_Lang">
<input type="text" name="x_Lang" id="x_Lang" size="30" maxlength="25" value="<%= Server.HTMLEncode(x_Lang&"") %>">
</span></td>
</tr>
View Replies
View Related
I am working on an ASP website and my boss wants to have drop downs.
I have taken the existing code of menu includes but am unable to view
the drop downs. it just shows the url (menu.asp) in the browser but
doesnt throw the drop down.
View Replies
View Related
How can I add a quick drop down menu to an asp page? I've tried to incorporate javascript and I can't seem to make it work. I want it to replace the current navigation on this page.
http://www.compsports.com/poll.asp?No=1
View Replies
View Related
I am creating a "search by category" page using a drop down menu. I am very new at SQL/ASP and am having trouble with the correct syntax for sorting my search results.
Each category in drop down has an id ("catid"). Results need to show all Company names that fall under that specific category in alphabetical order. I have already completed a directory that is sorted alphabetically and tried to "borrow" some of that code:
View Replies
View Related
