Re: MySQL - How to create a category tree in a store
I think I'm going to use this tool: http://nstree.riaforge.org/ I've been playing around with it. Seems fairly straightforward and does everything I need. I'm just working on what the admin interface would look like to display the entire tree so you could select multiple categories for a given product. Thanks for everyone's input. Will ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322755 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: MySQL - How to create a category tree in a store
@will Good deal. Haven't used below but it seems the author has written a nice book about it on his site. Good luck. -- Ryan On Sat, May 23, 2009 at 2:27 AM, Will Tomlinson w...@wtomlinson.com wrote: I think I'm going to use this tool: http://nstree.riaforge.org/ I've been playing around with it. Seems fairly straightforward and does everything I need. I'm just working on what the admin interface would look like to display the entire tree so you could select multiple categories for a given product. Thanks for everyone's input. Will ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322756 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Anyone see a problem with this code? Won't execute...
I can run this code, and see cmd.exe open in the list of services in the Task Manager, but cmd.exe closes rather quickly and there are no results from the batch file. Just wondering if anyone sees any problem with the code, itself. This was running fine on XP, but now I'm executing it on Windows 7 RC, CF 8.0.1... cfexecute name = C:\WINDOWS\system32\cmd.exe arguments = /c f:\inetpub\webroot\real_estate_data\hmls\10_hmls_batch files\load_hmls_active_photos.bat timeout = 0 /cfexecute Thanks for any feedback. Rick Ninety percent of the politicians give the other ten percent a bad reputation. Henry Kissinger ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322757 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Anyone see a problem with this code? Won't execute...
You might try putting the f:\inetpub ... in double quotes. -- Ryan On Sat, May 23, 2009 at 6:27 PM, Rick Faircloth r...@whitestonemedia.comwrote: I can run this code, and see cmd.exe open in the list of services in the Task Manager, but cmd.exe closes rather quickly and there are no results from the batch file. Just wondering if anyone sees any problem with the code, itself. This was running fine on XP, but now I'm executing it on Windows 7 RC, CF 8.0.1... cfexecute name = C:\WINDOWS\system32\cmd.exe arguments = /c f:\inetpub\webroot\real_estate_data\hmls\10_hmls_batch files\load_hmls_active_photos.bat timeout = 0 /cfexecute Thanks for any feedback. Rick Ninety percent of the politicians give the other ten percent a bad reputation. Henry Kissinger ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322758 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Anyone see a problem with this code? Won't execute...
You'd have to escape them or change the outer quotes to single quotes of course. :) -- Ryan On Sat, May 23, 2009 at 7:03 PM, Ryan Letulle bayous...@gmail.com wrote: You might try putting the f:\inetpub ... in double quotes. -- Ryan On Sat, May 23, 2009 at 6:27 PM, Rick Faircloth r...@whitestonemedia.comwrote: I can run this code, and see cmd.exe open in the list of services in the Task Manager, but cmd.exe closes rather quickly and there are no results from the batch file. Just wondering if anyone sees any problem with the code, itself. This was running fine on XP, but now I'm executing it on Windows 7 RC, CF 8.0.1... cfexecute name = C:\WINDOWS\system32\cmd.exe arguments = /c f:\inetpub\webroot\real_estate_data\hmls\10_hmls_batch files\load_hmls_active_photos.bat timeout = 0 /cfexecute Thanks for any feedback. Rick Ninety percent of the politicians give the other ten percent a bad reputation. Henry Kissinger ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322759 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Anyone see a problem with this code? Won't execute...
Execute the batch file directly, rather than trying to go via cmd.exe ? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322760 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Anyone see a problem with this code? Won't execute...
Correct. cmd.exe simply opens the window which allows you to run batch files ... that's what CFEXECUTE is already doing for you. So just run this: cfexecute name=f:\inetpub\webroot\real_estate_data\hmls\10_hmls_batch files\load_hmls_active_photos.bat / Execute the batch file directly, rather than trying to go via cmd.exe ? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322761 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Anyone see a problem with this code? Won't execute...
I know for vb scripts you have to run cscript.exe and pass the path to the vbs in the arguments. -- Ryan On Sat, May 23, 2009 at 8:43 PM, Jason Fisher ja...@wanax.com wrote: Correct. cmd.exe simply opens the window which allows you to run batch files ... that's what CFEXECUTE is already doing for you. So just run this: cfexecute name=f:\inetpub\webroot\real_estate_data\hmls\10_hmls_batch files\load_hmls_active_photos.bat / Execute the batch file directly, rather than trying to go via cmd.exe ? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322762 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Anyone see a problem with this code? Won't execute...
Correct. cmd.exe simply opens the window which allows you to run batch files ... that's what CFEXECUTE is already doing for you. That's not correct at all. Batch files are run by the command processor - cmd.exe. CFEXECUTE is not a command processor. And in my experience with CFEXECUTE, I've always had to run cmd.exe with the batch file as an argument. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322763 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Anyone see a problem with this code? Won't execute...
I converted all the cfexecute statesments to this format and they ran fine...they did utilize the cmd.exe even though the cmd.exe wasn't explicitly called with the format below. cfexecute name= f:\inetpub\webroot\real_estate_data\hmls\10_hmls_batch_files\load_hmls_active_photos.bat arguments = /c timeout = 5000 /cfexecute The format seemed to work either way. The issue I was having embarassingly was that when I rewrote the profiles for Navicat to run (such as load_hmls_active_photos.bat) I changed the other profile names from load_hmls_agent_temp to load_hmls_agent_data, inadvertantly changing only the last work in the name for the other profiles. That's why I could get the first profile to run, but not the others. It was driving me crazy! And I even looked over the profile and file names to insure they were correct and didn't catch it until the bitter end. What a WASTE of time because of a series of stupid mistakes...sigh... Thanks for all who prompted my thinking! Now at last I can move forward... Rick On Sat, May 23, 2009 at 10:49 PM, Dave Watts dwa...@figleaf.com wrote: Correct. cmd.exe simply opens the window which allows you to run batch files ... that's what CFEXECUTE is already doing for you. That's not correct at all. Batch files are run by the command processor - cmd.exe. CFEXECUTE is not a command processor. And in my experience with CFEXECUTE, I've always had to run cmd.exe with the batch file as an argument. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322764 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Weird query behavior
You don't say what DB it is, but I'd start by running a request profiler against it. See if the slowdown is on the DB side or the CF side. I'd also take a look at your logging. If the log files on production are filling up the disc, then additional logging to rows with text fields may be swapping a lot in and out of disc due to the larger amount of data being looked at. On a non-production box with adequate free disc space you wouldn't see that slow down. The suddenness of the changes in server behavior with no code changes tells me that you should look at resource issues that change on their own, like free disc space. I recently had a db that was set up by someone else and they used the MSSQL defaults, which have no limit to log file growth. It was fine until it wasn't. Then it really sucked. Hope that helps, Judah On Fri, May 22, 2009 at 1:00 PM, Justin Scott jscott-li...@gravityfree.com wrote: Exactly the same configuration? With the same settings for Unicode for query parameters and CLOB buffer? Yes, the data source configuration has all of the same settings. The really strange part is that everything has been working fine for weeks since the last code updates that we deployed, and this morning this one server just started having issues. I'll be restarting the entire server later tonight to see if that clears it up (you know, Windows...) or not. -Justin ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322765 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4