I have a page that is showing X number of records. I have a column with a check box in front of each record. I would like the user to be able to select certain records by selecting the check box in front of the record and then have the user hit "Submit." They will then be taken to another page in which only the selected records are shown.
I'm having trouble with my SQL statement. I'm not quite sure how to word my SQL statement since I do not have a field in my recordset that points to the value in the checkbox.
In other words, I'm not sure how to carry the value of the checkbox over into my SQL statement when I don't have a field for it. Do I need to add a field, and then update the field on a confirmation page before I use a SQL statement to show me the selected records?
I want to add record in my form. Previously i can only add 1 record and click on Add button to add 2nd record. Is it possible for me to directly add 2nd record? So i will have 2 options here, view the list and add 2nd record or directly add 2nd record.
Drop down value is selected and a query is performed on that value - I want the selected value to stay in the drop down field. Right now it goes back to the first value in the list once the submit button is clicked (it queries correctly).
When I come into the page there should be no value in the drop down list and when a value is selected it should stay in the field.
I have an insert record form that posts fine to a db which automatically creates an ID how could I get the next page to do a preview using the ID just created by the DB to go to the right record?
I have a .asp page which lists a date, then a bunch of record lines for data that falls within that date, then the next date and it's bunch of data record lines. e.g.
Ship Date: 04/06/04
Data xxxxxxxxxxxxxxxxxxxxx Data xxxxxxxxxxxxxxxxxxxxx Data xxxxxxxxxxxxxxxxxxxxx Data xxxxxxxxxxxxxxxxxxxxx
Ship Date: 11/07/04
Data xxxxxxxxxxxxxxxxxxxxx Data xxxxxxxxxxxxxxxxxxxxx Data xxxxxxxxxxxxxxxxxxxxx
What I want is:
Ship Date: 04/06/04
1: Data xxxxxxxxxxxxxxxxxxxxx 2: Data xxxxxxxxxxxxxxxxxxxxx 3: Data xxxxxxxxxxxxxxxxxxxxx 4: Data xxxxxxxxxxxxxxxxxxxxx
Ship Date: 11/07/04
1: Data xxxxxxxxxxxxxxxxxxxxx 2: Data xxxxxxxxxxxxxxxxxxxxx 3: Data xxxxxxxxxxxxxxxxxxxxx
How can I get these numbers printed againsts the records ?
I have 2 drop down lists here. Supposingly, upon the selection of the 2nd drop down list, I should be able to see textbox entry allowing user to update data being displayed at the bottom. But in my case here, i see no response upon the selection of "selType" which is my second drop down list. But both also don't work. So any suggestion on how can I retrieve the 2nd drop down list' selected value
I have combobox that those value is based on my database. So i want to get the selected value in order to do another matching for the SQL statement. May i know how to get it? Is it just use for example WHERE column=' "&combobox&" '? use the combobox name.
I have an aspx file where i've put a placeholder element. On load i create dynamically a table which contains a checkbox and a radiobuttonlist in each tablerow . The radiobuttonlist contains two items (yes,no). Both the checkboxes and the radiobuttonlist are NOT autopostbacked ( .autopostback = false).
When i press the submit button a sub is run. My problem is that i can not get the selected items in the radiobuttonlists.This is caused cos in the page_load i call the sub that dinamically recreates the table described above and so all values are reset (there is a rdb.item(0).selected=true line in my code.
If i try to remove it, the radiobuttons keep their values or not,after each submit, without a pattern!). I've also tried to keep the values in a collection, instasiated in the page_load but i couldn't do so cos the table (that contains the checkboxes and radiobuttonlists) is not recognized at the beggining of the page_load (i guess it's not an object yet cos the sub that creates all that is at the end of page_load)....
I have a drop down select box that gets filled from database. I have to add "All" to this list which does not come from database. Also the default selected value should be the second value that is stored in array. For ex I have array of Countries names as America, Indonesia,china, Canada. My array gives me the value Myarray(intcount,0)(intcount,1) as America and so on (two dimensional array).
I want Indonesia as the default selected value when the page loads. Also I need to hardcode All at the end. Upn submitting the form the selected value fromthe drop down should get selected.
I've got this listbox and this text field on an ASP page. Now I want the item I click on in the listbox to appear in the text field and I can't find the code nowhere for what seems to me such an easy thing to do.
I have an asp-page where I want the user to make a selection with a listbox. When the user changes to another listboxelement the page gets reloaded and depending on the selection a different content is shown.
I got this working so far but when the page has been reloaded the listbox always displayes the first selection in the list and not the one which the user selected. Code:
I've got IIS installed and running on Win 2000 Professional. However it seems that I cannot view asp code. To test I've used the good old "Hello world" example. When run through localhost I'm met with page cannot be displayed. When run through c:inetpubwwwroot, I'm met with a blank page yet I can view the text in HTML. I've checked my properties for home directory and I've got TCP port 80, execute permissions as script only and application protection as medium(pooled). The local path address is correct and its set to Read, Log visits and Index this resource.
I have different templates for different companies to be sent to the customer. first i get all the templates from the DB by giving: Select templates from tempates;
Now i want the user to select one..may be we can have a radio button displayed near the textarea in which i will be displaying the templates from DB. Once the agent selects one of the templates to be sent,that template should be sent as an email to the customer.
How do i go on achieving this ,with good formatted template in the DB?
I have a requirement where I need to have windows authentication enabled for only few ASP pages of my Site (Virtual Directory), rest of the pages should be enabled for anonymous access (No Authentication Dialog). Could some body guide in achieving solution for this.
Flow Steps
1. User visits the home page (One.asp page) No NT authentication dialog should appear.
2. The home page will have some Hyper links to other pages, on clicking on the Hyperlink it should prompt for NT Authentication Dialog (asking windows UserID and Password)
3. Once the UserID is validated by authentication process it should show the Target ASP (Two.asp) Page. The Target Page will have a link Named 'Back' which will redirect the User to 'One.asp'
4.Once user is redirected from Two.asp, if user clicks the Hyper Link it should prompt again for the authentication (Previous login information should be discarded, it should prompt again)
The Challenge i face is 1. Finding a solution to implement authentication for selected pages. 2. Logging off the User so that to Prompt the NT authentication dialog again.
I have a form with some textfields & checkboxes.One of the text field allows the user to select a file.When the user submits a form , I am inserting all textbox and checkbox values in a database.But, while performing insert I also want to upload the selected file on web server.Does any one know how to do that?
I have a Multi select box which I have populated with a list of choices. Is it possible to have a second Multi select box which is initially empty, yet when the user selects values from the first Multi Select box, they appear in the second multi select box? I'm sure I can easily do this by just posting the selection to a new page but I'd like to dynamically display the selected values on the same page.
I have a dropdown menu with parents' names, and on the same page when a name is selected (through an onChange event), another drop dpwn boix containing student names change according to the parent selected.
But I want the Parent drop down box to contain the parent's name who was selected, and although the event works, it just keeps displaying the first name of the list of parents even after a different parent is selected.
I have a list box with a number of values (4) on a ASP form, the value is stored in a database field.
When a form to amend the record is loaded, I would like to display the list box with the currently held value as the seleceted item in the list box. e.g.
4 items in listbox A B C D
B selected and saved.
Amendment form displayed, List box contains A B C D, with B highlighted.
From a PHP background I could use mysql_num_rows() to get the number of selected rows from a SQL query. Looking through Google I can't see a way to do this with ASP.
One place I looked said you need to loop through all the selected fields and using an incrementing counter, which doesn't sound like a good idea :/
If this is the case (which I hope it isn't), is there any way like PHP which you can then tell the SQL object to go back to the begining so you can reloop it (if you catch my drift)?
My site is a golf site where the players post in there own scores, a season consists of 6 weeks, each week earnings are given to all players depending where they finish.
I need to display the earnings for the season, (week 1 -6) added up and in the right order, what seems to be happening is the earnings are added up ok, just the positions are all wrong, ie if I go to ?seasonid=2&eventid=8 i display the total earnings for season 2 (event 7 - event 12) but in the finishing order for event 8. ORDER BY is working for current week, so dont think its that, I zipped up the code.
I have a simple form and want to submit a selected value of a combo box. so my combo box is named "selectname" and my form has action="file.asp?" what do I have to put after the question mark ?
how would I go about setting the <selected> attribute of a jump menu to one representing the current page? background info: i have a template-based site employing a jump menu as the navigation, but for usability's sake it needs to not reset back to the first option in the menu, but rather hang on to the current page as the 'selected' option. example of similar HTML showing the hard-coded 'selected' option I need to change: Code:
I have two date fields and i have in each one a calendar. I want these dates to be validated. They both should not be prior to the todays date and date 2 not to be prior to the date1. How can i do this people?
I have a registered user that buys a product online. The user supplies his/her email during the order also for verification purposes.
What I want to do as an Administrator is to be able to see that users first name and surname on my "Completed Orders" page (which dynamically refreshed every time a new order is made) using the email to get them from the database.
i had created an asp file and want to upload it to the server...however, when i uploaded the file..the file cannot be viewed through internet...why?do i need to set anything at the server?
