Turns out round is supported in cfquery. Once you have this field you can sort or group or whatever in sql.BlairOn 5/17/06, Blair McKenzie <
[EMAIL PROTECTED]> wrote:Sorry, round has two parameters. Put a 0 as parameter 2.
BlairOn 5/17/06, Blair McKenzie <
[EMAIL PROTECTED]
> wrote:This is valid tr
The first date in my example will be within the
first financial year whenever that is, every date is in a financial year.
Regards
Dale Fraser
From:
cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of KNOTT, Brian
Sent: Wednesday, 17 May 2006 15:11
PM
T
select CONVERT(VARCHAR, (datePart("m", dateColumn) % 7)) + CONVERT(VARCHAR,
datePart("", dateColumn)) AS period,
COUNT(CONVERT(VARCHAR, (datePart("m", dateColumn) % 7)) +
CONVERT(VARCHAR,
datePart("", dateColumn)))
fromdateTest
GROUP BY CONVERT(VARCHAR, (datePart("m", dateCol
For SQL 2000 try:-
select case when datepart(mm,yourdate) < 7 then datepart(,yourdate)-1
else datepart(,yourdate) endcase as finyear
from ...
sort by finyear
group by finyear
Chris
--
Chris Velevitch
Manager - Sydney Flash Platform Developers Group
www.flashdev.org.au
--~--
Andrew that looks awesome - right on target of what I was after!
On 5/17/06, Andrew Muller <[EMAIL PROTECTED]> wrote:
> How about CFCRemoteDocumenter:
> http://www.changemedia.org/cfcremotedocumenter/
>
> Geoff uses it on Full As A Goog and it seems pretty good to me:
>
> http://www.fullasagoog.c
SQL 2000
-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On
Behalf Of Steve Onnis
Sent: Wednesday, 17 May 2006 3:48 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: Dates
what database are you using?
-Original Message-
From: cfaussie@googleg
what database are you using?
-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED]
Behalf Of Chris Velevitch
Sent: Wednesday, May 17, 2006 3:32 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: Dates
On 5/17/06, KNOTT, Brian <[EMAIL PROTECTED]> wrote:
> Th
Nothing for me, but I have a difficult client who is trying to work
with the web service and hes going [paraphrased]
"why is it not .asmx nya nya nya and why do I not get a methods
summary nya nya nya??? "
Hes being a little inflexible if you ask me, and I know (and have told
him) that all the m
How about CFCRemoteDocumenter: http://www.changemedia.org/cfcremotedocumenter/Geoff uses it on Full As A Goog and it seems pretty good to me:
http://www.fullasagoog.com/webservice.cfmAndrewOn 5/17/06, [EMAIL PROTECTED] <
[EMAIL PROTECTED]> wrote:CF doesnt do the nice methods summary when you remov
What's wrong with the xml output you get with enter http://...cfc?wsdl
as the url?
Chris
--
Chris Velevitch
Manager - Sydney Flash Platform Developers Group
www.flashdev.org.au
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Go
On 5/17/06, KNOTT, Brian <[EMAIL PROTECTED]> wrote:
> That only works if you know what financial year you are operating in. I
> want to return all data in a query starting with the first available
> financial year.
It's unclear what you're trying to do. I'm assuming you want to group
the data by
Sorry, round has two parameters. Put a 0 as parameter 2.BlairOn 5/17/06, Blair McKenzie <[EMAIL PROTECTED]
> wrote:This is valid transact sql. You might need to put it in a stored procedure to use it.
round((month(date_field)+2)/14)+year(date_field) as financial_year
This should return the correct
This is valid transact sql. You might need to put it in a stored procedure to use it.round((month(date_field)+2)/14)+year(date_field) as financial_year
This should return the correct year for jan-jun, and year+1 for jul-dec. I don't know how financial years are usually labeled, but if you want to u
Thanks Scott this looks like a good option.
Brian
-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On
Behalf Of Scott Thornton
Sent: Wednesday, 17 May 2006 3:02 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: Dates
Hi,
when I wish to do crazy stuff
That only works if you know what financial
year you are operating in. I want to return all data in a query starting with
the first available financial year.
From:
cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of Dale Fraser
Sent: Wednesday, 17 May 2006
WTF?
Dates are only ordered one of two ways, ascending or
decending.
So if you do something like
Select *
From TableName
Where DateFiled between ‘2005-07-01’
and ‘2006-06-30’
Order By DateField
That will do the trick, but it’s not ordering
it’s the Wh
Hi,
when I wish to do crazy stuff like this, I add to the database a table I
created a few years back, each row contains (from about 1995 to 2015) the date,
week, the finiancial year, the financial quarter and so on.
I simply join on this table and output the required cell, sorted by the date.
with a
union?
select
from july onward and the select the first half as the second query in the
union
Steve
-Original Message-From: cfaussie@googlegroups.com
[mailto:[EMAIL PROTECTED]On Behalf Of KNOTT,
BrianSent: Wednesday, May 17, 2006 2:50 PMTo:
cfaussie@googlegroups
How can I get SQL to order dates by financial year not calendar
year. I want to order a query from1/72005 to 30/06/2006.
Brian Knott
---
This e-mail is sent by Suncorp-Metway Limited ABN 66 010 831 72
That would be: Queensland - Beautiful one day, Gone the next!
B)
Barry Beattie wrote:
>> If you want to see a half-million buck piece of equipment chomping up whole
>> trees and truckloads of vegetation in a way that would make Tim the Tool
>> Man drool with lust,
>
> Between Bris and the Gold
> If you want to see a half-million buck piece of equipment chomping up whole
> trees and truckloads of vegetation in a way that would make Tim the Tool
> Man drool with lust,
Between Bris and the GoldCoast, acres of soon-to-be resdential plots
had about 2m of topsoil and bushland stripped like
Did the trick sure nuff! The video is working now.
As it turns out , there was a setting In a little-traversed area of the control panel to add mime types to IIS myself rather than using the support guy to do it. So i had it fixed in a few minutes.
Brilliant!
If you want to see a half-
CF doesnt do the nice methods summary when you remove the wsdl like on
a .net webservice.
Currently it redirects to the cfide cfcexplorer, but I dont want to
give out my admin password to people trying to build on our webservice.
Any solutions to this?
What spiel do you give out to people tryin
Thanks Andrew, and the others too. I've been worrying away at this for a while, looking for something I've forgotten but in this case it looks like it'll be ok once the support guy fixes the mime type.
I'll let you know how it turns out.
CheersMike KearWindsor, NSW, AustraliaCertified Advance
There was a mime type problem with IIS6, as it didn't know what mimetype the flv
file was it would only run the swf file and load the
flvfile but wouldn't stream it.Solution add the .flv type to the
mime setting under
IISmanager, local computer, properties.On 5/17/06, Kay Smoljak <[EMA
If it's Windows 2003, I think there's a mime type you have to add for
Flash video to work. I remember doing soemthing like that about a year
ago... there was a technote on the macromedia site about it.
On 5/17/06, Mike Kear <[EMAIL PROTECTED]> wrote:
>
> I have a flash movie - a short product vid
Maybe it is a crossdomain.xml issue...
B)
Dale Fraser wrote:
> The swf has nothing in it
>
>
>
> http://redbackgroup.com.au/images/Predator2.swf
>
>
>
> Just shows nothing just like the popup, try uploading it again.
>
> Regards
> Dale Fraser
>
> ---
The swf has nothing in it
http://redbackgroup.com.au/images/Predator2.swf
Just shows nothing just like the popup, try
uploading it again.
Regards
Dale Fraser
From:
cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of Mike Kear
Sent: Wednesday, 17 M
I have a flash movie - a short product video - that works fine on my dev machine. Click the button and the movie opens and plays instantly. (i dont thnk the cause is the patent thing because at the moment I'm only trying to make it work with Firefox - making it work with IE will come next).
> > My understanding is that an include is just the same as if the contents of
> > the include had been typed at the location where the CFINCLUDE tag is.
assigned (before include):#x#
after include: #x#
final: #x#
assigned (before include): 2
after include: 10
final: 12
so they a
Maybe an option could be to get "a" developer and promise to train in ColdfusionOn 13/05/06, Ryan Sabir <
[EMAIL PROTECTED]> wrote:
>
So does that answer your question, Ryan?
Haha, well yes in a roundabout
way :)
In response to some of the
feedback I've been getting, I've removed the p
Maybe you're using the Xerces/Xalan stuff in Java while CF7 is using the crimson parser by default (which it does). I beleive there is a macromedia article on this problem. What I do is put the apache stuff in the java class path before the CF7 standard class path.
Works wondersCheers,SimonOn 17/
You look at the whole fusebox and MVC architecture and it basically ends up generating new cfm templates with alot of cfincludes. If the cfinclude ran in a different thread and its results were lost on return to the calling template then you would not be able to run your queries in the action (mod
Thanks Mike, anyone else have any comment?
On 5/13/06, Mike Kear <[EMAIL PROTECTED]> wrote:
>
> My understanding is that an include is just the same as if the contents of
> the include had been typed at the location where the CFINCLUDE tag is.
> CFINCLUDEs are simply a way of organising the code,
I've done that, logged a bug (#63260) for the
issue and it was verified by Adobe.
Estimated version of getting it fixed: CF 8 alpha
1.
Cheers
Kai
From: cfaussie@googlegroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of M@ BourkeSent:
Tuesday, 16 May 2006 2:03 a.m.To:
cfaussie@googleg
HA!ok, who has their passport? its time to move!On 5/16/06, M@ Bourke <[EMAIL PROTECTED]
> wrote:
http://www.forta.com/blog/index.cfm/2006/5/16/Looking-For-30-ColdFusion-Developers-In-Charlotte-and-Atlanta
A company is putting on 30 CF developersexpect the job to developer ratio to widen even m
http://www.forta.com/blog/index.cfm/2006/5/16/Looking-For-30-ColdFusion-Developers-In-Charlotte-and-Atlanta
A company is putting on 30 CF developersexpect the job to developer ratio to widen even more lolM@
--~--~-~--~~~---~--~~
You received this message because
37 matches
Mail list logo