Re: [cfaussie] SQL identity issue
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 Kukielwrote: > 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?
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 Kwrote: > 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
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, Samariswrote: > 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
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?
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.
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.
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
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?
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
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?
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.
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
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?
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?
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
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
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 See also the related topic: http://help.adobe.com/en_US/ColdFusion/9.0/Developing/WSc3ff6d0ea77859461172 e0811cbec22c24-7a0a.htmlhttp://help.adobe.com/en_US/ColdFusion/9.0/Developing/WSc3ff6d0ea77859461172%0Ae0811cbec22c24-7a0a.html Of course, you can also just google coldfusion autosuggest to find many other resources where people show using this feature, including pros/cons, tips/traps. /charlie -Original Message- From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of goldcoast_nerd Sent: Tuesday, June 28, 2011 11:03 PM To: cfaussie Subject: [cfaussie] Re: Creating A Fast Dropdown List Lookup yep jquery is the way to go here, cfinput autosuggest embeds all the values in the HTML, not ideal. here's the plugin i use -- http://docs.jquery.com/Plugins/autocomplete i would also suggest loading the contents via an ajax request which in turn returns values from a structure or an array if it doesnt change that often, so you dont have to run a query in the background on every keyup. all the best. -- 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: Daily Rate
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
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
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
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
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
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
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!
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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?
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
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
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
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
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
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)?
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 -~--~~~~--~~--~--~---