[cfaussie] Scott and Andrew have driven me away

[Tom MacKean]

OK. Had enough. I'm unsubscribing from cfaussie as of now.

Let me make this perfectly clear. I am dropping off this list for one reason
only, and that is that every time someone comes up with a sensible post
about something Scott and Andrew turn it into a flame war.

Scott - this is a list for people who have problems or questions about all
things COLDFUSION - it is not a forum for "Well you could do it with CF but
look at this alternative from MS".

Andrew - To quote from Bambi "If ya can't say nuffin' nice, don't say
nuffin' at all." Have a look through your posts and see how many have ADDED
to people's knowledge of a subject and how many have just been having a dig
at something someone (usually Scott) has said.

They went and set up a whole new watercooler newsgroup for you guys so you
could take your crap off cfaussie but your egos 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
unsuitable for overly sensitive persons with low self-esteem, no sense of
humor or irrational religious beliefs. If you are not the intended
recipient, any dissemination, distribution or copying of this email is not
authorized (either explicitly or implicitly) and constitutes an irritating
social fauxpas. No animals were harmed in the transmission of this email,
although the mutt next door is living on borrowed time, let me tell you.

--~--~-~--~~~---~--~~
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?hl=en
-~--~~~~--~~--~--~---

[cfaussie] Re: Date format

[Tom MacKean]

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 subtract the constant 693594 from
the integer and hand over to CF.

e.g. #dateformat(DOB-693594,"d/m/")#

Strangely, if DOB is null, the result is 2/1/0001

Thanks to everyone for their help and suggestions.

Tom


On 4/5/07, paulineb <[EMAIL PROTECTED]> wrote:
>
>
> Tom,
>
> If you use the following, which is an extract from a component I wrote
> to convert Active Directory account expiry filetime to utc time, you
> get quite different results.
>
> AD stores dates as nanoseconds since 1/1/1601, but I'd say that these
> dates are probably seconds since 1/1/1970 or seconds from 30/12/1899,
> so I've cut out the part that deals with nanoseconds! .
>
> cfscript code snippet:
>
>interimDate1 = DateAdd("s", 716640, "30/12/1899 00:00:00");
>interimDate2 = DateAdd("s", 712672, "30/12/1899 00:00:00");
>interimDate3 = DateAdd("s", 716640, "01/01/1970 00:00:00");
>interimDate4 = DateAdd("s", 712672, "01/01/1970 00:00:00");
>
>// Convert UTC to local.
>convertedDate1 = createodbcdatetime(DateConvert("utc2local",
> interimDate1));
>convertedDate2 = createodbcdatetime(DateConvert("utc2local",
> interimDate2));
>convertedDate3 = createodbcdatetime(DateConvert("utc2local",
> interimDate3));
>convertedDate4 = createodbcdatetime(DateConvert("utc2local",
> interimDate4));
>
> If you output these dates you get you get the same actual days, but
> different times.
>
> {ts '1900-01-07 17:04:00'}
> {ts '1900-01-07 15:57:52'}
> {ts '1970-01-09 17:04:00'}
> {ts '1970-01-09 15:57:52'}
>
> Which date range do you think tour dobs are from? You should be able
> to work out which one of these to use.
>
> Doesn't quite make sense to me that both Excel and CF are showing the
> date years 3862 and 3851. They have to be working in seconds maybe,
> not days since a certain date.
>
> Hope this helps.
>
> Pauline
>
>
> >
>


-- 
IMPORTANT: This email is intended for the use of the individual addressee(s)
named above and may contain information that is confidential privileged or
unsuitable for overly sensitive persons with low self-esteem, no sense of
humor or irrational religious beliefs. If you are not the intended
recipient, any dissemination, distribution or copying of this email is not
authorized (either explicitly or implicitly) and constitutes an irritating
social fauxpas. No animals were harmed in the transmission of this email,
although the mutt next door is living on borrowed time, let me tell you.

--~--~-~--~~~---~--~~
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?hl=en
-~--~~~~--~~--~--~---

[cfaussie] Re: Date format

[Tom MacKean]

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 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.
>
> Chris
> --
> Chris Velevitch
> Manager - Sydney Flash Platform Developers Group
> m: 0415 469 095
> www.flashdev.org.au
>
> >
>


-- 
IMPORTANT: This email is intended for the use of the individual addressee(s)
named above and may contain information that is confidential privileged or
unsuitable for overly sensitive persons with low self-esteem, no sense of
humor or irrational religious beliefs. If you are not the intended
recipient, any dissemination, distribution or copying of this email is not
authorized (either explicitly or implicitly) and constitutes an irritating
social fauxpas. No animals were harmed in the transmission of this email,
although the mutt next door is living on borrowed time, let me tell you.

--~--~-~--~~~---~--~~
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?hl=en
-~--~~~~--~~--~--~---

[cfaussie] Re: Date format

[Tom MacKean]

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 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, Excel will happily turn it into a correct date. To
> my thinking, it must therefore be a fairly standard way of formatting a date
> and yet I can find nothing about it anywhere.
>
> Very weird. More Googling needed I think.
>
> Thanks for all your help.
>
> T
>
>
>  On 4/3/07, rod higgins <[EMAIL PROTECTED]> wrote:
> >
> >
> > 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.
> >
> > 
> > 
> > 
> > #dateformat(refdate, '/mm/dd')#
> > 
> >
> > hth
> > Rod
> >
> >
> > > >
> >
>
>
> --
> IMPORTANT: This email is intended for the use of the individual
> addressee(s) named above and may contain information that is confidential
> privileged or unsuitable for overly sensitive persons with low self-esteem,
> no sense of humor or irrational religious beliefs. If you are not the
> intended recipient, any dissemination, distribution or copying of this email
> is not authorized (either explicitly or implicitly) and constitutes an
> irritating social fauxpas. No animals were harmed in the transmission of
> this email, although the mutt next door is living on borrowed time, let me
> tell you.
>



-- 
IMPORTANT: This email is intended for the use of the individual addressee(s)
named above and may contain information that is confidential privileged or
unsuitable for overly sensitive persons with low self-esteem, no sense of
humor or irrational religious beliefs. If you are not the intended
recipient, any dissemination, distribution or copying of this email is not
authorized (either explicitly or implicitly) and constitutes an irritating
social fauxpas. No animals were harmed in the transmission of this email,
although the mutt next door is living on borrowed time, let me tell you.

--~--~-~--~~~---~--~~
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?hl=en
-~--~~~~--~~--~--~---

[cfaussie] Re: Date format

[Tom MacKean]

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
and yet I can find nothing about it anywhere.

Very weird. More Googling needed I think.

Thanks for all your help.

T


On 4/3/07, rod higgins <[EMAIL PROTECTED]> wrote:
>
>
> 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.
>
> 
> 
> 
> #dateformat(refdate, '/mm/dd')#
> 
>
> hth
> Rod
>
>
> >
>


-- 
IMPORTANT: This email is intended for the use of the individual addressee(s)
named above and may contain information that is confidential privileged or
unsuitable for overly sensitive persons with low self-esteem, no sense of
humor or irrational religious beliefs. If you are not the intended
recipient, any dissemination, distribution or copying of this email is not
authorized (either explicitly or implicitly) and constitutes an irritating
social fauxpas. No animals were harmed in the transmission of this email,
although the mutt next door is living on borrowed time, let me tell you.

--~--~-~--~~~---~--~~
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?hl=en
-~--~~~~--~~--~--~---

[cfaussie] Date format

[Tom MacKean]

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 a value that seems to makes
sense. (The two values above yield 02.02.62 and 24.3.51 respectively).

Does anyone know what is going on here - and more importantly what can I do
in CF to 716640 to make it a date that I can use as a normal date.

Cheers,

Tom

-- 
IMPORTANT: This email is intended for the use of the individual addressee(s)
named above and may contain information that is confidential privileged or
unsuitable for overly sensitive persons with low self-esteem, no sense of
humor or irrational religious beliefs. If you are not the intended
recipient, any dissemination, distribution or copying of this email is not
authorized (either explicitly or implicitly) and constitutes an irritating
social fauxpas. No animals were harmed in the transmission of this email,
although the mutt next door is living on borrowed time, let me tell you.

--~--~-~--~~~---~--~~
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?hl=en
-~--~~~~--~~--~--~---

[cfaussie] Re: SOT: Local domain names

[Tom MacKean]

*"I'm back on cfaussie after a couple of years hiatus..."*

You haven't missed much. We've pretty much just been talking about which CF
hosts are any good, why Macs are better/worse than PCs, why CF is
better/worse/different to ASP/Ruby, and how much everyone drank at WebDU.

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
> was back it was on the demon server - came back to search for some
> flex advice.
>
> Andrew, you gotta read what you've been sent - I don't think that Tom
> was originally replying to you at all, nor did you clarify when he
> asked before flaming him.  On the other hand, your "Im SMRTer than
> yoo" random acronym-laden rant based on terms or homonyms you haven't
> understood is the funniest thing I've read since I left - I missed
> that! Keep it up. WYSIWYG!
>
> While we're (VASTLY) off topic, Scott Barnes is working for Microsoft
> now! wow, kudos dude.
>
> - McE
>
>
> >
>


