Chris You should try posting this to the Torque list, [EMAIL PROTECTED] You'll have a much better chance of getting a solution on that list.
On Wed, 2003-07-23 at 08:44, Chris Rafuse wrote: > Hey Keith, > > Sorry, not quite. I should have been more specific. Here is the table I > have: > > HouseRooms(int houseId, varchar type, varchar description) > > What I want to find out are the homes that have the rooms that I desire. > So if I wanted a home with a grand bedroom, regular study, and an > ensuite bathroom, I would have to join the table with itelf many times > as such: > > SELECT distinct houseId > FROM > HouseRooms AS Bedroooms, > HouseRooms AS Bathrooms, > HouseRooms AS Studies > WHERE > Bedrooms.houseId = Bathrooms.houseId > AND Bathrooms.houseId = Studies.houseId > AND Bedrooms.type = 'grand' > AND Bedrooms.description = 'bedroom' > AND Bathrooms.type = 'ensuite' > AND Bathrooms.description = 'bathroom' > AND Studies.type = 'regular' > AND Studies.description = 'study'; > > > This joins the table with itself and produces homes that have ALL of > these different rooms. I need to do this in torque, but I have no idea > how. Aliasing maybe? > > > Thanks, > > > Chris > > On Tue, 2003-07-22 at 23:19, Keith Seim wrote: > > I'm not a db expert, but I know torque OM objects that relate to > > themselves can work like this: > > (example from my own project) > > > > <table name="Exercise" idMethod="idbroker"> > > <column name="ExerciseID" required="true" primaryKey="true" > > type="INTEGER"/> > > <column name="Name" required="true" size="80" type="VARCHAR" /> > > <column name="Description" type="LONGVARCHAR" /> > > <column name="InstructionsID" type="INTEGER" /> > > <column name="ParentExerciseID" type="INTEGER" /> > > <column name="Expired" type="TIMESTAMP" /> > > <column name="EntryDeleted" type="TIMESTAMP" /> > > <column name="Tag" size="80" type="VARCHAR" /> > > <column name="CourseID" type="INTEGER" /> > > <column name="DateCreated" type="TIMESTAMP" /> > > > > <unique><unique-column name="ExerciseID"/></unique> > > > > <foreign-key foreignTable="Exercise"> > > <reference local="ParentExerciseID" foreign="ParentExerciseID"/> > > </foreign-key> > > > > <foreign-key foreignTable="Instructions"> > > <reference local="InstructionsID" foreign="InstructionsID"/> > > </foreign-key> > > > > <foreign-key foreignTable="Course"> > > <reference local="CourseID" foreign="CourseID"/> > > </foreign-key> > > > > </table> > > > > To see documentation for the resulting OM class, check here: > > http://www.kjsdesigns.com/javadoc/ca/utoronto/utm/datasphere/om/BaseExercise. > > html > > > > > > So then, all you have to do to get the ParentID object is run the: > > Exercise getExerciseRelatedByParentexerciseid() > > method. > > > > I'm not sure if this is what you're wanting - if not, please clarify and > > someone else will help > > > > Cheers > > Keith > > > > On Tuesday, July 22, 2003, at 09:05 AM, Chris Rafuse wrote: > > > > > Hello, > > > > > > Can anyone tell me if you can join a table with itself using torque? And > > > if so, maybe a little example? I need to join a table with itself > > > several times. > > > > > > Thanks, > > > > > > > > > Chris > > > > > > > > > --------------------------------------------------------------------- > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > > > > > ___________________________________ > > Keith Seim • http://kjsdesigns.com > > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] -- Bill <[EMAIL PROTECTED]> --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
