Recreating the vbscript now() function in javascript

I have recently been revamping a feedback mechanism which was built using vbscript, seen as I work on an intranet we were using the now function to take a snapshot of the time that the user made an entry.

As usual the JavaScript equivalent doesn’t work exactly the same, I didn’t want to amend the database structure so instead I thought creating a JavaScript now() function shouldn’t be too difficult. I was right.

Line wraps marked >>

function now(){ var d = new Date(); var day = checker( d.getDate() ); var month = checker( d.getMonth() + 1 ); var year = d.getFullYear(); var hours = checker( d.getHours() ); var minutes = checker( d.getMinutes() ); var seconds = checker( d.getSeconds() ); var str = month + "/" + day + "/" + year + " " >> + hours + ":" + minutes + ":" + seconds; return str; }

Quite simple really, just set the variables and construct the string to look like the VBscript now().

Last thing is the checker function, all that does is add a 0 to the start of any number below 10.

function checker( val ){ if( val < 10 ){ return "0" + val; }else{ return val; }; }

Simple.

Posted on April 25, 2008 at 11:10 pm

With these tags: DOM | Javascript, intranets, MS Access

Connecting to a MS Access Database using JavaScript

I have been searching for a technique to connect to a MS Access database solely using JavaScript for some time now. Until recently I have been totally out of luck.

Before I go on and reveal the method behind the madness let me make a few things crystal clear!

This is 100% advised against for anything other than in-house work e.g. Intranets as it is not a secure method.

So anyway here’s the code to achieve it. (line wraps marked »)

var conn = new ActiveXObject("ADODB.Connection");
var rs = new ActiveXObject("ADODB.Recordset");
conn.ConnectionTimeout = 15; 
conn.CommandTimeout = 15;     
var connStrng = "Provider=Microsoft.Jet.OLEDB.4.0; » 
Data Source=database.mdb; »
Persist Security Info=False"; // remember to escape \ if needed.
conn.open(connStrng);
rs.open("SQL Statement", conn);
var fields=new Array();
var i=0; while(!rs.eof) {
   var  = fields[i]=rs.fields("Field Name").value;
   i++; rs.moveNext();
};
rs.close();
conn.close();

Hope it helps.

Posted on December 20, 2007 at 5:23 pm

With these tags: intranets, JavaScript, MS Access