I have the following query!
select DISTINCT (stores.id) as single, stores.name, c.styleid,
si.itemid, c.item_type, IFNULL(c.cost_retail,0), si.date_paid
inner join stores on si.storeid = stores.storeid
inner join c on si.itemid = c.itemid
it runs perfect in Mysql editor when i run in cfquery i get the following error
Invalid CFML construct found on line 1 at column 37.
ColdFusion was looking at the following text:
The CFML compiler was processing:
An expression beginning with var.IFNULL, on line 1, column 1.This message is usually caused by a problem in the expressions structure.