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.
Nick
See the photo..
SELECT id, pre_1_reg, title_eve,date_eve, edate_eve, CASE
WHEN colname2='active' AND colname3 ='Current' THEN membApp_eve
END
FROM Meet_reg LEFT JOIN event ON Meet_reg.pre_1_reg=event.id_eve
WHERE id = colname