date:20060516

[cfaussie] Re: Dates

2006-05-16 Thread Blair McKenzie

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 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 use the year they start instead just subtract 1.

Blair
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.

 









From:



cfaussie@googlegroups.com [mailto:


cfaussie@googlegroups.com] On Behalf Of Dale Fraser
Sent: Wednesday, 17 May 2006 3:04
PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: Dates



 

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 Where bit your after.



Regards
Dale Fraser















From:



cfaussie@googlegroups.com [mailto:


cfaussie@googlegroups.com] On Behalf Of KNOTT, Brian
Sent: Wednesday, 17 May 2006 14:50
PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Dates



 

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 722 or one of its related entities "Suncorp". 

Suncorp may be contacted at
Level 18, 36 Wickham Terrace, Brisbane
or on 13 11 55 or at suncorp.com.au. 

The content of this e-mail
is the view of the sender or stated author and does not necessarily reflect the
view of Suncorp. The content, including attachments, is a confidential
communication between Suncorp and the intended recipient. If you are not the
intended recipient, any use, interference with, disclosure or copying of this
e-mail, including attachments, is unauthorised and expressly prohibited. If you
have received this e-mail in error please contact the sender immediately and
delete the e-mail and any attachments from your system. 

If this e-mail constitutes a
commercial message of a type that you no longer wish to receive please reply to
this e-mail by typing Unsubscribe in the subject line. 

 



















--~--~-~--~~~---~--~~
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 unsubscribe from this group, send email to [EMAIL PROTECTED]  For more options, visit this group at http://groups.google.com/group/cfaussie  -~--~~~~--~~--~--~---

[cfaussie] Re: Dates

2006-05-16 Thread Dale Fraser









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
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: Dates



 

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 3:04
PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: Dates



 

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 Where bit your after.



Regards
Dale Fraser















From:
cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of KNOTT, Brian
Sent: Wednesday, 17 May 2006 14:50
PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Dates



 

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 722 or one of its related entities
"Suncorp". 

Suncorp may be contacted at
Level 18, 36 Wickham Terrace, Brisbane
or on 13 11 55 or at suncorp.com.au. 

The content of this e-mail
is the view of the sender or stated author and does not necessarily reflect the
view of Suncorp. The content, including attachments, is a confidential
communication between Suncorp and the intended recipient. If you are not the
intended recipient, any use, interference with, disclosure or copying of this
e-mail, including attachments, is unauthorised and expressly prohibited. If you
have received this e-mail in error please contact the sender immediately and
delete the e-mail and any attachments from your system. 

If this e-mail constitutes
a commercial message of a type that you no longer wish to receive please reply
to this e-mail by typing Unsubscribe in the subject line. 

 

 






--~--~-~--~~~---~--~~
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 unsubscribe from this group, send email to [EMAIL PROTECTED]  For more options, visit this group at http://groups.google.com/group/cfaussie  -~--~~~~--~~--~--~---

[cfaussie] Re: Dates

2006-05-16 Thread Steve Onnis

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", dateColumn) % 7)) +
CONVERT(VARCHAR, datePart("", dateColumn))
ORDER BY CONVERT(VARCHAR, (datePart("m", dateColumn) % 7)) +
CONVERT(VARCHAR, datePart("", dateColumn))

That should do you.  it will create a number that you can order buy on

Just have to adjust it to your database

-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED]
Behalf Of KNOTT, Brian
Sent: Wednesday, May 17, 2006 3:45 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: Dates

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@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:
> 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 financial year.

If that's the case, and you didn't say which database you're using,
write an expression that yields a number for the financial year, say
2005 for the 2005/2006 financial year:-

 case
 when month(d) <7 then year(d)-1
 else year(d)
 endcase

give it a name and then sort and group by it.

Does this help?

Chris
--
Chris Velevitch
Manager - Sydney Flash Platform Developers Group
www.flashdev.org.au

---
This e-mail is sent by Suncorp-Metway Limited ABN 66 010 831 722 or one of
its related entities "Suncorp".

Suncorp may be contacted at Level 18, 36 Wickham Terrace, Brisbane or on 13
11 55  or at suncorp.com.au.

The content of this e-mail is the view of the sender or stated author and
does not necessarily reflect the view of Suncorp. The content, including
attachments, is a confidential communication between Suncorp and the
intended recipient. If you are not the intended recipient, any use,
interference with, disclosure or copying of this e-mail, including
attachments, is unauthorised and expressly prohibited. If you have received
this e-mail in error please contact the sender immediately and delete the
e-mail and any attachments from your system.

If this e-mail constitutes a commercial message of a type that you no longer
wish to receive please reply to this e-mail by typing Unsubscribe in the
subject line.

--~--~-~--~~~---~--~~
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 unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/cfaussie
-~--~~~~--~~--~--~---

[cfaussie] Re: Dates

2006-05-16 Thread Chris Velevitch


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

--~--~-~--~~~---~--~~
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 unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/cfaussie
-~--~~~~--~~--~--~---

