Groups | Blog | Home
all groups > macromedia flash flash remoting > november 2004 >

macromedia flash flash remoting : Inserting Date from DateField Component into Access DB


Anto111
11/20/2004 9:11:02 PM
Hi All, I am practicing sending data to an access database using remoting and
coldfusion. I have a problem inserting the date selected from the DateField
component into the database. I send datefield.selectedDate as an argrument to
the coldfusion function and have tried each of the following so it can be read
into the database but neither work. <CFQUERYPARAM CFSQLTYPE='CF_SQL_DATE'
VALUE='#Arguments.pudate#'> and #CreateODBCDate(Arguments.pudate)# I'd
apprecate any help you can give with this, Anthony
J_o_h_n_n_y
11/27/2004 8:09:29 AM
I believe the problem is that you are tring to send a Date OBJECT to Coldfusion
instead of a Date STRING.

DateField.selectedDate returns a Date Object, so to send it properly, you
would have to send:

(DateField.selectedDate.getMonths()+1) + "/" +
DateField.selectedDate.getDate() + "/" + Datefield.selectedDate.getFullYear();

Or something to that effect.

Anto111
11/28/2004 1:46:12 AM
Thanks,

I appreciate your reply,

AddThis Social Bookmark Button