Javascript accessing database

[chuahyen]

Is there a way for javascript to access database like Access 2000? If not, i am thinking of using ASP or PHP. However, I am now stuck in how to request ASP to get the required data so that Java script can be used to manipulate the data from ASP.

Please help..

Thanks

[joh6nn]

no, javascript can't access a database. i know that you can pass variables from asp to javascript, and vice versa, but i don't know how.

[ecnarongi]

I know how to do what you are looking for, ASP variables manipulated by JS and vice versa, but I am not clear on what you are asking for. explain

[chuahyen]

Actually, I need to get the data from the database in my web page (either ASP, JSP or PHP). With the data, i need to do processing using javascript with DHTML
e.g.

document.getElementById("flightID" + pageRow).filters.revealTrans.apply();

document.getElementById("flightID" + pageRow).filters.revealTrans.play();

document.getElementById("flightID" + pageRow).innerText= flights[flightArrayIndex[row]];

The data from the database is big. I need to put these data into 10 rows of the table.
Now, in order to show 10 rows of data at a time without a TOTAL PAGE REFRESH of the web browser, i need to replace each content of the table from the data in the database.

Please advise on how to solve this problem

thanks
chris

[whackaxe]

i think you should consider using PHP with a mySQL database. this is the most common script-database combination (i think) and both are very widley used and docmented on the net. PHP supports quite a number of differnt databases but mySQL is the most common with hosts.

[chuahyen]

But does mySQL support unicode? In Access 2000, the character fields are able to upport unicode. Thanks. I will look into PHP with mySQL and javascript.