ers (as opposed to
> parentAnswer)
> 8. Display
> On reflection, we would probably do lots of it different
> ways and the
> reporting side I would be looking to go down the route you
> have
> suggested... but time, resources, the voices from above...
> I'm sure
> you&
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
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
... 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
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
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
> -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
aReturn = ListToArray(returnList);
return aReturn;
}
Thanks all
DC
-Original Message-
From: David Collie (itndac)
Sent: 02 September 2003 19:00
To: '[EMAIL PROTECTED]'
Subject: RE: SQL or CF Code help with extracting distinct values from a
list
Hi Mike.
go (and also solved the
archiving issue we had)... then we introduced PARENT ANSWERS and I'm
kinda stuck again
Does that make sense?
Cheers all for the brain time.
DC
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 02 September 2003 17:35
To: CF-Tal
-Talk
Subject: 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.
Got a query returning something like
.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
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
outside of using distinct in the oracle query just this:
select distinct answer from myotherquery
where parent_answer = '#myparentanswer#'
hth
isaac
-- Original Message --
From: <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Sent: Sep 02, 2003 05:35 PM
HateBluetit, Sparrow
2 LoveSparrow
3 Don't care Bluetit, Crow
4 HateCrow, Budgie
What I need is SQL or CF code
Troy Karjala-Mauz wrote:
> Alle,
>
> I'm having problems figuring how I should write the query(ies), or the CF
> code to accomplish a >= count list. For example:
>
> Table1:
> T1-ID
> T1-Data
>
> Table2:
> T2-ID
> T1-ID
> T2-Data
>
> For each Table1 entry, I can have one or
Alle,
Im having problems figuring how I should write the query(ies), or the CF
code to accomplish a >= count list. For example:
Table1:
T1-ID
T1-Data
Table2:
T2-ID
T1-ID
T2-Data
For each Table1 entry, I can have one or more Table2 entries.
What I need to do is create a li
16 matches
Mail list logo
