Re: Can this be improved
On Sat, Dec 1, 2012 at 4:43 PM, Bruce Sorge sor...@gmail.com wrote: I did not use stored procs because I have having issues with making them on MySQL since I am new to the db, so I know that is one improvement that I could make. In addition to casey's comments, I would generally say that using Stored Procs is usually NOT an improvement. they don't usually give you a measurable performance gain, nor a security gain. They just end up making your code less maintainable since you have to maintain things in two places (the DB and CF code) instead of just one place (CF code). They also make your code less portable. ORM, on the other hand, makes your code WAY WAY WAY more portable, and (once you are past the learning curve) much faster to do development and easier to maintain. -Cameron -- Cameron Childress -- p: 678.637.5072 im: cameroncf facebook http://www.facebook.com/cameroncf | twitterhttp://twitter.com/cameronc | google+ https://profiles.google.com/u/0/117829379451708140985 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353336 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CF8 - sending mail via exchange?
Do I need to do anything special or use any of the cfexchange tags in order to send email via a MS Exchange server? Thanks Pete ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353337 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF8 - sending mail via exchange?
Do I need to do anything special or use any of the cfexchange tags in order to send email via a MS Exchange server? No, as long as your Exchange server will accept SMTP mail from your CF server, all you need to use is CFMAIL. Very often, Exchange servers are configured to limit or block SMTP mail that isn't being sent to the domain(s) managed by the Exchange server, though - you may need your Exchange administrator to allow it to relay mail from the IP address of your CF server. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353338 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF8 - sending mail via exchange?
I have had lots of hassle doing this due to restrictions on the exchange server, exchange won't allow you to relay anonymously by default, you must send.via a specific user also you may need to get the sysadmin to allow pop or imap, the default tends to be mapi. Regards Russ Michaels www.michaels.me.uk www.cfmldeveloper.com - Free CFML hosting for developers www.cfsearch.com - CF search engine On Dec 3, 2012 3:30 PM, Pete Ruckelshaus pruckelsh...@gmail.com wrote: Do I need to do anything special or use any of the cfexchange tags in order to send email via a MS Exchange server? Thanks Pete ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353339 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Can this be improved
Hey All, I'm curious as to what is behind statements like Cameron's (not picking on you Cameron.just a good example of what I'm talking about) ORM, on the other hand, makes your code WAY WAY WAY more portable, and (once you are past the learning curve) much faster to do development and easier to maintain. So what is it about ORM that makes this WAY WAY WAY better - defining better along the way of course ;-) I'm asking because EVERY coding efficiency anything I've ever tried (i.e. Ruby on Rails) turned out to be good to a point and then you're painted into a corner needing good old fashioned custom coding to solve the problem. Why is ORM (or ORM with CF) the magic bullet? Simple real life example? Thanks in advance folks -- Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. - makers of FACTS⢠phone: 250.480.0642 cell: 250.920.8830 e-mail: br...@electricedgesystems.com web: www.electricedgesystems.com and www.fisheryfacts.com Please consider the environment before printing this e-mail -CONFIDENTIALITY-- This message, including any attachments, is confidential and may contain information that is privileged or exempt from disclosure. It is intended only for the person to whom it is addressed unless expressly authorized otherwise by the sender. If you are not an authorized recipient, please notify the sender immediately and permanently destroy all copies of this message and attachments. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353340 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
list status
Hey guys, This list has served me well for a number of years but I'd like to unsubscribe... you can't unsubscribe without signing into the houseoffusion site and the forgot password functionality is not working. Does anyone know how to unsub from this list? Thanks ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353341 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: list status
Logging onto the site is the only way that I know of to officially unsubscribe. Of course you could always just create a filter rule to catch anything from HoF and delete it. That would be functionally similar. :-) On Mon, Dec 3, 2012 at 10:43 AM, Dan Baughman dan.baugh...@gmail.comwrote: Hey guys, This list has served me well for a number of years but I'd like to unsubscribe... you can't unsubscribe without signing into the houseoffusion site and the forgot password functionality is not working. Does anyone know how to unsub from this list? Thanks ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353342 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CFWindow Timing Issue
I am incorporating CFWindow and coldfusion.window functions into my site and have them working very well except for one issue. I would like to execute some javascript after the cfwindow fully opens but everything I am doing appears to execute after the popup appears but before the coldfusion page loads into the window. I have tried ajaxonload(), javascript onload, $('#docload').ready(function(), etc. They all seem to execute before the actual end of the process. Is there a way around this? Any help on this would be greatly appreciated. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353343 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
hmailserver Coldfusion
Anyone have any experience, comments using hmailserver with Coldfusion? Terry ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353344 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
write query result to file
Hi! Time-back-way-back, the best/easiest way to write a cfquery result to a file was to use cfwddx. What's the current best/easiest way? (So that it's easy to read the file and re-instantiate the result.) -- John Bliss - http://about.me/jbliss ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353345 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: write query result to file
cfwddx still works, doesn't it? Why not just use it? Sure, XML is a bit fat, but if you just want something quick and dirty, there is no reason not to use it, especially if you are the only reader. Outside of that - look at serializeJSON/deserializeJSON. On Mon, Dec 3, 2012 at 11:26 AM, John M Bliss bliss.j...@gmail.com wrote: Hi! Time-back-way-back, the best/easiest way to write a cfquery result to a file was to use cfwddx. What's the current best/easiest way? (So that it's easy to read the file and re-instantiate the result.) -- John Bliss - http://about.me/jbliss ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353346 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: write query result to file
Perfect. Thanks! On Mon, Dec 3, 2012 at 11:34 AM, Raymond Camden raymondcam...@gmail.comwrote: cfwddx still works, doesn't it? Why not just use it? Sure, XML is a bit fat, but if you just want something quick and dirty, there is no reason not to use it, especially if you are the only reader. Outside of that - look at serializeJSON/deserializeJSON. On Mon, Dec 3, 2012 at 11:26 AM, John M Bliss bliss.j...@gmail.com wrote: Hi! Time-back-way-back, the best/easiest way to write a cfquery result to a file was to use cfwddx. What's the current best/easiest way? (So that it's easy to read the file and re-instantiate the result.) -- John Bliss - http://about.me/jbliss ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353347 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: hmailserver Coldfusion
have used it many times. But what mail server you use is pretty immaterial if the only requirement is an SMTP server as they all work the same. Hmail is fine for a basic smtp server, On Mon, Dec 3, 2012 at 5:19 PM, te...@it-werks.com te...@it-werks.com te...@it-werks.com wrote: Anyone have any experience, comments using hmailserver with Coldfusion? Terry ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353348 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
list of countries and territories
Does anyone have or know of a good list of delimited countries and territories I can use and import into my DB? Thanks ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353349 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFWindow Timing Issue
I am incorporating CFWindow and coldfusion.window functions into my site and have them working very well except for one issue. I would like to execute some javascript after the cfwindow fully opens but everything I am doing appears to execute after the popup appears but before the coldfusion page loads into the window. I have tried ajaxonload(), javascript onload, $('#docload'). ready(function(), etc. They all seem to execute before the actual end of the process. Is there a way around this? Any help on this would be greatly appreciated. I solved the problem by using setTimeout(function(){ insert_javascript_here },0); from within the page I was loading in the popup. Calling an external function was executing at the wrong time, but using setTimeout like this with a timeout of 0 milliseconds works like I needed it to. Hope this helps someone someday. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353350 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Can this be improved
ORM should allow your app to run on any database on any platform (MySQL, MSSQL, Oracle) without you having to change any code. Although it doesn't cover all possible queries you may ever need to write, you may still find some instances where ORM doesn't do what you need. On Mon, Dec 3, 2012 at 4:36 PM, Bryan Stevenson br...@electricedgesystems.com wrote: Hey All, I'm curious as to what is behind statements like Cameron's (not picking on you Cameron.just a good example of what I'm talking about) ORM, on the other hand, makes your code WAY WAY WAY more portable, and (once you are past the learning curve) much faster to do development and easier to maintain. So what is it about ORM that makes this WAY WAY WAY better - defining better along the way of course ;-) I'm asking because EVERY coding efficiency anything I've ever tried (i.e. Ruby on Rails) turned out to be good to a point and then you're painted into a corner needing good old fashioned custom coding to solve the problem. Why is ORM (or ORM with CF) the magic bullet? Simple real life example? Thanks in advance folks -- Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. - makers of FACTS phone: 250.480.0642 cell: 250.920.8830 e-mail: br...@electricedgesystems.com web: www.electricedgesystems.com and www.fisheryfacts.com Please consider the environment before printing this e-mail -CONFIDENTIALITY-- This message, including any attachments, is confidential and may contain information that is privileged or exempt from disclosure. It is intended only for the person to whom it is addressed unless expressly authorized otherwise by the sender. If you are not an authorized recipient, please notify the sender immediately and permanently destroy all copies of this message and attachments. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353351 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: list of countries and territories
http://countrylist.net/ On Mon, Dec 3, 2012 at 6:43 PM, Greg Morphis gmorp...@gmail.com wrote: Does anyone have or know of a good list of delimited countries and territories I can use and import into my DB? Thanks ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353352 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Can this be improved
On Mon, Dec 3, 2012 at 11:36 AM, Bryan Stevenson br...@electricedgesystems.com wrote: So what is it about ORM that makes this WAY WAY WAY better I didn't say better, actually, I said portable Why is ORM (or ORM with CF) the magic bullet? Simple real life example? There is no such thing as a magic bullet. This is the reason we all are employed. I've used ORM in CF for a number of projects, and have used/explored maybe 50% of it's functionality so far. I am by no means an expert, however in my own personal experience.. ORM is good at: - Hibernate makes CRUD drop dead simple. - Your code will be shorter, more consistant - Changes are easier to make in one central place - You can even have Hibernate build your tables for you! Including relationships and indexes! - HQL Will let you drop down to SQL when the ORM entities don't seem to be doing the job alone. ORM is bad at: - Learning curve. The basics are easy. Adding complexity adds er... complexity. - Errors that it throws are sometimes misleading and semi-nonsensical (impacts learning curve) - Things like Self-Joins and more advances functionality can be difficult to figure out. Like any tool in your programming toolbox, you have to know when to use it and when not to. -Cameron -- Cameron Childress -- p: 678.637.5072 im: cameroncf facebook http://www.facebook.com/cameroncf | twitterhttp://twitter.com/cameronc | google+ https://profiles.google.com/u/0/117829379451708140985 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353353 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: list of countries and territories
That is awesome.. thanks Russ! On Mon, Dec 3, 2012 at 1:03 PM, Russ Michaels r...@michaels.me.uk wrote: http://countrylist.net/ On Mon, Dec 3, 2012 at 6:43 PM, Greg Morphis gmorp...@gmail.com wrote: Does anyone have or know of a good list of delimited countries and territories I can use and import into my DB? Thanks ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353354 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: hmailserver Coldfusion
At 12:19 PM 12/3/2012, you wrote: Anyone have any experience, comments using hmailserver with Coldfusion? I use it.. Works nicely. Here is a short snippet that will create a new email address via coldfusion. (the domain must already be set up). cffunction name=createNewEmail access=public returntype=string cfargument name=email type=string required=yes cfargument name=ppassword type=string required=yes cfset status=good cfset subdomain = listlast(email,'@') cftry CFOBJECT ACTION=Create NAME=hmail CLASS=hMailServer.Application cfset temp=hmail.Authenticate(Administrator, *your Admin Password *) cfset domain=hmail.Domains.ItemByName(#subdomain#) cfset account= domain.Accounts.Add() cfset account.Address='#email#' cfset account.Password='#ppassword#' cfset account.Active=True cfset account= Account.Save() cfcatch type=any cfset status='Bad' /cfcatch /cftry cfreturn status /cffunction ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353355 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Can this be improved
Thanks Russ.in my world that is not an issueand I'll stay custom if that's the only benefit. I can re-write T-SQL to PL-SQL in my sleep, but the only place I use PL-SQL is for custom system dev clientsand we are mostly moved to a product based company where our DBs of choice are T-SQL based (thus highly portable to other T-SQL based DBs should the need arise). Thanks for the concrete example Russmuch appreciated. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353356 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Can this be improved
Thanks Cameronand sorry on the portable/better goof ;-) I'd say from what you and Russ have said that there is no urgent need for me to experience the learning curve. I'll swing back and take a peek so I am better informed and give it a fair kick at the can ;-) Cheers On Mon, 2012-12-03 at 14:04 -0500, Cameron Childress wrote: On Mon, Dec 3, 2012 at 11:36 AM, Bryan Stevenson br...@electricedgesystems.com wrote: So what is it about ORM that makes this WAY WAY WAY better I didn't say better, actually, I said portable Why is ORM (or ORM with CF) the magic bullet? Simple real life example? There is no such thing as a magic bullet. This is the reason we all are employed. I've used ORM in CF for a number of projects, and have used/explored maybe 50% of it's functionality so far. I am by no means an expert, however in my own personal experience.. ORM is good at: - Hibernate makes CRUD drop dead simple. - Your code will be shorter, more consistant - Changes are easier to make in one central place - You can even have Hibernate build your tables for you! Including relationships and indexes! - HQL Will let you drop down to SQL when the ORM entities don't seem to be doing the job alone. ORM is bad at: - Learning curve. The basics are easy. Adding complexity adds er... complexity. - Errors that it throws are sometimes misleading and semi-nonsensical (impacts learning curve) - Things like Self-Joins and more advances functionality can be difficult to figure out. Like any tool in your programming toolbox, you have to know when to use it and when not to. -Cameron -- Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. - makers of FACTS⢠phone: 250.480.0642 cell: 250.920.8830 e-mail: br...@electricedgesystems.com web: www.electricedgesystems.com and www.fisheryfacts.com Please consider the environment before printing this e-mail -CONFIDENTIALITY-- This message, including any attachments, is confidential and may contain information that is privileged or exempt from disclosure. It is intended only for the person to whom it is addressed unless expressly authorized otherwise by the sender. If you are not an authorized recipient, please notify the sender immediately and permanently destroy all copies of this message and attachments. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353357 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: list status
I'll look at both the password mechanism as well as unsubscribe you. On Mon, Dec 3, 2012 at 11:43 AM, Dan Baughman dan.baugh...@gmail.comwrote: Hey guys, This list has served me well for a number of years but I'd like to unsubscribe... you can't unsubscribe without signing into the houseoffusion site and the forgot password functionality is not working. Does anyone know how to unsub from this list? Thanks ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353358 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Can this be improved
I would agree...unless it is a really, really complex query that is just killing performance...I try and avoid SP's...they make life so much harder for debugging. I haven't jumped into ORM land yet...it's on the list. Three Ravens Consulting Eric Roberts Owner/Developer ow...@threeravensconsulting.com tel: 630-486-5255 fax: 630-310-8531 http://www.threeravensconsulting.com -Original Message- From: Cameron Childress [mailto:camer...@gmail.com] Sent: Monday, December 03, 2012 9:28 AM To: cf-talk Subject: Re: Can this be improved On Sat, Dec 1, 2012 at 4:43 PM, Bruce Sorge sor...@gmail.com wrote: I did not use stored procs because I have having issues with making them on MySQL since I am new to the db, so I know that is one improvement that I could make. In addition to casey's comments, I would generally say that using Stored Procs is usually NOT an improvement. they don't usually give you a measurable performance gain, nor a security gain. They just end up making your code less maintainable since you have to maintain things in two places (the DB and CF code) instead of just one place (CF code). They also make your code less portable. ORM, on the other hand, makes your code WAY WAY WAY more portable, and (once you are past the learning curve) much faster to do development and easier to maintain. -Cameron -- Cameron Childress -- p: 678.637.5072 im: cameroncf facebook http://www.facebook.com/cameroncf | twitterhttp://twitter.com/cameronc | google+ https://profiles.google.com/u/0/117829379451708140985 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353359 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFWindow Timing Issue
maybe a better approach would be to add cfset ajaxonload('name-of-js-function-to-execute') at the bottom of the page loaded in your cfwindow instance. this way it is guaranteed to run after the cfwindow content is loaded - setTimeout() will delay code execution, but does not guarantee that the code runs after the content is loaded (i.e. due to delay because of network congestion, etc). the downside of using ajaxonload() cf function is - it does not accept any parameters, so you can't pass arguments to the js function it is set to execute. Azadi On Tue, Dec 4, 2012 at 3:44 AM, James Steubing ja...@steubing.net wrote: I am incorporating CFWindow and coldfusion.window functions into my site and have them working very well except for one issue. I would like to execute some javascript after the cfwindow fully opens but everything I am doing appears to execute after the popup appears but before the coldfusion page loads into the window. I have tried ajaxonload(), javascript onload, $('#docload'). ready(function(), etc. They all seem to execute before the actual end of the process. Is there a way around this? Any help on this would be greatly appreciated. I solved the problem by using setTimeout(function(){ insert_javascript_here },0); from within the page I was loading in the popup. Calling an external function was executing at the wrong time, but using setTimeout like this with a timeout of 0 milliseconds works like I needed it to. Hope this helps someone someday. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353360 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm