Re: Pskill and cfexecute

2008-01-26 Thread C S
> I am trying to kill the process htmldoc.exe, using pskill.exe, however > i keep getting the following error Sorry if this is a duplicate. The first response never appeared. The program may be waiting for an acceptance of the EULA. If you are using an newer version, try using the -accepteula a

Re: CFFTP Tag Delimma

2008-01-26 Thread James Holmes
Add a cfsetting tag to increase the request timeout too. On Jan 27, 2008 9:28 AM, Rick Faircloth <[EMAIL PROTECTED]> wrote: > Hi, all. > > I've managed to get the CFFTP tag to successfully download > a .zip file of 28 MB from a remote FTP server. > > It seems that I needed to set the timeout attri

CFFTP Tag Delimma

2008-01-26 Thread Rick Faircloth
Hi, all. I've managed to get the CFFTP tag to successfully download a .zip file of 28 MB from a remote FTP server. It seems that I needed to set the timeout attribute in the tag itself. It defaults to 30 seconds, which is represented in cfdump of the connection var as 3. So, I assume 3 i

RE: Why would I get a cfhttp timeout on this cfftp operation?

2008-01-26 Thread Rick Faircloth
Well... I downloaded an FTP program and hooked into the remote server with no problem and downloaded two, 25MB files. So there's no problem with the access. I had setup Sandbox Security on CF Admin, since I read I the docs that it had to be enabled to use FTP, but I've turned that back off and it

Re: Pskill and cfexecute

2008-01-26 Thread Jason Congerton
> > I am trying to kill the process htmldoc.exe, using pskill.exe, > however > > i keep getting the following error > > It might be waiting for acceptance of the EULA. If you are using a > newer version, try adding the flag -accepteula good job!!! i've been yanking my hair on this one, tried

Re: Pskill and cfexecute

2008-01-26 Thread C S
> I am trying to kill the process htmldoc.exe, using pskill.exe, however > i keep getting the following error It might be waiting for acceptance of the EULA. If you are using a newer version, try adding the flag -accepteula ~|

RE: is it possible to open cfml page from sql server stored proce dure?

2008-01-26 Thread Dave Watts
> I am using CF8. > Can you send me the syntax for using wget or cURL? > > I tried the following and it gave me an error: > EXEC master..xp_cmdshell 'cURL http://www.mywebsite.com' > > The error i got was: > 'cURL' is not recognized as an internal or external command, > operable program or batch

RE: is it possible to open cfml page from sql server stored proce dure?

2008-01-26 Thread Dave Watts
> > My goal is to run a series of stored procedures. At one > > point, while I run the stored procedures, I need to run > > coldfusion code which has a cfquery tag and some complex > > if and else conditions which are easier done in coldfusion > > than t-sql. > > I would think that if it is co

Re: OT: SQL Question -- Order by a column's value?

2008-01-26 Thread Brian Kotek
I actually prefer to do this in the ORDER BY clause (keeping the ordering logic in the ORDER BY instead of in the SELECT) but the end result is the same. If you won't or can't add a sort column to the table, a CASE statement is about the only other way to do this in the query itself. On Jan 25, 20

Re: Has anyone here built a solid RSS Ingest system?

2008-01-26 Thread Don L
>A system that would ingest stories from 1+ rss feeds? I think so. And in my view, there are at least two techniques to handle exception gracefully using CFTHREAD tag. a) the "timeout" attribute, this is an easier way to implement; b) using a predetermined timeout, to kill a thread if it does

Re: "##" issue & SQL Query

