JDev

Code, javascriptNovember 19, 2007 8:31 pm

Here is a little function that returns an array of all text fields in a document:

function getAllTextFields(){   

    var texts = [];
    var inputs =      document.getElementsByTagName(’input’);

    for(var i=0; i <inputs.length; i++)
            if(inputs[i].type == ‘text’)
                texts.push(inputs[i]);

     return texts;

Code, oracleNovember 9, 2007 4:03 pm

If your date is of DATE type, you can change the date in Oracle as follows:

select myDateField +1 from myTable : This adds one day to the selected date

select myDateField +(1/24) from myTable : This adds one hour to the selected date 

select myDateField +(1/(24*60)) from myTable : This adds one minute  to the selected date

select myDateField +(1/(24*60*60)) from myTable : This adds one second to the selected date