-- 
IMPORTANT: This email is intended for the use of the individual addressee(s)
named above and may contain information that is confidential privileged or
unsuitable for overly sensitive persons with low self-esteem, no sense of
humor or irrational religious beliefs. If you are not the intended
recipient, any dissemination, distribution or copying of this email is not
authorized (either explicitly or implicitly) and constitutes an irritating
social fauxpas. No animals were harmed in the transmission of this email,
although the mutt next door is living on borrowed time, let me tell you.

--~--~-~--~~~---~--~~
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?hl=en
-~--~~~~--~~--~--~---

[cfaussie] Re: ColdFusion Hosting

[Tom MacKean]

I had a little site for my baseball team hosted at *hostingfuse* and a
database table died. I sent their support helpdesk a please fix request on
29 Nov. They got back to me the same day and said, "We are having a database
related issue that could be causing the problem. Once it's been resolved,
we'll contact you to see if you're still having an issue"

I chased them again on the 18 Dec no reply.

I chased them again in Jan and got this on Jan 11...

Tom -
Normally, each table in mySQL database would have 3 files - hitting.frm,
hitting.MYI and hitting.MYD
Yours has hitting.ISM and hitting.ISD - I restored the files from the backup
taked on 1/11/06 - but it didn't make any difference. I'm not sure what else
we can do.

Guennadi M

PS: Apologies for the delays with getting back to you. We should be back on
track now :)

The table was not critical - I couldn'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 CF7 site I developed.
>
> www.hostingfuse.com/
>
> The hosting had to be as cheap as possible and server usage is not
> expected to shoot through the roof anytime soon. So far, I think it's
> a sweat deal for the client. Support sometimes takes a bit long to
> reply - but otherwise it seems to work a treat. If you have private or
> semi-private site you want to do in CF, this certainly a cheap option
> in Perth. They'd also offer FarCry CMS.
>
> I think, they are somehow affiliated with FastHit.
>
>
> >
>


-- 
IMPORTANT: This email is intended for the use of the individual addressee(s)
named above and may contain information that is confidential privileged or
unsuitable for overly sensitive persons with low self-esteem, no sense of
humor or irrational religious beliefs. If you are not the intended
recipient, any dissemination, distribution or copying of this email is not
authorized (either explicitly or implicitly) and constitutes an irritating
social fauxpas. No animals were harmed in the transmission of this email,
although the mutt next door is living on borrowed time, let me tell you.

--~--~-~--~~~---~--~~
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?hl=en
-~--~~~~--~~--~--~---

[cfaussie] Re: Browser testing

[Tom MacKean]

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 in all versions of all browsers for all OSes, but I don't
> who it was.
>
> Does anyone know of one?
>
>
> Chris
> --
> Chris Velevitch
> Manager - Sydney Flash Platform Developers Group
> m: 0415 469 095
> www.flashdev.org.au
>
> >
>


-- 
IMPORTANT: This email is intended for the use of the individual addressee(s)
named above and may contain information that is confidential privileged or
unsuitable for overly sensitive persons with low self-esteem, no sense of
humor or irrational religious beliefs. If you are not the intended
recipient, any dissemination, distribution or copying of this email is not
authorized (either explicitly or implicitly) and constitutes an irritating
social fauxpas. No animals were harmed in the transmission of this email,
although the mutt next door is living on borrowed time, let me tell you.

--~--~-~--~~~---~--~~
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?hl=en
-~--~~~~--~~--~--~---

[cfaussie] Re: Why select * is bad (was RE: [cfaussie] Re: @#$!! Queryparam)

[Tom MacKean]

Thanks Charlie,

I'm alternating between Dreamweaver and Eclipse at the moment, depending on
the project. Since my original post, I found a button in MySQL Manager (
http://www.mysqlmanager.com/) that copies all field names to clipboard.
Reasonably easy.

Cheers,

Tom "12-step" MacKean

On 3/6/07, Charlie Arehart <[EMAIL PROTECTED]> wrote:
>
>  Tom, what editor do you use? Nearly all of them (CF Studio, HomeSite+,
> Dreamweaver, and CFEclipse) offer the RDS feature, which would allow you to
> view all the tables and their columns for all datasources defined in your CF
> admin.  These offer either a list of column names you can drag and drop
> (tedious for many) or a visual query builder where you can check the columns
> desired and then copy/paste from the SQL they build. If you've never used
> them, you're not alone. Many go years never seeing them. Let us know which
> you use if you need more help.
>
> To those who would jump in saying that you can't use RDS if it's not
> enabled, such as is likely on a production server, I'll reply that one
> shouldn't be doing development work against a production server. :-) Do your
> development locally, or at least just setup the free CF Dev edition locally
> and define your datasources there, and point to them in your editor to help
> build SQL.
>
> Or skip RDS and just use whatever SQL building tool that might come with
> the 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 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 starting to
> sound like a rehab meeting. "Hi, I'm Tom, and I'm a Select * user." :-)
>
> /Charlie
> http://www.carehart.org/blog/
>
>
>
>  --
> *From:* cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] *On
> Behalf Of *Tom MacKean
> *Sent:* Monday, March 05, 2007 7:48 PM
> *To:* cfaussie@googlegroups.com
> *Subject:* [cfaussie] Re: Why select * is bad (was RE: [cfaussie] Re:
> @#$!! Queryparam)
>
>
>  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 into your SELECT
> statement (when you could just use a *). Is there a quick way, or do you
> guys just bite the bullet and start typing?
>
> Cheers,
>
> Tom
>
>
> >
>


-- 
IMPORTANT: This email is intended for the use of the individual addressee(s)
named above and may contain information that is confidential privileged or
unsuitable for overly sensitive persons with low self-esteem, no sense of
humor or irrational religious beliefs. If you are not the intended
recipient, any dissemination, distribution or copying of this email is not
authorized (either explicitly or implicitly) and constitutes an irritating
social fauxpas. No animals were harmed in the transmission of this email,
although the mutt next door is living on borrowed time, let me tell you.

--~--~-~--~~~---~--~~
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?hl=en
-~--~~~~--~~--~--~---

<>

[cfaussie] Re: Why select * is bad (was RE: [cfaussie] Re: @#$!! Queryparam)

[Tom MacKean]

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 into your SELECT
statement (when you could just use a *). Is there a quick way, or do you
guys just bite the bullet and start typing?

Cheers,

Tom


On 3/6/07, Duncan <[EMAIL PROTECTED]> wrote:
>
>
> Charlie,
>
> No pushing of buttons going on, I was asking like a lemming because I
> was wondering if there were other reasons that I did not know about. I
> am aware of the larger amounts of data where unneccessary, but thats
> about it.
>
> Sometimes I find asking this way on a list questions like these
> illicit better responses to learn from. No offense intended.
>
> Your comments here are helpful, Thankyou
>
> Duncan
>
> On 3/3/07, Charlie Arehart <[EMAIL PROTECTED]> wrote:
> >
> > So, are you saying that removing the "select *" does or does not solve
> the
> > problem? I just want to know where this thread is crossing from solving
> your
> > problem to discussing the broader issue of "select *".
> >
> > I'm actually surprised to hear that you would ask for a spelling out of
> the
> > reasons for why using "select *" is bad. It's such a universally derided
> > practice.  And there's been all that discussion afterward today later on
> > subjects like hosting, findnocase. I have to think folks didn't read
> this,
> > as I'd expect to see a number of people come out and explain why it's
> bad.
> > That's the beauty of a list like this: no one person needs to shoulder
> the
> > burden of answering a question.
> >
> > But I'll kick it off with saying that people usually use it when it's
> not
> > needed, as a shortcut. The problem is simply that if the number of
> columns
> > retrieved exceeds the number used, then you've asked for a lot of
> needless
> > work to be done: the database had to gather the data, then store it in
> its
> > buffers, then it had to be sent across the network, then it had to be
> stored
> > in CF's memory as a query resultset. The larger the number of excess
> column
> > (and the size of data they hold), the more the pain of the problem, and
> when
> > you multiply that by the number of rows retrieved, and then by the
> number of
> > requests running that query each day...well, as the joke goes, "a
> million
> > here, a million there, and soon you're talking about real money".
> >
> > And the problem is about more than just you who issued the query. You're
> > request asking the database to do work takes away resources that it
> could
> > have spent doing more useful work. And when data fills the DB buffers,
> that
> > flushes data from someone else's query that might have been reused for a
> > subsequent request for the same database pages (very low level, but
> > important, stuff).
> >
> > Now that was just if the number of columns retrieved would be smaller if
> you
> > did just name them instead. If they're the same, then that's certainly
> > different, though there can still be issues.
> >
> > For instance, depending on the database (and perhaps configuration), the
> use
> > of "select *" may cause the DBMS to process its query plan differently.
> That
> > really depends, though, and so I don't want to state categorically that
> it's
> > always bad for that reason. I'll leave that to others to hash out (see
> > below). Then there's this issue of its impact when used with
> CFQUERYPARAM,
> > and some have even argued that it causes problems when used in CFQUERY
> with
> > views (see the comments in the last thread below), and so on.
> >
> > Now, really, there are all manner of other places where people have
> decried
> > it (or debated it, as you want to). I can't tell if you're pressing me,
> > Duncan, just to get a rise out of me, or try to make me prove my
> statement,
> > or just out of sincere curiosity. I just want to clarify that I only
> > proposed you avoid it to solve your very problem with CFQUERYPARAM.
> Please
> > do let us know if it helped. But if you're still interested in the
> "select *
> > debate", there's plenty out there. I don't need to defend it myself. :-)
> >
> > What's interesting is that if you try to do a google search, you're
> > flummoxed because google uses * as a single word placeholder (no, not a
> > multi-word, just a single word, which is curious), so you can't (it
> seems)
> > readily say "find all results that say select * us bad". Here are a few
> > areas where this has been discussed and/or debated:
> >
> > http://www.parseerror.com/sql/select*isevil.html
> > http://www.sitepoint.com/forums/showthread.php?t=417457
> > http://www.adopenstatic.com/faq/selectstarisbad.asp
> >
> http://expertanswercenter.techtarget.com/eac/knowledgebaseAnswer/0,295199,si
> > d63_gci978334,00.html
> >
> http://rip747.wordpress.com/2006/07/10/to-select-or-not-its-a-matt

