Hi, I'm pretty new to ColdFusion, and I was wondering if someone could give me a little help. I'm getting the following CF error:
Incorrect parameter count in the call to native function 'DATE_FORMAT'
Here's the code that's producing it.
<cfquery name="qryGetDateName" datasource="DATABASE" result="RESULT"> SELECT DATE_FORMAT(Events.event_date,"%W") AS "Date" FROM Events WHERE event_id = 100 LIMIT 1; </cfquery>
When I run this query separately on the database, it executes just fine, but it's giving me this error when I try to execute it from a ColdFusion file. Can anyone help me?