from:"christophe albrech"

Re: [cfaussie] SQL identity issue

2016-01-28 Thread Christophe Albrech

By the way, if you do everything in sql, you should use "SELECT
scope_identity()" instead of "SELECT @@identity". The reason being that if
your insert calls a trigger on that table that in turns inserts a row in
another table, scope_identity() would return the id of the new row you
explicitly inserted, while @@identity would return the id of the row
inserted by the trigger.

On Wed, Jan 27, 2016 at 12:09 PM, Paul Kukiel  wrote:

> Less code, and database agnostic.  Behind the scenes it probably does the
> same thing.
>
> On Wed, Jan 27, 2016 at 12:01 PM, Mike K  wrote:
>
>> Whats the advantage of returning result.getPrefix().generatedkey  rather
>> than using the @@identity function of the database?
>>
>> Is it just to make it database agnostic?  or is there another reason for
>> it?
>>
>>
>> Cheers
>> Mike Kear
>> Windsor, NSW, Australia
>> Adobe Certified Advanced ColdFusion Developer
>> AFP Webworks
>> http://afpwebworks.com
>>
>> --
>> You received this message because you are subscribed to the Google Groups
>> "cfaussie" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to cfaussie+unsubscr...@googlegroups.com.
>> To post to this group, send email to cfaussie@googlegroups.com.
>> Visit this group at https://groups.google.com/group/cfaussie.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>
>
> --
> Paul Kukiel
>
> --
> You received this message because you are subscribed to the Google Groups
> "cfaussie" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to cfaussie+unsubscr...@googlegroups.com.
> To post to this group, send email to cfaussie@googlegroups.com.
> Visit this group at https://groups.google.com/group/cfaussie.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
You received this message because you are subscribed to the Google Groups 
"cfaussie" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to cfaussie+unsubscr...@googlegroups.com.
To post to this group, send email to cfaussie@googlegroups.com.
Visit this group at https://groups.google.com/group/cfaussie.
For more options, visit https://groups.google.com/d/optout.

Re: [cfaussie] Has anyone used the HierarchyID data type in MS SQLServer?

2016-01-28 Thread Christophe Albrech

Nested sets are so rad. I fell in love with them back when I read joe
celko's "sql for smarties" and its companion book "tree and hierarchies in
sql". Way to think outside the box. It just gets a bit more complex when it
comes to moving nodes around, but if you have the sprocs handy, you're in
business.

As far as the hierarchy datatype, I've only played with it briefly to study
for a cert. It works well, as far as I remember. While under the hood it's
pretty much a binary representation of materialized path implementation,
the fact that it's a CLR object means it comes with a bunch of helper
methods out of the box. Very much like spatial data, if you've ever worked
with it (again, awesome).

What I am wondering is why you are considering the change if you are happy
with the speed and stability of your current implementation (or are you
just curious?). Also consider the fact that using the hierarchyID will make
it harder to move to a different DBMS or a pre-2008 server if the need
arises.

To answer your question based on my experimentation and readings, no, MS is
not full of it, and yes it's a step in the right direction. Just like CF
has always kept adding support for new stuff (xpath, cfdocument...),
microsoft is doing the same and that's a good thing.




On Wed, Jan 27, 2016 at 6:05 PM, Mike K  wrote:

> Kevan Stannard

-- 
You received this message because you are subscribed to the Google Groups 
"cfaussie" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to cfaussie+unsubscr...@googlegroups.com.
To post to this group, send email to cfaussie@googlegroups.com.
Visit this group at https://groups.google.com/group/cfaussie.
For more options, visit https://groups.google.com/d/optout.

Re: [cfaussie] Companies Using ColdFusion

2015-09-08 Thread Christophe Albrech

For sure man. People have been defending cf for years saying that nope, it
is not going anywhere, but now even the most prolific bloggers in the cf
community have all but jumped ship (not a stab at them, by the way). There
will be a CF12, maybe a CF13, but I'd say that's about it. There are still
jobs out there, though. Porting a big-enough app to a different language is
neither easy nor cheap, and some company can't be bothered or don't have
the forethought to do it in the first place. We're becoming the new cobol
developers, guys. Yay.

On Tue, Sep 8, 2015 at 6:56 PM, Samaris  wrote:

> It's all sad news especially for programmers like myself who I my have cf
> coding skills seeking work
>
> Claude Raiola
> SAMARIS Software
> www.SAMARIS.net
> 1300 255 990
>
> On 8 Sep 2015, at 6:36 pm, Andrew Scott  wrote:
>
> Adobe in my opinion have no clue about the product, serious bugs can take
> them years to even fix and even if they do, there is no guarantee that they
> will be released for current supported versions. Most times, they get
> released with the next version only.
>
> I raised a concurrency issue with ColdFusion 10, that is really a serious
> issue with the Application scope and it took Adobe 3-4 years to actually
> fix it. Nobody can wait that length of time while trying to get work done.
>
> Most places still using ColdFusion are 3 or more versions behind the
> current version, which is obviously a cost factor in upgrading.
>
> I mean Windows 10 has been stable for a very long time, Adobe had the
> chance to make sure they released connectors that would work on Windows 10
> and yet, to this date I haven't seen any updates for it. They only have
> themselves to blame.
>
>
> Regards,
> Andrew Scott
>
>
> On Tue, Sep 8, 2015 at 6:20 PM, Samaris  wrote:
>
>> Thanks
>>
>> Claude Raiola
>> SAMARIS Software
>> www.SAMARIS.net
>> 1300 255 990
>>
>> --
> You received this message because you are subscribed to the Google Groups
> "cfaussie" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to cfaussie+unsubscr...@googlegroups.com.
> To post to this group, send email to cfaussie@googlegroups.com.
> Visit this group at http://groups.google.com/group/cfaussie.
> For more options, visit https://groups.google.com/d/optout.
>
> --
> You received this message because you are subscribed to the Google Groups
> "cfaussie" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to cfaussie+unsubscr...@googlegroups.com.
> To post to this group, send email to cfaussie@googlegroups.com.
> Visit this group at http://groups.google.com/group/cfaussie.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
You received this message because you are subscribed to the Google Groups 
"cfaussie" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to cfaussie+unsubscr...@googlegroups.com.
To post to this group, send email to cfaussie@googlegroups.com.
Visit this group at http://groups.google.com/group/cfaussie.
For more options, visit https://groups.google.com/d/optout.

Re: [cfaussie] Companies Using ColdFusion

2015-09-08 Thread Christophe Albrech

and SQL, too.

-- 
You received this message because you are subscribed to the Google Groups 
"cfaussie" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to cfaussie+unsubscr...@googlegroups.com.
To post to this group, send email to cfaussie@googlegroups.com.
Visit this group at http://groups.google.com/group/cfaussie.
For more options, visit https://groups.google.com/d/optout.

Re: [cfaussie] When did ColdFusion 10 get released?

2012-05-16 Thread christophe albrech

May 15, 2012 will always be remembered in history as the day CF10 was
released. Oh no wait, I meant Diablo 3.

On Wed, May 16, 2012 at 5:46 PM, Andrew Myers am2...@gmail.com wrote:

 I first saw an announcement yesterday

 Sent from my mobile

 On 16/05/2012, at 5:39 PM, Mark Picker mark.pic...@det.nsw.edu.au wrote:

 I was just having a look for something on the Adobe site and clicked on
 the Products/ColdFusion link and noticed that everything is ColdFusion 10.
 I didn't think it was being released until later in the year?

 http://www.adobe.com/products/coldfusion-family.html

 Cheers
 Mark

 --
 You received this message because you are subscribed to the Google Groups
 cfaussie group.
 To view this discussion on the web visit
 https://groups.google.com/d/msg/cfaussie/-/_YEsjmQGcuUJ.
 To post to this group, send email to cfaussie@googlegroups.com.
 To unsubscribe from this group, send email to
 cfaussie+unsubscr...@googlegroups.com.
 For more options, visit this group at
 http://groups.google.com/group/cfaussie?hl=en.

  --
 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
 cfaussie+unsubscr...@googlegroups.com.
 For more options, visit this group at
 http://groups.google.com/group/cfaussie?hl=en.


-- 
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 
cfaussie+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.

Re: [cfaussie] Re: Recommendations for a CF Framework.

2012-02-19 Thread christophe albrech

But it can have performance implications at the DB level.

   - If not sequential, Index fragmentation ensues. Page splits, too.
   - As the UUID is probably the clustering key, it gets added to all NCIs,
   which in turn become larger and slower.
   - Database gets bigger. That means less stuff in proc and data cache,
   more io, longer backups and disaster recovery procedure.

That said, they are, indeed pretty useful to move stuff around. And using
sequential UUID does a good job of limiting the damage. No idea what far
cry does under the hood though, so I'll stop bitching.

Tof

On Sun, Feb 19, 2012 at 11:57 PM, Dennis Clark boomf...@gmail.com wrote:

 Mark, what makes you think I was hating on FarCry?

 FarCry is f**king AWESOME, and to think otherwise is RETARDED.

 I guess people don't get my humour either :-)

 And yes, FarCry does use UUIDs all over the place, but it that's a good
 thing. It means no autonumber conflicts!

 -- Dennis
 On Feb 18, 2012 12:50 PM, Mark Picker mark.pic...@det.nsw.edu.au
 wrote:

 @Dennis.  I don't understand the FarCry hate.  What version are you
 talking about?  We have been running FarCry from when it was just a
 CMS but have recently made the jump to 6.1.3.  I do get that it can be
 confusing to someone who is new to it. Even though the documentation
 still needs some more love, it has gotten a lot better.  I recently
 went through the Developer Jump Start course (available from the
 FarCry wiki) and was blown away yet again at how powerful FarCry is
 when you start to dig into it.

 To someone learning to use FarCry (6+), make sure you have a good look
 at application.fapi.  Especially application.fapi.getContentObjects().

 @Zac. Depends if your using Friendly URL's.  Also depends if you use
 aliases (which is way easier to work with).

 Cheers
 Mark


 On Feb 17, 2:15 pm, Dennis Clark boomf...@gmail.com wrote:
  As others have said there are plenty of CF frameworks to choose from.
 One
  that hasn't been mentioned yet is FarCry. As a CMS it works well, but
 one
  non-scientific study found a strong correlation between prolonged
 exposure
  to FarCry and excessive use of expletives such as f**k, c**k, and
  dogr***er. The study was unable to prove or disprove causation, but
  recommends developers exposed to FarCry exercise caution and be on the
  lookout for these known symptoms.
 
  Hope that helps,
 
  -- Dennis
  On Feb 17, 2012 12:36 PM, MossyBlog scott.bar...@gmail.com wrote:
 
 
 
   Firstly, kudos for sticking it out with CF all these years! :)
 
   Secondly, I'm keen to brush the dust off my old CF skills and try it
   out again feeling more armed in the plethora of languages I've
   acquired over the years. That being said, I'm also keen to see what
   all the cool kids are using with regards to CF after market addons.
 
   Mach-II? or did i just show my age.
 
   --
   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
   cfaussie+unsubscr...@googlegroups.com.
   For more options, visit this group at
  http://groups.google.com/group/cfaussie?hl=en.

 --
 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
 cfaussie+unsubscr...@googlegroups.com.
 For more options, visit this group at
 http://groups.google.com/group/cfaussie?hl=en.

  --
 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
 cfaussie+unsubscr...@googlegroups.com.
 For more options, visit this group at
 http://groups.google.com/group/cfaussie?hl=en.


-- 
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 
cfaussie+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.

Re: [cfaussie] Re: Recommendations for a CF Framework.

2012-02-19 Thread christophe albrech

Yes, but as a rule of thumb (in most cases) I don't like having my
clustered index on something else than the pk. That's most likely what
you'll use to get to your data, which means that if you do put CIX on
another column, you open the door to a world of pain in terms of bookmark
look-ups.

Just theoritical talk, though. I've never used farcry, thus have no idea
how fast it is, or how well it scales.

Tof

On Mon, Feb 20, 2012 at 3:38 PM, Justin Carter justin.w.car...@gmail.comwrote:

 On Feb 20, 10:11 am, christophe albrech christophe.albr...@gmail.com
 wrote:
  But it can have performance implications at the DB level.
 
 - If not sequential, Index fragmentation ensues. Page splits, too.
 - As the UUID is probably the clustering key, it gets added to all
 NCIs,
 which in turn become larger and slower.
 - Database gets bigger. That means less stuff in proc and data cache,
 more io, longer backups and disaster recovery procedure.
 
  That said, they are, indeed pretty useful to move stuff around. And using
  sequential UUID does a good job of limiting the damage. No idea what far
  cry does under the hood though, so I'll stop bitching.
 
  Tof


 FarCry doesn't lock you into anything in this regard, you can avoid
 fragmentation and page splits by making objectid a non-clustered index
 and setting your clustered index to something more suitable, as you
 would do in any database that you needed to tune for performance. For
 those content types with millions of rows you'd also set bRefObjects
 to false in your component to avoid writing to FarCry's master table
 of objects and specify the content type name in any ORM related
 functions, instead of letting FarCry look it up automatically.

 cheers,
 Justin

 --
 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
 cfaussie+unsubscr...@googlegroups.com.
 For more options, visit this group at
 http://groups.google.com/group/cfaussie?hl=en.



-- 
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 
cfaussie+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.

Re: [cfaussie] Re: cfchart

2012-02-16 Thread christophe albrech

Hey Charlie,

Instead of having a just list of things, have you considered making it a
little app where developers can comment and rate each item like the review
system on amazon? Maybe even a rating system like ebay with 3-5 rows of
star (price, ease of use, responsiveness...) That might give it a bit more
traction, especially if you can order items by category and rating. Fuck
dude, make it a mobile app ;-)

