Case Statement problem
I have this query, which works when I substitute the "colnames" with the real data but Dreamweaver refuses to recognize the record set as valid.
Any help here would be very appreciated.
See the photo..
SELECT id, pre_1_reg, title_eve,date_eve, edate_eve, CASE
WHEN colname2='active' AND colname3 ='Current' THEN membApp_eve
FROM Meet_reg LEFT JOIN event ON Meet_reg.pre_1_reg=event.id_eve
WHERE id = colname