[cfaussie] Re: OT: Moving to Sydney

[Tom MacKean]

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 one that my neighbour recommends. He gets 60Gb of pretty quick
downloads a month for about $50.

Cable TV - you have the choice of Optus or Foxtel but they have the same
channels so it really depends on what sort of bundle you get. You might want
to bundle it with your mobiles/landlines/cable broadband etc. . Bear in mind
that if you are going to live in an apartment, you may have dramas getting
it hooked up - depends on the block.

Electricity/gas - a couple of different suppliers but they're basically all
the same.

Ikea is pretty good. Lots of stuff and if you have small children, you can
dump them in the supervised playground for an hour while you go shopping
without them (bliss!). It's in Rhodes and there's plenty of parking.

You can get monitors anywhere. There are lots and lots of little computer
shops in Sydney. Check out
http://www.adelong.com.au/store/index.php?cPath=38&osCsid=c0f1a4b0e16ed3b9244f695a689bd5d2.
They're in the city and generally have reasonable prices. Nice blokes too.

Hope this helps.

Tom

On 12/17/06, Maximilian Nyman <[EMAIL PROTECTED]> wrote:
>
>
> Hi dear group ;)
>
> This is really WAY off topic and I'm not sure if this appropriate for
> this forum.
> If it's not, please feel free to ignore it, or to tell me off
>
> Anyway, here we go... ;)
>
> I'm moving to Sydney (from Wellington) with my family first week of
> January and have a few questions.
>
> Who's the best services providers for:
> (Doesn't necessarily have to be the cheapest, even thought that would
> be nice too)
> - Broadband
> - Phone (land line and mobile)
> - TV/Cable
> - Electricity/Gas
>
>
> Also, we'll need stuff to fill our new home once we found one. So
> where's the best place for that? I know you guys have IKEA and I'm
> thrilled about that (since I'm from Sweden), but where else? EBay?
> And if anyone knows anyone who like to sell stuff, I will probably
> want to buy it ;)
> We might end up renting a furnished apartment, so I'm not sure how
> much furniture we going to need.
> But one thing that we'll definitely need a few monitors (two for me
> and one for my wife).
> And then there is all the other everyday stuff that one needs to setup
> a new home.
>
>
> I'm sorry to intrude on this group like this,but thank you for your time.
>
> Best regards,
> Max
>
> >
>


-- 
IMPORTANT: This email is intended for the use of the individual addressee(s)
named above and may contain information that is confidential privileged or
unsuitable for overly sensitive persons with low self-esteem, no sense of
humor or irrational religious beliefs. If you are not the intended
recipient, any dissemination, distribution or copying of this email is not
authorized (either explicitly or implicitly) and constitutes an irritating
social fauxpas. No animals were harmed in the transmission of this email,
although the mutt next door is living on borrowed time, let me tell you.


--~--~-~--~~~---~--~~
 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?hl=en
-~--~~~~--~~--~--~---

[cfaussie] Re: Getting a NT user's name

[Tom MacKean]

Thanks
On 10/24/06, grant <[EMAIL PROTECTED]> wrote:
 

if they're already logged in the username and domain should be in the cgi scope - remote_user or auth_user. you may need to turn anonymous access off in the server settings so that the value is passed through to the server... 

hth 

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 name without making them log in? 
i.e. Can CF find out which NT user is viewing the page or do I have to get them to log in?
 
Hope this is clear enough.
 
Tom
 
-- IMPORTANT: This email is intended for the use of the individual addressee(s) named above and may contain information that is confidential privileged or unsuitable for overly sensitive persons with low self-esteem, no sense of humor or irrational religious beliefs. If you are not the intended recipient, any dissemination, distribution or copying of this email is not authorized (either explicitly or implicitly) and constitutes an irritating social fauxpas. No animals were harmed in the transmission of this email, although the mutt next door is living on borrowed time, let me tell you. 

--~--~-~--~~~---~--~~
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] Getting a NT user's name

[Tom MacKean]

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 is viewing the page or do I have to get them to log in?
 
Hope this is clear enough.
 
Tom
 
-- IMPORTANT: This email is intended for the use of the individual addressee(s) named above and may contain information that is confidential privileged or unsuitable for overly sensitive persons with low self-esteem, no sense of humor or irrational religious beliefs. If you are not the intended recipient, any dissemination, distribution or copying of this email is not authorized (either explicitly or implicitly) and constitutes an irritating social fauxpas. No animals were harmed in the transmission of this email, although the mutt next door is living on borrowed time, let me tell you. 


--~--~-~--~~~---~--~~
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: decimal places

[Tom MacKean]

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]> 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 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) named above and may contain information that is confidential privileged or unsuitable for overly sensitive persons with low self-esteem, no sense of humor or irrational religious beliefs. If you are not the intended recipient, any dissemination, distribution or copying of this email is not authorized (either explicitly or implicitly) and constitutes an irritating social fauxpas. No animals were harmed in the transmission of this email, although the mutt next door is living on borrowed time, let me tell you. 
 
 -- IMPORTANT: This email is intended for the use of the individual addressee(s) named above and may contain information that is confidential privileged or unsuitable for overly sensitive persons with low self-esteem, no sense of humor or irrational religious beliefs. If you are not the intended recipient, any dissemination, distribution or copying of this email is not authorized (either explicitly or implicitly) and constitutes an irritating social fauxpas. No animals were harmed in the transmission of this email, although the mutt next door is living on borrowed time, let me tell you. 
-- IMPORTANT: This email is intended for the use of the individual addressee(s) named above and may contain information that is confidential privileged or unsuitable for overly sensitive persons with low self-esteem, no sense of humor or irrational religious beliefs. If you are not the intended recipient, any dissemination, distribution or copying of this email is not authorized (either explicitly or implicitly) and constitutes an irritating social fauxpas. No animals were harmed in the transmission of this email, although the mutt next door is living on borrowed time, let me tell you. 

--~--~-~--~~~---~--~~
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: decimal places

[Tom MacKean]

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 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) named above and may contain information that is confidential privileged or unsuitable for overly sensitive persons with low self-esteem, no sense of humor or irrational religious beliefs. If you are not the intended recipient, any dissemination, distribution or copying of this email is not authorized (either explicitly or implicitly) and constitutes an irritating social fauxpas. No animals were harmed in the transmission of this email, although the mutt next door is living on borrowed time, let me tell you. 
 
 -- IMPORTANT: This email is intended for the use of the individual addressee(s) named above and may contain information that is confidential privileged or unsuitable for overly sensitive persons with low self-esteem, no sense of humor or irrational religious beliefs. If you are not the intended recipient, any dissemination, distribution or copying of this email is not authorized (either explicitly or implicitly) and constitutes an irritating social fauxpas. No animals were harmed in the transmission of this email, although the mutt next door is living on borrowed time, let me tell you. 

--~--~-~--~~~---~--~~
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] decimal places

[Tom MacKean]

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) named above and may contain information that is confidential privileged or unsuitable for overly sensitive persons with low self-esteem, no sense of humor or irrational religious beliefs. If you are not the intended recipient, any dissemination, distribution or copying of this email is not authorized (either explicitly or implicitly) and constitutes an irritating social fauxpas. No animals were harmed in the transmission of this email, although the mutt next door is living on borrowed time, let me tell you. 


--~--~-~--~~~---~--~~
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: Apache & IIS running CF

[Tom MacKean]

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 run
> ColdFusion on Apache and ColdFusion. Can this be done?Yes. It works well.Depending on what OS, CF version and Apache version theCF installer might have problems setting the connector up. If
that happens, do an install where you only select the internal(testing) CF webserver, then run the Apache connector installerafterwards.CheersPaul HaddonTechnical Services ManagerFormstar Print Technologies

--~--~-~--~~~---~--~~
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: Cool flash countdown clock

