View Selected Record
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?
View Replies
ADVERTISEMENT
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.
View Replies
View Related
I'm getting this error message: Error Type:
Microsoft JET Database Engine (0x80004005)
You cannot add or change a record because a related record is required in table 'employees'. Code:
View Replies
View Related
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.
View Replies
View Related
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?
View Replies
View Related
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 ?
View Replies
View Related
I have a form named: 'formhandheld' and a select with the name: 'pricing_option'.
I'm trying to make the select <option> thats based on 'axDD3current' selected.
what's the code ? Probably more of a JavaScript question than ASP
document.formhandheld.pricing_option.options[<%=axDD3current%>].selected;
the above doesn't work
View Replies
View Related
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
View Replies
View Related
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.
View Replies
View Related
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)....
View Replies
View Related
By ASP
How can I get the dropdown(control'name)'s selected value?
What is it's property'name
View Replies
View Related
sourinsen is correct. that's the way to split values in your combobox.
View Replies
View Related
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.
View Replies
View Related
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.
View Replies
View Related
i need to get the selected value of dropdown from one page and i want it to be displayed in another page.
For that i used the below cade:
<%= request.Form("country") %>
country - drpdown name
But its not getting displayed.
View Replies
View Related
I am displaying few values in a List box. I would like to put first item as selected by default. i.e <option value="some value" selected>Name</option>
Here is my code.
<SELECT size=15 id=select1 name=select1>
<% do while not Rs.EOF %>
<Option value=<%=Rs("value")%>><%= Rs("Name") %></Option>
<%
Rs.MoveNext
loop
%>
</SELECT>
View Replies
View Related
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:
View Replies
View Related
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.
View Replies
View Related
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?
View Replies
View Related
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.
View Replies
View Related
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?
View Replies
View Related
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.
View Replies
View Related
Can anyone help me to pass selected date from a list box on one page to another using perl and asp?
View Replies
View Related
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.
View Replies
View Related
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.
Is this possible with ASP?
View Replies
View Related
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)?
View Replies
View Related
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.
View Replies
View Related
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 ?
View Replies
View Related
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:
<form name="form">
<select name="menu1" onChange="MM_jumpMenu('parent',this,0)">
<option value="page1.asp" selected>page1</option>
<option value="page2.asp">page2</option>
</select>
<input type="button" name="Button1" value="Go" onClick="MM_jumpMenuGo('menu1','parent',0)">
</form>
View Replies
View Related
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?
View Replies
View Related
what is the best way to highlight menus...as in like being in a particular section? like this:
my menu is database driven and in order for me to show it selected, i have to put something like menuid=12 a querystring.
case.asp?caseid=1323&menuid=12
this is what i'm doing so far but it seems terribly inefficient. does anyone have any suggestions?
View Replies
View Related
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.
Code: .....
View Replies
View Related
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?
View Replies
View Related
