That did the trick, thanks Scott.I was trying to make it too
complicated for myself.
"Case" was the answer.
--
Cheers
Mike Kear
Windsor, NSW, Australia
Adobe Certified Advanced ColdFusion Developer
AFP Webworks
http://afpwebworks.com
ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month
Hi,
This is how I might do it in SQL Server:
SELECT
SUM(CASE WHEN deliverymethod = 'F' THEN
1
ELSE
0
END) AS FAXES,
SUM(CASE WHEN deliverymethod = 'E' THEN
1
ELSE
0
END) AS EMAILS
FR
I have a need to report on various statuses in a status field. The
values in the field can be DX, EM, FX, PT and a few others and i need
to have sql work out how many of each code are in the status field for
a particular day.
I can call all the status field, then loop over it using query of
que
Hi Steve,
I haven't used verity for a while as I've switched to Lucene, but
I'm pretty sure you can only store text in those fields. However you
could serialize a struct into WDDX and dump it in there...
Toby
On 08/05/2007, at 13:15 , Steve Onnis wrote:
>
> Can you put complex val
Can you put complex values into the custom fields?
Am wondering if i can put a structure in there or of they will only
handle simple string values.
Steve
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
"cfaussie"