[Tom MacKean]

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 because it is *still* going.
And I give one vote to the the cannon clock because I like the way it starts up.Let the voting begin! (or is this just pushing an OT thread for which I will get banned?)BrettB)christophe albrech wrote:
> Am I the only one to find it cool, yet ugly?>> On 8/29/06, *Bjorn Schultheiss* <[EMAIL PROTECTED]> 
[EMAIL PROTECTED]>> wrote:>> pretty cool, i like the throwing action>> Regards,>> Bjorn Schultheiss> Senior Flash Developer> QDC Technologies
>>> > *From:* cfaussie@googlegroups.com 
cfaussie@googlegroups.com>> [mailto: cfaussie@googlegroups.com> cfaussie@googlegroups.com
>] *On Behalf Of *Shane Farmer> *Sent:* Monday, 28 August 2006 11:49 PM> *To:* cfaussie@googlegroups.com 
cfaussie@googlegroups.com>>> *Subject:* [cfaussie] Re: Cool flash countdown clock>>> Hi Dale,>> Works fine for me in IE7. 64bit IE doesn't like the plugin much (but
> that can be a good thing) but 32bit IE works fine. You might want to> check you security settings.>> Shane On 8/28/06, *Dale Fraser* <
[EMAIL PROTECTED]> [EMAIL PROTECTED]>> wrote:>>> Doesn't work in ie7.>> Tells me I don't have the latest version of Flash. But I do.
>> Regards> Dale Fraser>> http://dale.fraser.id.au 
> -Original Message-> From: cfaussie@googlegroups.com> 
cfaussie@googlegroups.com> [mailto:> cfaussie@googlegroups.com cfaussie@googlegroups.com>] On
> Behalf> Of Mike Kear> Sent: Monday, 28 August 2006 13:59 PM> To: cfaussie@googlegroups.com 
cfaussie@googlegroups.com>> Subject: [cfaussie] Cool flash countdown clock>>> Canon have this strange idea that I might buy their new Canon 400D> camera when it's released in a few days - FAT CHANCE!  - so they
> sent> a promotional email asking me to check out the new camera on line.>> I checked it out but was taken wtih this cool countdown clock.  I've> seen a similar idea with a hand writing out numbers before but
> this is> a much better implementation of that basic idea I think .>>> http://www.canon.com.au/eos400d/default.aspx
>> --> Cheers> Mike Kear> Windsor, NSW, Australia> Adobe Certified Advanced ColdFusion Developer> AFP Webworks> 
http://afpwebworks.com > ColdFusion, PHP, ASP, ASP.NET <
http://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 recommend a good solicitor?

[Tom MacKean]

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 solicitor knows conveyancing fine enough but isntreally up to the mark on internet issues.Can anyone recommend a good solicitor in the Sydney area who knows the
law relating to the internet and isnt going to bankrupt him by askinghim to pay for all the fancy offices and charge him for the air hebreathes in their offices?Off list would probably be best I think.
CheersMike KearWindsor, NSW, AustraliaAdobe Certified Advanced ColdFusion DeveloperAFP Webworkshttp://afpwebworks.comColdFusion, PHP, ASP, 
ASP.NET hosting from AUD$15/month-- IMPORTANT: This email is intended for the use of the individual addressee(s) named above and may contain information that is confidential privileged or unsuitable for overly sensitive persons with low self-esteem, no sense of humor or irrational religious beliefs. If you are not the intended recipient, any dissemination, distribution or copying of this email is not authorized (either explicitly or implicitly) and constitutes an irritating social fauxpas. No animals were harmed in the transmission of this email, although the mutt next door is living on borrowed time, let me tell you. 

--~--~-~--~~~---~--~~
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: OT: Google popup blocker too aggressive?

[Tom MacKean]

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 be able to click that without it getting blocked.. just recently I've noticed the Google blocker acting like this... is this a new thing? I always thought any popup that the user initiated would be allowed through.

 
bye
 
 





Ryan SabirTechnical Director
p: (02) 9274 8030f: (02) 9274 8099m: 0411 512 454w: 
www.newgency.com

Newgency Pty LtdWeb | Multimedia | eMarketing224 Riley St
Surry Hills NSW 2010Sydney, Australia
   -- IMPORTANT: This email is intended for the use of the individual addressee(s) named above and may contain information that is confidential privileged or unsuitable for overly sensitive persons with low self-esteem, no sense of humor or irrational religious beliefs. If you are not the intended recipient, any dissemination, distribution or copying of this email is not authorized (either explicitly or implicitly) and constitutes an irritating social fauxpas. No animals were harmed in the transmission of this email, although the mutt next door is living on borrowed time, let me tell you. 

--~--~-~--~~~---~--~~
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: Includes

[Tom MacKean]

Yes. That made it work. Cool.
 
Tom 
On 7/3/06, Maximilian Nyman <[EMAIL PROTECTED]> wrote:
Ok, here is the answer (which I just figured out with some oldfashioned trail-and-error)If you want your custom functions in 
Application.cfc to be accessablein your cfm pages you have to include the onRequest method into yourApplication.cfc   
         
Cheers,MaxMike Kear wrote:> I have functions in Application.cfc that are outside the normal> methods.  i.e. not inside onRequestStart or onApplicationStart etc  It> just includes them as methods just 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 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 with Variable MAXFUNC is undefined.> >> > I'm running CFMX 7 on Apache / Windows XP. Maybe it's just me. Has anyone> > else tried Max's code?
> >> >> > Tom> >> >-- IMPORTANT: This email is intended for the use of the individual addressee(s) named above and may contain information that is confidential privileged or unsuitable for overly sensitive persons with low self-esteem, no sense of humor or irrational religious beliefs. If you are not the intended recipient, any dissemination, distribution or copying of this email is not authorized (either explicitly or implicitly) and constitutes an irritating social fauxpas. No animals were harmed in the transmission of this email, although the mutt next door is living on borrowed time, let me tell you. 

--~--~-~--~~~---~--~~
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: Includes

[Tom MacKean]

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 with Variable MAXFUNC is undefined.

 
I'm running CFMX 7 on Apache / Windows XP. Maybe it's just me. Has anyone else tried Max's code?
 
Tom 
On 7/3/06, Maximilian Nyman <[EMAIL PROTECTED]> wrote:
Hmm, that's interesting!?!It works just fine for me.Do you have the actual code (you can send it directly to me if you
want), and I'll try to put it on the my server 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:> >>>> 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 function to Application.cfc:> > >> > access="public" hint="">>
>>> >> >>> Call you function from any .cfm page:
> Hello Max> >>> That should work just fine.>>> Have a good weekend everyone,> Max>
> p.s.> FYI: The function could even have access set to "private" and it would> still work>>>> --> IMPORTANT: This email is intended for the use of the individual addressee(s)
> named above and may contain information that is confidential privileged or> unsuitable for overly sensitive persons with low self-esteem, no sense of> humor or irrational religious beliefs. If you are not the intended
> recipient, any dissemination, distribution or copying of this email is not> authorized (either explicitly or implicitly) and constitutes an irritating> social fauxpas. No animals were harmed in the transmission of this email,
> although the mutt next door is living on borrowed time, let me tell you.>>  >>>-- IMPORTANT: This email is intended for the use of the individual addressee(s) named above and may contain information that is confidential privileged or unsuitable for overly sensitive persons with low self-esteem, no sense of humor or irrational religious beliefs. If you are not the intended recipient, any dissemination, distribution or copying of this email is not authorized (either explicitly or implicitly) and constitutes an irritating social fauxpas. No animals were harmed in the transmission of this email, although the mutt next door is living on borrowed time, let me tell you. 

--~--~-~--~~~---~--~~
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: Includes

[Tom MacKean]

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 function to Application.cfc:access="public" hint="">   
      Call you function from any .cfm page:
Hello MaxThat should work just fine.Have a good weekend everyone,Maxp.s.FYI: The function could even have access set to "private" and it would
still work-- IMPORTANT: This email is intended for the use of the individual addressee(s) named above and may contain information that is confidential privileged or unsuitable for overly sensitive persons with low self-esteem, no sense of humor or irrational religious beliefs. If you are not the intended recipient, any dissemination, distribution or copying of this email is not authorized (either explicitly or implicitly) and constitutes an irritating social fauxpas. No animals were harmed in the transmission of this email, although the mutt next door is living on borrowed time, let me tell you. 

--~--~-~--~~~---~--~~
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: Includes

[Tom MacKean]