[cfaussie] Re: CFC / Webservice summary

2006-05-16 Thread Duncan


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.com/webservice.cfm
>
> Andrew
>
>
> On 5/17/06, [EMAIL PROTECTED] < [EMAIL PROTECTED]> wrote:
> >
>
> 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 trying to integrate with your
> service?
>
>
>
> --
> ---
> Andrew Muller
> http://www.rebelspirit.com.au
>
> >
>
>


-- 
Duncan I Loxton
[EMAIL PROTECTED]

--~--~-~--~~~---~--~~
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 unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/cfaussie
-~--~~~~--~~--~--~---

[cfaussie] Re: Dates

2006-05-16 Thread KNOTT, Brian

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@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:
> 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 financial year.

If that's the case, and you didn't say which database you're using,
write an expression that yields a number for the financial year, say
2005 for the 2005/2006 financial year:-

 case
 when month(d) <7 then year(d)-1
 else year(d)
 endcase

give it a name and then sort and group by it.

Does this help?

Chris
--
Chris Velevitch
Manager - Sydney Flash Platform Developers Group
www.flashdev.org.au

---
This e-mail is sent by Suncorp-Metway Limited ABN 66 010 831 722 or one of its 
related entities "Suncorp". 

Suncorp may be contacted at Level 18, 36 Wickham Terrace, Brisbane or on 13 11 
55  or at suncorp.com.au.

The content of this e-mail is the view of the sender or stated author and does 
not necessarily reflect the view of Suncorp. The content, including 
attachments, is a confidential communication between Suncorp and the intended 
recipient. If you are not the intended recipient, any use, interference with, 
disclosure or copying of this e-mail, including attachments, is unauthorised 
and expressly prohibited. If you have received this e-mail in error please 
contact the sender immediately and delete the e-mail and any attachments from 
your system.

If this e-mail constitutes a commercial message of a type that you no longer 
wish to receive please reply to this e-mail by typing Unsubscribe in the 
subject line.

--~--~-~--~~~---~--~~
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 unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/cfaussie
-~--~~~~--~~--~--~---

[cfaussie] Re: Dates

2006-05-16 Thread Steve Onnis


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:
> 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 financial year.

If that's the case, and you didn't say which database you're using,
write an expression that yields a number for the financial year, say
2005 for the 2005/2006 financial year:-

 case
 when month(d) <7 then year(d)-1
 else year(d)
 endcase

give it a name and then sort and group by it.

Does this help?


Chris
--
Chris Velevitch
Manager - Sydney Flash Platform Developers Group
www.flashdev.org.au





--~--~-~--~~~---~--~~
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 unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/cfaussie
-~--~~~~--~~--~--~---

[cfaussie] Re: CFC / Webservice summary

2006-05-16 Thread Duncan


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 methods are in the wsdl.

So I was wondering if there was something I dont know that can stretch
half way to what he wants.

Duncan

On 5/17/06, Chris Velevitch <[EMAIL PROTECTED]> wrote:
>
> 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
>
> >
>


-- 
Duncan I Loxton
[EMAIL PROTECTED]

--~--~-~--~~~---~--~~
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 unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/cfaussie
-~--~~~~--~~--~--~---

[cfaussie] Re: CFC / Webservice summary

2006-05-16 Thread Andrew Muller

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 remove the wsdl like on
a .net webservice.Currently it redirects to the cfide cfcexplorer, but I dont want togive out my admin password to people trying to build on our webservice.Any solutions to this?What spiel do you give out to people trying to integrate with your
service?-- ---Andrew Mullerhttp://www.rebelspirit.com.au

--~--~-~--~~~---~--~~
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 unsubscribe from this group, send email to [EMAIL PROTECTED]  For more options, visit this group at http://groups.google.com/group/cfaussie  -~--~~~~--~~--~--~---

[cfaussie] Re: CFC / Webservice summary

2006-05-16 Thread Chris Velevitch


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 Google Groups 
"cfaussie" group.
To post to this group, send email to cfaussie@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/cfaussie
-~--~~~~--~~--~--~---

[cfaussie] Re: Dates

2006-05-16 Thread Chris Velevitch


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 financial year.

If that's the case, and you didn't say which database you're using,
write an expression that yields a number for the financial year, say
2005 for the 2005/2006 financial year:-

 case
 when month(d) <7 then year(d)-1
 else year(d)
 endcase

give it a name and then sort and group by it.

Does this help?


Chris
-- 
Chris Velevitch
Manager - Sydney Flash Platform Developers Group
www.flashdev.org.au

--~--~-~--~~~---~--~~
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 unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/cfaussie
-~--~~~~--~~--~--~---

[cfaussie] Re: Dates

2006-05-16 Thread Blair McKenzie

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 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 use the year they start instead just subtract 1.
Blair
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.

 









From:


cfaussie@googlegroups.com [mailto:

cfaussie@googlegroups.com] On Behalf Of Dale Fraser
Sent: Wednesday, 17 May 2006 3:04
PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: Dates



 

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 Where bit your after.



