database connection using javascript

harivino · 10-17-2012, 06:00 AM

i given the full code
is there any need to be installed for database connectivity from javascript
how do i check whether it is installed or not
what is the problem with following code

Code:

<html>
<head>
<title> MTC NEW ACCOUNT </title>

<script type="text/javascript">

function simple(form)
{



	var name 	= form.inputbox.value;
	var id   	= form.inputbox1.value;
	var balance 	= form.inputbox2.value;
	alert(id+" "+name+" "+balance);


	adOpenForwardOnly = 0; 
	adLockReadOnly = 1; 
	adCmdText = 1; 
 
	var myConnect = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Users\\HARI\\Desktop\\html pro new\\vino\\mtc.mdb";  
 
	var ConnectObj = new ActiveXObject("ADODB.Connection"); 
	var RS = new ActiveXObject("ADODB.Recordset"); 
	var sql = "INSERT INTO Admin VALUES name, id, balance"; 
 
	ConnectObj.Open(myConnect); 
	RS.Open(sql, ConnectObj, adOpenForwardOnly,adLockReadOnly,adCmdText); 
 
	var recordCount = RS.Fields.Count; 
	alert ("recordCount: " + recordCount);

}          


</script>



</head>

<body bgcolor="lightblue">
<form name="myform" action="" method="GET">
<font face="times new roman" size="10" color="red" <center><marquee>ACCOUNT CREATION...!</marquee></center></font>
<br>
<br><br>
<center><img src="ca.png" width="300" height="300" border="5px" width="700px" height="500px"> </center><br>
<br><b><br>
<div align="center">

NAME:<input type="text"   name="inputbox"     value=""><br><br>
IDNO:<input type="number" name="inputbox1"    value=""><br><br>

SELECT VECHILES<br><select><option>CAR</option><option>HUGE VEHICLE</option></select><br><br>
BALANCE:
<input type="number" name="inputbox2" maxlength=10" value="">
<br><br><br><br>



<input type="button" value="submit" onClick="simple(this.form)">
<input type="reset" value="clear all">


</div>
</form>
</body>
</html>

Dormilich · 10-17-2012, 06:45 AM

whether there is a syntax error in this JScript I cannot tell (MSDN would be the prime source here), but I can tell you that even JScript does not look for variables inside strings (unlike PHP).

and that it doesn’t work in any other browser than IE should be obvious.