WebDB: dynamic pages with parameters?
Date: Fri, 23 Jul 1999 00:43:49 GMT
Message-ID: <7n8ds2$9ua$1_at_nnrp1.deja.com>
Here's a vague hint from the Creating and Managing Components -User Guide that says you could do it. The question: how do you pass the parameters when showing the page?
"You can add bind variables to a hand-coded SQL query when creating
charts, reports, calendars, frame drivers, and _dynamic pages_.
A bind variable appears in a SQL queries as an alphanumeric string
preceded by a colon (:var1, :var2, :var3,…). For example,
the following SQL query creates parameters for SALARY and DEPT
columns of the SCOTT.EMP table:
select ename, salary, dept
from scott.employee
where salary = :sal and dept like :dept"
BTW, here's all the "example" of dynamic page content from
the "Reference Manual":
select * from scott.emp
That's a damn old joke. May the author of the "Reference Manual" be spit upon by a thousand angry camels with festering gums.
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.
Received on Fri Jul 23 1999 - 02:43:49 CEST