Regards
Dale Fraser















From:


cfaussie@googlegroups.com [mailto:

cfaussie@googlegroups.com] On Behalf Of KNOTT, Brian
Sent: Wednesday, 17 May 2006 14:50
PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Dates



 

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 722 or one of its related entities "Suncorp". 

Suncorp may be contacted at
Level 18, 36 Wickham Terrace, Brisbane
or on 13 11 55 or at suncorp.com.au. 

The content of this e-mail
is the view of the sender or stated author and does not necessarily reflect the
view of Suncorp. The content, including attachments, is a confidential
communication between Suncorp and the intended recipient. If you are not the
intended recipient, any use, interference with, disclosure or copying of this
e-mail, including attachments, is unauthorised and expressly prohibited. If you
have received this e-mail in error please contact the sender immediately and
delete the e-mail and any attachments from your system. 

If this e-mail constitutes a
commercial message of a type that you no longer wish to receive please reply to
this e-mail by typing Unsubscribe in the subject line. 

 

















--~--~-~--~~~---~--~~
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 unsubscribe from this group, send email to [EMAIL PROTECTED]  For more options, visit this group at http://groups.google.com/group/cfaussie  -~--~~~~--~~--~--~---

[cfaussie] Re: Dates

2006-05-16 Thread Blair McKenzie

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 use the year they start instead just subtract 1.Blair
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.

 









From:

cfaussie@googlegroups.com [mailto:
cfaussie@googlegroups.com] On Behalf Of Dale Fraser
Sent: Wednesday, 17 May 2006 3:04
PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: Dates



 

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 Where bit your after.



Regards
Dale Fraser















From:

cfaussie@googlegroups.com [mailto:
cfaussie@googlegroups.com] On Behalf Of KNOTT, Brian
Sent: Wednesday, 17 May 2006 14:50
PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Dates



 

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 722 or one of its related entities "Suncorp". 

Suncorp may be contacted at
Level 18, 36 Wickham Terrace, Brisbane
or on 13 11 55 or at suncorp.com.au. 

The content of this e-mail
is the view of the sender or stated author and does not necessarily reflect the
view of Suncorp. The content, including attachments, is a confidential
communication between Suncorp and the intended recipient. If you are not the
intended recipient, any use, interference with, disclosure or copying of this
e-mail, including attachments, is unauthorised and expressly prohibited. If you
have received this e-mail in error please contact the sender immediately and
delete the e-mail and any attachments from your system. 

If this e-mail constitutes a
commercial message of a type that you no longer wish to receive please reply to
this e-mail by typing Unsubscribe in the subject line. 

 















--~--~-~--~~~---~--~~
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 unsubscribe from this group, send email to [EMAIL PROTECTED]  For more options, visit this group at http://groups.google.com/group/cfaussie  -~--~~~~--~~--~--~---

[cfaussie] Re: Dates

2006-05-16 Thread KNOTT, Brian

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 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.

eg a sample row

2015-06-30 00:00:00.000,2015,   2015-Q2,2015-06/June,
2015-W27,   Tuesday,FY14/15,FY14/15-Q4,
FY14/15-12/JUNE,FY14/15-W53.

beats having to write function each time I run a query.

(I am hoping I am long gone by 2015 :-) ) 

>>> [EMAIL PROTECTED] 17/05/2006 2:49 pm >>>
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 722 or one
of its related entities "Suncorp". 

Suncorp may be contacted at Level 18, 36 Wickham Terrace, Brisbane or on
13 11 55  or at suncorp.com.au.

The content of this e-mail is the view of the sender or stated author
and does not necessarily reflect the view of Suncorp. The content,
including attachments, is a confidential communication between Suncorp
and the intended recipient. If you are not the intended recipient, any
use, interference with, disclosure or copying of this e-mail, including
attachments, is unauthorised and expressly prohibited. If you have
received this e-mail in error please contact the sender immediately and
delete the e-mail and any attachments from your system.

If this e-mail constitutes a commercial message of a type that you no
longer wish to receive please reply to this e-mail by typing Unsubscribe
in the subject line.

--~--~-~--~~~---~--~~
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 unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/cfaussie
-~--~~~~--~~--~--~---

[cfaussie] Re: Dates

2006-05-16 Thread KNOTT, Brian









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 3:04
PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: Dates



 

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 Where bit your after.



Regards
Dale Fraser















From:
cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of KNOTT, Brian
Sent: Wednesday, 17 May 2006 14:50
PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Dates



 

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 722 or one of its related entities "Suncorp". 

Suncorp may be contacted at
Level 18, 36 Wickham Terrace, Brisbane
or on 13 11 55 or at suncorp.com.au. 

The content of this e-mail
is the view of the sender or stated author and does not necessarily reflect the
view of Suncorp. The content, including attachments, is a confidential
communication between Suncorp and the intended recipient. If you are not the
intended recipient, any use, interference with, disclosure or copying of this
e-mail, including attachments, is unauthorised and expressly prohibited. If you
have received this e-mail in error please contact the sender immediately and
delete the e-mail and any attachments from your system. 

