Hi, Can anyone help me to open a Oracle table on a javascript event

[getchandan]

How can I open an Oracle table in a javascript event like "onblur" of a text box.

[dmjpro]

How can I open an Oracle table in a javascript event like "onblur" of a text box.

Go through Ajax.

Kind regards,
Dmjpro.

[gits]

hi ...

dmjpro is right. you cannot create a database-connection with javascript directly, but you may do a background-request (XMLHttpRequest => AJAX) to call a service an the server to do so ... the request object delivers the response in the background too and you may handle it through javascript and you may update a part of your page with it ... so don't need a page-refresh ...

kind regards

[getchandan]

How to open a Oracle table on a javascript event like "onBlur" of a text box... The content of the text box is matched with a table field with the help of WHERE clause of SELECT statement and the abstracted fields are shown on some other text boxes...I need coding help....Thanks.

[dmjpro]

How to open a Oracle table on a javascript event like "onBlur" of a text box... The content of the text box is matched with a table field with the help of WHERE clause of SELECT statement and the abstracted fields are shown on some other text boxes...I need coding help....Thanks.

You know Ajax.
Have a look at this.
Enjoy Ajax.
Good Luck !

Debasis Jana

[getchandan]

You know Ajax.
Have a look at this.
Enjoy Ajax.
Good Luck !

Debasis Jana

Thanks....but problem is that...suppose I have a textbox in my web page and I enter something in the text box, now on the "onblur" event of the text box I need to access a table from oracle database.....using "Select....from <table name> where <field name>="tetxbox_value"......and I need to show the selected value from the table in another text box of the webpage. eg:

<input type="text" name="txtgrp" id="txtgrp_id"  onBlur="openDB()">

openDB()
{
 //coding for opening oracle database and accessing a table using SELECT  statement...How is it possible using Javascript and Ajax.
}

[gits]

threads merged ... please don't double post your questions ...

kind regards

[dmjpro]

Thanks....but problem is that...suppose I have a textbox in my web page and I enter something in the text box, now on the "onblur" event of the text box I need to access a table from oracle database.....using "Select....from <table name> where <field name>="tetxbox_value"......and I need to show the selected value from the table in another text box of the webpage. eg:

<input type="text" name="txtgrp" id="txtgrp_id" onBlur="openDB()">

openDB()
{
//coding for opening oracle database and accessing a table using SELECT statement...How is it possible using Javascript and Ajax.
}

Yeah it is possible.
Go through that Article .....

Debasis Jana