...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, 29 June 2006 2:20 PMTo: cfaussie@googlegroups.comSubject: [cfaussie] Re: IncludesSteve,I could have done this just by doing
It defeats the purpose of what I want which is a short translation functionnameIeThe quick brown fox, jumps over the lazy dog.Becomes
#tr("The quick brown fox")#, #tr("over the lazy dog")#Rather than#application.udf.tr("The quick brown fox")#, #application.udf.tr("over thelazy dog")#
RegardsDale Fraser-Original Message-From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com
] On BehalfOf Steve OnnisSent: Thursday, 29 June 2006 13:50 PMTo: cfaussie@googlegroups.comSubject: [cfaussie] Re: Includesokhad a bit of a play
this is what i have come up with   this.name = "testApp" />            listFindNoCase("onApplicationStart,onApplicationEnd,onRequestStart,onRequest
End,onSessionStart,onSessionEnd,onError,onRequest", v)>      
         all your functions will then be available as application.udf.functionNameSteve
-Original Message-From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com]OnBehalf Of Andrew Scott
Sent: Thursday, June 29, 2006 1:15 PMTo: cfaussie@googlegroups.comSubject: [cfaussie] Re: IncludesDale,I am not 100% sure but the onRequest might store it in the request scope.
Senior Coldfusion DeveloperAegeon Pty. Ltd.www.aegeon.com.auPhone: +613  8676 4223Mobile: 0404 998 273-Original Message-From: 
cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On BehalfOf Dale FraserSent: Thursday, 29 June 2006 1:10 PM
To: cfaussie@googlegroups.comSubject: [cfaussie] Re: IncludesYep,We had a reload option in our apps that fire onApplicationStart. I assumethis is sufficient, but we did this and it didn't help
RegardsDale Fraser-Original Message-From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com
] On BehalfOf Steve OnnisSent: Thursday, 29 June 2006 13:07 PMTo: cfaussie@googlegroups.comSubject: [cfaussie] Re: Includesremember you need to restart the application for it to work
-Original Message-From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com]OnBehalf Of Dale Fraser
Sent: Thursday, June 29, 2006 12:53 PMTo: cfaussie@googlegroups.comSubject: [cfaussie] Re: IncludesSteve,Adding the tr function into application.cfc
 doesn't work, can't access it asapplication.trChris,Adding it and then doing the RegardsDale Fraser-Original Message-
From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On BehalfOf Chris VelevitchSent: Thursday, 29 June 2006 12:34 PM
To: cfaussie@googlegroups.comSubject: [cfaussie] Re: IncludesOn 6/29/06, Dale Fraser <[EMAIL PROTECTED]> wrote:
> We use application.cfc, so how can we include a function on every pageusing> application.cfc model?Try:-variables.tr = 
this.tr>in the onRequest method of Application.cfc and have the functionincluded as a function in the Application.cfcChris--Chris VelevitchManager - 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: Comparing names between databases

[Tom MacKean]

Thanks everyone. Ryan's suggestion of filtering on lastname to begin with worked a treat. The page runs in about 5 seconds and does everything exactly as it should. Another satisfied cfaussie customer :)
 
Tom 
On 6/29/06, christophe albrech <[EMAIL PROTECTED]
> wrote: 


A couple of year ago I wrote a little utility that was doing just that. but it was in vba (excel). I had two list with first name / last name that I had to match, and I used a whole bunch of silly algorithm. like so. 

 
1. look for exact matches
2. look for exact same surname, and try to identify a nickname (like robert in one list, and bob in the other)
3. exact same surname, and same firstname except for one typo (using different flavour of left and right)...
 
and so on. Each of these rules had a color coding, so when viewing the result you knew right away where your matches were. Once you've run it a few times, it becomes obvious that rules 1/2 are 100% accurate, and rule 3-5 still like 85+% accurate. I also remember building an index on the fly, which sped the whole thing considerably. Of course, with a DB, you wouldn't have to do that yourself. I remember that the next feature was going 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
 

On 6/28/06, Tom MacKean <[EMAIL PROTECTED] 
> wrote: 



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 and on each record, loop through the other table to find matches.
 
I would love to hear any thoughts about different ways of doing this.
 
Thanks,
 
Tom

-- IMPORTANT: This email is intended for the use of the individual addressee(s) named above and may contain information that is confidential privileged or unsuitable for overly sensitive persons with low self-esteem, no sense of humor or irrational religious beliefs. If you are not the intended recipient, any dissemination, distribution or copying of this email is not authorized (either explicitly or implicitly) and constitutes an irritating social fauxpas. No animals were harmed in the transmission of this email, although the mutt next door is living on borrowed time, let me tell you. 

 
-- IMPORTANT: This email is intended for the use of the individual addressee(s) named above and may contain information that is confidential privileged or unsuitable for overly sensitive persons with low self-esteem, no sense of humor or irrational religious beliefs. If you are not the intended recipient, any dissemination, distribution or copying of this email is not authorized (either explicitly or implicitly) and constitutes an irritating social fauxpas. No animals were harmed in the transmission of this email, although the mutt next door is living on borrowed time, let me tell you. 

--~--~-~--~~~---~--~~
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: Comparing names between databases

[Tom MacKean]

Good thinking! That will definitely help.
 
Thanks 
On 6/28/06, Ryan Sabir <[EMAIL PROTECTED]> wrote:



 
You could use some SQL to compare just the surnames, stripped of any punctuation and spaces. Then run your function on the resultant data set. This should reduce the processing time somewhat.

 




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 might be Harold Smith and one might be H J Smith.
 
I've written a function (120 lines long) that does a pretty good job of returning "yes, this is a match" or "no this is not a match". I can'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:cfaussie@googlegroups.com]On Behalf Of Tom MacKeanSent: Wednesday, June 28, 2006 5:16 PM 
To: cfaussie@googlegroups.comSubject: [cfaussie] Comparing names between databases 

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 and on each record, loop through the other table to find matches.
 
I would love to hear any thoughts about different ways of doing this.
 
Thanks,
 
Tom
-- IMPORTANT: This email is intended for the use of the individual addressee(s) named above and may contain information that is confidential privileged or unsuitable for overly sensitive persons with low self-esteem, no sense of humor or irrational religious beliefs. If you are not the intended recipient, any dissemination, distribution or copying of this email is not authorized (either explicitly or implicitly) and constitutes an irritating social fauxpas. No animals were harmed in the transmission of this email, although the mutt next door is living on borrowed time, let me tell you. 


-- 
IMPORTANT: This email is intended for the use of the individual addressee(s) named above and may contain information that is confidential privileged or unsuitable for overly sensitive persons with low self-esteem, no sense of humor or irrational religious beliefs. If you are not the intended recipient, any dissemination, distribution or copying of this email is not authorized (either explicitly or implicitly) and constitutes an irritating social fauxpas. No animals were harmed in the transmission of this email, although the mutt next door is living on borrowed time, let me tell you. 


-- IMPORTANT: This email is intended for the use of the individual addressee(s) named above and may contain information that is confidential privileged or unsuitable for overly sensitive persons with low self-esteem, no sense of humor or irrational religious beliefs. If you are not the intended recipient, any dissemination, distribution or copying of this email is not authorized (either explicitly or implicitly) and constitutes an irritating social fauxpas. No animals were harmed in the transmission of this email, although the mutt next door is living on borrowed time, let me tell you. 


-- IMPORTANT: This email is intended for the use of the individual addressee(s) named above and may contain information that is confidential privileged or unsuitable for overly sensitive persons with low self-esteem, no sense of humor or irrational religious beliefs. If you are not the intended recipient, any dissemination, distribution or copying of this email is not authorized (either explicitly or implicitly) and constitutes an irritating social fauxpas. No animals were harmed in the transmission of this email, although the mutt next door is living on borrowed time, let me tell you. 

--~--~-~--~~~---~--~~
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: Comparing names between databases

[Tom MacKean]

The thing is that the names come from two completely separate sources and one might be Harold Smith and one might be H J Smith.
 
I've written a function (120 lines long) that does a pretty good job of returning "yes, this is a match" or "no this is not a match". I can'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:cfaussie@googlegroups.com]On Behalf Of Tom MacKeanSent: Wednesday, June 28, 2006 5:16 PM 
To: cfaussie@googlegroups.comSubject: [cfaussie] Comparing names between databases 

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 and on each record, loop through the other table to find matches.
 
I would love to hear any thoughts about different ways of doing this.
 
Thanks,
 
Tom
-- IMPORTANT: This email is intended for the use of the individual addressee(s) named above and may contain information that is confidential privileged or unsuitable for overly sensitive persons with low self-esteem, no sense of humor or irrational religious beliefs. If you are not the intended recipient, any dissemination, distribution or copying of this email is not authorized (either explicitly or implicitly) and constitutes an irritating social fauxpas. No animals were harmed in the transmission of this email, although the mutt next door is living on borrowed time, let me tell you. 


-- IMPORTANT: This email is intended for the use of the individual addressee(s) named above and may contain information that is confidential privileged or unsuitable for overly sensitive persons with low self-esteem, no sense of humor or irrational religious beliefs. If you are not the intended recipient, any dissemination, distribution or copying of this email is not authorized (either explicitly or implicitly) and constitutes an irritating social fauxpas. No animals were harmed in the transmission of this email, although the mutt next door is living on borrowed time, let me tell you. 
-- IMPORTANT: This email is intended for the use of the individual addressee(s) named above and may contain information that is confidential privileged or unsuitable for overly sensitive persons with low self-esteem, no sense of humor or irrational religious beliefs. If you are not the intended recipient, any dissemination, distribution or copying of this email is not authorized (either explicitly or implicitly) and constitutes an irritating social fauxpas. No animals were harmed in the transmission of this email, although the mutt next door is living on borrowed time, let me tell you. 