Don't go thinking people don't appreciate your efforts buddy, I'm sure
everyone on here's either watched some of your recorded preso, or clicked
on a link on cf411 (which is a poor name I think, because no one outside of
the US would have a goddamn idea what 411 refers to, let alone remember
it). do you have google analytics on it, so you can see who goes there and
how often?

Cheers,

Tof

P.S.: Sorry about all the swearing. This is Oz, that's what we do :-D



On Thu, Feb 16, 2012 at 7:30 AM, charlie arehart charlie_li...@carehart.org
 wrote:

 Thanks, Brett. That’s an…interesting…way to look at it. :-) I suppose I
 see that benefit.

 And if at least others did mention it when such questions came up, I’d be
 happy to see that. Otherwise it seems I’m usually the only one (on this and
 other lists), even when I wait a couple of days to see if anyone else does.
 That’s a bit disheartening—and may even make some think that no one else
 knows or cares about it. I appreciate your (and Peter’s) kind regards then
 all the more.

 As for your appreciating that you hear from others offering alternatives
 when someone asks if there are any, I’ll note this: certainly if someone
 asks folks to share their experience working with alternatives (not just
 “what are alternatives”), then that’s when it makes sense for folks to
 share individual alternatives, with added opinion, since I don’t offer that
 on the category lists.

 But when someone just asks, “what are alternatives for x”, it would just
 be nice to see someone point out (in addition to any they may favor) that
 “you can find more alternatives in that category at cf411.com”. :-) Not
 everyone reads every message in every thread, so I’m sure there are always
 some who would not already know about it. Thanks for letting me vent  for a
 minute, folks. :-)

 /charlie

 ** **

 *From:* cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] *On
 Behalf Of *Brett Payne-Rhodes
 *Sent:* Wednesday, February 15, 2012 1:59 AM
 *To:* cfaussie@googlegroups.com
 *Subject:* Re: [cfaussie] Re: cfchart

 ** **

 For myself at least there is a huge finge benefit to people NOT going
 directly to CF411.com and that is that I get to hear and learn about these
 really useful tools before I actually need them... Plus I get reminded
 about the site as well.

 Thanks for the great resource Charlie. It might not be top-of-mind but it
 is definitely appreciated.

 B)

 ** **

 --
 You received this message because you are subscribed to the Google Groups
 cfaussie group.
 To post to this group, send email to cfaussie@googlegroups.com.
 To unsubscribe from this group, send email to
 cfaussie+unsubscr...@googlegroups.com.
 For more options, visit this group at
 http://groups.google.com/group/cfaussie?hl=en.


-- 
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 
cfaussie+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.

Re: [cfaussie] Re: Convert cf date to milliseconds since the epoch?

2012-02-16 Thread christophe albrech

At my work, we even have custom ones. When people whinge, we say they
scrunch because frowning makes their face look like a scrunchie (
http://www.fancypocket.sg/images/P/703998P.jpg).

There's also this one girl who scrunches all the time and has massive...
well, you know. We call her Whine-rack.

Tof

On Thu, Feb 16, 2012 at 2:49 PM, Andrew Myers am2...@gmail.com wrote:

 I use them interchangeably Charlie.  It even together.  My kids are so
 good at it they 'whinge and whine' all day!

 Sent from my mobile

 On 16/02/2012, at 2:21 PM, charlie arehart charlie_li...@carehart.org
 wrote:

  Yeah, leave such whining to me. :-) Thinking of my note earlier today.
  Groan. Sorry 'bout that, folks.
 
  Actually, don't you guys say whinging anyway? :-)
 
  /charlie
 
 
  -Original Message-
  From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On
  Behalf Of Andrew Myers
  Sent: Wednesday, February 15, 2012 9:02 PM
  To: cfaussie@googlegroups.com
  Subject: Re: [cfaussie] Re: Convert cf date to milliseconds since the
  epoch?
 
  I think I'll just do what i was initially trying to do and write a
  function that creates a Java date and be done with it.
 
  In fact if I'd have stopped whining and just written the damn thing id
  be on to the next problem by now :)
 
 
  On 16/02/2012, at 12:43 PM, Steve Onnis st...@cfcentral.com.au
  wrote:
 
  CreateDate() ?
 
 
  --
  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
 cfaussie+unsubscr...@googlegroups.com.
  For more options, visit this group at
 http://groups.google.com/group/cfaussie?hl=en.
 

 --
 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
 cfaussie+unsubscr...@googlegroups.com.
 For more options, visit this group at
 http://groups.google.com/group/cfaussie?hl=en.



-- 
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 
cfaussie+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.

Re: [cfaussie] Re: cfchart

2012-02-16 Thread christophe albrech

Ah ok. Sorry your quote must be from a previous email and I had only read
the latest one.

 As for 411, I understand that it is too late now to rebrand, but I don't
entirely agree with the following assumption:  I kind of hope that most in
the CF world would at least be familiar with the term. I grew up in
France, have lived in Australia for nearly 10 years, and spend about 1.5
years in the US in the middle. Still, when I read your email yesterday I
had to look up 411. I'll go further, I have no idea what the number is here
either. My phone's got google, so why waste my time talking to someone :-)

Finally, yes that's what I meant with google analytics. Have you also
considered the fact that people don't mention your site because they are
well aware you spend time on various mailing list and are most likely to
chime in anyway?


On Fri, Feb 17, 2012 at 1:16 AM, charlie arehart charlie_li...@carehart.org
 wrote:

 Thanks, Christophe. Yes, I have long wanted to improve the CF411 site to
 be more than just a long list. I mention that in the 2ndparagraph—meaning, 
 I’m well aware of the opps for improvement. :-)


 “I look to improve this interface over time, adding RSS feeds for when I
 add/change items, perhaps enabling comments per tool/resource, etc. We'll
 see.”

 The good news is that this work is in fact underway. Can’t say when, but
 it will eventually be very different and I hope therefore to be more
 effective (I should add to that list, social networking integration to make
 it easier for others to share their observations about it to others, etc.)
 A mobile app is an interesting idea, sure. Thanks for that. Will be much
 easier after a redesign. I also hope to have separate landing pages per
 category and tool—which may also help with SEO, as well as to then add
 better searching.

 Thanks for the general encouragement about my resources.

 As for the fact that 411 is not a universal concept, it’s a fair point but
 I’m not sure I want to rebrand now. I kind of hope that most in the CF
 world would at least be familiar with the term, since so much else about CF
 has tended to be US-centric (for better or worse).

 As for analytics, honestly, I don’t bother with them. I have in the past,
 but I suspect like most people, I’d look at it, think, “that’s
 interesting”, and move on, not knowing much I can do with the info. I
 suppose you’re saying that if I saw that lots of people were visiting, that
 should give me some comfort about its reach, and that may well do so. But
 my point here in this thread was really about how few people seem to
 mention it, when the specific questions of “what are alternatives for x”
 come up. It just seems that unless people spread the word, it would remain
 a domain of the cognoscenti. :-)

 But back to your original points, yes, perhaps if I improve both the look
 and feel, add RSS feeds, make it easier to sharing things on social
 networking, etc., that will help make it more visible.

 /charlie

 ** **

 *From:* cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] *On
 Behalf Of *christophe albrech
 *Sent:* Thursday, February 16, 2012 4:48 AM

 *To:* cfaussie@googlegroups.com
 *Subject:* Re: [cfaussie] Re: cfchart

 ** **

 Hey Charlie,


 Instead of having a just list of things, have you considered making it a
 little app where developers can comment and rate each item like the review
 system on amazon? Maybe even a rating system like ebay with 3-5 rows of
 star (price, ease of use, responsiveness...) That might give it a bit more
 traction, especially if you can order items by category and rating. Fuck
 dude, make it a mobile app ;-)

 Don't go thinking people don't appreciate your efforts buddy, I'm sure
 everyone on here's either watched some of your recorded preso, or clicked
 on a link on cf411 (which is a poor name I think, because no one outside of
 the US would have a goddamn idea what 411 refers to, let alone remember
 it). do you have google analytics on it, so you can see who goes there and
 how often?

 Cheers,

 Tof

 P.S.: Sorry about all the swearing. This is Oz, that's what we do :-D

 ** **

 --
 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
 cfaussie+unsubscr...@googlegroups.com.
 For more options, visit this group at
 http://groups.google.com/group/cfaussie?hl=en.


-- 
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 
cfaussie+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.

Re: [cfaussie] CF Report Builder tool: any success stories?

2012-01-04 Thread christophe albrech

Hi Charlie,

something to add to your reporting list. We use a product called YellowFin
(melbourne based) as our reporting module. It's not free, but nothing short
of exceptional. Basically, it is a web-based dn'd report builder that is
intuitive enough for end-users to build reports with and perfectly adapted
to saas vendors. I could go on forever, it's got integrated security, a web
service api, ipad and android apps, connects to any datasource under the
sun, and so on, but instead, I'll post a couple of links:

website: http://www.yellowfinbi.com/
demo:
http://demo.yellowfin.com.au/YFEntry.i4?key=efm9R7fVko%2FTX19kyvxgYnEESPtFQZqkoBPi%2FEDeFmE%3D

Cheers,

Tof


On Thu, Jan 5, 2012 at 4:05 AM, charlie arehart
charlie_li...@carehart.orgwrote:

 Yep, Barry, the CF RB is more to be used **by** developers to create
 build reports **for** end users, and especially to create ones that
 integrate specifically with CFML (passing CFQuery results into the report,
 for instance).

 If you’re really wanting something to allow the end users to define
 reports themselves, and it’s not important that the reports themselves
 integrate with CFML, there are any of a number of solutions more
 well-suited to that. I keep a list of reporting tools (no surprise) at my
 CF411 site, specifically:

 http://www.cf411.com/report


 Though these reports don’t “integrate” with CFML (you can’t pass CFQuery
 results directly to them, etc.), that may not be really a critical
 requirement. But we don’t want to assume that such 3rd party reporting
 solutions “don’t integrate at all with a CFML app”.

 First, to be clear, such reports could certainly query the same database
 that CF code queries (so they’re integrated in that respect).

 Second, most will want users to be able to “get to the reports” from links
 in pages shown within their CFML app, and that should be no problem. Most
 of these tools do create web-accessible reports, so you can link to them
 just like any other page (and of course, most offer substantial security if
 you want to lock down who should see the reports, or show different report
 output based on who the user is, etc.)

 Hope that helps.

 

 /charlie

 ** **

 *From:* cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] *On
 Behalf Of *Dale Fraser
 *Sent:* Wednesday, January 04, 2012 1:45 AM
 *To:* cfaussie@googlegroups.com
 *Subject:* RE: [cfaussie] CF Report Builder tool: any success stories?

 ** **

 No,

 ** **

 Our users don’t do it, im not sure how well that would work, the tool is a
 bit quirky, but with training might be ok.

 ** **

 I don’t see why they couldn’t use the tool and then have a webpage where
 they can upload the cfr to use. The queries can be embedded in the report.
 

 ** **

 We tend to actually do the queries in coldfusion and pass the query into
 the report but it can work both ways.

 ** **

 You would need a template when they upload to ask them what the input
 parameters are, such as start date, end date etc.

 ** **

 Then have a coldfusion page that generates the prompts for that report.***
 *

 ** **

 Regards

 Dale Fraser

 ** **

 --
 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
 cfaussie+unsubscr...@googlegroups.com.
 For more options, visit this group at
 http://groups.google.com/group/cfaussie?hl=en.


-- 
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 
cfaussie+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.

Re: [cfaussie] Count the number of arguments passed into a function.

2012-01-04 Thread christophe albrech

Here's a silly but funny way to do it:

#structCount(arguments) - (listLen(SerializeJSON(arguments),null) - 1)#

Dale, with your example, it goes 4 - (3-1) = 2 actual elements.

Tof

