RE: [ACFUG Discuss] redirect to mobile version using a php page.
One last suggestion - I fully agree with what Howard and Frank wrote. But, before you go doing a lot of work trying to mobilize your site, I would strongly suggest looking in your web logs to determine what type of mobile devices are hitting your site. You can do this in a number of ways - analyze the logs of your own webserver to determine the user client and operating systems being used, get free log analysis software (such as http://awstats.sourceforge.net/) - I'm sure there are others. If you're not opposed to it, google analytics also provides some nice updates for determining what type of mobile browsers are hitting your site. I'd run at least a few weeks worth of analysis to find out the extent of mobile usage on your site. If most people are using smartphones such as iphones or android devices, then you may not need to do a thing. If people are using older flip phone browsers, then you're looking into a whole new set of criteria. Just wanted to say all that so you don't just blindly spend a lot of time, money and resources on something that may not be necessary. Find what's being used the most, get your hands on a couple of those devices, test our site on those and then decide the plan of action. Allen From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of kristine keigan Sent: Tuesday, October 11, 2011 10:06 AM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] redirect to mobile version using a php page. thanks, guys. all good news. With your comments, I feel a lot more confident about my direction for mobilizing my site. Most of my pages won't need to be mobilized and we follow most of the guidelines for phones already (not a lot of javascript, not heavy in manipulating stuff via css although some css is ok and simple html coding. I think the majority of the pages will work just fine, but there is a site we found www.bmobilized.comhttp://www.bmobilized.com that can instantly turn your site into mobile ready only when they are on their phones with an option to have them bounce back to the main site if they want to rather than use the mobilized site. I don't know if we'll use them or another like site, but we're looking into it. Turns out that site is NOT good for login-based sites like my main site, but might work for another site we have for a different business. Thanks again. kristine On Oct 11, 2011, at 1:02 AM, Frank Moorman wrote: I also agree with the thought of not creating a different site... If your site is coded with an eye towards web standards, it should appear decent and functional in any browser. The only real concern for mobile browsers is screen resolution. However, even this should be treated without grouping things as a mobile browser; after all can you tell the difference between a phone and a tablet(which would have a large screen)? My personal thoughts are to only consider screen resolution when creating a website that may be used by mobile browsers. However, even this may be moot because mobile devices usually allow the end-user to zoom. I know for a fact that some of my websites have been used by people on their phone. I do have two words of advice: 1) Avoid extensive javascript (if possible, because that is the most likely to be unsupported); and, 2) Trim your input fields. I noticed that both android and iphone users on my website will tend to have a space added to words that are auto-completed(or spell-corrected) from their phone. On 10/11/2011 12:02 AM, Howard Fore wrote: Keep in mind this article is from 2005. Much of his advice is not at all what I would do (and am doing) today. Is your site templatized? If so, use CFWURFL to sniff the the mobile users and then set a request flag to determine if the users get the mobile or normal templates. I also greatly disagree with the advice to create a standalone site for mobile. This destroys your position in search engines for mobile users. It also pushes the mobile users into a ghetto of different functionality. It's better to treat them as you would a different class of desktop browser (you know...IE). My two cents... Sent from my iPhone On Oct 10, 2011, at 12:34 PM, kristine keigan techsupp...@hirenet.netmailto:techsupp...@hirenet.net wrote: I'm working on making a webpage more friendly for mobile devices. I found this simple step to convert a webpage to mobile friendly with some php. Question isI know nothing about php. Does my server need software? Does it need some sort of utilities or tools in order to run php or can I simply create a php page and have it work just I would an html page? All my pages are .cfm on my own server so I'm wondering if this possible solution will work for us. Here's the article I'm referencing: http://www.mikeindustries.com/blog/archive/2005/07/make-your-site-mobile-friendly kristine
RE: [ACFUG Discuss] redirect to mobile version using a php page.
PHP is a scripting engine like CF - you will need to have PHP installed if you want to run a .php page - however, you could reverse engineer the PHP method and implement a CF way of doing this. Allen -Original Message- From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of kristine keigan Sent: Monday, October 10, 2011 12:34 PM To: discussion@acfug.org Subject: [ACFUG Discuss] redirect to mobile version using a php page. I'm working on making a webpage more friendly for mobile devices. I found this simple step to convert a webpage to mobile friendly with some php. Question isI know nothing about php. Does my server need software? Does it need some sort of utilities or tools in order to run php or can I simply create a php page and have it work just I would an html page? All my pages are .cfm on my own server so I'm wondering if this possible solution will work for us. Here's the article I'm referencing: http://www.mikeindustries.com/blog/archive/2005/07/make-your-site-mobile-friendly kristine - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=gin.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] redirect to mobile version using a php page.
I should have noted though - I don't know if you're on a hosted (shared) server somewhere, but the easy way to test if you can run PHP on your site is to create a simple test.php, put a small chunk of php code in there and run it from the browser. -Original Message- From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of kristine keigan Sent: Monday, October 10, 2011 1:25 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] redirect to mobile version using a php page. thanks. On Oct 10, 2011, at 12:40 PM, axunderw...@ups.com axunderw...@ups.com wrote: PHP is a scripting engine like CF - you will need to have PHP installed if you want to run a .php page - however, you could reverse engineer the PHP method and implement a CF way of doing this. Allen -Original Message- From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of kristine keigan Sent: Monday, October 10, 2011 12:34 PM To: discussion@acfug.org Subject: [ACFUG Discuss] redirect to mobile version using a php page. I'm working on making a webpage more friendly for mobile devices. I found this simple step to convert a webpage to mobile friendly with some php. Question isI know nothing about php. Does my server need software? Does it need some sort of utilities or tools in order to run php or can I simply create a php page and have it work just I would an html page? All my pages are .cfm on my own server so I'm wondering if this possible solution will work for us. Here's the article I'm referencing: http://www.mikeindustries.com/blog/archive/2005/07/make-your-site-mobile-friendly kristine - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=gin.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=gin.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] CFThread name issue
Try one of these two...using the variables scope first cfthread action=RUN name=variables.thread1 cfset thread.myvar = rand() /cfthread cfthread action=JOIN name=variables.thread1/cfthread cfdump var=#variables.thread1.myvar# or, try using a separate structure: cfset myScope = StructNew() / cfthread action=RUN name=myScope.thread1 cfset thread.myvar = rand() /cfthread cfthread action=JOIN name=myScope.thread1/cfthread cfdump var=#myScope.thread1.myvar# From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Mischa Uppelschoten Sent: Thursday, May 26, 2011 10:07 AM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] CFThread name issue Thanks Steve, I understand what you're saying, but unless I missed something, my central question is not answered: how do I refer to a thread (from the spawning code) using a scoped variable? The code you refer to uses unscoped variables, which causes scope hunting. Mischa. Date: Thu, 26 May 2011 08:25:00 -0400 Subject: Re: [ACFUG Discuss] CFThread name issue From: nowhid...@gmail.com To: discussion@acfug.org A thread is a forked process... the whole point of running something in a thread is usually that you what to fire and forget Ie do some batch stuff then email the results. OR you want to fork to multiple threads and have them do the batch in multiple threads (possibly shortening your batch by the number of threads you spawn) If you want to find out how long that thread took to process it you can always cflog the results... the CF docs have an example of doing what you want: http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=Tags_t_04.html On Wed, May 25, 2011 at 5:51 PM, Mischa Uppelschoten mup...@hotmail.commailto:mup...@hotmail.com wrote: I think this is more about naming the thread itself than passing values into it. Let's say I'm not interested in passing values in, or even the outcome of a thread, only how much time it took: cfthread action=RUN name=thread1 !--- long running action with no output here --- /cfthread cfthread action=JOIN name=thread1/cfthread cfoutputThis took #thread1.ElapsedTime# ms./cfoutput How would I code the above and have CF *not* hunt for the scope that thread1 is defined in? From: t...@dynapp.commailto:t...@dynapp.com To: discussion@acfug.orgmailto:discussion@acfug.org Date: Wed, 25 May 2011 16:19:23 -0500 Subject: RE: [ACFUG Discuss] CFThread name issue I'm thinking that when you send something to thread, you have divorced it from the request scope entirely, hence, your inability to reference it as a request scope variable even with a syntactically correct var name. Based on what you're posting, I'd say scoping it into variables would solve the problem, yes? Or am I misunderstanding what you're saying completely? :) Troy Jones ___ Troy Jones | Director of Technical Services | Dynapp Inc | 1-800-830-5192 ext. 603 | dynapp.comhttp://www.dynapp.com/ | facebook.com/dynapphttp://www.facebook.com/dynapp From: ad...@acfug.orgmailto:ad...@acfug.org [mailto:ad...@acfug.orgmailto:ad...@acfug.org] On Behalf Of Mischa Uppelschoten Sent: Wednesday, May 25, 2011 4:13 PM To: discussion@acfug.orgmailto:discussion@acfug.org Subject: RE: [ACFUG Discuss] CFThread name issue That's another way of phrasing my question :-) Stuffing them into a struct works, so it's not some sort of issue w/ dot notation cfthread action=RUN name=MyStruct.thread1 works. From: t...@dynapp.commailto:t...@dynapp.com To: discussion@acfug.orgmailto:discussion@acfug.org Date: Wed, 25 May 2011 15:00:08 -0500 Subject: RE: [ACFUG Discuss] CFThread name issue Can threads be referenced with the request scope? Troy Jones Error! Filename not specified. ___ Troy Jones | Director of Technical Services | Dynapp Inc | 1-800-830-5192 ext. 603 | dynapp.comhttp://www.dynapp.com/ | facebook.com/dynapphttp://www.facebook.com/dynapp From: ad...@acfug.orgmailto:ad...@acfug.org [mailto:ad...@acfug.orgmailto:ad...@acfug.org] On Behalf Of Mischa Uppelschoten Sent: Wednesday, May 25, 2011 3:30 PM To: discussion@acfug.orgmailto:discussion@acfug.org Subject: [ACFUG Discuss] CFThread name issue Running into a headscratcher with cfthread. CF 8 Ent, Win 2k3 This works: cfthread action=RUN name=thread1 cfset thread.myvar = rand() /cfthread cfthread action=JOIN name=thread1/cfthread cfdump var=#thread1.myvar# this throws an error Element THREAD1.MYVAR is undefined in REQUEST: cfthread action=RUN name=request.thread1 cfset thread.myvar = rand() /cfthread cfthread action=JOIN name=request.thread1/cfthread cfdump var=#request.thread1.myvar# What gives? How do I prevent scope
RE: [ACFUG Discuss] CFThread name issue
That is correct, it will hunt for it. I don't remember the exact order, but it does happen. But, that being said, if the second one worked, you now have a scoped thread that you can reference without hunting. It used to be the variables scope was used for all unscoped variables. Doesn't seem to be the case any more but I haven't really paid any attention to it until I saw this thread. If creating a struct and naming the thread as a member of that stuct works, you should be good to go. I will warn though - make sure it also works on CF9 - I've had some things fail that were scoped functions on CF9 with insanely obscure errors (these worked with no problem in CF8). I won't go into detail here unless someone wants to know specifics, but make sure you test on 8 and 9. Allen From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Mischa Uppelschoten Sent: Thursday, May 26, 2011 10:37 AM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] CFThread name issue The first way of naming a thread fails, the second one works, but I was under the impression that unless a variable is *prefixed* with an official scope, like http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=Variables_30.html it is considered unscoped and CF hunts for it when code refers to it? From: axunderw...@ups.com To: discussion@acfug.org Date: Thu, 26 May 2011 10:23:06 -0400 Subject: RE: [ACFUG Discuss] CFThread name issue Try one of these two...using the variables scope first cfthread action=RUN name=variables.thread1 cfset thread.myvar = rand() /cfthread cfthread action=JOIN name=variables.thread1/cfthread cfdump var=#variables.thread1.myvar# or, try using a separate structure: cfset myScope = StructNew() / cfthread action=RUN name=myScope.thread1 cfset thread.myvar = rand() /cfthread cfthread action=JOIN name=myScope.thread1/cfthread cfdump var=#myScope.thread1.myvar# From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Mischa Uppelschoten Sent: Thursday, May 26, 2011 10:07 AM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] CFThread name issue Thanks Steve, I understand what you're saying, but unless I missed something, my central question is not answered: how do I refer to a thread (from the spawning code) using a scoped variable? The code you refer to uses unscoped variables, which causes scope hunting. Mischa. Date: Thu, 26 May 2011 08:25:00 -0400 Subject: Re: [ACFUG Discuss] CFThread name issue From: nowhid...@gmail.com To: discussion@acfug.org A thread is a forked process... the whole point of running something in a thread is usually that you what to fire and forget Ie do some batch stuff then email the results. OR you want to fork to multiple threads and have them do the batch in multiple threads (possibly shortening your batch by the number of threads you spawn) If you want to find out how long that thread took to process it you can always cflog the results... the CF docs have an example of doing what you want: http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=Tags_t_04.html On Wed, May 25, 2011 at 5:51 PM, Mischa Uppelschoten mup...@hotmail.commailto:mup...@hotmail.com wrote: I think this is more about naming the thread itself than passing values into it. Let's say I'm not interested in passing values in, or even the outcome of a thread, only how much time it took: cfthread action=RUN name=thread1 !--- long running action with no output here --- /cfthread cfthread action=JOIN name=thread1/cfthread cfoutputThis took #thread1.ElapsedTime# ms./cfoutput How would I code the above and have CF *not* hunt for the scope that thread1 is defined in? From: t...@dynapp.commailto:t...@dynapp.com To: discussion@acfug.orgmailto:discussion@acfug.org Date: Wed, 25 May 2011 16:19:23 -0500 Subject: RE: [ACFUG Discuss] CFThread name issue I'm thinking that when you send something to thread, you have divorced it from the request scope entirely, hence, your inability to reference it as a request scope variable even with a syntactically correct var name. Based on what you're posting, I'd say scoping it into variables would solve the problem, yes? Or am I misunderstanding what you're saying completely? :) Troy Jones ___ Troy Jones | Director of Technical Services | Dynapp Inc | 1-800-830-5192 ext. 603 | dynapp.comhttp://www.dynapp.com/ | facebook.com/dynapphttp://www.facebook.com/dynapp From: ad...@acfug.orgmailto:ad...@acfug.org [mailto:ad...@acfug.orgmailto:ad...@acfug.org] On Behalf Of Mischa Uppelschoten Sent: Wednesday, May 25, 2011 4:13 PM To: discussion@acfug.orgmailto:discussion@acfug.org Subject: RE: [ACFUG Discuss] CFThread name issue That's another
RE: [ACFUG Discuss] CFThread name issue
I haven't looked at that in a long time...I'm not sure how that works with structures. My guess would be that if CF sees a dot in the dot-notation, that it will just look for that structure, but I'm not 100% certain of that. Allen From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Mischa Uppelschoten Sent: Thursday, May 26, 2011 11:23 AM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] CFThread name issue Thanks Allen. Regarding But, that being said, if the second one worked, you now have a scoped thread that you can reference without hunting. Do I understand correctly that cfset myScope = StructNew() / cfset myScope.MyNewVar = bla cfoutput#myScope.MyNewVar#/cfoutput Is considered scoping a variable? I thought it had to be prefixed with request. or variables.? I would think that if you have a udf on your page named MyScope that returns a structure with a key named MyNewVar, that that would take precedence, per http://help.adobe.com/en_US/ColdFusion/9.0/Developing/WSc3ff6d0ea77859461172e0811cbec09af4-7fdf.html ? From: axunderw...@ups.com To: discussion@acfug.org Date: Thu, 26 May 2011 10:49:49 -0400 Subject: RE: [ACFUG Discuss] CFThread name issue That is correct, it will hunt for it. I don't remember the exact order, but it does happen. But, that being said, if the second one worked, you now have a scoped thread that you can reference without hunting. It used to be the variables scope was used for all unscoped variables. Doesn't seem to be the case any more but I haven't really paid any attention to it until I saw this thread. If creating a struct and naming the thread as a member of that stuct works, you should be good to go. I will warn though - make sure it also works on CF9 - I've had some things fail that were scoped functions on CF9 with insanely obscure errors (these worked with no problem in CF8). I won't go into detail here unless someone wants to know specifics, but make sure you test on 8 and 9. Allen From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Mischa Uppelschoten Sent: Thursday, May 26, 2011 10:37 AM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] CFThread name issue The first way of naming a thread fails, the second one works, but I was under the impression that unless a variable is *prefixed* with an official scope, like http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=Variables_30.html it is considered unscoped and CF hunts for it when code refers to it? From: axunderw...@ups.com To: discussion@acfug.org Date: Thu, 26 May 2011 10:23:06 -0400 Subject: RE: [ACFUG Discuss] CFThread name issue Try one of these two...using the variables scope first cfthread action=RUN name=variables.thread1 cfset thread.myvar = rand() /cfthread cfthread action=JOIN name=variables.thread1/cfthread cfdump var=#variables.thread1.myvar# or, try using a separate structure: cfset myScope = StructNew() / cfthread action=RUN name=myScope.thread1 cfset thread.myvar = rand() /cfthread cfthread action=JOIN name=myScope.thread1/cfthread cfdump var=#myScope.thread1.myvar# From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Mischa Uppelschoten Sent: Thursday, May 26, 2011 10:07 AM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] CFThread name issue Thanks Steve, I understand what you're saying, but unless I missed something, my central question is not answered: how do I refer to a thread (from the spawning code) using a scoped variable? The code you refer to uses unscoped variables, which causes scope hunting. Mischa. Date: Thu, 26 May 2011 08:25:00 -0400 Subject: Re: [ACFUG Discuss] CFThread name issue From: nowhid...@gmail.com To: discussion@acfug.org A thread is a forked process... the whole point of running something in a thread is usually that you what to fire and forget Ie do some batch stuff then email the results. OR you want to fork to multiple threads and have them do the batch in multiple threads (possibly shortening your batch by the number of threads you spawn) If you want to find out how long that thread took to process it you can always cflog the results... the CF docs have an example of doing what you want: http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=Tags_t_04.html On Wed, May 25, 2011 at 5:51 PM, Mischa Uppelschoten mup...@hotmail.commailto:mup...@hotmail.com wrote: I think this is more about naming the thread itself than passing values into it. Let's say I'm not interested in passing values in, or even the outcome of a thread, only how much time it took: cfthread action=RUN name=thread1 !--- long running action with no output here --- /cfthread cfthread action=JOIN name=thread1/cfthread cfoutputThis took #thread1.ElapsedTime# ms./cfoutput
RE: [ACFUG Discuss] Error Handling and CF8
:-) That's not uncommon...each Application.cfm or Application.cfc can be used for separate applications, or can be used to help keep directories from being secured, etc. It's just part of the CF framework - wouldn't call it a mess just because there's multiple of them! Might be that it is a mess, but, multiple Application files definitely have their place. Allen From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Matthew Nicholson Sent: Friday, March 11, 2011 3:22 PM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] Error Handling and CF8 Ah Ha! Looks as though I was barking up the wrong Application.cfm… I’ve found one that’s not encrypted and is apparently being used by my application mixed in all the source that I hadn’t noticed before. How many of these “Application.cfm” files are typically built into a single CF server? Oddly enough, I’ve found about 8 on this box. What a mess… Matthew R. Nicholson From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Mark Bureau Sent: Friday, March 11, 2011 3:17 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] Error Handling and CF8 looks like it might be encrypted. From: Matthew Nicholsonmailto:matthew.nichol...@soltech.net Sent: Friday, March 11, 2011 3:08 PM To: discussion@acfug.orgmailto:discussion@acfug.org Subject: [ACFUG Discuss] Error Handling and CF8 Afternoon All! I’m trying to setup error handling for our production environment to be more sophisticated then explosion followed by a crash and burn. With that, I’ve been able to find a wealth of tutorials on how to set templates and all sorts of other goodies but a majority of them require me to modify the Application.cfm or Application.cfc. My server(s) are all running vanilla CF8 and only use the Application.cfm. However, I’m unable to modify the file, I get a whole bunch of goop (with an example below) when I attempt to modify the file in just about every editor I have access to. Example: N P ¶¢**´ Is it encrypted? Am I being thick? Any direction would be greatly appreciated as always! Thanks! Matthew R. Nicholson - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLinkhttp://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLinkhttp://www.fusionlink.com - n��N�r��yb�X��f�j���鮇j�~m�~�(�ږ���b����+�m�~�(�ږ���b����+�Ţ�~�y�ky�m q?x%��l��i��0��� +X��Xn�+r�y�ky�m j)Z��b��(��b�ˬ�*'�F�~�(����� 0���j�!o݊�.�Ȩ��q?���.+-��-y��j�~m��*'�)�r���Ȩ
RE: [ACFUG Discuss] Error Handling and CF8
Well, here's a quick tip for you - you mentioned you only searched for Application.cfm files, you might want to include Application.cfc to that search. Application.cfc is the newer version of Application.cfm and has many more events that can be handled at page/application load times. You might have several of those floating around where you'll want to put in your error handling. From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Matthew Nicholson Sent: Friday, March 11, 2011 3:31 PM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] Error Handling and CF8 Excellent point! I’ll admit, I’m still quite new to working with CF and coming behind a number of developers onto a project with a less than ideal documentation policy… well… you get the idea… :) Thankfully, I love a good challenge. :D Matthew R. Nicholson From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of axunderw...@ups.com Sent: Friday, March 11, 2011 3:25 PM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] Error Handling and CF8 :-) That's not uncommon...each Application.cfm or Application.cfc can be used for separate applications, or can be used to help keep directories from being secured, etc. It's just part of the CF framework - wouldn't call it a mess just because there's multiple of them! Might be that it is a mess, but, multiple Application files definitely have their place. Allen From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Matthew Nicholson Sent: Friday, March 11, 2011 3:22 PM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] Error Handling and CF8 Ah Ha! Looks as though I was barking up the wrong Application.cfm… I’ve found one that’s not encrypted and is apparently being used by my application mixed in all the source that I hadn’t noticed before. How many of these “Application.cfm” files are typically built into a single CF server? Oddly enough, I’ve found about 8 on this box. What a mess… Matthew R. Nicholson From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Mark Bureau Sent: Friday, March 11, 2011 3:17 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] Error Handling and CF8 looks like it might be encrypted. From: Matthew Nicholsonmailto:matthew.nichol...@soltech.net Sent: Friday, March 11, 2011 3:08 PM To: discussion@acfug.orgmailto:discussion@acfug.org Subject: [ACFUG Discuss] Error Handling and CF8 Afternoon All! I’m trying to setup error handling for our production environment to be more sophisticated then explosion followed by a crash and burn. With that, I’ve been able to find a wealth of tutorials on how to set templates and all sorts of other goodies but a majority of them require me to modify the Application.cfm or Application.cfc. My server(s) are all running vanilla CF8 and only use the Application.cfm. However, I’m unable to modify the file, I get a whole bunch of goop (with an example below) when I attempt to modify the file in just about every editor I have access to. Example: N P ¶¢**´ Is it encrypted? Am I being thick? Any direction would be greatly appreciated as always! Thanks! Matthew R. Nicholson - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLinkhttp://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLinkhttp://www.fusionlink.com - n��N�r��yb�X��f�j���鮇j�~m�~�(�ږ���b��‑��+�m�~�(�ږ���b��‑��+�Ţ�~�‑y�ky�m q?x%��l��i��0��� +X��Xn�+r�y�ky�m j)Z��b��(��b�ˬ�*'�F�~�(� 0���j�!o݊�.�Ȩ��q?���.+-��-y��j�~m��*'�)�r���Ȩ nNrybXfj鮇j| qhvi �n���{.n�+���+%��fjv�{*.���~)^n���� 0i��}�h�)�v+n��ߢ� 0i��}�h�)�v+n��ߢ��i�۬Z+��ފw��皆i��0��� +X��X���m q?x%��l����!i��0�f���܆+�r��v+���~4i���m ��V�r�y��جr�,���ѧ� +���nh�םo��� 0~��yb�G(�[���ˊy?i� N�r��yb�X��f�j���鮇���mq
RE: [ACFUG Discuss] help with where to start trouble shooting an error
More than likely it is a trigger or something along those lines because that's a vanilla insert statement below (that could use some help to avoid some sql injection). Take a look at the folder_ka table to see if there are any triggers/constraints on the table From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Steve Ross Sent: Thursday, January 20, 2011 2:49 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] help with where to start trouble shooting an error Export the query to a string and run it in SQL Manager and see what it gives you On Thu, Jan 20, 2011 at 2:46 PM, Jeff Howard jeh...@gmail.commailto:jeh...@gmail.com wrote: The code that is causing the issue is a simple insert query, cfquery name=new_folder_ka datasource=#request.DSN# insert into folder_ka (name, Template_ID, Content_Sort_Order, description, created_by, parent, levels, owner_id, show_disc_links, show_FinancialData_links, show_InputSheet_links, create_date, last_update, cfif isDefined('form.timeframe') AND Len(Trim(form.timeframe)) checkout_timeframe, /cfif cfif isDefined('form.check_email') checkin_email, /cfif exclude_Search, exclude_myPage, Next_EmailAlert, show_history_all) values ( '#form.folder_ka_name#', cfif isDefined('form.Template_ID')#Val(form.Template_ID)#CFELSENULL/CFIF, '#form.Content_Sort_Order#', '#variables.description#', #variables.user_id#, #Val(form.parent_id)#, #variables.this_level#,#form.content_manager#, CFIF isDefined('form.show_disc_links')1CFELSE0/CFIF, CFIF isDefined('form.show_FinancialData_links')1CFELSE0/CFIF, CFIF isDefined('form.show_InputSheet_links')1CFELSE0/CFIF, getdate(), getdate() cfif isDefined('form.timeframe') AND Len(Trim(form.timeframe)) , #form.timeframe# /cfif cfif isDefined('form.check_email') AND Len(Trim(form.check_email)) , #form.check_email# /cfif ,CFIF isDefined('form.exclude_Search')1CFELSE0/CFIF ,CFIF isDefined('form.exclude_myPage')1CFELSE0/CFIF ,CFIF isDefined('form.Next_EmailAlert')1CFELSE0/CFIF cfif IsDefined(form.history) , 1) cfelse , 0) /cfif /cfquery It doesn't appear that a stored proc is involved unless maybe there is a trigger I'm unaware of. Thoughts? Thanks again, Jeff On Thu, Jan 20, 2011 at 2:37 PM, Teddy R. Payne teddyrpa...@gmail.commailto:teddyrpa...@gmail.com wrote: Jeff, In the SQL Server realm, a cursor is typical of a stored procedure that has a loop structure. Without using while loops and table variables, cursors used to be the defacto way to loop over logic in complex stored procedures. Teddy R. Payne, ACCFD Google Talk - teddyrpa...@gmail.commailto:teddyrpa...@gmail.com On Thu, Jan 20, 2011 at 2:34 PM, Jeff Howard jeh...@gmail.commailto:jeh...@gmail.com wrote: Hey all, I've got a client that I do some maintenance work for on a VERY old CF site. They have a CMS that is throwing an error when trying to add content. The servers have changed, the databases have been updated, the system runs across 3 different servers so I'm not sure where along the way the system broke I am getting the following error message on a server running CFMX7 and I believe MSSQL that was recently updated from 2003 to 2005 (possibly 2008): Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Could not complete cursor operation because the set options have changed since the cursor was declared. Any ideas on where to begin with this and possible culprits? Thanks in advance, Jeff -- Steve Ross web application interface developer http://blog.stevensross.com [mobile] (912) 344-8113 [ AIM / Yahoo! : zeriumsteven ] [googleTalk : nowhiding ] - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] help with where to start trouble shooting an error
Try this out (if it's sql server 2005 or up) select * from sys.triggers where parent_id = (select object_id from sys.objects where name = 'folder_ka' and type = 'u') That would tell you if there's any triggers on the table (assuming you have rights to query the sys schema). Allen From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Jeff Howard Sent: Thursday, January 20, 2011 3:02 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] help with where to start trouble shooting an error Thanks. I'm working on getting the db credentials now to run the exact query that is being displayed in the CF error message to test. Yes, the code could use some help. This is behind some authentication but this application is about 8 years old and if I started trying to bring it up to best practices I'd end up rebuilding the entire app. On Thu, Jan 20, 2011 at 2:53 PM, axunderw...@ups.commailto:axunderw...@ups.com wrote: More than likely it is a trigger or something along those lines because that's a vanilla insert statement below (that could use some help to avoid some sql injection). Take a look at the folder_ka table to see if there are any triggers/constraints on the table From: ad...@acfug.orgmailto:ad...@acfug.org [mailto:ad...@acfug.orgmailto:ad...@acfug.org] On Behalf Of Steve Ross Sent: Thursday, January 20, 2011 2:49 PM To: discussion@acfug.orgmailto:discussion@acfug.org Subject: Re: [ACFUG Discuss] help with where to start trouble shooting an error Export the query to a string and run it in SQL Manager and see what it gives you On Thu, Jan 20, 2011 at 2:46 PM, Jeff Howard jeh...@gmail.commailto:jeh...@gmail.com wrote: The code that is causing the issue is a simple insert query, cfquery name=new_folder_ka datasource=#request.DSN# insert into folder_ka (name, Template_ID, Content_Sort_Order, description, created_by, parent, levels, owner_id, show_disc_links, show_FinancialData_links, show_InputSheet_links, create_date, last_update, cfif isDefined('form.timeframe') AND Len(Trim(form.timeframe)) checkout_timeframe, /cfif cfif isDefined('form.check_email') checkin_email, /cfif exclude_Search, exclude_myPage, Next_EmailAlert, show_history_all) values ( '#form.folder_ka_name#', cfif isDefined('form.Template_ID')#Val(form.Template_ID)#CFELSENULL/CFIF, '#form.Content_Sort_Order#', '#variables.description#', #variables.user_id#, #Val(form.parent_id)#, #variables.this_level#,#form.content_manager#, CFIF isDefined('form.show_disc_links')1CFELSE0/CFIF, CFIF isDefined('form.show_FinancialData_links')1CFELSE0/CFIF, CFIF isDefined('form.show_InputSheet_links')1CFELSE0/CFIF, getdate(), getdate() cfif isDefined('form.timeframe') AND Len(Trim(form.timeframe)) , #form.timeframe# /cfif cfif isDefined('form.check_email') AND Len(Trim(form.check_email)) , #form.check_email# /cfif ,CFIF isDefined('form.exclude_Search')1CFELSE0/CFIF ,CFIF isDefined('form.exclude_myPage')1CFELSE0/CFIF ,CFIF isDefined('form.Next_EmailAlert')1CFELSE0/CFIF cfif IsDefined(form.history) , 1) cfelse , 0) /cfif /cfquery It doesn't appear that a stored proc is involved unless maybe there is a trigger I'm unaware of. Thoughts? Thanks again, Jeff On Thu, Jan 20, 2011 at 2:37 PM, Teddy R. Payne teddyrpa...@gmail.commailto:teddyrpa...@gmail.com wrote: Jeff, In the SQL Server realm, a cursor is typical of a stored procedure that has a loop structure. Without using while loops and table variables, cursors used to be the defacto way to loop over logic in complex stored procedures. Teddy R. Payne, ACCFD Google Talk - teddyrpa...@gmail.commailto:teddyrpa...@gmail.com On Thu, Jan 20, 2011 at 2:34 PM, Jeff Howard jeh...@gmail.commailto:jeh...@gmail.com wrote: Hey all, I've got a client that I do some maintenance work for on a VERY old CF site. They have a CMS that is throwing an error when trying to add content. The servers have changed, the databases have been updated, the system runs across 3 different servers so I'm not sure where along the way the system broke I am getting the following error message on a server running CFMX7 and I believe MSSQL that was recently updated from 2003 to 2005 (possibly 2008): Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Could not complete cursor operation because the set options have changed since the cursor was declared. Any ideas on where to begin with this and possible culprits? Thanks in advance, Jeff -- Steve Ross web application interface developer http://blog.stevensross.comhttp://blog.stevensross.com/ [mobile] (912) 344-8113 [ AIM / Yahoo! : zeriumsteven ] [googleTalk : nowhiding ] - To unsubscribe from this list, manage your profile @
RE: [ACFUG Discuss] help with where to start trouble shooting an error
Now you need to look at Folder_KA_Tree to see what triggers it has, and then take a look at the proc Get_Next_branch... From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Jeff Howard Sent: Thursday, January 20, 2011 3:47 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] help with where to start trouble shooting an error Ok, I'm in the db and there is one trigger and 5 constraints. I get the exact same error message when running the query in Mgmt Studio. Any tips on figuring out which of the 6 could be causing the issue? This is the trigger if it helps: SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER TRIGGER [dbo].[xx] ON [dbo].[Folder_Ka] FOR INSERT,UPDATE AS IF UPDATE ( Parent ) BEGIN DELETE FROM Folder_KA_Tree EXECUTE Get_Next_Branch @xxID = 0 END On Thu, Jan 20, 2011 at 3:30 PM, axunderw...@ups.commailto:axunderw...@ups.com wrote: Try this out (if it's sql server 2005 or up) select * from sys.triggers where parent_id = (select object_id from sys.objects where name = 'folder_ka' and type = 'u') That would tell you if there's any triggers on the table (assuming you have rights to query the sys schema). Allen From: ad...@acfug.orgmailto:ad...@acfug.org [mailto:ad...@acfug.orgmailto:ad...@acfug.org] On Behalf Of Jeff Howard Sent: Thursday, January 20, 2011 3:02 PM To: discussion@acfug.orgmailto:discussion@acfug.org Subject: Re: [ACFUG Discuss] help with where to start trouble shooting an error Thanks. I'm working on getting the db credentials now to run the exact query that is being displayed in the CF error message to test. Yes, the code could use some help. This is behind some authentication but this application is about 8 years old and if I started trying to bring it up to best practices I'd end up rebuilding the entire app. On Thu, Jan 20, 2011 at 2:53 PM, axunderw...@ups.commailto:axunderw...@ups.com wrote: More than likely it is a trigger or something along those lines because that's a vanilla insert statement below (that could use some help to avoid some sql injection). Take a look at the folder_ka table to see if there are any triggers/constraints on the table From: ad...@acfug.orgmailto:ad...@acfug.org [mailto:ad...@acfug.orgmailto:ad...@acfug.org] On Behalf Of Steve Ross Sent: Thursday, January 20, 2011 2:49 PM To: discussion@acfug.orgmailto:discussion@acfug.org Subject: Re: [ACFUG Discuss] help with where to start trouble shooting an error Export the query to a string and run it in SQL Manager and see what it gives you On Thu, Jan 20, 2011 at 2:46 PM, Jeff Howard jeh...@gmail.commailto:jeh...@gmail.com wrote: The code that is causing the issue is a simple insert query, cfquery name=new_folder_ka datasource=#request.DSN# insert into folder_ka (name, Template_ID, Content_Sort_Order, description, created_by, parent, levels, owner_id, show_disc_links, show_FinancialData_links, show_InputSheet_links, create_date, last_update, cfif isDefined('form.timeframe') AND Len(Trim(form.timeframe)) checkout_timeframe, /cfif cfif isDefined('form.check_email') checkin_email, /cfif exclude_Search, exclude_myPage, Next_EmailAlert, show_history_all) values ( '#form.folder_ka_name#', cfif isDefined('form.Template_ID')#Val(form.Template_ID)#CFELSENULL/CFIF, '#form.Content_Sort_Order#', '#variables.description#', #variables.user_id#, #Val(form.parent_id)#, #variables.this_level#,#form.content_manager#, CFIF isDefined('form.show_disc_links')1CFELSE0/CFIF, CFIF isDefined('form.show_FinancialData_links')1CFELSE0/CFIF, CFIF isDefined('form.show_InputSheet_links')1CFELSE0/CFIF, getdate(), getdate() cfif isDefined('form.timeframe') AND Len(Trim(form.timeframe)) , #form.timeframe# /cfif cfif isDefined('form.check_email') AND Len(Trim(form.check_email)) , #form.check_email# /cfif ,CFIF isDefined('form.exclude_Search')1CFELSE0/CFIF ,CFIF isDefined('form.exclude_myPage')1CFELSE0/CFIF ,CFIF isDefined('form.Next_EmailAlert')1CFELSE0/CFIF cfif IsDefined(form.history) , 1) cfelse , 0) /cfif /cfquery It doesn't appear that a stored proc is involved unless maybe there is a trigger I'm unaware of. Thoughts? Thanks again, Jeff On Thu, Jan 20, 2011 at 2:37 PM, Teddy R. Payne teddyrpa...@gmail.commailto:teddyrpa...@gmail.com wrote: Jeff, In the SQL Server realm, a cursor is typical of a stored procedure that has a loop structure. Without using while loops and table variables, cursors used to be the defacto way to loop over logic in complex stored procedures. Teddy R. Payne, ACCFD Google Talk - teddyrpa...@gmail.commailto:teddyrpa...@gmail.com On Thu, Jan 20, 2011 at 2:34 PM, Jeff Howard jeh...@gmail.commailto:jeh...@gmail.com wrote: Hey all, I've got a client that I do some maintenance work for on a VERY old CF site. They have a CMS that is
RE: [ACFUG Discuss] help with where to start trouble shooting an error
Yup, that proc has a cursor in it - look at the FETCH statement.. More than likely it's this statement below: EXECUTE Folder_Child_List @Folder_KA_ID, @Cursor_Child_List OUTPUT Looking at that, you've already declared and opened the cursor, and now it's calling another stored proc. My hunch is that the proc FOLDER_CHILD_LIST has a SET NOCOUNT in there that's messing the cursor up... Check into that From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Jeff Howard Sent: Thursday, January 20, 2011 4:02 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] help with where to start trouble shooting an error No constraints or triggers on Folder_KA_Tree and here is the SP that is called by the trigger: SET ANSI_NULLS OFF GO SET QUOTED_IDENTIFIER OFF GO ALTER PROCEDURE [dbo].[Get_Next_Branch] ( @Folder_KA_ID Int ) AS SET NOCOUNT ON -- Add The Data Into The Return Table For This Record INSERT INTO Folder_KA_Tree (Folder_KA_ID, Tree_Path) SELECT F.Folder_Ka_ID, dbo.getFolderTreePath(@Folder_KA_ID) FROM Folder_Ka F WHERE F.Soft_DELETE IS NULL AND F.Folder_Ka_ID = @Folder_KA_ID DECLARE @Cursor_Child_List CURSOR DECLARE @thisFolder_ID numeric(18, 0) EXECUTE Folder_Child_List @Folder_KA_ID, @Cursor_Child_List OUTPUT FETCH NEXT FROM @Cursor_Child_List INTO @thisFolder_ID WHILE (@@FETCH_Status = 0) BEGIN -- Get Tree From This Folder Down EXECUTE Get_Next_Branch @thisFolder_ID FETCH NEXT FROM @Cursor_Child_List INTO @thisFolder_ID END -- Close the cursor. CLOSE @Cursor_Child_List -- Deallocate the cursor. DEALLOCATE @Cursor_Child_List SET NOCOUNT OFF RETURN Thoughts? On Thu, Jan 20, 2011 at 3:57 PM, axunderw...@ups.commailto:axunderw...@ups.com wrote: Now you need to look at Folder_KA_Tree to see what triggers it has, and then take a look at the proc Get_Next_branch... From: ad...@acfug.orgmailto:ad...@acfug.org [mailto:ad...@acfug.orgmailto:ad...@acfug.org] On Behalf Of Jeff Howard Sent: Thursday, January 20, 2011 3:47 PM To: discussion@acfug.orgmailto:discussion@acfug.org Subject: Re: [ACFUG Discuss] help with where to start trouble shooting an error Ok, I'm in the db and there is one trigger and 5 constraints. I get the exact same error message when running the query in Mgmt Studio. Any tips on figuring out which of the 6 could be causing the issue? This is the trigger if it helps: SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER TRIGGER [dbo].[xx] ON [dbo].[Folder_Ka] FOR INSERT,UPDATE AS IF UPDATE ( Parent ) BEGIN DELETE FROM Folder_KA_Tree EXECUTE Get_Next_Branch @xxID = 0 END On Thu, Jan 20, 2011 at 3:30 PM, axunderw...@ups.commailto:axunderw...@ups.com wrote: Try this out (if it's sql server 2005 or up) select * from sys.triggers where parent_id = (select object_id from sys.objects where name = 'folder_ka' and type = 'u') That would tell you if there's any triggers on the table (assuming you have rights to query the sys schema). Allen From: ad...@acfug.orgmailto:ad...@acfug.org [mailto:ad...@acfug.orgmailto:ad...@acfug.org] On Behalf Of Jeff Howard Sent: Thursday, January 20, 2011 3:02 PM To: discussion@acfug.orgmailto:discussion@acfug.org Subject: Re: [ACFUG Discuss] help with where to start trouble shooting an error Thanks. I'm working on getting the db credentials now to run the exact query that is being displayed in the CF error message to test. Yes, the code could use some help. This is behind some authentication but this application is about 8 years old and if I started trying to bring it up to best practices I'd end up rebuilding the entire app. On Thu, Jan 20, 2011 at 2:53 PM, axunderw...@ups.commailto:axunderw...@ups.com wrote: More than likely it is a trigger or something along those lines because that's a vanilla insert statement below (that could use some help to avoid some sql injection). Take a look at the folder_ka table to see if there are any triggers/constraints on the table From: ad...@acfug.orgmailto:ad...@acfug.org [mailto:ad...@acfug.orgmailto:ad...@acfug.org] On Behalf Of Steve Ross Sent: Thursday, January 20, 2011 2:49 PM To: discussion@acfug.orgmailto:discussion@acfug.org Subject: Re: [ACFUG Discuss] help with where to start trouble shooting an error Export the query to a string and run it in SQL Manager and see what it gives you On Thu, Jan 20, 2011 at 2:46 PM, Jeff Howard jeh...@gmail.commailto:jeh...@gmail.com wrote: The code that is causing the issue is a simple insert query, cfquery name=new_folder_ka datasource=#request.DSN# insert into folder_ka (name, Template_ID, Content_Sort_Order, description, created_by, parent, levels, owner_id, show_disc_links, show_FinancialData_links, show_InputSheet_links, create_date, last_update, cfif isDefined('form.timeframe') AND Len(Trim(form.timeframe))
RE: [ACFUG Discuss] help with where to start trouble shooting an error
For the time being to try it out - just comment out all the SET operations...try it out and see if it works...this isn't a great solution because the JDBC driver that you're using is real picky about sql server and the count reporting. It can crop up in weird ways...but just as a test, comment the sets for now...then let us know. From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Jeff Howard Sent: Thursday, January 20, 2011 4:18 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] help with where to start trouble shooting an error You are correct and make me feel like I'm getting closer to actually resolving this (thank you). I actually thought I was fairly proficient with SQL Server until trying to debug this. I tried removing the NOCOUNT and setting it to OFF but no luck. Here is the SP with the NOCOUNT: SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[Folder_Child_List] ( @thisParent numeric(18,0), @Folder_List_Cursor CURSOR VARYING OUTPUT ) AS SET NOCOUNT ON SET @Folder_List_Cursor = CURSOR FOR SELECT F.Folder_Ka_ID FROM Folder_Ka F WHERE F.Soft_DELETE IS NULL AND F.Parent = @thisParent ORDER BY F.Priority_Display, F.Name -- Populate the cursor. OPEN @Folder_list_cursor RETURN On Thu, Jan 20, 2011 at 4:07 PM, axunderw...@ups.commailto:axunderw...@ups.com wrote: Yup, that proc has a cursor in it - look at the FETCH statement.. More than likely it's this statement below: EXECUTE Folder_Child_List @Folder_KA_ID, @Cursor_Child_List OUTPUT Looking at that, you've already declared and opened the cursor, and now it's calling another stored proc. My hunch is that the proc FOLDER_CHILD_LIST has a SET NOCOUNT in there that's messing the cursor up... Check into that From: ad...@acfug.orgmailto:ad...@acfug.org [mailto:ad...@acfug.orgmailto:ad...@acfug.org] On Behalf Of Jeff Howard Sent: Thursday, January 20, 2011 4:02 PM To: discussion@acfug.orgmailto:discussion@acfug.org Subject: Re: [ACFUG Discuss] help with where to start trouble shooting an error No constraints or triggers on Folder_KA_Tree and here is the SP that is called by the trigger: SET ANSI_NULLS OFF GO SET QUOTED_IDENTIFIER OFF GO ALTER PROCEDURE [dbo].[Get_Next_Branch] ( @Folder_KA_ID Int ) AS SET NOCOUNT ON -- Add The Data Into The Return Table For This Record INSERT INTO Folder_KA_Tree (Folder_KA_ID, Tree_Path) SELECT F.Folder_Ka_ID, dbo.getFolderTreePath(@Folder_KA_ID) FROM Folder_Ka F WHERE F.Soft_DELETE IS NULL AND F.Folder_Ka_ID = @Folder_KA_ID DECLARE @Cursor_Child_List CURSOR DECLARE @thisFolder_ID numeric(18, 0) EXECUTE Folder_Child_List @Folder_KA_ID, @Cursor_Child_List OUTPUT FETCH NEXT FROM @Cursor_Child_List INTO @thisFolder_ID WHILE (@@FETCH_Status = 0) BEGIN -- Get Tree From This Folder Down EXECUTE Get_Next_Branch @thisFolder_ID FETCH NEXT FROM @Cursor_Child_List INTO @thisFolder_ID END -- Close the cursor. CLOSE @Cursor_Child_List -- Deallocate the cursor. DEALLOCATE @Cursor_Child_List SET NOCOUNT OFF RETURN Thoughts? On Thu, Jan 20, 2011 at 3:57 PM, axunderw...@ups.commailto:axunderw...@ups.com wrote: Now you need to look at Folder_KA_Tree to see what triggers it has, and then take a look at the proc Get_Next_branch... From: ad...@acfug.orgmailto:ad...@acfug.org [mailto:ad...@acfug.orgmailto:ad...@acfug.org] On Behalf Of Jeff Howard Sent: Thursday, January 20, 2011 3:47 PM To: discussion@acfug.orgmailto:discussion@acfug.org Subject: Re: [ACFUG Discuss] help with where to start trouble shooting an error Ok, I'm in the db and there is one trigger and 5 constraints. I get the exact same error message when running the query in Mgmt Studio. Any tips on figuring out which of the 6 could be causing the issue? This is the trigger if it helps: SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER TRIGGER [dbo].[xx] ON [dbo].[Folder_Ka] FOR INSERT,UPDATE AS IF UPDATE ( Parent ) BEGIN DELETE FROM Folder_KA_Tree EXECUTE Get_Next_Branch @xxID = 0 END On Thu, Jan 20, 2011 at 3:30 PM, axunderw...@ups.commailto:axunderw...@ups.com wrote: Try this out (if it's sql server 2005 or up) select * from sys.triggers where parent_id = (select object_id from sys.objects where name = 'folder_ka' and type = 'u') That would tell you if there's any triggers on the table (assuming you have rights to query the sys schema). Allen From: ad...@acfug.orgmailto:ad...@acfug.org [mailto:ad...@acfug.orgmailto:ad...@acfug.org] On Behalf Of Jeff Howard Sent: Thursday, January 20, 2011 3:02 PM To: discussion@acfug.orgmailto:discussion@acfug.org Subject: Re: [ACFUG Discuss] help with where to start trouble shooting an error Thanks. I'm working on getting the db credentials now to run the exact query that is being displayed in the CF error
RE: [ACFUG Discuss] help with where to start trouble shooting an error
You're not wanting to comment out the CURSOR FOR...you want to comment out the SET NOCOUNT and any other SET lines in that inner most nested proc... From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Jeff Howard Sent: Thursday, January 20, 2011 4:44 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] help with where to start trouble shooting an error same result and when commenting out the CURSOR FOR line I get Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]The variable '@Folder_List_Cursor' does not currently have a cursor allocated to it. On Thu, Jan 20, 2011 at 4:21 PM, axunderw...@ups.commailto:axunderw...@ups.com wrote: For the time being to try it out - just comment out all the SET operations...try it out and see if it works...this isn't a great solution because the JDBC driver that you're using is real picky about sql server and the count reporting. It can crop up in weird ways...but just as a test, comment the sets for now...then let us know. From: ad...@acfug.orgmailto:ad...@acfug.org [mailto:ad...@acfug.orgmailto:ad...@acfug.org] On Behalf Of Jeff Howard Sent: Thursday, January 20, 2011 4:18 PM To: discussion@acfug.orgmailto:discussion@acfug.org Subject: Re: [ACFUG Discuss] help with where to start trouble shooting an error You are correct and make me feel like I'm getting closer to actually resolving this (thank you). I actually thought I was fairly proficient with SQL Server until trying to debug this. I tried removing the NOCOUNT and setting it to OFF but no luck. Here is the SP with the NOCOUNT: SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[Folder_Child_List] ( @thisParent numeric(18,0), @Folder_List_Cursor CURSOR VARYING OUTPUT ) AS SET NOCOUNT ON SET @Folder_List_Cursor = CURSOR FOR SELECT F.Folder_Ka_ID FROM Folder_Ka F WHERE F.Soft_DELETE IS NULL AND F.Parent = @thisParent ORDER BY F.Priority_Display, F.Name -- Populate the cursor. OPEN @Folder_list_cursor RETURN On Thu, Jan 20, 2011 at 4:07 PM, axunderw...@ups.commailto:axunderw...@ups.com wrote: Yup, that proc has a cursor in it - look at the FETCH statement.. More than likely it's this statement below: EXECUTE Folder_Child_List @Folder_KA_ID, @Cursor_Child_List OUTPUT Looking at that, you've already declared and opened the cursor, and now it's calling another stored proc. My hunch is that the proc FOLDER_CHILD_LIST has a SET NOCOUNT in there that's messing the cursor up... Check into that From: ad...@acfug.orgmailto:ad...@acfug.org [mailto:ad...@acfug.orgmailto:ad...@acfug.org] On Behalf Of Jeff Howard Sent: Thursday, January 20, 2011 4:02 PM To: discussion@acfug.orgmailto:discussion@acfug.org Subject: Re: [ACFUG Discuss] help with where to start trouble shooting an error No constraints or triggers on Folder_KA_Tree and here is the SP that is called by the trigger: SET ANSI_NULLS OFF GO SET QUOTED_IDENTIFIER OFF GO ALTER PROCEDURE [dbo].[Get_Next_Branch] ( @Folder_KA_ID Int ) AS SET NOCOUNT ON -- Add The Data Into The Return Table For This Record INSERT INTO Folder_KA_Tree (Folder_KA_ID, Tree_Path) SELECT F.Folder_Ka_ID, dbo.getFolderTreePath(@Folder_KA_ID) FROM Folder_Ka F WHERE F.Soft_DELETE IS NULL AND F.Folder_Ka_ID = @Folder_KA_ID DECLARE @Cursor_Child_List CURSOR DECLARE @thisFolder_ID numeric(18, 0) EXECUTE Folder_Child_List @Folder_KA_ID, @Cursor_Child_List OUTPUT FETCH NEXT FROM @Cursor_Child_List INTO @thisFolder_ID WHILE (@@FETCH_Status = 0) BEGIN -- Get Tree From This Folder Down EXECUTE Get_Next_Branch @thisFolder_ID FETCH NEXT FROM @Cursor_Child_List INTO @thisFolder_ID END -- Close the cursor. CLOSE @Cursor_Child_List -- Deallocate the cursor. DEALLOCATE @Cursor_Child_List SET NOCOUNT OFF RETURN Thoughts? On Thu, Jan 20, 2011 at 3:57 PM, axunderw...@ups.commailto:axunderw...@ups.com wrote: Now you need to look at Folder_KA_Tree to see what triggers it has, and then take a look at the proc Get_Next_branch... From: ad...@acfug.orgmailto:ad...@acfug.org [mailto:ad...@acfug.orgmailto:ad...@acfug.org] On Behalf Of Jeff Howard Sent: Thursday, January 20, 2011 3:47 PM To: discussion@acfug.orgmailto:discussion@acfug.org Subject: Re: [ACFUG Discuss] help with where to start trouble shooting an error Ok, I'm in the db and there is one trigger and 5 constraints. I get the exact same error message when running the query in Mgmt Studio. Any tips on figuring out which of the 6 could be causing the issue? This is the trigger if it helps: SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER TRIGGER [dbo].[xx] ON [dbo].[Folder_Ka] FOR INSERT,UPDATE AS IF UPDATE ( Parent ) BEGIN DELETE FROM Folder_KA_Tree EXECUTE Get_Next_Branch @xxID = 0 END On Thu, Jan 20, 2011 at 3:30
RE: [ACFUG Discuss] CMS Preferences
A couple non-cf related just as some other alternatives to look into as you've probably gotten all the CF ones on the various lists provided here... Drupal - super customizable, more learning curve to implement Joomla - pretty easy. less extendable Wordpress (not technically a CMS, but with the various plugins avail can be used as one) While I'm not crazy about this particular site, they do have a pretty comprehensive listing of various CMS platforms and they show by popularity which gives you a good indication of what people are using or looking into using... http://www.cmsmatrix.org/ From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Steve Drucker Sent: Monday, January 03, 2011 12:08 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] CMS Preferences We usually favor CommonSpot for larger sites. www.paperthin.comhttp://www.paperthin.com/ On Mon, Jan 3, 2011 at 11:46 AM, Kevin Bachman kevin.bach...@activegroup.netmailto:kevin.bach...@activegroup.net wrote: Thanks! Great list! And, no, not JUST CF written or driven, just easily compatible. We run CF on Windows servers, so anything that would jive and has a good reputation I would love to know about. -Kevin From: ad...@acfug.orgmailto:ad...@acfug.org [mailto:ad...@acfug.orgmailto:ad...@acfug.org] On Behalf Of Charlie Arehart Sent: Monday, January 03, 2011 11:23 AM To: discussion@acfug.orgmailto:discussion@acfug.org Subject: RE: [ACFUG Discuss] CMS Preferences While I can't offer feedback on them (others may), I can point you to a list of CF-based ones that exist that I keep: Content Management Systems (written in CFML) http://www.cf411.com/#cms There are over two dozen-yes, just those written in CFML. Everyone has their idea of what makes a good CMS. :-) BTW, do you really mean you want feedback only on CF-oriented ones? Just because you are a CF driven house, you may well be interested in and/or benefit from considering alternatives, whether written in other languages (where you may not care, because you never edit the code) or web-based ones. To be clear, my site lists only CF-based ones (it would be too large a chore to track all the CMSs out there). /charlie From: ad...@acfug.orgmailto:ad...@acfug.org [mailto:ad...@acfug.orgmailto:ad...@acfug.org] On Behalf Of Kevin Bachman Sent: Monday, January 03, 2011 11:10 AM To: discussion@acfug.orgmailto:discussion@acfug.org Subject: [ACFUG Discuss] CMS Preferences Hello, All! I was wondering if I could get some feedback from the group regarding various CMS solutions that you might currently prefer. The marketing department at our company are in the planning phases of a new corporate site and would like a little more control over content. We have always just home built our front facing site and never went to the trouble of building content management into it, so I am fairly unfamiliar with what folks are using, specifically for a CF driven house. I appreciate any feedback or suggestions you might have! Tahnks! Kevin Bachman Senior Developer kevin.bach...@activegroup.netmailto:kevin.bach...@activegroup.net 678.405.1197(w) 678.405.4187 (f) [cid:319123618@03012011-0FE1] Primary Offices - Atlanta - London - Beijing More than 400 Global Locations ActiveGroup, Inc., a division of [cid:319123618@03012011-0FE8] http://www.mvlgroup.com/ The Foundation for Informed Decision Making This email, and any files transmitted with it, is confidential and intended solely for the use of the individual or entity to whom it is addressed. If you received this in error, please contact the sender immediately and delete the material from any computer. - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserformhttp://www.acfug.org/?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLinkhttp://www.fusionlink.com/ - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserformhttp://www.acfug.org/?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLinkhttp://www.fusionlink.com/ - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserformhttp://www.acfug.org/?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLinkhttp://www.fusionlink.com/ - -- Regards,
RE: [ACFUG Discuss] Noob help
First, as someone else suggested - search your entire code-base for (with quotes) qryGetVisitRecordsthat should bring you back something like: cfquery name=qryGetVisitRecords.or even a cfstoredproc It's possible that someone had a dynamic name, but unlikely...so that'd be your first approach. Then, as far as what CF does with query of queries (your specific example) - it takes two CFQUERIES (note, these are now downloaded recordsets from the db server - they are coldfusion variables now) and it joins them together through the where clause that was in your query. So it tries to match up the queries on your sitecompany_id fields from the two different datasets returned by your db (in previously called cfquery/cfstoredproc tags). What would be very helpful to you would be to do a cfdump on both of the tables that were referenced in the FROM clause. I put tables in quotes because they're really just CFQueries. cfdump var=#qryGetVisitRecords# label=qryGetVisitRecords / cfdump var=#qryGetAssignedMonths# label=qryGetAssignedMonths / cfabort Then, looking at your where clause in the query, you'd want to browse through the dumped records from the above statement and have a look at your sitecompany_id fields in both and that will show you what will have matched up between the two. It's been a while since I've done any query of queries (I try to avoid them when possible - typically we can handle these things in the initial query), but it seems like there were things that would kill record joins such as case sensitivity, spaces at the end of fields on one side and not the other, etc. CF is MUCH more picky than SQL Server when it comes to joining it's tables to each other. Hope that helps. Allen From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of mike barnes Sent: Tuesday, December 07, 2010 7:38 AM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] Noob help The answer to everyones question is yes, the dbtype is query. So, how do does one debug this query of queries, since it appears to not be getting all of the records. Basically, what I would like to do is see what the underlying sql statement is; so, that I can map back to the database (or is this possible). Also, not sure what debugging tools I have available to me. What makes this query of queries confusing is the fact that the from statement does not represent a table or view, so, what does CF use to substitute this part of the query, is it all of the tables from the main query? Thanks Mike Barnes On Mon, Dec 6, 2010 at 5:44 PM, John Youngman j...@jg-technologies.netmailto:j...@jg-technologies.net wrote: Good tip, and dont forget to look in any cfm templates that are used in cfinclude tags that may lie above the query in question. Good luck!! :D __ John Youngman j...@jg-technologies.netmailto:j...@jg-technologies.net http://www.linkedin.com/in/johngyoungman On Dec 6, 2010, at 5:38 PM, Teddy R. Payne wrote: *chuckle* As you can see, several people are on the same train of thought here. Another way in the future to try and figure out context of code is to do some global searches for keywords like qryGetVisitRecords. This could provide some code insight as to where the original query exists and how often it is being referenced. When you cannot find code, then you need to expand your searches to the interfaces to the application. This could be in many forms to include databases, webservices, ...etc where either data access or other code logic could reside. Happy Hunting! Teddy R. Payne, ACCFD Google Talk - teddyrpa...@gmail.commailto:teddyrpa...@gmail.com - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] Change in behavior of HTTP web services on 9.01?
Just a quick observation - I think in cfhttp method =Get usually refers to the query type (via url params or form params). It LOOKS like that method in the cfhttp call is overriding the url param method...just for the heck of it, I would try and remove method=Get and see what happens... From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of shawn gorrell Sent: Thursday, September 16, 2010 1:07 PM To: discussion@acfug.org Subject: [ACFUG Discuss] Change in behavior of HTTP web services on 9.01? We've got a piece of code that has worked for a very long time that automagically quit working after the latest cumulative updater to CF9. The code in question does a CFHTTP GET to hit a CF webservice on another server. cfhttp url=http://myserver/apps/appname/remote/mycomponent.cfc?wsdlmethod=GetUsersWS; method=Get resolveurl=false timeout=120 throwonerror=yes/ yada yada yada Now when it runs it throws an error: The method GET was not found in component D:\path\apps\appname\remote\mycomponent.cfc. Obviously the CFC doesn't have a GET method, but it never had one and always worked. Any ideas (other than wondering why it isn't using CFINVOKE - don't ask)? Cheers, S - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLinkhttp://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] Change in behavior of HTTP web services on 9.01?
Well that makes it difficult to change...I would say change the method=POST and see if you get the same error except telling you that POST doesn't exist.. From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of shawn gorrell Sent: Thursday, September 16, 2010 1:26 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] Change in behavior of HTTP web services on 9.01? Have already tried that. It's an error as well. Method in a CFHTTP only supports the list of HTTP verbs. If you omit it, it defaults to GET. From: axunderw...@ups.com axunderw...@ups.com To: discussion@acfug.org Sent: Thu, September 16, 2010 1:11:22 PM Subject: RE: [ACFUG Discuss] Change in behavior of HTTP web services on 9.01? Just a quick observation - I think in cfhttp method =Get usually refers to the query type (via url params or form params). It LOOKS like that method in the cfhttp call is overriding the url param method...just for the heck of it, I would try and remove method=Get and see what happens... From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of shawn gorrell Sent: Thursday, September 16, 2010 1:07 PM To: discussion@acfug.org Subject: [ACFUG Discuss] Change in behavior of HTTP web services on 9.01? We've got a piece of code that has worked for a very long time that automagically quit working after the latest cumulative updater to CF9. The code in question does a CFHTTP GET to hit a CF webservice on another server. cfhttp url=http://myserver/apps/appname/remote/mycomponent.cfc?wsdlmethod=GetUsersWS; method=Get resolveurl=false timeout=120 throwonerror=yes/ yada yada yada Now when it runs it throws an error: The method GET was not found in component D:\path\apps\appname\remote\mycomponent.cfc. Obviously the CFC doesn't have a GET method, but it never had one and always worked. Any ideas (other than wondering why it isn't using CFINVOKE - don't ask)? Cheers, S - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLinkhttp://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLinkhttp://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLinkhttp://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] newbie question: storing an array variable into a variable whose data type is not specified
A potential problem with your code is not scoping the variable in the function - it's very possible that outside your function you have another variable named result that could be conflicting with your function. cffunction name=myfunction access=remote returntype=struct cfargument name=form_data type=struct !--- The variable to be returned by the function is result --- cfset var result = StructNew() / cfset var person = / cfset result['dept_name'] = some dept cfset result['dept_num'] = some dept number Try putting that in there and see if it helps. From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Clarke Bishop Sent: Thursday, September 09, 2010 11:24 AM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] newbie question: storing an array variable into a variable whose data type is not specified I think cfset foo['sauce'] = []/ started working with CF8, so this could still be a problem with an earlier version of ColdFusion. Also, Chris, just so you know, you can put multiple lines inside a cfscript block. It usually looks more like: cfscript Line 1 of code; Line 2 of code; Line 3 of code ... /cfscript Easier to read in my opinion! Clarke From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Steve Ross Sent: Thursday, September 09, 2010 10:03 AM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] newbie question: storing an array variable into a variable whose data type is not specified actually that should work fine... because this works: cfset foo['sauce'] = []/ cfdump var=#foo# On Thu, Sep 9, 2010 at 9:56 AM, viswanathan.jayara...@atl.frb.orgmailto:viswanathan.jayara...@atl.frb.org wrote: I think you have to first declare cfset result = StructNew() before attempting to do this cfset result['people_info'] = peoplearray !--- Can this be done? --- cfset result['statMsg'] = 'Information successfully collected.' cfset result['status'] = true Jay Jayaraman Central Billing Services Financial Management and Planning (404) 498-8453 (W) (404) 273-7131 (C) From:Chris H h_chris...@yahoo.commailto:h_chris...@yahoo.com To:discussion@acfug.orgmailto:discussion@acfug.org Date:09/09/2010 09:51 AM Subject:[ACFUG Discuss] newbie question: storing an array variable into a variable whose data type is not specified Sent by:ad...@acfug.orgmailto:ad...@acfug.org Hi All, I am a newbie to Coldfusion. My development background is mainly in C/C++ so please excuse me if my below question is naive. I have a function as below cffunction name=myfunction access=remote returntype=any cfargument name=form_data type=struct !--- The variable to be returned by the function is result --- cfset result['dept_name'] = some dept cfset result['dept_num'] = some dept number !--- I run a query where I want to find some information about people having name John and there can be N number of people with the name of John --- cfquery dbtype=query name=printPeople SELECT * FROM people WHERE peopleName = John /cfquery cfset peoplearray=ArrayNew(1) cfset myCounter = 0 / cfloop query=printPeople cfset myCounter = myCounter + 1 / cfscript ArrayAppend(peoplearray, #printPeople.empID#); /cfscript cfscript ArrayAppend(peoplearray, #printPeople.departmentname#); /cfscript cfscript ArrayAppend(peoplearray, #printPeople.departmentID#); /cfscript cfscript ArrayAppend(peoplearray, #printPeople.empTitle#); /cfscript /cfloop cfset result['people_info'] = peoplearray !--- Can this be done? --- cfset result['statMsg'] = 'Information successfully collected.' cfset result['status'] = true cfreturn result /cffunction The part cfset result['people_info'] = peoplearray attempts to store an array variable into a variable whose data type is not specified. Can this be done? If not, what should I do? Should I define the datatype of result variable as a structure, change the return type in function signature as a structure from any as a structure variable can hold string, integer and array variables? Any suggestions would be appreciated. - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLinkhttp://www.fusionlink.com/ - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For
RE: [ACFUG Discuss] newbie question: storing an array variable into a variable whose data type is not specified
Sorry about the var person - I was going to go into further detail about creating an array of structs but ripped out everything and forgot to remove that...in the code below you don't need it. But, being that your next question sheds more light on what you're trying to do I've not done flex in a while but I am almost positive you can bind a flex grid to a coldfusion query. So, it would make more sense for your function to just return the query object and then bind that straight to your grid. I'm assuming you're calling this via a CFC from flex, and there should be many examples of that out there. Your array of arrays will probably be 100x more tedious than doing the query to grid binding. Hope that helps. From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Chris H Sent: Thursday, September 09, 2010 1:09 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] newbie question: storing an array variable into a variable whose data type is not specified Thanks Steve, Jay, Clark and Axunderwood for the prompt responses and useful suggestions. 1. I have changed the return type of function to struct and other changes in the function as below according to the suggestions cffunction name=myfunction access=remote returntype=struct cfargument name=form_data type=struct cfset var result = StructNew() / cfset var person = / !--- Why is this needed? I did not understand this part. I realize the concept is to initialize variables with blank values before using them --- cfset result['dept_name'] = some dept cfset result['dept_num'] = some dept number . ... cfscript ArrayAppend(peoplearray, #printPeople.empID#); ArrayAppend(peoplearray, #printPeople.departmentname#); ArrayAppend(peoplearray, #printPeople.departmentID#); ArrayAppend(peoplearray, #printPeople.empTitle#); /cfscript .cfset result['people_info'] = peoplearray cfset result['statMsg'] = 'Information successfully collected.' cfset result['status'] = true cfreturn result /cffunction Rest of part is same as I posted earlier 2. How would I reference the return values in the caller function which is a Flex component? private function myfunction(eventObj:ResultEvent):void{ var people_obj:Object = new Object(); people_obj.dept_name = eventObj.result.dept_name; people_obj.dept_num = eventObj.result.dept_num; // would the below code work? people_obj.peoplearray = eventObj.result.peoplearray } // How can I access the department name, department ID and employee ID, title of the third person whose name is John from the above people_obj // object? // Or, do I need an arraycollection variable [Bindable] private var people_info:ArrayCollection; people_info = eventObj.result.peoplearray Then, I could load the arraycollection variable people_info into a DataGrid element where the elements would be displayed in order? Can someone please advise? Thanks From: Steve Ross nowhid...@gmail.com To: discussion@acfug.org Sent: Thu, September 9, 2010 9:55:29 AM Subject: Re: [ACFUG Discuss] newbie question: storing an array variable into a variable whose data type is not specified yep, what you are actually doing is creating a named struct (hash) when you do this: cfset result['people_info'] = peoplearray / changing the return type will give you exactly what you want (unless you want an array), and if you do then you can create an array of structs... On Thu, Sep 9, 2010 at 9:51 AM, Chris H h_chris...@yahoo.commailto:h_chris...@yahoo.com wrote: Hi All, I am a newbie to Coldfusion. My development background is mainly in C/C++ so please excuse me if my below question is naive. I have a function as below cffunction name=myfunction access=remote returntype=any cfargument name=form_data type=struct !--- The variable to be returned by the function is result --- cfset result['dept_name'] = some dept cfset result['dept_num'] = some dept number !--- I run a query where I want to find some information about people having name John and there can be N number of people with the name of John --- cfquery dbtype=query name=printPeople SELECT * FROM people WHERE peopleName = John /cfquery cfset peoplearray=ArrayNew(1) cfset myCounter = 0 / cfloop query=printPeople cfset myCounter = myCounter + 1 / cfscript ArrayAppend(peoplearray, #printPeople.empID#); /cfscript cfscript ArrayAppend(peoplearray, #printPeople.departmentname#); /cfscript cfscript ArrayAppend(peoplearray, #printPeople.departmentID#); /cfscript cfscript
RE: [ACFUG Discuss] newbie question: storing an array variable into a variable whose data type is not specified
Or why not just return the query seeing as how it's already basically what you want. From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Darin Kohles Sent: Thursday, September 09, 2010 1:08 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] newbie question: storing an array variable into a variable whose data type is not specified Since you mentioned C++, I'm assuming you have some OOP. Why aren't you storing each person as an object? cfloop ... ... cfset peoplearray[mycounter] = StructNew() cfset peoplearray[mycounter].empID = printPeople.empID ... On Thu, Sep 9, 2010 at 8:35 AM, axunderw...@ups.commailto:axunderw...@ups.com wrote: A potential problem with your code is not scoping the variable in the function - it's very possible that outside your function you have another variable named result that could be conflicting with your function. cffunction name=myfunction access=remote returntype=struct cfargument name=form_data type=struct !--- The variable to be returned by the function is result --- cfset var result = StructNew() / cfset var person = / cfset result['dept_name'] = some dept cfset result['dept_num'] = some dept number Try putting that in there and see if it helps. From: ad...@acfug.orgmailto:ad...@acfug.org [mailto:ad...@acfug.orgmailto:ad...@acfug.org] On Behalf Of Clarke Bishop Sent: Thursday, September 09, 2010 11:24 AM To: discussion@acfug.orgmailto:discussion@acfug.org Subject: RE: [ACFUG Discuss] newbie question: storing an array variable into a variable whose data type is not specified I think cfset foo['sauce'] = []/ started working with CF8, so this could still be a problem with an earlier version of ColdFusion. Also, Chris, just so you know, you can put multiple lines inside a cfscript block. It usually looks more like: cfscript Line 1 of code; Line 2 of code; Line 3 of code ... /cfscript Easier to read in my opinion! Clarke From: ad...@acfug.orgmailto:ad...@acfug.org [mailto:ad...@acfug.orgmailto:ad...@acfug.org] On Behalf Of Steve Ross Sent: Thursday, September 09, 2010 10:03 AM To: discussion@acfug.orgmailto:discussion@acfug.org Subject: Re: [ACFUG Discuss] newbie question: storing an array variable into a variable whose data type is not specified actually that should work fine... because this works: cfset foo['sauce'] = []/ cfdump var=#foo# On Thu, Sep 9, 2010 at 9:56 AM, viswanathan.jayara...@atl.frb.orgmailto:viswanathan.jayara...@atl.frb.org wrote: I think you have to first declare cfset result = StructNew() before attempting to do this cfset result['people_info'] = peoplearray !--- Can this be done? --- cfset result['statMsg'] = 'Information successfully collected.' cfset result['status'] = true Jay Jayaraman Central Billing Services Financial Management and Planning (404) 498-8453 (W) (404) 273-7131 (C) From:Chris H h_chris...@yahoo.commailto:h_chris...@yahoo.com To:discussion@acfug.orgmailto:discussion@acfug.org Date:09/09/2010 09:51 AM Subject:[ACFUG Discuss] newbie question: storing an array variable into a variable whose data type is not specified Sent by:ad...@acfug.orgmailto:ad...@acfug.org Hi All, I am a newbie to Coldfusion. My development background is mainly in C/C++ so please excuse me if my below question is naive. I have a function as below cffunction name=myfunction access=remote returntype=any cfargument name=form_data type=struct !--- The variable to be returned by the function is result --- cfset result['dept_name'] = some dept cfset result['dept_num'] = some dept number !--- I run a query where I want to find some information about people having name John and there can be N number of people with the name of John --- cfquery dbtype=query name=printPeople SELECT * FROM people WHERE peopleName = John /cfquery cfset peoplearray=ArrayNew(1) cfset myCounter = 0 / cfloop query=printPeople cfset myCounter = myCounter + 1 / cfscript ArrayAppend(peoplearray, #printPeople.empID#); /cfscript cfscript ArrayAppend(peoplearray, #printPeople.departmentname#); /cfscript cfscript ArrayAppend(peoplearray, #printPeople.departmentID#); /cfscript cfscript ArrayAppend(peoplearray, #printPeople.empTitle#); /cfscript /cfloop cfset result['people_info'] = peoplearray !--- Can this be done? --- cfset result['statMsg'] = 'Information successfully collected.' cfset result['status'] = true cfreturn result /cffunction The part cfset result['people_info'] = peoplearray attempts to store an array variable into a variable whose data type is not
[ACFUG Discuss] RE: Upload file error
requestTimeout? From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Moises Alejandro Zamora Villasana Sent: Tuesday, February 09, 2010 2:02 PM To: discussion@acfug.org Subject: [ACFUG Discuss] Upload file error Hi, Im trying to upload a large file (96 mb) and I get an error. I read that the CF8 doesn't have a limitation to upload file but so, what happening? Could It be the IIS? I have Win Server 2008 with CF8. Regards Moises __ COMIMSA, Premio Nacional de Tecnolog?a 2008. http://www.comimsa.com.mx/pnt Comentarios, quejas y/o sugerencias relacionadas con los proyectos o servicios tecnol?gicos ofrecidos por COMIMSA, favor de dirigirlas a cali...@comimsa.com.mx - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLinkhttp://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
[ACFUG Discuss] RE: Coldfusion Tabs vs JQuery Tabs
Just my $0.02. The biggest reason to use something other than CF's built in functionality is if you ever need to do something outside of the standard uses intended of the tabs. I've not used the CF tabs but here's an example of what I'm talking about. Let's assume that the CF tabs are standard fare, if you click a tab, it shows/hides divs. Well, let's say that you need the tab to do an ajax call or a form validation after you've clicked the tab title. If that's not built into the CF tab, it may be very difficult for you to make what you need work. Whereas with a third party library such as jquery, prototype, etc., you typically have very granular control over everything you want to accomplish. Now, please don't take that as a bash against the built in functionality of CF. CF is popular for a reason - they have a lot bundled in that makes rapid development/deployment possible. If you just need whatever functionality is available, then CF's internal options may be the way to go. Allen From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Murgolo, James Sent: Sunday, February 07, 2010 1:27 AM To: discussion@acfug.org Subject: [ACFUG Discuss] Coldfusion Tabs vs JQuery Tabs Anyone know of any advantages/disadvantages of using JQuery tabs vs the built in ColdFusion tabs? I've read that JQuery is a bit leaner but are there any functionality issues? Heck, what about spry tabs too? Thanks, James Murgolo Web Developer Department of Information Technology Oxford College of Emory University (770) 784 - 4662 james.murg...@emory.edumailto:james.murg...@emory.edu This e-mail message (including any attachments) is for the sole use of the intended recipient(s) and may contain confidential and privileged information. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this message (including any attachments) is strictly prohibited. If you have received this message in error, please contact the sender by reply e-mail message and destroy all copies of the original message (including attachments). - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLinkhttp://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] RE: Coldfusion Tabs vs JQuery Tabs
Well, if you take it to that degree, yes that's true. Under the cover CF (8) used EXT 1.0 I believe. The problem with that in my opinion is that it's now two versions old. And yes, all the CF DHTML is in the scripts folder, and yes you can figure out what to do behind the scenes. But, then you also have to figure out how CF is naming all your components, etc. There is much more digging to work with the built in CF DHTML features if you go further than the scope of the wrapped CF functionality. Steve, while what you say is absolutely true, in my experience it's not simply just understanding the Ext library and you're ready to roll. You've got to figure out how CF is generating the scripts so that you can then interact with the elements that it's creating on the page. And that leads me back to my original statement. If you plan on going past the scope of what the built in CF features offer, in my opinion (just my $0.02 again), then it might be worth looking into one of those 3rd party libraries - (I use Ext extensively myself). Two reasons for this - 1. You can get the latest builds of the libraries which have new features, have more bug fixes, etc., and 2. being that you're building the interface, you'll have a much more in-depth view of how things interact and therefore doing anything special will be easier to taylor to your needs. Again, I'm not trying to speak the gospel, I'm just trying to give James my view on the topic. From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Steve Drucker Sent: Monday, February 08, 2010 7:38 AM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] RE: Coldfusion Tabs vs JQuery Tabs Allen - The built in CF tabs are nothing more than an abstraction layer for the EXT-JS library tabs (www.extjs.comhttp://www.extjs.com), so your argument doesn't really hold water. If you know the various methods for EXT-JS then its every bit as flexible as Spry or jQuery. In fact, the CF tab JavaScript API is somewhat easier to learn since there are a number of high-level functions (i.e. ColdFusion.Layout.createTab(), ColdFusion.Layout.disableTab()) and you can always invoke ColdFusion.Layout.getTabLayout() to get a pointer to the underlying EXT-JS element. Frankly, given EXT-JS high quality and integrated series of UI components, it's definitely worth considering EXT-JS over jQuery for advanced UI (although I would still use jQuery for arbitrary DOM manipulation). WS0ef8c004658c1089-6262c847120f1a3b244-7fec.html On Mon, Feb 8, 2010 at 7:24 AM, axunderw...@ups.commailto:axunderw...@ups.com wrote: Just my $0.02. The biggest reason to use something other than CF's built in functionality is if you ever need to do something outside of the standard uses intended of the tabs. I've not used the CF tabs but here's an example of what I'm talking about. Let's assume that the CF tabs are standard fare, if you click a tab, it shows/hides divs. Well, let's say that you need the tab to do an ajax call or a form validation after you've clicked the tab title. If that's not built into the CF tab, it may be very difficult for you to make what you need work. Whereas with a third party library such as jquery, prototype, etc., you typically have very granular control over everything you want to accomplish. Now, please don't take that as a bash against the built in functionality of CF. CF is popular for a reason - they have a lot bundled in that makes rapid development/deployment possible. If you just need whatever functionality is available, then CF's internal options may be the way to go. Allen From: ad...@acfug.orgmailto:ad...@acfug.org [mailto:ad...@acfug.orgmailto:ad...@acfug.org] On Behalf Of Murgolo, James Sent: Sunday, February 07, 2010 1:27 AM To: discussion@acfug.orgmailto:discussion@acfug.org Subject: [ACFUG Discuss] Coldfusion Tabs vs JQuery Tabs Anyone know of any advantages/disadvantages of using JQuery tabs vs the built in ColdFusion tabs? I've read that JQuery is a bit leaner but are there any functionality issues? Heck, what about spry tabs too? Thanks, James Murgolo Web Developer Department of Information Technology Oxford College of Emory University (770) 784 - 4662 james.murg...@emory.edumailto:james.murg...@emory.edu This e-mail message (including any attachments) is for the sole use of the intended recipient(s) and may contain confidential and privileged information. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this message (including any attachments) is strictly prohibited. If you have received this message in error, please contact the sender by reply e-mail message and destroy all copies of the original message (including attachments). - To unsubscribe from
RE: [ACFUG Discuss] Ideal memory Configuration for CF Production server?
One thing to think about along this line of thinking is if you set up CF in a multiserver instance, you can allocate more ram to your heavy hitter by putting it in its own instance, and then group your light sites under another instance and allocate them their own memory as well. From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Wes Byrd Sent: Thursday, January 14, 2010 4:31 PM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] Ideal memory Configuration for CF Production server? One thing to note, CF on a 32 bit Windows server can only be allocated 1280MB of RAM... even if the server has 4 GB of RAM... you can only allocate 1280MB. Anything higher than that, the service will not start. This is not true for CF 8.01 running on 64 bit operating systems. Wes From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Ajas Mohammed Sent: Thursday, January 14, 2010 4:00 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] Ideal memory Configuration for CF Production server? About 20 sites and high traffic site. I am not sure how many users though. I guess there is a limit of 4gb memory on 32 bit systems. I noticed lsass.exe is taking 600,000K of memory and jrun.exe is taking 193,604K of memory. So lsass.exe is using thrice as much. Any suggestions? Ajas Mohammed / http://ajashadi.blogspot.com We cannot become what we need to be, remaining what we are. No matter what, find a way. Because thats what winners do. You can't improve what you don't measure. Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives. On Thu, Jan 14, 2010 at 3:44 PM, Troy Jones t...@dynapp.commailto:t...@dynapp.com wrote: It could be. I'd be interested to know how many sites, what kind of traffic each site brings, that kind of thing. But, if I had 4gb of memory, I'd set my heap size to 1024mb. That is good enough usually unless you have a relatively high-load server environment. [cid:248293721@14012010-0528] ___ Troy Jones | Director of Technical Services | Dynapp Inc | 1-800-830-5192 ext. 603 | dynapp.comhttp://www.dynapp.com/ | facebook.com/dynapphttp://www.facebook.com/dynapp From: ad...@acfug.orgmailto:ad...@acfug.org [mailto:ad...@acfug.orgmailto:ad...@acfug.org] On Behalf Of Ajas Mohammed Sent: Thursday, January 14, 2010 3:38 PM To: discussion@acfug.orgmailto:discussion@acfug.org Subject: [ACFUG Discuss] Ideal memory Configuration for CF Production server? Hi, I was wondering what is the ideal memory you prefer on an CF Production server? We are running Intel Xeon CPU E 5450 @ 3.00 GHZ, 4GB RAM. Any suggestions as far as If 4gb memory is good enough or it should be greater than that for a production server? Thanks, Ajas Mohammed / http://ajashadi.blogspot.com We cannot become what we need to be, remaining what we are. No matter what, find a way. Because thats what winners do. You can't improve what you don't measure. Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives. No virus found in this incoming message. Checked by AVG - www.avg.comhttp://www.avg.com Version: 8.5.432 / Virus Database: 270.14.131/2609 - Release Date: 01/14/10 07:35:00 - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLinkhttp://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLinkhttp://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - inline: image001.jpg
RE: [ACFUG Discuss] Examples of How NOT to Code in ColdFusion?
My biggest pet peeve: CFQueries inline in a CF template. I'm not a stickler for complete object oriented or you have to do things exactly a particular way...that being said, I have two reasons why I like to see cfqueries or cfstoredproc calls in a cfc or a cfm template that can be called as a cfmodule: 1. You know where to look for the code - if you do it in a cfc, you can have all your data access calls in one place that is easy to find in various methods 2. If you're writing a query to be used on a page somewhere, chances are, you'll need that same query again somewhere else - this doesn't always stand true, but 9 times out of 10, you use the same general queries for multiple areas on a site. My second biggest pet peeve: Looping over a query just to query x number of times again. This is probably the thing that I see beginners do the most, probably because they just don't understand how to write a query to retrieve all the data at once. For instance, someone might want to see their top 100 customer's orders..a lot of times you'll see someone write a query to retrieve their customers, and then loop over that query and then query to get the orders (so basically 101 queries to the db)...in reality, all they had to do was a query from the customer table left joining the order table in one query, and then looping over the results with a group by. The last one I can think of this early: Using CF as your paging repository for large datasets...this is probably the fault of many a book and message board out there, and probably just having the feature available in CF makes it too easy to pass up for most. But, the ability to query a db, retrieve 100,000 records, and then just using records 10-20 or something like that. I hate seeing that. The amount of network bandwidth being utilized, the memory being wasted, the processing required from cf, etc. It's just a horrible thing to use. I cringe every time I see it...and if I have my hands in it...I change it immediately to do a db implementation to just retrieve the rows needed. From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Derrick Peavy Sent: Monday, January 04, 2010 9:07 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] Examples of How NOT to Code in ColdFusion? !--- MY FIRST PET PEEVE --- !--- people need to learn to comment their code --- !--- for example, when I have to throw in a hack, i like to remind myself to remove it --- !--- so I type: hey dumba** - remove this comment and code block as soon as you can figure out how someone is loading this page, four screens deep in an app without any client or session vars enabled in the client when it should be impossible and the page will not even load when tested by 20 different browsers in 7 countries --- !--- I have an important file in my app that is probably 50% comments. seriously. because it's an awesome file and elegantly simplistic and responsible for 50% of the data on the site, so it's nice to be able to go back when tweaking and know why something is done the way it's done. So, maybe 350 lines of code mixed with xhtml and another 350 of comments. overkill? yeah. But if I die, you won't have to guess! --- !--- just to check myself after your post, I looked over my app.cfm file, I have a total of four (4) client vars, two of those can be int(11), one can only be a single digit, and one can only be either Y or N --- !--- there are some application variables for things that never change and so they can persist across any client or time up to the max allotted time for app variables to expire --- !--- everything else is session with a reasonable time out setting --- !--- not unusual to have 100k page loads total considering all bots and spiders and users, and 7 or 8K user page loads in a 24 hour period with no cpu spike or lag time unless a background data process is scheduled --- !--- MY SECOND PET PEEVE --- !--- writing every gosh damned query as a fricking cfc --- !--- the beauty of CF is that you can actually just write a da*n query and just run it --- !--- which brings me to... --- !--- MY THIRD PET PEEVE --- !--- people who can't accept a database structure that gets the job done without 100 x-ref matching tables which require 42 queries to get a user name and email --- !--- stop it. just stop it already and learn how to make data simple and accept that you are not Aamazon and you will never, ever, ever, likely scale your app beyond a few hundred concurrent users accessing the minimal amount of data --- _ Derrick Peavy derr...@derrickpeavy.commailto:derr...@derrickpeavy.com 404-786-5036 Innovation distinguishes between a leader and a follower. -Steve Jobs _ On Jan 4, 2010, at 7:12 PM, Cameron Childress wrote: On Mon, Jan 4, 2010 at 5:18 PM, Derrick
RE: [ACFUG Discuss] ColdFusion 7 + SQL Server 2000. 500 Operation failed on the data source named XYZ.
As an FYI - we had a similar issue up here. There was a problem where there were issues such as deadlocks occurring in the database if there was high volume of traffic with large amounts of client data being written to and read from. I would (if you can) run a trace on that database with the client tables in it to see if you're getting any locks that are killing off your threads. For some reason, CF seems to ignore the sql errors that come from the client data read/write. It was a very odd issue that took a long time to find. Another thing to do is to check and see how much old data is in those CDATA/CGLOBAL tables. Putting a db maintenance plan in place that cleans out those tables every couple of days did wonders for getting rid of the problem you describe. Allen From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Ajas Mohammed Sent: Tuesday, May 05, 2009 1:47 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] ColdFusion 7 + SQL Server 2000. 500 Operation failed on the data source named XYZ. Yes, XYZ has CDATA and CGLOBAL in it. Let me know if you need more information. I am stumped. Thanks for the reply. Ajas Mohammed / http://ajashadi.blogspot.com We cannot become what we need to be, remaining what we are. No matter what, find a way. Because thats what winners do. You can't improve what you don't measure. Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives. On Tue, May 5, 2009 at 1:42 PM, Teddy R. Payne teddyrpa...@gmail.commailto:teddyrpa...@gmail.com wrote: Can you confirm that the client store tables exist in the CF DSN that you are referencing in your application file? Does XYZ have CDATA and CGLOBAL in it? Teddy R. Payne, ACCFD Google Talk - teddyrpa...@gmail.commailto:teddyrpa...@gmail.com On Tue, May 5, 2009 at 1:11 PM, Ajas Mohammed ajash...@gmail.commailto:ajash...@gmail.com wrote: Hi, I believe so because same sql server account/user is used to for all DSN we have i.e. about 10-15 dsn's and we never had this problem with any of the dsn's. So its really weird. We have two appl's lets say MainApp and SubApp where MainApp is /MainApp and subApp is /MainApp/SubApp. Both have there own Appplication.cfm file and we have clientmanagement yes and clientstorage pointing to same DSN lets say XYZ like this sessionmanagement=no setclientcookies=yes clientmanagement=yes clientstorage=XYZ One user was getting this error in MainApp and I was getting the same error in subApp. Some users were not getting *any* errors at all. I got rid of MainApp error using this code at very end of logout screen. cfset client.hitcount = 1 .Thats strange because I dont use StructClear(Client). Someone mentioned that if you used StructClear then use hitcount. I am so confused now because client.hitcount thing worked and we havent used it for any of our sites which work fine. Any suggestions? By the way, I have not tried hitcount method on the SubApp application yet. Ajas Mohammed / http://ajashadi.blogspot.com We cannot become what we need to be, remaining what we are. No matter what, find a way. Because thats what winners do. You can't improve what you don't measure. Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives. On Tue, May 5, 2009 at 12:51 PM, Teddy R. Payne teddyrpa...@gmail.commailto:teddyrpa...@gmail.com wrote: Does the user that you bind for the datasource have access to create table? Client storage creates two database tables: CDATA, CGLOBAL Teddy R. Payne, ACCFD Google Talk - teddyrpa...@gmail.commailto:teddyrpa...@gmail.com On Tue, May 5, 2009 at 11:15 AM, Ajas Mohammed ajash...@gmail.commailto:ajash...@gmail.com wrote: Hi, I have a datasource defined lets say XYZ and I use this XYZ dsn as clientstorage. I am getting this error message after page request. Everything works fine except that the page has this error at end of page. 500 Operation failed on the data source named XYZ. Operation failed on the data source named XYZ. My search on google gave me clues that it could be a client variable causing problem or space for table storing client variables or Oracle db(which doesnt apply to me). So far, not sure what is the root of this problem. Which log file I need to check to track more info about this error? Any ideas as to what could be causing this error. Thanks, Ajas Mohammed / http://ajashadi.blogspot.com We cannot become what we need to be, remaining what we are. No matter what, find a way. Because thats what winners do. You can't improve what you don't measure. Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise
RE: [ACFUG Discuss] How to trap bad character - diamond with question mark.
What is the specific problem you're having with it? From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Derrick Peavy Sent: Monday, May 04, 2009 8:19 AM To: discussion@acfug.org Subject: [ACFUG Discuss] How to trap bad character - diamond with question mark. Does anyone have a quick fix for the black diamond with a question mark? Over the years, I've tried all kinds of things and nothing seems to work. Currently, this is in some data that I am importing from another system, so I can't avoid having to deal with it. _ Derrick Peavy derr...@derrickpeavy.commailto:derr...@derrickpeavy.com _ - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] creating a web service with cf
There's really not a problem with doing what you say - many will say it's bad practice, but a way to avoid getting all the bad practice responses, do something like this. Have a function in your cfc that returns your query. Then have another function that will format that particular query into an html table. That will do two things for you. One, you can separate your data layer from your display layer, and if in the future you feel that you need that query for more than just displaying HTML tables, you can easily just call that function. So no, there's no problem with wanting to just return an HTML table. You can do that, just separate out your data function and your html formatting functions. Give that a shot. As John said below, from php you would just call the page as follows: http://url_to_cfc/yourcfc.cfc?methodname=yourmethod - be sure to get rid of the returnFormat=json if you're going to be outputting html. Allen From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Dusty Hale Sent: Thursday, April 16, 2009 6:37 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] creating a web service with cf I guess my thought was that I didn't want to deal with a php array. I don't have so much php experience so I was hoping to just output (or echo) that one variable that would be returned all formatted into HTML for presentation on the page. This would allow me to do pretty much all the work with CF. Does that make any sense? The main reason I am thinking this way is because I feel comfortable coding with CF but not so comfortable with PHP and it is something I don't want to spend very much time on. Dusty On Thu, Apr 16, 2009 at 6:01 PM, John Mason ma...@fusionlink.commailto:ma...@fusionlink.com wrote: You're adding a lot more work to this than is necessary. Just call the cfc method (which will return a standard query) like so.. url_to_cfc/yourcfc.cfc?methodname=yourmethodreturnFormat=json This should provide you with a proper json string. Then on the php side use json_decode() to decode the string into a php array. You should be good too go with that and it'll take a lot less work. John ma...@fusionlink.commailto:ma...@fusionlink.com Dusty Hale wrote: Hi thank you Allen, John, and Brooks for the responses. I was actually planning on keeping the query result in the cfc and formatting the results in HTML table rows and pushing that into a cfsavecontent variable=myresults and then sending that returning that variable to the web service. So in PHP I was hoping to just spit out that variable somehow to display the results in the HTML table rows. Does that sound like it would work? Can anyone see any problems with doing it this way. Security is not too much of an issue here it is just some categories of sponsor information. Muchos Gracias, Dusty On Thu, Apr 16, 2009 at 10:36 AM, ma...@fusionlink.commailto:ma...@fusionlink.com mailto:ma...@fusionlink.commailto:ma...@fusionlink.com wrote: You can simply specify the return type as either wddx or json. PHP has (or at least had) a wddx reader. And json is common now, so I suspect php has functions for that as well. If you do specify the return type, do it in the url not on the attribute of the cffunction. It keeps your web service agnostic so to speak. John ma...@fusionlink.commailto:ma...@fusionlink.com mailto:ma...@fusionlink.commailto:ma...@fusionlink.com - Original Message - From: brooks.wil...@atl.frb.orgmailto:brooks.wil...@atl.frb.org mailto:brooks.wil...@atl.frb.orgmailto:brooks.wil...@atl.frb.org [mailto:brooks.wil...@atl.frb.orgmailto:brooks.wil...@atl.frb.org mailto:brooks.wil...@atl.frb.orgmailto:brooks.wil...@atl.frb.org] To: discussion@acfug.orgmailto:discussion@acfug.org mailto:discussion@acfug.orgmailto:discussion@acfug.org Sent: Thu, 16 Apr 2009 08:01:21 -0400 Subject: Re: [ACFUG Discuss] creating a web service with cf sure - but you need to decide on a data format. does php support cf query type? i doubt it - you will likely need to change the query to an array. Dusty Hale du...@dustyhale.commailto:du...@dustyhale.com mailto:du...@dustyhale.commailto:du...@dustyhale.com Sent by: ad...@acfug.orgmailto:ad...@acfug.org mailto:ad...@acfug.orgmailto:ad...@acfug.org 04/16/2009 01:02 AM Please respond to discussion@acfug.orgmailto:discussion@acfug.org mailto:discussion@acfug.orgmailto:discussion@acfug.org To discussion@acfug.orgmailto:discussion@acfug.org mailto:discussion@acfug.orgmailto:discussion@acfug.org cc Subject [ACFUG Discuss] creating a web service with cf I have a need which I think would be a good fit to create a web service but since I have never developed a web service I thought to get some other opinions. I have a site which is hosted on a Linux box with php and no CF. I need for part of this site to use a
RE: [ACFUG Discuss] Looking for a CF Host
Seeing as how it looks like nobody else has responded... Dedicated means it's like owning your very own server, except it's stored at the company's location. You basically have full rights over the box. Cost is much more Shared means, you're sharing the server with a number of other people (could be hundreds), which means you also share the costs. This can be super inexpensive, but you have to be careful - with shared, you get the good with the bad - if someone has written a bad query that tanks the db server you're all attached to, guess what, you get to share in that poor performance...but, it's a tradeoff...do you want to pay $200/month for dedicated hosting with super control (and super responsibility), or do you want to pay $20/month for less control, but usually pretty good service... From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of PEYTONTODD Sent: Monday, March 09, 2009 8:29 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] Looking for a CF Host Hi Charlie, Sorry for my ignorance, but what's the difference between shared an dedicated hosting? Peyton - Original Message - From: Charlie Arehart char...@carehart.org To: discussion@acfug.org Sent: Monday, March 9, 2009 7:01:37 PM GMT -05:00 US/Canada Eastern Subject: RE: [ACFUG Discuss] Looking for a CF Host Peyton, I have a generic answer and a specific recommendation. First, I'll point out that you can find dozens of alternative CF hosts listed at: ColdFusion Hosting Alternatives http://www.cf411.com/#cfhost This is one of a hundred-plus categories of resources and tools of interest to CFers, and a good place to check whenever you have a question like that. Second, I'll vouch specifically for two hosts (both on that list, though I don't generally offer any such commentary on the list). One is FusionLink, which is run by our own John Mason, who also hosts the ACFUG site and lists. I've heard nothing but good things from those hosted there, and we know that he always is quick with great solutions here as well. More at http://www.fusionlink.com/. Another is the company who hosts my site, Edge Web hosting. You don't mention whether you're interested in shared or dedicated hosting. There's of course quite a difference. I can certainly speak very highly of my experience with a dedicated server at Edge Web. More on them at http://www.edgewebhosting.net/. My site points to still other lists of CF hosters. There's an enormous range of alternatives. The challenge is really finding the right one for you. Most will meet your interest of low cost, though again, that's relative, so you'll need to investigate or be more specific in your expectations. Hope that's helpful. /charlie From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of PEYTONTODD07 Sent: Monday, March 09, 2009 3:11 PM To: discussion@ACFUG.org Subject: [ACFUG Discuss] Looking for a CF Host Hi all, I will be looking soon for a host for a small CF site I'll be writing. The main consideration at this point is cost, since the site is likely to involve nothing more complicated than data (e.g. SQL Server), passwords, and e-mail. Any suggestions? Thanks, Peyton - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLinkhttp://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLinkhttp://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLinkhttp://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] CF 7 Pagination - Query rerun making pagination useless
Ajas, if you're using SQL Server 2005 or Oracle, there are much better solutions...the problem with what you showed in the first link is you (the server) is always retrieving ALL rows from the given table and pushing those across the pipe from your SQL server to your web server. There are two things majorly wrong with this - 1. if you're really using paging, you're using only a subset of these rows and throwing the rest out. That means if you have 50,000 records in the table and you're only using 1,000, you're basically wasting your db server's I/O (and possibly CPU if you're doing any special groupings or anything), plus you're eating up bandwidth. 2. You're now forcing the web server to wait to retrieve all of this data, store it up, and then only use a portion of it. A better way (in my opinion) to do this is to use what's available through your db for paging and go with that. If you're using SQL Server 2005 looking into the ROW_NUMBER() OVER functionality. You can retrieve x number of rows at a time which saves I/O on your SQL Server (assuming proper indexing), your Web Server, and your bandwidth...here's a sample of how you'd do it in SQL Server 2005: DECLARE @startRow INT, @endRow INT SELECT @startRow = 11, @endRow = 20 SELECT * FROM( SELECT ROW_NUMBER() OVER (ORDER BY columnA, ColumnB DESC) AS rowNum, columnA, columnB, FROM myTable WHERE 1=1 AND columnA = '...' AND columnB='' )x WHERE x.rowNum BETWEEN @startRow AND @endRow If you're using Oracle (which I have limited experience in) you can use the built in rownum feature to do your paging selects. I'm sure other RDBM's out there have options to accomplish this as well. There are several options out there that can do what you need. The way that was shown in that first link you provided is the old way of doing things that is probably the worst of all worlds. If you have questions, drop me a line. Allen From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Ajas Mohammed Sent: Sunday, February 22, 2009 1:49 PM To: discussion@acfug.org Subject: [ACFUG Discuss] CF 7 Pagination - Query rerun making pagination useless Hi, Since these days, I am looking at optimization issues as you can tell from other posts, I have been thinking of pagination for quite sometime now. I have it working for a site and it works fine. There are plenty of solutions out there and one provided by Ben Forta in his CF 7 book. I like these 2 impementations 1. http://www.johnwbartlett.com/CF_tipsNtricks/index.cfm?TopicID=72 2. http://paginationcfc.riaforge.org/ But if the query is run *every time* when you go to next page, inst it defeating the very purpose of pagination i.e. less load in performing query to get 1000's of records at once. Anyone knows how to tackle this problem, so that query is run once and then you can move around in the record set by next previous links. I am curious to know how other people are doing this. Thanks, Ajas Mohammed / http://ajashadi.blogspot.com We cannot become what we need to be, remaining what we are. No matter what, find a way. Because thats what winners do. You can't improve what you don't measure. Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives. - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] CF Applications hosted on third party webserver/hosting services
That's awesome - I wonder if someone can hijack your session?! Charlie, how secure is your site?! =) From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of shawn gorrell Sent: Tuesday, February 17, 2009 2:29 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] CF Applications hosted on third party webserver/hosting services For anyone that needs tool advice, I'd recommend bookmarking this link to Charlie's site. http://www.carehart.org/cf411/?CFID=155996CFTOKEN=14df06d00161ffbb-85B4F706-90BC-5757-5CD21E2BC185306B From: Ramirez, Ruben - Curtis 1000 rrami...@curtis1000.com To: discussion@acfug.org Sent: Tuesday, February 17, 2009 2:11:29 PM Subject: RE: [ACFUG Discuss] CF Applications hosted on third party webserver/hosting services SeeFusion has been an invaluable tool for us. I initially heard about this from John Mason at one of his talks. http://www.seefusion.com/ Ruben From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Ajas Mohammed Sent: Tuesday, February 17, 2009 2:00 PM To: discussion@acfug.org Subject: [ACFUG Discuss] CF Applications hosted on third party webserver/hosting services Hi, Before I go to google and search for *performance optimization* *monitoring* CF Applications, and how to check what parts are killing the application, I thought I would ask here first. We have application which is doing well supporting lot of clients. We are CF 7, IIS, Windows Server 2003 shop. We have about 6 - 8 applications, all same code base, hosted on third party hosting services. I can access CF Admin etc. As the transactions are growing, we have noticed that its getting slower and slower. So any inputs as to how to track 1. what part of cf code is running slow 2. any tools (if open source that would be nice) . I remember CF also has something, but never had chance to look at it. 3. most importantly, how do i get started monitoring load etc on the CF Server. Thanks for your patience and apologies, if I have missed any information that you need to answer my questions. FYI, I wanted to do this long time back, but could not because of work deadlines but looks like I have to find time to sort this critical issue ASAP. Ajas Mohammed / http://ajashadi.blogspot.com We cannot become what we need to be, remaining what we are. No matter what, find a way. Because thats what winners do. You can't improve what you don't measure. Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives. - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLinkhttp://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLinkhttp://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] ISO 8601 date
Try the CF Function CreateODBCDateTime() http://livedocs.adobe.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/wwhelp.htm?context=ColdFusion_Documentationfile=0357.htm From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Teddy R. Payne Sent: Tuesday, January 27, 2009 3:17 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] ISO 8601 date cfset strTimeStamp = DateFormat(now(), -MM-DD) T TimeFormat(now(), HH:MM:SS) -05:00 Quick and dirty. Teddy R. Payne, ACCFD Google Talk - teddyrpa...@gmail.commailto:teddyrpa...@gmail.com On Tue, Jan 27, 2009 at 3:05 PM, Kevin Hellriegel khell...@gmail.commailto:khell...@gmail.com wrote: I need to create a dateTime for the Fedex ShipService webservice that looks like this: 2009-01-27T14:45:23-05:00. You've got the date, the letter T, the time and offset from GMT. I've created a string, but the web service blows up with the ever useful Cannot find webservice... If I use Now() instead, the webservice returns the data I need, but with a warning saying the field (ShipTimestamp) is invalid. I've been looking through the axis API and cannot figure out what to use. Any ideas? Thanks, Kevin - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
[ACFUG Discuss] RE: cf datasources
Troy, Yes, you can keep that information...Depending on what version of CF you're running, you may need more files to make the backup work... But, if you're running in full on jrun mode, the path will look like this c:\jrun4\servers\cfusion\cfusion-ear\cfusion-war\WEB-INF\cfusion\lib I can't remember what the pathing looks like for a standalone CFMX install, but you should be able to find it fairly easy... You'll want to back up that entire lib folder - neo-query.xml was good enough in cfmx 7 I believe...in 8, there are additional files that I cannot remember. From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Troy Jones Sent: Friday, January 16, 2009 3:52 PM To: discussion@acfug.org Subject: [ACFUG Discuss] cf datasources We had an event on one of our servers that has rendered CF unusable and needing a uninstall/reinstall. However, this means that we will lose our configured data sources. Does anyone know of a way to get this information before we uninstall the program or are we just pretty much SOL? Troy Jones Dynapp Support Team 678-528-2952 - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLinkhttp://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] cf datasources
I just did some poking around - in CF8 the files you would need are (at minimum) neo-clientstore.xml neo-datasource.xml From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Troy Jones Sent: Friday, January 16, 2009 4:00 PM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] cf datasources Therein lies my problem, CF is totally unusable in its current state. I can’t even open the administrator ☹. Troy Jones Dynapp Support Team 678-528-2952 From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Teddy R. Payne Sent: Friday, January 16, 2009 3:57 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] cf datasources In your ColdFusion administrator, there is a settings summary that will capture all of your DSN connection information with the exception of the username and password for the said connections. Teddy R. Payne, ACCFD Google Talk - teddyrpa...@gmail.commailto:teddyrpa...@gmail.com On Fri, Jan 16, 2009 at 3:51 PM, Troy Jones t...@dynapp.commailto:t...@dynapp.com wrote: We had an event on one of our servers that has rendered CF unusable and needing a uninstall/reinstall. However, this means that we will lose our configured data sources. Does anyone know of a way to get this information before we uninstall the program or are we just pretty much SOL? Troy Jones Dynapp Support Team 678-528-2952 - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserformhttp://www.acfug.org/?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLinkhttp://www.fusionlink.com/ - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLinkhttp://www.fusionlink.com - 뮴躻.nǫ???+%?˦jv?{*.??辩^n???硶ڿ?Ǯ??ཀྵh?)+n????ڿ?Ǯ??ཀྵh?)+n???i?۬Z+??ފw豧?۩??? +???X??ȭ???q?x%?ˬ?۩?f???܆+??v+?ˢ?~4iǮ??ྛmV?r?yʦ +??Ⲙh?םo??硶ڿ?뢢yb?G(?[???ˊy?i? N�r��yb�X��f�j���鮇���mq
RE: [ACFUG Discuss] Switch to CF8
You would still have to upload the file to the server using the cffile tag. He's having a problem getting the file to the server in the first place so I don't think cfftp is going to help. From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin Ford Sent: Saturday, November 01, 2008 8:46 AM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] Switch to CF8 Would the cfftp tag serve your purpose for this? The server would be handling the transfers so your users can be oblivious to where it's actually going. You could have the user pick files using an input type='file' tag to browse for file names, then pass those to cfftp to handle the upload. Note that CF8 also adds SFTP support to the cfftp tag. If you decide to try cfftp, do a little googling on it. There are a few little tricks that people have figured out that may make life much easier. For instance: http://www.bennadel.com/blog/1337-My-First-ColdFusion-8-CFFTP-Experience-Rocky-But-Triumphant.htm Kevin On Mon, Oct 27, 2008 at 4:08 PM, Forrest C. Gilmore [EMAIL PROTECTED]mailto:[EMAIL PROTECTED] wrote: If FTP is the way to upload files, why is there a CFFILE tag for this? I'm reluctant to give my users FTP access to the web site. The uploads need to go to 6 different folders, depending on the nature of the file. With CFFILE, I can let them select the proper folder, limit access to only those selected folders, and control the type of file that can be uploaded. My users don't need to know or negotiate the file structure of the site. Is there a way this can be done with FTP? I suppose I could set up a bunch of separate limited FTP accounts, but the CFFILE approach seems to be optimum. Other than uploading large files, around 80 MB or larger, this has worked fine, and it still works fine with Mozilla. IE will upload files as large as 30 MB, but it seems to choke on an 80MB file. I have not done enough testing to determine where the actual choke point lies. 64 MB maybe? Forrest C. Gilmore == Fennell, Mark P. wrote: It might be faster and less painful to use an FTP client to transfer files since ftp is the file transfer protocol. ;) mf -Original Message- From: [EMAIL PROTECTED]mailto:[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]mailto:[EMAIL PROTECTED]] On Behalf Of Justin Haygood Sent: Monday, October 27, 2008 1:39 PM To: discussion@acfug.orgmailto:discussion@acfug.org Subject: RE: [ACFUG Discuss] Switch to CF8 IE can only upload files up to 2 GB or 4 GB (one of the two...) anything smaller should work. -Original Message- From: [EMAIL PROTECTED]mailto:[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]mailto:[EMAIL PROTECTED]] On Behalf Of Forrest C. Gilmore Sent: Friday, October 24, 2008 9:04 PM To: discussion@acfug.orgmailto:discussion@acfug.org Subject: Re: [ACFUG Discuss] Switch to CF8 The thing that has me stumped about the upload, and seems to point to an issue with IE, is that Mozilla uploads the large file, using the exact same CF pages, that have no browser-specific code, without any problem. Forrest C. Gilmore -- Shane Heasley wrote: CF7 and earlier have to load the entire file into memory when doing uploads - so with large files you can run into heap problems. CF8 uses a different method. It was possibly coincidence that you only noticed the problem using IE? Moving to 8 might solve the problem. Cheers, www.CTek-Media.comhttp://www.CTek-Media.com To deal with my upload issue, my ISP wants to switch my site from CF7 to CF8. I am inclined to do so. Are there any Gotcha's I need to be aware of? Forrest C. Gilmore - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=gin.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLinkhttp://www.fusionlink.com - - To unsubscribe from this list, manage your profile @
RE: [ACFUG Discuss] Cookies/Sessions when opening a new window in tabbed browsers
Well..maybe, maybe not... Just for theoretical sake...you COULD make this work - would it be worth the trouble, that really depends on how many users do what was described below. But, you COULD get creative... Something like this. Let's say that there's a portal page to your application...you could actually force a new cfid and cftoken on that page and ALSO, you'd have to make sure it wasn't a temporary cookie. You'd have to make it a persistent cookie so that it wasn't in the browsers memory (otherwise they'd collide). Then, each tab would basically have it's own cfid/cftoken pair that would be unique to those browser sessions and you could have the user running two different sessions at a time. If you're not familiar with how the cookie is handled for the cf session, you'll definitely want to do some reading on that. Now, I will say with that with this approach, you may run into some weird things that you had not thought about before...but in theory, it's possible. Allen From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Steven Ross Sent: Thursday, July 03, 2008 12:33 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] Cookies/Sessions when opening a new window in tabbed browsers What you are asking to do really isn't possible because of the stateless nature of http because you can't tell where the user is coming from. If they are authenticated then the application / web server has no idea what client (browser window) they are coming from and will let them perform any task from multiple windows (unless they launch a completely new instance of the browser - which like you said would only work if you were not using cookie based authentication). Sounds like you just need to educate your users a bit. -Steve On Thu, Jul 3, 2008 at 12:11 PM, Bruce Hodgdon [EMAIL PROTECTED]mailto:[EMAIL PROTECTED] wrote: Is there any way to force a new session, if a user opens a new tab then goes to the same app that is in the first window? We use the pretty standard cfapplication that allows cookies and session management. I have found that sometimes users will open a new tab and go to the same application basically executing the app twice from different windows.But since both these windows share session variables this can sometimes cause problems (changes in one window effect the other).Executing the browser twice keeps separate sessions.But since this is 2 windows in the same browser the cookie that points to the session id is the same. I guess one way around this is cookieless sessions, then I believe you would have to put the jsessionid on each url? I don't like doing that.And that wouldn't stop someone from copying and pasting the URL to another window and having the same issue. Or is there a good way to tell if the user does have 2 windows open with the same session? Or other slick ways around this issue? - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLinkhttp://www.fusionlink.com - -- Steven Ross web application interface developer http://blog.stevensross.com [mobile] 404-488-4364 [fax] (404) 592-6885 [ AIM / Yahoo! : zeriumsteven ] [googleTalk : nowhiding ] - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLinkhttp://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] Cookies/Sessions when opening a new window in tabbed browsers
I'll take your word for it... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dean H. Saxe Sent: Thursday, July 03, 2008 12:50 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] Cookies/Sessions when opening a new window in tabbed browsers Allen, Sorry, but you are wrong here. You cannot do that. If the cookie is on disk, it is shared across all browser instances. Session cookies (non-persistent) may work if you can guarantee separate browser instances, which you can't do with tabs. I'd suggest some reading on the basics of the HTTP protocols for further info. The HTTP book from O'Reilly is good. -dhs Dean H. Saxe, CISSP, CEH [EMAIL PROTECTED] [T]he people can always be brought to the bidding of the leaders. This is easy. All you have to do is to tell them they are being attacked, and denounce the pacifists for lack of patriotism and exposing the country to danger. It works the same in every country. --Hermann Goering, Hitler's Reich-Marshall at the Nuremberg Trials On Jul 3, 2008, at 12:44 PM, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Well..maybe, maybe not... Just for theoretical sake...you COULD make this work - would it be worth the trouble, that really depends on how many users do what was described below. But, you COULD get creative... Something like this. Let's say that there's a portal page to your application...you could actually force a new cfid and cftoken on that page and ALSO, you'd have to make sure it wasn't a temporary cookie. You'd have to make it a persistent cookie so that it wasn't in the browsers memory (otherwise they'd collide). Then, each tab would basically have it's own cfid/cftoken pair that would be unique to those browser sessions and you could have the user running two different sessions at a time. If you're not familiar with how the cookie is handled for the cf session, you'll definitely want to do some reading on that. Now, I will say with that with this approach, you may run into some weird things that you had not thought about before...but in theory, it's possible. Allen From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Steven Ross Sent: Thursday, July 03, 2008 12:33 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] Cookies/Sessions when opening a new window in tabbed browsers What you are asking to do really isn't possible because of the stateless nature of http because you can't tell where the user is coming from. If they are authenticated then the application / web server has no idea what client (browser window) they are coming from and will let them perform any task from multiple windows (unless they launch a completely new instance of the browser - which like you said would only work if you were not using cookie based authentication). Sounds like you just need to educate your users a bit. -Steve On Thu, Jul 3, 2008 at 12:11 PM, Bruce Hodgdon [EMAIL PROTECTED] wrote: Is there any way to force a new session, if a user opens a new tab then goes to the same app that is in the first window? We use the pretty standard cfapplication that allows cookies and session management. I have found that sometimes users will open a new tab and go to the same application basically executing the app twice from different windows.But since both these windows share session variables this can sometimes cause problems (changes in one window effect the other).Executing the browser twice keeps separate sessions. But since this is 2 windows in the same browser the cookie that points to the session id is the same. I guess one way around this is cookieless sessions, then I believe you would have to put the jsessionid on each url? I don't like doing that.And that wouldn't stop someone from copying and pasting the URL to another window and having the same issue. Or is there a good way to tell if the user does have 2 windows open with the same session? Or other slick ways around this issue? - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - -- Steven Ross web application interface developer http://blog.stevensross.com [mobile] 404-488-4364 [fax] (404) 592-6885 [ AIM / Yahoo! : zeriumsteven ] [googleTalk : nowhiding ] - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink -
RE: [ACFUG Discuss] OT: problem with IIS on XP Pro.
I think the cost for a developer license of SQL Server is in the neighborhood of $50 - and it's the equivalent of enterprise. From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dusty Hale Sent: Tuesday, June 10, 2008 10:28 AM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] OT: problem with IIS on XP Pro. Haha poor little me in Costa. Yes beautiful country. I'm in Tamarindo shooting surfing photos (my side job) and trying to carry on development at the same time. I could have sworn I installed SQL Express but I think you are right because it doesn't say express in the event viewer. It might be easier for me to just pay the license rather than having to uninstall, reinstall, then piece the database back together (being that I can't get to it now). I can't seem to figure out how to just purchase the license though. Hopefully there is a development price. Do you know anything about this? Many thanks for your help. Dusty From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Charlie Arehart Sent: 06/10/2008 9:52 AM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] OT: problem with IIS on XP Pro. Are you sure that's SQL Server Express? Yes, it should be free with no eval period. It sure sounds like it's the full version (not the express). Does the error in Event Viewer identify the source as the express edition? In my machine, it shows specifically as MSSQL$SQLEXPRESS? I see a couple other instances of people asserting your problem, and they said their only solution was to remove and reinstall. I really wonder though if they are really looking at errors from the Express edition. I'll trust your reply to confirm things in your case. :-) If you have no choice, are you able to uninstall/reinstall? BTW, though I received this before your other note about being desperate in Costa Rica (a seeming contradiction for such a beautiful country), I see that you sent this 2nd, so it seems you've at least targeted the real source of the problem, right? Glad that the suggestion to look in event viewer helped. /charlie From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dusty Hale Sent: Monday, June 09, 2008 9:28 PM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] OT: problem with IIS on XP Pro. I checked event viewer under application. The errors for SQL say the evaluation period is over. I'm using SQL express though and thought it was free. Does this sound right? Dusty From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Charlie Arehart Sent: 06/09/2008 8:47 PM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] OT: problem with IIS on XP Pro. Are you looking in the Windows Event Viewer, or SQL Server log files, to get more info? Also, as for your info on running multiple IIS sites on XP, there are still other ways including the free tool IISAdmin, at http://www.firstserved.net/help/downloads. Doesn't get around the limitation of *running* more than one at a time, but at least is an interface option over the command line option below. Hope that helps someone. /charlie From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dusty Hale Sent: Monday, June 09, 2008 3:47 PM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] OT: problem with IIS on XP Pro. So now that I figured out CF was stopping and causing this, I have that going again. But SQL will not start. Everytime I try to push the start button I get an error that says sometimes services stop because they have no work to do. I've tried rebooting. Does anyone know why SQL would stop itself and then refuse to start again? From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dusty Hale Sent: 06/09/2008 3:27 PM To: discussion@acfug.org Subject: [ACFUG Discuss] OT: problem with IIS on XP Pro. Hi I used the method below to run multiple sites in IIS on XP Pro. It has always worked fine until today. Now the extra site I have always been able to use is not working. The default site still works fine. All other I get the generic Cannot find server error. If anyone know why this might be happening or a remedy for it, I would greatly appreciate it. I already tried deleting the second site and recreating it but same thing happens. The only other thing I know to do is maybe uninstall IIS completely and reinstall it and try again. In the server versions of Windows, you can have multiple versions of web sites installed into IIS and running simultaneously. You can install and run more than one web site within IIS in the professional version of Windows XP or Windows 2000. You just have to pull a trick to modify the IIS metabase to that it is aware of the additional sites. The user interface does not support creating more than one web site. Also, you still will not be able to have more
RE: [ACFUG Discuss] CFcontent Timout
cfset requestTimeout=760 / Or whatever number of seconds you'd like to put in there From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Clarke Bishop Sent: Tuesday, April 22, 2008 2:36 PM To: discussion@acfug.org Subject: [ACFUG Discuss] CFcontent Timout I have a large PDF document (2MB eBook) that sometimes is failing to fully download. It's a static PDF, and all I am doing is: cfheader name=Content-Disposition value=attachment; filename=MyDoc.pdf cfcontent type=application/pdf file=MyDoc.pdf Is there some sort of timeout I should set to keep this from quitting prematurely? Thanks for any ideas ... Clarke - Annual Sponsor - Figleaf Softwarehttp://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLinkhttp://www.fusionlink.com - - Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] QoQ question
I think there's misunderstanding. The column names are what had the spaces in them. The guy who said SELECT [column name] as ColumnName probably has the best solution. Trim function likely won't help in this situation at all. Allen From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of shawn gorrell Sent: Friday, April 18, 2008 9:07 AM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] QoQ question How would Trim() remove an embedded space? - Original Message From: McTure, Greg [EMAIL PROTECTED] To: discussion@acfug.org Sent: Friday, April 18, 2008 8:54:51 AM Subject: RE: [ACFUG Discuss] QoQ question Hi Scott: Couldn’t you use a TRIM function in the original query to eliminate the spaces? In SQL Server, it would actually be something like: SELECT RTRIM(LTRIM(col_with_spaces)) FROM TABLE. From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Scott Councill Sent: Thursday, April 17, 2008 4:25 PM To: discussion@acfug.org Subject: [ACFUG Discuss] QoQ question I am writing a query of query where the result set in the original query has spaces in the field names. I know when you are querying a database, you use [Field Name] as the syntax but CF is throwing an error when I do this with the QoQ. Any ideas how I can call the fieldname with spaces in a QoQ? J. Scott Councill Software Engineer II Direct: 404.601.4390 Cell: 804.267.9555 [EMAIL PROTECTED]mailto:[EMAIL PROTECTED] Spunlogic Expect More From the Web www.spunlogic.comhttp://www.spunlogic.com/?CMP=EMC-OutlookSig Looking for insights and tips on all aspects of interactive marketing? Visit Spunlogic's Bloghttp://www.spunlogic.com/blog/?CMP=EMC-OutlookSig for a look inside the minds of a leading interactive agency. - Annual Sponsor - Figleaf Softwarehttp://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLinkhttp://www.fusionlink.com - - Annual Sponsor - Figleaf Softwarehttp://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLinkhttp://www.fusionlink.com - - Annual Sponsor - Figleaf Softwarehttp://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLinkhttp://www.fusionlink.com - - Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] QoQ question
Shot in the dark... Have you tried putting quotes around the column name? SELECT column name, column 2 from myQuery ? From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Scott Councill Sent: Friday, April 18, 2008 2:25 PM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] QoQ question Thanks to all for comments. I should have been more detailed. Yes, spaces in field names is very bad. I am working with a process that uploads an Excel Spreadsheet that is created by a client. Yes, I could go back to them and tell them no spaces, but I wanted to try to find a solution that wouldn't require that. Once the SS has been uploaded, I then create a JDBC connection to the workbook and read the data in a specific sheet. That works fine. Now I have a query object that I am trying to join to a SQL database query to compare values. Yes, I can loop over the SS query and do lots of separate queries but I wanted to create a single query solution with a JOIN statement. So the answer seems to be NO QoQ does not support column names with spaces, not even using the proper [] bracket syntax. Is this correct? J. Scott Councill Software Engineer II Direct: 404.601.4390 Cell: 804.267.9555 [EMAIL PROTECTED]mailto:[EMAIL PROTECTED] Spunlogic Expect More From the Web www.spunlogic.comhttp://www.spunlogic.com/?CMP=EMC-OutlookSig Looking for insights and tips on all aspects of interactive marketing? Visit Spunlogic's Bloghttp://www.spunlogic.com/blog/?CMP=EMC-OutlookSig for a look inside the minds of a leading interactive agency. From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Cameron Childress Sent: Friday, April 18, 2008 9:19 AM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] QoQ question To be fair, QoQ solves an entirely different problem than Stored Procs. QoQ was also not designed to be an entire DB server, and hopefully never will be. QoQ is quirky as hell, yes, but for the newbies out there on the list it would be wrong (IMHO) to make a blanket recommendation about using stored procedures or functions instead of QoQ without pointing out that they solve entirely different problems, and really the question of which (SP or QoQ) you should use would hopefully have been asked an answered way before this point in Scott's development (which I'm sure it was). -Cameron On Fri, Apr 18, 2008 at 9:03 AM, Tommy Geist [EMAIL PROTECTED]mailto:[EMAIL PROTECTED] wrote: If I may offer some CONSTRUCTIVE answers like John, Query of Queries are very limited in their abilities compared to what modern databases will do. I believe they are even behind the basic mySQL so I would recommend using stored procedures or functions instead of QoQ. -- Cameron Childress Sumo Consulting Inc http://www.sumoc.com --- cell: 678.637.5072 aim: cameroncf email: [EMAIL PROTECTED]mailto:[EMAIL PROTECTED] - Annual Sponsor - Figleaf Softwarehttp://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLinkhttp://www.fusionlink.com - - Annual Sponsor - Figleaf Softwarehttp://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLinkhttp://www.fusionlink.com - - Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] QoQ question
Scott, One last suggestion - why not save the data into a new query object with the fixed column names and then use the new query: cfquery name=qryTest datasource=mydsn select top 10 [first name], [last name] from some_table /cfquery cfset newQuery=QueryNew(Replace(qryTest.columnList, , _, ALL)) / cfset newQuery = QueryNew() cfloop from=1 to=#ListLen(qryTest.columnList)# index=i cfset dataArray = ListToArray(ArrayToList(qryTest[ListGetAt(qryTest.columnList, i)])) cfset QueryAddColumn(newQuery, ReplaceNoCase(ListGetAt(qryTest.columnList, i), , _, ALL), varchar, dataArray) / /cfloop cfdump var=#qryTest# cfdump var=#newQuery# From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Howard Fore Sent: Friday, April 18, 2008 2:52 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] QoQ question Scott, Have you thought about using the POI stuff to read the Excel sheet? There's a lot of info on a CFC implementation at http://www.bennadel.com/blog/474-ColdFusion-Component-Wrapper-For-POI-To-Read-And-Write-Excel-Files.htm. True, that info then comes in as a struct but you could loop over the struct and create query without the spaces in the column names as you need for QOQ. Just a thought... Howard On Fri, Apr 18, 2008 at 2:25 PM, Scott Councill [EMAIL PROTECTED]mailto:[EMAIL PROTECTED] wrote: Thanks to all for comments. I should have been more detailed. Yes, spaces in field names is very bad. I am working with a process that uploads an Excel Spreadsheet that is created by a client. Yes, I could go back to them and tell them no spaces, but I wanted to try to find a solution that wouldn't require that. Once the SS has been uploaded, I then create a JDBC connection to the workbook and read the data in a specific sheet. That works fine. Now I have a query object that I am trying to join to a SQL database query to compare values. Yes, I can loop over the SS query and do lots of separate queries but I wanted to create a single query solution with a JOIN statement. So the answer seems to be NO QoQ does not support column names with spaces, not even using the proper [] bracket syntax. Is this correct? -- Howard Fore, [EMAIL PROTECTED]mailto:[EMAIL PROTECTED] The universe tends toward maximum irony. Don't push it. - Jeff Atwood - Annual Sponsor - Figleaf Softwarehttp://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLinkhttp://www.fusionlink.com - - Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] looking for opinions on duplicate form submissions
Ok...that is a tougher one One suggestion is this (high level)... if your database table isn't too large and is indexed properly, you might consider having something like this: On the top of your form (or somewhere that will be visible at all times), have a summary box that updates as you enter information into each field. So, for instance, if you have first name, last name, and city on a form, after you exit the first name field (it loses focus), you could run a query behind the scenes to find out how many entries are in the table with a combination of filled out fields. As a user finishes up the form, the summary box may show that their are currently 2 entries that are similar to the one entered on the form and give them the ability to view those other entries before saving the form). Just an idea. _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Howard Sent: Thursday, March 20, 2008 11:20 AM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] looking for opinions on duplicate form submissions These duplicates are not necessarily session duplicates. A user, or even a different user might input the same information from a hard-copy form into the system a day or two later. Basically, I'm trying to look into the database and compare all fields values with those of the submitted form, and if they're identical I'm displaying a message saying something to the effect of check these and make sure you're not duplicating someone's work. If after comparing, they decide that it's not a duplicate they hit ok and it commits. The trick here, is that all the form data can be identical and something in the attachments could be different, so the user has to look at the previous entries to decide if it's a duplicate or not and then click 'save' or 'cancel'. On Thu, Mar 20, 2008 at 11:03 AM, Dean H. Saxe [EMAIL PROTECTED] wrote: Put a unique identifier in the form request, store it in the user's session before form submission. Once the form is submitted check to see if the value matches. If so delete it from the session and continue processing. If the token doesn't match or is nonexistent in the session, then its a duplicate or out of order submission. -dhs Dean H. Saxe, CISSP, CEH [EMAIL PROTECTED] Free speech exercised both individually and through a free press, is a necessity in any country where people are themselves free. -- Theodore Roosevelt, 1918 On Mar 20, 2008, at 10:51 AM, Jeff Howard wrote: I'm working on an application where a form is submitted along with various attachments (doc, pdf, xls, etc). Apparently users are submitting the same request several times and I've been asked to address this issue. At first thought, it seemed quick and simple to me, but as I've started working on it I can't decide exactly how to handle the attachments in associated with the form in the most efficient way. That brings me here. I was looking for suggestions on how to handle the attachments while I run validation on the db to see if the input from the form already exists in the db. It seems like something that would be perfect for AJAX to handle, but my AJAX skills are virtually nonexistent. So, without using AJAX (or if you can break it down using AJAX for a novice) how would you handle the situation? The main issue I'm having, is that if I do the validation after the form submission, CF is assigning a temp directory to my attachment file. So what is submitted as this: C:\Documents and Settings\JHoward\Desktop\PO Request mods.doc ends up as this after submission and validation: C:\ColdFusion8\runtime\servers\coldfusion\SERVER-INF\temp\wwwroot-tmp\n eotmp13963.tmp and then when I pass it to the CFFILE, it tells me the file doesn't exist. I'm really just looking at the different ways other people would handle this situation to try and decide so any input would be great. Thanks in advance. Jeff - Annual Sponsor - Figleaf Software http://www.figleaf.com/ To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform http://www.acfug.org/?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com/ - - Annual Sponsor - Figleaf Software http://www.figleaf.com To unsubscribe from this list, manage
RE: [ACFUG Discuss] will Ajax go away (was JVM version and ColdFusion)
Just a quick .02 from me. Your last statement grabbed my attention... Do you think AJAX is or will be as useful and powerful as CF? I think maybe you're looking at AJAX wrong. AJAX is something that is typically used in conjunction with CF, PHP, ASP.NET, etc. AJAX is there to do a couple of things: 1. Improve the interface/interaction for end users 2. Reduce the amount of network traffic (less reloading of images, etc) 3. Create a more universal interface (use of JSON or XML can be used among many server platforms including CF, PHP, ASP.NET, etc) Chances are, you're still going to be using CF at least as a back end to retrieve, store, validate, etc. You will probably even use it for the front end and intermingle your AJAX with your CF. That is the most common usage of AJAX. If you're scared of it a bit, I would suggest using existing libraries to ease your pain. There are several good ones out there, my favorite being: http://www.jquery.com/ http://prototypejs.org/ So, don't think of AJAX as replacing languages, think about it as accompanying them. And, a thought on the Google interfaces or even other ones...just because you hear that Google has an AJAX interface doesn't mean you can't use ColdFusion to grab the data and parse it just as Javascript does! AJAX is just a method for retrieving data. Think of it as cfhttp in javascript. Anything you can call through AJAX, you can call through a CFHTTP (or even a browser's own url)... Hope that helps a little. Allen -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Forrest C. Gilmore Sent: Friday, February 08, 2008 3:03 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] will Ajax go away (was JVM version and ColdFusion) Some interesting benchmark results! Also thanks for noting the security issues, etc. with AJAX and Javascript. I guess my somewhat negative attitude toward AJAX has to do with its Javascript underpinings. It's Javascript that I tend to dislike. I mean, I like being able to write code that runs in the browser and lets you do things like data validation and build smarts into the page, but it is so quirky, case sensitive, and difficult to troubleshoot that it's very time-consuming to use. One good thing is that it's easy to copy and use code developed by others. However, users can easily turn off Javascript in their browsers, and many do so because of the bad things some sites do with it. The thing I love about CFML is that it uses tag-based code that is generally very understandable, encapsulates most of the underlying complexity, and gives very helpful error messages. I've not found any other web page coding language that is as easy to use. Granted, it has it's limitations, but I still prefer to use CFML and CFX code wherever I can. One downside, however, is that some CF functions actually generate Javascript code in the HTML page returned from the server. At least I don't have to worry about the syntax of that JS code! Now, if Google and others want to design services that I can easily invoke in a way that is not prone to error, or at least gives clear error messages, I don't care whether it's AJAX or anything else. Have you found these AJAX APIs easy to implement and error-free? While I'm in no way a professional programmer, over the years I have used Fortran, Dartmouth Basic, MS Basic, Visual Basic, Delphi (Pascal based, originally), and Lotus Notes Script (similar to Javascript and Basic), in addition to CF Script and CFML. My professional career was ending as the C languages and Java were coming to the forefront, so I didn't see the need to get into these technologies. When CF came along, I felt that Jeremy Allaire and Ben Forta were really onto something that would make it possible for amateurs like me to get some useful work done using the web. Do you think AJAX is or will be as useful and powerful as CF? Forrest C. Gilmore Darin Kohles wrote: Speaking of Benchmarks: http://www.jamesward.org/census/ On Feb 8, 2008 11:52 AM, Darin Kohles [EMAIL PROTECTED] wrote: You can always build a Flex (or Flash for that matter) application that can be put in you page as a 1px by 1px (I'm not sure if 0 by 0 will work) that has nothing on the stage with wmode=transparent. This application can now act as your portal between the browser via JS using the External Interface (or fsCommand going back to Flash ~6). Then your invisible Flex/Flash app can leverage all the connection types available (AMF/SecureAMF, Webservice, HttpService etc...) in a manner that is not easily accessible to any hacker (you can hide all kinds of security checks within this app). I've always wanted to do a bench mark of this type of app side by side with standard Ajax, but the bottom line is that the only browser specific code would be in how the returned data is applied to effect the client content. On Feb 8, 2008 11:20 AM,
RE: [ACFUG Discuss] Session variables
There are SOME situations where they can be a problem..if you have a single sign on type of interface for several applications and users can open new browser windows and *expect* to be able to go directly to another one of their secured apps, the sessions won't exist in the new browser and may cause problems. I'm sure there are workarounds, but I thought I'd throw that out there. The J2EE sessions are browser specific so opening a fresh browser will essentially disassociate the CF session with the new browser window. Allen -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Dean H. Saxe Sent: Wednesday, August 29, 2007 1:12 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] Session variables The J2EE session tokens have more entropy, which is always a good thing. I too see no reason to use the old ones. Dean H. Saxe, CISSP, CEH [EMAIL PROTECTED] Dissent is the purest form of patriotism. --Thomas Jefferson On Aug 29, 2007, at 12:55 PM, shawn gorrell wrote: I guess I don't know why anyone would use the old session variables anymore. I always use the J2EE session variables instead. Maybe someone can enlighten me to the any benefits or trade-offs of either choice. - Original Message From: Charlie Arehart [EMAIL PROTECTED] To: discussion@acfug.org Sent: Wednesday, August 29, 2007 11:51:46 AM Subject: RE: [ACFUG Discuss] Session variables Just to clarify, this isn't something you can do at the application level in CF8. I was under the impression myself for a while that we could do pretty much everything at the app level now, but it's just mappings and custom tag paths. Perhaps in a later release. :-) So, no, the J2EE sessions mechanism is a one for all and all for one sort of thing (unless of course one runs on Enterprise and creates another instance). /charlie From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Douglas Knudsen Sent: Wednesday, August 29, 2007 9:30 AM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] Session variables well...if your on CF8 I believe you can set this at the application level. Aside from that, what is breaking? In the past I had several apps running on a server with standard cf session vars and turned 'use J2EE session vars' on without incident. DK On 8/29/07, Fennell, Mark P. [EMAIL PROTECTED] wrote: Greetings, Is is possible to use J2EE session variables in one CFApplication and standard session variables in another? I have a server that is running two cfapplications and one uses J2EE variables and seems to not work so well when J2EE Sess Vars is disabled in cf admin. The other applications totally breaks if I have J2EE enabled. I was hoping that, before I set about actually fixing the problem with code that there might be some setting in the cfapplication tag that I can use to enable/disable j2ee vars for a specific application... I'm completely prepared to recode, I just wanted to check and see if anyone had an easy way out. Thanks. mf - Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?falogin.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - -- Douglas Knudsen http://www.cubicleman.com this is my signature, like it? - Annual Sponsor - Figleaf Software To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - - Annual Sponsor - Figleaf Software To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - - Annual Sponsor - Figleaf Software To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - - Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list,
RE: [ACFUG Discuss] CFQueryParam
When you get to your where clause you can do something like a loop over parameters if you need to...let's say for instance you have something like this: cfset aStruct = StructNew() cfset aStruct.columnNameA = 100 cfset aStruct.columnNameB = SomeValue cfquery ... SELECT * FROM Blah WHERE cfloop collection=#aStruct# item=key #key# = cfqueryparam cfsqltype=CF_SQL_VARCHAR value=#aStruct[key]# /cfloop /cfquery Granted, this is just a sample... Allen -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Charlie Stell Sent: Wednesday, August 01, 2007 11:18 AM To: discussion@acfug.org Subject: [ACFUG Discuss] CFQueryParam Does anyone know if CFQueryParam is offered in a function version? Im trying to build out a dynamic query string and then use that for the where clause... Thanks! Charlie - Annual Sponsor - Figleaf Software http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com - - Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] text editors
Just to clarify - Jeff is looking for a text editor that is embedded in a web page that has functionality similar to that of a word processor (like Microsoft word) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of david lee Sent: Friday, July 27, 2007 4:35 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] text editors OOPs, my bad...it's www.textpad.com david lee [EMAIL PROTECTED] wrote: Jeff, I have been using TextPad since my college days... www.testpad.com http://www.testpad.com/ Jeff Howard [EMAIL PROTECTED] wrote: Any suggestions on a good text editor to use in my apps. I've been using FCKeditor but it leaves a something to be desired, and seems like even more to be desired the more I use it. - Annual Sponsor - Figleaf http://www.figleaf.com/ Software To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform http://www.acfug.org/?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com/ - _ Ready for the edge of your seat? Check out http://us.rd.yahoo.com/evt=48220/*http://tv.yahoo.com/ tonight's top picks on Yahoo! TV. - Annual Sponsor - Figleaf Software http://www.figleaf.com/ To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform http://www.acfug.org/?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com/ - _ Building a website is a piece of cake. Yahoo! Small Business gives you all http://us.rd.yahoo.com/evt=48251/*http://smallbusiness.yahoo.com/webhosting/?p=PASSPORTPLUS the tools to get online. - Annual Sponsor - Figleaf Software http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com - - Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] writing a Content Mngmt system in CF..FAQ or Howto?
Your best bet is to download Joomla or Mambo or something similar and just look at their database tables, do some changes, and see how they're handling it. I mean, I hate to say it, but reverse engineering is the way to go here. Some of these systems are fairly tried and true and you'd be best off just digging through their schemas, code, etc. Allen -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Ajas Mohammed Sent: Wednesday, April 11, 2007 4:56 PM To: [EMAIL PROTECTED] Subject: Re: [ACFUG Discuss] writing a Content Mngmt system in CF..FAQ or Howto? thanks guys. But my issue is not exactly about Joomla or any CMS for that matter. Steven, I read that doc on wikipedia before I posted here. What i want is some sort of diagram or doc explaining what or how the cfm or htm page gets created by using the info which is iam 100% sure stored somewhere in the database. So when the user requests index3.cfm, index3.cfm is actually created using values from the db cols like bgcolor, font and the main content, I believe is brought from another table and so on. I need details like these. anyone out there with these high level details??? or can you guide me to a doc/link. thanks, Ajas. On 4/11/07, Fennell, Mark P. [EMAIL PROTECTED] wrote: I'm not sure if this has been mentioned yet, but I've found Katapult to be super simple and ridiculously easy to use... So long as you're running CF on windows... http://labs.fusionlink.com/katapult/index.cfm?page=projects/katapult -Original Message- From: [EMAIL PROTECTED] [mailto: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] ] On Behalf Of Steven Ross Sent: Wednesday, April 11, 2007 11:15 AM To: [EMAIL PROTECTED] Subject: Re: [ACFUG Discuss] writing a Content Mngmt system in CF..FAQ or Howto? for your last question: http://en.wikipedia.org/wiki/Content_management_system not sure how Joomla works, they are all pretty much the same also there is a manual for joomla: http://help.joomla.org/images/User_manual/user_manual_v1%200%201_10%2021 %2006.pdf that may help. On 4/11/07, Ajas Mohammed [EMAIL PROTECTED] wrote: Hello everyone, I came across Joomla which is a great tool and I have heard of so many content management systems(CMS) written in CF. My question is how the application works because all a user is doing is saving some settings in the application for example lets say user saves backgroundcolor property to blue, font to arial etc. Now when user views his website page lets say pagetest.cfm, this page gets the property of bgcolor and font from the CMS and displays it to the user. So my assumptions are : 1) The CF CMS page saves the settings or properties in database. 2) on every new page creation from CMS, a new entry is stored in db i.e. index1.cfm, index2.cfm and so on. Then, my question is how does the page code for lets say index2.cfm gets generated? Also, I am not sure how different pages in the website use/get the property bgcolor, font. At runtime, I guess a query gets info and dynamically generates the pages for the website. Can anybody give me a better idea or general overview from scratch of how the application works? What are the things needed to develop a CMS and so on. I apologize if the question or my explanation is not clear. Thanks -- Ajas Mohammed / http://ajashadi.blogspot.com http://ajashadi.blogspot.com - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - -- Steven Ross web application interface developer http://www.zerium.com http://www.zerium.com [mobile] 404-488-4364 [fax] 267-482-4364 - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?falogin.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - -- Ajas Mohammed / http://ajashadi.blogspot.com - To unsubscribe from this list, manage your
RE: [ACFUG Discuss] developing cf apps with sql server express databases
Yes, developing on express should be fine locally but trying to copy data may be a bit of a pain if you're using studio express as there's no tools for doing data transformations in the express version. However, I think you can buy a developer copy of sql server 2005 for something like $40 (I was just reminded of this today). Allen -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Dusty Hale Sent: Wednesday, April 11, 2007 10:24 PM To: [EMAIL PROTECTED] Subject: [ACFUG Discuss] developing cf apps with sql server express databases Anyone use SQL Server Express for developing CF apps on a local PC with windows XP Pro? Is this a good (cheap) solution for a development platform if the live platform will have SQL Server 2005? Will a database developed with SQL Server Express port over well and is the Interface for SQL Server Express similar to Enterprise Manager? Thx, Dusty - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] CF Eclipse- CVS - Bugzilla
I would definitely look into subversion - I believe there is a plugin for eclipse and the windows integration is very nice. Of all the versioning software I've used to date, it was, by far, my favorite. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Monday, March 19, 2007 12:50 PM To: discussion@acfug.org Subject: [ACFUG Discuss] CF Eclipse- CVS - Bugzilla I know that there have been several discussions on the list over the last few years about various versioning tools, and I'll admit that I've pretty much ignored them because we were locked into a product that we all despised with no end in sight. That day is over and we're actively seeking tools for source control and bug tracking. We'd kind of hoped for products that played nicely with one another, and I was thinking about using Eclipse with CF Eclipse, CVS with Eclipse plugin and Bugzilla with Eclipse plugin. That way we could bin Dreamweaver and do all of our development, source control and bug tracking from a single IDE. Anyone have any experience or feedback on either the whole combination or pieces? I'm hearing rumor mill that a killer new version of CF Eclipse is coming out very soon, so it may be a compelling replacement for DW. Feedback would be greatly appreciated... Shawn Gorrell Web Development Applications Architect Federal Reserve Bank - Atlanta Office (404) 498-8449 - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] CF Error
I don't know what your paths are on your computer, but it appears you're trying to do a cfinclude on a physical file path...you should probably use relative paths such as: cfinclude teamplate=carbs/stores/1/includes/appheader.cfm -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Robert Reil Sent: Wednesday, March 07, 2007 2:54 PM To: discussion@acfug.org Subject: [ACFUG Discuss] CF Error Finally thanks to Charlie's awesome support with Ask Charlie we got the RDS working in DW. I highly reccomend his expertice if needed and the connection through firewalls etc was a non issue. If you can see a web page he can see your screen. With that I am now starting to do some real Development work in DW with real data in a fully functional DW environmnet. FINALLY WHEW!!! Here is my first hurdle: I opened a page that works, saved it in a different web as a template, and allowed DW to update links Now I get this error: The filename, directory name, or volume label syntax is incorrect The error occurred in C:\Inetpub\wwwroot\intranet.motorcyclecarbs.com\sales\search.cfm: line 8 6 : /cfscript 7 : 8 : cfinclude template=file:///Z|/wwwroot/carbs/stores/1/includes/appheader.cfm 9 : cfset resp.setDateHeader(JavaCast(string,Expires) , JavaCast(long,0) ) 10 : cfoutput#req.getAttribute(STYLESHEET)#/cfoutput --- I have not yet mastered error reading in CF so I am wondering what this is saying. I think it is the method of pathing but dont know what it should look like. Any pointers? Robert P. Reil Managing Director, Motorcyclecarbs.com, Inc. 4292 Country Garden Walk NW Kennesaw, Ga. 30152 Office 770-974-8851 Fax 770-974-8852 www.motorcyclecarbs.com http://www.motorcyclecarbs.com/ - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] validation techniques for existing application
There is also QForms if you want to google that. It was implemented pretty well. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Monday, February 26, 2007 7:25 AM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] validation techniques for existing application There is a reusable-extensible (server side) validation component in my Tardis framework. Feel free to check it out and if you like it, just grab it out of the framework and do whatever you please with it. If you have any questions about it, feel free to contact me off list. http://www.illumineti.com/blog/index.cfm?mode=catcatid=28B26753-C09F-25C5-832AE045709158C1 Shawn Gorrell Web Development Applications Architect Federal Reserve Bank - Atlanta Office (404) 498-8449 Ajas Mohammed [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/25/2007 12:52 AM Please respond to discussion@acfug.org To discussion@acfug.org cc Subject [ACFUG Discuss] validation techniques for existing application Hi, We have about 5 web applications which fork from the same code, but ofcourse they have own customizations and also differ a lot from each other as the clients are different, meaning different needs and lots of different code even though the origin is the same code. Whenever we have new client, we use the code and the code grows from there on. Now to my main question. We dont have proper validation in any of our 5 or whatever no. of code we have. The main code which we use is so mixed with different validation that I cannot explain i.e. some cfforms, some javascript validation, some hidden fields i.e _required validation etc. So I was thinking that next time we have a new client, I should (or my team) add validation to the code we use such that we have all things covered atleast User interface * error description etc those kind of things. I wanted to know how to handle this? can anyone share there experience. What I wanted to achieve was a code reusable approach so that if I need same validation elsewhere I dont have to write it again. Something on the lines of CFC's I would say. This is my own interest and I will do at my own time. No one is bothered or care to have this functionality. Its just that the developer inside me cannot live with this fact that the application is not Perfect. I want it to be Perfect. After all, you live and die by your code. -- Ajas Mohammed / http://ajashadi.blogspot.com/ http://ajashadi.blogspot.com - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com/ FusionLink - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] CFC and reuse query
Before anyone attacks you on this...you shouldn't do something like this: cfquery select blah from blah where #col# = #val#/cfquery - big security risk...plus, using cfqueryparam (in most cases) will help a database store the query plan. But, you could do something like this: cffunction name=GetOSData returntype=query output=false cfargument name=osName required=true type=string / cfquery datasource=#APPLICATION.dsn# name=qryOS SELECT * FROM stats WHERE os = cfqueryparam cfsqltype=cf_sql_varchar value=#arguments.osName# /cfquery cfreturn qryOS / /cffunction Then, on your page you could do something like this: cfscript myObject = createObject(component, yourCFCName); qryWindows = myObject.GetOSData(windows); qryLinux = myObject.GetOSData(linux); //etc /cfscript Hope that helps... Allen -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Anthony Mathis Sent: Friday, February 02, 2007 1:27 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] CFC and reuse query Let me try to explain what I trying to accomplish a little bit better. I'm not sure if cfcs can do this. Documentation seems to make me think that they can. In my test.cfm I have the following: cfoutput#qryWINDOWS.recordcount#/cfoutput cfoutput#qryLINUX.recordcount#/cfoutput I'm using the following query from a cfinclude action.cfm (contains multiple queries). !---Query for Windows OS--- cfquery datasource=#APPLICATION.dsn# name=qryWINDOWS SELECT * FROM stats WHERE os = 'WINDOWS' /cfquery !---Query for Linux OS--- cfquery datasource=#APPLICATION.dsn# name=qryLINUX SELECT * FROM stats WHERE os = 'LINUX' /cfquery How can I accomplish this without using mulitiple queries for LINUX, MAC, UNIX, etc.., using a cfc? I'm new to the cfcs and after reading the documentation, It looks like the above is possible, plus I can cut down on my code. I would assume I could use variable(s) as follows: cfquery datasource=#APPLICATION.dsn# name=qryOS SELECT * FROM stats WHERE #var1# = #var2# /cfquery How would I pass #var1# and #var2# from my cfm to the cfc? Any examples would be great. How I display the return recordcount would be great as well. By the way, the output takes place on the same cfm (test.cfm). - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] Building my IDE Tool Box
Briefly... The ONLY reason I've ever liked DW is the fact that you can synchronize files between the local machine and a server very easily. Eclipse is supposed to have synchronize plugins but they've never seemed to work (at all). Also, DW is great for design type of work, as Ajas mentions below, but it's a resource hog. If you're low on memory you should probably look elsewhere - that being stated, Eclipse isn't exactly a light-weight either! One last thing - a negative for eclipse...if you're working with files that contain thousands of lines of code (I know, everyone says it shouldn't happen, but it does), just typing in a line of code in the middle of the page can be very annoying...it is SO SLOW... But, other than that, both have their uses but the one huge plus of eclipse - it's free -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Ajas Mohammed Sent: Friday, January 26, 2007 3:27 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] Building my IDE Tool Box Best IDE? well thats a tough question and it depends on persons own taste preferences. I like to play with all IDE's there in market and finally stick to ones which I like more. In this case its DW Eclipse. As John Mason mentioned earlier, from coder's point of view no one can beat Eclipse for the simple reason that its meant for a developer who does coding day in day out. Its a very wise option to get familiar with Eclipse because sooner or later some place you join will have developers who only use Eclipse. As for DW is concerned, it is also a great tool for a developer who wants to do design as well write code. Personally, I use both DW Eclipse. I use DW a lot because when I want to edit code, I just select the html element and I get to the point where I want to make the changes instead of searching for it. Thats the biggest plus for me as far as using DW is concerned. On the other side, whenever I have to refactor code or make code changes in CFC's etc, I prefer to stick to Eclipse. Also the Eclipse IDE has some very cool features like 1) You can go to previously viewed file by using cntl + F6 keys. I dont think you could do the same in DW. In DW, cntl + tab takes you through list of files that are open. I hate that. Usually i have lots of files open and I always like to go back forth between 2 open windows/files. Its much easier to do this in Eclipse. 2) The appearance of Eclipse editor looks very good to the eyes when compared to DW's appearance. This remark is based of how code looks in IDE and has nothing to do with fancy stuff. 3) Lot of plugin options. There is another tool which gives TortoiseSVN features in eclipse. I dont want to write it here as we are already discussing that in other thread. Bottom line, I use both. Of late I have been using DW only. But if you want to use Subversion commands in IDE, then Eclipse is by far the best option. Anyone who would like to add or comment on my post is more than welcome. I want to see ppl's opinion when it comes to there favourite editors. Ajas Mohammed. On 1/26/07, Steven Ross mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] wrote: I know you said windows but I have to chime in... if your on a mac. I like textmate... lean and consise. On 1/26/07, John Mason [EMAIL PROTECTED] wrote: From a purely coding side of things, I would think the majority of people would vote for Eclipse. Now, that isn't to say DW doesn't have it's place, but I think it's more on the design side. John [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] From: [EMAIL PROTECTED] [mailto: [EMAIL PROTECTED] On Behalf Of Robert Reil Sent: Friday, January 26, 2007 1:26 PM To: discussion@acfug.org Subject: [ACFUG Discuss] Building my IDE Tool Box It would seem that Teddy's CFEclipse and my Subversion questions are all heading towards the ultimate question. Not to start a flame war but. What is the best IDE for: CF, HTML, CSS, JS in a windows environment While also answering the question of what is the best version for a NOOB to work with some sort of Subversion? Ajas had great stuff about SVN and seems that Eclipse with TortoiseSVN would be great. It is also eluded to that Eclipse is not HTML, CSS, JS friendly. Pros, Cons, and workarounds please... Robert P. Reil Managing Director, Motorcyclecarbs.com, Inc. 4292 Country Garden Walk NW Kennesaw, Ga. 30152 Office 770-974-8851 Fax 770-974-8852 www.motorcyclecarbs.com http://www.motorcyclecarbs.com - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ http://www.mail-archive.com/discussion%40acfug.org/
RE: [ACFUG Discuss] Building my IDE Tool Box
It may be an issue with the plugin. If you want to test it out though...just copy and paste some code into cfeclipse that makes a file that's 2,500 lines of code and then go and try to add some code in the middle of the page. You could type three lines of code and then watch it come across the screen in Doogie Howser fashion 15-20 seconds later! It's insane. Allen -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Dean H. Saxe Sent: Friday, January 26, 2007 3:42 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] Building my IDE Tool Box Damn dude... what kind of box are you on the Eclipse is a dog on large files? I've never seen that behavior, but that's not using CFEclipse, just the base Eclipse for Java projects... Could it be an issue with the plugin? -dhs Dean H. Saxe, CISSP, CEH [EMAIL PROTECTED] [U]nconstitutional behavior by the authorities is constrained only by the peoples' willingness to contest them --John Perry Barlow On Jan 26, 2007, at 3:32 PM, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Briefly... The ONLY reason I've ever liked DW is the fact that you can synchronize files between the local machine and a server very easily. Eclipse is supposed to have synchronize plugins but they've never seemed to work (at all). Also, DW is great for design type of work, as Ajas mentions below, but it's a resource hog. If you're low on memory you should probably look elsewhere - that being stated, Eclipse isn't exactly a light-weight either! One last thing - a negative for eclipse...if you're working with files that contain thousands of lines of code (I know, everyone says it shouldn't happen, but it does), just typing in a line of code in the middle of the page can be very annoying...it is SO SLOW... But, other than that, both have their uses but the one huge plus of eclipse - it's free -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Ajas Mohammed Sent: Friday, January 26, 2007 3:27 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] Building my IDE Tool Box Best IDE? well thats a tough question and it depends on persons own taste preferences. I like to play with all IDE's there in market and finally stick to ones which I like more. In this case its DW Eclipse. As John Mason mentioned earlier, from coder's point of view no one can beat Eclipse for the simple reason that its meant for a developer who does coding day in day out. Its a very wise option to get familiar with Eclipse because sooner or later some place you join will have developers who only use Eclipse. As for DW is concerned, it is also a great tool for a developer who wants to do design as well write code. Personally, I use both DW Eclipse. I use DW a lot because when I want to edit code, I just select the html element and I get to the point where I want to make the changes instead of searching for it. Thats the biggest plus for me as far as using DW is concerned. On the other side, whenever I have to refactor code or make code changes in CFC's etc, I prefer to stick to Eclipse. Also the Eclipse IDE has some very cool features like 1) You can go to previously viewed file by using cntl + F6 keys. I dont think you could do the same in DW. In DW, cntl + tab takes you through list of files that are open. I hate that. Usually i have lots of files open and I always like to go back forth between 2 open windows/files. Its much easier to do this in Eclipse. 2) The appearance of Eclipse editor looks very good to the eyes when compared to DW's appearance. This remark is based of how code looks in IDE and has nothing to do with fancy stuff. 3) Lot of plugin options. There is another tool which gives TortoiseSVN features in eclipse. I dont want to write it here as we are already discussing that in other thread. Bottom line, I use both. Of late I have been using DW only. But if you want to use Subversion commands in IDE, then Eclipse is by far the best option. Anyone who would like to add or comment on my post is more than welcome. I want to see ppl's opinion when it comes to there favourite editors. Ajas Mohammed. On 1/26/07, Steven Ross [EMAIL PROTECTED] wrote: I know you said windows but I have to chime in... if your on a mac. I like textmate... lean and consise. On 1/26/07, John Mason [EMAIL PROTECTED] wrote: From a purely coding side of things, I would think the majority of people would vote for Eclipse. Now, that isn't to say DW doesn't have it's place, but I think it's more on the design side. John [EMAIL PROTECTED] From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Robert Reil Sent: Friday, January 26, 2007 1:26 PM To: discussion@acfug.org Subject: [ACFUG Discuss] Building my
RE: [ACFUG Discuss] cfxml
Yes, it was available in 6.1 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Monday, January 22, 2007 12:02 PM To: acfug acfug Subject: [ACFUG Discuss] cfxml What version (MM/Adobe) was the CFXML tag added? Is it available in CFML 6.1? Robert - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] SQL Question
If the two tables are the same layout (same columns), you have an easy solution: SELECT * INTO dbo.newTable FROM (SELECT * FROM table1 UNION SELECT * FROM table2) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Singles Concepts, Inc. Sent: Friday, January 19, 2007 2:56 PM To: discussion@acfug.org Subject: [ACFUG Discuss] SQL Question Hey CF Crew, I have a question concerning SQL; I have two database tables. I would like to merge and purge the two tables an end with result table that is free of duplicates. I was seeking a application written in CF. Thanks Michael - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] Frame bustin'
Try if(top.location != self.location) top.location = self.location.; -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Derrick Peavy Sent: Friday, December 01, 2006 11:27 AM To: discussion@acfug.org Subject: [ACFUG Discuss] Frame bustin' Anyone have a good, working method of frame busting? I ask because the JS i have been using does not work when someone uses a web proxy (annon.) to browse a site. Examples that do not work (among many): SCRIPT LANGUAGE=JavaScript if (top.frames.length!=0) top.location=self.document.location; /SCRIPT script if (parent.frames.length 0) { parent.location.href = self.document.location } /script When someone uses a service such as http://www.anonymousproxyworld..com http://www.anonymousproxyworld.com / they can strip the javascript but even when they don't, it does not work. They frame the page and append the meta data with their URL. _ Derrick Peavy Sales and Web Services Universal Advertising Phone: 404-786-5036 Fax: 404-370-0470 http://www.universaladvertising.com http://www.collegeadvertising.com http://www.collegeclassifieds.com ___ - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] Remote IP setup for Developer Edition
The first external ip that tries to hit your box is assigned. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Clarke Bishop Sent: Wednesday, November 08, 2006 10:02 AM To: discussion@acfug.org Subject: [ACFUG Discuss] Remote IP setup for Developer Edition CF Developer Edition is supposed to give you access from one remote IP, right? But, how do you specify the remote IP address? I think I've done this before, but I can't find the answer. Thanks for any help. Clarke - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] Replacement needed for ActivEdit
They've always stated that so they don't have to support it, but I've never had any problems with it. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Friday, November 03, 2006 12:12 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] Replacement needed for ActivEdit Good to know. Ever had any problems with FCKEditor? The download page for Version 2.3.2 states that it is under development and that it is usually stable, but not deeply tested. What version are you running? ed -- Ed Szwedo Web Development Team Lead CSC E-mail: [EMAIL PROTECTED] 919-541-3955 (Voice) 919-541-3719 (Fax) [EMAIL PROTECTED] l.frb.org Sent by:To [EMAIL PROTECTED] discussion@acfug.org cc [EMAIL PROTECTED], 11/03/2006 09:23 discussion@acfug.org AM Subject Re: [ACFUG Discuss] Replacement needed for ActivEdit Please respond to [EMAIL PROTECTED] .org We also like FCKeditor. We have been using it without any real problems for about 3+ years [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED]To discussion@acfug.org cc 11/02/2006 03:02 PM Subject Re: [ACFUG Discuss] Replacement Please respond toneeded for ActivEdit discussion@acfug.org Great. Thanks to everyone for their help. That's two votes for FCKeditor so far. ed -- Ed Szwedo Web Development Team Lead CSC E-mail: [EMAIL PROTECTED] 919-541-3955 (Voice) 919-541-3719 (Fax) Teddy Payne [EMAIL PROTECTED] il.com To Sent by: discussion@acfug.org [EMAIL PROTECTED] cc Subject 11/02/2006 02:53 Re: [ACFUG Discuss] Replacement PM needed for ActivEdit Please respond to [EMAIL PROTECTED] .org Mike Nimer integrated FCK Editor into cftextarea in this example: http://www.mikenimer.com/index.cfm?mode=entryentry=9C9A2F02-4E22-1671-50D7E0F64E772617 Teddy On 11/2/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: fck - free cool [k]ontent editor? Just a guess. Thanks, I'll check it out. ed -- Ed Szwedo Web Development Team Lead CSC E-mail: [EMAIL PROTECTED] 919-541-3955 (Voice) 919-541-3719 (Fax) [EMAIL PROTECTED] com Sent by:To
RE: [ACFUG Discuss] Replacement needed for ActivEdit
One that's free is called fckeditor - I know it looks bad, but just google it, it's a fantastic open source javascript solution (and they have cf examples) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Thursday, November 02, 2006 12:14 PM To: discussion@acfug.org Subject: [ACFUG Discuss] Replacement needed for ActivEdit We are currently using a product called ActivEdit as a rich HTML Editor to replace a textarea in some of our applications. ActivEdit allows the user to generate marked up content without knowing HTML. We have been having some difficulties with ActivEdit since moving to ColdFusion 7. We can't get the Spellchecker to work and are having trouble with the font dialog. Troubleshooting the problem with the ActivSoftware folks (maker of ActivEdit) has not resolved the problem. Does anyone use ActivEdit with CF 7? Can anyone suggest a replacement? Any input will be appreciated. ed -- Ed Szwedo Web Development Team Lead CSC E-mail: [EMAIL PROTECTED] 919-541-3955 (Voice) 919-541-3719 (Fax) - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] Client side
Coldfusion would have to be running on the client machine and you'd have to use cfregistry tag. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Dave Bellevue Sent: Friday, October 27, 2006 10:46 AM To: discussion@acfug.org Subject: [ACFUG Discuss] Client side I've been away from CF for a while, but am coming back into MX7 Need to know what is the best (and/or easiest) way run code on the client machine - we need to gather information from the registry, find things like the machine name (http header vars are not reliable) and determine if processes are running and then pass that info into a page. Thanks, Dave Bellevue - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] jrun setup
Do: jrunsvc -remove "Name of service to remove Case Sensitive" -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Robert ReilSent: Tuesday, October 24, 2006 4:55 PMTo: discussion@acfug.orgSubject: RE: [ACFUG Discuss] jrun setup Thump. Asking again Robert P. Reil Managing Director, Motorcyclecarbs.com, Inc. 4292 Country Garden Walk NW Kennesaw, Ga. 30152 Office 770-974-8851 Fax 770-974-8852 www.motorcyclecarbs.com From: Robert Reil [mailto:[EMAIL PROTECTED] Sent: Friday, October 20, 2006 3:56 PMTo: discussion@acfug.orgSubject: RE: [ACFUG Discuss] jrun setup Well I installed the CFusion7 service but it wont start. I also installed a Default server while going through some how tos last night. I want to remove it and cant seem to. For the removal of: Macromedia JRun Default Server Service I try to run: Jrunsvc remove Macromedia JRun Default Server Default JRun Default JRun Default Server And none of these work. I prefer to work in the Windows services console but have to get it to work first. I feel so silly not being able to get this service to remove, and the other to start. From: Douglas Knudsen [mailto:[EMAIL PROTECTED] Sent: Friday, October 20, 2006 11:51 AMTo: discussion@acfug.orgSubject: Re: [ACFUG Discuss] jrun setup On 10/19/06, Robert Reil [EMAIL PROTECTED] wrote: Only the following services seem relevant Macromedia JRun Admin Server Macromedia JRun CFusion Server Macromedia JRun Default Server No other Macromedia JRun services are installed Digging around in Google and LiveDocs I have come to this conclusion. I need to use the jrunsvc as Doug has replied to, and I saw that livedoc, to install a windows service for that service. I can't seem to get the service to load using that command though there are no samples, only wild cards and I think I am getting the syntax wrong. I wish I had a sample of a command line, with an extaction of the Windows services entry. C:/jrun4/bin/jrunsvc install jrun-server "service-name" "service-display" that is a sample, no wildcards are mentioned. replace jrun-server with your server name and the string literals with whatever you want. You can always edit the descriptions in the services panel too. If I use the JRun welcome.jsp file console to turn off the cfusion service, and to turn on the cfusion7 service that works, but the cfusion turns back on. I did notice that going into windows services and stopping the cfusion service does completely stop it. The ' JRun welcome.jsp file' access via port 8000 is known as the JMC. I STRONGLY recommend using this or the windows services panel in a mutually exclusive manner. Using both of these to start/stop jrun servers is a bad idea, they don't play well with others and may even use pointy scissors. If you are doing all this on your local desktop for development, I wouldn't use any of this. Just simply usec:\jrun4\jrun -start jrun-server to start the server from a command line. Creating a BAT file for this is cake and can be dbl-clicked in good old windows. So with that, I guess I should turn the JRun cfusion svc to manual (which I just did) And that I need some help on getting the JRun cfusion7 svc to install and have it run in the Windows services as Automatic. I want to run: C:/jrun4/bin/jrunsvc install jrun-server "service-name" "service-display" I want it to post into Windows Services as: Name: Macromedia JRun CFusion7 Server Description:Macromedia JRun ColdFusion 7 Server Startup Type: Automatic Please help me with the syntax From: Douglas Knudsen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 18, 2006 5:00 PMTo: discussion@acfug.orgSubject: Re: [ACFUG Discuss] jrun setup Are both of these listed in the Windows Services MMC Snap In?DK On 10/18/06, Robert Reil [EMAIL PROTECTED] wrote: I have CFMX, and CFMX7 running in the JRUN console. How do I make a default of MX stopped, and MX7 in run mode? Robert P. Reil Managing Director, Motorcyclecarbs.com, Inc. 4292 Country Garden Walk NW Kennesaw , Ga. 30152 Office 770-974-8851 Fax 770-974-8852 www.motorcyclecarbs.com -- Douglas Knudsenhttp://www.cubicleman.comthis is my signature, like it? - To unsubscribe from this list,
RE: [ACFUG Discuss] jrun setup
Let me know if it works for you. That should do the trick -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Robert ReilSent: Wednesday, October 25, 2006 1:38 PMTo: discussion@acfug.orgSubject: RE: [ACFUG Discuss] jrun setup Ill try that, thanks. Robert P. Reil Managing Director, Motorcyclecarbs.com, Inc. 4292 Country Garden Walk NW Kennesaw, Ga. 30152 Office 770-974-8851 Fax 770-974-8852 www.motorcyclecarbs.com From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 25, 2006 6:52 AMTo: discussion@acfug.orgSubject: RE: [ACFUG Discuss] jrun setup Do: jrunsvc -remove "Name of service to remove Case Sensitive" -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Robert ReilSent: Tuesday, October 24, 2006 4:55 PMTo: discussion@acfug.orgSubject: RE: [ACFUG Discuss] jrun setup Thump. Asking again Robert P. Reil Managing Director, Motorcyclecarbs.com, Inc. 4292 Country Garden Walk NW Kennesaw, Ga. 30152 Office 770-974-8851 Fax 770-974-8852 www.motorcyclecarbs.com From: Robert Reil [mailto:[EMAIL PROTECTED] Sent: Friday, October 20, 2006 3:56 PMTo: discussion@acfug.orgSubject: RE: [ACFUG Discuss] jrun setup Well I installed the CFusion7 service but it wont start. I also installed a Default server while going through some how tos last night. I want to remove it and cant seem to. For the removal of: Macromedia JRun Default Server Service I try to run: Jrunsvc remove Macromedia JRun Default Server Default JRun Default JRun Default Server And none of these work. I prefer to work in the Windows services console but have to get it to work first. I feel so silly not being able to get this service to remove, and the other to start. From: Douglas Knudsen [mailto:[EMAIL PROTECTED] Sent: Friday, October 20, 2006 11:51 AMTo: discussion@acfug.orgSubject: Re: [ACFUG Discuss] jrun setup On 10/19/06, Robert Reil [EMAIL PROTECTED] wrote: Only the following services seem relevant Macromedia JRun Admin Server Macromedia JRun CFusion Server Macromedia JRun Default Server No other Macromedia JRun services are installed Digging around in Google and LiveDocs I have come to this conclusion. I need to use the jrunsvc as Doug has replied to, and I saw that livedoc, to install a windows service for that service. I can't seem to get the service to load using that command though there are no samples, only wild cards and I think I am getting the syntax wrong. I wish I had a sample of a command line, with an extaction of the Windows services entry. C:/jrun4/bin/jrunsvc install jrun-server "service-name" "service-display" that is a sample, no wildcards are mentioned. replace jrun-server with your server name and the string literals with whatever you want. You can always edit the descriptions in the services panel too. If I use the JRun welcome.jsp file console to turn off the cfusion service, and to turn on the cfusion7 service that works, but the cfusion turns back on. I did notice that going into windows services and stopping the cfusion service does completely stop it. The ' JRun welcome.jsp file' access via port 8000 is known as the JMC. I STRONGLY recommend using this or the windows services panel in a mutually exclusive manner. Using both of these to start/stop jrun servers is a bad idea, they don't play well with others and may even use pointy scissors. If you are doing all this on your local desktop for development, I wouldn't use any of this. Just simply usec:\jrun4\jrun -start jrun-server to start the server from a command line. Creating a BAT file for this is cake and can be dbl-clicked in good old windows. So with that, I guess I should turn the JRun cfusion svc to manual (which I just did) And that I need some help on getting the JRun cfusion7 svc to install and have it run in the Windows services as Automatic. I want to run: C:/jrun4/bin/jrunsvc install jrun-server "service-name" "service-display" I want it to post into Windows Services as: Name: Macromedia JRun CFusion7 Server
re: [ACFUG Discuss] using a variable to build a variable name
Maybe this can help someone as well. I find this a very easy way to determine what fields you're looking for... First, on the form page, I'll create hidden fields of the same name so a comma delimited list is created on the action page: Display Page: input type="hidden" name="someID" value="#someID#"input type="text" name="category_#someID#" input type="hidden" name="someID" value="#someID#"input type="text" name="category_#someID#" input type="hidden" name="someID" value="#someID#"input type="text" name="category_#someID#" So therendered display might look something like this (I'm just using random numbers here): input type="hidden" name="someID" value="25"input type="text" name="category_25" input type="hidden" name="someID" value="101"input type="text" name="category_101" input type="hidden" name="someID" value="345"input type="text" name="category_345" Then, on the action page (the form processing page), I can just check for the existence of the someID values and loop over them (if you create multiple form fields with values : Action Page: !--- from the example above, form.someID = "25,101,345" --- cfparam name="form.someID" default="" cfloop list="#form.someID#" index="id" cfset tempVar = form["category_#id#"] do something ... /cfloop Hope that helps someone out. I've foundthis to be a very efficient and easy way to determine what's there... Allen Underwood, Developer UPS Supply Chain Solutions Atlas: 5-480-6979 Phone: 678-746-6979 E-mail: [EMAIL PROTECTED] So you need to process one or more formfields but you don't know the names at the time of processing? I had a similar requirement and here is how I solved it: cfscript for(FormField in arguments.FormVars) // this will loop through all available form variables { Quantity = structfind(arguments.FormVars, FormField); // set the variable "quantity" to the value of the form variable if(left(FormField, 2) EQ "c_" and right(FormField, 14) NEQ "_cfforminteger" and len(Quantity)) // check if this is one of the form vars I actually want to process. The formvars with names that end in _cfforminteger are created by CFFORM and can be ignored { ConfigID = mid(FormField, 3, len(FormField)); // where I use "ItemID", you would use "InvoiceID" ... do something else... } } /cfscript The "trick" really is to prefix the fields you know you'll be interested in with something unique, like I did with "c_". Later, you can simply test for this. Hope this makes sense. Mischa. BTW, I like CFScript, since it's a function, but you can write this is straight CF as well. Hey folks, I was wondering if anyone had a solution to an issue I'm having that is resulting in some hair loss on my part by means of my hands. I have a form that has repetitive fields that is built by using a loop. I append the form field name with a variable to distinguish between the different form fields: CFINPUT TYPE="TEXT" NAME="InvAmt#InvoiceQuery.InvId#". This works fine for creating unique names for my form fields but it creates a problem when it's time to write to the db. I can't recreate the variable names in my SQL statement for the insert or update: UPDATE tablename SET InvAmt = ??"InvAmt#InvoiceQuery.InvId#"?? WHERE ID=#ID# Obviously that won't work. Any ideas on how I can create the variable name for my SQL statement or any other solutions to my problem? Thanks, Jeff - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - Mischa Uppelschoten The Banker's Exchange, Inc. 2020 Hills Avenue NW Atlanta, GA 30318 Phone: (404) 605-0100 ext. 10 Fax: (404) 355-7930 Web: www.BankersX.com Follow this link for Instant Web Chat: http://www.bankersx.com/Contact/chat.cfm?Queue=MUPPELSCHOTEN - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=gin.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink -
RE: [ACFUG Discuss] Re: PLZ DISREGARD PREV MAIL..1.Query Caching 2.Implementing search Feature
if you paste the query in here we may be able to help...there are a few things that will cause a query NOT to be cached -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Ajas MohammedSent: Monday, October 16, 2006 10:37 AMTo: discussion@acfug.orgSubject: Re: [ACFUG Discuss] Re: PLZ DISREGARD PREV MAIL..1.Query Caching 2.Implementing search FeatureNo, I do not have cfqueryparam in any of my queries. For question no. 2, I have heard of verity but I am not sure what it does and if thats what is needed for performing search (like google).Thanks. On 10/16/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: For number 1: do you have a cfqueryparam in your query - from what I understand, this doesn't work with cached queries... -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Ajas MohammedSent: Monday, October 16, 2006 10:17 AMTo: discussion@acfug.orgSubject: [ACFUG Discuss] Re: PLZ DISREGARD PREV MAIL..1.Query Caching 2.Implementing search FeatureGood Morning everyone, Just wondering if anyone has any ideas/suggestions for the 2 questions I had asked??? I didnt see any reply which makes me think if it is very simple or if its difficult / time consuming. Thanks,Ajas. On 10/13/06, Ajas Mohammed [EMAIL PROTECTED] wrote: Hello everyone, I apologize for the earlier mail sent.. I dont know what happened and the incomplete message got sent. I have 2 questions.1) I have a search page which might return 1000's of records for a search/keyword. I have implemented Pagination i.e. showing NEXT / PREVIOUS (10) RECORDS at a time. My problem is that everytime I click on NEXT OR PREVIOUS, the query is getting executed all over again. I dont want the query to be run everytime NEXT/PREVIOUS link is clicked. I have this code to do the caching cfquery datasource="#client.dbname#" name="StateRegs" cachedwithin="#createTimeSpan (0,2,13,0)#"/cfquerycfoutput query="StateRegs" group="Reg_Name" startrow="#start#" maxrows="#end#" data shown heretda href=""start + disp")#"Next #next# records/a /td(this link basically takes to the same query page, but I have a url parameter action, which if set to search will run the query and display search results)/cfoutputSimilarly a link for previous records. In the coldfusion Administrator, ONLY SAVE CLASS FILES IS CHECKED AND MAXIMUM NUMBER OF CACHED QUERIES IS SET AS 300.2. The second question is also long. So plz visit this URL...http://www.sitepoint.com/forums/showthread.php?t=428803 Its about implementing multiple word search on a site and you have search for those words (maybe 3 or 5 or even more) in 4 tables.Thanks in advance... Ajas.- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink -
RE: [ACFUG Discuss] Issue with return from cfquery
You should probably look into using scope_identity() rather than the method you use below...that may help you out a bit... INSERT into blah() values() SELECT ID = SCOPE_IDENTITY() Rowcount can cause some headaches... -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Jeff HowardSent: Wednesday, October 04, 2006 9:50 AMTo: discussion@acfug.orgSubject: RE: [ACFUG Discuss] Issue with return from cfquery So I got access to the CF Admin this morning and between that and Profiler I can see what is causing my issue and can resolve. Thanks for everyone's help once again. It was a comination of advice that got me to this point. Now I was wondering if anyone could tell me why this issue is happening to try and avoid/combat it in the future. When I add a new record to the db I immediately pull that id back out with this query: SET ROWCOUNT 1SELECTidFROMtableORDER BY id DESC This seems to set the rowcount for ALL queries after this one. When I uncheck "Maintain connections across client requests" it works fine, but as long as the box is checked the 'rowcount' remains one for all requests to this db. Can anyone give a brief explaination of the 'why' for me on this. thanks for all the help, Jeff Stay in the know. Pulse on the new Yahoo.com. Check it out. - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink -
RE: [ACFUG Discuss] Issue with return from cfquery
Also, as a follow up - the reason you're having the problem is this - you're doing a set rowcount 1 and cf is holding onto the connection. That means all selects after that point are going to do only one row. If you want to keep the code the way you currently have it, after your ORDER BY id DESC, you would want to put SET ROWCOUNT 0 - that would fix your problem (or should). Allen -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Underwood Allen (WJJ1AXU)Sent: Wednesday, October 04, 2006 9:54 AMTo: discussion@acfug.orgSubject: RE: [ACFUG Discuss] Issue with return from cfquery You should probably look into using scope_identity() rather than the method you use below...that may help you out a bit... INSERT into blah() values() SELECT ID = SCOPE_IDENTITY() Rowcount can cause some headaches... -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Jeff HowardSent: Wednesday, October 04, 2006 9:50 AMTo: discussion@acfug.orgSubject: RE: [ACFUG Discuss] Issue with return from cfquery So I got access to the CF Admin this morning and between that and Profiler I can see what is causing my issue and can resolve. Thanks for everyone's help once again. It was a comination of advice that got me to this point. Now I was wondering if anyone could tell me why this issue is happening to try and avoid/combat it in the future. When I add a new record to the db I immediately pull that id back out with this query: SET ROWCOUNT 1SELECTidFROMtableORDER BY id DESC This seems to set the rowcount for ALL queries after this one. When I uncheck "Maintain connections across client requests" it works fine, but as long as the box is checked the 'rowcount' remains one for all requests to this db. Can anyone give a brief explaination of the 'why' for me on this. thanks for all the help, Jeff Stay in the know. Pulse on the new Yahoo.com. Check it out. - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink -
RE: [ACFUG Discuss] Issue with return from cfquery
Maybe try this: SELECT [id] from test -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Jeff HowardSent: Tuesday, October 03, 2006 12:32 PMTo: discussion@acfug.orgSubject: [ACFUG Discuss] Issue with return from cfquery Does anyone know what could be causing the following issue: I have a very simple query: CFQUERY name="getIDs" datasource="sysmods" SELECT ID FROM test/CFQUERY The DB has 1 column named ID and 10 rows numbered 1-10. I built this table to try and figure out what is happening to a more complex table that is having the same issue. When I run this in a browser it is only returning the first record. When I copy and paste the query into Enterprise Manager and Query Analyzerand it returns all 10 rows. The script I was running when this problem first surface ran fine several times this morning and all of a sudden it quit working. It was returning all records from the table and then I ran it again and this problem popped up. I couldn't figure out what was happening so I built a little test table and test script and I'm getting the same problems. This makes me believe it is a CF problem and not a SQL Server problem. Any ideas? From what I've gathered since joining a few months ago, someone always knows the answer in this group. Thanks, Jeff Howard Do you Yahoo!?Everyone is raving about the all-new Yahoo! Mail. - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink -
RE: [ACFUG Discuss] Issue with return from cfquery
Possibly the caching of the class files via CFthat's a long shot though as that really shouldn't affect the query results. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Jeff HowardSent: Tuesday, October 03, 2006 1:47 PMTo: discussion@acfug.orgSubject: RE: [ACFUG Discuss] Issue with return from cfquery Ok, the new issue is it all of a sudden started working again. I didn't change any settings anywhere or even change my script. All I did was eat a sandwich and hit refresh on the page and it started working. This is obviously not a good situation once the project I'm working on is live. Any new ideas on why it would all of a sudden start only returning 1 record instead of multiple records and then fix itself to start returning all records? I am the only one here today working on this server or with these scripts. Ideas? Charlie Arehart [EMAIL PROTECTED] wrote: Besides the other helpful suggestions so far, do you have debugging turned on, to see how many records are being returned in the resultset? More important, If the issue is really that it's just returning 1 record, then the question could be one of security and authorization, in SQL I mean. I'm pretty sure it's possible to restrict people to see only the records they're authorized to see. When you login to Enterprise Manager, do you log in with the same account as is being used in the setup of this datasource in the CF Admin console? If you have no control over the DSN setup, since you do have access to Enterprise Manager, turn on the SQL Profiler to see what authentication is being used when the request comes into SQL Server from CF. And do the same to watch the Query Analyzer request you make. It may tell you where and why things are different. /charlie http://www.carehart.org/blog/ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff HowardSent: Tuesday, October 03, 2006 12:32 PMTo: discussion@acfug.orgSubject: [ACFUG Discuss] Issue with return from cfquery Does anyone know what could be causing the following issue: I have a very simple query: CFQUERY name="getIDs" datasource="sysmods" SELECT ID FROM test/CFQUERY The DB has 1 column named ID and 10 rows numbered 1-10. I built this table to try and figure out what is happening to a more complex table that is having the same issue. When I run this in a browser it is only returning the first record. When I copy and paste the query into Enterprise Manager and Query Analyzerand it returns all 10 rows. The script I was running when this problem first surface ran fine several times this morning and all of a sudden it quit working. It was returning all records from the table and then I ran it again and this problem popped up. I couldn't figure out what was happening so I built a little test table and test script and I'm getting the same problems. This makes me believe it is a CF problem and not a SQL Server problem. Any ideas? From what I've gathered since joining a few months ago, someone always knows the answer in this group. Thanks, Jeff Howard Do you Yahoo!?Everyone is raving about the all-new Yahoo! Mail. - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - Get your own web address for just $1.99/1st yr. We'll help. Yahoo! Small Business. - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @
RE: [ACFUG Discuss] Issue with return from cfquery
Given all this - I'd strongly urge you to check your DSN's like Dean was pointing out earlier - this just doesn't make a whole lot of sense. Allen -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Jeff HowardSent: Tuesday, October 03, 2006 2:09 PMTo: discussion@acfug.orgSubject: RE: [ACFUG Discuss] Issue with return from cfqueryIt did this when I created a brand new table with a brand new .cfm with a brand new query in it so that leads me to believe that it's not a caching issue.[EMAIL PROTECTED] wrote: Possibly the caching of the class files via CFthat's a long shot though as that really shouldn't affect the query results. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Jeff HowardSent: Tuesday, October 03, 2006 1:47 PMTo: discussion@acfug.orgSubject: RE: [ACFUG Discuss] Issue with return from cfquery Ok, the new issue is it all of a sudden started working again. I didn't change any settings anywhere or even change my script. All I did was eat a sandwich and hit refresh on the page and it started working. This is obviously not a good situation once the project I'm working on is live. Any new ideas on why it would all of a sudden start only returning 1 record instead of multiple records and then fix itself to start returning all records? I am the only one here today working on this server or with these scripts. Ideas? Charlie Arehart [EMAIL PROTECTED] wrote: Besides the other helpful suggestions so far, do you have debugging turned on, to see how many records are being returned in the resultset? More important, If the issue is really that it's just returning 1 record, then the question could be one of security and authorization, in SQL I mean. I'm pretty sure it's possible to restrict people to see only the records they're authorized to see. When you login to Enterprise Manager, do you log in with the same account as is being used in the setup of this datasource in the CF Admin console? If you have no control over the DSN setup, since you do have access to Enterprise Manager, turn on the SQL Profiler to see what authentication is being used when the request comes into SQL Server from CF. And do the same to watch the Query Analyzer request you make. It may tell you where and why things are different. /charlie http://www.carehart.org/blog/ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff HowardSent: Tuesday, October 03, 2006 12:32 PMTo: discussion@acfug.orgSubject: [ACFUG Discuss] Issue with return from cfquery Does anyone know what could be causing the following issue: I have a very simple query: CFQUERY name="getIDs" datasource="sysmods" SELECT ID FROM test/CFQUERY The DB has 1 column named ID and 10 rows numbered 1-10. I built this table to try and figure out what is happening to a more complex table that is having the same issue. When I run this in a browser it is only returning the first record. When I copy and paste the query into Enterprise Manager and Query Analyzerand it returns all 10 rows. The script I was running when this problem first surface ran fine several times this morning and all of a sudden it quit working. It was returning all records from the table and then I ran it again and this problem popped up. I couldn't figure out what was happening so I built a little test table and test script and I'm getting the same problems. This makes me believe it is a CF problem and not a SQL Server problem. Any ideas? From what I've gathered since joining a few months ago, someone always knows the answer in this group. Thanks, Jeff Howard Do you Yahoo!?Everyone is raving about the all-new Yahoo! Mail. - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - - To unsubscribe from this list,
RE: [ACFUG Discuss] asp version of cfhttp
Try this http://www.webmasterworld.com/forum47/27.htm -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Teddy PayneSent: Friday, September 29, 2006 1:37 PMTo: discussion@acfug.orgSubject: Re: [ACFUG Discuss] asp version of cfhttpOk, I sense a whole people going, "huh?"Robert, this may not be soemthing the average CF developer or even the above average CF developer doesn't really looks for everyday. We use cfhttp to make our life easy for webservices and referencing remote pages. Perhaps those who are familiar with BD .Net may have more insight with comparison code.Sorry Robert,Teddy On 9/29/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Can someone point me to a resource or supply some info if there is an ASP equvilent to cfhttp tag.All I want to do ispost form parameters and get the returned file content and then test it's value.It must be in asp only. ThanksRobert-To unsubscribe from this list, manage your profile @http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglistsArchive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com--- cf_payne / Blog: http://cfpayne.wordpress.com/Atlanta CFUG: http://www.acfug.org - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink -
RE: [ACFUG Discuss] regex / quotedvaluelist question
Couldn't you just use cfqueryparam and use the list functionality built into that tag? It'd be a lot more secure and it would handle all that for you... SELECT * FROM whatever where email in (cfqueryparam cfsqltype=CF_SQL_VARCHAR list=Yes value=[EMAIL PROTECTED],[EMAIL PROTECTED],[EMAIL PROTECTED] separator=,) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Steven Ross Sent: Thursday, September 28, 2006 11:05 AM To: ACFUG ColdFusion Discussion Subject: [ACFUG Discuss] regex / quotedvaluelist question Trying to find out if this is possible using regex? Would I need to use backreferences to accomplish this? I'd like to search the following string: cfset string = [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED] and produce this: '[EMAIL PROTECTED]', '[EMAIL PROTECTED]', '[EMAIL PROTECTED]' The reason is that i want to use it in an IN clause... I thought i might be able to use QuotedValueList but, looks like that wont work... is that right? -- Steven Ross web application interface developer http://www.zerium.com [mobile] 404-488-4364 [fax] 928-484-4364 - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] Re: [ACFUG Community] Quick (and hopefully simple) question about updating a SQL Server table
Do this: mySmallDateField = NULLIF(LTRIM(RTRIM(whateverValueWasPassed)), '') -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Jeff HowardSent: Thursday, September 28, 2006 3:00 PMTo: discussion@acfug.orgSubject: Re: [ACFUG Discuss] Re: [ACFUG Community] Quick (and hopefully simple) question about updating a SQL Server table"Dean H. Saxe" [EMAIL PROTECTED] wrote: This should go to the discussion list (and I redirected it there). I apologize, this is my first attempt at trying to ask a question to the ACFUG and I just replied to an email that I received.Is the column set to allow nulls? If not, that's your issue. Yes, it is set to accept nulls. The issue is the form passes a "" and when it tries to update a smalldate and a money field in the table it throws and error. I put the SQL statement generated in the CF error into Enterprise Manager and dissected it field by field. The error that I get from Enterprise Manager is invalid data type or length.-dhsDean H. Saxe, CISSP, CEH[EMAIL PROTECTED]"If liberty means anything at all, it means the right to tell people what they do not want to hear."-- George Orwell, 1945On Sep 28, 2006, at 2:36 PM, Jeff Howard wrote: I am trying to do an update to a table in SQL Server with and one of the updates to the record is to a column that has a date (smalldate type) and I'm trying to update it to . Seems like this should be simple but everything I've tried keeps throwing errors. Stay in the know. Pulse on the new Yahoo.com. Check it out. - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists List hosted by FusionLink --To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserformFor more info, see http://www.acfug.org/mailinglistsArchive @ http://www.mail-archive.com/discussion%40acfug.org/List hosted by http://www.fusionlink.com- Do you Yahoo!?Get on board. You're invited to try the new Yahoo! Mail. - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink -
RE: Re: [ACFUG Discuss] Client? Session?
Just as an aside - you can still store complex structures in client variables but you'll have to wddx them into a string and then store them into the client variable. Also, if you do this and you have your client variables stored in the database, you'll want to make sure your datasource is enabled to retrieve BLOB's without the 64k limit. One other thing, if you're running on MX in JRUN configuration (not standalone), you can share the sessions between servers (if I remember right). J2EE has clustering built in and I believe it supports the equivalent of a session state server. Allen -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of [EMAIL PROTECTED]Sent: Wednesday, September 27, 2006 9:22 AMTo: discussion@acfug.orgSubject: Re: Re: [ACFUG Discuss] Client? Session?In general it seems to me that the rule is that once a user is on a server, they are on the same server. Define complex data. I potentially see structures and possibly an occasional object in the shared scope, but honestly I don't know yet. We don't officially have any code written. mcg Steven Ross [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/26/2006 08:04 PM Please respond todiscussion@acfug.org To discussion@acfug.org cc Subject Re: Re: [ACFUG Discuss] Client? Session? Yeah it depends on how you want your requests routed... it is myunderstanding that if you want the machines to round robin eachrequest then you need to do client variables, if you don't care andyou just want users to stay on one server then you can use sessions.On 9/26/06, Teddy Payne [EMAIL PROTECTED] wrote: Are you looking to store complex data in your shared scope? If so, you need some sort of sticky session solution. If you are looking to store simple data, using the datasource option of client variable storeage would make it easier to switch over between servers. Teddy On 9/26/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: I'm a little confused as to what scope of variables to use in our situation. We have a primary server and a 'backup' server in case the primary fails. Now that is the current situation. Eventually the backup will be replaced with a better machine and the load will be balanced a little more evenly. Currently the balancing is done via Resonate software (and no one seems to like it). As far as 100% failover, I really don't see that as a necessity, these aren't banking applications. Also these servers don't talk to each other that I know of. TIA Mary-Catherine - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - -- cf_payne / Blog: http://cfpayne.wordpress.com/ Atlanta CFUG: http://www.acfug.org - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink --- Steven Rossweb application interface developerhttp://www.zerium.com[mobile] 404-488-4364[fax] 928-484-4364-To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserformFor more info, see http://www.acfug.org/mailinglistsArchive @ http://www.mail-archive.com/discussion%40acfug.org/List hosted by http://www.fusionlink.com-- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/
RE: [ACFUG Discuss] Sum/CFSET
To answer the first question, you can get rid of the "" problem with: cfset mySum = Val(var1) + Val(var2) + Val(var3) If the var is null or empty, Val() will change it to 0 If you want to accomplish the same via SQL, try: SELECT mySum= ISNULL(col1, 0) + ISNULL(col2, 0) + ISNULL(col3, 0) If you try to add columns together and any of the columns has a null value in it, the result will be a null value...the way I show above will get rid of the nulls and replace with 0's Hope that helps. Allen -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Douglas KnudsenSent: Friday, September 22, 2006 12:13 AMTo: discussion@acfug.orgSubject: Re: [ACFUG Discuss] Sum/CFSETrighto, but I took his description to mean he wanted to sum columns, not rows.DK On 9/21/06, Dean H. Saxe [EMAIL PROTECTED] wrote: SUM requires a group by clause.SELECT sum(column_name) as sum_value FROM Table GroupBy column_name -dhsDean H. Saxe, CISSP,CEH[EMAIL PROTECTED]"[T]he people can always be brought to the bidding of the leaders.This is easy. All you have to do is to tell them they are being attacked, and denounce the pacifists for lack of patriotism andexposing the country to danger. It works the same in every country." --Hermann Goering, Hitler's Reich-Marshall at the Nuremberg TrialsOn Sep 21, 2006, at 10:46 PM, Douglas Knudsen wrote: use the SQL Luke! Try SELECT value1 + value2 + value3 as daSum FROM yourtable DK On 9/21/06, Chris C. Cooper [EMAIL PROTECTED] wrote: I've got a table with some fields I'm writing numeric values to from a form. I have the Columns in the database (SQL 2005) as Numeric fields. I've tried to sum the totals in SQL using SUM(value1, value2, value3, value4, value5) as total, but I kept getting errors about having to add all the columns as part of the aggregate function , so I left that alone. When I go to add the values in CF cfset total = #value1# + #value2# …It tells me can't add "", referring to the null values in some of the fields stored in the database. I was thinking about using a lot of if statements for each field but this seems wrong and will probably take a performance hit on the page. What do I need to do? TIA image001.jpg - Chris C. Cooper Cooper e.Business Solutions Atlanta , Georgia 404.691.4816 Cooper e.business Solutions – http://www.cooperebusiness.com - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - -- Douglas Knudsen http://www.cubicleman.com this is my signature, like it? - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink -- To unsubscribe from this list, manage your profile @http://www.acfug.org?falogin.edituserformFor more info, see http://www.acfug.org/mailinglistsArchive @ http://www.mail-archive.com/discussion%40acfug.org/List hosted by http://www.fusionlink.com--- Douglas Knudsenhttp://www.cubicleman.com this is my signature, like it? - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink -
RE: [ACFUG Discuss] RE: XML Formatting in CF5 question
Yeah, I tried that one first but it didn't work...I'm guessing the way the data was stored in unicode wasn't compatible with the utf 8. When I googled the invalid character reference, Microsoft actually suggests (it was the first link by the way) to use the iso 8859. The web is a never-ending learning process! Thanks John, Allen -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of John MasonSent: Tuesday, August 15, 2006 12:07 AMTo: discussion@acfug.orgSubject: RE: [ACFUG Discuss] RE: XML Formatting in CF5 question Yep, actually UTF-8 is the way to go here. The group that supported the older 8859-1 (Latin-1) group has move on. The UTF standards are the newer and more accepted encoding standard. http://en.wikipedia.org/wiki/ISO-8859-1 John [EMAIL PROTECTED] From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Steven RossSent: Monday, August 14, 2006 4:32 PMTo: discussion@acfug.orgSubject: Re: [ACFUG Discuss] RE: XML Formatting in CF5 question why not use utf-8? guess it depends on your input forms On 8/14/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Quick update - just in case anyone else ever runs into this problem. Again, just to restate quickly - say you have a German name with the double dots over the "u" or you have a spanish name with the ~ over the "n" or something like that, it was breaking my xml. To fix it I just needed to put this declaration at the top of the xml document: ?xml version="1.0" encoding="iso-8859-1" ? Allen -Original Message-From: Underwood Allen (WJJ1AXU) Sent: Monday, August 14, 2006 12:32 PMTo: 'discussion@acfug.org'Subject: XML Formatting in CF5 question Hello everyone, I've got an aggravating situation. We're using CF5 and I'm doing some AJAX interfaces. My problem is, we have international users that have unicode characters such as o acutes and various other flavors of invalid xml characters...Do any of you know of a way either in XML or in CF5 to escape the characters that will cause the XML to be invalid? Also, so you know, the values that are causing problems are attributes and not text values in-between the tags...for instance: person fName="invalidCharacterShowsUpHere" / CDATA won't solve my problem and I'm running out of ideas. Any help would be awesome! Thanks, Allen - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - -- Steven Rossweb application interface developer http://www.zerium.com[phone] 404-488-4364 - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink -
[ACFUG Discuss] XML Formatting in CF5 question
Hello everyone, I've got an aggravating situation. We're using CF5 and I'm doing some AJAX interfaces. My problem is, we have international users that have unicode characters such as o acutes and various other flavors of invalid xml characters...Do any of you know of a way either in XML or in CF5 to escape the characters that will cause the XML to be invalid? Also, so you know, the values that are causing problems are attributes and not text values in-between the tags...for instance: person fName="invalidCharacterShowsUpHere" / CDATA won't solve my problem and I'm running out of ideas. Any help would be awesome! Thanks, Allen - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink -
RE: [ACFUG Discuss] Change Management Options Debate.
Tortise SVN is an awesome windows integration tool - you don't have to use command line... -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Robert ReilSent: Tuesday, August 08, 2006 4:55 PMTo: discussion@acfug.orgSubject: RE: [ACFUG Discuss] Change Management Options Debate. Tortoise Robert P. Reil Managing Director, Motorcyclecarbs.com, Inc. 4292 Country Garden Walk NW Kennesaw, Ga. 30152 Office 770-974-8851 Fax 770-974-8852 www.motorcyclecarbs.com From: Steven Ross [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 08, 2006 4:37 PMTo: discussion@acfug.orgSubject: Re: [ACFUG Discuss] Change Management Options Debate. Not sure, it is command line on linux... that much i know.. course the only command you need to know is create and the rest is managed through something like TortoiseSVN On 8/8/06, Robert Reil [EMAIL PROTECTED] wrote: U was going to put this on the Win Dev Server. What work arounds will I encounter? I can see already that I will probably have to load Apache to use this. Is this a command line only tool? No GUI? Robert P. Reil Managing Director, Motorcyclecarbs.com, Inc. 4292 Country Garden Walk NW Kennesaw , Ga. 30152 Office 770-974-8851 Fax 770-974-8852 www.motorcyclecarbs.com From: Steven Ross [mailto: [EMAIL PROTECTED]] Sent: Tuesday, August 08, 2006 2:32 PM To: discussion@acfug.orgSubject: Re: [ACFUG Discuss] Change Management Options Debate. I posted a blog entry about setting up a fedora box and getting SVN going:easy stuff... course now I'm liking ubuntu, but the basic commands stay the same (except you use apt instead of yum) and some config files are in different places. http://www.zerium.com/zerium/index.cfm?mode=entryentry=63467E64-E1E5-119E-19FA55A04B20E4F3 On 8/8/06, Robert Reil [EMAIL PROTECTED] wrote: Doug: You did not hijack my thread. I opened it up for debate and I just stood back and absorbed. It seems that the debate provided a general consensus of SVN. I appreciate the candid banter and absorbed a lot from it. Objective fulfilled! Thanks again. Robert P. Reil Managing Director, Motorcyclecarbs.com, Inc. 4292 Country Garden Walk NW Kennesaw , Ga. 30152 Office 770-974-8851 Fax 770-974-8852 www.motorcyclecarbs.com From: Douglas Knudsen [mailto: [EMAIL PROTECTED]] Sent: Monday, August 07, 2006 8:42 PMTo: discussion@acfug.orgSubject: Re: [ACFUG Discuss] Change Management Options Debate. thank you Jeremy! As Charlie pointed out, it would be a good blog post to get consumed.Robert, we kind of hijakced your thread, but this is some good fudge for your version control sundae you will be eating!I made a couple in line comments below.I'll add one thing I really hate about CVS, you can't export a module from teh repository to a existing directory where you exported the module previously. CVS will not overwrite files. This forced us to checkout working copies on our prod server. No biggie, we are a intranet only team, but a pain. DK On 8/7/06, Jeremy Allen [EMAIL PROTECTED] wrote: THe points for SVN go like this:Versioning is much more sane and manageable. When I first started using SVN it was much more bearable to me. Your entire codebase can be encapsulated in one SVN version number instead of each file having its own version. When I say version 543 of the codebase with SVN there is no ambiguity about the state of the system when I say that. CVS has no easy concept of referring to the contents of the repository as a whole with a version number. That to me is what makes SVN so much better. We use tags in CVS for this. Works fine, but certainly doesn't tie in with the version of a file. This is a interesting concept. This means a file that was created as teh first file in your tree and never edited for 5 years still has the version listed at the max of all file versions, eh? SVN is easier to manage. This is a personal opinion but my experiences bear this one out. The command line for SVN is much more intuitive. SVN allows for you to delete and rearrange branches. This is HUGE. Deleting folders in CVS is plain not possible. CVSs delete functionality is just lacking in every way. yes, this is a major PITA for sure in CVS. Most clients hide this issue by 'pruning' empty dirs. Directories have revision numbers too. Everything in the system behaves consistently and there are no surprises or differences to deal with with different types of entities in the system as there is with CVS. SVN has no
RE: [ACFUG Discuss] Change Management Options Debate.
A good source control could help out tremendously. You can branch off separate builds...great freeware versions are CVS and Subversion (a spinoff of CVS). I think you will find plenty of information on these with a google. If you put the time into learning how to really incorporate a source control you could do exactly what you're talking about below and at the same time have good rollback points if you ever need to I will say this, I've worked with Subversion and was very impressed - they have tools that integrate into windows and they are pretty slick. Hope that helps a little, Allen -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Robert Reil Sent: Wednesday, August 02, 2006 8:00 AM To: discussion@acfug.org Subject: [ACFUG Discuss] Change Management Options Debate. While I am new to development I have reached a point where I realize that we have to modify AbleCommerce (our CF based shopping cart) but that Able continues to revise their product, and create new updated builds. This is going to become a mess as we go our way with their product and they go theirs. What I need to do is manage changes. We have been keeping a log file on changes but they are only as good as the technician that documents it. With this being the case I had a discussion last night at the study group with Teddy, and John that there are many many other options that may be good for me. I will need to compare Older AbleCommerce builds with newer ones so I can see the changes. Also to save as a base line a certain config as a build once updates are done. Then examining the AbleCommerce changes integrate them into our code. Or Vice versa. And this needs to be as simple as possible. So I respectfully open the floor for debate on what is the best FREEWARE product for us to manage these ongoing changes. Note: These changes would be CFM, CSS, WZC (AbleCommerce Wizard) files only for the most part that I can see. It would also be nice however if certain tables in the DB could be saved with a build as well if that would be possible. (for cart settings mostly) We are using CF6 at the moment on a Windows 2K server in MySQL4.1 Let the debate begin! Thanks! Robert P. Reil Managing Director, Motorcyclecarbs.com, Inc. 4292 Country Garden Walk NW Kennesaw, Ga. 30152 Office 770-974-8851 Fax 770-974-8852 www.motorcyclecarbs.com - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] Editor Options for CF7 (Macromedia Studio 8? Homesite? Some other editor?)
I know how Charlie feels...but, here's a strong motivational point for those of you out there trying to decideECLIPSE IS FREE! =) It took me a little while to get used to it, but I love Eclipse now. The biggest downfall I've seen is the absence of FTP. But, other than that, it is a beautiful editor. And, againIT'S FREE!!! Allen -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Charlie ArehartSent: Thursday, June 29, 2006 9:35 AMTo: discussion@acfug.orgSubject: RE: [ACFUG Discuss] Editor Options for CF7 (Macromedia Studio 8? Homesite? Some other editor?) Well, I'll just speak up for the other "dinosaurs" who haven't gotten into Eclipse. :-) I just find that various things I'm used to aren't there, and while I suppose they may be there if I poke around enough, the problem is typical of getting any developer to move from one editor to another. Similarly, some of the great advantages that Eclipse/CFEclipse are ones that I just for now don't need. I won't deny that at some point I (and others) may simply need to bite the bullet and suck it up. For now, though, I can speak for many who feel EXTREMELY productive in HS+ and just haven't felt a strong enough motivation to move. /charlie From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of West, JasonSent: Thursday, June 29, 2006 8:50 AMTo: discussion@acfug.orgSubject: RE: [ACFUG Discuss] Editor Options for CF7 (Macromedia Studio 8? Homesite? Some other editor?) What I have found interesting is that the New FLEX developer was built using Eclipse. IMHO if you are wanting to get the latest studio that will be the next IDE for development (not trying to promote but rather keep up) then the Eclipse with CFEclipse might be your best bet. I am currently working with Cingular and they provide the Dreamweaver Ver 8 on the desk when you walk in. I loaded the Eclipse with CFEclipse and my only complaint would be that Dreamweaver has an FTP on save where Eclipse/CFEclipse does not. With our current environment that is a necessity to the developers with our testing servers being on UNIX systems and not on the local box. Jason- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink -
RE: [ACFUG Discuss] OT: Query Problem
A Union by itself is like doing a distinct. It will remove any duplicates. In SQL Server you use UNION ALL to keep duplicates. There is probably an equivalent in Oracle. Allen Underwood -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Thursday, June 15, 2006 10:33 AM To: discussion@acfug.org Subject: [ACFUG Discuss] OT: Query Problem I have a two part Oracle 9i query with a UNION operator. The query should return 34 rows. It returns 32. If I remove the first part of the query, which by itself returns 0 rows, the query correctly returns 34 rows. What's special about these two rows? The price is identical in each case to the price in another record. So there are two records with a price of 118.75 and two records with a price of 6.25. All other prices are unique. Why should this make a difference? If I change the UNION to a UNION ALL, I get 34 records, which is OK in this case, but not others. Just plain UNION should work. Any hints are appreciated. Table names have been removed from the following query for this post. SELECT (i.price * i.qty) as price, EXTRACT(Month from t.createDate)AS current_month, fa.id as FA_ID, fa.name AS functional_area, fa.division, s.name as service, s.contract_number, s.id as Service_ID FROM i, t, s, fa WHERE fa.id IN ('6') AND s.fa_id = fa.id AND s.contract_number IN ('VOICE-RTP-DIALTONE 0684031TEL XEB001') AND s.labor = 'N' AND s.id IN (17.0) AND upper(substr(t.dcn, 1, 3)) = upper(substr(s.dcn, 1, 3)) AND t.fiscal_year = 2006 AND t.type = 'BC' AND t.status != 'D' AND i.trans_id = t.id UNION SELECT price, EXTRACT(Month from i.begin_period)AS current_month, fa.id as FA_ID, fa.name AS functional_area, fa.division, s.name as service, s.contract_number, s.id as service_id FROM i, t, ca, s, fa WHERE fa.office LIKE 'OARM-RTP' AND s.fa_id = fa.id AND s.contract_number IN ('VOICE-RTP-DIALTONE 0684031TEL XEB001') AND upper(s.name) NOT LIKE '%WCF%' AND ca.service_id = s.id AND t.ca_id = ca.id AND i.trans_id = t.id AND ( (EXTRACT(Month from i.begin_period) = 10 AND EXTRACT(Year from i.begin_period) = 2006 - 1) OR (EXTRACT(Month from i.begin_period) = 9 AND EXTRACT(Year from i.begin_period) = 2006) ) ORDER BY contract_number, division, functional_area, service, current_month, price -- Ed Szwedo Web Development Team Lead CSC E-mail: [EMAIL PROTECTED] 919-541-3955 (Voice) 919-541-3719 (Fax) -- Ed Szwedo Web Development Team Lead CSC E-mail: [EMAIL PROTECTED] 919-541-3955 (Voice) 919-541-3719 (Fax) - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] .sql file comparators
For you guys out there who like beyond compare - there is another free utility which is very nice for windows. http://winmerge.sourceforge.net Allen -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Adam ChurvisSent: Tuesday, May 30, 2006 10:56 AMTo: discussion@acfug.orgSubject: Re: [ACFUG Discuss] .sql file comparators On the cheap you can use BeyondCompare, which rocks. If you have *much* money you can use Embarcadero Change Manager, but it sounds like BeyondCompare should do what you need. Respectfully, Adam Phillip ChurvisCertified Advanced ColdFusion MX 7 DeveloperBlueDragon Alliance Founding Committee Get advanced intensive Master-level training inC# ASP.NET 2.0 for ColdFusion Developers atProductivityEnhancement.com - Original Message - From: Robert Reil To: discussion@acfug.org Sent: Monday, May 29, 2006 2:22 PM Subject: [ACFUG Discuss] .sql file comparators I have a mess... We use excel to manipulate and import data into a mysql db table. Somehow we lost the ability temporarily to QA the data and we have lost control of the data in each row. I need to go back into my original back ups and piece by piece see where new products have been rolled out and crop those items from the DB and manage them individually. Is there a tool that will take a .sql dump file and compare it and spit out reports on what is different? That way I can do a .csv extraction to rework the data for a new push to the repaired db later? Any and all advice is much appreciated. Robert P. Reil Managing Director, Motorcyclecarbs.com, Inc. 4292 Country Garden Walk NW Kennesaw, Ga. 30152 Office 770-974-8851 Fax 770-974-8852 www.motorcyclecarbs.com - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink -
RE: [ACFUG Discuss] Question about client variables and Evaluate()
Title: Message No, unfortunately it won't work...that's why the GetClientVariablesList() existed in 5 and previous versionsif you could use it as a structure you would be able to do StructKeyList(). -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Philip ArnoldSent: Thursday, May 11, 2006 11:25 AMTo: discussion@acfug.orgSubject: RE: [ACFUG Discuss] Question about client variables and Evaluate() Might sound strange, but I thought that CF5 allowed the [] notation on scopes. I know it didn't have the variables scope, but I'm pretty sure that it used the client scope like this. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]Sent: 11 May 2006 13:17To: discussion@acfug.orgSubject: [ACFUG Discuss] Question about client variables and Evaluate() Hello all, I've got a question regarding how to retrieve the value of a client variable without using evaluate(). Before everyone bombards me with how evil evaluate() is, let me just say I know!!! Here's the situation - need to code that will work in both CF5 and MX (as it is a mixed environment of servers for the time being). We spoke to a macromedia rep and they stated that using evaluate() in MX causes a page recompile which drastically hinders performance. Is there any way to reference a client variable that will work for both CF5 and MX without using evaluate()? Example: cfset variableName = "companyAddress" CF5 example: cfoutput#Evaluate("client.#variableName#")#/cfoutput MX example: cfoutput#client[variableName]#/cfoutput Is there a way to do it that will work for both without the evaluate?! Thanks, Allen * To unsubscribe from this list, manage your profile @ * * http://www.acfug.org?fa=login.edituserform * * * * For more info, see http://www.acfug.org/mailinglists * * To unsubscribe from this list, manage your profile @ * * http://www.acfug.org?fa=login.edituserform * * * * For more info, see http://www.acfug.org/mailinglists * * To unsubscribe from this list, manage your profile @ * * http://www.acfug.org?fa=login.edituserform * * * * For more info, see http://www.acfug.org/mailinglists *