Solved

getting the results to go to an database

Posted on 1998-04-14
14
223 Views
Last Modified: 2013-12-25
I am writing a web database to gather information on employee traveling routines. What is the best way to do an online questionnaire and record the results ? (ideally i would like to record the results in a database)

Cheers

Itssbell

0
Comment
Question by:itssbell
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 7
  • 4
  • 2
  • +1
14 Comments
 
LVL 1

Expert Comment

by:jello
ID: 1858233
There are a few ways to handle this type of process on the Web.  It is becoming very common to use Microsoft Active Server Pages to pass information to and from an ODBC compliant database.  MY particular method of choice is to use Cold Fusion (available at www.allaire.com)  To pass information back and forth.  Cold Fusion uses its own hybrid language (CFML) which is a hybrid between standard SQL commands and HTML.  I found it easy to learn and both flexible and scalable enough to suit my needs.
Let me know if you need more information.
0
 

Author Comment

by:itssbell
ID: 1858234
How would i use Active Server pages  ?
0
 
LVL 1

Expert Comment

by:jello
ID: 1858235
There's a comprehensive online tutorial located at:
http://www.activeserverpages.com/learn
0
Webinar: Aligning, Automating, Winning

Join Dan Russo, Senior Manager of Operations Intelligence, for an in-depth discussion on how Dealertrack, leading provider of integrated digital solutions for the automotive industry, transformed their DevOps processes to increase collaboration and move with greater velocity.

 

Expert Comment

by:NetW3
ID: 1858236
You don't specify your operating system, but if you are using a Unix system, you
can try using mSQL from Hugues technologies. mSQL is an alternative to the high-end
commercial software and is useful in smaller scale applications. Cold Fusion, as
suggsted above, is a very powerful app that works with NT and with Unix (well,
just with Solaris 2.5.x at this point) and will most certainly meet your needs.

Just use HTML forms to pass named information into your database application,
running as a service on NT or through CGI on a Unix system.

Perhaps specifying your base OS, web server type, and the scope of your work would
be helpful for future answers. If you have higher end requirements, something like
Oracle would be useful, if you are midrange, something like Lotus Notes/Domino may
serve(r) you well. If you have low end requirements, mSQL may get you by.

Please let us know your situation. Thanks, Curt

0
 

Author Comment

by:itssbell
ID: 1858237
I am using an NT system with IIS 4.0 installed

itssbell
0
 
LVL 5

Accepted Solution

by:
bin_huwairib earned 220 total points
ID: 1858238
itssbell,

Here is how to use Active Server Page, all the points below have to be on the server side.

1 - Create a file named "default.htm" and paste in it the following:

<HTML>
<HEAD>
</HEAD>
<BODY>
<H2>Employee Information</H2>
<FORM NAME="Emp_Form" ACTION="Submit.asp" METHOD="POST">
<P>Employee Name: <INPUT TYPE="Text" NAME="Emp_Name" SIZE="16"></P>
<P>Employee Address: <INPUT TYPE="Text" NAME="Emp_Address" SIZE="16"></P>
<P>Telephone No.: <INPUT TYPE="Text" NAME="Emp_Tel" SIZE="16"><P>
<P></P>
<INPUT TYPE="submit" NAME="Submit" VALUE="Submit">
<INPUT TYPE="reset" NAME="Reset" VALUE="Reset">
</FORM>
</BODY>
</HTML>

2 - Create another file named "submit.asp" and paste in it the following:

<%@ LANGUAGE="VBSCRIPT" %>

<HTML>
<%
 Set Conn = Server.CreateObject("ADODB.Connection")
 Conn.Open "employee"
 Conn.Execute("INSERT INTO EmployeeInfo (Emp_Name, Emp_Address, Emp_Tel) " & _
               "VALUES('" & Request("Emp_Name") & "','" & Request("Emp_Address") & _
               "','" & Request("Emp_Tel") & "')")
 Conn.Close
 Set Conn=Nothing
%>

<BODY>
 <SCRIPT Language="JavaScript">
 <!--
  function goDefault()
  {
        window.location.href = "default.htm";
  }
 // -->
 </SCRIPT>

<H3>Employee Information was saved sucessfully.</H1>
<p><INPUT TYPE="button" VALUE="Click here to go to Employee Information"
NAME="GoDef" ONCLICK="return goDefault()"></P>
</BODY>
</HTML>

