Inserting Date from DateField Component into Access DB

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Anto111 - 20 Nov 2004 21:11 GMT

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

Reply to this Message

J_o_h_n_n_y - 27 Nov 2004 08:09 GMT

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.

Reply to this Message

Anto111 - 28 Nov 2004 01:46 GMT

Thanks,

I appreciate your reply,

Anthony

Reply to this Message

Webmaster Forum / Flash / Flash Remoting / November 2004

Inserting Date from DateField Component into Access DB