2008-01-26 Thread Don L
Very difficult to read your sql stmt. One option would be like this (aliasing column name containing # sign). e.g. Select [column a with # sign] as col1 >From myTBL e.g. -- s step further with the above idea using CASE ... WHEN ... ELSE ... END as well >I have a sql query (SQL Server 200

Re: lite spell checker?

2008-01-26 Thread Don L
Never mind. I figured it out after 40 minutes this morning. Not using the Aspell approach. Thank you. >You should change the location of the 'spellchecker.cfm' file to the >location of the page on your local system. > >As for the request var error, rerun the system after the new location has >

Re: date problem

2008-01-26 Thread Claude Schneegans
>>thanks again for all your help claude You're welcome, and congratulation for you wise shopping ;-) -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Tha

RE: "#" issue & SQL Query

2008-01-26 Thread Adrian Lynch
If ever you need the literal string "#" and it's in a place where ColdFusion will try to evaluate it (which is the case inside cfquery), use two "##". Adrian http://www.adrianlynch.co.uk/ -Original Message- From: Tech Gate Sent: 26 January 2008 16:29 To: CF-Talk Subject: Re: "#" issue & S

Re: date problem

2008-01-26 Thread Richard White
Hi Claude, i just bought this component, it seems fairly straight forward, thanks very much this has been an ongoing issue for some time!!! will let you know if i have any questions if you dont mind thanks again for all your help claude richard

Re: DNS Hosting

2008-01-26 Thread Gerald Guido
I used the DnyDns.org pay service. Highly recommended but a bit pricy @ $27.50/domain/yr zoneedit.com is also good and free. A lot of domain registers offer free DNS services so you might look into that. I use Domainmonger.com's DNS service and am very happy with it. In any event I would seek ou

Re: "#" issue & SQL Query

2008-01-26 Thread Tech Gate
I tried: SELECT @Col_with_No_Pound = @Col_with_No_Pound + CASE @Col_with_No_Pound WHEN '' THEN '' ELSE ',' END + COLUMN_NAME, @Col_with_Pound= @Col_with_Pound + CASE @Col_with_Pound WHEN '' THEN '%' ELSE '%,%' END + COLUMN_NAME But, I get another error. === Error Message ==

"#" issue & SQL Query

2008-01-26 Thread Tech Gate
I have a sql query (SQL Server 2000) for CFMX: SELECT @Col_with_No_Pound = @Col_with_No_Pound + CASE @Col_with_No_Pound WHEN '' THEN '' ELSE ',' END + COLUMN_NAME, @Col_with_Pound= @Col_with_Pound + CASE @Col_with_Pound WHEN '' THEN '#' ELSE '#,#' END + COLUMN_NAME . Obviously, # i

Re: is it possible to open cfml page from sql server stored procedure?

2008-01-26 Thread C. Hatton Humphrey
> My goal is to run a series of stored procedures. At one point, while > I run the stored procedures, I need to run coldfusion code which has > a cfquery tag and some complex if and else conditions which are > easier done in coldfusion than t-sql. I would think that if it is conditionals (regardle

RE: is it possible to open cfml page from sql server stored procedure?

2008-01-26 Thread Dawson, Michael
Make sure you are using the entire path to "wget" or "curl". SQL Server may not know where those programs reside on your server. Then, test it in a command window before trying it in a stored proc. M!ke _ From: Discover Antartica [mailto:[EMAIL PROTECTED] Sent: Sat 1/26/2008 7:05 AM

Re: DNS Hosting

2008-01-26 Thread Jochem van Dieten
Dave Hatz wrote: > I am looking for recommendations on a company to host our DNS. Look for the two cheapest Linux VPS'es you can find (one on the East coast and one on the West coast) and host backup DNS, backup MX and backup network monitoring on them. Jochem ~

Re: lsdateformat and dateformat clarification

2008-01-26 Thread Jochem van Dieten
Richard White wrote: > i was under the impression that if i set a locale as English UK and then used > the follwing code: > > lsdateformat("07/24/1978","dd/mm/") that it would convert this date into > 24/07/1978 > but i am getting an error '07/24/1978 is an invalid date format' but if i use

Re: is it possible to open cfml page from sql server stored procedure?

2008-01-26 Thread Discover Antartica
I am using CF8. Can you send me the syntax for using wget or cURL? I tried the following and it gave me an error: EXEC master..xp_cmdshell 'cURL http://www.mywebsite.com' The error i got was: 'cURL' is not recognized as an internal or external command, operable program or batch file. Thanks ---

RE: Why would I get a cfhttp timeout on this cfftp operation?

2008-01-26 Thread Will Swain
Have you tried setting up an ftp account on a different server and accessing that? See if you get the same problem. I'm stumped tbh. -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: 26 January 2008 01:11 To: CF-Talk Subject: RE: Why would I get a cfhttp timeout on

Re: lsdateformat and dateformat clarification

2008-01-26 Thread Richard White
oh i see! thanks claude you have really made me understand this now :) ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w

Pskill and cfexecute

2008-01-26 Thread Jason Congerton
Hi I am trying to kill the process htmldoc.exe, using pskill.exe, however i keep getting the following error Timeout period expired without completion of E:\Websites\pstools\pskill.exe The error occurred in E:\Websites\selwood\test1.cfm: line 7 5 : 6 : 7 : Here is my code an