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"
WHERE event_id = 100
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?
Incorrect parameter count in the call to native function 'DATE_FORMAT'
This issue you are having has nothing to do with ColdFusion at all.