This will display all records in PropSec table order by SecSort column which has values like '01', '02', '03', '04' and etc.
The reason for this is that i want to sort the records according to the SecSort, '01' first followed by '02' and so on. There musn't be a same value in the drop down box. The no. of records can increase, & not necessary fix to 3 records only.
MS Access db design :
Secsort = text(2)
Title = text(20)
Expected Outcome:
I would want to check to see that the user does not select the same value twice, i.e to prompt out an error message if it does. I am really confused as how to do a dynamic checking when there is no specific field name to check against.
The checking can be done in the secsort.asp or secsort_rs.asp. As long as it can detect the same values & prompt error msg, i am very happy.....
I had a problem in validating my asp page.the field HomeTelno is not a required field.but it always ask for a phone number. How can i validate the field that the user had inputed numbers not letters on it if the user has a telephone #. How can i bypass the validation without asking for a telephone number if the user has no tel number. here is the code:
if (parseInt(form1.HomeTelno.value) != form1.HomeTelno.value) { alert('Please enter a phone number, numbers only'); form1.HomeTelno.focus(); form1.HomeTelno.select(); return (false); }
I need a text box to only take 6 digits. It should work like this:
If the user inserts say '89' form would actually send over '000089'. Likewise if they inserted 1234, again the form would send 001234, if they inserted 1 it would send 000001 and so on..
Yes, the easy way round this would be to give the users a message to input the data as 001234 for example, but is there any way this can be done dynamically?
I am trying to complete a form validation for a repeated dynamic text box. Someone shared some code with me that doesn't seem to do the trick but it lead me in the right direction. Here is the code that I'm using: Code:
I have a form that has both static and dynamic fields. I have no problem validating the static data, but whenever I try and apply form validation to a dynamic text box that has repeated rows, the validation does not seem to take. Do I have to run that validation through a loop? Code:
I have a form I'm building in Dreamweaver. On my form I have a drop down list that is populated by a table in my Access Database. I won't to add a second drop down list but have the contents of it vary by what I select in my first drop down list. Let me explain further. Lets say I have a database of Movies. And The name of the movies are in a table and that table is used to populate my first drop down list. Now I have another table that has the actors in the movies. I have a junction table to make them relate in my database.....now how can I select a movie in the first drop down list...and the actors from that movie popluate the second drop down list?
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.
I hope this is the right group. I am very new to ASP so this is probably a stupid question. I have some vbscript that query's AD and populates a recordset. I know the recorset contains the information I want by doing a Response.write. I am having problems dynamically creating a drop down list from the data in the recordset. The drop down is created but it is empty. Code:
I need advice how to reduce the size of my drop down list which is created dynamically using a field from my database. If you visit this link you'll see as the box is too long it's knocked out the whole look of the page. Other than shortening the names of the businesses, is there anything else I can do? My concern is that next year sometime after this site has gone live, it will be maintained with a content manager by people with no IT expertise.
I have two drop downs. Both dropdowns are dynamic and data is send from a db for both,
Depending on what is selected in the first drop down i want to populate the second drop down. I know and have done this using XMLHTTPScripts but as this is for a website i dont want to go down this route.
I have an form/application that requires several pages of steps to be completed. On page4 (income school info) I have a dynamic drop down list that builds itself from the database based on member names that the person has entered on the previous pages. When the person filling out the form gets to the end they have the chance to edit their data if something is wrong on page5a.
When they click on the edit icon the member name is passed back to page4 in the querystring. Based on what the member name is in the querystring, I want the dynamically built drop down list to select whatever name is in the querystring. Code:
I have to populate a drop down list from the database depending on the values of another drop down list. And the thing is it should also be able to add more dynamic dropdown lists to it.
Basically is a survey result page for which the one trying to look at the survey has to figure out different criteriaz.
Suppose he's looking for a group of people who are interested in buyin a stuff and then he wants to find if their age is above or below 50 and then further he decides to see if they are employed or not...
I did try a couple of things such as populating a dropdown list in a new page depending on the values passed on by previous one... but was hoping to find a better solution as the one i m workin is tooo complex and tooo complicated.
I have a web tool written in ASP. One of the feature is dynamic drop down list which updates a drop down list as another drop down list is changed.I uses javascript to reload the same page to update the drop down list.Everything works fine on the webpage using desktop/laptop.
However, it doesn't work on my mobile device(i.e. one drop down list doesn't get updated as another drop down is changed)how to make it works on mobile device? Should I integrate ASP with another technology,. WAP maybe?
I have a dynamic drop down being populated by a db and then the second drop down is populated depending on what was selected in the first. When it does this though the page refreshes. Is there a way to do this without a page refresh?
I dont think using javascript and arrays is an option cause I am doing this with states and cities and there are about 75,000 records in the db that it is lookin through. Code:
Does anyway know the best way (preferably usinge ASP and avoiding the use of Arrays) how to achieve the following:
I have an ASP page. In it, I have a FORM that contains 2 Radio Buttons and a Drop Down List. I need to have the values of the Drop Down List change depending on which Radio Button is selected by the User.
(I thought that maybe some sort of code acting on the OnChange action for the Radio Buttons might work??).
Im getting the functionality of it down first, thats what It looks a little bland. Anyway, the basic idea is that im trying to have a person select a department which brings up a list of class numbers, which brings up a table of tutoring times. Ive just started using ASP a week ago, so don't tear me apart too much. Code:
I want to make a form where m using two drop down menus.
Where in based on selection in first drop down the second drop down should populate itself with relevant data based on first drop down. Like first can be COUNTRY name and second can be STATE name where based oon country selected the STATES are displayed in second drop down for selection.
I have an asp application which I made "Multilanguage". I made an asp file for every language with all the strings to be used stored like this:
Langstring1 = "French" Langstring20 = "VTest"
In the beginning of an asp file I determine which language file to include. In my database there are only numbers. I can now display the right text in the right language using respons.write: Response.write(Langstring20)
Now I want to use a dropdown box displaying a text as selected based on a relation between the number in my database and my language files. When I have number 20 in a database, the value of the option should be 20 and the text displayed should be 'VTest' for this is Langstring20. Problem is that the option value seems to be correct with what I do, but the text displayed in the box is not correct. How can I solve this? Code:
I have a form with 2 drop down menus. the first is populated via a database query and the second gets populated based on the selection made in the first box. (Category/Sub Category)
I am having a difficult time keeping the initial item selected after the page reloads. I thought that this statement would work: Code:
i have a website that uses (or needs to use) dynamically driven dropdowns using asp & JS on all pages. it contains 3 different dropdowns that are DB fed and are dependent upon the value of each other. the drop down values are updated using a repost to itself.
they work perfectly on the initial pages where no other variables are involved, but i am having troubles on the pages where more variables are being sent. eg: i have use a lot of error checking, and when i repost, the variables are deleted, and thus the error listings take effect as the variables are now blank. can i refresh the dropdowns without repossting to the samepage without effecting the existing variables on that page? sessions? cookies?
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:
Create the following code from database but does not validate on enter - I am using ShadowWizards validation code.
<Input fields so work however I will need dropdown and radio buttons to be validated also.
I really like the work ShadowWizard has put in and would like to continue in the same neat, cleaver coded way!
I did validate the few fields with ASP but Yahoo toolbar stops people going back on forms and therefor would not work on all PC's, typically the bosses and now he seems to want it asap so any javascript solution? Code:
I code that creates a calendar for each month and then it displays events from that month that are stored in a db. I need to loop through my recordset and display all the events, but I can't quite figure out how to do it. I am thinking I need to do an array. But I am not really sure.... any ideas. Here is where you can view the calendar. Code:
Ok, I have a Javascript ASP and in it I have a dynamic repeating table with certain attributes to people. If one of these attributes is old or invalid, i want to change the color of the text (and maybe make it flash, blink, change size, something) so that it's easy to read.
I have 3 drop down boxes on an asp page Dynamically populated fron the db, I need the drop bown boxes to be refreshed when you have picked the first eg I select "Midlands" from the Region drop down and only the "Locations" that are in the Midlands are entered into the Locations drop down.....
I have a validate.inc file for my form (ASP). I want to make a validation without external file, i want to write it in the main page, where the whole code is writing, like validation in ASP.NET, a link about that will be helpful too.
Can anyone tell me if there is a way to validate form fields using the dreamweaver server behaviours except using javascript. Basically I need a method of validating each form field when the form is submitted. I don't want to use javascript as I know that users can switch 'active scriting' off, which disables javascript. Due to the forms being critical inputs within an e-commerce system, I must validate them 'server-side'. Is their a dreameaver extension that does this or has anyone over come this issue before?
i want to use javascript to identify whether the user clicked on the hyperlink or not.How can we recognize that one.Here,i will explain my problem clearly. I have one small application in ASP. Application consists of one textbox,one button and one hyperlink like contact us.
If the user click on the button without enter his name or choose contact us hyperlink, then the validation message box will be displayed.How can i do validation for <a>tag.I know the validation for button Like same way i tried to use name attribute to <a> tag and tested,but it gives errors and not worked.How can i solve this problem.
