[cfaussie] Re: Date format
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] Date format
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: Date format
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. cfset mydate = createdate(1962,2,2) cfset refdate = dateadd(d, -716640, mydate) cfoutput #dateformat(refdate, '/mm/dd')# /cfoutput 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] Re: Date format
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. cfset mydate = createdate(1962,2,2) cfset refdate = dateadd(d, -716640, mydate) cfoutput #dateformat(refdate, '/mm/dd')# /cfoutput 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
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: SOT: Local domain names
*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
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: 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 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-matter-of-opin ion/ That last one above is from a CF perspective, and does discuss the question from the perspective of what if I *do* want all the columns. I'll leave it to you and
[cfaussie] Re: Why select * is bad (was RE: [cfaussie] Re: @#$!! Queryparam)
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 -~--~~~~--~~--~--~--- attachment: attfc7c2.jpg
[cfaussie] Re: OT: Moving to Sydney
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=38osCsid=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] Getting a NT user's name
Using cfNTauthenticate I can get a user to log in and check that they are part of the domain. But if they are already logged onto thenetwork and are browsing the page from a logged on machine,is it possible to collect the user name without making them log in? i.e. Can CF find out which NT user is 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: Getting a NT user's name
Thanks On 10/24/06, grant [EMAIL PROTECTED] wrote: if they're already logged in the username and domain should bein 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 thenetwork and are browsing the page from a logged on machine,is it possible to collect the user name without making them log in? i.e. Can CF find out which NT user is 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] decimal places
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: decimal places
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] Re: decimal places
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: Cool flash countdown clock
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] mailto: [EMAIL PROTECTED] wrote: pretty cool, i like the throwing action Regards, Bjorn Schultheiss Senior Flash Developer QDC Technologies *From:* cfaussie@googlegroups.com mailto: cfaussie@googlegroups.com [mailto: cfaussie@googlegroups.com mailto:cfaussie@googlegroups.com ] *On Behalf Of *Shane Farmer *Sent:* Monday, 28 August 2006 11:49 PM *To:* cfaussie@googlegroups.com mailto: 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] mailto:[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 http://dale.fraser.id.au/ -Original Message- From: cfaussie@googlegroups.com mailto: cfaussie@googlegroups.com [mailto: cfaussie@googlegroups.com mailto:cfaussie@googlegroups.com] On Behalf Of Mike Kear Sent: Monday, 28 August 2006 13:59 PM To: cfaussie@googlegroups.com mailto: 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 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: Includes
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: cfcomponent !--- All your onApplicationStart/End, onSessionStart/End,
onRequestStart/End, etc, etc. --- cffunction name=maxFunc output=false returnType=string access=public hint=cfargument name=str type=string required=true /
cfset var returnStr = ReturnVal: arguments.str /cfreturn returnStr / /cffunction /cfcomponent Call you function from any .cfm page:
Hello Maxbr cfdump var=#maxFunc('Well Hello Back!')# 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
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 cffunction name=onRequest returnType=void output=true cfargument name=targetPage type=string required=true/ cfinclude template=#arguments.targetPage# /cffunction Cheers,MaxMike Kear wrote: I have functions in Application.cfc that are outside the normal methods.i.e. not inside onRequestStart or onApplicationStart etcIt 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] 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. --~--~-~--~~~---~--~~ 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
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] 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 SQLquery. Tom On 6/28/06, Tom MacKean [EMAIL PROTECTED] wrote: mySQL On 6/28/06, Steve Onnis [EMAIL PROTECTED] wrote: what database platform? -Original Message-From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com]On Behalf Of Tom MacKeanSent: 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
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 SQLquery. Tom On 6/28/06, Tom MacKean [EMAIL PROTECTED] wrote: mySQL On 6/28/06, Steve Onnis [EMAIL PROTECTED] wrote: what database platform? -Original Message-From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com]On Behalf Of Tom MacKeanSent: 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
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: Includes
...and we're back to the start :) On 6/29/06, Joel Cass [EMAIL PROTECTED] wrote: Daleall you would need to do is put one line before your code:cfset tr= application.myUdf.tr-Original Message-From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com ]OnBehalf Of Dale FraserSent: Thursday, 29 June 2006 2:20 PMTo: cfaussie@googlegroups.comSubject: [cfaussie] Re: IncludesSteve,I could have done this just by doing cfset application.myUdf = createObjectIt 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 withcffunction name=onApplicationStart cfset this.name = testApp / cfinclude template= function.cfm cfset application.udf = structNew() / cfloop collection=#variables# item=v cfif NOTlistFindNoCase(onApplicationStart,onApplicationEnd,onRequestStart,onRequest End,onSessionStart,onSessionEnd,onError,onRequest, v) cfif isCustomFunction(variables[v]) cfset application.udf[v] = variables[v] / /cfif /cfif /cfloop/cffunctionall 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: +6138676 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 cfset also didn't work.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:-cfset variables.tr = this.trin 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: OT: Dreamweaver - Managing Sites
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: +6138676 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] Dreamweaver not overwritting files
UncheckMaintain syncronization information in the Remote Info panel Tom On 6/8/06, Chad Renando [EMAIL PROTECTED] wrote: I have.I suspect it has something to do with dreamweaver notoverwriting a file if it is seen as the same on the server.I typically delete the server file and reupload, 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
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] Exporting settings
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: Exporting settings
Thanks, I'll give it a go On 6/5/06, cfgroupie [EMAIL PROTECTED] wrote: Yes you can.But it depends on what version. I do it by creating a .car file andthen just re-instating it. Works a charm. I know with BlueDragon you have an entire XML that stores it but I don't believe CFMX7 does.Jeremy-- 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
My big book of _javascript_ suggests that you might need a semicolon after var image1 = new Image() (and the other similar lines) e.g. scriptvar image1 = new Image();image1.src = "">var image2 = new Image();image2.src = "" var image3 = new Image();image3.src = "">var image4 = new Image();image4.src = "" /script 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: OT: apache error - why not several hosts?
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 urlstakes 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 *:80VirtualHost * 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/VirtualHostVirtualHost * 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/VirtualHostVirtualHost * 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 /VirtualHost--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: Spaces in table names nightmare
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] Re: Converting HTML to PDF an retaining anchors
The full version of Adobe Acrobat will create a PDF from a web page. Just type Shift-ctrl-O and select the page. It doesn't always deal with css that well, but it's mostly good. Tom On 4/5/06, Mark Ireland [EMAIL PROTECTED] wrote: There is a java thing called iTextFrom: Steve Onnis [EMAIL PROTECTED]Reply-To: cfaussie@googlegroups.comTo: CFAussie Mailing List cfaussie@googlegroups.com Subject: [cfaussie] Converting HTML to PDF an retaining anchors Date: Tue, 4 Apr 2006 20:03:26 +1000Hey guysThis 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 thousandof 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? RegardsSteve 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
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] 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 doctor and then having multiple address and providernumber etcwould 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: OT: XML vs database
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 doctor and then having multiple address and providernumber 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] Application.cfc refresh
OK. I'm starting to get the hang of these Application.cfc things. However, if I change a value, that change is not reflected straight away. eg. if, in my OnApplicationStart function, I define cfset APPLICATION.dsn = sydneyivf_local. Later, I want to change this to sydneyivf_server, the change 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: Application.cfc refresh
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 cfset APPLICATION.dsn = sydneyivf_local. 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: Application.cfc refresh
Maybe on your computer... I had to put brackets around my if _expression_
Thanks
Tom
On 2/22/06, Robin Hilliard [EMAIL PROTECTED] wrote:
On 22/02/2006, at 1:43 PM, Robin Hilliard wrote: Probably best enough...
cfscript if structKeyExists(url, reset) { structClear(application); structClear(session); onApplicationStart(); onSessionStart();
}/cfscriptThis 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: Remember this pic? - !!! NSFW !!!
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.