If this e-mail constitutes a
commercial message of a type that you no longer wish to receive please reply to
this e-mail by typing Unsubscribe in the subject line. 

 






--~--~-~--~~~---~--~~
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 unsubscribe from this group, send email to [EMAIL PROTECTED]  For more options, visit this group at http://groups.google.com/group/cfaussie  -~--~~~~--~~--~--~---

[cfaussie] Re: Dates

2006-05-16 Thread Dale Fraser









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 Where bit your after.



Regards
Dale Fraser











From:
cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of KNOTT, Brian
Sent: Wednesday, 17 May 2006 14:50
PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Dates



 

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 722 or one of its related entities
"Suncorp". 

Suncorp may be contacted at
Level 18, 36 Wickham Terrace, Brisbane
or on 13 11 55 or at suncorp.com.au. 

The content of this e-mail
is the view of the sender or stated author and does not necessarily reflect the
view of Suncorp. The content, including attachments, is a confidential
communication between Suncorp and the intended recipient. If you are not the
intended recipient, any use, interference with, disclosure or copying of this
e-mail, including attachments, is unauthorised and expressly prohibited. If you
have received this e-mail in error please contact the sender immediately and
delete the e-mail and any attachments from your system. 

If this e-mail constitutes
a commercial message of a type that you no longer wish to receive please reply
to this e-mail by typing Unsubscribe in the subject line. 






--~--~-~--~~~---~--~~
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 unsubscribe from this group, send email to [EMAIL PROTECTED]  For more options, visit this group at http://groups.google.com/group/cfaussie  -~--~~~~--~~--~--~---

[cfaussie] Re: Dates

2006-05-16 Thread Scott Thornton


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.

eg a sample row

2015-06-30 00:00:00.000,2015,   2015-Q2,2015-06/June,   
2015-W27,   Tuesday,FY14/15,FY14/15-Q4, 
FY14/15-12/JUNE,FY14/15-W53.

beats having to write function each time I run a query.

(I am hoping I am long gone by 2015 :-) ) 




>>> [EMAIL PROTECTED] 17/05/2006 2:49 pm >>>
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 722 or one of its 
related entities "Suncorp". 

Suncorp may be contacted at Level 18, 36 Wickham Terrace, Brisbane or on 13 11 
55  or at suncorp.com.au.

The content of this e-mail is the view of the sender or stated author and does 
not necessarily reflect the view of Suncorp. The content, including 
attachments, is a confidential communication between Suncorp and the intended 
recipient. If you are not the intended recipient, any use, interference with, 
disclosure or copying of this e-mail, including attachments, is unauthorised 
and expressly prohibited. If you have received this e-mail in error please 
contact the sender immediately and delete the e-mail and any attachments from 
your system.

If this e-mail constitutes a commercial message of a type that you no longer 
wish to receive please reply to this e-mail by typing Unsubscribe in the 
subject line.






--~--~-~--~~~---~--~~
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 unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/cfaussie
-~--~~~~--~~--~--~---

[cfaussie] Re: Dates

2006-05-16 Thread Steve Onnis




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.comSubject: [cfaussie] 
  Dates
  
  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 722 or one of its related entities 
  "Suncorp". 
  
  Suncorp may be 
  contacted at Level 18, 36 Wickham Terrace, Brisbane or on 13 11 55 or at 
  suncorp.com.au. 
  
  The content of this 
  e-mail is the view of the sender or stated author and does not necessarily 
  reflect the view of Suncorp. The content, including attachments, is a 
  confidential communication between Suncorp and the intended recipient. If you 
  are not the intended recipient, any use, interference with, disclosure or 
  copying of this e-mail, including attachments, is unauthorised and expressly 
  prohibited. If you have received this e-mail in error please contact the 
  sender immediately and delete the e-mail and any attachments from your system. 
  
  
  If this e-mail 
  constitutes a commercial message of a type that you no longer wish to receive 
  please reply to this e-mail by typing Unsubscribe in the subject line. 
  
  
--~--~-~--~~~---~--~~
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 unsubscribe from this group, send email to [EMAIL PROTECTED]  For more options, visit this group at http://groups.google.com/group/cfaussie  -~--~~~~--~~--~--~---

[cfaussie] Dates

2006-05-16 Thread KNOTT, Brian









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 722 or one of its related entities "Suncorp".  

 

Suncorp may be contacted at Level 18, 36 Wickham Terrace, Brisbane or on 13 11 55  or at suncorp.com.au. 

 

The content of this e-mail is the view of the sender or stated author and does not necessarily reflect the view of Suncorp. The content, including attachments, is a confidential communication between Suncorp and the intended recipient. If you are not the intended recipient, any use, interference with, disclosure or copying of this e-mail, including attachments, is unauthorised and expressly prohibited. If you have received this e-mail in error please contact the sender immediately and delete the e-mail and any attachments from your system. 

 

