HTML Database access using Javascript

Trying to create an HTML page called Project.html that will ask the user for basic information (name, e-mail address, and comments), and when the SUBMIT buttom is hit, add the users to an Access 2007 Database. Ideally, the information would only be able to be added once, but I need the adding sequence to work first. Any and all comments or questions would be appreciated.

Anthony
Beginning Programmer

Expand|Select|Wrap|Line Numbers

 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
 
<html xmlns="http://www.w3.org/1999/xhtml">

<head>

    <title>Project input Form</title>

    <style type="text/css">

        .style1

        {

            width: 70%;

        }

        .style2

        {

            text-align: right;

            width: 261px;

        }

        #Text1

        {

            width: 191px;

        }

        #Text2

        {

            width: 189px;

        }

        #Text3

        {

            width: 190px;

        }

        #Button1

        {}

    </style>

    <SCRIPT LANGUAGE="JavaScript">

    function addrecord (form) {

        var cn = new ActiveXObject("ADODB.Connection");

        var strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source = C:\Documents and Settings\aknab\My Documents\testingapp\users.accdb;Persist Security Info=False";

        cn.Open(strConn);

        var rs = new ActiveXObject("ADODB.Recordset");

        var SQL = "select count(*) from Customers";

        rs.Open(SQL, cn);

        alert(rs(0));

        rs.AddNew 'Prepare the database to add a new record and add

        rs.Fields("name") = Request.Form("cname");

        rs.Fields("email") = Request.Form("cemail");

        rs.Fields("comments") = Request.Form("ccomments");
 
        rs.Update;   'Save the update
 
        rs.Close();

        cn.Close();  

    }

    </script>

</head>

<body>
 
    <p style="text-align: center">

        Vetsulin Test page.<br />

    </p>

    <table class="style1">

        <tr>

            <td class="style2">

                Name&nbsp;             </td>

            <td>

                &nbsp; &nbsp;<input id="Text1" type="text" name="cname" /></td>

        </tr>

        <tr>

            <td class="style2">

                e-mail&nbsp;

            </td>

            <td>

                &nbsp; &nbsp;<input id="Text2" type="text" name="cemail" /></td>

        </tr>

        <tr>

            <td class="style2">

                Comments&nbsp;

            </td>

            <td>

                &nbsp; &nbsp;<input id="Text3" type="text" name="ccomments"/></td>

        </tr>

    </table>
 
    <p style="text-align: center">

        <input id="Submit1" type="submit" value="submit" onClick="addrecord(this.form)" />&nbsp;&nbsp;&nbsp;

        <input id="Reset1" type="reset" value="reset" /></p>
 
</body>

</html>

Feb 2 '10 #1

Subscribe Post Reply

14310

Dormilich

8,658

Expert Mod 8TB

you are aware, that this will only work in IE?

Feb 2 '10 #2

aleseus

Yes. this will only be used in a closed environment at this time. the office is Microsoft central.

Feb 2 '10 #3

acoder

16,027

Expert Mod 8TB

What problems are you having with the code? Error messages? Which line number?

Have you checked the archives for similar questions, e.g. this one?

Feb 2 '10 #4

aleseus

At launch, I am getting the error at line 33 EXPECTED HEXADECIMAL DIGIT

when running, and I hit submit, I get an error at line 83 OBJECT EXPECTED

Feb 2 '10 #5

acoder

16,027

Expert Mod 8TB

What lines do these correspond to in the code?

I think part of your problem is using XHTML and including JavaScript code within the page. Either use HTML or include the code from a script file, and validate the page.

Feb 4 '10 #6

ifedi

Expand|Select|Wrap|Line Numbers

 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> 
 
<html xmlns="http://www.w3.org/1999/xhtml"> 

<head> 

    <title>Project input Form</title> 

    <style type="text/css"> 

        .style1 

        { 

            width: 70%; 

        } 

        .style2 

        { 

            text-align: right; 

            width: 261px; 

        } 

        #Text1 

        { 

            width: 191px; 

        } 

        #Text2 

        { 

            width: 189px; 

        } 

        #Text3 

        { 

            width: 190px; 

        } 

        #Button1 

        {} 

    </style> 

    <SCRIPT LANGUAGE="JavaScript"> 

    function addrecord (form) { 

        var cn = new ActiveXObject("ADODB.Connection"); 

        var strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source = C:\Documents and Settings\aknab\My Documents\testingapp\users.accdb;Persist Security Info=False"; 

        cn.Open(strConn); 

        var rs = new ActiveXObject("ADODB.Recordset"); 

        var SQL = "select count(*) from Customers"; 

        rs.Open(SQL, cn); 

        alert(rs(0)); 
 
        //below:why no closing single quote?

        rs.AddNew 'Prepare the database to add a new record and add 

        rs.Fields("name") = Request.Form("cname"); 

        rs.Fields("email") = Request.Form("cemail"); 

        rs.Fields("comments") = Request.Form("ccomments"); 
 
        //below:why no closing single quote?

        rs.Update;   'Save the update 
 
        rs.Close(); 

        cn.Close();   

    } 

    </script> 

