i'm thinking about making a muti page survey and was looking for some input on the best way to go about it. example
i want 3 questions on the first page, the user answers then hits next the next questions load and so on. what would be the best way of programming this?
I am in the process of building a Simple Survey, and I am having trouble getting started. I have put together my html form, and now I need to build my "survey.asp" page to communicate with my Access database. I have designed my database to have 3 tables: Department, Contract, Survey. Code:
I'm currently developing a website in which i want a have a simple survery. The survey will run for three pages. [survery1.htm,survery2.htm,survery3.htm]
I guess i have to use forms to do this, but don't know how? How do i maintain the user input details in the survery1.htm and carry it forward to the successive pages while getting the survery2.htm ?
In simple terms, How do i pass the user input details from one page to other page and finally forward them to an email address? I would very much appreciate if someone can send me a model or where i can get one.
Just wondering if anyone knows of any good Survey apps available in ASP, most i have seen are .NET. Also, free would would be ideal.
There are lots out there, but ideally i'd liek to see one that allows for things like, "If this does not Apply, you will be sent directly to question 14", etc.
I am going to be working on a project that is a web based survey that will submit the data to a database. But the data will also need to be multiplied by a number and displayed back to the user with some text. And was wondering if anyone had any good resources or samples I could check out I really appreciate any response.
In database exist survey results. Specific results from multiple choice - multiple answer survey (checkbox) are in tbl_results table (example excerpt):
table answers has ID numbers of answered answers, delimited. Anybody has solution to use those ID numbers as foreign key against table tbl_answers, in order to make possibility to make query for better statistics .
i m currently setting up a staff survey, which will be linked from the website of our company. In the past this has been all hard-copy and decisions been made to put it online, and the job was assigned to me.
I've somehow managed to link to HTML form to the database, with the user completing the survey complete with validation to ensure they have not ommited any fields.
how do I prevent a user entering their username with a different employee number? bearing in mind i will have already input all staff username and employee number into the database. So that when the user enters these fields, the database write the survey to that particular record. I think i just need more code for validation, but I'm clueless as to what i require.
I have a questionnaire that I want a user to fill out. If you click on the link, you should be able to see the workflow. I was wondering what the best way of doing this was? To have seperate pages? One page?
what is the best way to develop a database for a survey? How should I name the columns in the database? I have an survey to develop and some of the questions have up to 80 answer options + quantity for the options.
For example, I have a list of truck models from different manufacturers (eg: John Deere[304, 444, 544, 624...], NewHolland[LW50, LW110, LW130...]. The person filling out the survey needs to be able to select from none to all of items and this would only be question #1.
That means if the person filling out the survey select JD 304 and NH LW110 I'll have a total of four entries one for each of the trucks and one of quantity for each of the trucks. If I use a column for each possible answer, I'll end up with about 1000 columns what to me wouldn't be a very well developed database. Anyone has done anything similar? Any ideas?
I have created a dynamic form ,different under different conditions. The elements of the page are dynamically created with the required infor . coming from tables. Now, i have to store the values, states of all individual elements of the form, for future processing . The values are the part of a survey. I hav to analyse the values and create a report.
Now , i m getting confused in the way , the values of all dynamic fields to be stored. I m not getting a good way to store the values and later process for survey analysis.
I am in the process of building a Simple Survey, and I am having trouble getting started. I have put together my html form, and now I need to build my "survey.asp" page to communicate with my Access database. I have designed my database to have 3 tables: Department, Contract, Survey.
Basically from each question the Survey Table will be populated. The survey table is in this format [SurvID (prim key), ques1, ques2, ...contractID.]
So if a user on question 1 clicked radio button "1radio1" then the number one should populate "ques1" field etc. Same goes for question 5, if the user chooses "5radioN" then "N" would populate the "ques5" field.
Also on there will be a drop down menu on the top of the page where the employee can choose the contractID. How would I incorporate that as well? Code:
I have created a database request page (wahooo - new to asp and it works) and everything is great. Now I'm creating a second page and want to know if I'm able to make two different queries on one page. I want to be able to create one query that uses a Request.QueryString from a URL and then use one of the returned values from that query to create another query on the same page. I hope that make sense. Here is the database connection code:
If you are going to be making multiple calls to the same database from a single page, should you connect/close, connect/close, connect/close....or just connect once at the beginning of the page and close at the end?
i want to submit 30 field(textbox,combo etc.) data into database.if i take all 30 fields on same asp page or form,the page will not look good, so i want to break that into 3 pages,each page will having only 10 fields.when all required fields on first page will be filled by the user then he will click on next button,so he will see next page , i.e. page no. 2,same for page 3.
if he want to come on previous page for editing some info,it should be possible.on 3rd page there is submit button,when he clicks on submit all the info will stored into table. can anyone tell me is it possible using ASP 3.0? if it is possible then tell me how to do this?
Im basically making a site that will have a homepage with links I will add everyday to graphics and movies on my server. When you click the link it will open a new page similiar to the homepage with the graphic/movie in the middle of hte page.
I know there's an easy way to do this so i can just have it call a database or something like that. Basically I want to just have to add a link to the home page describing what it is, then and add the link to the file to the database and have the coding do everything for me. I think this is asp.
Can someone clue me in. All the sites i've built up until now have hundreds of pages all consisting of the same thing and it's such a pain to keep duplicating code. I'm not looking to get too advanced. If I don't have to use an access database, i don't want to.
I've been building an ASP app that sits on top of a relational database (MS Access). The problem is that the data from some web forms need to be stored in different tables. Currently I am using multiple SQL Insert statements.
The problem with this approach is that it is possible that several inserts would succeed and then one would fail. This would ruin my database. Is there some way to synchronize the Insert commands or to "flush" the commands at the same time? I need the Insert statements to either all succeed or all fail.
I currently have designed a web page and inserted some ASP modules into it. But, if I insert more than one ASP module I receive an "Internal Server Error". If I delete the second ASP module the page works perfectly. So, my questions is this. Can you only insert one ASP module per web page? Where is the problem. Code:
I m trying to use multiple option menu using redirect function in ASP.
I managed to do a single option but I need to use multiple options can you please advise on how to do this, so both options apear in the same page. for instance, in the code below a user should be able to select uk and also selects between the other options; population, geography from the same page. Code:
We have a master page set up and it is tied to its css file through the standard method in the <head> tag. What I would like to do though is from another page inheriting the master page to add another link to a css file.
That way i can have the sites global file used to make the general apperance consistent, then make the internal content more flexible without destroying the current css file.
Is this a possible task? When i went into the main master page and tried to add a <asp:contentplaceholder id="additionCSS" runat="server" /> tag to the head. When this is done visual studio alerts me saying it doesn't recognize the tag 'asp'. Is there a way around this? We are only just rewriting the site to use master pages now so I'm still figuring it out.
I am trying to make a search page. Once a serach word or words is put in I need it to serach multiple product tables and output the description of any prioduct if the search word is present in the description.
However, If i put in 2 keywords like "paper sticker" I get no results. How do you search multiple keywords? Code:
I am attempting to only show 10 results per page in my results page. I keep on getting the following error. Wrong number of arguments or invalid property assignment: 'MoveFirst' Does someone know where i am going wrong? Code:
I have a query on a page that displays the results of a recordset. Each row has a check box that has the table ID associated with the row of data.
I am trying to figure out how do I send every row checked to another page and have that page know the ID's that were checked so the next page can query the table for those ID's and fill out a submission form. I know the form fields I can write so it dynamically names the value based on the script, that part is easy, but trying to figure out how to have the script accept multiple ID's so it can go through each and display the results is not.
Now this is simple if I am just sending one ID to the next page, I can just use a "Post" and append a ?id=xxx to the URL and then do a request.querystring for the ID. Where I am confused is trying to send multiple ID = 's to the next page so it reads more then one ID if more then one was checked on the previous page which 99% of the time it will be.
HERE IS MY MAIN QUESTION:
What should I look up to point me in the right direction to create a classic VBScript/ASP code to parse through the ID's that were checked on the previous page and have the next page query each ID for the data?
I can pretty much figure out how if I know what I am looking to do. I was just looking for some sort of direction that I can pursue to understand how do do this task. What is it I am trying to do? IS there a term or set of terms I need to consider looking up to get examples so I can tweak and write it from there?
i am new to asp and web designing, and was wondering how to reload a page so that a different set of images appear, depending on which submit button is pressed. Code:
Just as the title says I am trying to do something impossible with a single SQL statement. I am doing an ASP webpage for internal use at the company I work for.
I want to know if there is a way to insert/update data into multiple tables in 1 SQL statement.
If it requires functions | views or anything else that is fine but I don't want to have 3-4 different SQL statements to update 2-3 different columns in different tables.
I have a search option on my website, which should perform a search on 4 fields, as follows:
tblNews headline content
tblDatabank filename description
It only needs to return matches which are an exact match of their search criteria. For instance, searching for "I am here" would return a record which contained "I am here", but not just "I" or "I am" etc.
I need to return all these records as part of one recordset preferably, as I want to be able to order them etc., though I imagine you may suggest I use an array somehow to merge two recordets etc., then reorder them?
i hav problem with updating the data. In the asp page i hav displayed records based on search criteria. in display mode im displaying the to be updated field in combo box for each similar contract_no. each contract_no will hav different no of rows and to be updated combo box.
based on the selected value in the combo boxes of different contract_nos i hav to update the combo value with old value. user select multiple combo values at a time I need anybody's help with detailed programming logic.
I created a web page from Excel2000, using "Save as web page..."...Publish function. then, I moved htm file to my IIS web server. Then I added a form control, and submit button.
How can get the data on the excel file using ASP from server side? For example, the value of Cell(1,2), Cell(2,3)....
What I want to be able to do is create a user control that will display an entire page page within it. Does anyone know how to do this or better yet have any same code?
I like to know how to write this specifc function on ASP where the user eg: display a set of records on the webpage. Example the data are ID, Name and address.
Lets say i display the data on the webpage and i set the Name as the <a href>. So when i click on the name, it will move to another page with the id of the specific name. Code:
I have an ActiveX control in my ASP page that has not been signed yet, so currently just for testing I set the Security for Intranet to "Low". When I run the ASP page on my machine (the IIS is in my machine), I have no problem, except the page prompted me with "An ActiveX control on this page might be unsafe to interact with other parts of the page. Do you want to allow this interaction?"
But, when I run the ASP page on another machine (even though the other machine is also a development machine that already has the ActiveX control and I set the Security for Intranet to "Low"), it did not prompt me the above message, and I got an error when accesing any method of the AX control (e.g Object doesn't support this property or method 'myAXControl.method').
Is this because I have to create a CAB file and mark the AX control as safe for scripting ?To create a CAB file for this AX control, do I need to create my own VB AX Control project that contains this control and then create a cab file for this VB project ?
This is a standard ASP application that has several pages at the root withthe global.asa. I set a session variable session("accountid") = "123456" within an asp page and then response.redirect to the next page and immediately response.write session("accountid") and I get back nothing.
But if I set a session variable session("accountid") = "123456" within an asp page and response.redirect to a page in a sub directory and immediately response.write session("accountid") I get back 123456 on the screen.