If this e-mail constitutes a commercial message of a type that you no longer wish to receive please reply to this e-mail by typing Unsubscribe in the subject line. 

  
--~--~-~--~~~---~--~~
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 unsubscribe from this group, send email to [EMAIL PROTECTED]  For more options, visit this group at http://groups.google.com/group/cfaussie  -~--~~~~--~~--~--~---

[cfaussie] Re: Can anyone see why my flash movie doesnt play in production?

2006-05-16 Thread Brett Payne-Rhodes


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 GoldCoast, acres of soon-to-be resdential plots
> had about 2m of topsoil and bushland stripped like this, ready to sell
> to landscaping supplies (the lord taketh away and you buy it back)
> - pretty amazing to watch in the flesh
> 
> I'm sure Gunns in Tasmania would have a field day with it on some old
> growth forests...
> 
> 
> 
> On 5/17/06, Mike Kear <[EMAIL PROTECTED]> wrote:
>> 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-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,  see
>> http://redbackgroup.com.au/products/ThePredator.cfm  and
>> click on the  button under the image.
>>
>>
>> Cheers
>> Mike Kear
>> Windsor, NSW, Australia
>> Certified Advanced ColdFusion Developer
>> AFP Webworks
>> http://afpwebworks.com
>> ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month
>>
>>
>>
>>
>>
>> On 5/17/06, Mike Kear <[EMAIL PROTECTED]> wrote:
>>
>> 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.
>>
>>
>> Cheers
>> Mike Kear
>>
>>
>>
>> On 5/17/06, Andrew Mercer <[EMAIL PROTECTED] > wrote:
>>> There was a mime type problem with IIS6, as it didn't know what mime
>>> type the flv file was it would only run the swf file and load the flv
>>> file but wouldn't stream it.
>>>
>>> Solution add the .flv type to the mime setting under IIS
>>> manager, local computer, properties.
>>
>>
>>
>>  >
>>
> 
> > 
> 

--~--~-~--~~~---~--~~
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 unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/cfaussie
-~--~~~~--~~--~--~---

[cfaussie] Re: Can anyone see why my flash movie doesnt play in production?

2006-05-16 Thread Barry Beattie


> 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 this, ready to sell
to landscaping supplies (the lord taketh away and you buy it back)
- pretty amazing to watch in the flesh

I'm sure Gunns in Tasmania would have a field day with it on some old
growth forests...



On 5/17/06, Mike Kear <[EMAIL PROTECTED]> wrote:
>
> 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-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,  see
> http://redbackgroup.com.au/products/ThePredator.cfm  and
> click on the  button under the image.
>
>
> Cheers
> Mike Kear
> Windsor, NSW, Australia
> Certified Advanced ColdFusion Developer
> AFP Webworks
> http://afpwebworks.com
> ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month
>
>
>
>
>
> On 5/17/06, Mike Kear <[EMAIL PROTECTED]> wrote:
> >
>
>
> 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.
>
>
> Cheers
> Mike Kear
>
>
>
> On 5/17/06, Andrew Mercer <[EMAIL PROTECTED] > wrote:
> >
> > There was a mime type problem with IIS6, as it didn't know what mime
> > type the flv file was it would only run the swf file and load the flv
> > file but wouldn't stream it.
> >
> > Solution add the .flv type to the mime setting under IIS
> > manager, local computer, properties.
>
>
>
>
>  >
>

--~--~-~--~~~---~--~~
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 unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/cfaussie
-~--~~~~--~~--~--~---

[cfaussie] Re: Can anyone see why my flash movie doesnt play in production?

2006-05-16 Thread Mike Kear

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-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,  see 
http://redbackgroup.com.au/products/ThePredator.cfm  and click on the  button under the image.
 
CheersMike KearWindsor, NSW, AustraliaCertified Advanced ColdFusion DeveloperAFP Webworkshttp://afpwebworks.comColdFusion, PHP, ASP, 
ASP.NET hosting from AUD$15/month 
 
 
On 5/17/06, Mike Kear <[EMAIL PROTECTED]> wrote:


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 Kear 

On 5/17/06, Andrew Mercer <[EMAIL PROTECTED]
> wrote: 

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.

--~--~-~--~~~---~--~~
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 unsubscribe from this group, send email to [EMAIL PROTECTED]  For more options, visit this group at http://groups.google.com/group/cfaussie  -~--~~~~--~~--~--~---

[cfaussie] CFC / Webservice summary

2006-05-16 Thread duncan . loxton


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 trying to integrate with your
service?


--~--~-~--~~~---~--~~
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 unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/cfaussie
-~--~~~~--~~--~--~---

[cfaussie] Re: Can anyone see why my flash movie doesnt play in production?

2006-05-16 Thread Mike Kear

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 Advanced ColdFusion DeveloperAFP Webworkshttp://afpwebworks.comColdFusion, PHP, ASP, 
ASP.NET hosting from AUD$15/month 
 
On 5/17/06, Andrew Mercer <[EMAIL PROTECTED]> wrote:

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.

--~--~-~--~~~---~--~~
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 unsubscribe from this group, send email to [EMAIL PROTECTED]  For more options, visit this group at http://groups.google.com/group/cfaussie  -~--~~~~--~~--~--~---

