Re: Access query problem in CF

To: CF-Talk Subject: Re: Access query problem in CF How about this: SELECT COUNT(no_stats) AS nb_visite FROM statistique WHERE datepart(h,statistique.date_in) = 11 Access has a DatePart function like CF does... HTH, Howie --- On Saturday, April 02, 2005 6:04 PM, CFDEV scribed: --- Hi all

Re: Access query problem in CF

Is FORMAT() returning a string or an integer? Have you try WHERE FORMAT(statistique.date_in,hh) = '11' ? -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED])

Re: Access query problem in CF

How about this: SELECT COUNT(no_stats) AS nb_visite FROM statistique WHERE datepart(h,statistique.date_in) = 11 Access has a DatePart function like CF does... HTH, Howie --- On Saturday, April 02, 2005 6:04 PM, CFDEV scribed: --- Hi all, This query works great in Access but through CF

RE: Access query problem in CF

Thanks but it still says too few parameters :( I'm on CFMX 6.1 with a MS Accecss datasource. Pat -Original Message- From: Howie Hamlin [mailto:[EMAIL PROTECTED] Sent: April 2, 2005 19:41 To: CF-Talk Subject: Re: Access query problem in CF How about this: SELECT COUNT(no_stats

RE: Access query problem in CF

Have you looked at the docs for DatePart() in Access? What does it say about the arguments required? Ade -Original Message- From: CFDEV [mailto:[EMAIL PROTECTED] Sent: 03 April 2005 03:49 To: CF-Talk Subject: RE: Access query problem in CF Thanks but it still says too few parameters

RE: Access query problem in CF

Yes, the documentation is exactly what the query is.. And it works in queries of Access, but when I do it through CF it doesn't :( Pat -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: April 2, 2005 21:54 To: CF-Talk Subject: RE: Access query problem in CF Have you