|
|
 |
|
Example 12
|
|
|
|
|
Example 11
Main Menu
Example 13
|
|
|
|
<CFQUERY DATASOURCE="#Request.DSN#" NAME="GetPeople">
SELECT FName, LName, Pet_Name, TypeOfPet
FROM People, Pets, PetTypes
WHERE People.PeoCnt = Pets.PeoCnt AND Pets.PetTypeCnt = PetTypes.PetTypeCnt
ORDER BY LName DESC, Pet_Name
</CFQUERY>
|
|
|
|
<CFOUTPUT QUERY="GetPeople">
#Lname#, #FName#, #Pet_Name#, #TypeOfPet#<BR>
</CFOUTPUT>
|
|
|
|
Skeleton, Jack, Hobbes, Cat
Skeleton, Jack, Maggie Moo, Dog
Skeleton, Jack, Slitherin, Snow Snake
Frost, Jack, Snowball, Snow Snake
Clause, Santa Rockin, Adonis, Dog
Clause, Santa Rockin, Blanka, Dog
Clause, Santa Rockin, Korky, Dog
Bunny, Easter, Calvin, Elephant
|
|
|
|
|
|
|
|
