Application Express :: Value Changed By JavaScript Submitted As Null When Using $x_disableItem?

Oct 21, 2012

Had some issues with a page on which i changed the value of an item using javascript and added a dynamic action (dummy pl-sql) that submitted the item. The problem was that if i also used $x_disableItem to disable the item in the function that set the value , the value submitted was always null. However if i used the "Disabled" attribute from the item Settings and remove the calling $x_disableItem in the function, the value submitted is correct.

To reproduce , create these objects on a page (default everything not specified):

<li>P1_VALUE - textfield
<li>P1_SET_VALUE - button calls "javascript:setValue();"
<li>P1_SUBMIT - submits the page
<li>Dynamic action:
- Event - Before Page Submit
- Execute PL-SQL (begin null; end;) - Page item to submit P1_VALUE

[code]....

So i have two questions:

1) Why is the implementation different (would have expected to behave in the same way)?

2) When using the javascript API function $x_disableItem , why is the value submitted null?

P.S: For the workaround i removed the $x_disableItem call with calling a custom function that toggles the read-only attribute of a given item.

View 2 Replies


ADVERTISEMENT

Application Express :: Page Items Values Don't Get Submitted In Add_member Collection 4.2

Jun 10, 2013

The values in the page item dont get submitted hence generate errors in my application , in apex 4.2 using collectionEg.

apex_collection.add_member(p_collection_name => 'ORDER',     p_c001 => :P56_product_id,     p_c002 => :P56_product_name,    p_c003 => :P56_list_price,    p_c004 => 1);  

Can there be a reason why ?

View 4 Replies View Related

Application Express :: Set Popup LOV Value From JavaScript?

Sep 3, 2013

I use APEX 4.2.2 and in my page I call a Modal Region to insert a new customer using AIAX and OnDemand PL/SQL process, then I need to set the inserted value into the Popup LOV from javascript. I used the code

:$('dialog').dialog('close');$('P20_CUSTOMER').trigger('apexrefresh');$('P20_CUSTOMER').one('apexafterrefresh', function()  { apex.item('P20_CUSTOMER').setValue(ajaxResult, $v('P20_DESCRIPTION'));} 

where P20_CUSTOMER is the Popup LOV, ajaxResult is the PK returning from the OnDemand PL/SQL process and P20_DESCRIPTION is an APEX Item of the Modal Region. The new customer is inserted successfully into the table and the PK value returned to javascript code, but the new value is not displayed into the LOV.

View 1 Replies View Related

Application Express :: Display Only And JavaScript

Oct 26, 2012

I have two Select Lists P58_TYPE_DOC (it shows for users that have not adm profile) and P58_TYPE_DOC_ADM (it shows just for administrator).

On my Page proprieties I have on HTML Header this code :

onload="show_fk_facture('P58_TYPE_DOC');show_fk_facture('P58_TYPE_DOC_ADM');"

I have to execute the java script when the page loads, but I cant execute the function for both items in the same time.

Because one of the items will be hidden, and the java script won't be able to find it.

I tried to use "if isNAN('P58_TYPE_DOC') else ....." but it doesnt work.

View 11 Replies View Related

Application Express :: Set Variable Via Javascript

May 16, 2013

I got a long string (length exceeds 32512) from Javascript, and want to pass the sting to a variable to a item called P_SQL

I use *$x("P_SQL").value* in javascript to set the value, but my process couldn't get the value before I submit, however, when I do submit it reports an error like this : Bad Request

Your browser sent a request that this server could not understand.mod_plsql: /pls/alq/wwv_flow.accept HTTP-400 Value param too long. Length is 216343. Upper limit is 32512

how to handle this conflict ?

View 4 Replies View Related

Application Express :: JavaScript Code In Page Zero?

Sep 27, 2012

I have javascript code i want to move from standard report page to page zero, well page 0 doesn't have html header/page attribute section so how to i achieve this?

View 7 Replies View Related

Application Express :: Use Javascript.addrow() In A New Page?

Oct 5, 2012

In a normal tabular form, with the add, delete, submit option, Under the add button we have the javascript.addrow() call which creates a new row. However, in my case the rows in the tabular form have some columns as display type. So when the user clicks on the add button, he cannot enter all the fields. Is there a way

1. Either to enable all columns of a new row only so that users can add all values and save

2. Or atleast open a new page where the new row is open with all editable fields?

Version:4.1.0
11g

View 1 Replies View Related

Application Express :: Setting MaxDate Using Javascript?

Jun 24, 2013

I am struggling to set the maxDate of a datetimepicker.

In the document load of the page I have this:

$('#P64_STARTDT').datepicker("option", "maxDate", $v('P64_XFORMATSTARTDT'));

P64_XFORMATSTARTDT is in the format YYYYMMDDHH24MI

It never sets it.

View 3 Replies View Related

Application Express :: Difference Between JavaScript And Checkbox

Nov 18, 2013

How to check off checkbox with JavaScript. I tried

1) $("#checkboxID").prop('checked' , false) (jQuery)
2)    $("#checkboxID").attr('checked' , false) (jQuery)2) document.getElementById("checkboxID").checked = false;Checkbox's list of values: STATIC:;1

