|
|
 |
|
Example 11
|
|
|
|
|
Example 10
Main Menu
Example 12
|
|
|
|
<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
</CFQUERY>
|
|
|
|
<CFOUTPUT QUERY="GetPeople">
#Lname#, #FName#, #Pet_Name#, #TypeOfPet#<BR>
</CFOUTPUT>
|
|
|
|
Clause, Santa Rockin, Adonis, Dog
Clause, Santa Rockin, Blanka, Dog
Clause, Santa Rockin, Korky, Dog
Bunny, Easter, Calvin, Elephant
Skeleton, Jack, Hobbes, Cat
Frost, Jack, Snowball, Snow Snake
Skeleton, Jack, Maggie Moo, Dog
Skeleton, Jack, Slitherin, Snow Snake
|
|
|
|
|
|
|
|
