Harold Larsen
|
| Posted: 01/08/2003, 7:15 PM |
|
With CCS and PHP, MySql, I would like to use a field from my search form to
retrive some 2 add'l fields from an SQL and then use those fields to filter
the grid results as opposed to using the value from the form field. Not
sure how to accomplish this. I have been successful in the before show
event of a record form to do a getparam on my search field, do a query an
end up with the 2 desired fields and use the retrive value for control to
ouput these to my texboxes on the record form, but what I'd really like to
do is use the 2 fields as input to my grid database source filter in the
where clause. Thanks.
|
|
|
 |
RonB
|
| Posted: 01/09/2003, 2:49 PM |
|
Add the to fields to the grid and change from label to hidden. Now the 2
fields don't show in the grid and you can feed the parameters the easy way.
RonB
"Harold Larsen" <hlarsen727@magnaspeed.net> schreef in bericht
news:avipg9$dkt$1@news.codecharge.com...
> With CCS and PHP, MySql, I would like to use a field from my search form
to
> retrive some 2 add'l fields from an SQL and then use those fields to
filter
> the grid results as opposed to using the value from the form field. Not
> sure how to accomplish this. I have been successful in the before show
> event of a record form to do a getparam on my search field, do a query an
> end up with the 2 desired fields and use the retrive value for control to
> ouput these to my texboxes on the record form, but what I'd really like to
> do is use the 2 fields as input to my grid database source filter in the
> where clause. Thanks.
>
>
|
|
|
|
Harold Larsen
|
| Posted: 01/09/2003, 7:08 PM |
|
Thanks.
This has gotten me alot closer. I have added the first field to the grid
(haven't made it hidden yet) and see it shows up. I got it there via source
type Code Expression and $GLOBALS["latddo"], since the variable I created in
the Before Build Select Event of the Grid is called $latddo.
Problem is, I don't know how to refer to this new grid column in my Where
clause of my Data source for the Grid. I have selected the field I want to
coimpare to, and then on the parameter source side of the compare, I don't
know how to refer to my new grid column.
Thanks. I'm almost there.
"RonB" <r.borkent@123chello123.nl> wrote in message
news:avkua1$fmo$1@news.codecharge.com...
> Add the to fields to the grid and change from label to hidden. Now the 2
> fields don't show in the grid and you can feed the parameters the easy
way.
>
> RonB
>
>
> "Harold Larsen" <hlarsen727@magnaspeed.net> schreef in bericht
>news:avipg9$dkt$1@news.codecharge.com...
> > With CCS and PHP, MySql, I would like to use a field from my search form
> to
> > retrive some 2 add'l fields from an SQL and then use those fields to
> filter
> > the grid results as opposed to using the value from the form field. Not
> > sure how to accomplish this. I have been successful in the before show
> > event of a record form to do a getparam on my search field, do a query
an
> > end up with the 2 desired fields and use the retrive value for control
to
> > ouput these to my texboxes on the record form, but what I'd really like
to
> > do is use the 2 fields as input to my grid database source filter in the
> > where clause. Thanks.
> >
> >
>
>
|
|
|
|
|