On Thu, Jan 5, 2012 at 5:21 PM, Kai Koenig k...@koeni.de wrote:

 I trust you've logged that bug?

 Cheers
 Kai


  I think it's a bug one way or another and Adobe should fix it.
 
  structCount is INCORRECT imo shows 4 elements
  dump is INCORRECT imo shows 4 elements
  structKeyExists is CORRECT. It doesn't think its there.
 
  Anything else you try to do to those elements, think it doesn't exists
 thus
  the first 2 don't follow the same rules
 
  cfoutput#arguments.a4#/cfoutput
 
  Element A4 is undefined in ARGUMENTS.
 
  One way or another the behaviour should be consistant.
 
  Regards
  Dale Fraser
 
  http://dale.fraser.id.au
  http://cfmldocs.com
  http://learncf.com
  http://flexcf.com
 
 
  -Original Message-
  From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On
 Behalf
  Of charlie arehart
  Sent: Thursday, 5 January 2012 4:55 PM
  To: cfaussie@googlegroups.com
  Subject: RE: [cfaussie] Count the number of arguments passed into a
  function.
 
  Yep, that's an interesting challenge, Gavin. (And if anyone may have read
  only the first sentence of his note and not the rest, note that he IS
  already counting the arguments struct, but the issue is that because he's
  using cfargument to define them, even without any default, all those
 defined
  args appear in the struct even if no value is passed in.)
 
  Ben Nadel has blogged on this same problem a few years ago:
 
 
 http://www.bennadel.com/blog/1430-ColdFusion-ARGUMENTS-Keys-Always-Exist-Eve
  n-When-Not-Required.htm
 
  Sadly neither he nor anyone else reading it had any solution other than
 what
  you've proposed, Gavin, doing a structkeyexist to test if there's a value
  passed in.
 
  I do agree that it could be helpful to get the value more easily, and I'm
  really surprised that it's not something that's been solved (though I
 have
  to admit I've not needed it before, but I can appreciate its value.)
 Perhaps
  someone here will point out something we're all missing. :-)
 
  One little tip that could help find another solution is that the
 arguments
  scope can be processed either as a struct or an array. While
  arraylen(arguments) returns the same value as structcount, but the slot
 in
  the array for any argument not provided will be empty, and that can be
  tested as of CF8 with arrayisdefined(array,index). Not really any better
  than structkeyexists. Again, though, maybe thinking about it as an array
  instead may give someone an idea.
 
  Finally, I'll note that I searched the cflib.org site, and of the 55
 UDFs
  there that refer to count, none seemed related to solving this problem.
  Same with the 21 that referred to arguments.
 
  /charlie
 
 
  -Original Message-
  From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On
  Behalf Of Gavin Baumanis
  Sent: Wednesday, January 04, 2012 11:55 PM
  To: cfaussie
  Subject: [cfaussie] Count the number of arguments passed into a
  function.
 
  Hi there,
  Let me explain what I am trying to do,
 
  the executive summary is that I want to count the number of arguments
  passed into a function.
  anyFunction(), might have 10 cfargument properties assigned to it.
  But if I call;
  anyFunction(arg1=1, arg2=2)
 
  Then I somehow want to be able to retrieve the value 2 (2 passed in
  variables).
 
  Why,
  Because I have a getObject method.
  getObject is basically a cfquery and I filter the results of the
  query, based on the arguments passed in.
  so if I have;
  getObject(myId = 1, yourId = 2);
 
  then it creates SQL that looks like;
  select STUFF
  from myTable
  where 1=1
  and myid=1
  and yourid=1
  and...(add a number of arguments here)
 
  If I do NOT pass in any arguments, then the SQL retrieves ALL rows
  from the table.
  But I want to do is;
  If no arguments are passed in  - create an empty object.
 
  (we have a getAllObjects function to retrieve all rows)
 
  maybe some code will help...
 
  I have two snippets of code;
  One is a function in a CFC, the other is some code in a CFM template
  that calls the function - pretty simple.
 
  myTestCFC.cfc:
  cffunction name=blah
   cfargument name=text required=false /
   cfargument name=messageid required=false /
   cfargument name=queryid required=false /
   cfargument name=datasource required=false /
 
   cfset var local = {} /
   cfset local.length = #structCount(arguments)#
 
   cfreturn local.length
  /cffunction
 
 
  test.cfm:
  cfset myReturnVal = myTestCFC.blah(text=gav, queryid=3) cfdump
  var=#myReturnVal# br / cfif structKeyExists(messageCFC,
  messageid)
   Yes
  cfelse
   No
  /cfif
 
  the output of this code is;
  4
  No
 
  The value 4 is because blah() has 4 arguments defined.
  But structKeyExists, returns false...
 
  How can it not

Re: [cfaussie] Determine Server

2011-12-19 Thread christophe albrech

Hi Dale,

If you run into trouble with stuff like that, I know we have implemented
something similar here for some of our bigger clients, like dpt of defence
or ato. In our case the session itself was spread across multiple app
servers and a single DB server (I wasn't involved with that project,
though). Now we're implementing terracotta and swapping transfer with
hibernate to prepare for the even nastier load we'll get with US
departments.

Anyway, people here are pretty busy at the moment, but if you run into
problems with that stuff, feel free to send me an email and I'll shoot it
around the dev team.

Cheers,

Tof.

On Tue, Dec 20, 2011 at 3:55 AM, Steve Onnis st...@cfcentral.com.au wrote:

 You want to get the local ip address of the server?

 ** **

 *From:* Dale Fraser [mailto:d...@fraser.id.au]
 *Sent:* Monday, 19 December 2011 10:40 PM
 *To:* cfaussie@googlegroups.com
 *Subject:* [cfaussie] Determine Server

 ** **

 Hi,

 ** **

 I’m setting up cloud servers via a load balancer

 ** **

 I want to test the rotation of servers through the round robin allocation
 of requests over the multiple app servers.

 ** **

 Im just trying something simple by dumping HTTP_HOST

 ** **

 But that dumps the host of the balancer and not the destination server.***
 *

 ** **

 How can I determine the server that I land on

 ** **

 Regards

 Dale Fraser

 ** **

 http://dale.fraser.id.au

 http://cfmldocs.com

 http://learncf.com

 http://flexcf.com

 ** **

 --
 You received this message because you are subscribed to the Google Groups
 cfaussie group.
 To post to this group, send email to cfaussie@googlegroups.com.
 To unsubscribe from this group, send email to
 cfaussie+unsubscr...@googlegroups.com.
 For more options, visit this group at
 http://groups.google.com/group/cfaussie?hl=en.

 --
 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
 cfaussie+unsubscr...@googlegroups.com.
 For more options, visit this group at
 http://groups.google.com/group/cfaussie?hl=en.


-- 
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 
cfaussie+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.

Re: [cfaussie] Does CFTRANSACTION work across multiple datasources?

2011-09-07 Thread christophe albrech

Hi Mike,

I won't comment about CF or any other database server, but this is possible
with SQL server.

you need to create a link to your distant server first. Then in your
example, instead of using a cftransaction and 2 cfquery with different dsn,
you'd have something along the line of

cfquery dsn=local
  being tran t1
begin try

INSERT into linkedserver.distantdatabase.dbo.table
   values(...)

Update eventrecord
SET  exportedToRemoteDB = true

   COMMIT
begin catch

Update eventrecord
SET  exportedToRemoteDB = true

end catch
  end try
cfquery

I'm sure ant modern dbms would have a similar mechanism, but I'm very much a
sql server fan boy, so it's the only thing I know ;-)

as for actual cross-server transactions, you can configure something called
DTC (Distributed Transaction Coordinator). It's pretty much an engine that
allows a tran between 2 or more linked servers to be shared, and that
manages commits and rollbacks as a whole.

hope this helps.

Tof

On Wed, Sep 7, 2011 at 9:57 PM, Andrew Scott andr...@andyscott.id.auwrote:

 I don't think ColdFusion cares about temp tables, as long as they exist at
 that time of the query.


 --

 Regards,
 Andrew Scott
 WebSite: http://www.andyscott.id.au/
 Google+: http://plus.google.com/108193156965451149543



 On Wed, Sep 7, 2011 at 9:51 PM, ColdGen Internet Solutions 
 coldgen.internet.soluti...@gmail.com wrote:

 Is a big ask - what about a temporary table or backup table you can
 flag for records that made it through - you can compare commits to?

 I have a similar issue but for sending emails AND the database issue.

 Peter Tilbrook
 Web Administrator, The Club Group (ACT) Pty. Ltd.
 Managing Director, ColdGen Internet Solutions
 Professional Adobe ColdFusion 9 Application Development
 President, ACT and Region ColdFusion Users Group
 PO Box 2247
 Queanbeyan, NSW, 2620
 AUSTRALIA

 Tel: +61-2-6284-2727
 Mob: +61-2-0457-449-016

 Email Address: pe...@coldgen.com
 WWW: http://www.coldgen.com/
 WWW2: http://www.clubgroup.com.au/

 ABN: 80 826 226 128





  --
 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
 cfaussie+unsubscr...@googlegroups.com.
 For more options, visit this group at
 http://groups.google.com/group/cfaussie?hl=en.


-- 
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 
cfaussie+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.

Re: [cfaussie] Does CFTRANSACTION work across multiple datasources?

2011-09-07 Thread christophe albrech

sorry, I meant to update that second update statement to false

On Wed, Sep 7, 2011 at 10:23 PM, christophe albrech 
christophe.albr...@gmail.com wrote:

 Hi Mike,

 I won't comment about CF or any other database server, but this is possible
 with SQL server.

 you need to create a link to your distant server first. Then in your
 example, instead of using a cftransaction and 2 cfquery with different dsn,
 you'd have something along the line of

 cfquery dsn=local
   being tran t1
 begin try

 INSERT into linkedserver.distantdatabase.dbo.table
values(...)


 Update eventrecord
 SET  exportedToRemoteDB = true

COMMIT
 begin catch


 Update eventrecord
 SET  exportedToRemoteDB = true

 end catch
   end try
 cfquery

 I'm sure ant modern dbms would have a similar mechanism, but I'm very much
 a sql server fan boy, so it's the only thing I know ;-)

 as for actual cross-server transactions, you can configure something called
 DTC (Distributed Transaction Coordinator). It's pretty much an engine that
 allows a tran between 2 or more linked servers to be shared, and that
 manages commits and rollbacks as a whole.

 hope this helps.

 Tof


 On Wed, Sep 7, 2011 at 9:57 PM, Andrew Scott andr...@andyscott.id.auwrote:

 I don't think ColdFusion cares about temp tables, as long as they exist at
 that time of the query.


 --

 Regards,
 Andrew Scott
 WebSite: http://www.andyscott.id.au/
 Google+: http://plus.google.com/108193156965451149543



 On Wed, Sep 7, 2011 at 9:51 PM, ColdGen Internet Solutions 
 coldgen.internet.soluti...@gmail.com wrote:

 Is a big ask - what about a temporary table or backup table you can
 flag for records that made it through - you can compare commits to?

 I have a similar issue but for sending emails AND the database issue.

 Peter Tilbrook
 Web Administrator, The Club Group (ACT) Pty. Ltd.
 Managing Director, ColdGen Internet Solutions
 Professional Adobe ColdFusion 9 Application Development
 President, ACT and Region ColdFusion Users Group
 PO Box 2247
 Queanbeyan, NSW, 2620
 AUSTRALIA

 Tel: +61-2-6284-2727
 Mob: +61-2-0457-449-016

 Email Address: pe...@coldgen.com
 WWW: http://www.coldgen.com/
 WWW2: http://www.clubgroup.com.au/

 ABN: 80 826 226 128





  --
 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
 cfaussie+unsubscr...@googlegroups.com.
 For more options, visit this group at
 http://groups.google.com/group/cfaussie?hl=en.




-- 
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 
cfaussie+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.

Re: [cfaussie] A really useful video of CF9 performance

2011-08-27 Thread christophe albrech

2 chicks handing over a cup to one another. But there's a cf sticker on it.

On Sun, Aug 28, 2011 at 12:06 PM, Mike Kear afpwebwo...@gmail.com wrote:

 But the video is private so I can't see it.What's in it?

 Cheers
 Mike Kear
 Windsor, NSW, Australia
 Adobe Certified Advanced ColdFusion Developer
 AFP Webworks
 http://afpwebworks.com
 ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month


 On Tue, Aug 23, 2011 at 11:00 AM, Mark Ireland markinc...@hotmail.comwrote:


 A really useful video of CF9 performance

 http://www.youtube.com/watch?v=IfBGxnFJddg

 This may be the first video of its kind I have seen after all these years!

 --
 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
 cfaussie+unsubscr...@googlegroups.com.
 For more options, visit this group at
 http://groups.google.com/group/cfaussie?hl=en.




 --

  --
 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
 cfaussie+unsubscr...@googlegroups.com.
 For more options, visit this group at
 http://groups.google.com/group/cfaussie?hl=en.


-- 
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 
cfaussie+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.

Re: [cfaussie] Re: Creating A Fast Dropdown List Lookup

2011-07-04 Thread christophe albrech

Might be a stupid question, but are you sure the bottleneck is at the CF
level? i.e. is the unit number column indexed in the database?

On Thu, Jun 30, 2011 at 1:06 AM, charlie arehart charlie_li...@carehart.org
wrote:

Not knocking jQuery, but to be clear, the CFInput autosuggest is just as
capable of generating its data from a remote call (ajax or otherwise). You
can see an example in the CF Developer Guide (I show the CF9 one, but the
feature worked essentially the same in CF8):

http://help.adobe.com/en_US/ColdFusion/9.0/Developing/WSc3ff6d0ea77859461172
e0811cbec22c24-7a01.html#WSc3ff6d0ea77859461172e0811cbec22c24-720chttp://help.adobe.com/en_US/ColdFusion/9.0/Developing/WSc3ff6d0ea77859461172%0Ae0811cbec22c24-7a01.html#WSc3ff6d0ea77859461172e0811cbec22c24-720c

Re: [cfaussie] Re: Daily Rate

2011-03-15 Thread christophe albrech

Mark,

I don't understand how you could have been stuck for 4 years. Why didn't you
hire a grad for 40/45k a year and train them ?

On Tue, Mar 15, 2011 at 2:07 PM, Mark Picker mark.pic...@det.nsw.edu.auwrote:

 As Brian said short term I took it as meaning contractor rate, not
 salary.

 If it helps, we pay full time staff a salary that works out at around
 $330 gross per day.  Then add 5 weeks annual leave, 14 sick days, flex
 time, super etc.

 CF skills aren't a must (but we would rate skilled CF developers
 higher than non skilled) but staff would need to have some type of
 development background.

 Good luck finding someone Brian.  We tried filling a CF position for
 over 3 years (or maybe 4??) and recently had to remove the position as
 we couldn't fill it.

 Cheers
 Mark

 --
 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
 cfaussie+unsubscr...@googlegroups.com.
 For more options, visit this group at
 http://groups.google.com/group/cfaussie?hl=en.



-- 
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 
cfaussie+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.

Re: [cfaussie] OT: a couple of questions for my travel there in coming weeks

2010-11-05 Thread christophe albrech

wifi in the cbd:
http://www.onlymelbourne.com.au/melbourne_details.php?id=10425