</head> 

<body> 
 
    <p style="text-align: center"> 

        Vetsulin Test page.<br /> 

    </p> 

    <table class="style1"> 

        <tr> 

            <td class="style2"> 

                Name&nbsp;             </td> 

            <td> 

                &nbsp; &nbsp;<input id="Text1" type="text" name="cname" /></td> 

        </tr> 

        <tr> 

            <td class="style2"> 

                e-mail&nbsp; 

            </td> 

            <td> 

                &nbsp; &nbsp;<input id="Text2" type="text" name="cemail" /></td> 

        </tr> 

        <tr> 

            <td class="style2"> 

                Comments&nbsp; 

            </td> 

            <td> 

                &nbsp; &nbsp;<input id="Text3" type="text" name="ccomments"/></td> 

        </tr> 

    </table> 
 
    <p style="text-align: center"> 

        <input id="Submit1" type="submit" value="submit" onClick="addrecord(this.form)" />&nbsp;&nbsp;&nbsp; 

        <input id="Reset1" type="reset" value="reset" /></p> 
 
</body> 

</html>

Let me confess that I haven't actually taken time to test your code.
However, please note the two lines of comment I've placed in your javascript above.

Above all, I'm not sure I'd expect

Expand|Select|Wrap|Line Numbers

 
 <input id="Submit1" type="submit" value="submit" onClick="addrecord(this.form)" />
 

to work when this input and all the other input fields are NOT ENCLOSED IN ANY <form></form>
I suspect that the parent FORM is the object expected

Regards, Ifedi.

Feb 9 '10 #7

Dormilich

8,658

Expert Mod 8TB

to work when this input and all the other input fields are NOT ENCLOSED IN ANY <form></form>
I suspect that the parent FORM is the object expected

form elements do not submit if there’s no <form> element, that’s right.

Feb 9 '10 #8

raleti

use "microsoft.ace.oledb.12.0" driver instead of "Microsoft.Jet.OLEDB.4.0"
and chanage rs.Open(SQL, cn); to rs.Open(SQL, cn,1,3);

its worked from with above changes.

Jan 14 '15 #9

by: hagarwal | last post by:

People, Here's my situation: 1. I have a web browser component that does not support Javascript (well it does, but we've disabled it) 2. I have to display some HTML in it, where the user has a...

Javascript

Backup Database Access using VB code

by: xpcer | last post by:

i wanna to backup an access database using vb. if my database without password i can use Filecopy "database.mdb","D:\myback.mdb" but if my database with password, it can't work, and the...

Visual Basic 4 / 5 / 6

how to load images in database access using VB?

by: leen85 | last post by:

helo everybody...i'm lina...i need your help...i have a problem in VB and Access...i have 38000 images for my company employee which size about 5GB to stored in database...as we know we cant stored...

Visual Basic 4 / 5 / 6

Insert data into ms access using javascript

by: rajabide4u | last post by:

How to insert data into ms access using javascript

ASP / Active Server Pages

How can I get data on database MYSQL using javascript function?

by: ariel gons | last post by:

This is one of my project and also my thesis in school. How can I get data on database MYSQL using javascript function? Is there anybody here can help me with this problem.. Can anyone give...

Javascript

Database Access using pyodbc. I've a problem

by: Rajendran | last post by:

Hi all, I've installed pyodbc module to access my database (MS Access). I've setup a User level DSN to the database.mdb file. When I run my python code in the command prompt it is retrieving the...

Python

Insert text box values in MS Access using Javascript

by: franklin moses | last post by:

how do i insert textbox values to ms access using javascript

Javascript

Database access from Javascript?

by: Mikhail Teterin | last post by:

Hello! A major application we are using allows extending itself with custom JavaScript. They embed Rhino implementation of JS (written in Java). There is no apparent built-in way to access...

Javascript

Unable to save record in access using javascript

by: irfanshariffa | last post by:

<html> <head> <script type="text/javascript" language="javascript"> function validate() { if (document.form.fname.value=="") { alert("Enter your Name"); document.form.fname.focus();

Javascript

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

HTML Database access using Javascript

Similar topics