--~--~-~--~~~---~--~~
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: Comparing names between databases

[Tom MacKean]

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 names between databases

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 and on each record, loop through the other table to find matches.
 
I would love to hear any thoughts about different ways of doing this.
 
Thanks,
 
Tom
-- IMPORTANT: This email is intended for the use of the individual addressee(s) named above and may contain information that is confidential privileged or unsuitable for overly sensitive persons with low self-esteem, no sense of humor or irrational religious beliefs. If you are not the intended recipient, any dissemination, distribution or copying of this email is not authorized (either explicitly or implicitly) and constitutes an irritating social fauxpas. No animals were harmed in the transmission of this email, although the mutt next door is living on borrowed time, let me tell you. 


-- IMPORTANT: This email is intended for the use of the individual addressee(s) named above and may contain information that is confidential privileged or unsuitable for overly sensitive persons with low self-esteem, no sense of humor or irrational religious beliefs. If you are not the intended recipient, any dissemination, distribution or copying of this email is not authorized (either explicitly or implicitly) and constitutes an irritating social fauxpas. No animals were harmed in the transmission of this email, although the mutt next door is living on borrowed time, let me tell you. 

--~--~-~--~~~---~--~~
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] Comparing names between databases

[Tom MacKean]

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 and on each record, loop through the other table to find matches.
 
I would love to hear any thoughts about different ways of doing this.
 
Thanks,
 
Tom
-- IMPORTANT: This email is intended for the use of the individual addressee(s) named above and may contain information that is confidential privileged or unsuitable for overly sensitive persons with low self-esteem, no sense of humor or irrational religious beliefs. If you are not the intended recipient, any dissemination, distribution or copying of this email is not authorized (either explicitly or implicitly) and constitutes an irritating social fauxpas. No animals were harmed in the transmission of this email, although the mutt next door is living on borrowed time, let me tell you. 


--~--~-~--~~~---~--~~
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: OT: Dreamweaver - Managing Sites

[Tom MacKean]

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:
Some how you must have told it that you wanted to save all dependencies, asit usually asks each time you do this by default:-) Look in the settings
config.Senior Coldfusion DeveloperAegeon Pty. Ltd.www.aegeon.com.auPhone: +613  8676 4223Mobile: 0404 998 273-Original Message-From: 
cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On BehalfOf Scott ThorntonSent: Wednesday, 28 June 2006 12:17 PMTo: 
cfaussie@googlegroups.comSubject: [cfaussie] OT: Dreamweaver - Managing SitesHi,The 'site' I am working with in the moment is insisting on saving around20-30 related files when I save a single document. These other documents
have not changed.Does any know of a setting I may turn off to stop the behaviour?Scott Thornton, ProgrammerApplication DevelopmentInformation Services and TelecommunicationsHunter-New England Area Health Service
p: +61 02 49213589m: 0413800242-- IMPORTANT: This email is intended for the use of the individual addressee(s) named above and may contain information that is confidential privileged or unsuitable for overly sensitive persons with low self-esteem, no sense of humor or irrational religious beliefs. If you are not the intended recipient, any dissemination, distribution or copying of this email is not authorized (either explicitly or implicitly) and constitutes an irritating social fauxpas. No animals were harmed in the transmission of this email, although the mutt next door is living on borrowed time, let me tell you. 

--~--~-~--~~~---~--~~
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: OT: what Eclipse DB plugin do you use (for SQLServer)?

[Tom MacKean]

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 with SQLServer.Let me know if you want to know more?CheersGareth.
Barry Beattie wrote:> the only one I've had experiance with is the QuantumDB plug-in that> doesn't support SQLServer>> and "Universal dbViewer Eclipse plugin" (which does) says on it's site:
>> "No new versions will be released for the moment. Not tested with> eclipse versions higher than 3.1.1">> Eclipse 3.2 is just around the corner, it seems.>> so is there any other DB plug-ins worthy of attention (for SQLServer),
> esp if you're used to Enterprise Manager + QA - or - Visual Studio.NET> 2005?>> thanx> barry.b>> >>>
--~--~-~--~~~---~--~~
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: [OT] Dreamweaver not overwritting files

[Tom MacKean]

Sorry Taco, don't know. I work alone. For me, unchecking it fixes the not-updating-on-the-server problem and has no side effects. In a multi-developer site, there may be issues.
 
Tom 
On 6/8/06, Taco Fleur <[EMAIL PROTECTED]> wrote:

That would mean I could overwrite some of the work 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 have.  I suspect it has something to do with dreamweaver not
overwriting a file if it is seen as the same on the server.  I typically delete the server file and reupload, although I suppose youcould try the opposite and move the local to a safe place, refresh, 
then move it back and try.  The only other time I have seen this iswhen I was uploading to the wrong spot or fixing the wrong file to upload.ChadOn 6/8/06, Taco Fleur <
 [EMAIL PROTECTED]> wrote:>> I have the checkout option enabled in dreamweaver, and it's just not> overwritting any files after changes are made. I have to go on the server > delete the file and upload it from the local machine. It doesn't happen with 
> every file.> Anyone seen this before?>> --> Taco Fleur - http://www.pacificfox.com.au 
> Web Design, Web development, Graphic Design and Complete Internet Solutions> an industry leader with commercial IT experience since 1994 …>  >>

-- Taco Fleur - http://www.pacificfox.com.au
 Web Design, Web development, Graphic Design and Complete Internet Solutions an industry leader with commercial IT experience since 1994 … 
--~--~-~--~~~---~--~~
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: [OT] Dreamweaver not overwritting files

[Tom MacKean]

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 reupload, although I suppose youcould try the opposite and move the local to a safe place, refresh,then move it back and try.  The only other time I have seen this iswhen I was uploading to the wrong spot or fixing the wrong file to
upload.ChadOn 6/8/06, Taco Fleur <[EMAIL PROTECTED]> wrote:>> I have the checkout option enabled in dreamweaver, and it's just not> overwritting any files after changes are made. I have to go on the server
> delete the file and upload it from the local machine. It doesn't happen with> every file.> Anyone seen this before?>> --> Taco Fleur - http://www.pacificfox.com.au
> Web Design, Web development, Graphic Design and Complete Internet Solutions> an industry leader with commercial IT experience since 1994 …>  >>
--~--~-~--~~~---~--~~
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: Page size from server

[Tom MacKean]

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 with clientcaching etc and am trying to measure  / check how much data is actuallysent from the server so I can test various options.I ran a test just using the View Page Info in Mozilla and it returned
just the size of the html and didnt count the data in JS src files (forexample) - irrespective of whether the file was in the cache or not.I guess some kind of port monitoring software could work ??
Any suggestions ?Thanks,Murray-- IMPORTANT: This email is intended for the use of the individual addressee(s) named above and may contain information that is confidential privileged or unsuitable for overly sensitive persons with low self-esteem, no sense of humor or irrational religious beliefs. If you are not the intended recipient, any dissemination, distribution or copying of this email is not authorized (either explicitly or implicitly) and constitutes an irritating social fauxpas. No animals were harmed in the transmission of this email, although the mutt next door is living on borrowed time, let me tell you. 

--~--~-~--~~~---~--~~
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: Exporting settings

[Tom MacKean]

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: This email is intended for the use of the individual addressee(s) named above and may contain information that is confidential privileged or unsuitable for overly sensitive persons with low self-esteem, no sense of humor or irrational religious beliefs. If you are not the intended recipient, any dissemination, distribution or copying of this email is not authorized (either explicitly or implicitly) and constitutes an irritating social fauxpas. No animals were harmed in the transmission of this email, although the mutt next door is living on borrowed time, let me tell you. 

--~--~-~--~~~---~--~~
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] Exporting settings

[Tom MacKean]

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 information that is confidential privileged or unsuitable for overly sensitive persons with low self-esteem, no sense of humor or irrational religious beliefs. If you are not the intended recipient, any dissemination, distribution or copying of this email is not authorized (either explicitly or implicitly) and constitutes an irritating social fauxpas. No animals were harmed in the transmission of this email, although the mutt next door is living on borrowed time, let me tell you. 


--~--~-~--~~~---~--~~
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: OT: apache error - why not several hosts?

[Tom MacKean]

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-hosts-xp.htmlwhich explains how to do it in the simplest, clearest terms I'veencountered before.
However I've missed something somewhere because I'm still not gettingmultiple virtual sites appearing. Have i got something wrong here ormissed something? Because using any of these urls  takes me to the
same place - the root of the first one.Can anyone see what's wrong here?Here's my hosts file relating to this area:127.0.0.1   localhost
127.0.0.1   dev.afpwebworks.com   # my company site127.0.0.1   dev.bluegrass.org.au  # my bluegrass site
127.0.0.1   dev.intranet  # intranet - admin appsI've included a virtual-hosts.txt file with the virtual hosts listed,and restarted apache after every change to any of these files.
Here's whats in the virtual-hosts.txt file:## Use name-based virtual hosting.NameVirtualHost *:80   ServerName dev.intranet   DocumentRoot "C:/sites/Mysites/intranet.com/site/web"
   ErrorLog "C:/sites/Mysites/intranet.com/local-logs/error.log"   CustomLog "C:/sites/Mysites/intranet.com/local-logs/access.log" combined
   ServerName dev.afpwebworks.com   DocumentRoot "C:/sites/Mysites/afpwebworks.com/site/web"   ErrorLog "C:/sites/Mysites/afpwebworks.com/local-logs/error.log"
   CustomLog "C:/sites/Mysites/afpwebworks.com/local-logs/access.log" combined   ServerName dev.bluegrass.org.au
   DocumentRoot "C:/sites/Mysites/bluegrass.org.au/site/web"   ErrorLog "C:/sites/Mysites/bluegrass.org.au/local-logs/error.log"   CustomLog "C:/sites/Mysites/bluegrass.org.au/local-logs/access.log" combined
