Re: webdb - advanced pl/sql

Zdenek Zavadil <zzavadil_at_my-deja.com> wrote in message news:8aiavs$e3a$1_at_nnrp1.deja.com...
> In article <38cc7743$1_2_at_news.ausmail.com>,
> "Mark Hills" <m.hills_at_exec.com.au> wrote:
> > I was wondering if anyone has done much with the option to add one's
> own
> > "Advanced PL/SQL" in webdb?
> >
> > If you have could you please enlighten me as to what sort of things
> you have
> > used this for and the limit of what can be achieved with it?
> >
> > Because I was wondering when building forms(etc) in webdb is it
> possible to
> > use the "Advanced PL/SQL" facility to write code that interacts with
> the
> > values in the forms on the page?
> >
> > For example, in certain situations, I would like to add one or more
> buttons
> > at the bottom of the page that will provide functionality based
> either on
> > default values or ones that the user has entered/selected in one or
> more
> > fields.
> >
> > I've tried various combinations of frame-drivers and qbe forms but I
> don't
> > think that the functionality I want exists in the standard Webdb
> framework.
> >
> > Any thoughts or advice gladly received.
> >
> > Thanks,
> > Mark Hills.
> >
> >
>
> Hi Mark.
> Yes, this kind of functionality doesn't exists in the current version.
>
> When we was faced with similar problem - add some buttons that would
> operate with values in the form - we used JavaScript.
> Usual way to add JS we use is to create procedure, fill it with
> many htp.print() commands, which simply print the JS code,
> and from "Advanced PL/SQL" just call this procedure with
> appropriate arguments.
>
> If you view the source of the page with a form, you can see the
> function findItem() and how it is used in another function checkAll(),
> so we use it in our scripts to access fields.
>
> We also always create forms as "Unstructured" to better control
> the form layout and to insert additional HTML tags (buttons etc.)
>
> HTH,
>
> Zdenek
>
>
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

[Quoted] Many thanks for the advice Zdenek but there's a hole in my knowledge that I [Quoted] was hoping you could take the time to help me with.

I think my problems arise because I don't know enough about javascript.

[Quoted] I understand what you've said about using the javascript methods (such as [Quoted] findItem) to get the value in a field and I understand about defining a [Quoted] input item(button) that when clicked calls that javascript but what happens next?

[Quoted] I assume that the javascript that I have to write, would find out the value [Quoted] of the field I'm interested in and then use that value as part of building [Quoted] up a http request. Is this right? Does the javascript code build up the [Quoted] request dynamically and then submit it?

Am I on the right path here?

Many TIA,
Mark Hills. Received on Thu Mar 16 2000 - 09:56:08 CET