Checkbox always states checked. When I append 'checked="checked" ' attribute (or simply checked) to this unchecked checkbox in Firebug nothing happens. Why ? I execute JavaScript code in Dynamic Action on button click. All other controls (textareas and textfields) are cleaned successfully except this checkbox. "Effected elements" property includes all needed items.

View 3 Replies View Related

Application Express :: Changing Color Using JavaScript In IE8

Nov 19, 2013

Apex version 4.1.1.00.23IE8 (8.0.7601.17514)Firefox 25.0 

 I have a tabbed form that I need to conditionally disable rows (making them read only). I'm using Javascript to set the attributes of the fields that need to be set.A request was  made to make the font color of the read only fields black so that they're easier to read.I'm not able to get the font changed to black on the fields that are Select Lists in Internet Explorer. They are staying gray, however, they are set to black in Firefox. The JavaScript code for one of the Select List is:   

var curr_id = html_GetElement('f42').id; //Group
$x(curr_id).disabled = true;
$x(curr_id).style.background = "silver";
//$x(curr_id).style.color = "black";
$x(curr_id).style.color = "#000000"; //black

View 7 Replies View Related

Application Express :: Passing Variable To Javascript

Aug 28, 2013

4.1.2theme 24

I have a .js process in the before header of a page which has this pl/sql process using htp script javascript function {code} 

function check(flag_val){ if(flag_val=="N") 
document.getElementById("btn").disabled = true;
else 
document.getElementById("btn").disabled = false;  } 
{code} 

and then there is the actual pl/sql process which  has a cursor 

{code} 
declareflg varchar2(1);
..begin selectflag into v_flagfrom table where rownum = 1;
-- actual conditions are different but this returns one value.

 Then below using htp package I had html table with something like 

<td align="right">
<button class="btn btn-success" type="button" id="btn"  onclick="check(flg);"
title="Accept Lead" style=" width:50px;">Flag value</button> </td>  
 {code}

For some reason the script function is not called if I use onload. If I change the onload to onclick it works. Also, if I pass check(flg) it does not work. If I use check(''N'') then is works fine. question is how do I pass a pl/sql variable flg in this case to a javascript function as a parameter? I basically, want the value of flg checked on page load and then if it is N then disable the button. Or else keep it enabled.

View 0 Replies View Related

Application Express :: Additional JavaScript For Websheet?

Oct 11, 2013

I need some functionality in current (4.2.2) APEX websheet which seems not possible out of the box.Therefore I'd like to ad a javascript to my websheet application.

View 0 Replies View Related

Application Express :: Passing Item Values To Javascript

Nov 23, 2012

APEX 4.2 - Base code from Denes examples

CODE ON HTML HEADER

