Re: Date format in access
Hassan Arteaga Rodriguez wrote: > In my understanding the date param in access u should use # > Ie: select id_invoice, name where invoice_date=#2003-12-02# That is not necessary. And using cfqueryparam is a best practice. Jochem -- Who needs virtual reality if you can just dream? - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Date format in access
In my understanding the date param in access u should use # Ie: select id_invoice, name where invoice_date=#2003-12-02# regards __ MSc. Hassan Arteaga Rodríguez Microsoft Certified System Engineer. DIGI- Grupo de Desarrollo COPEXTEL, S.A. -Original Message- From: Jochem van [Hassan Arteaga Rodriguez] Dieten [mailto:[EMAIL PROTECTED] Sent: Monday, December 01, 2003 09:26 AM To: CF-Talk Subject: Re: Date format in access Shahzad.Butt said: > > Can someone tell the date format to use in CFQuery in select/insert > statement for an access DB? cfqueryparam + a date object. Jochem _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Date format in access
afaik Now() is already in this format, so you should be able to write either... INSERT INTO foo (dtWhatever) VALUES (#Now()#) or INSERT INTO foo (dtWhatever) VALUES () or maybe even the inbuild access object (for Now() anyway) which i beleve is INSERT INTO foo (dtWhatever) VALUES (Now) HTH -Original Message- From: Dan Farmer [mailto:[EMAIL PROTECTED] Sent: Monday, December 1, 2003 15:46 To: CF-Talk Subject: Re: Date format in access >Hi > >Can someone tell the date format to use in CFQuery in select/insert >statement for an access DB? > >thanks > >Shahzad.Butt >Ph: +44 (0) 1992 701 722 >Fax: +44 (0) 1992 701 604 > > > _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Date format in access
>Hi > >Can someone tell the date format to use in CFQuery in select/insert >statement for an access DB? > >thanks > >Shahzad.Butt >Ph: +44 (0) 1992 701 722 >Fax: +44 (0) 1992 701 604 > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Date format in access
CreateODBCDataTime(somedate) -Original Message- From: Shahzad.Butt [mailto:[EMAIL PROTECTED] Sent: 01 December 2003 15:19 To: CF-Talk Subject: Date format in access Hi Can someone tell the date format to use in CFQuery in select/insert statement for an access DB? thanks Shahzad.Butt Ph: +44 (0) 1992 701 722 Fax: +44 (0) 1992 701 604 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Date format in access
Shahzad.Butt said: > > Can someone tell the date format to use in CFQuery in select/insert > statement for an access DB? cfqueryparam + a date object. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]