s keep you posting in other
people's topics.
What a couple of pricks.
Don't bother replying, I'm gone.
Tom MacKean
--
IMPORTANT: This email is intended for the use of the individual addressee(s)
named above and may contain information that is confidential privileged or
unsuitab
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 subtra
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.
ht is wasn't working. The
key 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
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
a
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 give
ebDU.
It's like *Days of Our 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
> wa
ouldn't even be bothered rebuilding 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
Did you mean this... http://www.danvine.com/iecapture/
Used to be good, but too popular now. Takes wy too long
Tom MacKean
On 3/6/07, Chris Velevitch <[EMAIL PROTECTED]> wrote:
>
>
> I remember there's a website that provides a service for previewing
> your website
DBMS you're using. Many of them have visual query building tools as
> well, where again you can build a SQL statement and then copy/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 u
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 name
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
On 10/24/06, 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 the network and are browsing the page from a logged on machine, is it possible to collect the user na
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 the network 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 i
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, B
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
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 addresse
Download the ACME Guide and work you way through it. Nice, simple instructions :)
http://www.stephencollins.org/acme/
Tom
On 9/14/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
On Thu, Sep 14, 2006 at 03:20:32AM -, wrote:> Bored out of my friggin mind here. Anyway, just attempting to r
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!) an
If I had a dollar for every time I've said that ...
On 8/14/06, Mike Kear <[EMAIL PROTECTED]> wrote:
My client is looking for a solicitor to advise him on e-commercematters such as a terms and conditions document, privacy and other
legal issues relating to his online business.He says his current s
I've switched it off. It's more annoying than the pop-ups.
Tom
On 8/1/06, Ryan Sabir <[EMAIL PROTECTED]> wrote:
Hey all,
Just lately I've noticed the Google popup blocker has been blocking popups that I request with a click, for example this sort of popup:
Click here
I'm sure I used to
like any other.
>>> Tom, are you sure you're not nesting your function inside another method?>>> Cheers> Mike Kear> Windsor, NSW, Australia> Certified Advanced ColdFusion Developer
> AFP Webworks> http://afpwebworks.com> ColdFusion, PHP, ASP, ASP.NET host
here and just run itwithout touching the code 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:> &
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>On the contrary - Not only could it be done, it's actually quite easy.Just add you fu
...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:
application.myUdf.tr>-Original Message-From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com
]OnBehalf Of Dale FraserSent: Thursday,
oing to be a keyboard-smart 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
mewhat.
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 s
7;t see how you would recreate all the logic in an SQL query.
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:
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] Comparin
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
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:
I use Quantum to talk to Navision (which runs like SQL Server) No problems. SQL Explorer is also good but I haven't got it working with Navision yet, only MySQL. That's probably my problem, not the software though. :)
Tom
On 6/19/06, Gareth Edwards <[EMAIL PROTECTED]> wrote:
QuantumDB does work
k the other developers are doing, at least thats the message I got when I unticked it.
On 6/8/06, Tom MacKean <[EMAIL PROTECTED]
> wrote:
Uncheck "Maintain syncronization information" in the Remote Info panel
Tom
On 6/8/06, Chad Renando <[EMAIL PROTECTED]
> wrote:
I hav
Uncheck "Maintain 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 reuploa
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 experimentin
Thanks, I'll give it a go
On 6/5/06, <[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-- IMPORTANT:
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
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 http://johnbokma.com/windows/apache-virtual-
My big book of _javascript_ suggests that you might need a semicolon after
var image1 = new Image() (and the other similar lines)
e.g.
var image1 = new Image();
image1.src = ""> var image2 = new Image();
image2.src = ""
var image3 = new Image();
image3.src = ""> var imag
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 p
We have a huge Navision database that looks after all out patient information. I nned to connect and get some data from it. Unfortunately the monkey who built it has used table names such as:
TEST Sydney IVF Limited$Classification Rate
Try as I might, I can't get an SQL statement to accept the
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 iText>From: "Steve Onnis" <
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 forinter
000 records3. Modify XML object4. 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,
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
Could you do this...
Find the maximum length of the first field and the maximum length of the second, add them together then add (say) three spaces - this is your total number of characters.
For each option, work out the length of the first and second fields, then add a varying number of spaces
I use mySQL Manager by EMS for looking after my msSQL dbs. They also have a product called SQL Manager 2005. If it works like the mySQL version, you'll be able to do everything you need to do. Copy whole dbs, copy tables, restore backups, etc. Very easy to use.
Download a trial here http://www.s
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...
if structKeyExists(url, "reset") { structClear(application
ment, maybe 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 a
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 . Later, I want to change this to sydneyivf_server, the change doesn't happen.
A cfdump will still sh
I'll be a WebDU virgin this year. Be gentle with me. (Not going to the banquet, though)
Tom MacKean
On 2/22/06, Lindsay Evans <[EMAIL PROTECTED]> wrote:
I'll be there.Most likely downstairs in the Irish pub, as usual :p--
Lindsay Evanshttp://
Could someone please give me the syntax to replace all double quotes with single quotes in a string
e.g.
I know you have to "escape" them somehow, but Ive never done that before.
Cheers
Tom-- IMPORTANT: This email is intended for the use of the individual addressee(s) named above and may c
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
Can anyone name the people in this pic? (I don't think Ed Sullivan is one of them.)
http://www.houseoffusion.com/users/view.cfm/recordid=55
Tom
On 1/27/06, Scott Barnes <[EMAIL PROTECTED]> wrote:
Can someone tell me how 42 is the answer to all things great and small...oh, though this was a lis
Yep. Very good service. Very good control panel. Easy to set up subdomains, email, etc. Couldn't be happier.
Tom
On 1/24/06, Gareth Edwards <[EMAIL PROTECTED]> wrote:
Is anyone using hostingfuse? for personal or business? the prices seem very cheap for a low bandwidth site?
Who is hostingfuse ow
55 matches
Mail list logo
