gt; Subject: Re: Referencing a query column while still in the query
>
> SELECT d.ItemID, d.Title, d.MediaType,
> (avg(i.BuyersPrice/i.Quantity)
> -avg(q.Cost)*1.175
> -avg(i.BuyersPrice/i.Quantity)*0.15
>
> + CASE mediatype
>
4 8:32 AM
Subject: RE: Referencing a query column while still in the query
I had also considered this but I was just looking for a more "elegant"
solution that got the job done in one go. I am just about to build a new
table with mediatype and shippingcosts in it so I can just joi
SELECT d.ItemID, d.Title, d.MediaType,
(avg(i.BuyersPrice/i.Quantity)
-avg(q.Cost)*1.175
-avg(i.BuyersPrice/i.Quantity)*0.15
+ CASE mediatype
WHEN 1 then 1.1
when 2 then 1
...
END
AS AvgMargin
FROM SomeTables
--- James Smith <[EMAIL PROTE
n [mailto:[EMAIL PROTECTED]
> Sent: 04 August 2004 16:25
> To: CF-Talk
> Subject: Re: Referencing a query column while still in the query
>
> James...you said:
> No good, already considered this but I need to be able to
> sort on the final AvgMargin Column so it must have
Edge Systems Group Inc.
t. 250.920.8830
e. [EMAIL PROTECTED]
- Original Message -
From: James Smith
To: CF-Talk
Sent: Wednesday, August 04, 2004 8:15 AM
Subject: RE: Referencing a query column while still in the query
> No, you can't reference the value of a column wh
> No, you can't reference the value of a column while building
> the query.
> The column doesn't *have* a value in it until the query is
> built, sent, and the results returned.
That is what I figured.
> However, you could create a helper table to hold the
> appropriate information, and gra
to me it seems like there should be a costs table with mediatype and
costs columns, and you should join with that.
--
Hugo Ahlenius
-
Hugo Ahlenius E-Mail: [EMAIL PROTECTED]
Project Officer Phone:
No, you can't reference the value of a column while building the query.
The column doesn't *have* a value in it until the query is built,
sent, and the results returned.
However, you could create a helper table to hold the appropriate
information, and grab it that way.
Or you could march thr
You can't do it in CF, you have to do it in SQL. The easiest way would
be to create a (SQL) function that returns the proper value depending on
the media type.
Pascal
> -Original Message-
> From: James Smith [mailto:[EMAIL PROTECTED]
> Sent: 04 August 2004 17:02
> To: CF-Talk
> Subject: R
9 matches
Mail list logo
