RE: [ cf-dev ] Dynamic SQL column data

2002-11-25 Thread Tim Blair
> 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 an

RE: [ cf-dev ] Dynamic SQL column data

2002-11-25 Thread Steve Martin
Sent: 25 November 2002 17:36 > To: [EMAIL PROTECTED] > Subject: RE: [ cf-dev ] Dynamic SQL column data > > > 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.

RE: [ cf-dev ] Dynamic SQL column data

2002-11-25 Thread Snake
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

RE: [ cf-dev ] Dynamic SQL column data

2002-11-25 Thread Snake
] Dynamic SQL column data Not sure I understand. What's the dilemma? And if no dilemma, what's the problem? > -Original Message- > From: Snake [mailto:[EMAIL PROTECTED]] > Sent: 25 November 2002 17:04 > To: [EMAIL PROTECTED] > Subject: [ cf-dev ] Dynamic SQL colum

RE: [ cf-dev ] Dynamic SQL column data

2002-11-25 Thread Snake
An AND only works where you are specify columns that must be exclusive, not rows. -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

RE: [ cf-dev ] Dynamic SQL column data

2002-11-25 Thread Snake
olumn 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

RE: [ cf-dev ] Dynamic SQL column data

2002-11-25 Thread duncan . cumming
cc: Subject: RE: [ cf-dev ] Dynamic SQL column data

RE: [ cf-dev ] Dynamic SQL column data

2002-11-25 Thread Steve Martin
AIL 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

RE: [ cf-dev ] Dynamic SQL column data

2002-11-25 Thread Douglas Humphris
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 ] Dynami

Re: [ cf-dev ] Dynamic SQL column data

2002-11-25 Thread duncan . cumming
"Snake" it.net> cc: Subject:

RE: [ cf-dev ] Dynamic SQL column data

2002-11-25 Thread Steve Martin
Not sure I understand. What's the dilemma? And if no dilemma, what's the problem? > -Original Message- > From: Snake [mailto:[EMAIL PROTECTED]] > Sent: 25 November 2002 17:04 > To: [EMAIL PROTECTED] > Subject: [ cf-dev ] Dynamic SQL column data > > > G

[ cf-dev ] Dynamic SQL column data

2002-11-25 Thread Snake
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 1033Hmmm 620 15 1033Creative Partnerships Staff 621 15 1033Cult