On Sat, Nov 6, 2010 at 4:28 PM, Steve Onnis st...@cfcentral.com.au wrote:

 Also its not that big either. You can drive from one end to the other and
 back in a day so if you are there for a couple days, maybe look at staying
 in a couple places, hire a car and take in the sites :)

 -Original Message-
 From: Mike Kear [mailto:afpwebwo...@gmail.com]
 Sent: Saturday, 6 November 2010 3:58 PM
 To: cfaussie@googlegroups.com
 Subject: Re: [cfaussie] OT: a couple of questions for my travel there in
 coming weeks

 Charlie, the only comment i'd make about your wanting to stay in one
 city for a couple of nights, then another  in Tasmania.Remember
 that the entire state has a population of around 500,000, and about
 half of them are in Hobart.When you refer to city in Tasmana,
 youre not talking about anything that resembles city in the USA.

 Not that there's anything wrong with that, mind you.  Tasmania is a
 fantastic place.  Just dont expect big city, thats all.   From my own
 experience i'd say its more like Roanoake Va than New York City.   If
 you want to see something fantastic,  beautiful,   mild weather,  then
 Tassie's goign to be right up your alley.

 Cheers
 Mike Kear
 Windsor, NSW, Australia
 Adobe Certified Advanced ColdFusion Developer
 AFP Webworks
 http://afpwebworks.com
 ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month



 On Sat, Nov 6, 2010 at 2:33 PM, charlie arehart
 charlie_li...@carehart.org wrote:
  Hey folks, as some of you may know, I'm coming down for the
 cf.Objective(ANZ)
  conference in Melbourne in 2 weeks. Given the distance and duration (and
 being our
  10th anniversary), my wife is coming along and we plan to spend about a
 week before
  and after traveling Victoria and perhaps Tassie.
 
  One question we have is: what's the situation down there for public
 internet access
  (wifi or hardwire)? Here in the States, you can rock up to any McDonald's
 or Starbucks
  and have free wifi. Is that the same there, by any chance, or at any
 place
 else we
  might reasonably pop into once or twice a day if needed? We are looking
 to
 hook up our
  laptops, not use rented workstations such as in an internet café. (The
 hotel we're
  staying in the first week charges about $15/day for internet access.)
 
  Also, anyone want to hazard a recommendation for where best we might look
 to stay in
  Tassie from Sat the 20th to Wed the 24th? Of course, recommending for
 someone you
  don't know well can be a challenge. We have no kids, are in our late
 40's,
 and are
  reasonably fit. We enjoy history, culture, nature, and so on. Not
 particularly sports
  or sporting enthusiasts, nor beach bums. It seems it may be a good idea
 to
 get a car
  there and drive around, staying in one city for a couple of nights, then
 another. If
  anyone has any recommendations, we'd welcome it.
 
  Thanks.
 
  /charlie
 
  --
  You received this message because you are subscribed to the Google Groups
 cfaussie group.
  To post to this group, send email to cfaus...@googlegroups.com.
  To unsubscribe from this group, send email to
 cfaussie+unsubscr...@googlegroups.comcfaussie%2bunsubscr...@googlegroups.com
 .
  For more options, visit this group at
 http://groups.google.com/group/cfaussie?hl=en.
 
 



 --

 --
 You received this message because you are subscribed to the Google Groups
 cfaussie group.
 To post to this group, send email to cfaus...@googlegroups.com.
 To unsubscribe from this group, send email to
 cfaussie+unsubscr...@googlegroups.comcfaussie%2bunsubscr...@googlegroups.com
 .
 For more options, visit this group at
 http://groups.google.com/group/cfaussie?hl=en.






 ===
 Email scanned by PC Tools - No viruses or spyware found.
 (Email Guard: 7.0.0.21, Virus/Spyware Database: 6.16180)
 http://www.pctools.com/
 ===





 ===
 Email scanned by PC Tools - No viruses or spyware found.
 (Email Guard: 7.0.0.21, Virus/Spyware Database: 6.16180)
 http://www.pctools.com/
 ===

 --
 You received this message because you are subscribed to the Google Groups
 cfaussie group.
 To post to this group, send email to cfaus...@googlegroups.com.
 To unsubscribe from this group, send email to
 cfaussie+unsubscr...@googlegroups.comcfaussie%2bunsubscr...@googlegroups.com
 .
 For more options, visit this group at
 http://groups.google.com/group/cfaussie?hl=en.



-- 
You received this message because you are subscribed to the Google Groups 
cfaussie group.
To post to this group, send email to cfaus...@googlegroups.com.
To unsubscribe from this group, send email to 
cfaussie+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.

Re: [cfaussie] Strange problem - Element RECORDCOUNT is undefined in query

2010-10-04 Thread christophe albrech

Hi Scott,

If I may, your code could be improved performance-wise. It is a classic
example of Rbar programming (pronounced reebar = Row by agonizing row) as
the process is not written in a set-based way, which is exactly what DB
servers are really good (and really fast) at.

If you think about it, the code loops over each record in the first query
(the cfif is useless by the way) , and then does an update for each one. if
you have a thousand records, that's a thousand loops, a thousand queries
sent through the wire, a thousand query the optimizer has to parse, and so
on. What you really want to do is have a single update statement instead.

The problem in your case is that using aggregation forces you to use a group
by statement. On top of that you need the aggregated data to perform the set
operation which complicates the matter. While writing one single statement
is possible it's probably easier to read if you use a temp table to store
the maxed date and then write a single update. like so:

cfquery
SELECT  sb_invoice.sb_invoice_id,
MAX(sb_claim_date) AS sb_claim_date
INTO##tempTable
FROMsb_invoice
INNER JOIN sb_invoice_item ON sb_invoice.sb_invoice_id =
sb_invoice_item.sb_invoice_id
INNER JOIN sb_item_claim ON sb_invoice_item.sb_invoice_item_id =
sb_item_claim.sb_invoice_item_id
WHERE   sb_invoice.sb_bill_mech_code IN ( 'M', 'F', 'AG', 'SC', 'MB', 'MO' )
AND sb_invoice_item.sb_item_status_code IN ( '21', '24', '31' )
GROUP BY sb_invoice.sb_invoice_id,
sb_invoice.sb_reminder_date
HAVING  sb_invoice.sb_reminder_date  DATEADD(d, 30, MAX(sb_claim_date))

UPDATE  i
SET sb_reminder_date = DATEADD(d, 31, t.sb_claim_date)
FROMsb_invoice i
INNER JOIN #tempTable t ON i.sb_invoice_id = t.sb_invoice_id
/cfquery

The more records the initial select returns, the more resources you save. I
just tried a simple example on my local machine where I tried to update 10k
rows with both methods. the rbar one took about 10 seconds while the
set-based one took less than half a second. trying with 100k rows, I got 70
seconds against 2.5.

Let's keep in mind that lots of updates wouldn't need the temp table in the
first place. It's only there because because you were updating with an
aggregated value. Normally you'd just do:

UPDATE t
set blah = 6
FROM myTable t
 JOIN otherTable o on o.id = t.fk
 ...
 ...

Anyway, speaking of agonizing stuff, I'm off to see the dentist.

Cheers,

Tof



On Fri, Oct 1, 2010 at 11:30 AM, Scott Thornton 
scott.thorn...@hnehealth.nsw.gov.au wrote:

  Hello,



 Thanks for all replies.



 An update of my local dev server to 9,0,1,274733 appears to have solved
 the problem.







 *From:* cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] *On
 Behalf Of *Scott Thornton
 *Sent:* Friday, 1 October 2010 10:29 AM
 *To:* cfaussie@googlegroups.com
 *Subject:* RE: [cfaussie] Strange problem - Element RECORDCOUNT is
 undefined in query



 HI All,



 1. What happens if you try CFDUMP instead right after the query?



 using

 *cfdump var=#fix_this#cfabort*

 * *

 *returns *



 Variable FIX_THIS is undefined.



 2. re recordcount gt 0.



 I didn't know that, thanks.



 3.  Why the cfoutput?



 The original code used cfloop, I tried using cfoutput as well. Typically
 cfloop would be used.



 4. Update CF?



 Will try that now.



 5. Does the query run (as is)?



 Yes it does, however it does not return any rows ( in SQl Query Analyzer
 2000). The database is MS SQL 2005



 5. Much simplier query?



 cfquery  datasource=#DSN# name=fix_this

 select top 1 * from sb_invoice

 /cfquery



 cfdump var=#fix_this#cfabort



 works fine.



 Sooo, I will update my local server first, then put the orginal query back
 in and see how it goes.



 *From:* cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] *On
 Behalf Of *...@ampersand.net.au
 *Sent:* Friday, 1 October 2010 9:41 AM
 *To:* cfaussie@googlegroups.com
 *Subject:* Re: [cfaussie] Strange problem - Element RECORDCOUNT is
 undefined in query



 What happens if you try CFDUMP instead right after the query?

 On 1/10/2010 9:35 AM, Scott Thornton wrote:

 Hi,



 Running across a odd problem in CF 9,0,0,251028. development server.



 I was just running a process that usually works and has not been modified
 for quite a long time. part of that process runs a query and then loops over
 the result set. Simple enough… however the query does not seem to exist
 after it has run.


 eg: The following code returns Element RECORDCOUNT is undefined in
 FIX_THIS.





 cfquery  datasource=#DSN# name=fix_this

 select sb_invoice.sb_invoice_id,
 sb_invoice.sb_reminder_date, max(sb_claim_date) as sb_claim_date

 from sb_invoice

 inner join sb_invoice_item

 on sb_invoice.sb_invoice_id = sb_invoice_item.sb_invoice_id

 inner join sb_item_claim

 on

Re: [cfaussie] Display XML on webpage

2010-06-06 Thread christophe albrech

you could use a js syntax highlighter:
http://code.google.com/p/syntaxhighlighter/

On Mon, Jun 7, 2010 at 2:18 PM, Scott Thornton 
scott.thorn...@hnehealth.nsw.gov.au wrote:

 Hi,

 I was hoping to achieve something rather simple ( I thought), which was to
 display on a webpage the xml stored from within a database, in hopefully a
 formatted manner.

 The XML is stored unformatted within a database text field.

 When I save the following XML a text document with an .xml extension,
 Internet explorer formats it and displays it okay, but a simple output of
 the database field eg:

 cfqueryselect /cfquery
 cfoutput#query.xml#/cfoutput

 Internet explorer displays an error,

 The XML page cannot be displayed
 Cannot view XML input using XSL style sheet. Please correct the error and
 then click the Refresh button, or try again later.

 Firefox displays it as one long string.

 Wrapping the cfoutput in CODE/CODE doesn't help.

 Putting the cfoutput with a CFtextarea helps, but then I need to format it
 ( indent it to make it more readable )

 I guess one potential problem is that the xml string contains another XML
 string ( partData )

 ?xml version=1.0 encoding=UTF-8 standalone=yes?
  ns1:transmissionMessage transmissionGmt=20100517153248
 transmissionId=WEB20117091e4bf161a06700 from=WEB20117 mode=FIXME
 contentsSigned=false
 contentsType=MCA/OlcHospital/inhospitalclaimreques...@1 xmlns:ns1=
 http://hic.gov.au/hiconline/protocol/model;
adaptor minorVersion=28 majorVersion=6.10 vendor=HIC
 platform=os: Windows 2003 x86 5.2 jre: Sun 1.5.0_05 product=HicOnline
/adaptor
logic minorVersion=56 majorVersion=1 vendor=MCA platform=os:
 Windows 2003 x86 5.2 jre: Sun 1.5.0_05 product=OlcHospital
/logic
originator minorVersion=1 majorVersion=2.610 vendor=NOT SPECIFIED
 platform=os: Windows 2003 x86 5.2 jre: Sun 1.5.0_05 product=Platypus2
/originator
pki minorVersion=0 majorVersion=2.3.3 vendor=HIC platform=os:
 Windows 2003 x86 5.2 jre: Sun 1.5.0_05 product=eSignature
/pki
content transactionId=WEB22 sendCount=1 requestId=1
 role= dataRef=1 type=MCA/OlcHospital/inhospitalclaimreques...@1
 signed=false
/content
partData
  ?xml version=1.0 encoding=UTF-8 standalone=yes?
ns1:inHospitalClaimRequest xmlns:ns1=
 http://hic.gov.au/hiconline/eclipse/version-1;
  claim messagePartId=CID
claimTypeCdePU/claimTypeCde
facilityId0012790J/facilityId
fundBrandIdABC/fundBrandId
accountReferenceIdA1234567/accountReferenceId
senderContact
  nameabc  123/name
  phone0249853321/phone
  emailemailaddr...@hnehealth.nsw.gov.au/email
/senderContact
contiguousClaimCdeN/contiguousClaimCde
urgencyCode9/urgencyCode
compensationClaimCdeN/compensationClaimCde
totalHospitalChargeAmount58800/totalHospitalChargeAmount
totalChargeAmount58800/totalChargeAmount
facilityTypeCode1/facilityTypeCode
patient messagePartId=PAT
  patient gender=2 dateOfBirth=1939-01-16+10:00
identity firstName=firstName lastName=lastName/
residentialAddress postcode=2287/
medicare memberRefNum=1 memberNum=1234567707/
healthFund memberNum=1234567/
  /patient
  medicalRecordId97654321/medicalRecordId
/patient
episode messagePartId=EPD
  admissionDate2010-05-03+10:00/admissionDate
  admissionTime09:24:00+10:00/admissionTime
  dischargeDate2010-05-05+10:00/dischargeDate
  dischargeTime15:35:00+10:00/dischargeTime
  episodeId2116524/episodeId
  patientClassificationCodeOT/patientClassificationCode
  episodeTypeCode10/episodeTypeCode
  accommodationStatusCodeA/accommodationStatusCode
  sameDayCode2/sameDayCode
  lengthOfStay3/lengthOfStay
  dischargeTypeCode09/dischargeTypeCode
  referralSourceCode4/referralSourceCode
  admissionCategoryCode1/admissionCategoryCode
/episode
accommodationSummary messagePartId=ACS
  fromDate2010-05-03+10:00/fromDate
  toDate2010-05-05+10:00/toDate
  numberOfDays2/numberOfDays
  leaveDays0/leaveDays
  accommodationDays2/accommodationDays
  totalChargeAmount58800/totalChargeAmount
  chargeRaisedCdeC/chargeRaisedCde
  accommodation messagePartId=ACD1
fromDate2010-05-03+10:00/fromDate
toDate2010-05-05+10:00/toDate
numberOfDays2/numberOfDays
chargeAmount58800/chargeAmount
chargeRaisedCdeC/chargeRaisedCde
dayRate29400/dayRate
patientClassificationCodeOT/patientClassificationCode