[cfaussie] Re: Can anyone see why my flash movie doesnt play in production?

2006-05-16 Thread Andrew Mercer

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 <[EMAIL PROTECTED]> wrote:
If it's Windows 2003, I think there's a mime type you have to add forFlash 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 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).>> But when i deploy it to the production site, the button opens a window, and> then nothing.   It's like I have missed uploading a file.I've uploaded> the following elements of this movie, which I thought ought to do it but
> apprentely not:>> Predator2.html - the page carrying the flash movie that pops up when you> click the button> Predator2.swf  - the flash movie> Predator.flv   - the video content.
>> The only other file that might be required is the predator2.fla  but you> dont have to deploy that to the production site with videos do you?>> Can anyone see what i've missed?>
> The URL for the page involved is> http://redbackgroup.com.au/products/ThePredator.cfm> there's a button under the picture of the grinder-upper machine.
>> --> Cheers> Mike Kear> Windsor, NSW, Australia> Certified Advanced ColdFusion Developer> AFP Webworks> http://afpwebworks.com
> ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month>  >>--Kay Smoljakhttp://kay.zombiecoder.com/

--~--~-~--~~~---~--~~
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 unsubscribe from this group, send email to [EMAIL PROTECTED]  For more options, visit this group at http://groups.google.com/group/cfaussie  -~--~~~~--~~--~--~---

[cfaussie] Re: Can anyone see why my flash movie doesnt play in production?

2006-05-16 Thread Kay Smoljak


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 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).
>
> But when i deploy it to the production site, the button opens a window, and
> then nothing.   It's like I have missed uploading a file.I've uploaded
> the following elements of this movie, which I thought ought to do it but
> apprentely not:
>
> Predator2.html - the page carrying the flash movie that pops up when you
> click the button
> Predator2.swf  - the flash movie
> Predator.flv   - the video content.
>
> The only other file that might be required is the predator2.fla  but you
> dont have to deploy that to the production site with videos do you?
>
> Can anyone see what i've missed?
>
> The URL for the page involved is
> http://redbackgroup.com.au/products/ThePredator.cfm
> there's a button under the picture of the grinder-upper machine.
>
> --
> Cheers
> Mike Kear
> Windsor, NSW, Australia
> Certified Advanced ColdFusion Developer
> AFP Webworks
> http://afpwebworks.com
> ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month
>  >
>


-- 
Kay Smoljak
http://kay.zombiecoder.com/

--~--~-~--~~~---~--~~
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 unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/cfaussie
-~--~~~~--~~--~--~---

[cfaussie] Re: Can anyone see why my flash movie doesnt play in production?

2006-05-16 Thread Brett Payne-Rhodes


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
> 
> 
> 
> *From:* cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] *On 
> Behalf Of *Mike Kear
> *Sent:* Wednesday, 17 May 2006 12:31 PM
> *To:* cfaussie@googlegroups.com
> *Subject:* [cfaussie] Can anyone see why my flash movie doesnt play in 
> production?
> 
>  
> 
> 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).
> 
>  
> 
> But when i deploy it to the production site, the button opens a window, 
> and then nothing.   It's like I have missed uploading a file.I've 
> uploaded the following elements of this movie, which I thought ought to 
> do it but apprentely not:
> 
>  
> 
> Predator2.html - the page carrying the flash movie that pops up when you 
> click the button
> 
> Predator2.swf  - the flash movie
> 
> Predator.flv   - the video content.
> 
>  
> 
> The only other file that might be required is the predator2.fla  but you 
> dont have to deploy that to the production site with videos do you?
> 
>  
> 
> Can anyone see what i've missed?
> 
>  
> 
> The URL for the page involved is 
> http://redbackgroup.com.au/products/ThePredator.cfm   there's a button 
> under the picture of the grinder-upper machine.
> 
> -- 
> Cheers
> Mike Kear
> Windsor, NSW, Australia
> Certified Advanced ColdFusion Developer
> AFP Webworks
> http://afpwebworks.com
> ColdFusion, PHP, ASP, ASP.NET  hosting from AUD$15/month
> 
> 
> 
> > 

--~--~-~--~~~---~--~~
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 unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/cfaussie
-~--~~~~--~~--~--~---

[cfaussie] Re: Can anyone see why my flash movie doesnt play in production?

2006-05-16 Thread 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 May 2006 12:31
PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Can anyone see
why my flash movie doesnt play in production?



 



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). 





 





But when i deploy it to
the production site, the button opens a window, and then nothing.  
It's like I have missed uploading a file.    I've uploaded
the following elements of this movie, which I thought ought to do it but
apprentely not: 





 





Predator2.html - the page
carrying the flash movie that pops up when you click the button





Predator2.swf  - the
flash movie 





Predator.flv  
- the video content. 





 





The only other file that
might be required is the predator2.fla  but you dont have to deploy that
to the production site with videos do you?





 





Can anyone see what i've
missed? 





 





