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
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])
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
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
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
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
6 matches
Mail list logo