Connect a web form to access database - JavaScript Discussion Boards

Hello all,

I am using the Chrome browser to run a simple html test page containing jQuery code.

If I load it from the disk path, it works as expected.
If, instead, I use the IIS, then it gives the $ is not defined error. Funny enough, using the incognito mode makes it work WTF | :WTF:

Any idea about what could be wrong here?

Bogdan Rechi.

A code sample may help.

Chris J
www.redash.org

Thank you and Shahriar for the answers. There is nothing special with the source code and it is even located in the same directory as the jQuery. I think it is just related to the way Chrome functions, since it works as expected in the incognito mode.

Here it is a fragment (relevant, I hope):

//...
</style>

<script type="text/javascript" src="jquery-1.5.min.js"></script>

<script type="text/javascript">

var x = 10;

$(window).load( // error here, $ unknown
function()
{
console.info("jquery loaded");
testLoad();
});

//...

Bogdan Rechi.

I ran this code without error in Chrome v9.0.597.98 beta without issue under the normal mode. Under firefox and IE it complained about console not not being defined.

<html>
<head>
<script type="text/javascript" src="jquery-1.5.min.js"></script>
<script type="text/javascript">

var x = 10;
function testLoad()
{
	alert("hi");
}

$(window).load( // error here, $ unknown
function()
{
console.info("jquery loaded");
testLoad();
});
</script>
</head>
<body>
<p>Testing jQuery</p>
</body>
</html>

Chris J
www.redash.org

Hi,
you need to provide your HTML code where you referenced the jQuery in order to investigate the issue. As of now it seems you are missing relative path respect to your application.

You should provide HTML code and also mention Directory structure where are you store .js file, this may helpful to diagnose the problem. Thumbs Up | :thumbsup:

sunaSaRa Imdadhusen
+91 99095 44184
+91 02767 284464

<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.5.0/jquery.min.js"></script>

I hope the above information will be helpful. If you have more concerns, please let me know.

Hello all,

I have a simple web form that use an email address to send information once it's submitted. I need to modify it to where it sends the info to an access database. How can I make that happen?

javascript file:

//collects the data
 function submitForm() {
	document.getElementById('apply').submit();
        clearForm();
}
//clears the form
 function clearForm(){

  	var i;
        for (i = 0; (i < document.forms.length); i++) {
         document.forms[i].reset();
  }
}

//create the  drop down list
function addOption(selectbox,text,value ){
	var optn = document.createElement("option");
	optn.text = text;
	optn.value = value;
	selectbox.options.add(optn);
}

function addOption_list(){
	var quan = new Array("1","2","3","4","5+");
	for (var i=0; i < quan .length;++i){
	
	addOption(document.apply.quantity, quan[i], quan[i]);
	}
}

function addOption_list2(){
	var quan = new Array("1","2","3","4","5","6","7","8","9","10+" );
	for (var i=0; i < quan.length;++i){
	
	addOption(document.apply.quantitys, quan[i], quan[i]);
	}
}

//switches between divs when one of the radio button is checked
  function toggle(obj) {
    var busDiv = document.getElementById('busi');
    var indDiv = document.getElementById('ind');

        if (obj.value == 'business'){
            busDiv.style.display = '';
            indDiv.style.display = 'none';
        }          
        else{
            busDiv.style.display = 'none';
            indDiv.style.display = '';
        }
      	                      
  }

web form:

<?xml version="1.0" encoding="UTF-8" ?>

<!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" xml:lang="en" lang="en">

<head>
	<title>Untitled</title>
	<link href="wireless.css" rel="stylesheet" type="text/css"/>   
	<script type="text/javascript" src="form.js"></script>
</head>

<body onload="addOption_list(); addOption_list2(); divSelection()" >

   <div id="outer">
   	<img src="" alt="logo" usemap="#logomap" class="carrierLogo" />
	  <map id="logomap" name="logomap">
		<area shape="rect" coords="0,0,399,120" href="#" alt="home"/>
	  </map>
	  
   <div id="inner">	
	<form id="apply" name="apply" action="mailto:info@donate.com" method="post" enctype="text/plain">
	
	<fieldset>
	 	<legend>Donor Type</legend>
		   <label for="donerType">
		     <input type="radio" id="businessDoner" name="donerType"  value="business" checked="checked" onclick="toggle(this); " />
		   		  Business
		   </label>
		   
		   <label for="donerType">
		   	 <input type="radio" id="individualDoner" name="donerType" value="individual" onclick="toggle(this)" />
		   		  Individual
		   </label>
	 </fieldset>
	 
	 
	 <fieldset id="contact" >
	 	<legend>Donor Information</legend>
	 	<div id="busi" >
                       fields..
                      ..

                      more fields..
	    </div>
	 	
                <div id="ind" style="display: none" >
                       fields..
                      ..

                      more fields..
	  </div>
	 </fieldset>

	 
	 <div>
		<label for="submitBtn">Submit <input type="button" value="Submit" onclick="submitForm();" id="submitBtn"/></label>
		&nbsp;&nbsp;&nbsp;&nbsp;<label for="cancelBtn">Cancel <input type="reset" value="Cancel"  id="cancelBtn"/></label>
	</div>
	
	</form>
	
</div>
</div>
</body>
</html>

Microsoft Access database is very Heavy and not recommended.

PHP + MySQL is recommended.

You can easy learn yourself:

DB Connect[^]
Insert Data[^]
MySQL Select[^]

Yeah that's what I ended up doing Smile | :)

