DataDoIt
|
| Posted: 02/03/2004, 4:44 PM |
|
CCS 2; PHP4; MySQL 4.
I'm attempting to display both header and detail information on the same
page. Header is one grid, and Detail is another grid. For detail, I'm
trying to make it display records based on a Label control in Header. How
do I make detail information display based on a control's value in header?
I've tried inserting a parameter, specifying the control name and type, but
no luck (get a completely blank page). Am I in the right ball park on how
to do this?
|
|
|
 |
DonB
|
| Posted: 02/03/2004, 4:55 PM |
|
I"d have a link in the header grid instead of a label. The href on it would
be to the same page, with a parameter added to indicate the key for the
record you click on. The detail grid needs to have that same parameter
defined in it's datasource, giving it the "WHERE pk=xyz" that selects detail
records. If your detail datasource is setup in this manner but not showing
any data, then maybe it's a problem with the datatype (such as text vs
numeric)?
--
DonB
http://www.gotodon.com/ccbth
"DataDoIt" <mike@datadoit.com> wrote in message
news:bvpf8h$232$1@news.codecharge.com...
> CCS 2; PHP4; MySQL 4.
>
> I'm attempting to display both header and detail information on the same
> page. Header is one grid, and Detail is another grid. For detail, I'm
> trying to make it display records based on a Label control in Header. How
> do I make detail information display based on a control's value in header?
> I've tried inserting a parameter, specifying the control name and type,
but
> no luck (get a completely blank page). Am I in the right ball park on how
> to do this?
>
>
>
|
|
|
|
DataDoIt
|
| Posted: 02/03/2004, 7:42 PM |
|
Rather than using a link to display and update the detail records, I'd like
for the detail to show without having to click anything.
Header (top of page) has a grid that includes information from Table1,
Table2 and Table3.
Detail (bottom of page) has a grid that should include information from
Table4. The link between the two is a field in Table1 and Table4. There
are lotsa records from Table4 for every Table1 record.
When I try to include a parameter in the detail grid that says Table4.Field1
= Table1.Field1, URL, it doesn't display any related records. (no records
found). When I set it to "Control", I get a blank page. I guess my
confusion is what or how should the parameter be set? URL or Control or
otherwise?
I've searched through the sample apps, but can't find anything that will
just display detail -without- clicking a URL and specifying an Href Source.
Thanks.
"DonB" <~ccbth~@gotodon.com> wrote in message
news:bvpft7$3mq$1@news.codecharge.com...
> I"d have a link in the header grid instead of a label. The href on it
would
> be to the same page, with a parameter added to indicate the key for the
> record you click on. The detail grid needs to have that same parameter
> defined in it's datasource, giving it the "WHERE pk=xyz" that selects
detail
> records. If your detail datasource is setup in this manner but not showing
> any data, then maybe it's a problem with the datatype (such as text vs
> numeric)?
>
> --
> DonB
>
> http://www.gotodon.com/ccbth
>
>
> "DataDoIt" <mike@datadoit.com> wrote in message
>news:bvpf8h$232$1@news.codecharge.com...
> > CCS 2; PHP4; MySQL 4.
> >
> > I'm attempting to display both header and detail information on the same
> > page. Header is one grid, and Detail is another grid. For detail, I'm
> > trying to make it display records based on a Label control in Header.
How
> > do I make detail information display based on a control's value in
header?
> > I've tried inserting a parameter, specifying the control name and type,
> but
> > no luck (get a completely blank page). Am I in the right ball park on
how
> > to do this?
|
|
|
|
|
