Hi all,
I am using ColdFusion to drag some data kicking and screaming out of a very
strange MS-based database. The date of birth field has values such as 716640
and 712672.
After a bit of mucking about I discovered that I can place this value in an
excel cell and change the format to date to
Ok,
It will be a julian date of some format, which is normally a number or
seconds or minutes past a certain point in time, based on the small number,
minutes.
The standard Java Time is seconds or milliseconds past 1 Jan 1970.
I tried this with yours but it didn't work, you need to
Trying to create a date of 0001/01/01 is alot of fun in CF - I cant
seem to create one using createdate(). I imagine Tom you will have to
use something like the code below to generate a reference date to
compare the integers against.
cfset mydate = createdate(1962,2,2)
cfset refdate = dateadd(d,
Hi Rei,
if you go look at your datasource in coldfusion administrator, under
the advanced settings there is an option for Enable long text
retrieval (CLOB) . make sure it's turned on.
cheers,
Toby
On 03/04/2007, at 19:04 , Rei wrote:
Evening all,
I am trying to retrieve WDDX
What SQL db are you using?
On Apr 3, 7:04 pm, Rei [EMAIL PROTECTED] wrote:
Evening all,
I am trying to retrieve WDDX packet stored in an ntext field of table
x in my trusty SQL db. The charLength of said WDDX packet is approx
7.
CFWDDX ACTION=WDDX2CFML INPUT=#bigPacket# OUTPUT=xStruct
Thanks a lot - works a charm!!
On Apr 3, 7:09 pm, Toby Tremayne [EMAIL PROTECTED] wrote:
Hi Rei,
if you go look at your datasource in coldfusion administrator, under
the advanced settings there is an option for Enable long text
retrieval (CLOB) . make sure it's turned on.
The funny thing is, Excel recognises these numbers as dates. If I paste one
of the numbers into Excel, then do Format Cell Date and choose the last
option on the list, Excel will happily turn it into a correct date. To my
thinking, it must therefore be a fairly standard way of formatting a date
My client has asked for advice on what the ramifications might be for
his site if he shares content with another company who uses WSE
Security.
The content will require secure access - there's dollars being passed
back and forth - and this other company is a .net site, and they use
WSE security.
Hi Tom,
According to http://www.joelonsoftware.com/items/2006/06/16.html:
In most modern programming environments, dates are stored as real
numbers. The integer part of the number is the number of days since some
agreed-upon date in the past, called the epoch. In Excel, today's date, June
OK. Feeling a bit silly now.
#dateformat(718167,d.m.yy)# works a treat. It gives 9.4.66 which is the
same result as Excel (and I assume is correct)
My confusion initially was that #dateformat(718167,d.m.)# gives
9.4.3866 which didn't look right at all so I thought is wasn't working. The
key
Barry
I think we all do. I did the same thing a few years ago to, and even posted
a solution to this from a mssql database.
Tom: Yeah it is a Julian format, and is commonly used in storing dates in
mySql servers.
Andrew Scott
Senior Coldfusion Developer
Aegeon Pty. Ltd.
On 4/4/07, Tom MacKean [EMAIL PROTECTED] wrote:
My confusion initially was that #dateformat(718167,d.m.)# gives
9.4.3866 which didn't look right at all so I thought is wasn't working. The
Looks like a bug in the dateformat function. Perhaps you could raise
an issue with Adobe about it.
Actually Excel returns the same result when you force it to use a four digit
year.
Tom
On 4/4/07, Chris Velevitch [EMAIL PROTECTED] wrote:
On 4/4/07, Tom MacKean [EMAIL PROTECTED] wrote:
My confusion initially was that #dateformat(718167,d.m.)# gives
9.4.3866 which didn't look right
I can't see a bug at all. The dateformat function simply diplays the
last two digits of the year of the date as it should. It the date is
stored as 9.4.3866 you would expect a display of 9.4.66 wouldn't you?
What I want to know is why #dateformat(1,d.m.)# is 31/12/1899
and not 1/1/900 ??
On
suggest you refer back to Karen's previous entry and then follow up the
joelonsoftware link, about halfway donn the joelonsoftware post. it might
help
On 4/4/07, rod higgins [EMAIL PROTECTED] wrote:
I can't see a bug at all. The dateformat function simply diplays the
last two digits of the
My point exactly excel parses the date from 1/1/1900, so should CF. The date
stored in excel is the same as CF, for Tom's example it would be stored
internally as 9/4/3866 regardless of how you display it. Half way down the
article;
In most modern programming environments, dates are stored as real
Tom,
The number is simple it is a date that is number of seconds from a given
date, if you type the number into excel it is going to do its best to
convert that number to a date.
The actual problem as I tried to find the code that I came up with fro
coldfusion, is simple to achieve.
Hi All,
Many people we meet at Webdu talked to us about Flex training in
general and also learning a bit more about ZoomFlex . Due to the
demand we have put together a low cost Flex training course to be held
in Sydney on the 23-24 April. At only $295 the course is an absolute
bargin for those
Grant,
Can this course be offered in other locatons.
Brian
-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On
Behalf Of Grant Straker
Sent: Wednesday, 4 April 2007 1:36 PM
To: cfaussie
Subject: [cfaussie] Affordable Flex Training
Hi All,
Many people
Grant,
That is fantastic and I would love to send some staff on this course.
However it really just isn't a good time for us.
But please if you plan on doing something similar again I would be
interested.
PS: If you want to do one in Melbourne it would be more affordable for us
and I could
I just house trained my dog. Cost me nothing.
-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On
Behalf Of Dale Fraser
Sent: Wednesday, 4 April 2007 1:45 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: Affordable Flex Training
Grant,
That is
Hey
Been trying to get a cfchart to appear in a tabbed cfform
Have tried flipping the type in cfformitem, but only succeed in getting
various code being displayed
Can't find any examples or info where this is done on MX7.02
Any help appreciated
Bryce :-)
*** Confidentiality and
because you (your company) have been a respected Macromedia Alliance partner
for a while now, does this training come with any recognition/magic pieces
of paper/certification?
On 4/4/07, Grant Straker [EMAIL PROTECTED] wrote:
Yep, if people are interested.
We have a number of clients in
It won't come with any Adobe certification but we will have our own
certificate to hand out at the end.
We have been working with and training Flex since Flex 1.0, so feel we
know enough about it to get out a certificate with some meaning.
Grant
On Apr 4, 4:12 pm, Barry Beattie [EMAIL
FYI the Adobe certified Flex courses are now being offered by Dynamic
Web Training - I'm actually in Melbourne right now teaching the very
first Rich Client Application course, and will be back down in a few
weeks for the Data Communications course. That said, if you can
make it to
Well the training is not worthless, very high quality and beneficial.
But the certificate is worthless in the sense that employers seem to hold no
value to it, I'm sure most here with CF certifications might agree.
Regards
Dale Fraser
http://dale.fraser.id.au/blog/
-Original
You know Robin,
That really pisses me off. I have off and on list been chasing to get you
down to Melbourne to do training and you have never come back with anything.
Each time we get to a point of you saying I'll organise something leave it
with me.
And now you're down doing training? Did I
I disagree I think certification is looked upon quite well by employers and
is well worth the effort.
My2c.
-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Dale Fraser
Sent: Wednesday, 4 April 2007 2:58 PM
To: cfaussie@googlegroups.com
Subject:
Will you be in town for the VIC Cfug Meeting Robin?
-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Robin Hilliard
Sent: Wednesday, 4 April 2007 2:35 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: Affordable Flex Training
FYI the
Are you an employer who looks upon it favourably or an employee who has had
it looked upon favourable?
No one has ever asked to see my certificates and I've never asked to see
any.
Regards
Dale Fraser
http://dale.fraser.id.au/blog/
-Original Message-
From:
Sorry Steve,
Is there a meeting? did I miss the announcement? is there another cfaussie
list where such things are announced??
Do you have a date and a venue that you can share with us?
Lucas.
On 4/4/07, Steve Onnis [EMAIL PROTECTED] wrote:
Will you be in town for the VIC Cfug Meeting Robin?
Should be scheduled for the 20th so hold your horses:P
_
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Lucas
Sent: Wednesday, 4 April 2007 3:45 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: Affordable Flex Training
Sorry Steve,
Is there a meeting?
Actually most recently an employer and yes if I had to choose between a
certified candidate and one that wasn't I would definitely go with a
certified candidate. Some of our clients prefer developers that are
certified and it adds value to any firm to say projects are developed by
certified
33 matches
Mail list logo