Re: [cfaussie] Re: Thanks for emailing me

2010-01-31 Thread Christophe Albrech

Thanks for your email.  I am on a family camp this week. I will be returning
on Monday 18th January, 2010 and will respond to your email then.

Kind Regards
Tof

On Mon, Jan 11, 2010 at 6:25 PM, Geoff Bowers mod...@gmail.com wrote:

 Everyone will be delighted I'm sure that cas...@bluerocksoftware.com
 has now been set to NO EMAIL ;)

 -- geoff
 List Mum

 On Jan 11, 6:02 pm, cas...@bluerocksoftware.com wrote:
  Thanks for your email.  I am on a family camp this week. I will be
 returning on Monday 18th January, 2010 and will respond to your email then.
 
  Kind Regards
  Cassie

 --
 You received this message because you are subscribed to the Google Groups
 cfaussie group.
 To post to this group, send email to cfaus...@googlegroups.com.
 To unsubscribe from this group, send email to
 cfaussie+unsubscr...@googlegroups.comcfaussie%2bunsubscr...@googlegroups.com
 .
 For more options, visit this group at
 http://groups.google.com/group/cfaussie?hl=en.





-- 
You received this message because you are subscribed to the Google Groups 
cfaussie group.
To post to this group, send email to cfaus...@googlegroups.com.
To unsubscribe from this group, send email to 
cfaussie+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.

Re: [cfaussie] Re: Trying to consume .Net Webservice

2009-11-18 Thread Christophe Albrech

ah cool. Well let me know if you need any help registering certificate.

Cheers,

Tof

On Thu, Nov 19, 2009 at 12:03 PM, Dawesi daw...@gmail.com wrote:

 I'm checking regarding the cert  - a hunch I had, I have a feeling
 that could be the problem as we're getting a connection error only
 when posting (we can get to the webservice thru nt login and proxy).

 Will also be playing with the CFX_HTTP5 tag...

 This is a 3rd party development, not internal DOE directly, although
 DOE is running the project. SoapUi is the bomb! :-) I have that.

 On Nov 18, 5:03 pm, Christophe Albrech t...@crackettt.com wrote:
  Connection error might very well be a certificate problem.
- does it run over SSL, and if so have you downloaded the cert file and
  installed it?
- you said department of education. I integrate with DECSSA (department
 of
  education and children services SA). same guys?
- one great tool to play with web services is SOAPui, give it a try.
 you
  can point to the WSDL directly, and it will create a test harness on the
 fly
  for you.
- I've had problems in the past connecting to third party webservices
 with
  CF. one way I found worked all the time is a CFHTTP to the end point in
  which you just pass the soap packet through.
 
  Anyway, it's beer O clock.
 
  Cheers,
 
  Tof
 
  On Wed, Nov 18, 2009 at 4:49 PM, skateboard.com.au 
 w...@skateboard.com.auwrote:
 
   yeah, because i suck
 
   -Original Message-
   From: Zac Spitzer zac.spit...@gmail.com
   To: cfaussie@googlegroups.com
   Date: Wed, 18 Nov 2009 16:45:13 +1100
   Subject: Re: [cfaussie] Trying to consume .Net Webservice
 
any reason you haven't tried a modern release like CF8 or cf9 ?
 
On Wed, Nov 18, 2009 at 4:42 PM, skateboard.com.au
w...@skateboard.com.auwrote:
 
 I tried for ages to get it to work with cf6, maybe it works with
later
 versions I dont know.
 That said, in cf6 you can't do it natively because .net used the
schema
 that allows multi
 return values and such. I ended up just using straight cfhttp and
doing it
 all at the soap
 level.
 
 cheers
 
 Drew Peacock
 
 -Original Message-
 From: Dawesi daw...@gmail.com
 To: cfaussie cfaussie@googlegroups.com
 Date: Tue, 17 Nov 2009 21:18:37 -0800 (PST)
 Subject: [cfaussie] Trying to consume .Net Webservice
 
  I'm looking for someone who can help me connect to a .Net
webservice
  from Dept Of Education... I'm about to look at the CFX_HTTP5 com
  object from the component store... before that I was wondering if
  there was anyone with experience with common errors when
  consuming .Net webservices.
 
  I can see the wsdl descriptor page in both my browser and with
  coldfusion however I can't post to the service without getting a
  connection error.
 
  any hints would be appreciated... webservice is password
 protected
so
  I can't give it out here, but is test environment, so can make an
  exception for anyone who has had experience. I also have a test
page
  you could drop on your server.
 
  Cheers,
  Chris Dawes
  043 three 99 44 two zero
 
  --
 
  You received this message because you are subscribed to the
 Google
  Groups cfaussie group.
  To post to this group, send email to cfaus...@googlegroups.com.
  For more options, visit this group at
 http://groups.google.com/group/cfaussie?hl=.
 
 --
 
 You received this message because you are subscribed to the Google
Groups
 cfaussie group.
 To post to this group, send email to cfaus...@googlegroups.com.
 For more options, visit this group at
http://groups.google.com/group/cfaussie?hl=.
 
--
Zac Spitzer
Solution Architect / Director
Ennoble Consultancy Australia
   http://www.ennoble.com.au
   http://zacster.blogspot.com
+61 405 847 168
 
--
 
You received this message because you are subscribed to the Google
Groups cfaussie group.
To post to this group, send email to cfaus...@googlegroups.com.
For more options, visit this group at
   http://groups.google.com/group/cfaussie?hl=.
 
   --
 
   You received this message because you are subscribed to the Google
 Groups
   cfaussie group.
   To post to this group, send email to cfaus...@googlegroups.com.
   For more options, visit this group at
  http://groups.google.com/group/cfaussie?hl=.

 --

 You received this message because you are subscribed to the Google Groups
 cfaussie group.
 To post to this group, send email to cfaus...@googlegroups.com.
 For more options, visit this group at
 http://groups.google.com/group/cfaussie?hl=.




--

You received this message because you are subscribed to the Google Groups 
cfaussie group.
To post to this group, send email to cfaus...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/cfaussie?hl=.

Re: [cfaussie] Trying to consume .Net Webservice

2009-11-17 Thread Christophe Albrech

Connection error might very well be a certificate problem.
  - does it run over SSL, and if so have you downloaded the cert file and
installed it?
  - you said department of education. I integrate with DECSSA (department of
education and children services SA). same guys?
  - one great tool to play with web services is SOAPui, give it a try. you
can point to the WSDL directly, and it will create a test harness on the fly
for you.
  - I've had problems in the past connecting to third party webservices with
CF. one way I found worked all the time is a CFHTTP to the end point in
which you just pass the soap packet through.

Anyway, it's beer O clock.

Cheers,

Tof

On Wed, Nov 18, 2009 at 4:49 PM, skateboard.com.au 
w...@skateboard.com.auwrote:

 yeah, because i suck

 -Original Message-
 From: Zac Spitzer zac.spit...@gmail.com
 To: cfaussie@googlegroups.com
 Date: Wed, 18 Nov 2009 16:45:13 +1100
 Subject: Re: [cfaussie] Trying to consume .Net Webservice

  any reason you haven't tried a modern release like CF8 or cf9 ?
 
  On Wed, Nov 18, 2009 at 4:42 PM, skateboard.com.au
  w...@skateboard.com.auwrote:
 
   I tried for ages to get it to work with cf6, maybe it works with
  later
   versions I dont know.
   That said, in cf6 you can't do it natively because .net used the
  schema
   that allows multi
   return values and such. I ended up just using straight cfhttp and
  doing it
   all at the soap
   level.
  
   cheers
  
   Drew Peacock
  
   -Original Message-
   From: Dawesi daw...@gmail.com
   To: cfaussie cfaussie@googlegroups.com
   Date: Tue, 17 Nov 2009 21:18:37 -0800 (PST)
   Subject: [cfaussie] Trying to consume .Net Webservice
  
I'm looking for someone who can help me connect to a .Net
  webservice
from Dept Of Education... I'm about to look at the CFX_HTTP5 com
object from the component store... before that I was wondering if
there was anyone with experience with common errors when
consuming .Net webservices.
   
I can see the wsdl descriptor page in both my browser and with
coldfusion however I can't post to the service without getting a
connection error.
   
any hints would be appreciated... webservice is password protected
  so
I can't give it out here, but is test environment, so can make an
exception for anyone who has had experience. I also have a test
  page
you could drop on your server.
   
Cheers,
Chris Dawes
043 three 99 44 two zero
   
--
   
You received this message because you are subscribed to the Google
Groups cfaussie group.
To post to this group, send email to cfaus...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/cfaussie?hl=.
   
   
  
  
   --
  
   You received this message because you are subscribed to the Google
  Groups
   cfaussie group.
   To post to this group, send email to cfaus...@googlegroups.com.
   For more options, visit this group at
   http://groups.google.com/group/cfaussie?hl=.
  
  
  
 
 
  --
  Zac Spitzer
  Solution Architect / Director
  Ennoble Consultancy Australia
  http://www.ennoble.com.au
  http://zacster.blogspot.com
  +61 405 847 168
 
  --
 
  You received this message because you are subscribed to the Google
  Groups cfaussie group.
  To post to this group, send email to cfaus...@googlegroups.com.
  For more options, visit this group at
  http://groups.google.com/group/cfaussie?hl=.
 
 


 --

 You received this message because you are subscribed to the Google Groups
 cfaussie group.
 To post to this group, send email to cfaus...@googlegroups.com.
 For more options, visit this group at
 http://groups.google.com/group/cfaussie?hl=.




--

You received this message because you are subscribed to the Google Groups 
cfaussie group.
To post to this group, send email to cfaus...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/cfaussie?hl=.

Re: [cfaussie] Fire Up The Barbie - mate!

2009-11-16 Thread Christophe Albrech

Not that it's got anything to do with cf, but you might want to correct the
application description.

Fire Up The Barbie is an all Aussie app that let’s us Aussie’s do what we
do best – organize and cook up a barbie!
The application let’s you search for a bbq in ACT (more data to come, as we
have mined data for all states) and organize an event for it on facebook,
all details are passed to facebook where you can create the event and invite
your friends.


   - it's not let's, it's lets.
   - it's not Aussie's it's Aussies
   - organise not organized. the latter is a valid american English
   alternative, but hey, you are, after all, selling a true blue, fair dinkum
   Aussie app.

 Not trying to be a prick or a smartass (although I very much am both of
them), but bad grammar or spelling always reflect badly on the app and the
developer.

Cheers,

Tof


On Thu, Nov 12, 2009 at 4:20 PM, Taco Fleur taco.fl...@clickfind.com.auwrote:

 Hey guys,

 I just submitted an app written in CF and JS, just wondering if you could
 spare a moment and cast your vote (5 stars of course ;-) here
 http://mashupaustralia.org/mashups/fire-up-the-barbie/

 Ooh, and its a facebook app as well so you can add it to your profile and
 whenever you feel like a barbie with your mates, just Fire Up The Barbie,
 crack open a tinnie and cook some snags!

 --
 Kind regards,
 Taco Fleur
 clickfind™ - The new Australian Online Marketing Platform (OMP)
 http://www.onlinemarketingplatform.com.au
 http://www.clickfind.com.au

  --
 You received this message because you are subscribed to the Google Groups
 cfaussie group.
 To post to this group, send email to cfaus...@googlegroups.com.
 For more options, visit this group at
 http://groups.google.com/group/cfaussie?hl=.


--

You received this message because you are subscribed to the Google Groups 
cfaussie group.
To post to this group, send email to cfaus...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/cfaussie?hl=.

[cfaussie] Re: Convert a date to a proper date object

2009-10-07 Thread christophe albrech

You could also do it at the db level. obvisouly sending the string to the db
to get a timestamp back is not very effective performance wise, but if
you're going to insert it in a table of yours anyway you might as well
convert it there. Of if you've stored a heap of them as strings in the db
and you query on the lot for reporting.
DECLARE @mydate AS VARCHAR(50)
SET @mydate = 'Wed Oct 07 22:59:00 + 2009'
SELECT  CAST(SubString(@mydate, 4, 8) + RIGHT(@mydate, 4) +
SubString(@mydate, 11, 9) AS datetime)

Tof

On Thu, Oct 8, 2009 at 11:15 AM, Steve Onnis st...@cfcentral.com.au wrote:


 @mike

 That's why you just copy and paste :P

 -Original Message-
 From: Mike Kear [mailto:afpwebwo...@gmail.com]
 Sent: Thursday, 8 October 2009 11:13 AM
 To: cfaussie@googlegroups.com
 Subject: [cfaussie] Re: Convert a date to a proper date object


 I can't believe how timely this is!  I had JUST started staring at
 this date and begun thinking about how i was going to deal with this,
 when this thread popped up.

 @Paul i think your answer is tres elegant.Thanks.

 @Steve your solution looks elegant too, but I just KNOW what would
 happen in my case - i'd miss off a close bracket or something.   I
 know it would happen because i have little invisible gremlins sitting
 on my shoulder that wait for me to code lines like that and fire a
 spark or something at my keyboard so it misses off keystrokes.

 Cheers
 Mike Kear
 Windsor, NSW, Australia
 Adobe Certified Advanced ColdFusion Developer
 AFP Webworks
 http://afpwebworks.com
 ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month


 On Thu, Oct 8, 2009 at 10:54 AM, Steve Onnis st...@cfcentral.com.au
 wrote:
  Looks like it is formatted like a javascript date
 
  also notice there is no time zone info thoughbit of a pain that is
 
  thanks for the code snipped though.
 
  i actually decided to do it this way
 
  tweetDate = ParseDateTime(listFirst(ListSetAt(tweetDate, 1,
  listLast(tweetDate,  ),  ), +));
 
  basically turn
 
  Fri Sept 19 16:30:00 + 2009
 
  into
 
  2009 Fri Sept 19 16:30:00
 
  and then parse it with ParseDate()
 
 
  From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On
 Behalf
  Of Steve Onnis
  Sent: Wednesday, October 07, 2009 7:32 PM
  To: cfaussie@googlegroups.com
  Subject: [cfaussie] Re: Convert a date to a proper date object
 
 
 
  yes twitter (dam twits!)
 
 
 
  why is the date like that anyway?
 
 




 


