angelo
|
| Posted: 04/09/2002, 12:06 PM |
|
Hi,
I've been developing a portal system that runs off a single page, it
works by having about 10 forms on it, depending on a paramater passed it
shows a different form. Example action=main would show the main page
form and hide the others.
I used templates and use the standard way to hide the form. However this
method only hides the form in the "open" action of code charge.
What I want to make sure is the queries for all 10 forms are not being
executed as this would be a serious waste of resources. I'm assuming
code charge still runs the queries whether or not the forms are shown.
Is there a way to make sure that only the form I want to show executes
it's query and is shown while all others are skipped over?
Thanks,
Angelo
|
|
|
 |
CodeCharge Support
|
| Posted: 04/09/2002, 2:41 PM |
|
The code for hiding the form has an "exit sub" statement that jumps out of
the
sub routine that displays the form. Taking that this code is placed in the
Open
event, no SQL statements have yet been executed at this point.
CodeCharge Support.
"angelo" <nospam@spam.com> wrote in message
news:a8ve3g$jva$1@news.codecharge.com...
> Hi,
>
> I've been developing a portal system that runs off a single page, it
> works by having about 10 forms on it, depending on a paramater passed it
> shows a different form. Example action=main would show the main page
> form and hide the others.
>
> I used templates and use the standard way to hide the form. However this
> method only hides the form in the "open" action of code charge.
>
> What I want to make sure is the queries for all 10 forms are not being
> executed as this would be a serious waste of resources. I'm assuming
> code charge still runs the queries whether or not the forms are shown.
> Is there a way to make sure that only the form I want to show executes
> it's query and is shown while all others are skipped over?
>
> Thanks,
>
> Angelo
>
>
|
|
|
|
angelo
|
| Posted: 04/10/2002, 5:31 AM |
|
Perfect! :) So the works already done and I didn't have to do anything!
Thank you
Angelo
"CodeCharge Support" <Walkerp@codecharge.com> wrote in message
news:a8vn71$71t$1@news.codecharge.com...
> The code for hiding the form has an "exit sub" statement that jumps
out of
> the
> sub routine that displays the form. Taking that this code is placed in
the
> Open
> event, no SQL statements have yet been executed at this point.
>
> CodeCharge Support.
>
>
> "angelo" <nospam@spam.com> wrote in message
>news:a8ve3g$jva$1@news.codecharge.com...
> > Hi,
> >
> > I've been developing a portal system that runs off a single page, it
> > works by having about 10 forms on it, depending on a paramater
passed it
> > shows a different form. Example action=main would show the main
page
> > form and hide the others.
> >
> > I used templates and use the standard way to hide the form. However
this
> > method only hides the form in the "open" action of code charge.
> >
> > What I want to make sure is the queries for all 10 forms are not
being
> > executed as this would be a serious waste of resources. I'm assuming
> > code charge still runs the queries whether or not the forms are
shown.
> > Is there a way to make sure that only the form I want to show
executes
> > it's query and is shown while all others are skipped over?
> >
> > Thanks,
> >
> > Angelo
> >
> >
>
>
|
|
|
|
|
