I have a column in my MySQL database typed as DATETIME, and i am trying to pass the value from a datefield in Flex via ColdFusion to the db, but for some reason it's just not hapening, i keep getting errors, here's one of them:
So here's the code i'm using to send it to the db (from Flex):
faultCode:Server.Processing faultString:'Unable to invoke CFC - Error Executing Database Query.' faultDetail:'Data truncation: Incorrect datetime value: '30/06/2009' for column 'date' at row 1'
('ro' is my remote object and 'Insert' is my method for the CFC)
private function insertHandler(event:MouseEvent):void
so here's my CFC code:
I've tried all sorts of different syntax to get this to work, and i'm just out of ideas, do i have to cfset the argument to a data type dd/mm/yyyy (as i belive the MySQL column is in?) or do i have to send another value from the dateField in Flex? ie data instead of text? I have tried that but it didn't seem to work.
<cffunction name="Insert" access="remote" returntype="Any">
<cfargument name="dateInput" type="Date" required="yes">
<cfquery name="qInsert" datasource="#data#">
INSERT INTO testing (date)
Really hoping someone here can help me sort this out
Many thanks in advance guys and gals!!!!!