<script language="JavaScript" type="text/javascript">
function f_setglp(pThis,p_app_item,p_other_record_level_item)
{    
var curr_id = $x(pThis).id; // OK !
var curr_glp = $x(p_app_item).id; // returns undefined
var curr_orli = $x(p_other_record_level_item).id; // returns undefined

[Code]...

The Javasxcript function fires OK on click in the "Product" attribute but: PMO_GLP_PK is an Application Item that Javascript can´t reference as I called YES_NO is another tabular form attribute and the reference returns also "undefined"

what is the best way to implement this ?

View 4 Replies View Related

Application Express :: Updating APEX Collection Via JavaScript?

Aug 1, 2012

Note, I'm using APEX 4.1.1

The scenario is that I have tabular form that was manually created from a collection; the collection name is "COMPANY"

Within this tabular form, I have number of selection lists (apex_item.select_list) and for each, I fire off a JavaScript based on the "onchange" event (e.g.,'onchange="updateCollection(' || seq_id || ', 10, this.value)"'); updateCollection is a custom function I created. Right now, all it does is alert me with the specifics of the of the selection list. As a further example, if I select "Google" from the selection list, sequence id would be "1", attribute number would be "10" and attribute value would be "Google"

Within this JavaScript, I would like to update the value of this associated element in the "COMPANY" collection. Ideally, I would like to directly call this:

APEX_COLLECTION.UPDATE_MEMBER_ATTRIBUTE(p_collection_name => "COMPANY", p_seq => 1, p_attr_number => 10, p_attr_value => 'Google') but I could not figure out how to do this.

View 11 Replies View Related

Application Express :: Javascript Function For Tabular Form Changes?

Apr 12, 2013

I have a tabular form with a few columns. THey are ID, date1, date2 and task_name. The task_name is a drop down list of tasks. Upon selecting a specific task, I want the date1 and/or date2 columns to become read only (voided out) so users cannot enter in data. I am working with a tabular form, so I figured I need a javascript function to handle the logic and to call the function in the html elements of the column in the apex environment. This will need to happen dynamically (on click) before the page is submitted. I am more lost/confused on syntax. I know I will need to know the actual column name (coo1, coo2, something like that) of my columns that I will be refering to when I use javascript.

View 2 Replies View Related

Application Express :: JavaScript API To Set Item Values Not Working In 4.2 EA2?

Aug 7, 2012

I had a complex drill-down dashboard where I was setting page items through $s(Page Item, value) from the Chart Links. But when I did the same thing in APEX 4.2 EA on [URL]...it is simply opening a blank page. whether in 4.2 that Java API has been removed?

View 4 Replies View Related

Application Express :: Error In Javascript Not Fetching Value On Button Click

Nov 23, 2012

I am using APEX 4.1 to build the application. I have 2 select list region in the page where one region consist of certain values.On calling a javascript function it is able to move the value from one select region to another. After this I click on the modify button where in the value move out of the first select list region to the second will be updated in the table.

Although I could see the values are not being updates. On putting alerts after the value being fetched in the javascript function and clicking the Modify button I can see that no data is being reflected in the alert. Hence the data is not being passed from the second select list APEX item to the javascript function.

View 1 Replies View Related

Application Express :: How To Pass A Cursor Result To Javascript Code

Jun 15, 2012

what document I should look for to pass a cursor generated by PL/SQL to java script code in APEX?

View 15 Replies View Related

Application Express :: Unable To Trigger JavaScript From Page Item?

Oct 22, 2013

I am using the following code in Java Script function 

function notNull(object){    if(object.value=="")  alert('This field must contain a value.');  } 

I am then calling the function from one of the page item under HTML Form Element Attributes  by using the following

onblur="notNull(this);"  

But it doesn't seem to work. I am using APEX 4.2.3 

View 3 Replies View Related

Application Express :: JavaScript Assign Value Is Not Visible To Page Process

Aug 21, 2012

I have a page (16) and a tabular form when the user select the check box I update the zero page item

$x('P0_REPORT_REFNO').value=l_value;

this works fine till this point now i have a button will calls page 8 and pass the parameter to page 8 P0_REPORT_REFNO is displaying the selected value but passing null to page 8.I am running the application on apex.oracle.com

View 3 Replies View Related

Application Express :: Capture On Change Event For Select List Using JavaScript

Nov 15, 2012

Is there any way I can capture on change event for the Select List (already created on the page) using java script and then refresh chart region?

View 2 Replies View Related

Application Express :: Syntax Error In Javascript Processing A Tabular Form

Sep 21, 2012

I have the following code which allows me to disable the "f04" field if pThis is set to 'N'

<script type="text/javascript">
function hide_show_comments(pThis){
//get the curren row index on change

[Code].....

View 9 Replies View Related

Application Express :: Change Form Text Field Label Using Javascript

Oct 22, 2013

I have a field that will be providing different info based on document type. I would like to change the field label from javascript in DA. 

View 3 Replies View Related

Application Express :: Turned Out By Disabling Javascript Whole Login Region Disappeared

Nov 8, 2012

Application Express 4.1.1.00.23
Internet Explorer - 8
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

I am about to embark on my first APEX development and have got far as the login screen. I disabled JavaScript just to see what would happen if someone had it disable, it turned out by disabling javascript the whole login region dissapeared. I am wondering how to develop the application so it works when javascript is disabled. I am using the cloudy theme. Not sure how to develop the application as its got to work with JavaScript disabled.

View 11 Replies View Related

Application Express :: Update Record In Another Row When Date Changed

Oct 10, 2013

As all of you know, In the Apex,  when you create a form with report in the page, you are able to insert and edit data. But when you edit the data, the data will be modified in the same row. In other word, you loose the old data.

What I need to do is: I have revised_num field and production_date field. I want to create a form with report and insert and edit data as is in the apex and insert 0 to the revised num until production date is null. But when  production date is not null, then from that point, I want to insert data to another row and modify revised num to 1. and I want the revised num be incremented by 1 each time the user modifies the data after the production date is not null.I don't know where I should start.

View 12 Replies View Related

Application Express :: Changed Date Formats For Several Different Ways

Jul 18, 2013

I have an APEX Page , page no1 for person's details  that got fields like name, Date of Birth. When user enters the details, it get saved. Now when we want to edit a person's details, we click on that person then it goes to next page, where we can change/details of the person.But when i tried to do that, i am getting Not a valid month error.. log message shows that it is coming from : Automatic Row Processing (DML)- an after SUBMIT process. Is there a  way to avoid this error?I changed date formats for several different ways.

View 1 Replies View Related

Application Express :: Execute JavaScript After Update And Submit In Skillbuilders Modal Page

May 13, 2013

I'm editing, say, list of my employees in a tabular form opened in Skillbuilders Modal Page. I have to execute same javascript code after the changes in the tabular form have been submitted.

I've tried using a Dynamic Action fired on Page Load, but that gets executed before the update is completed.

View 4 Replies View Related

Application Express :: Dynamic Actions Call A Javascript Function On All Text Items

Feb 21, 2013

On a tabular form I have 50 columns each an input box , (basically 50 weeks of the year)

in these boxes I want to make them numbers only and max length 2

currently I have in the ELEMENT ATTRIBUTES for each column

OnFocus="javascript:this.maxLength=2"; onKeyPress="return numbersonly(this,event)";

( I have a function called numbers only in page 0 )

what I would like to do , to make it more maintainable is to remove all the calls in the element attributes of each column

and put it in 2 dynamic actions how would I go about this ?

I have tried using jquery selector of input:text to call javascript code on both events , Get focus and Key Press for every text box but its not working .

View 5 Replies View Related

Application Express :: How To Get Checkbox Value When List Value Changed In Classic Report

Dec 26, 2012

I worked with apex 4.2 and i create normal classic report with one checkbox column and one column change it to select list(named loved) now i want when user change list take value of checkbox item and show it in message .

SQL for report

{
SELECT
'<INPUT TYPE="checkbox" NAME="f01" VALUE="'
||SEQ
||'">' SEQ,
ID,
DEPT_NO,
EMP_NAME}

i change the column attributes of Dept_NO to Display as Select list of department name (named lov). Now i want when user change name of department the value of SEQ SHOW IN ALERT MESSAGE

i create JavaScript on the page

function test(pThis) {
var f01_value = $('select[name="f01"]').value;
alert('#SEQ : '+ f01_value);
}
</script>

I call this javascript function when list change but the value undefined..

My Question :

How can get this value Or any value of item in reports ?

View 6 Replies View Related

Application Express :: JavaScript - Execute When Page Loads Not Working When Paging Results Grid

Aug 12, 2013

I have some Javascript in an Apex page, running in 'Execute when page loads'. It does some stuff to a results grid. It works fine on page load, but then doesn't run when I page through, or sort the grid. I presume this is because the grid is being sorted / paged using Ajax, which means the page isn't being fully loaded. Is there anywhere else I can put the code so it gets applied to the grid on sorts and paging?

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved