Re: MySQL - How to create a category tree in a store

2009-05-23 Thread Will Tomlinson
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

Re: MySQL - How to create a category tree in a store

2009-05-23 Thread Ryan Letulle
@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

Anyone see a problem with this code? Won't execute...

2009-05-23 Thread Rick Faircloth
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

Re: Anyone see a problem with this code? Won't execute...

2009-05-23 Thread Ryan Letulle
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

Re: Anyone see a problem with this code? Won't execute...

2009-05-23 Thread Ryan Letulle
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

Re: Anyone see a problem with this code? Won't execute...

2009-05-23 Thread Peter Boughton
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:

Re: Anyone see a problem with this code? Won't execute...

2009-05-23 Thread Jason Fisher
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,

Re: Anyone see a problem with this code? Won't execute...

2009-05-23 Thread Ryan Letulle
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

Re: Anyone see a problem with this code? Won't execute...

2009-05-23 Thread Dave Watts
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

Re: Anyone see a problem with this code? Won't execute...

2009-05-23 Thread Rick Faircloth
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=

Re: Weird query behavior

2009-05-23 Thread Judah McAuley
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