--CheersMike KearWindsor, NSW, AustraliaCertified Advanced ColdFusion DeveloperAFP Webworkshttp://afpwebworks.comColdFusion, PHP, ASP, 
ASP.NET hosting from AUD$15/month-- IMPORTANT: This email is intended for the use of the individual addressee(s) named above and may contain information that is confidential privileged or unsuitable for overly sensitive persons with low self-esteem, no sense of humor or irrational religious beliefs. If you are not the intended recipient, any dissemination, distribution or copying of this email is not authorized (either explicitly or implicitly) and constitutes an irritating social fauxpas. No animals were harmed in the transmission of this email, although the mutt next door is living on borrowed time, let me tell you. 

--~--~-~--~~~---~--~~
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: [OT] Image preloading check please

[Tom MacKean]

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 image4 = new Image();
 image4.src = ""

  
Tom 
On 4/24/06, Duncan <[EMAIL PROTECTED]> wrote:
Taco,No joy I am afraid, its not preloaded. I get a blank space before theon image appears.
DuncanOn 4/24/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:>> Hi all,>
> Sorry for the OT.> Would someone be so kind to check the following site whether it> preloads the images for the main navigation?> http://www.commerceengine.com.au
> I tried checking it through a proxy, but the disable _javascript_!. Kind regards,>> Taco Fleur>> Commerce Engine Pty Ltd - Australia's leading online Payment Gateway
> ...> Local Call 1300 859 179> Postal Address: PO Box 15118, City East Brisbane, Queensland, 4002,> Australia> Head office: 31 Valencia Court, Eatons Hill, Queensland, 4037,> Australia
> Telephone: +61 (0) 7 3857 3881> Fax: +61 (0) 7 3414 6464> Internet: http://www.commerceengine.com.au>> - Accepting payments online is easy
> - Developer API, XML, POST> - Low fees> - Full integration by a one-stop-shop>> >> The information contained in this email may be confidential. You should
> only disclose, re-transmit, copy, distribute, act in reliance on or> commercialise the information if you are authorised to do so. Any views> expressed in this email communication are those of the individual
> sender, except where the sender specifically states them to be the> views of Commerce Engine Pty Ltd. Any advice contained in this e-mail> has been prepared without taking into account your objectives,
> financial situation or needs. Before acting on any advice in this> e-mail, Commerce Engine recommends that you consider whether it is> appropriate for your circumstances. Commerce Engine does not represent,
> warrant or guarantee that the integrity of this communication has been> maintained nor that the communication is free of errors, virus or> interference.> Commerce Engine Pty Ltd ACN 118 850 552
>>> >>--Duncan I Loxton[EMAIL PROTECTED]-- IMPORTANT: This email is intended for the use of the individual addressee(s) named above and may contain information that is confidential privileged or unsuitable for overly sensitive persons with low self-esteem, no sense of humor or irrational religious beliefs. If you are not the intended recipient, any dissemination, distribution or copying of this email is not authorized (either explicitly or implicitly) and constitutes an irritating social fauxpas. No animals were harmed in the transmission of this email, although the mutt next door is living on borrowed time, let me tell you. 

--~--~-~--~~~---~--~~
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: Spaces in table names nightmare

[Tom MacKean]

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 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] Spaces in table names nightmare

[Tom MacKean]

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 these as table names. How do I do it? Do I have to escape it in some obscure way. Google has been no help.
 
Thanks,
 
Tom
 
-- IMPORTANT: This email is intended for the use of the individual addressee(s) named above and may contain information that is confidential privileged or unsuitable for overly sensitive persons with low self-esteem, no sense of humor or irrational religious beliefs. If you are not the intended recipient, any dissemination, distribution or copying of this email is not authorized (either explicitly or implicitly) and constitutes an irritating social fauxpas. No animals were harmed in the transmission of this email, although the mutt next door is living on borrowed time, let me tell you. 


--~--~-~--~~~---~--~~
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: Converting HTML to PDF an retaining anchors

[Tom MacKean]

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" <
 [EMAIL PROTECTED]>>Reply-To: cfaussie@googlegroups.com>To: "CFAussie Mailing List" <
cfaussie@googlegroups.com >>Subject: [cfaussie] Converting HTML to PDF an retaining anchors
>Date: Tue, 4 Apr 2006 20:03:26 +1000>>Hey guys>>This is pretty urgent and I have come up with nothing really.  I have tried >a number of product and none seem to work as I want them.
>>I have a HTML document which I need to convert to PDF, well a few thousand>of them actually and I need to have the PDF retain the hyperlinks and >anchors that are in the HTML.>>Does anyone know of anything that will allow me to do this?
>>Regards>Steve Onnis>>>_ 
realestate.com.au: the biggest address in propertyhttp://ninemsn.realestate.com.au
-- IMPORTANT: This email is intended for the use of the individual addressee(s) named above and may contain information that is confidential privileged or unsuitable for overly sensitive persons with low self-esteem, no sense of humor or irrational religious beliefs. If you are not the intended recipient, any dissemination, distribution or copying of this email is not authorized (either explicitly or implicitly) and constitutes an irritating social fauxpas. No animals were harmed in the transmission of this email, although the mutt next door is living on borrowed time, let me tell you. 

--~--~-~--~~~---~--~~
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: OT: XML vs database

[Tom MacKean]

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 forinteroperability?Just thought this may be relevant to what you are doing and influenceyour design:
http://www.nehta.gov.au/content/view/63/112/Sean-- IMPORTANT: This email is intended for the use of the individual addressee(s) named above and may contain information that is confidential privileged or unsuitable for overly sensitive persons with low self-esteem, no sense of humor or irrational religious beliefs. If you are not the intended recipient, any dissemination, distribution or copying of this email is not authorized (either explicitly or implicitly) and constitutes an irritating social fauxpas. No animals were harmed in the transmission of this email, although the mutt next door is living on borrowed time, let me tell you. 

--~--~-~--~~~---~--~~
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: OT: XML vs database

[Tom MacKean]

Thank you all for your replies. I will indeed use a database, use a database, use a database. (It's half built anyway). 
 

I just started thinking about XML because I was looking at my iTunes library file (which is XML) and it seemed like the same sort of structure as my doctors list - that is, it's all about one particular item (song/doctor) with lots of disparate properties. 

 
Thanks,
 
Tom   
On 4/3/06, Dale Fraser <[EMAIL PROTECTED]> wrote:
XML is fine for small data sets, easy enough to parse and process usingXpath (xmlSearch).But for 5000, records I think a database would be better, it's quicker and
more robust, the XML model would be more appropriate for very small datasetsie < 100 records perhaps.With XML you have to read and parse all 5000 records every time you make andaddition or update. Ie:
1. Read all 5000 records from disk file2. Parse all 5000 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, 3 April 2006 10:51 AM> To: cfaussie@googlegroups.com> Subject: [cfaussie] OT: XML vs database>> 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 can have multiple addresses> * Addresses can have multiple doctors> * Doctors can have multiple provider numbers> * Only one person at a time needs to be able to use this application
> so locking it is fine.> * It doesn't have to be particularly fast> * There will be about 5000 doctors>> It seemed to me that creating  and then having multiple 
> and  etc would be easier than lots of relational tables> linked by keys.>> What is everyone's opinion on using XML in this way? How easy is it to> read/filter/update data store in an XML page like this? Should I just
> stick to the db?>> Tom>>>> --> IMPORTANT: This email is intended for the use of the individual> addressee(s) named above and may contain information that is confidential
> privileged or unsuitable for overly sensitive persons with lowself-esteem,> no sense of humor or irrational religious beliefs. If you are not the> intended recipient, any dissemination, distribution or copying of this
> email is not authorized (either explicitly or implicitly) and constitutes> an irritating social fauxpas. No animals were harmed in the transmission> of this email, although the mutt next door is living on borrowed time, let
> me tell you.>>> >-- IMPORTANT: This email is intended for the use of the individual addressee(s) named above and may contain information that is confidential privileged or unsuitable for overly sensitive persons with low self-esteem, no sense of humor or irrational religious beliefs. If you are not the intended recipient, any dissemination, distribution or copying of this email is not authorized (either explicitly or implicitly) and constitutes an irritating social fauxpas. No animals were harmed in the transmission of this email, although the mutt next door is living on borrowed time, let me tell you. 

--~--~-~--~~~---~--~~
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] OT: XML vs database