--~--~-~--~~~---~--~~
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 
cfaussie+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/cfaussie?hl=en
-~--~~~~--~~--~--~---

[cfaussie] Re: CFCAMP

2007-11-26 Thread christophe albrech

Any chance you warm-up for web-du by presenting it at the Melbourne cfug?

On Nov 14, 2007 12:50 PM, Toby Tremayne [EMAIL PROTECTED] wrote:

 truth is I got scared that Mark Mandel would yell booo and throw things at
 me so I chickened out.


 On 11/14/07, Mark Blair  [EMAIL PROTECTED] wrote:
 
 
 
  Toby, that's a shame L but totally understand.
 
 
 
  Dale et al,
 
 
 
  CFCAMP's format is going to be fairly flexible on the day, however will
  be kicking the day off with a keynote, followed by a mashup of local
  speakers and Adobe speakers, including myself, Andrew Spaulding and Nick
  Watson.
 
 
 
  The exact running order is still in the process of being locked down and
  will be published to the CFCAMP site late tomorrow.
 
 
 
  Hope that helps
 
 
 
  Best
 
  Mark
 
 
 
  Mark Blair
 
  Technical Director, Pacific
 
  Adobe Systems
 
 
 
 
 
 
 
  *From:* cfaussie@googlegroups.com [mailto: [EMAIL PROTECTED] *On
  Behalf Of *Toby Tremayne
  *Sent:* Wednesday, 14 November 2007 10:12 AM
  *To:* cfaussie@googlegroups.com
  *Subject:* [cfaussie] Re: CFCAMP
 
 
 
  Hi Dale,
 
   I asked to be removed from the list as i've just landed 4 new clients
  all at once so I'm not going to have time to even finish writing my session
  in time for cfcamp.  I'm disappointed not to be able to speak but yeah
  nothing sinister :)  I'll hopefully be doing the session at webdu in 2008
  instead - I will be attending cfcamp, but just as a spectator.
 
  Toby
 
  On 11/14/07, *Dale Fraser* [EMAIL PROTECTED] wrote:
 
  So I thought I'd ask here as others might be interested.
 
 
 
  What's happening with this, I've seen in Melbourne speakers being
  removed, have they changed their mind or not been accepted. Can anyone tell
  me what the format is, how it will work etc, etc.
 
 
 
  There doesn't seem to be enough speakers and was wondering what people
  would be doing in the meantime, what the agenda is for timing of talks etc
  etc.
 
 
 
  Regards
 
  Dale Fraser
 
 
 
 
 
 
 
 
 
 
 
 

 


--~--~-~--~~~---~--~~
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: CFMX 6.1 Admin

2007-09-16 Thread christophe albrech

yeah dude, that's madness to have it set up that way on a live box. doesn't
really explain the crashes though, should just make your app run a bit slow.


you should also install the latest version of machii, it's faster.



On 9/14/07, Stephen M [EMAIL PROTECTED] wrote:


 Every one of the MachII apps has cfset MACHII_CONFIG_MODE = 1 /

 That's not usual is it? Why would they do that?  The first thing you
 read (well half way down the second page) in the MachII getting
 Started doc is the bit that says set MACHII_CONFIG_MODE to -1 (never
 reload) for production.

 Stephen

 On Sep 14, 12:47 pm, Steve Onnis [EMAIL PROTECTED] wrote:
  Personally I would be looking at the MachII sites. I have found them to
 be
  very resource hungry as they are storing a lot of stuff in the memory
 and if
  you are running multiple sites using it, that may be whats causing your
  memory usage.
 
  Although if it was fine untill you put the shadow app on it, then maybe
 the
  shadow app just pushed it over the edge.  I don't know anything about
 shadow
  and how it handles cfc persistence but maybe it also stores a lot of
 stuff
  in memory.
 
  Steve
 
  -Original Message-
  From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On
 Behalf
 
  Of Stephen M
  Sent: Friday, 14 September 2007 12:37 PM
  To: cfaussie
  Subject: [cfaussie] Re: CFMX 6.1 Admin
 
  On Sep 14, 12:14 pm, Dale Fraser [EMAIL PROTECTED] wrote:
   Cough 6.1
 
   Umm, upgrade due soon?
 
  Yeah, we're going to CF8 --- WooHoo!! But that won't happen for a few
 weeks
  and I need to stabilise this thing right now.
 
   Anyway, 6.1 was pretty stable, you shouldn't have to tweak those
 settings.
   If you are getting those types of messages and crashes, I'd seriously
   be having a look at your apps to see if your doing anything silly.
 
  There's lots of stuff on this server besides the Shado, quite a few
 MachII
  and then a few plain ole HTML with bits of java thrown in. I've only
 been
  here 10 days and I'm finding new stuff every day. It could be a
 sociability
  issue.  But naturally Cold Fusion itself tends to be blamed.
 
   Regards
   Dale Fraser
 
  http://learncf.com
 
   -Original Message-
   From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On
   Behalf
 
   Of Stephen M
   Sent: Friday, 14 September 2007 11:34 AM
   To: cfaussie
   Subject: [cfaussie] CFMX 6.1 Admin
 
   I've got a  6.1MX system that is crashing way too often.  It might be
   the Shado content management setup, but I'm asking that question on
   another forum.
 
   Ithought I should try to tweak the admin settings.   I have just found
   a few java.lang.OutOfMemoryError errors in the exception log so that
   means I should increase the JVM Max Heap size doesn't it?
 
   Although the OutOfMemoryError doesn't always correspond to the crashes
   so there is probably something else going on as well.
 
At the moment the JVM Max Heap size is set to 512MB, there is no Min
   size set.  A bit of googling through various java mailing list
   archives suggests I should set Min to the same as Max for improved
   performance.
 
   Any suggestions?  Its way too late for load testing.  I've just got to
   stick something in to see if it works better.  I'm aware that
   increasing the Max heap setting makes for more work for the Garbage
   Collector and could therefore result in decreased performance.  Are
   there any other potential problems?
 
   To complicate thing I have the following startup string set.  Again,
   my search of the archives suggests that MaxpermSize is a different
   parameter not related to Max or Min Heap size.  Should I be adjusting
   this string as well.?
 
   -server -Dsun.io.useCanonCaches=false -Xbootclasspath/
   a:{application.home}/../lib/webchartsJava2D.jar -XX:MaxPermSize=128m
   -XX:+UseParallelGC
 
 
 
   winmail.dat
  4KDownload


 


--~--~-~--~~~---~--~~
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: CFMX 6.1 Admin

2007-09-16 Thread christophe albrech

yup should be faster, and nope, one of the goal of the machii team is to
keep it 100% backward compatible. 1.5RC1 is out too.

That said I honestly don't know how well machii works with versions as old
as 6.1.

the config mode tells the framework whether it should reload itself or not.
This involves creating objects and other things, which can take some time.


On 9/17/07, Stephen M [EMAIL PROTECTED] wrote:


 I've changed all the MACHII_CONFIG_MODE settings back to -1  Some were
 already set to -1, some were set to 0 and some were set to 1.  There
 is no explanation or docos explaining why or why not, but they are all
 -1 now.

 Most of these apps, if they are run, would be run overnight from
 England by 1 person, so they are probably not competing for resources
 anyway.

 Just had to search up and down the directory trees looking for MachII
 apps.  No one seems to know how many there are or how often they get
 used.

 We are running version 1.1.0

 Is 1.1.1 really much faster?  More importantly, there are no issues
 with the upgrade?

 thanks,
 Stephen



 On Sep 17, 11:43 am, christophe albrech
 [EMAIL PROTECTED] wrote:
  yeah dude, that's madness to have it set up that way on a live box.
 doesn't
  really explain the crashes though, should just make your app run a bit
 slow.
 
  you should also install the latest version of machii, it's faster.
 
  On 9/14/07, Stephen M [EMAIL PROTECTED] wrote:
 
 
 
   Every one of the MachII apps has cfset MACHII_CONFIG_MODE = 1 /
 
   That's not usual is it? Why would they do that?  The first thing you
   read (well half way down the second page) in the MachII getting
   Started doc is the bit that says set MACHII_CONFIG_MODE to -1 (never
   reload) for production.
 
   Stephen
 
   On Sep 14, 12:47 pm, Steve Onnis [EMAIL PROTECTED] wrote:
Personally I would be looking at the MachII sites. I have found them
 to
   be
very resource hungry as they are storing a lot of stuff in the
 memory
   and if
you are running multiple sites using it, that may be whats causing
 your
memory usage.
 
Although if it was fine untill you put the shadow app on it, then
 maybe
   the
shadow app just pushed it over the edge.  I don't know anything
 about
   shadow
and how it handles cfc persistence but maybe it also stores a lot of
   stuff
in memory.
 
Steve
 
-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED]
 On
   Behalf
 
Of Stephen M
Sent: Friday, 14 September 2007 12:37 PM
To: cfaussie
Subject: [cfaussie] Re: CFMX 6.1 Admin
 
On Sep 14, 12:14 pm, Dale Fraser [EMAIL PROTECTED] wrote:
 Cough 6.1
 
 Umm, upgrade due soon?
 
Yeah, we're going to CF8 --- WooHoo!! But that won't happen for a
 few
   weeks
and I need to stabilise this thing right now.
 
 Anyway, 6.1 was pretty stable, you shouldn't have to tweak those
   settings.
 If you are getting those types of messages and crashes, I'd
 seriously
 be having a look at your apps to see if your doing anything silly.
 
There's lots of stuff on this server besides the Shado, quite a few
   MachII
and then a few plain ole HTML with bits of java thrown in. I've only
   been
here 10 days and I'm finding new stuff every day. It could be a
   sociability
issue.  But naturally Cold Fusion itself tends to be blamed.
 
 Regards
 Dale Fraser
 
http://learncf.com
 
 -Original Message-
 From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED]
 On
 Behalf
 
 Of Stephen M
 Sent: Friday, 14 September 2007 11:34 AM
 To: cfaussie
 Subject: [cfaussie] CFMX 6.1 Admin
 
 I've got a  6.1MX system that is crashing way too often.  It might
 be
 the Shado content management setup, but I'm asking that question
 on
 another forum.
 
 Ithought I should try to tweak the admin settings.   I have just
 found
 a few java.lang.OutOfMemoryError errors in the exception log so
 that
 means I should increase the JVM Max Heap size doesn't it?
 
 Although the OutOfMemoryError doesn't always correspond to the
 crashes
 so there is probably something else going on as well.
 
  At the moment the JVM Max Heap size is set to 512MB, there is no
 Min
 size set.  A bit of googling through various java mailing list
 archives suggests I should set Min to the same as Max for improved
 performance.
 
 Any suggestions?  Its way too late for load testing.  I've just
 got to
 stick something in to see if it works better.  I'm aware that
 increasing the Max heap setting makes for more work for the
 Garbage
 Collector and could therefore result in decreased
 performance.  Are
 there any other potential problems?
 
 To complicate thing I have the following startup string
 set.  Again,
 my search of the archives suggests that MaxpermSize is a different
 parameter not related to Max or Min Heap size.  Should I be
 adjusting

[cfaussie] Re: CF8 Release Date Rumor

2007-07-17 Thread christophe albrech

I've heard this twice now, but from no one I know to be reliable That
means Peter, yeah?

Tof

On 7/17/07, Dale Fraser [EMAIL PROTECTED] wrote:

  Can anyone confirm the CF8 release date of next Monday? I've heard this
 twice now, but from no one I know to be reliable.



 Regards

 Dale Fraser



 http://dalefraser.blogspot.com





 


--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
cfaussie group.
To post to this group, send email to cfaussie@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/cfaussie?hl=en
-~--~~~~--~~--~--~---

[cfaussie] Re: Server Virus Software

2007-06-20 Thread christophe albrech

Exactemundo, Joel.

On 6/20/07, Joel [EMAIL PROTECTED] wrote:

  Do you use the command line interface for Fprot via CFexecute during file
 uploads?




  --

 *From:* cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] *On
 Behalf Of *christophe albrech
 *Sent:* Wednesday, 20 June 2007 1:42 PM
 *To:* cfaussie@googlegroups.com
 *Subject:* [cfaussie] Re: Server Virus Software



 We're using something called Fprot on both servers and workstation, and
 also within the CF code to scan user-uploaded documents on the fly.

 Cheers

 Tof

 On 6/16/07, *Dale Fraser* [EMAIL PROTECTED] wrote:

 What Virus software are people using to run on Windows 2003 based servers.



 Looking for some recommendations that scan automatically, update
 definitions automatically etc.



 Regards

 Dale Fraser



 http://dalefraser.blogspot.com










 


--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
cfaussie group.
To post to this group, send email to cfaussie@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/cfaussie?hl=en
-~--~~~~--~~--~--~---

[cfaussie] Re: CFAussie Community Head Count

2007-06-19 Thread christophe albrech

booya

On 6/5/07, Mark Mandel [EMAIL PROTECTED] wrote:


 wow.. is this thing still going?

 Mark

 On 6/5/07, dfwise [EMAIL PROTECTED] wrote:
 
  FAB,
 
  Long time veiwer, first time caller.
 
 
  On Jun 1, 12:02 pm, Matt Voerman [EMAIL PROTECTED] wrote:
   Hi Guys,
   Just a quick note to let you guys know that we at the Adobe Australia
   office haven't forgotten about you, and do monitor this (and several
   other) lists on a regular basis.
  
   We have a couple of Community related irons in the fire and will
   communicate more on them as they solidify.
  
   What would be of great help to us in the meantime would be a hands up
   (head count) on how many Aussie CF'ers are reading this list on a
   regular basis. If you could just ping a response to to this thread
   that would be grouse.
  
   Thanks in advance
  
   Matt Voerman
  
   Senior Consultant
   Adobe Systems Pacific
 
 
  
 


 --
 E: [EMAIL PROTECTED]
 W: www.compoundtheory.com

 


