RE: SQL or CF Code help with extracting distinct values from a list

2003-09-04 Thread S . Isaac Dealey
, I would be ecstatic, but surprised >> ;-) It is a >> complicated set up and one that just could not really be >> explained >> over the list methinks! >> Cheers, >> DC >> -Original Message- >> From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] >

RE: SQL or CF Code help with extracting distinct values from a list

2003-09-03 Thread d.a.collie
roper load which I'll find out with tomorrow's testing... (BTW Oracle 8.1.7) Thanks! DC -Original Message- From: Michael Traher [mailto:[EMAIL PROTECTED] Sent: 03 September 2003 15:53 To: CF-Talk Subject: RE: SQL or CF Code help with extracting distinct values from a list Mic

RE: SQL or CF Code help with extracting distinct values from a list

2003-09-03 Thread Michael Traher
Michael Traher Systems Manager ICLP (London) Tel: UK +44 (0) 20 8256 9072 Fax: UK +44 (0) 20 8681 0234 This e-mail may contain privileged and confidential information and/or copyright material and is intended for the use of the addressee only. If you receive this e-mail by mistake please advise

RE: SQL or CF Code help with extracting distinct values from a list

2003-09-03 Thread d.a.collie
... I'm sure you've been there ;-) Isaac, cheers for your time, I really do appreciate it but I am now halfway built on a method as time is now short. cheers DC -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] Sent: 03 September 2003 14:21 To: CF-Talk Su

RE: SQL or CF Code help with extracting distinct values from a list

2003-09-03 Thread S . Isaac Dealey
nd > not a CF UDF followed by a QoQ, I would be ecstatic, but > surprised ;-) It is a complicated set up and one that just > could not really be explained over the list methinks! > Cheers, > DC > -Original Message- > From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] > S

RE: SQL or CF Code help with extracting distinct values from a list

2003-09-03 Thread d.a.collie
omplicated set up and one that just could not really be explained over the list methinks! Cheers, DC -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] Sent: 02 September 2003 23:51 To: CF-Talk Subject: Re: SQL or CF Code help with extracting distinct values from a l

Re: SQL or CF Code help with extracting distinct values from a list

2003-09-02 Thread S . Isaac Dealey
> -Original Message- > From: David Collie (itndac) > Sent: 02 September 2003 18:22 > To: CF-Talk > Subject: RE: SQL or CF Code help with extracting distinct > values from a > list > Hi Isaac, > Thanks for getting back to me > It's the distinct values in

RE: SQL or CF Code help with extracting distinct values from a list

2003-09-02 Thread d.a.collie
Hi Mike cheers, but not sure your method will work for me, comments as below >> I assume you are already looping over the results? So you could build a list of distinct values, within this loop, record >> at a time. >> i.e. treat parent_answer as a list, for each item in this list do a Lis

RE: SQL or CF Code help with extracting distinct values from a list

2003-09-02 Thread Michael Traher
I assume you are already looping over the results? So you could build a list of distinct values, within this loop, record at a time. i.e. treat parent_answer as a list, for each item in this list do a ListFind comparing to your distinct value list. (will be empty to start with) If you find the va

Re: SQL or CF Code help with extracting distinct values from a list

2003-09-02 Thread d.a.collie
.PARENT_ANSWER); I just know that this is hugely inefficent and was hoping for some pointers for a better way of doing it? -Original Message- From: David Collie (itndac) Sent: 02 September 2003 18:22 To: CF-Talk Subject: RE: SQL or CF Code help with extracting distinct values from

RE: SQL or CF Code help with extracting distinct values from a list

2003-09-02 Thread d.a.collie
x27;ve got :-) Cheers DC -Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 02 September 2003 18:02 To: CF-Talk Subject: Re: SQL or CF Code help with extracting distinct values from a list outside of using distinct in the oracle query just this: select distinct

Re: SQL or CF Code help with extracting distinct values from a list

2003-09-02 Thread info
Subject: Re: SQL or CF Code help with extracting distinct values from a list >Hi there, > >Trying to think of the best way to do this and I know the only way I can >think of it will cause the web server to fall over due to the amount of >data. > >Problem. &