Index
Index 2
Why I use Linux and Firefox
HTML DB & Javascript
The Basics
Enable/Disable Form Items
HTML DB Javascript Remix
Show/Hide/Toggle Form Items
htmldb_Get Introduction
AJAX & DHTML
AJAX
Set Multiple Items
(AJAX) Auto Update Report
(AJAX) Collection Control
(AJAX) Process On Demand
(AJAX) Report Pull
(AJAX) Report Row with Detail
(AJAX) Select Items
(AJAX) Set Item Value
(AJAX) Tree
htmldb_Get Aysnc Extension
DHTML
Form Element Focus
Progress Meter On Submit
Region Tabs
Report Row With Detail (iframe)
Report Row with Detail
Shuttle (Item Based)
Shuttle (PL/SQL Based)
Smart Table
List (DHTML Tree)
Show/Hide Report Columns
HTML DB Usage
Linked Reports
HTML/CSS/Layout
HTML DB DHTML Tree
Region Position
Report Row Templates
Multi Region Form Layout
Vertical Aligned Regions
Layout Example
SVG / Canvas
Canvas #1
Custom Charts
Thermometer
Scatter (Coming Soon)
Timeline (Coming Soon)
SVG Knowledge Tree
Pie Chart CSS
Bar Spacing
Application Exports / CSS / JS
Ajax Region Pull
Index
>
AJAX and DHTML
>
(AJAX) Report Pull
Department Select
Department Select
%
ACCOUNTING
OPERATIONS
RESEARCH
SALES
Report Drop
Page 48 Code
Javascript
<script language="JavaScript" type="text/javascript"> <!-- function dhtml_GetReport(pThis){ var l_Val = html_SelectValue(pThis); var get = new htmldb_Get(null,html_GetElement('pFlowId').value,null,47); get.add('P47_DEPT',l_Val) gReturn = get.get(null,'<htmldb:BOX_BODY>','</htmldb:BOX_BODY>'); get = null; html_GetElement('ReportDrop').innerHTML = gReturn; return; } //--> </script>
Select Item Javascript
Report Drop Region Src
Page 47 Code
Page 47 Items
Page 47 contains 1 hidden item named P47_DEPT
Page Template (PPR Minimal) Header
<html lang="en-us"> <head> #HEAD# <title>#TITLE#</title> </head> <body>#FORM_OPEN#
Page Template (PPR Minimal) Body
<htmldb:SUCCESS_MESSAGE><div id="SUCCESS_MESSAGE">#SUCCESS_MESSAGE#</div></htmldb:SUCCESS_MESSAGE> <htmldb:NOTIFICATION_MESSAGE><div id="NOTIFICATION_MESSAGE">#NOTIFICATION_MESSAGE#</div></htmldb:NOTIFICATION_MESSAGE> <htmldb:GLOBAL_NOTIFICATION><div id="GLOBAL_NOTIFICATION">#GLOBAL_NOTIFICATION#</div></htmldb:GLOBAL_NOTIFICATION> <htmldb:REGION_POSITION_01><div id="REGION_POSITION_01">#REGION_POSITION_01#</div></htmldb:REGION_POSITION_01> <htmldb:REGION_POSITION_02><div id="REGION_POSITION_02">#REGION_POSITION_02#</div></htmldb:REGION_POSITION_02> <htmldb:REGION_POSITION_03><div id="REGION_POSITION_03">#REGION_POSITION_03#</div></htmldb:REGION_POSITION_03> <htmldb:REGION_POSITION_04><div id="REGION_POSITION_04">#REGION_POSITION_04#</div></htmldb:REGION_POSITION_04> <htmldb:REGION_POSITION_05><div id="REGION_POSITION_05">#REGION_POSITION_05#</div></htmldb:REGION_POSITION_05> <htmldb:REGION_POSITION_06><div id="REGION_POSITION_06">#REGION_POSITION_06#</div></htmldb:REGION_POSITION_06> <htmldb:REGION_POSITION_08><div id="REGION_POSITION_08">#REGION_POSITION_08#</div></htmldb:REGION_POSITION_08> <htmldb:BOX_BODY><div id="BOX_BODY">#BOX_BODY#</div></htmldb:BOX_BODY>
Page Template (PPR Minimal) Footer
#FORM_CLOSE#</body></html>
Sql
select "EMP"."EMPNO" as "EMPNO", "EMP"."ENAME" as "ENAME", "EMP"."JOB" as "JOB", "EMP"."MGR" as "MGR", "EMP"."HIREDATE" as "HIREDATE", "EMP"."DEPTNO" as "DEPTNO", "EMP"."SAL" as "SAL", "EMP"."COMM" as "COMM" from "EMP" "EMP" where DEPTNO = :P47_DEPT
Notes
Forum Link