problem with selecting data from a set
Posted: Sun Oct 31, 2004 2:34 pm
Restaurant Search engine:
table 1 is tblAmenityType.
table 2 is tblRestaurantFeatures
Table 1 has 2 fields, amenityID and amenityName.
Table 2 has several fields, one of which is also restID, and the other is restFeatures, which is a set.('1','2','3','4','5'..) I am trying to determine if this is the proper way to use this in my query.
What I am trying to do is create an advanced search, where users can modify their restaurant search based on different features, such as Live Entertainment, Valet Parking, etc. I can't determin how to create a query that will find restaurants that have one of the numbers from the set. If this is confusing, I am trying to determine the query allowing me to modify the search by these features, which I have stored in the "restFeatures" set as 1,2,3 or 1,2 or 3,4 etc. which will correspond to the proper amenityID.
Any help would be greatly appreciated.
table 1 is tblAmenityType.
table 2 is tblRestaurantFeatures
Table 1 has 2 fields, amenityID and amenityName.
Table 2 has several fields, one of which is also restID, and the other is restFeatures, which is a set.('1','2','3','4','5'..) I am trying to determine if this is the proper way to use this in my query.
What I am trying to do is create an advanced search, where users can modify their restaurant search based on different features, such as Live Entertainment, Valet Parking, etc. I can't determin how to create a query that will find restaurants that have one of the numbers from the set. If this is confusing, I am trying to determine the query allowing me to modify the search by these features, which I have stored in the "restFeatures" set as 1,2,3 or 1,2 or 3,4 etc. which will correspond to the proper amenityID.
Any help would be greatly appreciated.