[Tom MacKean]

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 can have multiple addresses
Addresses can have multiple doctors
Doctors can have multiple provider numbers
Only one person at a time needs to be able to use this application so locking it is fine.
It doesn't have to be particularly fast
There will be about 5000 doctors
It seemed to me that creating  and then having multiple  and  etc would be easier than lots of relational tables linked by keys.
 
What is everyone's opinion on using XML in this way? How easy is it to read/filter/update data store in an XML page like this? Should I just stick to the db?
 
Tom
-- IMPORTANT: This email is intended for the use of the individual addressee(s) named above and may contain information that is confidential privileged or unsuitable for overly sensitive persons with low self-esteem, no sense of humor or irrational religious beliefs. If you are not the intended recipient, any dissemination, distribution or copying of this email is not authorized (either explicitly or implicitly) and constitutes an irritating social fauxpas. No animals were harmed in the transmission of this email, although the mutt next door is living on borrowed time, let me tell you. 


--~--~-~--~~~---~--~~
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: Select Boxes

[Tom MacKean]

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 in between up to your character total.
 
You'd have to use a monospace font in your option.
 
Just a thought...
 
Tom
 
On 3/27/06, Steve Onnis <[EMAIL PROTECTED]> wrote:


in the same option?


-Original Message-From: cfaussie@googlegroups.com
 [mailto:cfaussie@googlegroups.com]On Behalf Of KNOTT, BrianSent: Monday, March 27, 2006 9:28 AM
To: cfaussie@googlegroups.comSubject: [cfaussie] Select Boxes


Is there any way to have to items in a select box, one left aligned and one right aligned.  I have a customer who want to display 2 pieces of information in the dropdown box, but have the second piece right aligned.

 
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: Uploading databases to SQLServer 2005

[Tom MacKean]

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.sqlmanager.net/en/products/mssql/manager/download
 
Tom 
On 3/10/06, M@ Bourke <[EMAIL PROTECTED]> wrote:

>Alarm bells are ringing here at AFPWebworks Central - our NEVER BE A PIONEER alarm is >going off.
Like someone else said be sure to check out the forums on sqlservercentral

--~--~-~--~~~---~--~~
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: Application.cfc refresh

[Tom MacKean]

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);   structClear(session);   onApplicationStart();   onSessionStart();
   }This improved version will even compile without syntax errors! :-P__Robin HilliardDirector - RocketBoots Pty LtdProfessional Services for Macromedia Technologies
http://www.rocketboots.com.auFor schedule/availability call Pamela Higgins:w+61 7 5451 0362m+61 419 677 151e
[EMAIL PROTECTED]or Direct:m+61 418 414 341f+61 2 9798 0070e[EMAIL PROTECTED]*** Quick! Ring Geoff up and beg him to accept your late
-- IMPORTANT: This email is intended for the use of the individual addressee(s) named above and may contain information that is confidential privileged or unsuitable for overly sensitive persons with low self-esteem, no sense of humor or irrational religious beliefs. If you are not the intended recipient, any dissemination, distribution or copying of this email is not authorized (either explicitly or implicitly) and constitutes an irritating social fauxpas. No animals were harmed in the transmission of this email, although the mutt next door is living on borrowed time, let me tell you. 

--~--~-~--~~~---~--~~
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: Application.cfc refresh

[Tom MacKean]

That makes sense. Ta.
On 2/22/06, Shib71 <[EMAIL PROTECTED]> wrote:
OnApplicationStart only runs the first time a page with that application name is run. You should only put stuff that will never change, or needs to be initialized there. If you're playing with those settings for development, 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 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 show APPLICATION.dsn as being sydneyivf_local
 
What is the best way to clear old values to make this change happen? Anybody got a "best practice"?
 
Thanks,
 
Tom-- IMPORTANT: This email is intended for the use of the individual addressee(s) named above and may contain information that is confidential privileged or unsuitable for overly sensitive persons with low self-esteem, no sense of humor or irrational religious beliefs. If you are not the intended recipient, any dissemination, distribution or copying of this email is not authorized (either explicitly or implicitly) and constitutes an irritating social fauxpas. No animals were harmed in the transmission of this email, although the mutt next door is living on borrowed time, let me tell you. 

--~--~-~--~~~---~--~~
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] Application.cfc refresh

[Tom MacKean]

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 show APPLICATION.dsn as being sydneyivf_local
 
What is the best way to clear old values to make this change happen? Anybody got a "best practice"?
 
Thanks,
 
Tom-- IMPORTANT: This email is intended for the use of the individual addressee(s) named above and may contain information that is confidential privileged or unsuitable for overly sensitive persons with low self-esteem, no sense of humor or irrational religious beliefs. If you are not the intended recipient, any dissemination, distribution or copying of this email is not authorized (either explicitly or implicitly) and constitutes an irritating social fauxpas. No animals were harmed in the transmission of this email, although the mutt next door is living on borrowed time, let me tell you. 


--~--~-~--~~~---~--~~
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: WebDu Who's going ?

[Tom MacKean]

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://lindsayevans.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] Escaping characters in a replace statement

[Tom MacKean]

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 contain information that is confidential privileged or unsuitable for overly sensitive persons with low self-esteem, no sense of humor or irrational religious beliefs. If you are not the intended recipient, any dissemination, distribution or copying of this email is not authorized (either explicitly or implicitly) and constitutes an irritating social fauxpas. No animals were harmed in the transmission of this email, although the mutt next door is living on borrowed time, let me tell you. 


--~--~-~--~~~---~--~~
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: Remember this pic? - !!! NSFW !!!

[Tom MacKean]

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 I stated, the taxi guy wanted his fair, he had to get out of the 
car and come to by door and ask for it... i don't respond to hornhonks.Ahh... drinks to be had at WebDU... (noise ratio gone up 2 unitstoday, thanks to moi).On 1/27/06, M@ Bourke <
 [EMAIL PROTECTED]> wrote:> >Strippers are evil anyway, ask M@ about that fact.>> Listen here Jerry, you were the one going out with a stripper while in a> competition with your friends at the same time also being stalked by a taxi 
> driver, and being refused service at the local soup store.>--Regards,Scott Barnes
http://www.mossyblog.com-- IMPORTANT: This email is intended for the use of the individual addressee(s) named above and may contain information that is confidential privileged or unsuitable for overly sensitive persons with low self-esteem, no sense of humor or irrational religious beliefs. If you are not the intended recipient, any dissemination, distribution or copying of this email is not authorized (either explicitly or implicitly) and constitutes an irritating social fauxpas. No animals were harmed in the transmission of this email, although the mutt next door is living on borrowed time, let me tell you. 

[cfaussie] Re: Remember this pic?

[Tom MacKean]

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 list to post random thoughts one conjures during the day.
On 1/24/06, TRACEY, Darren <[EMAIL PROTECTED]> wrote:>> Would it kill you to quote just a little bit of the original email that you
> are responding to?> It can be a real chore to try to follow what you're talking about sometimes> Peter.>> Regards>> Darren Tracey> Systems Analyst> HR Systems and Fastrack
> Wealth and Corporate Systems> Suncorp> p: + 61 7 3232 4019 (x64019)> f: + 61 7 3232 4133> e: [EMAIL PROTECTED]> l: Lvl 12, 388 Queen St Brisbane QLD 4000
> m: Suncorp IPC IT064, GPO Box 1453, Brisbane QLD 4000> > -Original Message-> > From: ACTCFUG [mailto:[EMAIL PROTECTED]]> > Sent: Monday, 23 January 2006 7:14 PM
> > To: cfaussie> > Subject: [cfaussie] Re: Remember this pic?> >> >> > So I take it "Gavin" is not pictured or you have contempt for user> > group managers.
>> ---> 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.>>>--
Regards,Scott Barneshttp://www.mossyblog.com-- IMPORTANT: This email is intended for the use of the individual addressee(s) named above and may contain information that is confidential privileged or unsuitable for overly sensitive persons with low self-esteem, no sense of humor or irrational religious beliefs. If you are not the intended recipient, any dissemination, distribution or copying of this email is not authorized (either explicitly or implicitly) and constitutes an irritating social fauxpas. No animals were harmed in the transmission of this email, although the mutt next door is living on borrowed time, let me tell you. 

[cfaussie] Re: Looking for Oz based CFMX 7 web hosting provider

[Tom MacKean]

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 owned by? Anyone know?CheersGareth. 
Dmitry Yakhnov wrote: 

http://www.hostingfuse.com/index.php?fuseaction=hosting.planOptima


ACTCFUG wrote:
  
Not even Web Central seem to support MX 7 which is pretty
dissapointing. Any suggestions?
  -- IMPORTANT: This email is intended for the use of the individual addressee(s) named above and may contain information that is confidential privileged or unsuitable for overly sensitive persons with low self-esteem, no sense of humor or irrational religious beliefs. If you are not the intended recipient, any dissemination, distribution or copying of this email is not authorized (either explicitly or implicitly) and constitutes an irritating social fauxpas. No animals were harmed in the transmission of this email, although the mutt next door is living on borrowed time, let me tell you.