I havethis query
<CFQUERY name="getFundStatus" datasource="xxx">
SELECT (IIf(paybycheck.anonym=1, "anonym", paybycheck.name)) AS name,
city,state,amount,checkdate,anonym
FROM paybycheck
WHERE fund = '#tpcid#'
group by name,city,state,amount,anonym,checkdate
order by name asc
</CFQUERY>
returns "-1" instead of the word "anonym" AS name
I have also tried
SELECT
case when paybycheck.anonym=1 then 'anonym' else paybycheck.name end AS name
FROM paybycheck
WHERE 1=1
and this
SELECT
CASE paybycheck.anonym
WHEN 1 then 'anonym'
WHEN 0 then paybycheck.name
END as name
FROM paybycheck
WHERE 1=1
and a host of variations, at no avail.
These last two, keeps generating the "missing operator in query espression" error.
Any thought?
Thank You
<CFQUERY name="getFundStatus" datasource="xxx">
SELECT (IIf(paybycheck.anonym=1, "anonym", paybycheck.name)) AS name,
city,state,amount,checkdate,anonym
FROM paybycheck
WHERE fund = '#tpcid#'
group by name,city,state,amount,anonym,checkdate
order by name asc
</CFQUERY>
returns "-1" instead of the word "anonym" AS name
I have also tried
SELECT
case when paybycheck.anonym=1 then 'anonym' else paybycheck.name end AS name
FROM paybycheck
WHERE 1=1
and this
SELECT
CASE paybycheck.anonym
WHEN 1 then 'anonym'
WHEN 0 then paybycheck.name
END as name
FROM paybycheck
WHERE 1=1
and a host of variations, at no avail.
These last two, keeps generating the "missing operator in query espression" error.
Any thought?
Thank You