Thanx for the reply though!

Can anyone help me out I'm a bit stuck on how to create a javascript array from some XML.

I've been trying to debug javascript code(not java) for Google (Spreadsheet) documents and there are no useful debugging facilities.

As their spreadsheet contents are manipulated through a javascript array, I downloaded the spreadsheet as an *xls file imorted it into MSAccess then exported the table to XML. This not only gives me the XML file but also the schema if I need it. By using a HTML wrapper I can now import the replica XML data and external javascript files into an environment which CAN be debugged properly. e.g. Firefox with Firebug, or similar

Ignoring schemas if possible, How do I best convert XML back into a javascript array? Once i have solved this, I think it my home-made IDE will be of use to others experiencing the same debugging problems.

JSON Tutor[^]

Please just go through JSON. I think that may be of some help Smile | :)

Hi,

I would like to check if a session has expired using Javascript without renewing the session.

Does anyone have any ideas?

Thank you

At the moment I have code that just before the session expires displays a message to the user asking them to confirm they are still there. This message is triggered using setTimeout() in JavaScript. From this point onwards I would like to call a server-side (c#) function to periodically check if the session has expired, until the session has expired. Is there a way I can call a server-side function from JavaScript without renewing the session?

I tried calling a [WebMethod] c# function but it seems these calls renew the session as it never replies that the session has expired.

Any help would be really appreciated.

Thank you,
Mel

guys, i use this code to get the the size of the file to upload
but i get the exception "Automation server can't create object"

JavaScript

function GetFileSize(filespec)
{
    var filesystemobject = new ActiveXObject("Scripting.FileSystemObject");
    var file = filesystemobject.GetFile(filespec);
    return file.Size;
}

please, Help me.

Help people,so poeple can help you.

Did you try to google for an answer? On the first page I found this[^]

Wout Louwers

Sir, I put my path and server on the RemoteText.wsf file, but this didnt work.

HTML

<package>
<job>
<script language="VBScript">
set oController = CreateObject("WSHController")
set oProcess = oController.CreateScript("D:\Work\RemoteFile.wsf", "localhost")
WScript.ConnectObject oProcess, "remote_"
oProcess.Execute
While oProcess.Status <> 2
   WScript.Sleep 100
WEnd
WScript.Echo "Done"

Sub remote_Error
	Dim theError
	Set theError = oProcess.Error
	WScript.Echo "Error - Line: " & theError.Line & ", Char: " & theError.Character & vbCrLf & "Description: " & theError.Description
    	WScript.Quit -1
End Sub

</script>
</job>
</package>

Help people,so poeple can help you.

Did you try to register the WScript object as stated in the article?

Wout Louwers

ok, sir.
is there any way to obtain the file size other than ActiveX(Since ActiveX is not supported on operating systems other than windows)

Help people,so poeple can help you.

Not that I know of. Sorry.

Wout Louwers

Try this :
1. Go to internet explorer, Tools menu -> Internet options
2. Go to second tab -> Security
3. Enable ActiveX controls and plug ins options.

Hope this helps.
All the best.

thank you, sir;

but i don't think that ActiveX works on other browsers (like Fire Fox) or Operating Systems (like Linux) so, i quit using ActiveX.

100 Rose | [Rose]

, man.

Help people,so poeple can help you.

Hi there,

you got any workaround for this problem..? or any solution..??
i'm also facing the same problem.. Frown | :(

no; sir.

Help people,so poeple can help you.

Hi guys,nice to meet you all,
i create a .js file which contains a formular:

Ext.onReady(function(){
var bd = Ext.getBody();
var text1=new Ext.form.TextField({
                        id :"Name",
                        fieldLabel: 'Name',
                        name: 'first',
                        width:190})
var text2=new Ext.form.TextField({
                        id :"CarteIdentité",
                        fieldLabel: 'N°CIN',
                        name: 'last',
                        width:190})
var text3= new Ext.form.TextField({
                        id :"Matricule",
                        fieldLabel: 'Matricule',
                        name: 'Matricule',
                        width:190})
var field = new Ext.form.FieldSet({
                title: 'Contact Information',
                autoHeight: true,
                defaultType: 'textfield',
                items: 
             [text1,
               text2,
               text3]
        })
 var form = new Ext.form.FormPanel({
 defaultType: 'textfield',
 bodyStyle:'padding:5px 5px 0',
 //layout:'absolute',
 items :field
 });
 var window = new Ext.Window({
        width: 500,
        height:300,
        minWidth: 300,
        minHeight: 200,
        layout: 'fit',
        plain:true,
        bodyStyle:'padding:5px;',
        buttonAlign:'center',
        items: form,
	buttons: [{
            text: 'Valider',
            handler : function ()
            {
                Ext.Ajax.request({
                     url: "../Application.aspx"
                    ,params: {Action :'SaveData',
                              Name : document.getElementById("Name").value,
                              CarteIdentité : document.getElementById("CarteIdentité").value,
                              Matricule : document.getElementById("Matricule").value}
                    ,method: 'post'
                    ,success: function(response, opts)
                    { Ext.MessageBox.alert('Successful!!!!!!!!!');}
                    ,failure: function(){Ext.MessageBox.alert('Erreur');}
                });
            }
            }]
 })
  window.show();
  // form.render(document.body);

});

I developed with EXT.
when i run the project allways the faailure condition is declared
what is the problem?
I wanna know that the data i fill in the formular will be save in a database.I create .mdf database which contains a table (Name,CIN,Matricule)
How cani do that?
ty