I am trying to group my cfquery output by date however as the values the date column also include the time stamp this is causing a problem.
Is there a way that i can make the query only group by the date portion of the datetime stamp as this will then allow me to group all records of the same
Hi Claude,
Here's an example of some code that I use to report activity summarised by
day...
Select count(*) as pageCount, dayOfMonth(activityDate) as dayOfMonth,
activityDate
from Activity
Where activityDate #createODBCDate(startDate)#
And activityDate #createODBCDate(endDate)#
I've got a copy of CF5 (standard) still in the box. Let me know if you want
this.
George
2008/9/2 Ben Snart [EMAIL PROTECTED]
Anyone have a copy of CF8 (standard) they're looking to sell.
If so please let me know.
[EMAIL PROTECTED]
--~--~-~--~~~---~--~~
Claude
You will need to compile your own date as part of the query like
select starttime,
CONVERT(DATE, YEAR(startdate) + '-' + MONTH(startdate) + '-' +
DAY(startdate)) AS startdate,
[from] as sentfrom,
endtime,
subject,
duration,
location,
message,
organizer,
If you're using Oracle then you can simple trunc the date time stamp. Might
work for SQL Server too.
On 03/09/2008, Claude Raiola [EMAIL PROTECTED] wrote:
I am trying to group my cfquery output by date however as the values the
date column also include the time stamp this is causing a
Hi,
to remove the time from a date column I would use (SQL 2000\2005 ETC)
SET DATEFORMAT DMT
SELECT
CONVERT(DATETIME, CONVERT(VARCHAR, MY_DATE_TIME_FIELD, 103))
FROM
XXX
GROUP BY
CONVERT(DATETIME, CONVERT(VARCHAR, MY_DATE_TIME_FIELD, 103))
On 03/09/2008 at 5:58 pm, in message
I have tried the suggestion below however it generates the following error message
Query Of Queries syntax error.Encountered "CONVERT. Incorrect Select
List, Incorrect select column,
Some background: The starttime is being extracted from CFExchangeCalendar from each calendar event found. I
Are you doing is on a query of a query.
Won work, sql only funions.
Regards
Dale Fraser
http://learncf.com http://learncf.com/
http://flexcf.com http://flexcf.com/
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Claude
Raiola
Sent: Thursday, 4 September
Hi thanks for that
So as i am retrieving the data from the cfexchangecalendar tag any suggestions on how can i then query said data so its grouped by starttime (which includes date and time) whilst only using the date portion of the starttime value in order to have all my events grouped by date
Technically it's not another browser to worry about, as it uses
webKit, which is the same rendering engine as Safari... .so if you are
testing for Safari (which you should be anyway), then you know it's
okay.
Mark
On Tue, Sep 2, 2008 at 11:20 PM, Dawesi [EMAIL PROTECTED] wrote:
Google's
Cast your vote for Coldfusion
http://www.extjs.com/forum/showthread.php?t=43322
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
cfaussie group.
To post to this group, send email to cfaussie@googlegroups.com
To
Hi Claude,
If QoQ, try using the CAST function.
http://livedocs.adobe.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/wwhelp.htm?context=ColdFusion_Documentationfile=1271.htm
I haven't tested the following, just guessing what it might be.
If it doesn't work, play around with it and/or
I think the CAST to DATE in query of queries gives a timestamp which
still has the time part, so here's another suggestion:
It's not the most efficient way, but you could try pre-processing the
query data like this so that your startdate value only contains the
date part:
cfset
you can also use it in teaching labs to teach your classes
2008/9/3 João Fernandes [EMAIL PROTECTED]
ok, got it. not much value added in my opinion but if it can benefit
some, better.
--
João Fernandes
Adobe Community Expert
http://www.onflexwithcf.org
http://www.riapt.org
Portugal
picture this:
2003: reluctant IT teacher being dragged kicking and screaming away
from their beloved Microsoft product to teach ColdFusion (much humble
pie consumed later, BTW)
120 students all studying how to build dynamic websites over seven
classes in a single week. the lessons ran twice a
Now..
If you could create application specific DSN's like you can with mappings
now..THAT would be a feature to push for in CF9 for sure!
If there is one thing that IS a pain in the rear in CF is having to go into
the admin to create/manage DSNs
Steve
-Original Message-
From:
You can do it now with the admin api.
Regards
Dale Fraser
http://learncf.com
http://flexcf.com
-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Steve Onnis
Sent: Thursday, 4 September 2008 12:26 PM
To: cfaussie@googlegroups.com
Subject:
From a shared hosting perspective you don’t want to allow access to the
admin api now do you which is where I am coming from. You can add mappings
through the admin api also but they decided to allow application specific
mappings also so I don’t see the difference really.
-Original
This month Steve Onnis will be joining us via Connect to present on
Virtualization and how it can be used in both Server and Development
Environments.
As usual we will have Food, Drinks and time for discussions.
I look forward to seeing you at the September 2008 Coldfusion Usergroup
Please
I'm working on streaming our radio station signal to the web - has
anyone here done it and can spare a few minutes to bring me up to
scratch with what all the issues are please? Im not talking about
podcasts, but 24/7 streaming - if anyone can spare a few minutes for
a phone call from me
and besides, from a classroom perspective...
the students want to go back to their own already set-up workarea
(sandbox) to keep going, even if they're tossed out of one lab at the
end of the lesson
... at least, that's the type of keeness the teacher would hope happens...
On Thu, Sep 4,
21 matches
Mail list logo
