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

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

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

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.

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

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

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

2012-02-19 Thread christophe albrech
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

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

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.

Re: [cfaussie] Re: cfchart

2012-02-16 Thread christophe albrech
** ** *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

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

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

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,

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

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

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

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

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

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

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,

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

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

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

2009-11-18 Thread Christophe Albrech
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

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

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

[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

[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:

[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

[cfaussie] Re: CFMX 6.1 Admin

2007-09-16 Thread christophe albrech
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

[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

[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

[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

[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

[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

[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

[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

[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

[cfaussie] Re: OT: In Melbourne if anyone wants to catchup

2007-04-16 Thread christophe albrech
/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

[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

[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

[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

[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

[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

[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

[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

[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

[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] 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

[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:

[cfaussie] Re: CF to ASP programmer wanted

2006-07-26 Thread christophe albrech
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

[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

[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

[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

[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