APEX-PLUGIN.COM

..the apex plugin directory

an initiative of
 

Compete in the ODTUG APEX   Plugin Competition!

·   Rules on ODTUG

·   Register to submit

·   Winner will be announced at Kscope12!

 

Basic Competition Rules

  • Only new plugins can enter the competition
  • Plug-ins must be submitted by May14,2012
  • Select ODTUG Competition as category
  • Provide an URL to a demo location
  • Source code uploaded to ODTUG Competition category is not downloadable during competition

Add your APEX4.0 Plugin info

Describe your Plugin’s features. You can upload the Plugin’s code and documentation, or, alternatively, submit the URLs to your website or blog.

You are here:
Follow us on Twitter
Dynamic Action Plugin Set Multiple Items

Set Multiple Items

10
Categories: Dynamic Action Plugin
Author: tereska

This plugin allows you to set multiple items witho

The new plugin version (1.1) supports special characters.
 
This plugin allows you to set multiple items without submitting the page. 
 
As a first parameter you need to provide an SQL query which selects values 
that are then populated in the items given in the second parameter. 
Therefore the number of columns should correspond to the number of items.
If this is not the case, depending on which number is smaller, either
less columns will be selected or less items set.
The third parameter is optional and used to submit the value of an item which is included in the query.
 
1. SQL Query (query must not contain comments):
      select ENAME, JOB, HIREDATE, SAL
        from EMP
       where EMPNO = :P1_EMPNO
       -- and ... - this line would break the plugin
2. Page Item(s) to Set:
      P1_ENAME,P1_JOB,P1_HIREDATE,P1_SAL
3. Page Item to Submit:
      P1_EMPNO    
 
Keywords
Set Multiple Items, JSON_FROM_ITEMS, json_SetItems, AJAX, JSON

Oracle APEX Plugin
Company:
Date added: 30.9.2011
Views: 2291
Votes: 1
Reviews: 6
Min. APEX Version:
4.0
Share on Facebook
Digg! Share on Digg
Save This Page
Link to:
Download
download apex plugin
If something is not correct please report it here: Report Listing
Do you have a question about this Plugin? Want to write a Review or Comment?
 Login first.
Reviews / Questions / Comments are e-mailed to the author of the Plug-in.
0 
by tereska
on December 14, 2011
Please let me know if you are setting the third parameter "Page Item to Submit".
December 14, 2011
The Entry has been updated in the meantime!
0 
by Niels
on December 14, 2011
I think that version 1.1 is bugged.
I cannot get it to set any values.
0 
by Niels
on December 14, 2011
I think that version 1.1 is bugged.
I cannot get it to set any values.
0 
by Niels
on December 14, 2011
Thanks :)
December 14, 2011
The Entry has been updated in the meantime!
0 
Special character problem
by tereska
on December 13, 2011
Thank you for pointing this out.
Yes, that is because JSON cannot transport those characters unescaped.
This issue will be fixed in the new version of the plugin. I'm already testing the new version.

Regards.
tereska
0 
by Niels
on December 13, 2011
hi,

it seems that your plugin does not work with values that contain special characters like carriage return, double quote etc.
Powered by Sigsiu.NET RSS Feeds

Disclaimer: The APEX Plugins on this site are not supported by Oracle Support Services.

If you have a question about a Plugin or need support: Login and select the plugin detail page. At the bottom you can enter your Question / Review / Remark.
Your message will be sent to the author of the plugin.