<html>
<head>
<title>Report</title>
</head>
<script language="JavaScript1.2">
function items()
[code]...
I have a text box item "BINDTEST" that has html element set to:onchange="items();"
I have a button with a url redirect of:
javascriptopon[URL}...
When I click on the button, popup window opens with test url but bindtest1 variable is not appended. What is proper form for trying to get value of bind variable in the url.
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.
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.
I have a number of reports subregions in a page . Each of reports sub-region has a HTML text and a cell (report with a single column ) having a count sql . Now , the problem is that the HTML text in some below sub-regions are not getting displayed .. Is there a limit on the no. of sub regions???? Can there be any alternative way to display all the HTML text and the corresponding count sql in a page .
I have select list which has null and other values. I have created a blank HTML region with the following text
Report for the year &P2_YEAR. and for geography &P2_GEOG.
Now P2_YEAR works fine because, it is always populated with a year. However, &P2_GEOG has 'All' as null value since we can see the report for all geographies. However, if the all option is selected, the above &P2_GEOG. shows as null. Since its not a PL/SQL proc, I cannot put in a NVL. I am guessing one possible way is to write a PL/SQL code before region and then check if its null and then try to populate a new hidden field and show, something like that. Wondering if there is a way to do it directly in the HTML region?
I have a requirement to view the PDF content in the apex page region, I am using Apex 3.2 and Oracle 10 Enterprise edition. I Uploaded the PDF file in the shared component under static file. Now i need to view the content of the PDF file. method to view the PDF content.
I saw the link in denes blog here he shows how the PDF is getting displayed. but there is no steps of methods mentioned
I have an apex page with a link on one column for each row. My requirement is as below
When i click on the first time on any of that link, it opens up in a new window and any subsequent clicks should override the previously opened window. So at a time, there should be only 2 windows open..
1) the APEX page 2) The browser window after clicking on an link in apex page
I'm using Apex 4.2. On click of a button, I refresh 2 Standard Region Reports with a Dynamic Action. This dynamic action has been working without problems for WEEKS and all of a sudden i'm getting the ORA-20876: Stop APEX Engine error when I click the button.
In the dynamic action, I removed the refresh of the second report and now the error does not occur. If I add the second refresh action back in, it throws the above error. I've even tried making the second report identical to the first and the refresh action fails. why this is failing on the second refresh action since the second report & region is IDENTICAL to the first report now.
We have many many APEX applications in APEX 3.0 running on a 10.2.0.4 database that needs desperately to be upgraded. As a test, I've set up a clean 11gR2 database and copied the production APEX database into it via datapump. I set up APEX Listener, as I don't have any OAS sitting around and the EPG doesn't seem to be supported for APEX 3.0... the Listener doesn't say one way or the other.
When trying to log in, I get the login page, but it tries to reference files such as apex_get_3_1.js while I only have files such as htmldb_get.js in my images directory in production. I noticed it is looking for what appears to be 3.1 files instead of 3.0 files... which concerns me.
The APEX listener appears to be more than just a Java PL/SQL gateway.
Is there a minimum version of APEX the APEX Listener supports?
The application I am working on uses Oracle HTP procedures to generate HTML pages for our application. I am trying to perform some cleanup when a user closes a web application by clicking the 'X' button in there browser. I am thinking of using the onUnload trigger to call a javascript function, which in turn would call a procedure in my PL/SQL pacakge for cleaning up logical locks on records.
The body tag delaration looks like this code fragment:
Note that clear_locks is a pl/sql stored procedure.So far I have gotten it to pass in the user ID correctly.Is there a way I can call my clear_locks procedure?
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
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.
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
I want to use java-script to open a prompt to see if the user wants to change the date of a work order (Located in Work_order_info called "opened_date")
What I have so far:
var n = prompt("Is the checklist starting now? (Type either y or n)", "y or n"); if (n == "y" || n == "Y"){ alert("The opened date has now been changed!"); }else if (n = "n" || n == "N"){ alert("The opened date has not been changed!"); }else{ alert("You needed to type either n or y, nothing else!"); }
I'm not entirely sure how to tell the table to change the opened_date to sysdate. I'm sure it's really simple >.
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?
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?
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.
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:
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
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.
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.
<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"
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.
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?
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.