RE: [Reactor for CF] sub queries

[Doug Hughes]

This sounds to me like a case where it would be most appropriate to write a custom query.   Doug   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Gareth Cole Sent: Tuesday, June 20, 2006 11:10 AM To: reactor@doughughes.net Subject: [Reactor for CF] sub queries   Hi Doug,   My apologies if this has already been covered, but I couldn’t see anything about this in the list archive.   I’m building a search on a jobs table, in which the user can specify a number of optional criteria e.g. SELECT * FROM jobs WHERE category=X  AND type=Y ……   Doing this in reactor, I’ve found the getByFields(), or using an OOP query in the gateway to work very well.   My problem, is that each job can belong to several locations – this is modelled in the DB using a ‘location’ table and linking via ‘jobLocation’ table. Normally I would use a subquery to allow the user to narrow search results to a particular location e.g. SELECT * FROM jobs WHERE category=X  AND type=Y  AND jobID IN (SELECT jobID FROM jobLocation WHERE locationID=Z)   Is this possible with reactor? If not, it’s no problem as I can very easily build a custom method into my job gateway   Thanks -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List reactor@doughughes.net Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List reactor@doughughes.net Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --