Dynamic Tables Based On A Form
I have a db with about 15 fields in, what i have a list of all the fields on a form, simply check the checkbox relating to that field and on the next page it creates a table only with those fields in it.
View RepliesI have a db with about 15 fields in, what i have a list of all the fields on a form, simply check the checkbox relating to that field and on the next page it creates a table only with those fields in it.
View RepliesI know how to create dynamic tables in dreamweaver to display fields and records in a table of a database, but in my case I need to create a dynamic table that lists all the tables in the database, then to click on the one i want 2 edit the data in there.
View Replies View RelatedDoes anyone know how to display movie times from a particular zipcode stored in a DB? I need to find a website out there has a data feed that can be accessed with movie times. Anyone have any ideas?
View Replies View RelatedI dont even know if ASP is the right language to be doing this, but what I am basically trying to complete is a way for a dropdown box to come, and depending on what they select data will go into a table. For instance, the dropdown will what type of taxpayer they are and if they select individual, the offered services will appear in the table.
View Replies View RelatedI have a SQL table that I am displaying dynamically...
The primary key of which is the ID, I have another table that I want to display as a subset of a row from the first table but only if they have the same IDs??
THe things I am trying are not working and I am sure I am missing an obvious step..
example:
ID GROUP NOTES
-- ------- -------
1 People None
- 1 Blah Blah Blah
- 1 Something else
2 People None
3 People None
- 3 Something here too
Sorry if I didnt do avery good job explaining but I am about fried out on this.
I have a table called locations which holds 9 store locations. I am at
my wit's end trying to format these like this:
centered
City Name(named once)
store store store store
next, etc.
Here's my dilemna: Some cities only have 1 location, some have 4, some
have 3. I don't know how to dynamically get them all centered under the
city names (which I only need listed once) because of the different
number of stores for each city. Code:
I've been racking my brains over this one. I have a Classic ASP edit
form with many fields, one of them a Status drop-down. If the Status
(option value) has been changed to "Pending" for instance, I do a
objMail.send, otherwise it doesn't send.
No problem, but how can I
prevent the mail from sending AGAIN if a user goes back to the page and
updates another field, or even just refreshes the page? If it helps, I
am updating a SQL Server database.
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.
Is it possible (and if so, how?) to have an asp form page that based upon a user's selection on a field, would generate a input field b that the user selects?
For example:
User selects "name" in a select statement which would list the possible names to select from or if the user selects "telephone" in the same select statement then it would list the possible telephone numbers to select from.
Or simpler:
If user selects A then show P to select from or
if user selects B then show Z to select from.
Dropdown has three choices. If the third is chosen, the next field needs to be hidden. is there an ASP version of a show/hide script?
View Replies View RelatedI have a form on one page where someone selects a bunch of options and details about a specific category. Then on the next page they fill out a form with contact information, name, address, email, etc.
Well what I want to know is when they click Submit on that contact form is there a way to have it so it goes through and searches the database for any that match the state and county(which they will select from a )??
So what I basically want right now is for the first form to be filled out, then the second form to be filled out, then when they are submitted it will go through the database and select everyone in there with that state and county, then on the next page display the results of both forms AND the matches in the db(obviously whatever fields I want it to display).
I already have both forms(basic html), I already have the dynamic dropdown for state and county(classic asp), what Im wondering is how do I put that dynamic dropdown in the contact form and then when submitted it will go through and search the db based on what was selected there. Would this be some sort of onClick for the submit button tellin it to search the db based on the dropdown or how would I get started on something like this?
There will be other information on the dropdown like name address email so one problem I was wondering about was my dropdown menu. When you select the state it refreshes the page and then loads the counties, so wouldnt that erase anything that was filled out on the form?
I could make it so they actually type the name of their state and county but that causes problems too because if they mispell either then it wont return any results.
I need to have my ASP form "post" action=? pass to a different confirmation page based on a radio button selection on the form, after submit.
Depending on which radio button they click on, they will receive the same confirmation but then be redirected to a selection specific page, based on the radio button selection. I'm assuming I need to create several different action pages, each with a different redirect, then have the radio button determine which action page the form is directed to based on the radio button selection.
I've tried several different options, such as creating a variable on the form, sDirectionVar, with redirect conditions, but I don't know how to call that on submit? I'm not sure I'm even going in the right direction.
I have a form where the visitor should enter the e-mail adress, a password and some additional info. When the form is submitted I want to automatically send a confirmation e-mail to the visitor, containing the information from the form (like the procedure when joining this forum :-)). Is it possible to achieve that with ASP? Would be very grateful if anybody can finish the code below... because I don't know how to handle the variables after I have retrieved the form info..
This is enterinfo.htm.....
I have a form where a visitor can enter som information, in this case the e-mail adress, password and some additional info. As soon as the form is submitted I want to send an automatically generated e-mail confirmation to that user's e-mailadress (like the procedure when joining this forum for the first time). When I have retrieved the info from the form in the "confirm.asp" I don't know what to do....
View Replies View RelatedI have an asp page that displays informaton from an Access database. I want to create a form that allows users to display only data that matches their search criteria.
I have made many forms like this in Front Page with the Database results wizard, but I want to manually code it. Code:
Can one form be set up to populate two or three tables? If so, how?
View Replies View RelatedI started this db 8 months ago but left it for 5 months. Now I am back and trying to get in the swing of things again. My question? Can I design one form that will populate two tables, and if so, how? (Simple answers please. I am only partially literate in programming chit chat)
View Replies View RelatedI have two tables Property & Landlord. I have a form and when it is filled in and submitted the information should be sent to the two tables, but i cant seem to get my head around this problem.
View Replies View Relatedit's a dynamic form which should show which option is selected. I've made zillions of these before, and this should work no problem, but there's a bug that I just can't see somewhere... Can anyone see what in god's name I'm missing? Code:
View Replies View RelatedI currently have a form with 5 rows of textboxes (one textbox on each row). I would like when user keyed in something in the last textbox (textbox at 5th row), it will automatically create another row of texbox below it. Can someone please advise me on how I can do that?
View Replies View RelatedI am trying to populate a form field without having to write any Javascript.
I am using dreamweaver and am trying to follow the help guide to create dynamic fields. However it is not the best of examples and i am struggling quite a bit with it.
I am trying to create a form that asks mostly yes or no questions using radio buttons. One question has 5 different radio buttons. The form is dynamic because if they answer say yes to one question it will go another.
If they answer no, it will go to another. The questions should display as a hierarchy, so that they can see all of the questions and what they answered, I also want them to be able to change the answer to previous question. I did it in javascript, but it doesn't work quite as well if they change their previous answers. How do I do it in ASP?
I have a form with 5 textboxes (one on each row). I want it to auto generate another textbox below the last when user key in something in the 5th textbox (which is the last textbox in the form). This will go on until the user has nothing to key. Textboxes will always generate at the last row when user key in the last texbox displayed.
View Replies View RelatedI have 2 databases, one i write two when i submit the form, that works fine. The other holds contact info. I need for when the Company Initials are typed in(form CSN) that the Pace Administrator info fills automatically(PAName and PAPhone). Code:
View Replies View RelatedI have a lot of information to fill out on this form. So I'd prefer not to do the submit to itself everytime to rebuild it. I've seen many java script examples on how to dynamically populate a checkbox, combo box etc. but is it possible just to not have the box there at all?
I've seen a .visible=false on spans in aspx, but can you do something similar to this with plain old asp?
Example, i have a combo box, and let's say i select a few options and write a "on change"..... i call a function that makes an attribute .visible false. Is this possible to make a text box disappear off the page without resubmitting the from? If not, any other bright ideas on how to do this one?
If I have say 10 fixed variables, how can I set their values = to that of a form that is built dynamically?
column1column2
email=formvalue(0)
fname=formvalue(1)
lname=formvalue(2)
etc..
lastvar=formvalue(9)
I have a form on an asp page and need to dynamically add rows to it and then be able to insert the dynamic cells to a SQL database.
I have tried this with JAvascript and have kind of hit a wall. Any ideas how to do it with ASP instead? I want to add the next row when a user exits the last cell in the existing row.
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:
View Replies View RelatedThe problem I have is that I need to be able to allow users select from a drop down list, but if they select other from the list, I need to show a text box where they can enter the details, otherwise keep it hidden. here is my code so far: Code:
View Replies View RelatedI have a form which inputs info into a database. However what I would like is to populate a select box directly from the dbase. When the form is entered the field is updated along with all the other info.
I have enclosed two of my pages - I think I'm nearly there.
My client wants File Uploading in ASP that i can do but the requirement says that i should have one FORM FILE FIELD first to browse the file to upload.
and the moment i click the browse button of first FILE FIELD, a second FILE FIElD is generated beneath it and when the user clicks on the second Browse button it generates the third and this process goes on. Untill the user clicks the upload button to upload all the files.
I know this sounds stupid as it is much easy to provide 5 Form File fields and if user wants more then another five is added on another page, but ti is clients requirement .
I dont know how to dynamically Generate Form FILE FIELD for browsing file to upload AT RUN TIME .
I have a form with dynamic checkboxes, and normal text boxes. If the user doesn't fill out the required items and submits the form they get returned back to the form with their checkbox selection gets lost.
How do i retrieve the values already checked and placed them back.
Basically i want to pull a record from a table and based on a few records build a input form.
The idea: I want to be able to design a online logging form, using 4 fields in the table inc_label, inc_group, inc_required and inc_type.
Inc_Label is the name of the item.
Inc_Group is the name of the Group.
Inc_Requried is if the item is required.
Inc_Type is the item type.
Code: