Hi all,
I think most of our friends do not understand my exact requirement. and here
is the detailed one
i ve two tables with the name category and prods (i m using this temporarily
as i ve not designed my database yet)
CatID Categoryname
1 Category1
2 Category2
3 Category3
4 Category4
5 Category5
6 Category6
prodID Prod Category
1 product1 Category1
2 product2 Category1
3 product3 Category2
4 product4 Category2
5 product5 Category3
6 product6 Category3
7 product7 Category4
8 product8 Category4
9 product9 Category4
10 product10 Category4
11 product11 Category4
12 product12 Category4
Now i need an aspx page which displays these data in the following manner
Category1 Category2
Category3
Product1,Product2,more Product3,Product4,more
Product5,Product6,more
Category4 Category5
Category6
Product7,Product8,more Product9,Product10,more
Product11,Product12,more
\r\n
\r\nIt repeats if there are more categories
\r\n
\r\nPlease tell me how to do this
\r\n
\r\n\r\n",0] ); D(["mi",8,2,"108000a91272bf99",0,"0","Preethiviraj
Kulasingham","Preethiviraj","[EMAIL PROTECTED]","me","5:57 pm (38 minutes
ago)",["sumanth kilari "] ,[] ,[] ,[] ,"Dec 6, 2005 5:57 PM","Re: My
requirement","",[] ,1,,,"Tue Dec 6 2005_5:57 PM","On 12/6/05, Preethiviraj
Kulasingham
wrote:","On 12/6/05, Preethiviraj Kulasingham <[EMAIL PROTECTED]>
wrote:","yahoo.com","yahoo.com",["","",1] ,"",["","",0,""] ,0,,""] );
D(["mb","Can you try with soemthing like this:
Select A.Catagory, Min(A.Prod) +\', \'+B.MinProd Prod from Object A inner
join
(Select Catagory, Min(Prod) MinProd from Object
Group by Catagory) B On A.Catagory \u003d B.Catagory and A.Prod >B.MinProd
Group By A.Catagory, B.MinProd
",1] ); //--> Product9,Product10,more
Product11,Product12,more
It repeats if there are more categories
Please tell me how to do this
---------------------------------
Yahoo! Personals
Single? There's someone we'd like you to meet.
Lots of someones, actually. Yahoo! Personals
[Non-text portions of this message have been removed]
------------------------ Yahoo! Groups Sponsor --------------------~-->
Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life.
http://us.click.yahoo.com/KIlPFB/vlQLAA/TtwFAA/saFolB/TM
--------------------------------------------------------------------~->
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
