For anyone still interested in this thread, I thought I might show my final
conclusions...
The database is called Bluechip (a product of HCN, the folks who brought you
Medical Director) and anyone working in the health industry may come across
it.
To get a date from a Bluechip date integer
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
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
is that the year is only two digits. Sorry for wasting everyone's time
:(
T
On 4/4/07, Tom MacKean [EMAIL PROTECTED] wrote:
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
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
Lives* - even if you don't watch all the time, you
can catch up pretty quick.
Tom MacKean :)
On 3/20/07, mrEscher [EMAIL PROTECTED] wrote:
Heh,
I'm back on cfaussie after a couple of years hiatus - last I read it
was back it was on the demon server - came back to search for some
flex
it, I
simply removed the functionality it provided from the web site. However,
what if it had been? I found this service less than satisfactory.
Just my experience.
Tom MacKean
On 3/6/07, elAdi [EMAIL PROTECTED] wrote:
I am hosting a CF7 site I developed.
www.hostingfuse.com/
The hosting
I am a SELECT * user.
(In my defence, I'm self-taught and didn't know any better until now)
My question... is there a trick or tip or tool that you guys use to save
typing in the name of every field that you're after? If you're populating
a big long form, it's a real pain to type every field
/paste it into
your CFML.
Hope that's helpful, Tom.
PS Did you know that there's a Tom McKeon in the CF world? He's in upstate
New York here in the States. Small world. (For those missing the point, this
note was from Tom MacKean.)
PPS With all these folks saying, I'm a SELECT * user, it's
Broadband - If you want cable, I recommend Optus over Telsta - both have
appalling customer service but Optus is marginally less appalling. If you
want ADSL, definitely check out whirlpool as Sean suggests - there are a
million suppliers. A lot of them do a phone/broadband bundle - TPG have a
good
Using cfNTauthenticate I can get a user to log in and check that they are part of the domain. But if they are already logged onto thenetwork and are browsing the page from a logged on machine,is it possible to collect the user name without making them log in?
i.e. Can CF find out which NT user is
, Tom MacKean [EMAIL PROTECTED]
wrote:
Using cfNTauthenticate I can get a user to log in and check that they are part of the domain. But if they are already logged onto thenetwork and are browsing the page from a logged on machine,is it possible to collect the user name without making them log
Hi List,
How do I round a number to a certain number of decimal places (in this case three).
e.g. . should become .667 and .1 should become .100
I can't seem to find a function that does it.
Thanks,
Tom-- IMPORTANT: This email is intended for the use of the individual addressee(s)
Thanks. That's perfect. I thought there might be a built-in function that I hadn't found, but if not...
Tom
On 9/18/06, Blair McKenzie [EMAIL PROTECTED] wrote:
CFLib is awesomeBlair
On 9/18/06, Tom MacKean [EMAIL PROTECTED]
wrote:
Hi List,
How do I round a number to a certain number
Even better Rod. That's exactly what I was after. I knew there must be a way to do it.
T
On 9/18/06, Tom MacKean [EMAIL PROTECTED] wrote:
Thanks. That's perfect. I thought there might be a built-in function that I hadn't found, but if not...
Tom
On 9/18/06, Blair McKenzie [EMAIL PROTECTED
If you're gonna vote, here's a few more to add to the ballot
http://ed.mullen.home.comcast.net/fclock.html
Tom
On 8/29/06, Brett Payne-Rhodes [EMAIL PROTECTED] wrote:
I think we should vote!I give two votes to the mbcomms 'clock' for originality (I like the writing and rubbing out idea!) and
and lets see if that works./MaxOn 7/3/06, Tom MacKean [EMAIL PROTECTED]
wrote: Doesn't work for me. Variable MAXFUNC is undefined. Tom On 6/30/06, Max [EMAIL PROTECTED]
wrote: Dale Fraser wrote: Yep I saw it to which lead me to conclude that it cant be done. Regards Dale Fraser
ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On 7/3/06, Tom MacKean
[EMAIL PROTECTED] wrote: I just cut and pasted the code from your post. I added the function after my OnRequestEnd function and put the Hello Max code on a test page. The page
gives me the grey unexpected error box
HI all,
I have two databases each containing names. I need to compare the two tables and identify anyone who its in both lists. There are 4000 names in one list and 1200 in the other.
Speed is not an issue - this is not a public site.
The only thing I can think of is to loop through one table
mySQL
On 6/28/06, Steve Onnis [EMAIL PROTECTED] wrote:
what database platform?
-Original Message-From: cfaussie@googlegroups.com
[mailto:cfaussie@googlegroups.com]On Behalf Of Tom MacKeanSent: Wednesday, June 28, 2006 5:16 PM
To: cfaussie@googlegroups.comSubject: [cfaussie] Comparing
the logic in an SQLquery.
Tom
On 6/28/06, Tom MacKean [EMAIL PROTECTED]
wrote:
mySQL
On 6/28/06, Steve Onnis [EMAIL PROTECTED]
wrote:
what database platform?
-Original Message-From: cfaussie@googlegroups.com
[mailto:cfaussie@googlegroups.com]On Behalf Of Tom MacKeanSent
.
From: cfaussie@googlegroups.com [mailto:
cfaussie@googlegroups.com] On Behalf Of Tom MacKean
Sent: Wednesday, 28 June 2006 5:30 PMTo: cfaussie@googlegroups.com
Subject: [cfaussie] Re: Comparing names between databases
The thing is that the names come from two completely separate sources and one
heuristic, whereby not only do you detect typo, but you also detect the more likely ones (like an a for an s).
I should build this thing again, usig coldfusion, but between work, learning new stuff, and open source projects, I'm afraid I have no time :-/
tof
On 6/28/06, Tom MacKean [EMAIL
...and we're back to the start :)
On 6/29/06, Joel Cass [EMAIL PROTECTED] wrote:
Daleall you would need to do is put one line before your code:cfset tr=
application.myUdf.tr-Original Message-From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com
]OnBehalf Of Dale FraserSent:
In Preferences Site make sure both Prompt on Get/Check Out and Prompt on Put/Check in. The next time you upload, it will ask you if you want to upload dependent files as well. Choose no and Don't show this again. It remembers your choice
Tom
On 6/28/06, Andrew Scott [EMAIL PROTECTED] wrote:
UncheckMaintain syncronization information in the Remote Info panel
Tom
On 6/8/06, Chad Renando [EMAIL PROTECTED] wrote:
I have.I suspect it has something to do with dreamweaver notoverwriting a file if it is seen as the same on the server.I
typically delete the server file and reupload,
http://www.websiteoptimization.com/
gives pretty good reports.
Tom
On 6/5/06, murrah [EMAIL PROTECTED] wrote:
Hi.Does anyone know how to monitor the actual downloaded size of a webpage ? ie how many bytes are actually sent from the server.
I am trying to optimise my pages and am experimenting
I'm just about to rebuild my system. Is there a way to export all my settings (mappings, dsns, etc) out of ColdFusion to be reimported after rebuild. I can it anywhere obvious.
Thanks,
Tom-- IMPORTANT: This email is intended for the use of the individual addressee(s) named above and may contain
Thanks, I'll give it a go
On 6/5/06, cfgroupie [EMAIL PROTECTED] wrote:
Yes you can.But it depends on what version. I do it by creating a .car file andthen just re-instating it. Works a charm. I know with BlueDragon you
have an entire XML that stores it but I don't believe CFMX7 does.Jeremy--
My big book of _javascript_ suggests that you might need a semicolon after
var image1 = new Image() (and the other similar lines)
e.g.
scriptvar image1 = new Image();image1.src = "">var image2 = new Image();image2.src = ""
var image3 = new Image();image3.src = "">var image4 = new
In the line, NameVirtualHost * try deleting the :80
Tom
On 4/24/06, Mike Kear [EMAIL PROTECTED] wrote:
I'm working on setting my system up using Apache instead of IIS, and Ihave the web server working,I have worked through the excellent
article at
Thanks. Working now.
On 4/19/06, grant [EMAIL PROTECTED] wrote:
isn't it square brackets, i.e. [dbo].[TEST Sydney IVFLimited$Classification Rate]
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups cfaussie group. To post
The full version of Adobe Acrobat will create a PDF from a web page. Just type Shift-ctrl-O and select the page. It doesn't always deal with css that well, but it's mostly good.
Tom
On 4/5/06, Mark Ireland [EMAIL PROTECTED]
wrote:
There is a java thing called iTextFrom: Steve Onnis
[EMAIL
Thanks, I wasn't but will now. Going to need something before 2007 though, or I'm in real trouble. :)
Tom
On 4/3/06, seano [EMAIL PROTECTED] wrote:
Tom,Are you following what NEHTA (National eHealth Transition Authority
www.nehta.org.au) is doing to standardise provider identification
I was all set to create a new database for an application that is basically a contact list for doctors when I thought Would this be better as an XML file?. I've never used an XML file to store and retrieve data before, but I understand the basic concept.
Let me scope it out for you:
Doctors
. Write all 5000 records to disk.There are also security / locking considerations with thisRegards
Dale Fraser -Original Message- From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On
Behalf Of Tom MacKean Sent: Monday, 3 April 2006 10:51 AM To: cfaussie@googlegroups.com Subject
OK. I'm starting to get the hang of these Application.cfc things. However, if I change a value, that change is not reflected straight away.
eg. if, in my OnApplicationStart function, I define cfset APPLICATION.dsn = sydneyivf_local. Later, I want to change this to sydneyivf_server, the change
you should put them in onrequest, then move them back for production.
Blair
On 2/22/06, Tom MacKean [EMAIL PROTECTED]
wrote:
OK. I'm starting to get the hang of these Application.cfc things. However, if I change a value, that change is not reflected straight away.
eg. if, in my
Maybe on your computer... I had to put brackets around my if _expression_
Thanks
Tom
On 2/22/06, Robin Hilliard [EMAIL PROTECTED] wrote:
On 22/02/2006, at 1:43 PM, Robin Hilliard wrote: Probably best enough...
cfscript if structKeyExists(url, reset) { structClear(application);
Apologies to anyone who got in trouble from the booby-police
Tom
On 1/27/06, darryl lyons [EMAIL PROTECTED] wrote:
Scott, I'll 2nd drinks at WebDU, and maybe even the odd conference session.
On 1/27/06, Scott Barnes [EMAIL PROTECTED]
wrote:
Exotic dancer thank you, there is a difference..As
40 matches
Mail list logo