The URL for the page
involved is http://redbackgroup.com.au/products/ThePredator.cfm  
there's a button under the picture of the grinder-upper machine. 

-- 
Cheers
Mike Kear
Windsor, NSW, Australia
Certified Advanced ColdFusion Developer
AFP Webworks
http://afpwebworks.com
ColdFusion, PHP, ASP, ASP.NET hosting from
AUD$15/month 








--~--~-~--~~~---~--~~
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 unsubscribe from this group, send email to [EMAIL PROTECTED]  For more options, visit this group at http://groups.google.com/group/cfaussie  -~--~~~~--~~--~--~---

[cfaussie] Can anyone see why my flash movie doesnt play in production?

2006-05-16 Thread Mike Kear

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).

 
But when i deploy it to the production site, the button opens a window, and then nothing.   It's like I have missed uploading a file.    I've uploaded the following elements of this movie, which I thought ought to do it but apprentely not: 

 
Predator2.html - the page carrying the flash movie that pops up when you click the button
Predator2.swf  - the flash movie 
Predator.flv   - the video content. 
 
The only other file that might be required is the predator2.fla  but you dont have to deploy that to the production site with videos do you?
 
Can anyone see what i've missed? 
 
The URL for the page involved is http://redbackgroup.com.au/products/ThePredator.cfm   there's a button under the picture of the grinder-upper machine.
-- CheersMike KearWindsor, NSW, AustraliaCertified Advanced ColdFusion DeveloperAFP Webworkshttp://afpwebworks.comColdFusion, PHP, ASP, 
ASP.NET hosting from AUD$15/month 

--~--~-~--~~~---~--~~
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 unsubscribe from this group, send email to [EMAIL PROTECTED]  For more options, visit this group at http://groups.google.com/group/cfaussie  -~--~~~~--~~--~--~---

[cfaussie] Re: cfinclude and memory usage

2006-05-16 Thread Barry Beattie


> > 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 are on the same thread.

> > IF thats the case, any queries in an include would remain in memory until
> > the end of the page request.

sounds like Mike is correct

my 2c.


On 5/17/06, Duncan <[EMAIL PROTECTED]> wrote:
>
> 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,or allowing snippets of
> > code to be reused in more than one page.
> >
> > IF thats the case, any queries in an include would remain in memory until
> > the end of the page request.
> >
> > There are a lot of advantages of using CFINCLUDEs but that isnt one of them.
> >Not by my understanding.   So I agree with you Duncan.
> >
> > Cheers
> > Mike Kear
> > Windsor, NSW, Australia
> > Certified Advanced ColdFusion Developer
> > AFP Webworks
> > http://afpwebworks.com
> > ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month
> >
> >
> >
> > On 5/13/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> > >
> > > I have just seen this on a forum and have a feeling its misguided:
> > >
> > > "use cfinclude to seperate major query as CF will process each
> > > cfinclude in different thread.
> > > and will release the memmory when the cfinclude page finish."
> > >
> > > Can anyone shed any light on the correctness of this statement?
> > >
> > > I would say its false because its a linear process and the query has to
> > > stay iun memory until the request is finished.
> > >
> > >
> > >
> > >
> > >
> > > --
> > >
> > > > >
> > >
> >
>
>
> --
> Duncan I Loxton
> [EMAIL PROTECTED]
>
> >
>

--~--~-~--~~~---~--~~
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 unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/cfaussie
-~--~~~~--~~--~--~---

[cfaussie] Re: Where have all the CF developers gone?

2006-05-16 Thread Simon Haddon

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 pay scale from the ad. Also, have 
reworded some of the requirements. We did this a few days ago but still haven't 
had any responses.
 
The ad is still up there if 
people are interested:

http://mycareer.com.au/4029944 

 
We've gotten a few resumes from 
recruitment firms. We're getting a lot of people asking for a salary of around 
90k, and thats before the commission we'd have to pay. That seems to me a little 
high, for a full-time CF programmer position. Definately if it was a managerial 
role, but this is more of a lead programmer role. Are there employers out there 
paying this much for a CF programmer? Or are they just being talked up by their 
agencies?
 
seeya
 
 





-- CheersSimon Haddon

--~--~-~--~~~---~--~~
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 unsubscribe from this group, send email to [EMAIL PROTECTED]  For more options, visit this group at http://groups.google.com/group/cfaussie  -~--~~~~--~~--~--~---

[cfaussie] Re: External XML Entities with CF 7...

