No, it has to be exclusive, where a member has answered two questions with specific answers. It's a profile search thingy.
-----Original Message----- From: Douglas Humphris [mailto:[EMAIL PROTECTED]] Sent: 25 November 2002 17:29 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Dynamic SQL column data Can't you use an OR? (QID = 11 and answer = "whatever" OR QID = 12 and answer = "something") AND Addiitonal requirements here -----Original Message----- From: Snake [mailto:[EMAIL PROTECTED]] Sent: 25 November 2002 17:04 To: [EMAIL PROTECTED] Subject: [ cf-dev ] Dynamic SQL column data Got a bit of a dilemma here. I have data that is stored thus AID QID MID answer 585 11 1016 586 14 1016 619 1 1033 Hmmm 620 15 1033 Creative Partnerships Staff 621 15 1033 Cultural Organisation MID = memberID AID=AnswerID QID = QuestionID I need to pull out all distinct memberID's where they have for example QID = 11 and answer = "whatever" AND QID = 12 and answer = "something" AND Addiitonal requirements here Of course a standard AND wont work as it is different rows not different columns. -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
