macromedia.coldfusion.advanced_techniques
[Top] [All Lists]

Re: Advanced Sarch

Subject: Re: Advanced Sarch
From: "TiGGi"
Date: Sat, 29 Mar 2008 01:38:29 +0000 UTC
Newsgroups: macromedia.coldfusion.advanced_techniques

Hey Phil, thank you again for your help.  Can I bother you once more?
 I am gonna use the query you suggested last, I was wondering what happens if 
user hasn't selected one of the categories?  Isn't this going to bring back 
incorrect result? 


 [q][i]Originally posted by: [b][b]paross1[/b][/b][/i]
 I suppose this equivalent would do the same thing.

 SELECT DISTINCT e.employerID, u.UserID
 FROM employer e, employer_CAT ec, User_CAT uc, employer_LOC el, User_LOC ul, 
employer_DUR ed, User_DUR ud, Users u
 WHERE e.employerID = ec.employerID
 AND ec.CAT = uc.CAT
 AND e.employerID = el.employerID
 AND el.LOC = ul.LOC
 AND e.employerID = ed.employerID
 AND ed.DUR = ud.DUR
 AND uc.UserID = u.UserID
 AND ul.UserID = u.UserID
 AND ud.UserID = u.UserID

 Phil[/q]




<Prev in Thread] Current Thread [Next in Thread>