Pseudo code, cozz I know it wont work. I basically need to do the equiv of an AND on rows, so a version of this pseudo code that actually works.
Select distinct memberID Where QID = 1 and answer = "this" And QID = 2 and answer = "that" This wont work beacuase it will try and get a row where the columns are equal to both. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 25 November 2002 17:31 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Dynamic SQL column data yeah, i was just pasting in Russ' code though! Duncan Cumming IT Manager http://www.alienationdesign.co.uk mailto:[EMAIL PROTECTED] Tel: 0141 575 9700 Fax: 0141 575 9600 Creative solutions in a technical world ---------------------------------------------------------------------- Get your domain names online from: http://www.alienationdomains.co.uk Reseller options available! ---------------------------------------------------------------------- ---------------------------------------------------------------------- "Steve Martin" <steve.martin@seque To: <[EMAIL PROTECTED]> nce.co.uk> cc: Subject: RE: [ cf-dev ] Dynamic SQL column data 11/25/02 05:30 PM Please respond to dev That wouldn't work as you have conflicting AND statements. You want: SELECT DISTINCT MID FROM Answers WHERE (QID = 11 and answer = 'whatever') OR (QID = 12 and answer = 'something') OR Additional requirements here > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]] > Sent: 25 November 2002 17:29 > To: [EMAIL PROTECTED] > Subject: Re: [ cf-dev ] Dynamic SQL column data > > > > SELECT DISTINCT MID > FROM Answers > WHERE QID = 11 and answer = "whatever" > AND > QID = 12 and answer = "something" > AND > Additional requirements here > > > not sure why that wouldn't work? > > > Duncan Cumming > IT Manager > > http://www.alienationdesign.co.uk > mailto:[EMAIL PROTECTED] > Tel: 0141 575 9700 > Fax: 0141 575 9600 > > Creative solutions in a technical world > > ---------------------------------------------------------------------- > Get your domain names online from: http://www.alienationdomains.co.uk > Reseller options available! > ---------------------------------------------------------------------- > ---------------------------------------------------------------------- > > > > > "Snake" > > <snake@snakep To: > <[EMAIL PROTECTED]> > it.net> cc: > > Subject: [ > cf-dev ] Dynamic SQL column data > 11/25/02 > > 05:04 PM > > Please > > respond to > > dev > > > > > > > > > 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] -- ** 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]
