Hamid Sarabi
|
| Posted: 12/10/2002, 7:25 AM |
|
How to make a grid to view a multi table in a tree format or table in table?
we have sql like:
SELECT bugs.*, project_name
FROM bugs INNER JOIN projects ON bugs.project_id = projects.project_id
and want a grid like:
Project Name_1
Bug Id_1 Bug Name_1 Bug Desc_1
Bug Id_2 Bug Name_2 Bug Desc_2
Bug Id_3 Bug Name_3 Bug Desc_3
Project Name_2
Bug Id_1 Bug Name_1 Bug Desc_1
Bug Id_2 Bug Name_2 Bug Desc_2
Project Name_3
Bug Id_1 Bug Name_1 Bug Desc_1
best
HS
|
|
|
 |
Imran
|
| Posted: 12/10/2002, 11:38 AM |
|
I believe they have some info regarding something like this on
http://support.codecharge.com/kb_article.asp?s_keyword=...d=&kb_articlesP
ageSize=10&s_type=&order_by=Freshness&s_cat=&article_id=57
"Hamid Sarabi" <hs@ctek.dk> wrote in message
news:at5120$1br$1@news.codecharge.com...
> How to make a grid to view a multi table in a tree format or table in
table?
>
> we have sql like:
> SELECT bugs.*, project_name
> FROM bugs INNER JOIN projects ON bugs.project_id = projects.project_id
>
> and want a grid like:
>
> Project Name_1
> Bug Id_1 Bug Name_1 Bug Desc_1
>
> Bug Id_2 Bug Name_2 Bug Desc_2
>
> Bug Id_3 Bug Name_3 Bug Desc_3
> Project Name_2
> Bug Id_1 Bug Name_1 Bug Desc_1
>
> Bug Id_2 Bug Name_2 Bug Desc_2
> Project Name_3
> Bug Id_1 Bug Name_1 Bug Desc_1
>
>
>
>
> best
> HS
>
>
|
|
|
|
Imran
|
| Posted: 12/10/2002, 1:04 PM |
|
Sorry, try this link:
http://support.codecharge.com/kb_article.asp?kb_article...4&article_id=57
"Imran" <imranz@knight-images.com> wrote in message
news:at5fsd$t0m$1@news.codecharge.com...
> I believe they have some info regarding something like this on
>
http://support.codecharge.com/kb_article.asp?s_keyword=...d=&kb_articlesP
> ageSize=10&s_type=&order_by=Freshness&s_cat=&article_id=57
>
>
>
>
> "Hamid Sarabi" <hs@ctek.dk> wrote in message
>news:at5120$1br$1@news.codecharge.com...
> > How to make a grid to view a multi table in a tree format or table in
> table?
> >
> > we have sql like:
> > SELECT bugs.*, project_name
> > FROM bugs INNER JOIN projects ON bugs.project_id = projects.project_id
> >
> > and want a grid like:
> >
> > Project Name_1
> > Bug Id_1 Bug Name_1 Bug Desc_1
> >
> > Bug Id_2 Bug Name_2 Bug Desc_2
> >
> > Bug Id_3 Bug Name_3 Bug Desc_3
> > Project Name_2
> > Bug Id_1 Bug Name_1 Bug Desc_1
> >
> > Bug Id_2 Bug Name_2 Bug Desc_2
> > Project Name_3
> > Bug Id_1 Bug Name_1 Bug Desc_1
> >
> >
> >
> >
> > best
> > HS
> >
> >
>
>
|
|
|
|
Hamid Sarabi
|
| Posted: 12/11/2002, 5:23 AM |
|
this comes from Chris K.
I would propose to use simple grid save last row's project name in some
static variable. Every row you check if current project differs from the
last one, if so you parse additional row with project name, if not, you hide
it.
Best regards,
Chris
> How to make a grid to view a multi table in a tree format or table in
table?
>
> we have sql like:
> SELECT bugs.*, project_name
> FROM bugs INNER JOIN projects ON bugs.project_id = projects.project_id
>
> and want a grid like:
>
> Project Name_1
> Bug Id_1 Bug Name_1 Bug Desc_1
>
> Bug Id_2 Bug Name_2 Bug Desc_2
>
> Bug Id_3 Bug Name_3 Bug Desc_3
> Project Name_2
> Bug Id_1 Bug Name_1 Bug Desc_1
>
> Bug Id_2 Bug Name_2 Bug Desc_2
> Project Name_3
> Bug Id_1 Bug Name_1 Bug Desc_1
>
>
>
>
> best
> HS
>
>
|
|
|
|
Hamid Sarabi
|
| Posted: 12/11/2002, 5:25 AM |
|
Any jsp coder out there, who tried this? Please share your code :)
> Sorry, try this link:
>
>
http://support.codecharge.com/kb_article.asp?kb_article...4&article_id=57
>
>
>
> "Imran" <imranz@knight-images.com> wrote in message
>news:at5fsd$t0m$1@news.codecharge.com...
> > I believe they have some info regarding something like this on
> >
>
http://support.codecharge.com/kb_article.asp?s_keyword=...d=&kb_articlesP
> > ageSize=10&s_type=&order_by=Freshness&s_cat=&article_id=57
> >
> >
> >
> >
> > "Hamid Sarabi" <hs@ctek.dk> wrote in message
> >news:at5120$1br$1@news.codecharge.com...
> > > How to make a grid to view a multi table in a tree format or table in
> > table?
> > >
> > > we have sql like:
> > > SELECT bugs.*, project_name
> > > FROM bugs INNER JOIN projects ON bugs.project_id = projects.project_id
> > >
> > > and want a grid like:
> > >
> > > Project Name_1
> > > Bug Id_1 Bug Name_1 Bug Desc_1
> > >
> > > Bug Id_2 Bug Name_2 Bug Desc_2
> > >
> > > Bug Id_3 Bug Name_3 Bug Desc_3
> > > Project Name_2
> > > Bug Id_1 Bug Name_1 Bug Desc_1
> > >
> > > Bug Id_2 Bug Name_2 Bug Desc_2
> > > Project Name_3
> > > Bug Id_1 Bug Name_1 Bug Desc_1
> > >
> > >
> > >
> > >
> > > best
> > > HS
> > >
> > >
> >
> >
>
>
|
|
|
|
michelle
|
| Posted: 12/11/2002, 1:21 PM |
|
OK, Given that you have the apprpriate ORDER BY in the sql.
"Hamid Sarabi" <hs@ctek.dk> wrote in message
news:at7e82$f2p$1@news.codecharge.com...
> this comes from Chris K.
> I would propose to use simple grid save last row's project name in some
> static variable. Every row you check if current project differs from the
> last one, if so you parse additional row with project name, if not, you
hide
> it.
>
> Best regards,
> Chris
>
>
> > How to make a grid to view a multi table in a tree format or table in
> table?
> >
> > we have sql like:
> > SELECT bugs.*, project_name
> > FROM bugs INNER JOIN projects ON bugs.project_id = projects.project_id
> >
> > and want a grid like:
> >
> > Project Name_1
> > Bug Id_1 Bug Name_1 Bug Desc_1
> >
> > Bug Id_2 Bug Name_2 Bug Desc_2
> >
> > Bug Id_3 Bug Name_3 Bug Desc_3
> > Project Name_2
> > Bug Id_1 Bug Name_1 Bug Desc_1
> >
> > Bug Id_2 Bug Name_2 Bug Desc_2
> > Project Name_3
> > Bug Id_1 Bug Name_1 Bug Desc_1
> >
> >
> >
> >
> > best
> > HS
> >
> >
>
>
|
|
|
|
|