2006-05-16 Thread Simon Haddon

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/05/06, Kai Koenig ( ZeroOne ) <[EMAIL PROTECTED]> wrote:





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:cfaussie@googlegroups.com] On Behalf Of M@ BourkeSent: 
Tuesday, 16 May 2006 2:03 a.m.To: 
cfaussie@googlegroups.comSubject: [cfaussie] Re: External XML 
Entities with CF 7...
CF can be nasty with xml, CF has some issues with xpath as well 
:(shoot Macrobe an email letting them know of there XML 
issues.M@who now has to put his hand in a diff spot to do the @ 
symbol lol


-- CheersSimon Haddon

--~--~-~--~~~---~--~~
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 unsubscribe from this group, send email to [EMAIL PROTECTED]  For more options, visit this group at http://groups.google.com/group/cfaussie  -~--~~~~--~~--~--~---

[cfaussie] Re: cfinclude and memory usage

2006-05-16 Thread Simon Haddon

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 (model) templates and output your results in the display (view) templates.  
A cfinclude is nothing more than a simple way to seperate you code into smaller templates that you can reuse.Cheers,SimonOn 17/05/06, 
Barry Beattie <[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.
  assigned (before include):#x#  after include: #x#
  final: #x#assigned (before include): 2after include: 10final: 12
so they are on the same thread.> > IF thats the case, any queries in an include would remain in memory until> > the end of the page request.sounds like Mike is correctmy 2c.
On 5/17/06, Duncan <[EMAIL PROTECTED]> wrote:>> 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,or allowing snippets of> > code to be reused in more than one page.> >> > IF thats the case, any queries in an include would remain in memory until
> > the end of the page request.> >> > There are a lot of advantages of using CFINCLUDEs but that isnt one of them.> >Not by my understanding.   So I agree with you Duncan.> >
> > Cheers> > Mike Kear> > Windsor, NSW, Australia> > Certified Advanced ColdFusion Developer> > AFP Webworks> > http://afpwebworks.com
> > ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month> >> >> >> > On 5/13/06, [EMAIL PROTECTED]
 <[EMAIL PROTECTED]> wrote:> > >> > > I have just seen this on a forum and have a feeling its misguided:> > >> > > "use cfinclude to seperate major query as CF will process each
> > > cfinclude in different thread.> > > and will release the memmory when the cfinclude page finish."> > >> > > Can anyone shed any light on the correctness of this statement?
> > >> > > I would say its false because its a linear process and the query has to> > > stay iun memory until the request is finished.> > >> > >> > >
> > >> > >> > > --> > >> > > > >> > >>  --> Duncan I Loxton> 
[EMAIL PROTECTED]>> >>-- CheersSimon Haddon

--~--~-~--~~~---~--~~
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 unsubscribe from this group, send email to [EMAIL PROTECTED]  For more options, visit this group at http://groups.google.com/group/cfaussie  -~--~~~~--~~--~--~---

[cfaussie] Re: cfinclude and memory usage

2006-05-16 Thread Duncan


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,or allowing snippets of
> code to be reused in more than one page.
>
> IF thats the case, any queries in an include would remain in memory until
> the end of the page request.
>
> There are a lot of advantages of using CFINCLUDEs but that isnt one of them.
>Not by my understanding.   So I agree with you Duncan.
>
> Cheers
> Mike Kear
> Windsor, NSW, Australia
> Certified Advanced ColdFusion Developer
> AFP Webworks
> http://afpwebworks.com
> ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month
>
>
>
> On 5/13/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> >
> > I have just seen this on a forum and have a feeling its misguided:
> >
> > "use cfinclude to seperate major query as CF will process each
> > cfinclude in different thread.
> > and will release the memmory when the cfinclude page finish."
> >
> > Can anyone shed any light on the correctness of this statement?
> >
> > I would say its false because its a linear process and the query has to
> > stay iun memory until the request is finished.
> >
> >
> >
> >
> >
> > --
> >
> > > >
> >
>


-- 
Duncan I Loxton
[EMAIL PROTECTED]

--~--~-~--~~~---~--~~
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 unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/cfaussie
-~--~~~~--~~--~--~---

[cfaussie] Re: External XML Entities with CF 7...

2006-05-16 Thread Kai Koenig \( ZeroOne \)




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@googlegroups.comSubject: [cfaussie] Re: External XML 
Entities with CF 7...
CF can be nasty with xml, CF has some issues with xpath as well 
:(shoot Macrobe an email letting them know of there XML 
issues.M@who now has to put his hand in a diff spot to do the @ 
symbol lol
--~--~-~--~~~---~--~~
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 unsubscribe from this group, send email to [EMAIL PROTECTED]  For more options, visit this group at http://groups.google.com/group/cfaussie  -~--~~~~--~~--~--~---

[cfaussie] Re: Where have all the CF developers gone?

2006-05-16 Thread Lucas

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 more lolM@



-- Lucashttp://www.thebitbucket.net

--~--~-~--~~~---~--~~
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 unsubscribe from this group, send email to [EMAIL PROTECTED]  For more options, visit this group at http://groups.google.com/group/cfaussie  -~--~~~~--~~--~--~---

[cfaussie] Re: Where have all the CF developers gone?

2006-05-16 Thread M@ Bourke

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 you are subscribed to the Google Groups "cfaussie" group.  To post to this group, send email to cfaussie@googlegroups.com  To unsubscribe from this group, send email to [EMAIL PROTECTED]  For more options, visit this group at http://groups.google.com/group/cfaussie  -~--~~~~--~~--~--~---

37 matches

Mail list logo