Best Way To Develop Survey Database?
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?
View Replies
ADVERTISEMENT
I want to develop a site with the following features:
1. A movie library (DVD's, VCD's etc)
2. A database
3. search by category, title, actor, etc
4. membership signup
5. tracking system for lent out titles
Now am new to ASP just dived in am using Visual web developer express edition. Please point me in the right direction on the best way to do this. Am self taught kind a person and will not take me a long time to get the hang of it once in the right direction. Am not conversant with Visual basic or C#.
View Replies
View Related
is it possible for me to develop a website
offline, and using CDO. How i can know that, the script I wrote at offline
and run at localhost will work when I host it on the webserver. I try to
write a website which allow to send order form to email. Now I facing the
problem, because I need to test it at localhost.
View Replies
View Related
How can I develop Graphs using ASP 6.0, which I am using SQL 2000 as my database? Is there is any free tool to develop graphs using ASP 6.0?
View Replies
View Related
I have 3 different ways to let the visitor know that latest news is up on the website. First is through email,send through website and last through a pop up.The problem is how do I develop a counter that record the hits from three different sources,so I know the most effective way that the visitor is using to access the latest news.
View Replies
View Related
currently i'm using dreamweaver ultradev, it highlights keywords and such but doesn't really do any error highlighting, which can get frustrating when i'm searching for a compile error.
View Replies
View Related
I have to develop a news bulletin system for my website. Plz can someone help with suitable links or examples to develop this. Im using asp with vbscript and sqlserver backend.
View Replies
View Related
I've got .Net 2003 installed on my XP Home machine. Since don't(can't) have IIS installed, I've heard you can use a remote machine that has IIS and ..Net to develop an ASP.Net solution on my XP Home machine. What do I have to do to make this happen?
View Replies
View Related
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.
View Replies
View Related
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.
View Replies
View Related
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.
View Replies
View Related
In database exist survey results. Specific results from multiple choice - multiple answer survey (checkbox) are in tbl_results table (example excerpt):
IDresult__IDquestion_answers
....
24________72_________178,180,191
25________77_________221,224
26________79_________291,298,301,302
27________84_________522,523,525
....
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 .
View Replies
View Related
I want do add an online survey on my site, but i have no idea where to start.can anybody explain to me what goes into building an online survey.
View Replies
View Related
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.
View Replies
View Related
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?
View Replies
View Related
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?
View Replies
View Related
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.
View Replies
View Related
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:
View Replies
View Related
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:
View Replies
View Related
I have just started using ASP, I am normaly using PHP but I thought ASP might be a good road to go down. I am having a few problems, I am trying to limit the number of records I take out the database but I keep getting errors.
<%
'connection string
datapath=Server.Mappath("guest.mdb")
strconn="PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=" & datapath & ";"
Set CONN = Server.CreateObject("ADODB.Connection")
CONN.Open strconn
'select all records row by row
DBquery="SELECT * FROM Guests LIMIT 10"
set query=Conn.execute(DBquery)
do while not query.eof
'get a variable from the table
guest_id = query("ID")
guest_name = query("Name")
guest_msg = query("Mesg")
guest_date = query("DateTime")
'print the variable to the screen
response.write guest_id & "<br />"
response.write guest_name & "<br />"
response.write guest_msg & "<br />"
response.write guest_date & "<br />"
response.write "<br />"
'move to the next record
set conn = nothing
query.movenext
loop
%>
I am getting this error;
Microsoft JET Database Engine error '80040e14'
Syntax error in FROM clause.
/guestbook/guest.asp, line 11
can anyone help me?
View Replies
View Related
I had made a form name 'dform.html' which asks idno, name and phone from the user and after the user clicks on button "save data" sdata.asp is executed. sdata.asp is written to save the values entered for idno,name and phone in dform.html into table "myfriends" in the mydata.mdb (access database). but when i am clicking on save data button i am getting error saying
"Error Type:
Microsoft JET Database Engine (0x80040E09)
Cannot update. Database or object is read-only.
/SDATA.ASP, line 9"
can please anyone tell me why i am getting this error.
View Replies
View Related
I work with ASP for several weeks now and i really like it! But until now i have just used it in connection with my localhost. I made connections to a SQL Database and to an ACESS Database with using the ODBC Tool from WIndows!!
Now i want to publish my website but i don't know how to handle the connection string kind of thing. My MySQL-Database is on a different server than the website and i need a connection string where i can type in the server, a password and a username and it should then connect.
View Replies
View Related
I'm current working on a project which need to upload local data to
live server database.
Meanings that, i'm current having a server in my local mechine. I need
upload data from local database to live database which host at oversea
company. But i really have no idea how to do this in asp.
View Replies
View Related
Error Type:
Microsoft JET Database Engine (0x80040E21)
Cannot update. Database or object is read-only.
/q_maker/aero_admin/delete.asp, line 12
what is wrong! i checked the db and its not readonly.
View Replies
View Related
i wrote a shopping cart using cookies found out thatIE 7 won't let me add more cookies after a certian number. decided to use DB along with cookies and now i have very weired problem never encountered before Code:
View Replies
View Related
Products ---> Products|Customer <--Customer
With regardst the above many-to-many relationship:
Is there any advantage in creating seperate access databases for:
- Customer
- Products
....Rather than keeping them as three tables in one database.
The reason I ask is that I have found that if I am using a ftp approach to
overwriting or updating the remote database there are sometimes problems
with synchronizing data .....This seems to be a better solution?
Am I off base?
View Replies
View Related
does any one know a simple free database driven website tutorial that i could learn? i need it for when someone searches a name ionformation on that name comes up along with photographs realating to them.
I have built several websites before but none are database driven so is there any dummy proof versions?
View Replies
View Related
How do I do a Do While loop to display rows of information out of a database. Here's my code, and it seems like its in an infinite loop. Code:
View Replies
View Related
I have a Access DB with two tables (Users and tblpersons). Users are stored in table Users and their records in tblpersons. They are able to login, Enter, Search, Update their data.
I want users to be able to Enter and update only their data not other users data.
Example:User_Id 1 when logged in, is able to enter data for any user(1,2,3......) and able to modify their data.
View Replies
View Related
I can make a simple database file and name it database.mdb, all I need to do is name a single field email and save it. But I dont know how to make it so that my page will become active and the emails submitted will be saved either to the mdb file or a text file, im not sure what goes on there.
View Replies
View Related
i have 2 tables and i only want the records where which arent in the one database eg.
table 1
idnum
1
2
3
4
table two
idnum
1
2
3
4
5
6
out of these two tables i only want from table two idnum 5 and 6 cause they arnt in the 1st table.
View Replies
View Related
They are on Windows 2000 IIS 5.0 and currently have an older version
of their job database using Access hosted on a Brinkster server.
The new server that they are on, when I contacted the host, they advised me
against creating any new applications using Access, as the server is not meant
for multi-users.
So, I am thinking that they need to get their host to upgrade to a SQL database
and have the job database developed using that.
My question to this forum is: What do you think is the best combination for
improvement here, SQL or MySQL or what, considering that their site is using asp
and hosted on Win2000 IIS 5.0?
Also, any recommendations on scripts that might be already available that could
be customised to their site?
View Replies
View Related
What we have is our own (in house) Windows 2000 Server which runs MS SQL for our data storage and we have writen our own VB6.0 Application which runs of the SQL DB to manange our stock, ordering, price's etc etc. Also we have our own Website with a Web Hosting Company which is also a Windows 2000 Server but can only Run access databases.
What we what to do is somehow have the Access database and the SQL database sync together to have some of the same data in both database's. But I don't know where to start.
View Replies
View Related