--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
cfaussie group.
To post to this group, send email to cfaussie@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/cfaussie?hl=en
-~--~~~~--~~--~--~---

[cfaussie] Re: cfmail problems in Gmail

2007-06-19 Thread christophe albrech

haha, I must be a bit dyslexic. When I read your email the first time I read
You have successfully started the registration process with Smellystuff.
:-D


On 6/18/07, Taco Fleur [EMAIL PROTECTED] wrote:

 Hello all,

 I am sending out a text only email (see below), but it does not display in
 the Gmail interface.
 Should I remove the cfmailpart? Or is there something else I am missing.
 Thanks in advance.

 cftry
 cfmail
  to=#getEmailAddress()#
  from=[EMAIL PROTECTED]
  subject=Your registration with Sellmystuff
  mailerid=sellmystuff.com.au
  wraptext=60
cfmailpart type=text wraptext=60
 Hello #getScreenName()#,

 You have successfully started the registration process with Sellmystuff,
 the email address you used is: #getEmailAddress()#

 Please make sure you add [EMAIL PROTECTED] to your safe sender
 list, this will prevent our future emails from ending up in the SPAM folder.

 You will receive another confirmation from us when your registration is
 completed.

 Regards,
 The Sellmystuff team/cfmailpart
 /cfmail
 cfcatch
  cfset request.system.Error.doLogError ( cfcatch ) 
 /cfcatch
/cftry
   /cfif


 --
 http://www.clickfind.com.au
 The new Australian search engine for businesses, products and services
 


--~--~-~--~~~---~--~~
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: Server Virus Software

2007-06-19 Thread christophe albrech

We're using something called Fprot on both servers and workstation, and also
within the CF code to scan user-uploaded documents on the fly.

Cheers

Tof

On 6/16/07, Dale Fraser [EMAIL PROTECTED] wrote:

  What Virus software are people using to run on Windows 2003 based
 servers.



 Looking for some recommendations that scan automatically, update
 definitions automatically etc.



 Regards

 Dale Fraser



 http://dalefraser.blogspot.com



 


--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
cfaussie group.
To post to this group, send email to cfaussie@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/cfaussie?hl=en
-~--~~~~--~~--~--~---

[cfaussie] Re: Hack ColdFusion Application

2007-05-15 Thread christophe albrech

back home (France), Fleur is a chick first name, so I always thought you
were a girl as well.

taco means something in French too (and I'm not talking DnD) but I won't
translate it ;-)

Tof

On 5/11/07, Taco Fleur [EMAIL PROTECTED] wrote:

 Hi Adam,

 more than willing to share anything that is found.

 So far its all bugs really.

 David was able to create an account that should allow only uploading of
 one ad that has an item price higher than $2 and also allows uploading of 50
 free items. He then went and posted his paid ad and free ads, then edited
 the free ads to have a higher item price than $2. In short, he was able to
 post more ads than he paid for.

 And the other bug was that he could upload as many $2 ads as he wanted
 because the code had = 2 instead of  2

 Nothing really shocking, even though they were not true hacks/cracks (as
 I'd hoped they'd be), I made the mistake of writing the instructions a
 little different for him, so I could not back out of paying up for it ;-)

 Lucas found that the CFAdmin was accessible, stupid me, still have the
 website on development. Could not let that one slip wihtout paying for it
 either.

 In regards to security;
 - basically using cfqueryparam everywhere
 - stored procs
 - do not allow html in any of the text fields
 - perform regex over all input
 - do not allow numerical values higher than 2,147,483,647 or less than
 -2,147,483,648 as we know for sure that our database only works with INTEGER
 data type
 - check that a user owns the record he is editing deleting
 - do not output any vars passed through the url, instead pass an integer
 and use a switch case
 stuff like that which everyone knows ;-)

 Still hoping someone comes along and is able to crack it with some fancy
 voodoo stuff like using hexidecimal values that I did not anticpate or
 something like that.

 PS. I am male and honestly don't care what jokes you crack about my name,
 at least I can say there is only one Taco Fleur in this world, I bet you
 can't say that about Andrew Scott

 PPS. thanks Barry for your support, I have to say it was difficult to do
 and very scary, but yes we do want to make sure all bases are covered and
 the clients get what they pay for.

 On 5/11/07, Adam Chapman [EMAIL PROTECTED] wrote:
 
 
  Hi Taco
 
  Wondering if you are willing to share what you've discovered so others
  can better hack proof their apps..
 
  (when you've addressed those issues yourself of course ;) )
 
  Cheers,
  Adam
 

 


--~--~-~--~~~---~--~~
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: Request VS Application Scope

2007-04-23 Thread christophe albrech

Dude, to answer you original question, which is what the hell is the
request scope? (if I understand you well): the request scope gives you
access to the whole HTTP request entity. So you can see it as one round-trip
to the server. If inside a template, you have a cfmodule, or a cf_whatever,
a variable defined as request.var1, will be visible, whereas a non scoped
variable (or really, a variables. variable) is only visible within a given
template, and the templates it includes (as in cfinclude).

tof

On 4/23/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:


 Yeah thanks for that.

 So basically, when would you need to be using the request scope?

 I use the application.cfc so i would have all this in my
 onrequeststart().

 Thanks once again guys,

 On Apr 23, 7:41 pm, M@ Bourke [EMAIL PROTECTED]
 wrote:
  I'd either put it in your application scope or cache ya query.
  if it's going to be available for every user all the time then
 application
  shouldn't be a problem
  if the site's busy and ya setting it to request each page request for
 each
  user then it would be using a lot of memory although the memory would be
  getting cleaned up it would be continually getting filled up.
  I'm not an expert on the inner workings of the cf server but I'd try the
  application scope and if you don't get any issues with it then for this
 case
  just sick with it.
 
  M@
 
  On 4/23/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
 
 
 
   Well i store them in the application scope because i call some
   function to fetch page information from the database and i wouldnt
   want them to load on every page request, I would much rather store
   them in the app scope and call them from the pages This was
   implemented to avoid hitting the db all the time for fetch page
   elements and things like that.
 
   If i was to place them in the request scope would this mean they would
   load on every page request? Obs this isnt what i would want.
 
   On Apr 23, 7:23 pm, Peter Tilbrook [EMAIL PROTECTED] wrote:
No point. In fact an unnecessary overhead.
 
Once the request is finished they are no longer required. Another
 page
request - they are used - then zip. No locking or anything required.
 
Application vars have their place but for - at least how I use them
 -
   like
datasourcenames and such - Request scope is perfectly suitable. Just
   declare
them in the Application.cfm so they are available to all page
 requests.
 
--
Peter Tilbrook
ColdGen Internet Solutions
President, ACT and Region ColdFusion Users Group
PO Box 2247
Queanbeyan, NSW, 2620
AUSTRALIA
 
   http://www.coldgen.com/http://www.actcfug.com/
 
Tel: +61-2-6284-2727
Mob: +61-0432-897-437
 
Email: [EMAIL PROTECTED]
MSN Messenger Live: Desktop General


 


--~--~-~--~~~---~--~~
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: mail a friend protocol

2007-04-22 Thread christophe albrech

We recently had the same problem down here. Our system uses subdomains for
each of our clients (client1.mycompanyname.net.au), but users usually
register with own business email, so we end up sending emails from my
company domain with a from-address like [EMAIL PROTECTED] .

Of course, that didn't exactly fly with spoofing detection, so we created a
generic client address like [EMAIL PROTECTED] for the
from-address, and used the individual user address in a reply-to mailparam.

does that make sense?

Tof

On 4/17/07, AJ Mercer [EMAIL PROTECTED] wrote:

 We have a web site that has 'mail a friend' option that will send the
 details of the page they are looking at to their friend(s)

 Currently, I have it set up such that the email address will be that of
 the person sending it.
 This has caused a licensing issue on our mail server - too many email
 addresses.

 This has raised a couple of questions:

 a) Is it bad practice to send from a different domain?
 e.g. mail.mycomany.com sending mail for [EMAIL PROTECTED]
 Will this look like a spoof email to the receiving email server?

 b) Would it be bad practice to send the mail with the To address like
 this:
 Your Friends Name [EMAIL PROTECTED]
  with the Reply-to being your email address e.g. [EMAIL PROTECTED]



 


--~--~-~--~~~---~--~~
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: OT: In Melbourne if anyone wants to catchup

2007-04-16 Thread christophe albrech

there's no online demo, but you can download a sample zip there
http://www.microsoft.com/silverlight/tools.aspx


On 4/16/07, Dale Fraser [EMAIL PROTECTED] wrote:

  Wow,



 That is impressive, I always wanted to see a new Logo!



 WTF? Where is the content, screenshots, demos. You can't launch a product
 with just a logo, the website you posted is broken even. Just click the
 Microsoft Silverlight home page link on the right, which goes here.



 http://www.microsoft.com/silverlight/



 I'm sure you will find all the juicy content there, NOT!



 Regards

 Dale Fraser



 http://dale.fraser.id.au/blog



 *From:* cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] *On
 Behalf Of *Scott Barnes
 *Sent:* Monday, 16 April 2007 3:55 PM
 *To:* cfaussie@googlegroups.com
 *Subject:* [cfaussie] Re: OT: In Melbourne if anyone wants to catchup



 Oh yeah, for anyone wanting to know more about Microsoft going forward
 come along. I also should point out that this is a roadshow mostly about
 User Experience stuff so it can be worthwhile for the CF folk as well ( yes
 you don't have to buy products or sell your soul).



 Christophe, be sure to say hi! :)



 p.s

 http://blogs.msdn.com/msmossyblog/archive/2007/04/16/microsoft-debuts-its-flash-killer-silverlight.aspx



 We announced SilverLight todayish :) - may help put things in a bit more
 perspective.



 On 4/16/07, *christophe albrech* [EMAIL PROTECTED] wrote:

 I've registered for the conference, so I might see you there.

 On 4/13/07, *Scott Barnes* [EMAIL PROTECTED]  wrote:

  I'm in Melbourne on Wed-Thu 18th-19th April, if anyone wants to catchup
 and poke fun at my Microsoft logo?



 I'm in town for a roadshow that maybe of interest to CF`ers around User
 Experience.

 http://blogs.msdn.com/shanemo/pages/the-age-of-user-experience-sydney-11-4-brisbane-12-4-13-4-melbourne-19-4.aspx




 --
 Regards,
 Scott Barnes
 http://www.mossyblog.com




 br

 


--~--~-~--~~~---~--~~
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: OT: In Melbourne if anyone wants to catchup

2007-04-15 Thread christophe albrech

I've registered for the conference, so I might see you there.

On 4/13/07, Scott Barnes [EMAIL PROTECTED] wrote:

 I'm in Melbourne on Wed-Thu 18th-19th April, if anyone wants to catchup
 and poke fun at my Microsoft logo?

 I'm in town for a roadshow that maybe of interest to CF`ers around User
 Experience.
 http://blogs.msdn.com/shanemo/pages/the-age-of-user-experience-sydney-11-4-brisbane-12-4-13-4-melbourne-19-4.aspx



 --
 Regards,
 Scott Barnes
 http://www.mossyblog.com

 


--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
cfaussie group.
To post to this group, send email to cfaussie@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/cfaussie?hl=en
-~--~~~~--~~--~--~---

[cfaussie] Re: HTTPZip on Coldfusion Server

2007-03-26 Thread christophe albrech

out here, we use Xcompress 3.0, which works a treat.

Tof


On 3/7/07, Steve Onnis [EMAIL PROTECTED] wrote:


 Hey guys

 Has anyone here implements HTTPZip or anything like that for code
 compression on a coldfusion server?  I am running IIS6 and CF7 and it
 doesnt seem to be doing anything at all.

 Steve


 


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

2006-10-11 Thread christophe albrech

always liked this one: http://www.dynarch.com/projects/calendar/On 10/10/06, grant 
[EMAIL PROTECTED] wrote:Anybody care to recommend a well-designed capable easy-to-deploy cross-browser _javascript_ datepicker?
Thnks





--~--~-~--~~~---~--~~
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: SMSC SMS providers in Australia

2006-09-26 Thread christophe albrech

Lucas,Here, we're using messagemedia, who are  an sms wholesaler. this means that you can actually bill your clients per SMS. they have an java api, which works pretty well.Tof
On 9/20/06, Lucas [EMAIL PROTECTED] wrote:
Hey Folks,does anyone know of a good SMS provider in Australia that will allow us to connect to their SMSC from the ColdFusion SMS gateway?cheers,Lucas.-- 

http://www.thebitbucket.net





--~--~-~--~~~---~--~~
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: Multiple Level Inheritance

2006-09-19 Thread christophe albrech

agh. well said me heartyOn 9/19/06, Barry Beattie [EMAIL PROTECTED] wrote:
 He's talking about a scenario where inheritence goes up more than one level.ayeparent-child-grandchild The OO guy in me does ask tho - is this something that *has* to be
 done through inheritence, or can it be done throuhg composition?aye, aye. that be what I wuz drivin'at.shiver me timbers.barry.b
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups cfaussie group.  To post to this group, send email to cfaussie@googlegroups.com  To unsubscribe from this group, send email to [EMAIL PROTECTED]  For more options, visit this group at http://groups.google.com/group/cfaussie  -~--~~~~--~~--~--~---

[cfaussie] Re: Querying across multiple databases

2006-09-14 Thread christophe albrech