3 - Create MS Access Database named "emp" and create a table called "employeeinfo", this table will consist of three fields Emp_Name, Emp_Address and Emp_Tel.

4 - Create an ODBC data source named "employee" (Microsoft Access Driver) to be pointed to "emp" database which was created in step 3.

This sample have three fields only, you can expand it as much as you can.


Best regards,
Bin Huwairib
0
 

Author Comment

by:itssbell
ID: 1858239
Using your code i got an error message -

270 (0x0000010e)

 I think its because i haven't set up the ODBC database up properly - can explain in a bit more depth how i set this up

Thanks a lot

Itssbell
0
 
LVL 5

Expert Comment

by:bin_huwairib
ID: 1858240
itssbell,

Do the following steps on your server machine:

1 - Goto the (Settings/Control Panel) then double click on the ODBC icon.
2 - Goto (System DSN) tab and click on (Add) button.
3 - Select "Microsoft Access Driver (*.mdb)" then click on (Finish).
4 - Enter "employee" in (Data Source Name) text box.
5 - Click on select and choose "emp" database (assuming that you created "emp" database -check step no.3 in the previous answer-).
6 - Click OK.

That is all, please let me know if you require any other details.


Best regards
Bin Huwairib
0
 

Author Comment

by:itssbell
ID: 1858241
I have followed your instructions to create the odbc database called employee, but its still coming up with the same error.

THe URL is

www.wkac.ac.uk/webdomain/default.htm

Thanks for your help so far

Itssbell
0
 
LVL 5

Expert Comment

by:bin_huwairib
ID: 1858242
itssbel,

It's nothing to do with the ODBC database, look at this artical it might help you.


PSS ID Number: Q180710

SYMPTOMS
========
 
When a user makes a request for a Web page from Microsoft Internet
Information Server (IIS), the server reports an error 270 (0x0000010e) in
the browser.
 
CAUSE
=====
 
This error occurs because an application is running in the IIS process's
memory space. The application is modifying threads within the process to a
thread type called Apartment Model Threading. When the application is ready
to return control of the thread, the application does not convert the
thread back to a "free threaded" thread. This causes IIS to experience a
memory exception error and reports it to the browser.
 
WORKAROUND
==========
 
To work around the problem, determine which component is causing the
problem and either fix it or do not use it.
 
Custom-developed components can cause the problem. You should also check
for any ISAPI (for example, a filter or .dll file) or an ActiveX object
that may use the IIS thread pool, and remove or repair them.
 
STATUS
======
 
Microsoft is researching this problem and will post new information here in
the Microsoft Knowledge Base as it becomes available.
 
MORE INFORMATION
================
 
To determine which ISAPI filters are currently in use on the system, you
will need to use Registry Editor. Start Registry Editor (Regedt32.exe) and
locate the following registry key:
 
   HKEY_LOCAL_MACHINE/System/CurrentControlSet/Services/W3SVC/Parameters
 
Find the value "Filter DLLs" and double-click it. The Edit Value dialog box
appears. If the value is selected, clear the highlighting before you
attempt to view it. (To clear the selection, press the left or right arrow
key.) Filter DLLs that are in use will be listed by path and file name,
separated by a comma. By default, IIS installs the ISAPI filter
Sspifilt.dll. Both versions of Microsoft Proxy Server, if installed on the
system, will include a filter named W3proxy.dll. These do not cause this
problem and should be left in place.


Best regards
Bin Huwairib
0
 

Author Comment

by:itssbell
ID: 1858243
so is there a patch/fix/update for it ?

Cheers Itssbell
0
 
LVL 5

Expert Comment

by:bin_huwairib
ID: 1858244
itssbell,

Which version of IIS installed on your server.

Bin Huwairib
0
 

Author Comment

by:itssbell
ID: 1858245
IIS 4.0

cheers

Itssbell
0
 

Author Comment

by:itssbell
ID: 1858246
Thanks for all your help - you have been a star
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When it comes to write a Context Sensitive Help (an online help that is obtained from a specific point in state of software to provide help with that state) ,  first we need to make the file that contains all topics, which are given exclusive IDs. …
When crafting your “Why Us” page, there are a plethora of pitfalls to avoid. Follow these five tips, and you’ll be well on your way to creating an effective page.
This tutorial walks through the best practices in adding a local business to Google Maps including how to properly search for duplicates, marker placement, and inputing business details. Login to your Google Account, then search for "Google Mapmaker…
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

751 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question