[cfaussie] Re: Are folks tracking CFJOBS Google Group?
Merge! -- 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.
[cfaussie] Re: CFML Slack team/channels
The number is now nudging 600.. There is now #cfaussie channel for anyone interested.. Regards, Adam On Tuesday, June 30, 2015 at 5:05:47 PM UTC+10, Kai Koenig wrote: Just a quick public service announcement: There’s a very active CFML slack channel now and you should seriously consider joining — there are around 220 people signed up for it and a min of ~50 seems to be active at any given time. More details on how to join here: http://blog.adamcameron.me/2015/06/cfml-slack.html Cheers Kai -- 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] Are there any mid-snr CF devs left in Australia
Our company is using Railo over ACF.. I doubt I'd change back unless they Adobe released some killer features that couldn't be replicated somehow. On Wednesday, February 26, 2014 11:48:33 PM UTC+11, ajme...@gmail.com wrote: Daemon are hosting Farcry CMS sites on Railo including http://sochi2014.olympics.com.au/ No surprises that I am also running Farcry (and MangoBlog) on Railo as well. On 26 February 2014 19:28, M@ Bourke m.electroni...@gmail.comjavascript: wrote: I'm moving back to Oz next year after what will have been 9 years in the UK. Not sure exactly what I'm going to do when I get back, I still do a lot of CF today (primarily Railo) but have focused a lot more on JS lately and run a JS user group here. Do many cf places in oz use Railo? On Wed, Feb 26, 2014 at 11:06 AM, Simon Haddon simon@gmail.comjavascript: wrote: I have written a lot of complex systems in ColdFusion in my time but for the last few years I have been working with just Java. Still love ColdFusion best though. So much so that I wrote a web server from scratch using many similar concepts to ColdFusion. Even to the point that pages were compiled automatically. I nope that ColdFusion stays strong. Cheers Simon. Brett Payne-Rhodes bre...@gmail.com javascript: wrote: Six months ago you could have tempted me to move to Melbourne from Perth. As it is now however I was tempted to Europe instead, now working in The Hague - just don't mention the weather... :) B) On Tue, Feb 25, 2014 at 9:48 PM, Dave david...@gmail.com javascript:wrote: Hi there, I was wondering if there are any mid-senior level ColdFusion developers left in Australia (specifically, Melbourne). We are finding is really tough to hire people that have written enterprise (ie, complex, framework driven) applications. dave -- 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+u...@googlegroups.com javascript:. To post to this group, send email to cfau...@googlegroups.comjavascript: . Visit this group at http://groups.google.com/group/cfaussie. For more options, visit https://groups.google.com/groups/opt_out. -- 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+u...@googlegroups.com javascript:. To post to this group, send email to cfau...@googlegroups.comjavascript: . Visit this group at http://groups.google.com/group/cfaussie. For more options, visit https://groups.google.com/groups/opt_out. -- 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+u...@googlegroups.com javascript:. To post to this group, send email to cfau...@googlegroups.comjavascript: . Visit this group at http://groups.google.com/group/cfaussie. For more options, visit https://groups.google.com/groups/opt_out. -- 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+u...@googlegroups.com javascript:. To post to this group, send email to cfau...@googlegroups.comjavascript: . Visit this group at http://groups.google.com/group/cfaussie. For more options, visit https://groups.google.com/groups/opt_out. -- *AJ Mercer* webonix:net strength=Industrial / http://webonix.net | webonix:org community=Open / http://webonix.org http://twitter.com/webonix Railo Community Managerhttp://www.getrailo.org/index.cfm/community/team/ -- 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/groups/opt_out.
[cfaussie] Re: CFAussie Posts Are Very Occasional
I still lurk here.. though I find most of my issues are resolved by googling.. BTW.. Hi! On Monday, August 12, 2013 12:33:49 PM UTC+10, rai...@ozemail.com.au wrote: Hi Wondering if this user group is still active as I seem to only receive the occasional post every now and then often nothing for over a week, in the past its been far more regular activity ?? Is there a more active user group that I am not aware of ??? Kind Regards Claude Raiola SAMARIS Software -- 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/groups/opt_out.
RE: [cfaussie] Re: OT: Webpage download timing
+1 for Firebug Regards, Adam From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of Josh Wines Sent: Thursday, 5 April 2012 3:23 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: OT: Webpage download timing Firebug is a great debugging tool that will give you that. http://getfirebug.com/ Josh On Thursday, April 5, 2012 3:15:17 PM UTC+10, Scott.thornton wrote: G'Day, Can anyone recommend any Firefox add-ons, or other programs, that will display the download time of a web page and its components eg .css\.js\.jpg files? I am testing a CF 9 cluster, on a virtualised server, and while the CF debug shows the page renders quickly and queries complete in 10ms, the page is very slow to load and I was wondering if there were problems downloading the external files etc due to mapping problems or file access problems etc. Cheers, -- 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/-/C1JeNPWzjc4J. To post to this group, send email to cfaussie@googlegroups.commailto:cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.commailto: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] Recommendations for a CF Framework.
@Dale: Frameworks are for people who don't know what they are doing :P Or for those who invent wheels for fun.. Documentation is overrated too ;) Regards, Adam -Original Message- From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of Dale Fraser Sent: Friday, 17 February 2012 2:52 PM To: cfaussie@googlegroups.com Subject: RE: [cfaussie] Recommendations for a CF Framework. I'd recommend no framework. Frameworks are for people who don't know what they are doing :P 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 MossyBlog Sent: Friday, 3 February 2012 9:56 PM To: cfaussie Subject: [cfaussie] Recommendations for a CF Framework. 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.
RE: [cfaussie] CSS packager
There is a cfwheels plugin.. Asset Bundler http://cfwheels.org/plugins/listing/4 Regards, Adam From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of Steve Onnis Sent: Tuesday, 8 November 2011 4:49 PM To: cfaussie@googlegroups.com Subject: [cfaussie] CSS packager Anyone know of a CSS/JavaScript packager i could use in ColdFusion for minifying CSS/JavaScript files? -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.commailto:cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.commailto: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] cfloop inside a cfif tag
How about this.. cfloop index=i from=1 to=#total_applicants# cfif session[applicant#i#_firstname] eq '' or session[applicant#i#_familyname] eq '' or form.loan_amount eq '' mandatory fields are missing /cfif /cfloop From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of rai...@ozemail.com.au Sent: Friday, 10 June 2011 10:08 AM To: cfaussie@googlegroups.com Subject: [cfaussie] cfloop inside a cfif tag Hi I am building an online application form and the last page testes for which fields across the multi pages of the application form As the application form allows for multiple applicants some of the mandatory fields only need to be checked dependant on whether there are more than one applicant entered into the form Each page of the application form captures the data entered and saves the data into session variables to allow for the values entered across the application form to remain present as the applicant moves through the various pages of the application form . If there is a second applicant loaded then session variables relating to the seconds applicants data are defined eg session.applicant2_firstname, session.applicant2_familyname One the last page I test form mandatory fields with code similar to cfif cfloop index=-i from 1 to #total_applicants# session.applicant#i#_firstname eq '' or session.applicant#i#_familyname eq ''/cfloop or #loan_amount# eq '' mandatory fields are missing /cfif I need to be abel to perform a cfloop within the cfif statement so that the mandatory fields relating to the 2nd. 3rd or 4th applicants are only tested for when the value for total_applicants is 2,3 or 4 I trust the above makes sense I look forward to your suggestion to achieve the above -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.commailto:cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.commailto: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 : SQL TEXT type column
Hi Steve, Depending on your database, the TEXT datatype column can handle LARGE amounts of data. You might want to check how much data your datasource can handle.. check out the Advanced Settings in your datasource in cfadmin. Regards, Adam From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf Of Steve Onnis Sent: Friday, 15 October 2010 3:36 PM To: cfaussie@googlegroups.com Subject: [cfaussie] OT : SQL TEXT type column How much can this column actually hold? How would it translate to say a text file in size? I am trying to work out if a heap of data should be able to fit into the column or not === Email scanned by PC Tools - No viruses or spyware found. (Email Guard: 7.0.0.21, Virus/Spyware Database: 6.16090) http://www.pctools.comhttp://www.pctools.com/?cclick=EmailFooterClean_51 === -- 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. -- 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] OT : SQL TEXT type column
2,147,483,647 characters in MSSQL 2009. Your insert/update queries will error if the length exceeds that specified in cfadmin... you could try increasing if to MSSQL maximum.. I have not tried that! http://msdn.microsoft.com/en-us/library/ms187993.aspx See the note regarding deprecation of the text datatype. Important ntext, text, and image data types will be removed in a future version of MicrosoftSQL Server. Avoid using these data types in new development work, and plan to modify applications that currently use them. Use nvarchar(max), varchar(max), and varbinary(max) instead. Regards, Adam From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf Of Steve Onnis Sent: Friday, 15 October 2010 3:47 PM To: cfaussie@googlegroups.com Subject: RE: [cfaussie] OT : SQL TEXT type column It has Long Text Buffer (chr) : 64000 Does that means it will truncate at that? What if i don't want to restrict it at all? From: Adam chapman [mailto:a...@portplus.com] Sent: Friday, 15 October 2010 3:42 PM To: cfaussie@googlegroups.com Subject: RE: [cfaussie] OT : SQL TEXT type column Hi Steve, Depending on your database, the TEXT datatype column can handle LARGE amounts of data. You might want to check how much data your datasource can handle.. check out the Advanced Settings in your datasource in cfadmin. Regards, Adam From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf Of Steve Onnis Sent: Friday, 15 October 2010 3:36 PM To: cfaussie@googlegroups.com Subject: [cfaussie] OT : SQL TEXT type column How much can this column actually hold? How would it translate to say a text file in size? I am trying to work out if a heap of data should be able to fit into the column or not === Email scanned by PC Tools - No viruses or spyware found. (Email Guard: 7.0.0.21, Virus/Spyware Database: 6.16090) http://www.pctools.comhttp://www.pctools.com/?cclick=EmailFooterClean_51 === -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.commailto:cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.commailto: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.commailto:cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.commailto:cfaussie+unsubscr...@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.16090) http://www.pctools.comhttp://www.pctools.com/?cclick=EmailFooterClean_51 === === Email scanned by PC Tools - No viruses or spyware found. (Email Guard: 7.0.0.21, Virus/Spyware Database: 6.16090) http://www.pctools.comhttp://www.pctools.com/?cclick=EmailFooterClean_51 === -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.commailto:cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.commailto: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 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.
[cfaussie] Re: Weird Problem Element is Undefined problem
Hey Chong, Also consider using the duplicate() function when copying your structure.. From what I understand, structCopy() may not create a deep copy of your structure, But rather a pointer to the original. So if you modify the original, it can sometimes cause some changes (desired or otherwise) in the copy. Regards, Adam -Original Message- From: KC Kuok [mailto:kck...@gmail.com] Sent: Wednesday, 25 November 2009 9:44 PM To: cfaussie Subject: [cfaussie] Re: Weird Problem Element is Undefined problem Hi guys, just finished reading the replies... I think the scope is probably the best shot, I will give that a go first thing in the morning... I am leaning towards a scope issue, probably caused by a extended cfc having the identically named variable, i should really have checked for that first... though it will be weird because I call another value from the same struct a few lines before that with no dramas at all... I will update you guys on what is the issue, once I find it. Cheers, Chong On Nov 25, 9:33 pm, Gavin Baumanis b...@palcare.com.au wrote: I'm just shooting from the hip... Any chance this is an issue with nested loops? There is buggish behaviour around nested loops / queries. I was so stumped (with my issue) I sent an email off to ben nadel and his Ask Ben column for help; The link is;http://www.bennadel.com/blog/546-Referring-To-The-Proper-Row-Of-The-O... Just in case it turns out to be the same issue for you. Gavin. On 25/11/2009, at 16:37 , KC Kuok wrote: When I try to get key value from a structure I get an error however if I do a dump function, I can see the struct AND the variable which is referred to similarly. E.g. ... ThisValue = STRUCTVARIABLE.THISFOREIGNKEY; ... I get Element THISFOREIGNKEY is undefined in STRUCTVARIABLE However If I do a dump function, dodump(STRUCTVARIABLE) or even dodump (STRUCTVARIABLE.THISFOREIGNKEY ) just before that line I can see the entire structure or just the value respectively. I can't see what is wrong, could this be a cfscript related bug ? Or am I missing something real obvious ? One of the things I thought maybe wrong is the scope, but even then it does not seem that anything is wrong with it... Dodump() is just a regular cffunction which passes the args to cfdump inside. Any thoughts? Thanks in advance! Chong -- 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 athttp://groups.google.com/group/cfaussie?hl=en. As always, please contact me if I can be of any further assistance. Gavin Beau Baumanis Senior Application Developer PalCare P/L 657 Nicholson Street Carlton North Victoria, Australia, 3054 E: b...@palcare.com.au P: +61 -3 9380 3513 M: +61 -438 545 586 W:http://www.palcare.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. 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 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.
[cfaussie] Re: CFReport Builder issue - again!
Hi Gavin, You could try this: cfreport template=print_CAR.cfr format=pdf cfloop collection=#myStruct# item=i cfreportparam name=#i# value=#myStruct[i]# / /cfloop /cfreport Then reference each param individually.. #params.myKey# Hope this helps.. Regards, Adam -Original Message- From: Gavin Baumanis [mailto:beauecli...@gmail.com] Sent: Thursday, 9 July 2009 1:53 PM To: cfaussie Subject: [cfaussie] CFReport Builder issue - again! Hi Everyone, I am back to trying to fix my reporting issues and have been working on it for the past three hours - and I have finally thrown the towell in! I am creating a structure, that stores the results of several queries. if I dump the structure, (from the page that contains the cfreport tag) I get an appropriate dump of a struct with the expected key- value pairs. I then use the struct as a reportparam. cfreport template=print_CAR.cfr format=pdf cfreportparam name=reportParamStruct value=#reportParamStruct# /cfreport But I get the following error when I try and run this page; Error evaluating expression : Source text : param.reportParamStruct.problemdescription I have tried with and without pound signs, I have also included a print when condition that checks for the structure and its key exisiting and that the key isn't an empty string. seemingly no matter what I try - I still get the above error. If anyone has any ideas at all - I would be most grateful. --~--~-~--~~~---~--~~ 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: Validating dates ... what's the trick?
I second Brett's method.. I do the same thang myself. Regards, Adam -Original Message- From: Brett Payne-Rhodes [mailto:bret...@gmail.com] Sent: Friday, February 20, 2009 3:17 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Validating dates ... what's the trick? I could never get a reliable result from the various 'parsedate' functions... In the end I wrote my own function to create dates from strings. It looks for a variety of delimiters then extracts day, month, year; or month, year, day; or even year, month, day; depending on how it was set up. The trick at the end is to use createDate(year, month, day) wrapped up in a try/catch. If it throws an error then you have a problem. hth Brett B) Mike Kear wrote: I'm trying to catch when a user inputs an invalid date from a set of dropdowns for day/month/year. What's the trick to using IsValid(eurodate, ? This doesnt work if the user enters 31/2/2009: cfif not (IsValid(eurodate, createdate(form.ShipYear,form.ShipMonth,form.ShipDay) )) Stuff /cfif If i feed this line the 'date' 31/2/2009 it doesnt do the stuff inside the cfif, it throws an error with the helpful error message 'MONTH'. I guess its because inside the IsValid() function, it's trying to create the date first, and never getting to run the isvalid() function. But if the IsValid() function will only work when it's given a valid date, what is the point of it? -- Brett Payne-Rhodes Eaglehawk Computing t: +61 (0)8 9371-0471 m: +61 (0)414 371 047 e: br...@ehc.net.au w: http://www.yoursite.net.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 cfaussie+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Validating dates ... what's the trick?
Hi Mike, I used to use the 3 dropdowns method.. (now using jquery datepicker) but used mmm for the month value. Then validate something like this isDate(#day#-#month#-#year#) which evaluates to isDate(31-Feb-2009) There was no confusion between day and month this way.. Regards, Adam -Original Message- From: Mike Kear [mailto:afpwebwo...@gmail.com] Sent: Friday, February 20, 2009 3:56 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Validating dates ... what's the trick? The problem is i'm building the date from 3 dropdowns for day, month and year, so the day dropdown has 1-31 on it. Therefore it's possible to select 31/Feb/2009. Then if you try to validate the date from the form, by feeding those three values into the LSIsDate() function, or the IsValid(Date) or any other date function, first of all you have to give those functions a date object. To do that you use createdate() which chunders if you give it 31/Feb/2009So therefore the function LSIHisDate can never be tested on an invalid date (which is its main purpose for living after all) . This same point applies to IsDate() and IsValid(eurodate, ... and IsValid(date, ... ) because they take a date object as an argument, and you can't create an invalid date object. Unless i'm missing something here, it seems that these date validation functions have no use. The way you check validity of dates is to either design the form so people can't enter invalid dates (e.g. using a date picker) and/or using try/catch around the createdate() function. 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 Fri, Feb 20, 2009 at 3:46 PM, Chris Velevitch chris.velevi...@gmail.com wrote: Did you try the LSIsDate function? Chris -- Chris Velevitch Manager - Adobe Platform Users Group, Sydney m: 0415 469 095 www.apugs.org.au Adobe Platform Users Group, Sydney Feb '09 meeting: Hands On Cairngorm Basics Date: Mon 23rd Feb 6pm for 6:30 start Details and RSVP on http://groups.adobe.com/posts/d094878396 -- --~--~-~--~~~---~--~~ 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: Building a web service - can you pass in XML or should the arguments be data typed
Hi Matthew, I second Steve on the point below.. I have pulled out many a hair trying to get complex datatypes to send/parse correctly between different platforms. They work nicely between CF and CF, but try with CF and .NET and the 'fun' begins. Regards, Adam -Original Message- From: Steve Onnis [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 11, 2008 2:07 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Building a web service - can you pass in XML or should the arguments be data typed All CF datatypes are converted to SOAP equivalents So it says but i have seen time and time again issues with the soap conversion and datatyping issues, especially with .NET Using XML you know exactly what you are getting. Thats my reason. -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Matthew Sent: Tuesday, 11 November 2008 2:04 PM To: cfaussie Subject: [cfaussie] Re: Building a web service - can you pass in XML or should the arguments be data typed @Steve, thanks again for replying. CF can handle complex data types no problem. All CF datatypes are converted to SOAP equivalents (http:// livedocs.adobe.com/coldfusion/7/htmldocs/1547.htm#1186403). As per my latest post it just seems crazy to have to write an additional XML parser to deciffer the XML submitted by the client (you'd need a whole lot of validation logic as well). Same goes for sending the data back - why not just let CF covert the objects into their equivalent SOAP datatypes. I can't see any benefit for receiving XML packets and returning XML packets!?!?!? Can anyone comment on reasons to do this? Cheers Matthew On Nov 11, 1:55 pm, Steve Onnis [EMAIL PROTECTED] wrote: Mathews Its either/or. I preferred the XML way so that's the way it was built. I guess what I was trying to say in my last email is there isn't a right/wrong way, just what ever fits better with what you are trying to do. Its easier to search xml than it is to try and parse arguments if some arguments are not required to be passed in. Also I don't know if you will have issues with things like passing in arrays and stuff into the web service because of the data types possibly not being maintained in the request. This is where XML is better as you don't need to worry about it and you can handle it all in your web service. Steve -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Matthew Sent: Tuesday, 11 November 2008 1:41 PM To: cfaussie Subject: [cfaussie] Re: Building a web service - can you pass in XML or should the arguments be data typed @Steve, Thanks for the response but I don't think you've understood me correctly. I'll try to explain myself again. Perhaps there is a CF web service guru out there that can help? When building a web service, should the input arguments be a single XML document (which defines the input parameters) or should you just have an argument for each parameter. Or are both options acceptable? It makes more sense to me to have a argument for each parameter otherwise if you have an XML doc as the input you have to write your own XML parser / validator. This is all built right into CF when you choose access=remote. I've been doing a little more reading and noted that you can distribute your web service as an RPC (default in CF) or as document- literal style. I think the RPC system is the way I've been discussing and the document-literal style option is the alternative where you pass in a full XML document. Is RPC easier but compatible with fewer technologies? Cheers Matthew --~--~-~--~~~---~--~~ 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: Filtering out folders.
Hi Joris, cfdirectory CAN filter multiple types.. Filter=*.html|*.xml|*.txt Alternatively (and less efficiently) you could use QoQ to exclude the types you don't want. Regards, Adam -Original Message- From: Joris de Beer [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 23, 2008 2:43 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Filtering out folders. Hi Chris, The filter attribute only filters in matching files, e.g. This will only list jpegs in a folder. cfdirectory action=list directory=#expandPath(Banners)# name=BannerFolders recurse=yes type=dir listinfo=name filter=*.jpg / Also, filter only allows one inclusion, but I need to exclude all sorts of stuff like .svn, .dsStore, thumbs.db Regards, Joris On 20/09/2008, at 3:42 PM, Chris Velevitch wrote: Use the filter attribute on the cfdirectory. Chris -- Chris Velevitch Manager - Adobe Platform Users Group, Sydney m: 0415 469 095 www.apugs.org.au Adobe Platform Users Group, Sydney September meeting: It's Going To Be Brilliant Date: Mon 29th September 6pm for 6:30 start Details and RSVP on http://apugs2008september.eventbrite.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] CfJob -Melbourne
Hello Everyone, I know this isn't technically the place for these, but since we are all (mostly) friends, I hope y'all don't mind me posting this here.. We are looking for a junior to intermediate level CF developer to join our team. 2+ Years CF Experience is desired, with skills in most or all of the following: CFMX 7+ HTML Javascript CSS XML SQL Server 2005 SOAP Contact: [EMAIL PROTECTED] Regards, Adam Chapman Portplus www.portplus.com T: 03 9800 --~--~-~--~~~---~--~~ 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: CfJob -Melbourne
Looking for a permanent addition to the dev team.. Cheers Adam -Original Message- From: Steve Onnis [mailto:[EMAIL PROTECTED] Sent: Monday, 23 June 2008 2:41 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: CfJob -Melbourne Full time for casual/contract ? -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Adam Chapman Sent: Monday, 23 June 2008 2:43 PM To: cfaussie@googlegroups.com Subject: [cfaussie] CfJob -Melbourne Hello Everyone, I know this isn't technically the place for these, but since we are all (mostly) friends, I hope y'all don't mind me posting this here.. We are looking for a junior to intermediate level CF developer to join our team. 2+ Years CF Experience is desired, with skills in most or all of the following: CFMX 7+ HTML Javascript CSS XML SQL Server 2005 SOAP Contact: [EMAIL PROTECTED] Regards, Adam Chapman Portplus www.portplus.com T: 03 9800 --~--~-~--~~~---~--~~ 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] Coldspring Best Practice
Hi All, I have started implementing Coldspring into an app I'm working on and I was after some opinions on the best way to call the beans. This is a fusebox 5.5 (noXml) implementation. My main aim is to avoid lots of 'unnecessary' code but keeping performance at a maximum. I think I have 2 primary options.. (Pros cons as I see them..) 1. Set all coldspring beans into local variable scope on every request in application.cfc !--- application.cfc --- cfset thisService = application.beanFactory.getBean(thisService) / cfset thatService = application.beanFactory.getBean(thatService) / ... 20+ beans Pros: Ease of maintenance, results in shorter syntax Cons: Possible performance hit 2. Set only the beans needed for the request in the controller and also make it available to the view templates !--- controller --- cfset var thisService = application.beanFactory.getBean(thisService) / cfset var thatService = application.beanFactory.getBean(thatService) / cfset event.setValue(myQuery,thisService.myMethod()) / cfset event.setValue(thatService,thatService)) / !--- view --- cfset myQuery = event.getValue(myQuery) / cfloop query=myQuery #thatService.formatMe(myQuery.column)# /cfloop Pros: All beans not copied to local variables scope every request Cons: More code to do the same job as scenario 1 Any comments appreciated. Regards, 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] CFC Design Patterns
Hi All, I am looking at re-vamping the way I build cfcs and want to move to a more OO approach.. I have recently started using coldspring and am after pplz thoughts on their favoured design pattern and how best to organise cfcs.. Any feedback or links appreciated.. Regards, Adam Chapman Portplus www.portplus.com T: 03 9800 --~--~-~--~~~---~--~~ 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] Fusebox 5.5 vs Colddbox
Hi All, Just after any comments on anyone's experience with coldbox and particularly how it compares to fusebox 5.5 (With MVC design pattern). From what I have found, I can only find positive comments about coldbox. A couple of things that I find work against FB5: - Long fusebox.load times - Having to reload an application when new fuseactions are added to a circuit - The occasional 'corrupt' parsed file.. I'm not sure if FB5.5 has addressed any of these issues. Regards, Adam Chapman --~--~-~--~~~---~--~~ 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: queryAddRow
Hi Andrew, The null rows are simply visual placeholders where pages will be put.. but this is a subject for another thread. Regards, Adam -Original Message- From: Andrew Scott [mailto:[EMAIL PROTECTED] Sent: Thursday, 15 May 2008 4:00 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: queryAddRow Adam, And how do those 12 pages get handled in JS if the data is NULL for 12 rows? Sorry but that is not a good example. Andrew Scott Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 9015 8628 Mobile: 0404 998 273 -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Adam Chapman Sent: Thursday, 15 May 2008 3:09 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: queryAddRow Hi Andrew, until someone shows me a good enough reason too (sic) How about wanting 15 rows in the query regardless of whether they are blank or not.. I have a dynamic book building application in which a book is limited to 15 pages.. I already have the front cover, inside sleeve and back cover set in stone.. but the remaining 12 pages (rows in the query) are yet to be defined. I want a dropdown box containing 12 blank rows so the user can pick/pack and sort those 12 inside pages via javascript. This app is currently in production. Regards, Adam PS. Nice function 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: queryAddRow
Hi Andrew, until someone shows me a good enough reason too (sic) How about wanting 15 rows in the query regardless of whether they are blank or not.. I have a dynamic book building application in which a book is limited to 15 pages.. I already have the front cover, inside sleeve and back cover set in stone.. but the remaining 12 pages (rows in the query) are yet to be defined. I want a dropdown box containing 12 blank rows so the user can pick/pack and sort those 12 inside pages via javascript. This app is currently in production. Regards, Adam PS. Nice function Steve. -Original Message- From: Andrew Scott [mailto:[EMAIL PROTECTED] Sent: Thursday, 15 May 2008 1:50 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: queryAddRow Brett, That's because 'I' was curious as to why he didn't use ArrayAppend. There was nothing wrong with my original question. Steve eventually answered it, and no 'I' still don't see the reason one would do it that way? But I have that right, until someone shows me a good enough reason too. Nothing wrong with that. Andrew Scott Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 9015 8628 Mobile: 0404 998 273 -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Brett Payne-Rhodes Sent: Thursday, 15 May 2008 1:13 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: queryAddRow Sorry Andrew but often your 'curiosity' comes across as purely judgemental and somewhat condescending. As in *I* don't understand why you did it that way or why anyone would ever want to do that anyway, so you should do this instead and if you don't agree I'm going to keep at you until you do. From my reading of this thread Steve answered your question at least twice, *and* put the answer in his comments. Comments!!! Perhaps you just need to rephrase the way you project your curiosity. All I know is that I get tired of you continually badgering people and tend to stop reading threads that I might actually learn something from. Brett 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?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: wierd caching problem
Hi Barry, I had a similar issue a few weeks ago (CFMX7).. I had to turn 'save class files' off, run the template, then turn it back on. It happened around the time of daylight savings change where the cf time and OS time were different.. Hope this helps. Adam -Original Message- From: barry.b [mailto:[EMAIL PROTECTED] Sent: Tuesday, 29 April 2008 9:12 AM To: cfaussie Subject: [cfaussie] wierd caching problem this has got me beat. I'm throwing files against a shared dev server, getting the occasional oops and trying to correct it. These are just simple test harnesses, hardly anything in them. what's happening is that I'm still getting the error message even after I fix the oops. something is still hanging on to the old code and throwing the error BUT the error stack trace is showing the correct (new/repaired) code. While trusted cache is turned off, I'm having to go into the CF admin and manually clear the template cache now just to see the changes. It's like trusted cache is still on, even though it's turned off. eg: Variable QRYGETCUSALL is undefined. The error occurred in X:\xxx_xxx\_scratch\idr\cloneforms.cfm: line 12 10 : 11 : 12 : cfdump var=#qryGetCusAllx# label=qryGetCusAll / that error message is old because I renamed the query but forgot to change the name in the dump the first time around. The stack trace is from the second run of the code that should not throw an error [1]. any suggestions what might be causing this, and suggest a fix? [1] CFQUERY NAME=qryGetCusAllx DATASOURCE=idr SELECT * FROMTidrT_Customer WHERE fk_DisputeID = cfqueryparam cfsqltype=cf_sql_integer value=118972 / ORDER BYDateCreated /CFQUERY cfdump var=#qryGetCusAllx# label=qryGetCusAll / --~--~-~--~~~---~--~~ 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: Problem with double quotes and SQLServer
Hi Mike, I have found in the past a value such as 42 wheels is _inserted_ into the database without any problem. However, when the update form is used with the same value the html is rendered as: input type=text name=myField value=42 wheels / Notice that the value attribute is prematurely ended.. but seems to still render in the browser. The solution was to use the #htmlEditFormat()# function on the value attribute of your form field eg: input type=text name=myField value=#htmlEditFormat(myField)# / Hope this helps. Cheers, Adam -Original Message- From: Mike Kear [mailto:[EMAIL PROTECTED] Sent: Monday, 7 January 2008 3:39 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Problem with double quotes and SQLServer Well when i add a description like 42 wheels myself on the production server, it stores in the database just fine. But when the client does it, it doesn't. So there's something different about what the client's doing. The client's not what you'd call computer savvy, and isn't cutting and pasting from a word document so I dont think the problem is they're using the MS Word smart quotes (66/99) and I'm not. That's why I assumed the problem must be that they're using Vista (their computer is brand new) and it's putting a different character in the field for the double quote character. But i'm open to any suggestions. It's very frustrating trying to fix a problem when i can't reproduce it myself. 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 1/7/08, Andrew Scott [EMAIL PROTECTED] wrote: Are there any other differences with the server? Or maybe the browser? The OS should not make a difference... Andrew Scott Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone:+613 9015 8628 Mobile: 0404 998 273 --~--~-~--~~~---~--~~ 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: Using CFEXECUTE to run a batch file
Hi Peter, I use cfexecute like this: cfexecute name=#batPath# outputfile=#outputFilePath# arguments= timeout=10 / Regards, Adam -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, 21 December 2007 1:01 AM To: cfaussie Subject: [cfaussie] Using CFEXECUTE to run a batch file I have a batch file d:\test.bat which I would like to execute to run on the server. My command is as follows cfexecute name=d:\test.bat timeout=10 /cfexecute This will echo the contents of the file test.bat to the screen rather than execute the file. Am I missing something simple --~--~-~--~~~---~--~~ 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: regex - replacing a string outside of 'tags'
Hi Glen, Just what I was after, nice work. Thanks to all who put thought into it. Regards, Adam -Original Message- From: nkosi [mailto:[EMAIL PROTECTED] Sent: Thursday, 6 December 2007 6:05 PM To: cfaussie Subject: [cfaussie] Re: regex - replacing a string outside of 'tags' Oops, was meant to include the output ... Look a spanner ... I am throwing the span style=color:red;spanner/ span in the works. Anyone seen my spanner? Becomes ... Look a bspan/bner ... I am throwing the span style=color:red;bspan/bner/span in the works. Anyone seen my bspan/bner? I must admit - my regex is pretty poor, I always have to refer to Mr. Forta's Teach yourself Regular Expressions in 10 minutes - ironic that I have probably spent well over 10 minutes referring to this book :| --~--~-~--~~~---~--~~ 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] regex - replacing a string outside of 'tags'
Hi All, Wondering if regex wizards out there can help me with this.. I want to replace a substring within a string, but ONLY if its is not a name/attribute of a html tag. (Between a matching pair of ) Below is some code to illustrate the problem.. cfset myString = 'I am throwing a span style=color:red;spanner/span in the works' / cfoutput#myString#br //cfoutput cfset myString = replaceNoCase(myString,span,bspan/b,all) / cfoutput#myString#br //cfoutput This is for highlighting multiple search strings in search results. Thanks in advance for helping the regex impaired. Regards, 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: Role call: CFCAMP Melbourne
Hey.. Myself and one of my workmates will be there.. _ From: MrBuzzy [mailto:[EMAIL PROTECTED] Sent: Wednesday, 21 November 2007 1:24 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Role call: CFCAMP Melbourne Hi y'all, I've seen this work on other mailing lists. Who's coming tomorrow? See you there ;) Cheers. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: ColdFusion sessions playing up? showing info that belongs to others? ....
Hi Taco, I had this happen years ago, the cause was that the two users were using the same isp that was heavily caching content.. the solution back then was to ensure that every url was unique.. and/or pass session token in the url. Cheers, Adam _ From: Taco Fleur [mailto:[EMAIL PROTECTED] Sent: Thursday, 30 August 2007 9:48 AM To: cfaussie@googlegroups.com Subject: [cfaussie] ColdFusion sessions playing up? showing info that belongs to others? Hello all, I was wondering if someone has seen this before. One of our applications is apparently displaying info that belongs to someone else. I.e. they sign in, see the right info, go to another page and see the sign in details of someone else. Now, the only way I can see this happening is if ColdFusion is playing up and getting the session info mixed up. Two users say they saw information belonging to another user when moving from one page to another. I just find it impossible when I look at the code! There is a User CFC, it contains the screen name and user id, but it is only populated if the user signs in. Therefore it can only be that Coldfusion is playing up. Anyone seen this before, know issue? Thanks in advance. -- *** http://www.clickfind.com.au The new Australian search engine for businesses, products and services *** http://brisbane-web-design.pacificfox.com.au blog *** Virtual and Dedicated Servers with MS SQL from $250 a month *** Virtual and Dedicated Servers with registered version of ColdFusion from $350 a month *** ColdFusion licenses at the lowest price --~--~-~--~~~---~--~~ 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: CFCAMP Australia Is GO
CFCAMP.. Sounds like a new tag to make your requests slightly more gay? -Original Message- From: Geoff Bowers [mailto:[EMAIL PROTECTED] Sent: Monday, 13 August 2007 8:39 PM To: cfaussie Subject: [cfaussie] CFCAMP Australia Is GO Quick heads up for CFAUSSIE... more official marketing to follow. CFCAMP Australia is a free, mini-conference for coldfusion developers by coldfusion developers. We're celebrating the release of Coldfusion 8 -- and there is a lot to celebrate. Help us build the agenda for your city: http://cfcamp.pbwiki.com/ Suggest your own sessions, petition existing sessions, help organise! Brisbane on the 11th of September at the Rydges Canberra on the 12th of September at the UCU Conference Centre Sydney on the 13th of September at the Wesley Centre Enjoy! -- geoff http://www.daemon.com.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?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: CF Query Question
Howdy, select loanno, LoanProgram, BorrowerName, LoanFacility, BorRate, InvstLoanRate, SettlementDate, FeeFreeRate, OtherFeeRate, PenaltyRate, BorRate-InvstLoanRate as lender_margin from trails order by lender_margin (SQL Server) Cheers, Adam From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, 22 June 2007 12:22 PM To: cfaussie@googlegroups.com Subject: [cfaussie] CF Query Question Hi, have the following query select loanno, LoanProgram, BorrowerName, LoanFacility, BorRate, InvstLoanRate, SettlementDate, FeeFreeRate, OtherFeeRate, PenaltyRate, BorRate-InvstLoanRate as lender_margin from trails I am wondering is there is a way that i can sort the output based on the value of lender_margin given its value is created from two other columns in the table, whilst lender_margin is not a physical column in the table Regards Claude --~--~-~--~~~---~--~~ 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: cfqueryparam cfsqltype=cf_sql_timestampproblem
Hi Scott,
Here are a couple of possible workarounds if you don't find what your'e
after.
WHERE year(sb_accom_start_date) = #datePart(,myDate)#
AND month(sb_accom_start_date) = #datePart(m,myDate)#
AND day(sb_accom_start_date) = #datePart(d,myDate)#
WHERE sb_accom_start_date
BETWEEN #CreateODBCDate('01/jan/2007 00:00:00')#
AND #CreateODBCDate('02/jan/2007 00:00:00')#
Cheers,
Adam
PS: (mssql)
Scott Thornton wrote:
Hi,
I had a bit of an unexpected problem whilst using the above today.
Problem is my time looks like '01/jan/2007 23:02' but I want to only
use the date portion.
So in a query I use:
cfquery datasource=#dsn#
select
*
from
sb_hospital
where
sb_accom_start_date #CreateODBCDate('01/jan/2007
23:02')#
/cfquery
which when runs, the date looks like '01/jan/2007' to the query.
However
cfquery datasource=#dsn#
select
*
from
sb_hospital
where
sb_accom_start_date cfqueryparam
cfsqltype=cf_sql_timestamp value=#CreateODBCDate('01/jan/2007
23:02')#
/cfquery
passes the full date with the time on it.
Seems a bit strange to me. Not what I was expecting at all.
CF MX 6.1.
--~--~-~--~~~---~--~~
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
present -Original Message- From: Matt Voerman [mailto:[EMAIL PROTECTED] Sent: Friday, 1 June 2007 12:02 PM To: cfaussie Subject: [cfaussie] CFAussie Community Head Count 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 --~--~-~--~~~---~--~~ 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] cfc - cfargument best practice
Hi All, I have the need to create a cfc method which will update a large number of db fields.. (50+). Here are 2 options I'm considering: 1. Accept an argument for each field 2. Accept a single argument containing a structure with all the data required for each field Thoughts? 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: cfc - cfargument best practice
Hi Dale, Thanks for the reply.. I think I must have been a bit vague with my question, I already have the cfc set up using the DOA/Gateway model.. I guess I'm asking which of the 2 options for accepting a large amount of data is prettier.. or whether there are pros and cons of either which will make one more attractive than the other. Cheers, Adam -Original Message- From: Dale Fraser [mailto:[EMAIL PROTECTED] Sent: Tuesday, 29 May 2007 11:01 AM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: cfc - cfargument best practice I think it depends on the cfc and it's purpose. You could write one generic class, lets say called Database.cfc Which could have methods such as select, update, insert etc. Then they could take paramaters such as you described in 2. This class is then generic and can be smart enough to update any table. If however you have a class called say Product.cfc And it deals only with products and it has an update method, then I would suggest option 1, as then the method constrains the required fields and can have intelligence. If you are really keen you could have Product.cfc extend Database.cfc Regards Dale Fraser http://dalefraser.blogspot.com -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Adam Chapman Sent: Tuesday, 29 May 2007 10:54 AM To: cfaussie@googlegroups.com Subject: [cfaussie] cfc - cfargument best practice Hi All, I have the need to create a cfc method which will update a large number of db fields.. (50+). Here are 2 options I'm considering: 1. Accept an argument for each field 2. Accept a single argument containing a structure with all the data required for each field Thoughts? 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: cffunction access=Package
Hi Dale, I use it with the DAO/Gateway model.. mProduct (dir) productManager.cfc productDAO.cfc productGateway.cfc Only the productManager cfc is called by the application code.. the manager calls the relevant DAO/Gateway cfc depending on the function.. in this scenario all the productManager methods Are public and all other cfc methods are package. A DOA/Gateway should (can) never be called Directly, cfc calls always go thru a 'manager'. Hope this helps. Cheers, Adam From: Dale Fraser [mailto:[EMAIL PROTECTED] Sent: Tuesday, 29 May 2007 12:20 PM To: cfaussie@googlegroups.com Subject: [cfaussie] cffunction access=Package Anyone explain what this is and when you would us it? 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: + Important: Repent, Completely trust in God only and, Love Him with all of your heart.
Hi.. I think I can help.. but I have not tested this code cfset god = structNew() / cfset god.earth = createObject(Component, universe.earth).init() / cfset trinity = arrayNew() / cfset trinity[1] = father / cfset trinity[2] = son / cfset trinity[3] = spirit / cfset Atheism = false / cfset Evolution = false / cfif not Repent cflocation url=hell.cfm / cfelseif not trustInGod cflocation url=hell.cfm / cfelseif not loveLord cflocation url=hell.cfm / !--- add more conditions here.. this is likely to grow large.. please load-test --- /cfif -Original Message- From: Secret [mailto:[EMAIL PROTECTED] Sent: Tuesday, 15 May 2007 9:41 AM To: cfaussie Subject: [cfaussie] + Important: Repent, Completely trust in God only and, Love Him with all of your heart. There is a section below with the title Atheism and Evolution are WRONG. All those who have sinned deserve to suffer in Hell forever. Pride is an example of a terrible sin. 1. Repent (be truly sorry for your sins; beg for God's forgiveness; abandon sin; ask Him to help you stop sinning; and repent for His sake). 2. Completely trust in God only; do not trust in yourself. 3. Love the Lord with all of your heart. The Son of God (the Lord Jesus Christ) suffered and died on the cross to pay for the sins of those who trust in Him. His blood can clean away our sins. He was buried for three days, then lived again. There is hope of eternal life and happiness for those who trust in God. Your efforts and works cannot save you. Only God is truly righteous and good. Humans are totally corrupt, but thankfully God controls all things. Thank the Lord if He has saved you, and if His Spirit has given you the ability to trust in Him. - Atheism and Evolution are wrong: An atheist is a person who does not believe in God. God is the Intelligent Creator of the Universe. If you refuse to trust in God, it's not my loss. 1. Energy/matter cannot be created nor destroyed through natural methods. 2. The Universe cannot create itself. If it created itself, then anything can create itself; and the Universe can have a Mind of its own. 3. Fine-tuning of the Universe. 4. Laws of physics do not order themselves. They have no goals. 5. No oscillating universe; no multiverse. 6. Universe moving towards entropy (or heat death). 7. Planets do not form through natural methods. 8. Gases scatter/dissipate quickly. Therefore, Jupiter have been created. 9. Saturn has three rings. They have been set in place. 10. A Theory: the Earth is near the center of the Universe. This idea supports the Bible. 11. The Earth is not millions of years old. Notes: Magnetic field decay; Archaeology; History, other Time limiters. Note: Ancient people were as smart as modern men. Evolutionists have no excuse. 12. Misplaced fossils; Wrong sequence of geological strata/layers; Polystrata fossils are enemies of Uniformitarianism and Evolution. 13. Decay rates are not constant. Note: Even the speed of light is not constant. Radiometric methods are unreliable. Example of a flaw: A radiometric method showed that primate skull KNM-ER 1470 was 212-230 million years old. Even evolutionists rejected it. 14. NATURAL life can only come from life. Abiogenesis (or spontaneous generation) is impossible. 15. The DNA double-helix, self-repair codes, self-checking system/ algorithms, structure, DNA language convention, irreducible cell complexity, and chromosome count are enemies of evolution. 16. DNA of humans differ/vary by about 10-12% from each other. 50% of human DNA is identical to the DNA of a banana. Humans and apes have no common ancestor. 17. Common sense and science reveal the fact of Intelligent Design. There are cells which are more complex than New York City or modern space shuttles. 18. There is no real vestigial/useless organ. There is no junk DNA. Note: Males' nipples arouse women. 19. Mutations are harmful, deadly, and destructive to genetic codes. Example: Cancer. 20. Natural selection and Sexual selection do not eliminate destructive genetic codes. 21. The fossil record and the Cambrian Explosion are enemies of evolution. There were NO mice-bats with one wing or two wings each having 25% bone structure. There were NO walking fishes. 22. The Lord gave humans a conscience, morals, and advanced intelligence. 23. Strong evidence of a Global Flood in the past. This fact supports the Bible. Geologic layers were formed quickly and catastrophically. Note: Hydro-plate theory. 24. No historical record gives clues about evolution. 25. Scientists can use false or biased data. Examples: Piltdown man deception, Lucy mistake, Archaeopteryx mistake. 26. Evolution is science fiction (a myth). It is similar to the story of the Centaurs (horse-men) and Mermaids (fish-women). I don't believe in Centaurs and Mermaids. 27. Philosophers love wisdom. But, only God is truly wise. Atheists are not philosophers. They are not free-thinkers. 28. Science is closely related to
[cfaussie] Re: Hack ColdFusion Application
But you're right there is more than one of me... *shudder* ;) From: Andrew Scott [mailto:[EMAIL PROTECTED] Sent: Friday, 11 May 2007 12:25 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Hack ColdFusion Application On 5/11/07, Taco Fleur [EMAIL PROTECTED] wrote: Hi Adam, 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 Hmm, not sure why I was singled out... But you're right there is more than one of me... I began my career in programming computer games in 1988, and I worked with my name sake. And on top of that I was also a registered Commodore Amiga developer, and the guy I reported too was also my name sake. -- Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 --~--~-~--~~~---~--~~ 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
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
Taco Fleur wrote:
OK, I'm now offering $100 per hack/crack found.. Anyone interested
please email me directly.
On 5/2/07, *Taco Fleur* [EMAIL PROTECTED]
mailto:[EMAIL PROTECTED] wrote:
I'm looking for someone interested to try and crack/hack one of
our
applications that is going to launch soon.www.sellmystuff.com.au
http://www.sellmystuff.com.au/
(not the pages there now).
Happy to pay $50 per hack/crack discovered (maximum $250 pp).
What I mean by hack/crack is;
- login with invalid account
- edit someone elses details
- XSS
- Session hijacking
- SQL Injection
What I do not mean is;
- DOS attacks
- Other attacks that are aimed at the web server or anything else
nothing to do with the application itself
Will provide more details to people interested.
--
Taco Fleur - http://www.pacificfox.com.au
http://www.pacificfox.com.au/
Web Design, Web development, Graphic Design and Complete Internet
Solutions
an industry leader with commercial IT experience since 1994 ...
--
Taco Fleur - http://www.pacificfox.com.au
Web Design, Web development, Graphic Design and Complete Internet
Solutions
an industry leader with commercial IT experience since 1994 ...
Web Design, Web development, Graphic Design and Complete Internet
Solutions
an industry leader with commercial IT experience since 1994 ...
--
Taco Fleur -http://www.pacificfox.com.au
Web Design, Web development, Graphic Design and Complete Internet Solutions
an industry leader with commercial IT experience since 1994 ...
ace.gif
2KViewDownload
--~--~-~--~~~---~--~~
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: FineNoCase Problem
ListFindNoCase('OPPO,OPSNC,OPVAN,OPGEN,INP', x) gt 0
Cheers,
Adam
-Original Message-
From: Scott Thornton [mailto:[EMAIL PROTECTED]
Sent: Friday, 2 March 2007 2:48 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] FineNoCase Problem
Hi,
I have been using
FindNoCase(x,'OPPO,OPSNC,OPVAN,OPGEN,INP') gt 0 for a while but only
noticed today that if the value of x is OPVA it would match on the value
OPVAN. Not what I was expecting.
I have changed the statement to use multiple comparison eg x=oppo or
x=opsnc and so on, but was wondering if there was a solution using a
function like that above?
--~--~-~--~~~---~--~~
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: Fusebox question
Hi Ryan, If your model code was encapsulated in cfcs, you could name your queries in the controller.. this is how I do it. set name=qGetEvent value=#application.myQueriesCfc.getEvent(myArgument='value')# / Cheers, Adam _ From: Ryan Sabir [mailto:[EMAIL PROTECTED] Sent: Sunday, 25 February 2007 1:45 PM To: 'cfaussie@googlegroups.com' Subject: [cfaussie] Re: Fusebox question Thanks Robin, That all makes sense, but here's the bit I think I've missed... how do I specify the variable name the controller sets up for the view. At the moment in my model, a query looks like this: cfquery name=qEvent ..etc In this case the model itself is setting the name of the variable. How do I get the controller to specify this? Is it as simple as setting a request variable in the controller 'request.eventObjectName' and passing that down the line? That means I'll have to evaluate() it at run time, a possible performance hit. Or is there a FuseBox structure that can hold this object until its needed? thanks. _ From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Robin Hilliard Sent: Saturday, 24 February 2007 4:43 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Fusebox question On 23/02/2007, at 1:55 PM, Ryan Sabir wrote: This seems to me to be breaking the whole modularity of my solution, as the view is expecting a query object named 'qGetEvent', in order to display its data. I feel like I've missed something fundamental in the Fusebox docs that will explain to me how to pass that query object down the line as a generic object, ratehr than a specifically named variable. Whats the trick? Hi Ryan, You have to have _some_ dependencies in an application to make it work, the trick is to eliminate the most harmful ones. Dependencies from the UI back to the business logic/data (as you have here) are fine, as long as the variable name the controller sets up for the view stays fixed - as long as the control stuff doesn't need to know anything else about the view you're fine. It's like using a post office box to send a letter to someone... (you don't know who and don't want to know) ...you agree on the format of the letter... (value objects, query column names and types) ...and a post office box. (a variable name). When you have a letter to send you drop it into the post office box, and you don't care or know if anyone picks it up. What you avoid doing this is having to address the letter to a specific, concrete individual... (this would be like rendering bits of html or calling a function or tag specific to the current incarnation of the UI) ...from the UI... (a flighty crowd with high staff turnover - UI and other interfaces change far more often than business logic) ...if you did that, you'd have to keep changing your process to address the letter, impacting your otherwise highly reusable letter addressing process. (i.e. your business logic) If this sort of analogy appeals and you'd like to hear more, this is pretty much an extract from my MAX Asia architecture talk that I'm repeating at WebDU next month. It's about MVC and Flex but applies to ColdFusion too. Cheers, Robin __ Robin Hilliard Director - RocketBoots Pty Ltd Consulting . Recruitment . Software Licensing . Training http://www.rocketboots.com.au For schedule/availability call Pamela Higgins: w+61 7 5451 0362 m+61 419 677 151 f+61 3 9923 6261 e[EMAIL PROTECTED] or Direct: m+61 418 414 341 e[EMAIL PROTECTED] 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: QoQ inside a CFC function
Hi Duncan.. In your cfc, try this sql: Select * from arguments.thisQuery Cheers, Adam -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, 16 February 2007 9:41 AM To: cfaussie Subject: [cfaussie] QoQ inside a CFC function All, Just having a blank here - I cant work out why i cant pass a query to a CFC and then have it do a QoQ and return another query object. I have knocked up a sample test case to try and work it out: CFM page: cfquery name=qIPBlacklist datasource=#application.DBDSN# username=#application.DBUserName# password=#application.DBPassword# Select top 10 * from ParamTest /cfquery cfobject component=tempQuery name=testQueryObj cfset qReturnedResults=testQueryObj.doQoQ(thisQuery=qIPBlacklist)/ CFC: cfcomponent output=false cffunction name=doQoQ access=package output=false returntype=Any cfargument name=thisQuery type=Query required=true / cfset var thisResult = / cfquery name=thisResult dbtype=query Select * from #arguments.thisQuery# /cfquery cfreturn thisResult / /cffunction /cfcomponent This results in a Simple objects cannot be converted, clearly if I call like this: cfset qReturnedResults=testQueryObj.doQoQ(thisQuery='qIPBlacklist')/ I am simply passing a string which then results in a This is not a valid query object error. Any help greatly appreciated! Thanks. --~--~-~--~~~---~--~~ 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: [WOT] Vista launches
http://www.bbspot.com/Images/News_Features/2007/02/vista_upgrade_flowcha rt.pdf -Original Message- From: Haikal Saadh [mailto:[EMAIL PROTECTED] Sent: Thursday, 1 February 2007 5:01 PM Cc: cfaussie@googlegroups.com Subject: [cfaussie] [WOT] Vista launches http://www.little-gamers.com/index.php?comicID=1530 :D :D :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 [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: working with dates in CF
Hi Claude, Try dateformat(lsParseDateTime(payment_date), dd-mmm-yy) Cheers, Adam _ From: claude raiola [mailto:[EMAIL PROTECTED] Sent: Monday, 29 January 2007 12:52 AM To: cfaussie@googlegroups.com; cfaussie@googlegroups.com Subject: [cfaussie] working with dates in CF hi al I have the following date that I need to specify in my code cfset payment_from_date=10-01-07 however I cannot seem to display it in correct date format using the dateformat function it keeps returning 1-oct-07 when I am using dateformat(payment_date, dd-mmm-yy) I look forward to your advice seem to find date display / manipulation a real pain in the butt to get the correct format Kind Regards Claude Raiola B.Econ(Acc.); B.Hotel Mngt. Mobile: 0414 228 948 Phone: 07 5538 5961 Fax: 07 3319 6444 Websites: www.WebsiteSolutions.com.au http://www.websitesolutions.com.au/ www.AustralianAccommodation.com http://www.australianaccommodation.com/ www.AccommodationNewZealand.com http://www.accommodationnewzealand.com/ www.HospitalityPurchasing.net http://www.hospitalitypurchasing.net/ www.Samaris.net http://www.samaris.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?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: cfinvoke webservice, xml response and 'cf' datatypes
Thanks Toby Shane, Will give both these methods a crack and see what happens.. Cheers, Adam _ From: Shane Farmer [mailto:[EMAIL PROTECTED] Sent: Sunday, 21 January 2007 4:55 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: cfinvoke webservice, xml response and 'cf' datatypes Hi Adam, A very handy tool you could try is SoupUI (www.soapui.org). We use it at work to run test suites against our Java web services. You point it at the WSDL, it can generate a default request where you fill in the blanks and hit send. What you get back is the actual SOAP envelope with all the XML you will ever need :-) Well worth checking out if you are working with web services and just a simple request/response to deal with. There is even an Eclipse plug in for it! When you have the SOAP response, you can decide if you need to send XML or if the native type will be consumable from .net. It will even validate it for you! Hope this helps. Shane On 1/19/07, Adam Chapman [EMAIL PROTECTED] wrote: Hi All, I am currently putting together a basic webservice which returns an array to the caller. (returntype=array) I want to see the xml response that the caller will receive (.NET user), but as the returntype is array, when I cfdump the result, I get a nicely formatted array dump, rather than the raw xml. Anyone know a quick way to access the actual soap xml response? Or should I use xml to create an xml object and return THAT rather than the array? Cheers, Adam cfinvoke webservice=http://mywebservices/myservice.cfc?wsdl method=getArray returnvariable=ws cfinvokeargument name=a value=what / cfinvokeargument name=b value=fun / /cfinvoke cfdump var=#ws# --~--~-~--~~~---~--~~ 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: Image Manipulation
Hi Rod, I use ImageCR http://efflare.com/products/cfx_imagecr/ I gave alagad a try but imageCR is about 8 times faster.. Though I do like alagad Being written in java.. (and is free) Im gagging to see what adobe do with image manilpulation functionality in CF8.. Cheers, Adam From: Rod Higgins [mailto:[EMAIL PROTECTED] Sent: Thursday, 12 October 2006 12:56 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Image Manipulation What are ppl using to generation images on the fly? I have an old app using the batik api to create images from SVG content using the org.apache.batik.apps.rasterizer.SVGConverter class. What are ppl currently using and what are the pros and cons with each approach? tia Rod --~--~-~--~~~---~--~~ 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] regexp - keyboard characters
Hi All, Anyone have a regular expression that strips all but keyboard characters.. not just printable characters.. but anything that you can't type using a keyboard? I'm sure there is some funky syntax required to escape some of the shift0-9 characters.. a • – “ ” é ç © È € b I would like to just be left with a and b from the above string.. (the hyphen is not a normal hyphen.. looks like it comes from M$ word) Thanks in advance.. 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 -~--~~~~--~~--~--~---
[cfaussie] Re: regexp - keyboard characters
Thanks chaps..
-Original Message-
From: Joel Cass [mailto:[EMAIL PROTECTED]
Sent: Thursday, 5 October 2006 10:47 AM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: regexp - keyboard characters
You could try it the old-school way (at least it'll work on older
versions):
[EMAIL PROTECTED]\*\.\?\(\)\{\}\[\]\\|\:;',/]
Joel
-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED]
Behalf Of Adam Chapman
Sent: Thursday, 5 October 2006 10:28 AM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: regexp - keyboard characters
Hi Steve,
Doesnt seem to be having any effect..
Test script below..
cfoutput
cfset str1 = a b /
#str1#br /
cfset str2 = REReplaceNoCase(str1, [^[:alnum:][:punc:][:space:], ,
ALL) /
#str2#br /
cfoutput
Cheers,
Adam
-Original Message-
From: Steve Onnis [mailto:[EMAIL PROTECTED]
Sent: Thursday, 5 October 2006 9:51 AM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: regexp - keyboard characters
REReplaceNoCase(string, [^[:alnum:][:punc:][:space:], , ALL)
Try that
Steve
-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On
Behalf Of Adam Chapman
Sent: Thursday, 5 October 2006 8:34 AM
To: cfaussie@googlegroups.com
Subject: [cfaussie] regexp - keyboard characters
Hi All,
Anyone have a regular expression that strips all but keyboard
characters.. not just printable characters.. but anything that you can't
type using a keyboard?
I'm sure there is some funky syntax required to escape some of the
shift0-9 characters..
a b
I would like to just be left with a and b from the above string.. (the
hyphen is not a normal hyphen.. looks like it comes from M$ word)
Thanks in advance..
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
-~--~~~~--~~--~--~---
[cfaussie] Re: CFFTP limit?
Hi Ryan, We use cfftp heavily.. and query directories with thousands of files and have found post CF5 cfftp to be pretty good.. Though some of the error messages can be pretty vague at times.. especially when trying to configure a new connection. I agree with Bjorn.. check the directories exist and that you have permissions.. if all else fails, try connecting via the command line to see if you can get any more info.. Cheers, Adam From: Ryan Sabir [mailto:[EMAIL PROTECTED] Sent: Thursday, 21 September 2006 1:21 PM To: 'cfaussie@googlegroups.com' Subject: [cfaussie] CFFTP limit? Hey all, I'm pushing files between servers using CFFTP and seem to have come across some sort of limit. I have a directory with around 1400 files in it, and when I try to list that directory I get a very unhelpful error message, see below. All other directories on that site transfer fine. Has anyone else come across this limit? thanks Here is the error, the stack trace just has java.lang.NullPointerException in it: --~--~-~--~~~---~--~~ 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: SQL Error message explanation - whats this really mean ?
Hi Mike, It's a tedious task but I would start by removing the cfqueryparam one field At a time and see which one is causing the problem.. its likely going to be around the 5th input parameter. Once you have found the offending parameter, check the cfsqltype of the cfqueryparam and check the datatype of the value you are trying to insert. I have a feeling it will be a datatype issue. Cheers, Adam -Original Message- From: Mike Kear [mailto:[EMAIL PROTECTED] Sent: Friday, 15 September 2006 4:05 PM To: cfaussie@googlegroups.com Subject: [cfaussie] SQL Error message explanation - whats this really mean ? I'm getting an error message during an insert when I use CFQUERYPARAM, that goes away if i remove all the CFQUERYPARAMs. The exact message is: [quote] [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near '@P5'. [/quote] Since there's no '@P5' in the insert query anywhere, I'm assuming it means something like parameter 5 is that right? so it's telling me that the 5th field in the insert is wrong (or somewhere close to it). If so I'm puzzled because there doesnt appear to be anything wrong with parameter 5, or the parameters either side or the ones either side of that. Can anyone tell me what the @P5 is really telling me? (this is a big insert with about 40 fields being inserted and tracking down which field is giving the problem is proving problematic) -- 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 --~--~-~--~~~---~--~~ 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] createobject() class not found
Hi All,
Can anyone tell me why this fails or where the java class would be?
cfset jsch = createobject('java',com.jcraft.jsch.JSch) /
Error:
Object Instantiation Exception.
Class not found: com.jcraft.jsch.JSch
Here is the site it comes from..
http://www.jcraft.com/jsch/index.html
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
-~--~~~~--~~--~--~---
[cfaussie] Re: createobject() class not found
Hi Mark,
Frommy limited java knowledge, the code is expecting to get the java
class from the jcraft web server.
Im actually trying the implement the sftp.cfc
(http://www.socialpoints.com/blog/client/includes/cfsftp1_3_1.zip)
An extract from the jcraft readme
http://www.jcraft.com/jsch/README
How To Try
==
This archive does not include java byte code, so please compile
the source code by your self.
$ cd jsch-?.?.?/src
$ javac com/jcraft/jsch/*java com/jcraft/jsch/jce/*java
com/jcraft/jzlib/*.java
'/examples/' directory has included some samples to demonstrate what
JSch can do. Please refer to '/examples/README' file.
Cheers,
Adam
-Original Message-
From: Mark Mandel [mailto:[EMAIL PROTECTED]
Sent: Thursday, 14 September 2006 11:55 AM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: createobject() class not found
Adam -
Have you moved the library into your ClassPath or anything of the like?
Mark
On 9/14/06, Adam Chapman [EMAIL PROTECTED] wrote:
Hi All,
Can anyone tell me why this fails or where the java class would be?
cfset jsch = createobject('java',com.jcraft.jsch.JSch) /
Error:
Object Instantiation Exception.
Class not found: com.jcraft.jsch.JSch
Here is the site it comes from..
http://www.jcraft.com/jsch/index.html
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
-~--~~~~--~~--~--~---
[cfaussie] createobject() class not found
Hi Mark,
I have done all that.. followed the sftp.cfc readme to the letter
1. Put the cfsftp.jar file on your web server.
2. In CFADMIN select Java and JVM from the server settings and add the
full
path to the cfsftp.jar file to the ColdFusion Class Path.
e.g. c:\cfsftp\cfsftp.jar
3. Restart ColdFusion server.
Then I get the error as described when calling the init() method of the
sftp.cfc
I have a fair bit of experience calling and using java with
createObject, but only with calls to classes..
output = createObject(java,java.io.FileOutputStream).init()
but not:
jsch = createobject('java',com.jcraft.jsch.JSch)
Cheers,
Adam
-Original Message-
From: Mark Mandel [mailto:[EMAIL PROTECTED]
Sent: Thursday, 14 September 2006 12:08 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: createobject() class not found
You need to have your Java code in the ColdFusion classpath.
I would highly recommend picking up a Java book of some description
and getting to know the language a little bit more before continuing
down this road - it sounds like it might be painful :o(
Mark
On 9/14/06, Adam Chapman [EMAIL PROTECTED] wrote:
Hi Mark,
Frommy limited java knowledge, the code is expecting to get the java
class from the jcraft web server.
Im actually trying the implement the sftp.cfc
(http://www.socialpoints.com/blog/client/includes/cfsftp1_3_1.zip)
An extract from the jcraft readme
http://www.jcraft.com/jsch/README
How To Try
==
This archive does not include java byte code, so please compile
the source code by your self.
$ cd jsch-?.?.?/src
$ javac com/jcraft/jsch/*java com/jcraft/jsch/jce/*java
com/jcraft/jzlib/*.java
'/examples/' directory has included some samples to demonstrate what
JSch can do. Please refer to '/examples/README' file.
Cheers,
Adam
-Original Message-
From: Mark Mandel [mailto:[EMAIL PROTECTED]
Sent: Thursday, 14 September 2006 11:55 AM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: createobject() class not found
Adam -
Have you moved the library into your ClassPath or anything of the
like?
Mark
On 9/14/06, Adam Chapman [EMAIL PROTECTED] wrote:
Hi All,
Can anyone tell me why this fails or where the java class would be?
cfset jsch = createobject('java',com.jcraft.jsch.JSch) /
Error:
Object Instantiation Exception.
Class not found: com.jcraft.jsch.JSch
Here is the site it comes from..
http://www.jcraft.com/jsch/index.html
Cheers,
Adam
--
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: createobject() class not found
Hi Dale,
It would seem the readme instructions did not work.. but putting the jar
file str8 into the lib directory and a restart did.
Cheers,
Adam
-Original Message-
From: Dale Fraser [mailto:[EMAIL PROTECTED]
Sent: Thursday, 14 September 2006 12:14 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: createobject() class not found
Adam,
Just put the .jar file into
C:\CFusionMX7\lib\
Restart Coldfusion and you should be good.
The com.blah package structure will be in the jar.
A JAR being a zip file containing a directory structure of java goodies.
Regards
Dale Fraser
http://dale.fraser.id.au
-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On
Behalf
Of Adam Chapman
Sent: Thursday, 14 September 2006 12:04 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: createobject() class not found
Hi Mark,
Frommy limited java knowledge, the code is expecting to get the java
class from the jcraft web server.
Im actually trying the implement the sftp.cfc
(http://www.socialpoints.com/blog/client/includes/cfsftp1_3_1.zip)
An extract from the jcraft readme
http://www.jcraft.com/jsch/README
How To Try
==
This archive does not include java byte code, so please compile
the source code by your self.
$ cd jsch-?.?.?/src
$ javac com/jcraft/jsch/*java com/jcraft/jsch/jce/*java
com/jcraft/jzlib/*.java
'/examples/' directory has included some samples to demonstrate what
JSch can do. Please refer to '/examples/README' file.
Cheers,
Adam
-Original Message-
From: Mark Mandel [mailto:[EMAIL PROTECTED]
Sent: Thursday, 14 September 2006 11:55 AM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: createobject() class not found
Adam -
Have you moved the library into your ClassPath or anything of the like?
Mark
On 9/14/06, Adam Chapman [EMAIL PROTECTED] wrote:
Hi All,
Can anyone tell me why this fails or where the java class would be?
cfset jsch = createobject('java',com.jcraft.jsch.JSch) /
Error:
Object Instantiation Exception.
Class not found: com.jcraft.jsch.JSch
Here is the site it comes from..
http://www.jcraft.com/jsch/index.html
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
-~--~~~~--~~--~--~---
[cfaussie] Re: CF webservices - output parameters
Hi Drew, You COULD just build the xml soap response yourself.. kinda defeats the purpose of using cf for webservices.. but I had to do this to get around a webservice 'complex datatype' issue.. Cheers, Adam -Original Message- From: skateboard.com.au [mailto:[EMAIL PROTECTED] Sent: Thursday, 31 August 2006 3:59 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: CF webservices - output parameters Hey Andrew Bummer if CF is limited in this way. Can anyone else suggest another web service delivery platform that will run on solaris. I'll look at an apache/tomcat/axis configuration if nobody else has any suggestions. thanks Drew --~--~-~--~~~---~--~~ 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: Cold Fusion Tutor - hourly rate
Hi Pete, That's what cfaussie is for.. we were all cf noobs at one point. Post your code and what you are trying to achieve and one of the kind souls on the list will point you in the right direction. This list has been good to me over the years.. *sniff* I promised myself I wouldn't cry. Cheers, Adam -Original Message- From: pmayadun [mailto:[EMAIL PROTECTED] Sent: Thursday, 24 August 2006 7:10 PM To: cfaussie Subject: [cfaussie] Cold Fusion Tutor - hourly rate Hi all, I am trying to (self) learn CF. Primerily via books, the web etc etc. I get stuck sometimes and spend too much time trouble shooting. I have tried via various forums on the web, but it simply doesnt seem to help. Would someone be able to help with explanations as to what i am doing wrong, on an hourely rate? I live in the Gold Coast, so if it is someone in the Gold Coast that would be super. But not all that imp as I can always call and chat... OR if someone can just write some sample code to explain what I have done wrong would be Ok too. many thanks... Pete [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 -~--~~~~--~~--~--~---
[cfaussie] Sorta OT: CF Developer Position here at Portplus..
Hi Everyone, Hope I don't get a smacked bottom for posting this here.. but here goes.. There is a position available here for an experienced developer, below is the official gumph.. so check it out. Regards, Adam Chapman Senior Coldfusion Developer Portplus www.portplus.com T: 03 9800 = Coldfusion Developers Developers - Don't miss this opportunity to join our team of professionals who are continually pushing technology to the edge for the Real Estate Industry. We are seeking an experienced Coldfusion Developer (3+ years) to join our team. Core skill requirements will be: - Advanced Coldfusion skills (3+ years) - Relational database design and administration (MS SQL Server) - Advanced application design experience - Advanced SQL skills - Experience with CFCs - Experience with Flash a definite advantage - Exposure to Fusebox methodology (FB4 preferred) - XML Experience - Javascript Skills - Project documentation skills - Ability to work to deadlines Your key responsibilities will include design, development and documentation of web applications. Furthermore, teamwork, communication skills and desire to work in a positive environment are a critical requirement. Remuneration will be negotiated for the successful applicant. FOR YOUR APPLICATION TO BE CONSIDERED YOU MUST INCLUDE SAMPLE CODE WITH YOUR APPLICATION. PLEASE APPLY ONLY BY EMAIL OTHERWISE APPLICATION WILL NOT BE CONSIDERED. If you have the qualifications and are interested in this opportunity, please forward your application and CV to: [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 -~--~~~~--~~--~--~---
[cfaussie] clearTrustedCache() - single template?
Hi All, Y'know how you can clear the trusted cache with the code below.. adminObj = createObject(component,cfide.adminapi.administrator); adminObj.login(cfadminpassword); myObj = createObject(component,cfide.adminapi.runtime); myObj.clearTrustedCache(); Does anyone know if its possible to clear a single template from the cache.. Regards, Adam Chapman Portplus www.portplus.com T: 03 9800 --~--~-~--~~~---~--~~ 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: db architecture question
HI Grant, you can't pass in parameters to a view Why not? (unless I'm missing something) I do this all the time... Sql View (called topSecret) SELECT * FROM TOP_SECRET_DB_TABLE -- other joins/unions etc. Cfquery SELECT * FROM topSecret WHERE clientId = 666 ORDER BY thisField Let me know if im not on the same page as you?!?! Cheers, Adam -Original Message- From: grant [mailto:[EMAIL PROTECTED] Sent: Thursday, 6 July 2006 3:23 PM To: cfaussie@googlegroups.com Subject: [cfaussie] ot: db architecture question hi all we've got a propriety system here that backends onto sql server. the system maintains all time entries and billing information for the firm - and in the firms view, this information is sacred and has about a million levels of security. I've been charged with making a web-visible reporting tool using the information in this system. we are not allowed to connect directly from CF to the sql database - there has to be a layer of abstraction between the web-visible server and the internal database. we've already done a version one, where we ran a seperate sql-server with linked views to the production sql-server. this has had many pitfalls, the main one being that you can't pass in parameters to a view - or link stored procs. basically we've had to make seperate views for each of the parameters that we wish to pass in (usually it's clientid, of which we only have about five at the moment) but it's a managability nightmare. so here's my question: how can i access the production db, either from the cf server or a separate db server, while still maintaining an abstracted level of security (and be able to pass in parameters)? There are about 3million records we're sifting through, so it's not practical to bring it into cf memory and filter from there. any ideas, for you advanced db guys? thanks grant --~--~-~--~~~---~--~~ 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] Long Lat query
Enjoy SELECT suburbId, suburbName FROM suburb WHERE ROUND((ACOS((SIN(#suburb_latitude#/57.2958) * SIN(suburb_latitude /57.2958)) + (COS(#suburb_latitude#/57.2958) * COS(suburb_latitude /57.2958) * COS(suburb_longitude/57.2958 - #suburb_longitude#/57.2958 * 3963, 3) = #val(surroundingRadiusMiles)# There are other ways.. like just passing in a suburbId and surroundingRadiusMiles.. but I will leave that to you!! ;) Cheers, Adam From: Taco Fleur [mailto:[EMAIL PROTECTED] Sent: Monday, 22 May 2006 8:56 AM To: cfaussie@googlegroups.com Subject: [cfaussie] [OT] Long Lat query Is anyone able to share a query with me that will calculate surrounding suburbs on a longitude and latitude database? I have the database, but not the query. Thanks -- Taco Fleur - http://www.pacificfox.com.au Web Design, Web development, Graphic Design and Complete Internet Solutions an industry leader with commercial IT experience since 1994
[cfaussie] Re: webservice woes
Hi Grant, Find yourself an online wsdl parser/web service tester.. this will Generate the request xml.. you can then modify and use this as the http request.. a bit lazy but it will save you some serious time. Email me if you get stuck as there are a few cfhttpparam quirks with this method. Cheers, Adam -Original Message- From: grant [mailto:[EMAIL PROTECTED] Sent: Monday, 1 May 2006 9:31 AM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: webservice woes nope, still no joy. it looks like it's going to be the http route that Adam suggested. --~--~-~--~~~---~--~~ 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: webservice woes
Hi Grant, The wsdl renders fine in a browser so the problem doesn't appear to be at the amazon end. I pulled all my hair out when trying to consume a .net soap webservice with 'complex' datatypes. I spent ages on it with cfinvoke and createObject but got nowhere. I finally got it to work by building the xml request myself and posting it using cfhttp.. (a webservice is basically just an xml post via http anyhow) Then just parse the xml response with cf's xml functions and all is good.. it has been extremely reliable. Cheers, Adam -Original Message- From: grant [mailto:[EMAIL PROTECTED] Sent: Friday, 28 April 2006 3:53 PM To: cfaussie@googlegroups.com Subject: [cfaussie] webservice woes hi all i've having trouble with calling a few webservices with cfinvoke - i keep getting the error: 'Could not generate stub objects for web service invocation.' It then goes on to imply that the wsdl is malformed, which it isn't... there's heaps of info about it in google, but there aren't that many solutions - none that work for me anyway (tried the firewall/proxy, it's not SSL, it's not credential related). anybody seen this and found a solution? here's some code, to amazon, which is firing the error for me...give it a burl... cfscript AWS = createObject(Webservice,http://webservices.amazon.com/AWSECommerceSer vice/AWSECommerceService.wsdl); /cfscript cfdump var=#AWS# thanks G --~--~-~--~~~---~--~~ 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: what's the 'proper way' to remove comma formatting from numbers
Hi Kay, I like a regular expression for this sort of thing.. but it's just personal preference as I am often turning $10,000 into 1. I will also turn $10,000.00 into 1.00 reReplace(string,[^0-9.],,all) This will remove anything that isn't a number or a . (leaving decimal points in place) Cheers, Adam -Original Message- From: Kay Smoljak [mailto:[EMAIL PROTECTED] Sent: Friday, 7 April 2006 11:35 AM To: cfaussie@googlegroups.com Subject: [cfaussie] what's the 'proper way' to remove comma formatting from numbers Hey guys, I can think of all sorts of ways to actually do it, but what's the most correct/bulletproof way to turn 10,000 into 1? -- Kay Smoljak http://kay.zombiecoder.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] Postcode search
Hi All, We used mapds.com.au to create: http://www.portplus.com/storage/919/website/frames/templates/flashmap.cf m and use the same data for 'surrounding suburbs' type functions. 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 -~--~~~~--~~--~--~---
