Reading/Writing data in MS-Access database using javascript

A simplest way to create a application is making a HTML page interact with the database directly. This is possible with javascript.

Code copied from webdeveloper.com

Adding a Record

function AddRecord() {
var adoConn = new ActiveXObject("ADODB.Connection");
var adoRS = new ActiveXObject("ADODB.Recordset");

adoConn.Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source='/\dbName.mdb'");
adoRS.Open("Select * From tblName", adoConn, 1, 3);

adoRS.AddNew;
adoRS.Fields("FieldName").value = "Quentin";
adoRS.Update;

adoRS.Close();
adoConn.Close();
}

Removing a Record

function DeleteRecord() {
var adoConn = new ActiveXObject("ADODB.Connection");
var adoRS = new ActiveXObject("ADODB.Recordset");

adoConn.Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source='\\dbName.mdb'");
adoRS.Open("Select * From tblName Where FieldName = 'Quentin'", adoConn, 1, 3);
adoRS.Delete;
adoRS.Delete;

adoRS.Close();
adoConn.Close();
}

Editing a Record

function EditRecord() {
var adoConn = new ActiveXObject("ADODB.Connection");
var adoRS = new ActiveXObject("ADODB.Recordset");

adoConn.Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source='\\dbName.mdb'");
adoRS.Open("Select * From tblName Where FieldName = 'Quentin'", adoConn, 1, 3);

adoRS.Edit;
adoRS.Fields("FieldName").value = "New Name";
adoRS.Update;

adoRS.Close();
adoConn.Close();
}

Ajax programming with Struts 2

Very useful and handy steps to create AJAX enabled page

javaworld.com Article : Five steps to dynamic tables using Struts 2, Dojo and JSON

Death of a format - HD DVD

BBC report

Toshiba has dropped out of the high-definition DVD battle, saying that it will stop production of its HD DVD players and recorders.

It means victory for Sony's Blu-ray format but will leave questions for all those who bought into the failed format as well as raising issues about whether anyone can benefit from a format war.

Bid farewell to Mouse (device)!!!

Yes, its high time to bid farewell to that pointing device, as touch screens are going to rule the User Interface world in future. After the sucess of iPhone's touch interface, everyone in business have started looking it BIG.

BBC reports that even microsoft have plans to support the touch screen interface in their up coming Windows 7. Microsoft's windows is the commonly used desktop platform across the world, so if 'Windows 7' doesn't need a mouse, new desktop wouldn't be having them. Anyway those desktops should have, much costlier touch screens for interface instead of this cheap device.

If Microsoft is doing this, sure that apple and even Linux touch screen support would come one by one. Then touch screen would be the cat eating our mouse device!

News podcast by All India Radio

"Neengal kettu kodu irrupathu ... aakasavani'in seithi arikai, vasipathi saroj......."

No one could forget these famous line of our national radio.

Now we can listen to the AIR news on net. Even thought the audio quality if not soo good, its an good initiative by AIR.

http://www.newsonair.com/news_schedule.asp

Wishes to my friend

(This was the mail i composed for my friend few months back)

Wish you meet that person, who proposed you first
Wish you accept that now and marry him/her
Wish you get your dream job and earn a lot
Wish you go the top most position in that job
Wish you have as many kids, so they don't let you sleep
Wish you get the best manager awards
Wish you start your own company, and give me a developer job :)
Wish you make your company a billion dollar worth
Wish you become the best employer of that year
Wish you get elected as president of some prestigious institution
Wish you get the Indian of the Year: NRI
Wish you become so famous that a city is named after you!!!

Even with all these happenings, I wish…

Wish you remain the same old friend for me!!!!

Delhi beat Chennai by -1 runs?

Yes, thats what the IPL's official website said (at 7:40pm) about the match (delhi daredevil vs chennai super kings, 8th may), which was a thriller, won by chennai in the last ball. Even though plenty of money has been poured in this event, they couldn't maintain a decent web site. Of-course we can't except more from a politician run BCCI!





[update:
only after an hour (at 8:30 pm) the website got updated correctly]