Re: [cfaussie] The solution: Odd date behaviour - CF9/SQLServer2005
Straight from the ColdFusion documentation Mike. Formats a date value using U.S. date formats. For international date support, use LSDateFormat WSc3ff6d0ea77859461172e0811cbec22c24-6de1.html. On Wed, Jun 9, 2010 at 3:19 PM, Mike Kear afpwebwo...@gmail.com wrote: I'm still testing, but it looks like at long last this problem is solved. For those who have been following this saga, the issue is that no matter what way I put the date into the code, it always seemed to be stored in the database in an erratic way. For dates earlier than the 13th of the month (and therefore ambiguous as to which is the day and which is the month in the date string) the database would store -dd-mm and for the 13th or later, it would store -mm-dd, which is what i wanted for all of the dates. It boiled down to a code generator that i've been using without any issues for a long time. The setter and getter for any date fields was like the following: === cffunction name=setTransDate access=public returntype=void output=false cfargument name=TransDate type=string required=true / cfif isDate(arguments.TransDate) cfset arguments.TransDate = dateformat(arguments.TransDate,DD/MM/) / /cfif cfset variables.instance.TransDate = trim(arguments.TransDate) / /cffunction cffunction name=getTransDate access=public returntype=string output=false cfreturn variables.instance.TransDate / /cffunction === This date formatting was apparently what's causing the problem. I'm not sure why because I'd have thought it would either do nothing (i.e. convert dd/mm/ into dd/mm/) or correct an American format date to Australian format date. But when i removed that manipulation, the problem went away. I'm a little nervous about just using it, because I think i should know why the former code was a problem but that will have to wait for another day. Here's the code that seems to give me the desired result: === cffunction name=setTransDate access=public returntype=void output=false cfargument name=TransDate type=date required=true / cfset variables.instance.TransDate = arguments.TransDate / /cffunction cffunction name=getTransDate access=public returntype=date output=false cfreturn variables.instance.TransDate / /cffunction === I am MOST grateful to all those people - too numerous to mention now - who have helped me through this. Because it goes back to a code generator that I've never had any issues with while writing maybe 100 applications, I didn't even look at that. It was a LONG way down the list of possible suspects. I'll write and make sure Pete Farrell is in the loop on this. Thank you all. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.comcfaussie%2bunsubscr...@googlegroups.com . For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] The solution: Odd date behaviour - CF9/SQLServer2005
I don't think that's the issue - us date formats would only kick in with the named formats (i.e. short). Since he provided the format, the output should be a generic string in that format. Mike, when I've had that issue I got around it by outputing the month with the abbreviation rather than the number e.g. 9 Jun 2010. Both ColdFusion and all the DBs I've worked with accept the format, and they have no need for best-guess interpretation. Blair On Wed, Jun 9, 2010 at 4:41 PM, Andrew Scott andr...@andyscott.id.auwrote: Straight from the ColdFusion documentation Mike. Formats a date value using U.S. date formats. For international date support, use LSDateFormathttp://WSc3ff6d0ea77859461172e0811cbec22c24-6de1.html . On Wed, Jun 9, 2010 at 3:19 PM, Mike Kear afpwebwo...@gmail.com wrote: I'm still testing, but it looks like at long last this problem is solved. For those who have been following this saga, the issue is that no matter what way I put the date into the code, it always seemed to be stored in the database in an erratic way. For dates earlier than the 13th of the month (and therefore ambiguous as to which is the day and which is the month in the date string) the database would store -dd-mm and for the 13th or later, it would store -mm-dd, which is what i wanted for all of the dates. It boiled down to a code generator that i've been using without any issues for a long time. The setter and getter for any date fields was like the following: === cffunction name=setTransDate access=public returntype=void output=false cfargument name=TransDate type=string required=true / cfif isDate(arguments.TransDate) cfset arguments.TransDate = dateformat(arguments.TransDate,DD/MM/) / /cfif cfset variables.instance.TransDate = trim(arguments.TransDate) / /cffunction cffunction name=getTransDate access=public returntype=string output=false cfreturn variables.instance.TransDate / /cffunction === This date formatting was apparently what's causing the problem. I'm not sure why because I'd have thought it would either do nothing (i.e. convert dd/mm/ into dd/mm/) or correct an American format date to Australian format date. But when i removed that manipulation, the problem went away. I'm a little nervous about just using it, because I think i should know why the former code was a problem but that will have to wait for another day. Here's the code that seems to give me the desired result: === cffunction name=setTransDate access=public returntype=void output=false cfargument name=TransDate type=date required=true / cfset variables.instance.TransDate = arguments.TransDate / /cffunction cffunction name=getTransDate access=public returntype=date output=false cfreturn variables.instance.TransDate / /cffunction === I am MOST grateful to all those people - too numerous to mention now - who have helped me through this. Because it goes back to a code generator that I've never had any issues with while writing maybe 100 applications, I didn't even look at that. It was a LONG way down the list of possible suspects. I'll write and make sure Pete Farrell is in the loop on this. Thank you all. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.comcfaussie%2bunsubscr...@googlegroups.com . For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.comcfaussie%2bunsubscr...@googlegroups.com . For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- 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] The solution: Odd date behaviour - CF9/SQLServer2005
+1 on using the three letter month... almost impossible to confuse and human friendly to boot On 9 June 2010 16:49, Blair McKenzie shi...@gmail.com wrote: I don't think that's the issue - us date formats would only kick in with the named formats (i.e. short). Since he provided the format, the output should be a generic string in that format. Mike, when I've had that issue I got around it by outputing the month with the abbreviation rather than the number e.g. 9 Jun 2010. Both ColdFusion and all the DBs I've worked with accept the format, and they have no need for best-guess interpretation. Blair On Wed, Jun 9, 2010 at 4:41 PM, Andrew Scott andr...@andyscott.id.au wrote: Straight from the ColdFusion documentation Mike. Formats a date value using U.S. date formats. For international date support, use LSDateFormat. On Wed, Jun 9, 2010 at 3:19 PM, Mike Kear afpwebwo...@gmail.com wrote: I'm still testing, but it looks like at long last this problem is solved. For those who have been following this saga, the issue is that no matter what way I put the date into the code, it always seemed to be stored in the database in an erratic way. For dates earlier than the 13th of the month (and therefore ambiguous as to which is the day and which is the month in the date string) the database would store -dd-mm and for the 13th or later, it would store -mm-dd, which is what i wanted for all of the dates. It boiled down to a code generator that i've been using without any issues for a long time. The setter and getter for any date fields was like the following: === cffunction name=setTransDate access=public returntype=void output=false cfargument name=TransDate type=string required=true / cfif isDate(arguments.TransDate) cfset arguments.TransDate = dateformat(arguments.TransDate,DD/MM/) / /cfif cfset variables.instance.TransDate = trim(arguments.TransDate) / /cffunction cffunction name=getTransDate access=public returntype=string output=false cfreturn variables.instance.TransDate / /cffunction === This date formatting was apparently what's causing the problem. I'm not sure why because I'd have thought it would either do nothing (i.e. convert dd/mm/ into dd/mm/) or correct an American format date to Australian format date. But when i removed that manipulation, the problem went away. I'm a little nervous about just using it, because I think i should know why the former code was a problem but that will have to wait for another day. Here's the code that seems to give me the desired result: === cffunction name=setTransDate access=public returntype=void output=false cfargument name=TransDate type=date required=true / cfset variables.instance.TransDate = arguments.TransDate / /cffunction cffunction name=getTransDate access=public returntype=date output=false cfreturn variables.instance.TransDate / /cffunction === I am MOST grateful to all those people - too numerous to mention now - who have helped me through this. Because it goes back to a code generator that I've never had any issues with while writing maybe 100 applications, I didn't even look at that. It was a LONG way down the list of possible suspects. I'll write and make sure Pete Farrell is in the loop on this. Thank you all. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month -- 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. -- 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. -- Zac Spitzer Solution Architect / Director Ennoble Consultancy Australia
Re: [cfaussie] The solution: Odd date behaviour - CF9/SQLServer2005
On Tue, Jun 8, 2010 at 10:19 PM, Mike Kear afpwebwo...@gmail.com wrote: It boiled down to a code generator that i've been using without any issues for a long time. The setter and getter for any date fields was like the following: Storing dates as formatted strings is just asking for problems. I'm glad you posted the set/get methods (as I asked) because now we can see exactly why it fails! cfset arguments.TransDate = dateformat(arguments.TransDate,DD/MM/) / So this converts a real date to a specific format string. cfreturn variables.instance.TransDate / And this returns the formatted string and it then gets converted to a real date (when you go to the DB) using your native locale - which *tries* to match it to an Australian date when it can but reverts to the US format when it can't. The moral is: never, ever store a date as a string :) cffunction name=setTransDate access=public returntype=void output=false cfargument name=TransDate type=date required=true / cfset variables.instance.TransDate = arguments.TransDate / /cffunction cffunction name=getTransDate access=public returntype=date output=false cfreturn variables.instance.TransDate / /cffunction That's how set/get methods should behave - no conversion. BTW, it would be *really* useful to tell us which code generator you used so we can avoid it... -- Sean A Corfield -- (904) 302-SEAN Railo Technologies, Inc. -- http://getrailo.com/ An Architect's View -- http://corfield.org/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] Re: Odd date behaviour - CF9/SQLServer2005
On Tue, Jun 8, 2010 at 9:15 PM, Mike Kear afpwebwo...@gmail.com wrote: This is generated by the Rooibos code written by P Farrell Just saw this so ignore my other post (about naming the guilty code generator). Thanx. -- Sean A Corfield -- (904) 302-SEAN Railo Technologies, Inc. -- http://getrailo.com/ An Architect's View -- http://corfield.org/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood -- 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] The solution: Odd date behaviour - CF9/SQLServer2005
Good point. It only becomes an issue when the date has to be a string at some point, e.g. form fields. On 09/06/2010 5:40 PM, Sean Corfield seancorfi...@gmail.com wrote: On Tue, Jun 8, 2010 at 10:19 PM, Mike Kear afpwebwo...@gmail.com wrote: It boiled down to a code... Storing dates as formatted strings is just asking for problems. I'm glad you posted the set/get methods (as I asked) because now we can see exactly why it fails! cfset arguments.TransDate = dateformat(arguments.TransDate,DD/MM/) / So this converts a real date to a specific format string. cfreturn variables.instance.TransDate / And this returns the formatted string and it then gets converted to a real date (when you go to the DB) using your native locale - which *tries* to match it to an Australian date when it can but reverts to the US format when it can't. The moral is: never, ever store a date as a string :) cffunction name=setTransDate access=public returntype=void output=false cfargument... That's how set/get methods should behave - no conversion. BTW, it would be *really* useful to tell us which code generator you used so we can avoid it... -- Sean A Corfield -- (904) 302-SEAN Railo Technologies, Inc. -- http://getrailo.com/ An Architect's View -- http://corfield.org/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood -- You received this message because you are subscribed to the Google Groups cfaussie group. To ... -- 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] The solution: Odd date behaviour - CF9/SQLServer2005
I have no problem with posting the name of code generator, but let me share this with the author first. Then I'll post more details. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Wed, Jun 9, 2010 at 5:40 PM, Sean Corfield seancorfi...@gmail.comwrote: [snippety snip] BTW, it would be *really* useful to tell us which code generator you used so we can avoid it... -- Sean A Corfield -- (904) 302-SEAN Railo Technologies, Inc. -- http://getrailo.com/ An Architect's View -- http://corfield.org/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] Re: Odd date behaviour - CF9/SQLServer2005
Sean, I'm not sure characterising it as guilty is very fair. This generator has worked just fine for me without any problems in about a hundred applications. This is the first time it's given me any issues. It's been so reliable I didnt suspect it might be anything to do with this issue for a very long time. I'm sure you'd be annoyed if i posted that something you've written is guilty before I've even asked you about the issue. Perhaps it might be a bug you're aware of, perhaps you might have a reason it's the way it is that's not compatible with what i want to use it for. Or any of a number of reasons. That's why i think its only fair to talk to the author first before making characterisations about his code. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Wed, Jun 9, 2010 at 5:44 PM, Sean Corfield seancorfi...@gmail.comwrote: On Tue, Jun 8, 2010 at 9:15 PM, Mike Kear afpwebwo...@gmail.com wrote: This is generated by the Rooibos code written by P Farrell Just saw this so ignore my other post (about naming the guilty code generator). Thanx. -- Sean A Corfield -- (904) 302-SEAN Railo Technologies, Inc. -- http://getrailo.com/ An Architect's View -- http://corfield.org/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.comcfaussie%2bunsubscr...@googlegroups.com . For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
[cfaussie] CFUG Melbourne June 2010: Galaxy SOA at PalCare Pty Ltd.
In March this year Robin Hilliard presented his Rapid Service-Oriented Architecture Development approach (based on 'Galaxy'), to the Melbourne CFUG. Gavin Baumanis, who maintains and develops a large legacy code base, picked up on the possibility of using an SOA approach to assist in quarantining parts of an application to introduce structure and allow the re-factoring of sections of the code without endangering the overall product. Over the last few months, he has been evaluating Galaxy for this purpose. This month, Gavin presents his initial findings on Galaxy and how he sees it supporting his requirements at PalCare Pty. Ltd. The presentation will be an open discussion of: Service Oriented Architecture (recap) Using Galaxy SOA to assist in the architectural choice of SOA - (recap) Case study of using SOA / Galaxy SOA Change in development mindset What did / did not work why What's ahead for us? Will we be using SOA / Galaxy SOA for our work? What's ahead for Galaxy SOA? Gavin fell into Coldfusion programming when he left the Navy after ten years of service and joined RMIT. Here he inherited a Coldfusion 4 application that was used to display the University's 15,000 floor plans. He must have liked it as he's still using ColdFusion! Currently he works for PalCare P/L where his team is rewriting a Patient Management System used by palliative care providers in Australia and New Zealand. Date: Thursday 17 June 2010 Time: 6:30 PM NEW Location: CogState Level 2 255 Bourke Street Melbourne, VIC, 3000 A note on the door will provide a number to ring for access. RSVP: Please reply to this post if you are planning to attend so we know how many pizzas to order. As always, many thanks to Dale Fraser and CogState for their hospitality. We look forward to seeing you all there. (Actually, we may be working in Adelaide that week, in which case you'll be in Dale's more-than-capable hands.) Peter Robertson Co-Manager Melbourne CFUG Steve Onnis Manager Melbourne CFUG -- 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] CF Query Timeout
Hi Is there a way that I have prevent the cfquery from timing out The sit is running on cf8 server in a shared hosting environment I am creating a complex excel spreadsheet using cfxml variable=varname that holds the xml for up to 20 different worksheets created on the fly. Given the volume of records in each worksheet often I generate the error Error Occurred While Processing Request The request has exceeded the allowable time limit Tag: CFQUERY I have tried to specify the timeout value in each query to a large amount of time however the timeout error still generates within 1 minute of the page starting to process the data. I have ensured that I am running queries of queries where possible to prevent unnecessary queries to the sql database however this seems not to have had any effect. If anyone has some suggestion I would be grateful. Regards Claude Raiola (B.Econ Acc; B.Hot. Mngt) Samaris Software Email: mailto:i...@trackingcentral.om.au i...@samaris.net Website: http://www.TrackingCentral.com.au www.SAMARIS.net Mobile: 0414 228 948 -- 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] CF Query Timeout
try putting a cfsetting at the top of the page cfsetting requesttimeout=999 / _ From: rai...@ozemail.com.au [mailto:rai...@ozemail.com.au] Sent: Wednesday, 9 June 2010 10:44 PM To: cfaussie@googlegroups.com; coldfusion-ho...@yahoogroups.com Subject: [cfaussie] CF Query Timeout Hi Is there a way that I have prevent the cfquery from timing out The sit is running on cf8 server in a shared hosting environment I am creating a complex excel spreadsheet using cfxml variable=varname that holds the xml for up to 20 different worksheets created on the fly. Given the volume of records in each worksheet often I generate the error Error Occurred While Processing Request The request has exceeded the allowable time limit Tag: CFQUERY I have tried to specify the timeout value in each query to a large amount of time however the timeout error still generates within 1 minute of the page starting to process the data. I have ensured that I am running queries of queries where possible to prevent unnecessary queries to the sql database however this seems not to have had any effect. If anyone has some suggestion I would be grateful. Regards Claude Raiola (B.Econ Acc; B.Hot. Mngt) Samaris Software Email: mailto:i...@trackingcentral.om.au i...@samaris.net Website: http://www.TrackingCentral.com.au www.SAMARIS.net Mobile: 0414 228 948 -- 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] CF Query Timeout
you can put a big number in for requesttimeout, but you will not be able to exceed the limit set in the CF administrator you may want to check with them to see what it is set at On 9 June 2010 21:00, Steve Onnis st...@cfcentral.com.au wrote: try putting a cfsetting at the top of the page cfsetting requesttimeout=999 / -- *From:* rai...@ozemail.com.au [mailto:rai...@ozemail.com.au] *Sent:* Wednesday, 9 June 2010 10:44 PM *To:* cfaussie@googlegroups.com; coldfusion-ho...@yahoogroups.com *Subject:* [cfaussie] CF Query Timeout Hi Is there a way that I have prevent the cfquery from timing out The sit is running on cf8 server in a shared hosting environment I am creating a complex excel spreadsheet using cfxml variable=varname” that holds the xml for up to 20 different worksheets created on the fly. Given the volume of records in each worksheet often I generate the error Error Occurred While Processing Request *The request has exceeded the allowable time limit Tag: CFQUERY * I have tried to specify the timeout value in each query to a large amount of time however the timeout error still generates within 1 minute of the page starting to process the data. I have ensured that I am running queries of queries where possible to prevent unnecessary queries to the sql database however this seems not to have had any effect. If anyone has some suggestion I would be grateful. Regards Claude Raiola (B.Econ Acc; B.Hot. Mngt) Samaris Software Email: i...@samaris.net i...@trackingcentral.om.au Website: www.SAMARIS.net http://www.TrackingCentral.com.au Mobile: 0414 228 948 -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.comcfaussie%2bunsubscr...@googlegroups.com . For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.comcfaussie%2bunsubscr...@googlegroups.com . For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- AJ Mercer http://webonix.net http://twitter.com/webonix -- 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] CF Query Timeout
yes you can. i do it all the time for long request pages. requesttimeout supersedes the cfadmin values as per the cfdocs for the description of requesttimeout integer; number of seconds. Time limit, after which ColdFusion processes the page as an unresponsive thread. Overrides the time-out set in the ColdFusion Administrator. _ From: AJ Mercer [mailto:ajmer...@gmail.com] Sent: Wednesday, 9 June 2010 11:07 PM To: cfaussie@googlegroups.com Subject: Re: [cfaussie] CF Query Timeout you can put a big number in for requesttimeout, but you will not be able to exceed the limit set in the CF administrator you may want to check with them to see what it is set at On 9 June 2010 21:00, Steve Onnis st...@cfcentral.com.au wrote: try putting a cfsetting at the top of the page cfsetting requesttimeout=999 / _ From: rai...@ozemail.com.au [mailto:rai...@ozemail.com.au] Sent: Wednesday, 9 June 2010 10:44 PM To: cfaussie@googlegroups.com; coldfusion-ho...@yahoogroups.com Subject: [cfaussie] CF Query Timeout Hi Is there a way that I have prevent the cfquery from timing out The sit is running on cf8 server in a shared hosting environment I am creating a complex excel spreadsheet using cfxml variable=varname that holds the xml for up to 20 different worksheets created on the fly. Given the volume of records in each worksheet often I generate the error Error Occurred While Processing Request The request has exceeded the allowable time limit Tag: CFQUERY I have tried to specify the timeout value in each query to a large amount of time however the timeout error still generates within 1 minute of the page starting to process the data. I have ensured that I am running queries of queries where possible to prevent unnecessary queries to the sql database however this seems not to have had any effect. If anyone has some suggestion I would be grateful. Regards Claude Raiola (B.Econ Acc; B.Hot. Mngt) Samaris Software Email: mailto:i...@trackingcentral.om.au i...@samaris.net Website: http://www.TrackingCentral.com.au www.SAMARIS.net Mobile: 0414 228 948 -- 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 mailto:cfaussie%2bunsubscr...@googlegroups.com . For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com mailto:cfaussie%2bunsubscr...@googlegroups.com . For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- AJ Mercer http://webonix.net http://twitter.com/webonix -- 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] CF Query Timeout
oh yeah - I was thinking of sessionTimeout and applicationTimeout On 9 June 2010 21:18, Steve Onnis st...@cfcentral.com.au wrote: yes you can. i do it all the time for long request pages. requesttimeout supersedes the cfadmin values as per the cfdocs for the description of requesttimeout integer; number of seconds. Time limit, after which ColdFusion processes the page as an unresponsive thread. Overrides the time-out set in the ColdFusion Administrator. -- *From:* AJ Mercer [mailto:ajmer...@gmail.com] *Sent:* Wednesday, 9 June 2010 11:07 PM *To:* cfaussie@googlegroups.com *Subject:* Re: [cfaussie] CF Query Timeout you can put a big number in for requesttimeout, but you will not be able to exceed the limit set in the CF administrator you may want to check with them to see what it is set at On 9 June 2010 21:00, Steve Onnis st...@cfcentral.com.au wrote: try putting a cfsetting at the top of the page cfsetting requesttimeout=999 / -- *From:* rai...@ozemail.com.au [mailto:rai...@ozemail.com.au] *Sent:* Wednesday, 9 June 2010 10:44 PM *To:* cfaussie@googlegroups.com; coldfusion-ho...@yahoogroups.com *Subject:* [cfaussie] CF Query Timeout Hi Is there a way that I have prevent the cfquery from timing out The sit is running on cf8 server in a shared hosting environment I am creating a complex excel spreadsheet using cfxml variable=varname” that holds the xml for up to 20 different worksheets created on the fly. Given the volume of records in each worksheet often I generate the error Error Occurred While Processing Request *The request has exceeded the allowable time limit Tag: CFQUERY * I have tried to specify the timeout value in each query to a large amount of time however the timeout error still generates within 1 minute of the page starting to process the data. I have ensured that I am running queries of queries where possible to prevent unnecessary queries to the sql database however this seems not to have had any effect. If anyone has some suggestion I would be grateful. Regards Claude Raiola (B.Econ Acc; B.Hot. Mngt) Samaris Software Email: i...@samaris.net i...@trackingcentral.om.au Website: www.SAMARIS.net http://www.TrackingCentral.com.au Mobile: 0414 228 948 -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.comcfaussie%2bunsubscr...@googlegroups.com . For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.comcfaussie%2bunsubscr...@googlegroups.com . For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- AJ Mercer http://webonix.net http://twitter.com/webonix -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.comcfaussie%2bunsubscr...@googlegroups.com . For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.comcfaussie%2bunsubscr...@googlegroups.com . For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- AJ Mercer http://webonix.net http://twitter.com/webonix -- 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] CF Query Timeout
Thanks Steve, I tried it and it worked a treat I pushed search criteria to the max to test it and it took 5 minutes to run the process with the resulting multi workbook spreadsheet containing several 100 rows of data per workbook, the excel file size ending up being 7 meg worked perfectly. As always we love your work Regards Claude Raiola (B.Econ Acc; B.Hot. Mngt) Samaris Software Email: i...@samaris.net mailto:i...@trackingcentral.om.au Website: www.SAMARIS.net http://www.TrackingCentral.com.au Mobile: 0414 228 948 From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf Of Steve Onnis Sent: Wednesday, 9 June 2010 11:18 PM To: cfaussie@googlegroups.com Subject: RE: [cfaussie] CF Query Timeout yes you can. i do it all the time for long request pages. requesttimeout supersedes the cfadmin values as per the cfdocs for the description of requesttimeout integer; number of seconds. Time limit, after which ColdFusion processes the page as an unresponsive thread. Overrides the time-out set in the ColdFusion Administrator. _ From: AJ Mercer [mailto:ajmer...@gmail.com] Sent: Wednesday, 9 June 2010 11:07 PM To: cfaussie@googlegroups.com Subject: Re: [cfaussie] CF Query Timeout you can put a big number in for requesttimeout, but you will not be able to exceed the limit set in the CF administrator you may want to check with them to see what it is set at On 9 June 2010 21:00, Steve Onnis st...@cfcentral.com.au wrote: try putting a cfsetting at the top of the page cfsetting requesttimeout=999 / _ From: rai...@ozemail.com.au [mailto:rai...@ozemail.com.au] Sent: Wednesday, 9 June 2010 10:44 PM To: cfaussie@googlegroups.com; coldfusion-ho...@yahoogroups.com Subject: [cfaussie] CF Query Timeout Hi Is there a way that I have prevent the cfquery from timing out The sit is running on cf8 server in a shared hosting environment I am creating a complex excel spreadsheet using cfxml variable=varname that holds the xml for up to 20 different worksheets created on the fly. Given the volume of records in each worksheet often I generate the error Error Occurred While Processing Request The request has exceeded the allowable time limit Tag: CFQUERY I have tried to specify the timeout value in each query to a large amount of time however the timeout error still generates within 1 minute of the page starting to process the data. I have ensured that I am running queries of queries where possible to prevent unnecessary queries to the sql database however this seems not to have had any effect. If anyone has some suggestion I would be grateful. Regards Claude Raiola (B.Econ Acc; B.Hot. Mngt) Samaris Software Email: i...@samaris.net mailto:i...@trackingcentral.om.au Website: www.SAMARIS.net http://www.TrackingCentral.com.au Mobile: 0414 228 948 -- 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 mailto:cfaussie%2bunsubscr...@googlegroups.com . For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com mailto:cfaussie%2bunsubscr...@googlegroups.com . For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- AJ Mercer http://webonix.net http://twitter.com/webonix -- 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. -- 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] The solution: Odd date behaviour - CF9/SQLServer2005
Gareth (QLD CFUG mgr) and I identified this (dates as strings) as a problem when developing a custom framework right back in CF6.1 days. For my money, the only way to handle this is to strongly type all the data as it moves from one layer to another (inc the DB), starting the string to date conversion as soon as form data is read. LSDateFormat() and other tools are part of a form processing layer before it gets placed in it's first object/CFC. We thought of it as the opposite side to formatting strongly typed data to strings for display (eg: decimals as currency, etc). The only downside to that is optional date values. This means picking up an empty string from the form and replacing it with a sentinal value (eg 1/1/0001) at the form processing layer with a corrosponding piece of logic to convert that to a DBNULL. IMHO the same holds true for numbers, especially decimals. That's one of the many things I like Mark doing with Transfer - he thought of this problem and tried to address it. at least this is what my shattered mind can remember... barry.b uh oh. I can see a CF needs NULL's argument happening ... again ... -- 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] The solution: Odd date behaviour - CF9/SQLServer2005
string to date conversion as soon as form data is read. LSDateFormat() and other tools are part of a form processing layer before it gets FUKIT! dateFormat was for display. One of the Parse()/isDate() functions was used for conversion/replace with sentinal values. I can't remember what it was now. I really must learn to shut the F up while I'm still this broken. No Fun. -- 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] Put Your Group on the Map
Ray keeps rolling out the Picard updates. If you setup your group and put the address in, it will show up here http://groups.adobe.com/index.cfm?event=page.maps Any group managers on here, lets try to get all the ANZ groups on the map. I added the flex one, but it isn't showing yet, so its probably cached. Regards Dale Fraser http://dale.fraser.id.au http://dale.fraser.id.au http://cfmldocs.com/ http://cfmldocs.com http://learncf.com http://learncf.com http://flexcf.com http://flexcf.com -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] Re: Odd date behaviour - CF9/SQLServer2005
Yes quite so, Sean. I'm just saying that it's worked a treat for me for a long time, and I didn't want there to be any sense of criticism of this code generator, or the two people who wrote it. When I look at the code behind the generator, I see that there's logic in the routine that writes getters and setters for date fields so that sometimes it writes the conversion/dateformatting bit and sometimes it doesn't. I guess that's where this issue arose and didnt in previous uses of the generator. Whether the issue is a bug or my use of the generator remains to be seen. That's all i mean by 'lets not label it as guilty just yet'. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Thu, Jun 10, 2010 at 3:13 AM, Sean Corfield seancorfi...@gmail.comwrote: Wow, don't jump to conclusions! I used guilty simply to mean the component that caused the bug you ran into. It's just code, it doesn't have any emotion. -- -- 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.