You could do cross database queries even if they were on different servers. In the case of MSSQL, you just have to register linked servers through sp_addlinkedserver, and then use myLinkedServer.Mydatabase.MyDBuser.Mytable
.TofOn 9/13/06, [EMAIL PROTECTED] 
[EMAIL PROTECTED] wrote:Are the databases on the same sql server? If so you can simply include the
database name as part of the query.ie dbname.dbuser.dbtable Hi all I think I remember a post on this before but I can't find it anywhere.
 the app I'm extending uses 2 databases (2 diff DSN's). I now need to pull in data from both into the same recordset. eg: SELECT SCHED.StartDateTime, SCHED.EndDateTime, SCHED.Quiz_ID
, INST.AbsoluteSerialNum FROM tbl_Quiz_Schedule AS SCHED INNER JOIN evaluations.dbo.tbl_InstrumentReleased AS INST ON INST.>
 I could:- use Query'o'query to combine 2 seperate queries into one (too much irrelivant data)- put the SQL onto one of the DB's as a SProc (back-up plan)- work out how to join the two databases within the same CFQUERY
 (preferred) any suggestions? thanx barry.b 

--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups cfaussie group.  To post to this group, send email to cfaussie@googlegroups.com  To unsubscribe from this group, send email to [EMAIL PROTECTED]  For more options, visit this group at http://groups.google.com/group/cfaussie  -~--~~~~--~~--~--~---

[cfaussie] Re: OT : I will be available for contract shortly

2006-09-14 Thread christophe albrech

Steve,We regularly need contractors here. (NGA, the potential new venue for the melbourne cfug). Can you send me ([EMAIL PROTECTED] dot net dot au) your resume just in case ?cheersTof
On 9/8/06, Steve Onnis [EMAIL PROTECTED] wrote:





Hey 
guys

I just wanted to get 
the word out that I will be available for contract work in a couple of weeks, so 
anyone needed a hand with some projects, please feel free to contact me at [EMAIL PROTECTED] if you think I 
could be of service to you, no matter how short the term.

I am based in 
Melbourne but have no issue going interstate if required.

Regards
Steve 
Onnis









--~--~-~--~~~---~--~~
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: VIC UG Numbers

2006-09-04 Thread christophe albrech

Same as Mark.TofOn 9/1/06, Dale Fraser [EMAIL PROTECTED] wrote:
I wanted to do this last night but forgot.If you were at the usergroup last night,Can you let us know if you were there just because of the Flex stuff or forColdfusion.I've attached voting to this email so you can either click (assuming this
works through groups) or just email back.Also, Steve / anyone count how many people were there?RegardsDale Fraserhttp://dale.fraser.id.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: Last nights usergroup meeting

2006-09-04 Thread christophe albrech

Too bad, it's a bit far for me. Maybe if I buy a bike?On 9/1/06, Bjorn Schultheiss [EMAIL PROTECTED]
 wrote:2 thumbs up.Sounds good to me.Just around the corner from where I work.
Regards,Bjorn SchultheissSenior Flash DeveloperQDC Technologies-Original Message-From: cfaussie@googlegroups.com [mailto:
cfaussie@googlegroups.com] On BehalfOf Mark MandelSent: Friday, 1 September 2006 11:23 AMTo: cfaussie@googlegroups.comSubject: [cfaussie] Re: Last nights usergroup meeting
Btw all -I got told today if we want to do CFUG meetings here (Raglan St, SthMelbourne)Would people like tha as a venue?MarkOn 9/1/06, Bjorn Schultheiss 
[EMAIL PROTECTED] wrote: Yeah The next one we'll go hard into CF/Flex and then intro into FDS. FDS is really cool but complex. CF/Flex rocks.. The next meeting will be a good one.
 In the meantime post your work flexaussie list. Guys need any help i'll be there. Regards, Bjorn Schultheiss Senior Flash Developer QDC Technologies
--E: [EMAIL PROTECTED]W: www.compoundtheory.com
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups cfaussie group.  To post to this group, send email to cfaussie@googlegroups.com  To unsubscribe from this group, send email to [EMAIL PROTECTED]  For more options, visit this group at http://groups.google.com/group/cfaussie  -~--~~~~--~~--~--~---

[cfaussie] Re: Why buy into CF?

2006-08-30 Thread christophe albrech

cf_troll
Personally, I thing Coldfusion is shit-house, period.
/cf_troll

tof

On 8/30/06, Andrew Mercer [EMAIL PROTECTED] wrote:

yep - this is my point.Sure the sleep thing is simple, but ColdFusion is more aboutCFSLEEP time=5000 /

On 8/30/06, Dale Fraser [EMAIL PROTECTED]
 wrote:

Brett,You make a fine point, I wasn't sure if he wanted to access the java stuff
or have Adobe provide more out of box tags.But I totally agree with you, this stuff is simple Zip, Sleep, Image Adobeshould include it, they would be silly not to. RegardsDale Fraser
http://dale.fraser.id.au-Original Message-From: cfaussie@googlegroups.com [mailto:
cfaussie@googlegroups.com] On BehalfOf Brett Payne-RhodesSent: Wednesday, 30 August 2006 8:00 PM
To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Why buy into CF?I'm sure Andrew is aware of that, and that there are custom tags around for
zip and sleep as well.But just because these things exist does not mean that Adobe should not be expanding the native CF tag library to include these features. I for onewould be generally much happier to use a CF tag in preference to a third
party tag - even if Ben Forta's name is signed on it.And isn't that is what CF is largely being touted as... A way for us non-java programmers to tap into and deliver 'java' based systems...Cheers,
BrettB)Haikal Saadh wrote: Ben Forta has written an wrapper around image/J. Andrew Mercer wrote:  What I would like to see from Adobe take from .Net is the amount of
 objects that have been exposed in to the developer. That is, I would like to see more JAVA objects exposed. For example, I  would like to see a CFZIP tag, and how about CFIMAGE or CFSLEEP. There
 is pletty of stuff in the JVM - it just need to be made easier to access.


--~--~-~--~~~---~--~~
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: CFECLIPSE search

2006-08-23 Thread christophe albrech

Jeremy,

Go to search menu == search
create a working-set or use an existing one (choose)
then hit replace. it will find all the matches then offer you to replace.
Nothing prevents you from creatinga working set that encompasses several projects.

Tof
On 8/18/06, cfgroupie [EMAIL PROTECTED] wrote:
Hey Guys,Just a simple one, does anyone know how to do a find and replace on anentire project in cfeclipse? I found the search portion and I worked
out the replace. But it doesn't do anything...what the?Jeremy

--~--~-~--~~~---~--~~
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: CF to ASP programmer wanted

2006-07-26 Thread christophe albrech

sure, but what I meant was that, to me the tricky thing about a query is the query itself, not how you run it from x dev language to y DBMS. if he's not migrating to a new db server as well, the sql should be the same. I don't think updating the cfquery/cfqueryparam/quotes... should be that complicated.


but again, I don't know asp, so I might be plain wrong here ;-)
On 7/26/06, Barry Beattie [EMAIL PROTECTED] wrote:
christophethat's not quite trueboth ASP and ASP.NET use SQL as a string in a command (you can throw
the SQL string straight at a connection object without a commandobject being used). there's issues about single quotes andconcatenation as well as parameters. cfqueryparam is heaven on astick...
But I suspect what Cookie is after is more the experiance in using ADO/ADO/NETeg:connection objectscommandrecordset  (ADO/ASP)dataset  (
ADO.NET/ASP.NET)parameterCookie, it might be worth clarifying if this is for ASP (_vbscript_) orASP.NET (C# or VB.NET)(sorry, the gig ain't for me at the moment)
On 7/26/06, christophe albrech [EMAIL PROTECTED] wrote: the trickiest part about them is the sql queries
 I don't get that... sql shouldn't have to be modified when translating coldfusion to asp. Only the functions (cfquery = whatever in asp) that execute the queries should change??
 tof On 7/26/06, cookie [EMAIL PROTECTED] wrote:   I urgently need a programmer who can translate ColdFusion to ASP for a
  couple of days work.I have some relatively short and simple CF pages  that need translation, the trickiest part about them is the sql  queries. If anyone can assist either email me at 
[EMAIL PROTECTED] or  call my mobile on 0419316815. I can then send interested parties the  source code to enable you to give me a quote for the job.  Thanks
   Graham Cook

--~--~-~--~~~---~--~~
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: CF to ASP programmer wanted

2006-07-25 Thread christophe albrech

the trickiest part about them is the sqlqueries

I don't get that... sql shouldn't have to be modified when translating coldfusion to asp. Only the functions (cfquery = whatever in asp)that execute the queries should change??

tof
On 7/26/06, cookie [EMAIL PROTECTED] wrote:
I urgently need a programmer who can translate ColdFusion to ASP for acouple of days work.I have some relatively short and simple CF pages
that need translation, the trickiest part about them is the sqlqueries. If anyone can assist either email me at [EMAIL PROTECTED] orcall my mobile on 0419316815. I can then send interested parties the
source code to enable you to give me a quote for the job.ThanksGraham Cook

--~--~-~--~~~---~--~~
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: Victorian ColdFusion Design and Development User Group Meeting

2006-07-20 Thread christophe albrech

Yes, same comment as the others:1. the meeting was really cool2. can't wait for the flex preso.cheerstofOn 7/21/06, Bjorn Schultheiss
 [EMAIL PROTECTED] wrote:





Thanks to all who organised last 
night.
Yeah it was pretty cool.

Just a heads up to all CF, Flex and Flash Developers in 
Melbourne at the meeting next month i plan to give a presentation on Flex 
2.

I will run 
through examples of work andtouch on all the 
interesting topics.

Outline
1. Intro Flex Builder2. Intro 
CFEclipse3.Flex2 Hello world (AS3 and MXML intro)
4. Flash 9 Player and AVM2 details
5. Flex Framework6. Flash 9 Display List 7. 
Event Handling 8. Data Binding9. Mystic10. AMF311. Flex Data 
Services
Regards,

Bjorn 
Schultheiss
Senior Flash 
Developer
QDC 
Technologies



From: cfaussie@googlegroups.com
 
[mailto:cfaussie@googlegroups.com] On Behalf Of Mark 
MandelSent: Friday, 21 July 2006 10:14 AMTo: 
cfaussie@googlegroups.comSubject: [cfaussie] Re: TONIGHT : Victorian 
ColdFusion Design and Development User Group Meeting
Just wanted to say - Great meeting last night 
guys!Great presentations from both Dale and Chad, and a good 
turnout.Can't wait till next month.Mark
On 7/20/06, Steve 
Onnis [EMAIL PROTECTED] 
wrote:

  
  
  
  
  Our next scheduled meeting for the 
  Victorian ColdFusion Design and Development User Group willis 
  TONIGHTat VTR Consulting starting at 
  7:00pm.This week we will 
  have 2 guest presenters, Dale Fraser and Chad 
  Renando.
  Dale Fraser
  Version control is a very important aspect of 
  any development process, and even more so when you are working with a team of 
  developers.
  
  Using Subversion with 
  Coldfusion
  

Installing on Windows

Configuring SVN 

Understanding SVN principles 


Using Keywords 

Commit / Update Process 

Tagging / Branching Logging Changes 

  
  Chad Renando
  CFAjax is a black box answer for CF 
  programmers looking for an easy introduction to the increasingly every-day 
  world of ajax. Packaged with pre-made examples prime for copy-and-paste 
  integration into your own application, it is a god-send for anyone who knows 
  what theywant to do without getting bogged down in the why. 
  Coming from a self-proclaimed copy-and-paste relative hack, the brief 
  presentation will take you on the journey from installation to massive 
  single-page application, without stressing the acronyms like CFC, DOM or 
  COM.
  
  
  The introduction of a short but sweet 
  Tips and Tricks segment will be our closing. This segment is 
  designed to shed some light on some cool program shortcuts and tricks to make 
  developing and designing that much faster. This meeting we will be looking at 
  some nifty Adobe PhotoShop shortcuts to make your life 
  easier.
  As always there will be giveaways, 
  giveaways and more giveaways including 
  books, t-shirts and webDU merchandise from 
  the last webDU Conference in Sydney.After the meeting we can go to one 
  of the many pubs/cafes nearby for a drink or a feed. 
  Just a reminder about the CFAUSSIE lists, anyone 
  who isn't registered should be. It's the best place to get help or even just 
  have a rant:PGo to the 
cfaussie google group to register.
  Hope to see you there.
  
  We 
  will be providing refreshments and finger food so if you are looking at coming 
  along please send an RSVP email to 
[EMAIL PROTECTED]so we can get some indication 
  of numbers.
  
  
   
  
  VTR Consulting
 has moved and is now located at Level 
  2, 212 Barkly Street, St 
  Kilda.
  
  Regards
  Steve Onnis
  Victorian CFUG 
  Manager
  -- E: 
[EMAIL PROTECTED]W: www.compoundtheory.comICQ: 3094740 




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

2006-06-28 Thread christophe albrech

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.

--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---

[cfaussie] Re: OT: what Eclipse DB plugin do you use (for SQLServer)?

2006-06-24 Thread christophe albrech

there DBedit too, but I'm not a huge fan.On 6/22/06, Greg Stewart [EMAIL PROTECTED] wrote:
Hi Chris,I just downloaded rc7 and the latest stable build of CFeclipse and sofar it all seem to be running just fine. Are you aware of any issues?
On 6/20/06, Chris Velevitch [EMAIL PROTECTED] wrote: On 6/20/06, Greg Stewart [EMAIL PROTECTED]
 wrote:  As far as I can tell cfeclipse (well at least the BER release) works  really nicely with 3.2 RC4. Have you tried it with 3.2 RC7 (2 Jun)? Chris
 -- Chris Velevitch Manager - Sydney Flash Platform Developers Group www.flashdev.org.au --e: greg.stewart
(a)gmail.comw: http://gregs.tcias.co.uk/

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

54 matches

Mail list logo