tag:blogger.com,1999:blog-1561253375800464394.post5344292858110589301..comments2024-03-28T10:48:36.635+01:00Comments on Denes Kubicek ApEx BLOG: Checkbox NightmareDenes Kubicekhttp://www.blogger.com/profile/01962373591521960882noreply@blogger.comBlogger7125tag:blogger.com,1999:blog-1561253375800464394.post-18859960755221146812013-03-27T08:22:44.561+01:002013-03-27T08:22:44.561+01:00hello mate. i wrote you an email to ask for a user...hello mate. i wrote you an email to ask for a user name and a password for apps. can you please answer?<br />thank you.<br />gabrielAnonymoushttps://www.blogger.com/profile/15125041712218041842noreply@blogger.comtag:blogger.com,1999:blog-1561253375800464394.post-47108541016950793032009-09-25T15:01:32.932+02:002009-09-25T15:01:32.932+02:00The checkboxes issue is trivial when you change it...The checkboxes issue is trivial when you change it to ajax. You dont need any more the sloppy approach of two nested loops to iterate through. Simply make a listener in javascript and once triggered a box send it off to a pl sql process on demand. By means of associative arrays you can carry out a query with an O(1). Ajaxized all your applications. That advice is worth more than gold.pepecristiano@yahoo.comnoreply@blogger.comtag:blogger.com,1999:blog-1561253375800464394.post-78704114120441111762009-06-23T11:14:03.870+02:002009-06-23T11:14:03.870+02:00and could be done in APEX 3.0 i suppose (or shoul...and could be done in APEX 3.0 i suppose (or should i upgrade to 3.1 or 3.2). I found this excellent tip : http://apex-smb.blogspot.com/2009/01/apex-report-with-checkboxes-advanced.html<br /><br />I suppose i need to ajaxify my pagination and datagrid rendering.<br /><br />ThanksAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-1561253375800464394.post-72394831172410334342009-06-23T10:46:54.314+02:002009-06-23T10:46:54.314+02:00I could imagine doing that only by using ajax and ...I could imagine doing that only by using ajax and collections.<br /><br />Denes KubicekDenes Kubicekhttps://www.blogger.com/profile/01962373591521960882noreply@blogger.comtag:blogger.com,1999:blog-1561253375800464394.post-68320181065760757022009-06-23T10:01:04.024+02:002009-06-23T10:01:04.024+02:00Hi Denes
Yes checkboxes can be a nightmare in APE...Hi Denes<br /><br />Yes checkboxes can be a nightmare in APEX.<br />Thanks for this article.<br />I checked also this one : <br />http://htmldb.oracle.com/pls/otn/f?p=31517:95:472341346271226:pg_R_4543909217427606558:NO&pg_min_row=1&pg_max_rows=7&pg_rows_fetched=7<br /><br />How can we keep (in session) the checkbox checked in a tabular form or report with pagination , when navigating from one page to another.<br />ThanksAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-1561253375800464394.post-61487278801071283872009-03-23T05:08:00.000+01:002009-03-23T05:08:00.000+01:00Dear Denes,first of all it's a shock to me how com...Dear Denes,<BR/><BR/>first of all it's a shock to me how complicated is the checkbox issue on APEX. I totally agree with your request for the development team. However, lately I just had to make a checkbox involved "delete messages" page and I just managed to make it quite simple. This solution might help other ones thus I'd like to share it.<BR/><BR/>The base of my solution is the APEX-like_AJAX: javascript + on Demand Application Process combo.<BR/>If the checkbox is checked an onChange event triggers an on Demand Application Process which puts the value (here: message ID) into a temporary table. Next, when user clicks the "Delete selected messages" button a page process just makes the rest of the process (erases messages from the table of messages based on the IDs in the temporary table). Last step is to flush the temporary table.<BR/><BR/>Hope someone will find this helpful.<BR/><BR/>All the bests,<BR/><BR/>ZahooAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-1561253375800464394.post-64350022566476520592007-04-19T16:44:00.000+02:002007-04-19T16:44:00.000+02:00Denes,What is the function of the tick boxes?cheer...Denes,<BR/>What is the function of the tick boxes?<BR/>cheers<BR/>BjornAnonymousnoreply@blogger.com