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

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

2009-05-23 Thread Rick Faircloth
I converted all the 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. The format seemed to work either way. The issue I was having embarassingly was that when I rewrote the profiles for Navicat

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'

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 wrote: > > Correct. cmd.exe simply opens the window which allows you to run batch > files ... that's what CFEXECUTE is already doing for you.

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: >Execute the batch file directly, rather than trying to go via cmd.exe ? ~

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: http://www.houseoffusion.c

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 wrote: > You might try putting the f:\inetpub ... in double quotes. > -- > Ryan > > > > > On Sat, May 23, 2009 at 6:27 PM, Rick Faircloth > wrote: > >> >>

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 wrote: > > 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 > f

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 Windows

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 wrote: > > I think I'm going to use this tool: > > http://nstree.riaforge.org/ > > I've been playing around with it. S

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 giv