Selection List/Asp Question
I have a selection list of the 50 states that is not dynamically built. If &state=CA is in the query string i want the selection list to automatically select CA out of the selection list since that is what was in the querystring. Know what I mean?
View Replies
ADVERTISEMENT
I have a dropdown list where u can add students name inside the listbox. As u can see there is a "Please select one" option in the dropdown list also. When i click on the option, it will be added into the listbox also. Can someone pls help me to solve this in JavaScript. My attachment.
if (document.teamForm.newMember.value == "-- Please Select One --")
{
alert ("You can not select this option.")
teamForm.newMember.focus();
return false;
}
View Replies
View Related
I have a list box that allows users to search an SQL database on ZIP, Name and so on
After the submit the List Box selection always goes back to the defaut selection.
I figured by writing the current selected item to a cookie prior to the submit I could recall it upon reload.
Does anybody know how to set default selected item for a list box? Am I going about this the right way? The more I research it seems dynamically creating the list box is the way t go
View Replies
View Related
Here is my situation, I have an ASP page with 2 list boxes. The first list box displays people that are available to be selected. The other list box shows the people who have been selected. This makes it easy to see who has been selected and who has not been selected since if you are in one list box you will not be in the other.
I know how to write the SQL to get the data for each list box but my problem is getting this to work without having to reload the whole page (I thought I could just re-run each list boxes' SQL and display the results instead of having to load the page again).
Write now I was thinking each list box would have an OnClick or OnChange JavaScript event. I would then have 1 table with all People in it and a second table of people who were selected. When the user clicked on the list box of available people (not selected) I need to run an ASP insert script and then requery both list boxes to pick up the change. In the case a user was removed from the selected list box, I need to run a Delete ASP script.
My problem is that I can do this if I reload the page every time a person is selected from a list but there has to be a way this can be done without reloading the page. Do you have any ideas or suggestions?
View Replies
View Related
I working on an ASP page that has a drop down list that gets its contents from a SQL table.
Can anyone show me how to use the selected item from the drop down list and use it as a parameter in calling SQL stored procedure (this procedure simply updates a table so there are no result sets).
I have designed my page to include a submit button and was wondering if it is possible to call the procedure as soon as the submit button is clicked. I get really confused with whether to use a server side or client side script.
View Replies
View Related
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.
View Replies
View Related
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:
View Replies
View Related
how do i get a value from a combo box and populate a list box base on the selected value from a combo box? If possible can i get a sample coding.
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 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.....
View Replies
View Related
How can i list out all the email address into my website from the hotmail caontact list? i am successful log in into the yahoo contact list by using serverxmlhttp and list out all the email address from the page source, but i could not access to hotmail by using the serverxmlhttp. Is any other methos can list out the email address from hotmail contact list?
View Replies
View Related
i want to do a voting, which let user select. how can i count the number of user vote?
n... how can i accumulate each slection and display a chart by percent?
example:
.apple
.beer
View Replies
View Related
I have a web page where a user can select a location out of a possibility of 5. I also give them the option of seraching all 5.
However when I put this in it get rids of the drop down box and puts them all in an open box about 2 inches in length. Which isn't too bad but if I say had 20 locations it would take up half the page.
View Replies
View Related
I have a form field called Streets that contains 'HIGH STREET,MAIN STREET'
I have a field in my access db called StreetName a single record would contain one street and I want to return all records that have a StreetName in the Streets field. How would I go about this?
View Replies
View Related
I do not write the whole code.
I have a IF statement like the following.
if request.Form("UyeTipi") = 1 then
strsql=select ****
else if request.Form("UyeTipi") = 2 then
strsql2=select *****
this is the recordset
set objRecordset = objConnection.Execute(strSql)
With loop I want to display data either from "strsql1" or "strsql2"
I create table like the following with loop
Code:
View Replies
View Related
I am working in an asp/Vb script environment.In a form I have 2 combo boxes.first is main criteria and second one is sub criteria.in the first combo I have made predefined enteris(the headers of the table)say a table is:emp and its headers are:empid,empname,L1manager,accounts,location etc.
on a change event of first combo,I want to fetch the details from the table.say if I selected Ename in first combo.the second combo should automatically fetch the listed Enames and vice versa.
View Replies
View Related
My left frame contains a combo box which loads the selected record in the main frame.The combo box retrieves concatenated 3 columns from my db. E.g. ID, Firstname & Surname.
Because of this, it seems to blow out the size of the frame,thus ruining my nav system.Does anyone know how I can restrict the box width, but allow the drop down part to remain wide?
View Replies
View Related
How do i select a completly random record from a database?
sql = select (random) from tbl, sort of thing.
View Replies
View Related
I have searched through a lot of paging articles. But I have not found any specific recommendations for my issue. I have a large record set that I need to page through (1000 records). But on each page (100 records) I must be able to select some rows, add
some comment for each and sumarize them on-the fly.
if I page forward and backward, I still need to see before selected rows with comments and I can even deselect or edit some of them. Should I store all this information (selection, comment, price) in session variables or is there a better way?
View Replies
View Related
I am working in an asp/Vb script environment. In a form I have 2 combo boxes. first is main criteria and second one is sub criteria. in the first combo I have made predefined enteris(the headers of the table) say a table is:emp and its headers are:empid,empname,L1manager,accounts,location etc.
on a change event of first combo,I want to fetch the details from the table. say if I selected Ename in first combo. the second combo should automatically fetch the listed Enames and vice versa.
View Replies
View Related
My site is running on IIS5.0 hosted on win2k service pack 4 m/c. We are going to procure high end windows M/C . I seek your advice in selecting right os and version of IIS. My comp is a bit hesitant to migrate to .net too (I don’t know planning of comp in future).My requirement should be
1) Same Program should run on new server with minimum changes.
2) If required we can migrate to .net (although planning is not in near future and I even don’t know what is needed for that)
Your advice in this regard is highly appreciated. Also if you can explain in short about new feature in IIS6.0 (or upper version). Which version of IIS come along with Windows 2003 server, I really have very little knowledge in this field.
View Replies
View Related
i am using frontpage ,ASP, and some javascript. how do you create a START-> ALL PROGRAMS selection option. you place the mouse over the "all programs" and you got all selection related to "all programs"
i want to do the same thing with data from a database. how do i do this?
View Replies
View Related
I have this code the value thats stored in table is Yes in College_Assistance field
so i want to select the Yes radio button
but its not selecting
when i see he view source it doesnt say checked="true"
any idea why. Code:
View Replies
View Related
Has anyone used the UPS e-tools such as address verification and rate selection service? I'm trying to implement it on our site and I would just about kill to see some source code. It's a little above my coding level and I just can't seem to figure it out.
The documentation goes into a VB sample, but I dont think that is necessary since you can perform an HTTP POST and parse XML in an ASP page.
View Replies
View Related
I am trying to show some stats. However I have four levels to choose from, which are shown as true/false. I want to count each entry by employee and categorize it only under the highest level achieved. One entry can have multiply Levels. Hope this make sense my mind is a little foggy today.
Here is the sql statement I am using. I have added the levels as or however I want to count each level but only the highest level achived. I don't know if it would be easier to do this in a SQL statement or in vb script. Code:
View Replies
View Related
I have 4 radio buttons
<input type="radio" name="One" value="One" checked
One
<input type="radio" name="Two" value="two"
Two
<input type="radio" name="Three" value="Three"
Three
<input type="radio" name="Fout" value="Four" >
Four
How do i remember wich one was selected when the page is posted back.Meaning having all options back with the selected one being checked.
View Replies
View Related
I have a webpage where there are two drop down menues. From each of them, one item can be selected. I need code to test if there was an item selected from both the drop down menus. How do I do this? Do use ASP or HTML?
View Replies
View Related
I have the following drop down menu on a html page and when submitting
i would like to call out on asp what someone has selected.
<select size="1" name="type">
<option value="Prospect">Prospect</option>
<option value="Suspect">Suspect</option>
<option value="Qualified">Qualified</option>
<option value="Proposed">Proposed</option>
<option value="Closed">Closed</option>
<option value="Lost">Lost</option>
</select></b></p>
I also have regular fields on the html page which works great when
submitting but for some reason i can't get the dropdown selection to
display Code:
View Replies
View Related
How can i retrive random row of table in ASP.i have a table created in
access2003 and i want to show randomly selected row to the client.is
there any way to do this using recordset object.
View Replies
View Related
I have a script that has worked flawlessly for a while. It allows a user to select from a listbox - with highlighted lines already of their settings, multiple lines (CTRL-SHFT) and the page updates the database properly.
Now, for some reason, I have a user that when we load their settings, all is fine. If I submit the form, immediately, with no new additional selections, all works fine. But, if I add even one new selection on the list box by holding CTRL-SHFT, the submit button no longer works at all.
This user does have a long list of selections already, I am just wondering if I may have hit a max some how?
View Replies
View Related
Is there an SQL query which select an item from the database randomely!
View Replies
View Related
I have used the follwing query before in SQL and its worked fine but not on an access database is the syntax different?Code:
strSQL = "SELECT Count(DISTINCT BID) as varAmount FROM Bookings Where BookedBy = '" & rsStaff("Name") & "'"
The Error i recieve is:
Microsoft JET Database Engine error '80040e14'
Syntax error (missing operator) in query expression 'Count(DISTINCT BID)'.
View Replies
View Related
I have three sets checkboxes in my .
Checkbox a,b,c with different names
If a user selects checkboxes in set A. He cannot select any check box in set B, but he must select in C. If a user selects check boxes in set B. He cannot select any check box in A and C. If a user selects check boxes in C. He cannot select any check box in set B, but he must select in set A.
View Replies
View Related