 |
|
Oracle Tips by Burleson |
HTML DB
URL Format
Understanding the URL used in HTML DB will help
improve a developer’s efficiency. The URL has several distinct
parts. For reference look at the sample URL that follows.
http://localhost:7777/pls/hdb20/f?p=102:3:7646151020298818363::NO::P3_ID:28
http://localhost:7777/pls/hdb20 is the address
used to navigate to HTML DB.
The rest of the URL is actually a call to a stored
procedure within the database named F.
The parameter being passed is a colon delimited string to the P
parameter in the procedure. The values in the colon delimited string
have a specific position they must be presented to the procedure.
These positions are referred to as arguments. The arguments are shown
here.
f?p=App:Page:Session:Request:Debug:ClearCache:itemNames:itemValues:PrinterFriendly
-
App: This is the application ID or the alias
of the application.
-
Page: The page ID to render or the alias name
of the page.
-
Session: A numeric value indicating the
session ID. The session ID is needed so HTML DB knows which session
state to reference.
-
Request: When buttons are pressed, they set
the REQUEST, normally to the name of the button. The next page can
then reference the REQUEST to know the name of the button the user
pressed.
-
Debug: Set this value to YES to display debug
information in the page being rendered.
-
ClearCache: This will clear the cache for an
application page. To clear the cache for multiple pages, a comma
delimited string of page ID’s can be provided. This is a URL
argument to remember. It will be used quite often during
development and testing. It is argument six in the colon delimited
string. To clear cache for the entire application, enter the value
APP for this argument.
-
itemNames: This argument is used to set the
session state of page items. Multiple page items can be set here by
using a comma delimited list. Page items are global so even though
the goal is to navigate to page 100, the session state can be set
for items on other pages or application level items.
-
itemValues: This is partner to the itemNames
argument. These are the values used to set the session state for
the items listed in the itemNames argument.
-
PrinterFriendly: To render the page in a mode
that is better for printing, set this argument to YES. It is then
possible to set the conditional display to Current page is NOT in
Printer Friendly Mode. The page component would then not be
rendered if the PrintFriendly argument is set to YES.
The above book excerpt is from:
Easy HTML-DB
Oracle Application Express
Create Dynamic
Web Pages with OAE
ISBN 0-9761573-1-4
Michael Cunningham & Kent
Crotty
http://www.rampant-books.com/book_2005_2_html_db.htm
|
