Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Data Shaping in ASP

Posted on 2003-12-09
3
198 Views
Last Modified: 2010-04-06
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.
0
Comment
Question by:musclejack
  • 2
3 Comments
 
LVL 35

Expert Comment

by:YZlat
ID: 9910239
select * from myViewOrTable
Order By product, product_type

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

Expert Comment

by:NowaY
ID: 9916456
musclejack,

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

Thanks,
Dominick
0
 
LVL 8

Accepted Solution

by:
NowaY earned 500 total points
ID: 9916477
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I will show you how to create a ASP.NET Captcha control without using any HTTP HANDELRS or what so ever. you can easily plug it into your web pages. For Example a = 2 + 3 (where 2 and 3 are 2 random numbers) Session("Answer") = 5 then we…
JavaScript has plenty of pieces of code people often just copy/paste from somewhere but never quite fully understand. Self-Executing functions are just one good example that I'll try to demystify here.
Viewers will learn one way to get user input in Java. Introduce the Scanner object: Declare the variable that stores the user input: An example prompting the user for input: Methods you need to invoke in order to properly get  user input:
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.

789 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question