<div>
select * from myViewOrTable<br />
Order By product, product_type<br />
<br />
I'm not sure what do you mean by select as parent and select as child
</div>


select * from myViewOrTable
Order By product, product_type

I'm not sure what do you mean by select as parent and select as child

<div>
musclejack,<br />
<br />
I answered your last question be giving you an example of data shaping as requested.<br />
<br />
Thanks,<br />
Dominick
</div>


musclejack,

I answered your last question be giving you an example of data shaping as requested.

Thanks,
Dominick

<div>
<div class="content wysiwyg-content">
If I have a view that has 4 fields (customer, product, product type, date - all the fields are not unique and can be both parent or child) For example:<br />
<br />
customer &nbsp; product &nbsp; product type &nbsp; date<br />
ABC &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;BEEF &nbsp; &nbsp; &nbsp; FOOD &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1/1/03<br />
ABC &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;SHIRT &nbsp; &nbsp; CLOTHES &nbsp; &nbsp; &nbsp; &nbsp;2/6/03<br />
BGH &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;APPLE &nbsp; &nbsp; FOOD &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 7/7/02<br />
BGH &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;BEEF &nbsp; &nbsp; &nbsp; FOOD &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 7/7/02<br />
CCC &nbsp; &nbsp; &nbsp; &nbsp; SHIRT &nbsp; &nbsp; CLOTHES &nbsp; &nbsp; &nbsp; &nbsp;5/5/03<br />
<br />
Can you show me how to use data shaping to select * the fields using 'product' as parent and select * the fields using 'product type' as child. <br />

</div>
</div>


If I have a view that has 4 fields (customer, product, product type, date - all the fields are not unique and can be both parent or child) For example:

customer   product   product type   date
ABC          BEEF       FOOD             1/1/03
ABC          SHIRT     CLOTHES        2/6/03
BGH          APPLE     FOOD             7/7/02
BGH          BEEF       FOOD             7/7/02
CCC         SHIRT     CLOTHES        5/5/03

Can you show me how to use data shaping to select * the fields using 'product' as parent and select * the fields using 'product type' as child. 


Data Shaping in ASP

Web development can range from developing the simplest static single page of plain text to the most complex web-based internet applications, electronic businesses, and social network services using a wide variety of languages and standards, including the familiar HTML, JavaScript and jQuery, ASP and ASP.NET, PHP, ColdFusion, CSS, PHP, Flex and Flash, but also the implementation of a broad list of standards including XML, WSDL, SSDL, VoiceXML and many more.