one to many / master detail issue

what is the best way to renerder master detail in ASP with out repeat visits
to the server and recursive queries.

Class 1
Jim jones
Kathy Pho
Class 2
fred smith
scott free

Ive seen code that uses a variable and a loop but they dont seem to be able
to go one level deap and cant handle more complex information that may
happen after the forinstance

Jims house
house ID
Price
number of bathrooms
Number of bedrooms
Pic1
Pic2
Pic3
Address
Phone number
Sallys house
house ID
Price
number of bathrooms
Number of bedrooms
Pic1
Pic2
Pic3
Pic4
Pic5
Pic6
Address
Phone number

where the pictures are comming form a nither table using the property ID in
the relationship.



thanks


Marcel
Marcel [ Mo, 13 Februar 2006 01:23 ] [ ID #1186268 ]

Re: one to many / master detail issue

Marcel wrote:
> what is the best way to renerder master detail in ASP with out repeat
> visits to the server and recursive queries.
>
> Class 1
> Jim jones
> Kathy Pho
> Class 2
> fred smith
> scott free
>
> Ive seen code that uses a variable and a loop but they dont seem to
> be able to go one level deap and cant handle more complex information
> that may happen after the forinstance
>
> Jims house
> house ID
> Price
> number of bathrooms
> Number of bedrooms
> Pic1
> Pic2
> Pic3
> Address
> Phone number
> Sallys house
> house ID
> Price
> number of bathrooms
> Number of bedrooms
> Pic1
> Pic2
> Pic3
> Pic4
> Pic5
> Pic6
> Address
> Phone number
>
> where the pictures are comming form a nither table using the property
> ID in the relationship.
>
>
>
Check this out:
http://groups.google.com/group/microsoft.public.inetserver.a sp.general/msg/133e666175614264

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
reb01501 [ Mo, 13 Februar 2006 12:53 ] [ ID #1186269 ]
Webserver » microsoft.public.inetserver.asp.db » one to many / master detail issue

Vorheriges Thema: Error Type: (0x80020009) Exception occurred.
Nächstes Thema: passing wildcard criteria