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 : cfexecute name=#pSkill# arguments=-t htmlDoc outputfile=#psfile# 
timeout=25/cfexecute


Here is my code

cfset pskill = E:\Websites\pstools\pskill.exe
cfset psdir = E:\Websites\pstools\
cfset psfile = E:\Websites\pstools\ps.txt

cfexecute name=#pSkill# arguments=-t htmlDoc outputfile=#psfile# 
timeout=25/cfexecute

any help would be appreciated

jason


 


~|
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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297514
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297515
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


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 this cfftp operation?

The page runs successfully until it times out while the download operation
is going on.

I can watch the file being downloaded in Windows Explorer until the point
where the page times out like any other slow web page.  At that point the
page shows the error message and the download stops.

Any other thoughts or tests I can run?
Debugging info I can gather?


 -Original Message-
 From: Dave Watts [mailto:[EMAIL PROTECTED]
 Sent: Friday, January 25, 2008 6:01 PM
 To: CF-Talk
 Subject: RE: Why would I get a cfhttp timeout on this cfftp operation?
 
  No problems anywhere, but with CFFTP.
 
  I just need to get around the CFHTTP page timeout.  And there should 
  be a way to use the CFFTP tag without having to resort to jumping 
  through a lot of hoops using third-party software and contorted 
  methods.
 
  Why won't the tag just work?
 
 Any number of reasons. Again, this probably isn't an HTTP problem if 
 you can't successfully run the page directly (as opposed to running it 
 as a scheduled task).
 
 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!
 
 



~|
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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297516
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


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

- Original Message 
From: Terry Schmitt [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Friday, January 25, 2008 4:08:29 PM
Subject: Re: is it possible to open cfml page from sql server stored procedure?

You didn't specify the CF version, but for CF6+ use wget or cURL.
In the old days with CF5 (and still for me) you can actually execute the CF 
executable with the page as a parameter.

T
 Hello All
 Is there a way to execute a coldfusion file from a microsoft sql 
 server stored procedure?
 In other words, since cf files don't have a .exe extension, is it 
 possible to open a cfml page from a sql stored procedure?
 
 note: 
 i can open sql files and run them by using commands such as the 
 following:
 
 EXEC master..xp_cmdshell 'osql -E -i 
 \\mycomputernetworkname\Driveletter\foldername\testing.sql'
 
 best regards
 DA
 
 
  
___ 
_
 Never miss a thing.  Make Yahoo your home page. 
 http://www.yahoo.
com/r/hs 



~|
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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297517
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


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 
 dateformat instead of lsdateformat then it converts it fine
 
 it seems to me that lsdateformat function takes an english uk formated date 
 (dd/mm/)

Taking some string input and converting that to a date object is what 
ParseDateTime() and LSParseDateTime() are for. All other date and time 
functions should not be fed string input but date objects. (And if you 
have to use string input, use the -mm-dd format.)

Jochem

~|
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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297518
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


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

~|
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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297519
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


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
To: CF-Talk
Subject: Re: is it possible to open cfml page from sql server stored procedure?



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' 
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

- Original Message 
From: Terry Schmitt [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Friday, January 25, 2008 4:08:29 PM
Subject: Re: is it possible to open cfml page from sql server stored procedure?

You didn't specify the CF version, but for CF6+ use wget or cURL.
In the old days with CF5 (and still for me) you can actually execute the CF 
executable with the page as a parameter.




~|
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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297520
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


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 (regardless of the
complexity) that it would make more architectural sense to do
everything within SQL.  Granted, you may want to build a user defined
function to handle the comparisons, but that would be more effective
and portable than utilizing WGet or cURL.

If you go the route of the executables, you will need to obtain them
and install on your server.  Neither are included with Windows.

Your other option would be to move everything into CFML.

Hatton

~|
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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297521
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


# 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, # is causing the error whereas I need to # sign there.

=== Error Message ==

The CFML compiler was processing:

An expression that began on line 27, column 99.
Your expression might be missing an ending # (it might look like #expr ).
The body of a cfquery tag beginning on line 20, column 2.

27 :@Col_with_Pound= @Col_with_Pound + CASE
@Col_with_Pound WHEN '' THEN '#' ELSE '#,#' END + COLUMN_NAME


How do you get around this error?  I need to use a single # in the
query for the output.

thx much

~|
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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297522
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


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

cfset demo_Col_with_Pound = replace(#DemoCol.Col_with_Pound#, %, #, ALL)

But, I get another error.

=== Error Message ==

The CFML compiler was processing:

an expression beginning with replace, on line 37, column 30.This
message is usually caused by a problem in the expressions structure.
a cfset tag beginning on line 37, column 2.


36 : cfset demo_Col_with_No_Pound = DemoCol.Col_with_No_Pound
37 : cfset demo_Col_with_Pound = replace(#DemoCol.Col_with_Pound#,
%, #, ALL)

Thx much

On Jan 26, 2008 11:07 AM, Tech Gate [EMAIL PROTECTED] wrote:

 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, # is causing the error whereas I need to # sign there.

 === Error Message ==

 The CFML compiler was processing:

 An expression that began on line 27, column 99.
 Your expression might be missing an ending # (it might look like #expr ).
 The body of a cfquery tag beginning on line 20, column 2.

 27 :@Col_with_Pound= @Col_with_Pound + CASE
 @Col_with_Pound WHEN '' THEN '#' ELSE '#,#' END + COLUMN_NAME


 How do you get around this error?  I need to use a single # in the
 query for the output.

 thx much


~|
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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297523
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


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 out reviews of DNS providers and make sure that
they have significant redundancy (4+ servers).

Here is a starting point:

http://www.google.com/Top/Computers/Software/Internet/Servers/Address_Management/Dynamic_DNS_Services/

Another option is to get a resellers or hosting account with a reputable
hosting company that uses H-sphere (or Plesk to a lesser degree).

H-sphere has an interface that allows you full control over DNS. I have used
it for DNS and it worked great. Hostdepartment offers resellers accounts for
$25 a month. Sozo has them for $50/mo with CF 7 support.

Disclaimer: I have been with Hostdepartment for years and never had problems
with DNS but their technical support is dodgy and some of their boxes flake
out every so often. I keep them around because I find it to be very handy to
have access to cheap (Linux) hosting.  But I wouldn't trust them (or any
large low cost hosting company) with any thing remotely mission critical.

http://www.hostdepartment.com/


On Jan 25, 2008 6:34 PM, Dave Hatz [EMAIL PROTECTED] wrote:

 I am looking for recommendations on a company to host our DNS.  We are
 currently using Internap's CoLocation services and their DNS went down
 again.  3rd time in less than 2 months.  Our customers are pissed and I
 don't blame them.  I need to find another solution and always value the
 recommendations from this list.

 Thanks,
 Dave Hatz

 

~|
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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297524
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


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 

~|
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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297525
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


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  SQL Query


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

cfset demo_Col_with_Pound = replace(#DemoCol.Col_with_Pound#, %, #,
ALL)

But, I get another error.

=== Error Message ==

The CFML compiler was processing:

an expression beginning with replace, on line 37, column 30.This
message is usually caused by a problem in the expressions structure.
a cfset tag beginning on line 37, column 2.


36 : cfset demo_Col_with_No_Pound = DemoCol.Col_with_No_Pound
37 : cfset demo_Col_with_Pound = replace(#DemoCol.Col_with_Pound#,
%, #, ALL)

Thx much


~|
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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297526
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


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])
Thanks.


~|
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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297527
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: quot;##quot; issue amp; 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 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, # is causing the error whereas I need to # sign there.

=== Error Message ==

The CFML compiler was processing:

An expression that began on line 27, column 99.
Your expression might be missing an ending # (it might look like #expr ).
The body of a cfquery tag beginning on line 20, column 2.

27 :@Col_with_Pound= @Col_with_Pound + CASE
@Col_with_Pound WHEN '' THEN '#' ELSE '#,#' END + COLUMN_NAME


How do you get around this error?  I need to use a single # in the
query for the output.

thx much 

~|
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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297529
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


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 not complete 
within a specified time, check out livedocs for detail.

And since we're at it, I wish the CFFEED tag has a cache attribute like 
CFQUERY, hence, it can improve performance greatly (saving round trips to feed 
source), scenario, daily news.  Yes, the xmlVar, or varXML would function 
kind of similarly, but you would to go through the whole damn process, creating 
such such a file, checking date/time stamp... 

~|
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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297530
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


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, 2008 3:00 PM, Ian Skinner [EMAIL PROTECTED] wrote:

 Che Vilnonis wrote:
  I was trying to do that w/o adding another column. Can it be done?
 Yes, see Crow's, Charlie's or my post on using CASE to create an inline
 sort column with SQL.



 

~|
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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297531
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


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
been defined above and we can work through that.

William

-- 
William E. Seiter


~|
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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297528
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


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 conditionals (regardless of the
 complexity) that it would make more architectural sense to do 
 everything within SQL.  Granted, you may want to build a user 
 defined function to handle the comparisons, but that would be 
 more effective and portable than utilizing WGet or cURL.
 
 If you go the route of the executables, you will need to 
 obtain them and install on your server.  Neither are included 
 with Windows.
 
 Your other option would be to move everything into CFML.

I would second C's (Hatton's?) recommendation. Calling CF code from SQL may
be easier to do now (assuming you've already written the CFML) but it will
be harder to maintain that sort of violation of application partitioning in
the future. It also requires your database server to be able to make HTTP
requests, which is often prevented or at least limited in secure
environments for obvious security reasons.

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!

~|
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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297532
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


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 file.

As others have already mentioned, neither wget or cURL are distributed with
Windows. In addition, you generally don't want to install client utilities
like these on a database server, unless you're absolutely sure that outbound
client requests are blocked at the firewall. In a properly-secured SQL
Server environment, access to the built-in FTP client is often blocked, for
example.

In addition, in a properly-secured SQL Server environment, access to system
stored procedures like xp_cmdshell is often blocked as well, since they are
often targeted as the end step of an SQL injection attack.

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!

~|
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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297533
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


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 

~|
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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297534
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


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 permissions, different 
file locations, timeouts, different solutions - thank you!!! 

~|
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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297535
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


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 hasn't helped.

Is anyone out there successfully using the CFFTP tag?

Rick

 -Original Message-
 From: Will Swain [mailto:[EMAIL PROTECTED]
 Sent: Saturday, January 26, 2008 7:26 AM
 To: CF-Talk
 Subject: RE: Why would I get a cfhttp timeout on this cfftp operation?
 
 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 this cfftp operation?
 
 The page runs successfully until it times out while the download operation
 is going on.
 
 I can watch the file being downloaded in Windows Explorer until the point
 where the page times out like any other slow web page.  At that point the
 page shows the error message and the download stops.
 
 Any other thoughts or tests I can run?
 Debugging info I can gather?
 
 




~|
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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297536
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


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 is 3 ms or 30 seconds.

That 3 was too short for the download, but a setting of 6 ms or 9 ms
was more than enough, even though the download took longer than 60 or 90 secs. 
(?)

However, a new error occurs right after the download finishes.

When the next cfftp tag is run to close the connection, an error occurs stating:
The request has exceeded the allowable time limit Tag: cfftp

Therefore, my cfmail tag does fire to send me a successful download message.

Seems I'm stuck between a rock and a hard place.  Make the timeout long enough
to get the full download and cause a exceeded the allowable time limit or
have too short a time for the download, which causes a I/O Exception while 
reading
error.

Clues?  Hints?  Suggestions?

Thanks,

Rick



~|
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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297537
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


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 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 is 3 ms or 30 seconds.

 That 3 was too short for the download, but a setting of 6 ms or 9 
 ms
 was more than enough, even though the download took longer than 60 or 90 
 secs. (?)

 However, a new error occurs right after the download finishes.

 When the next cfftp tag is run to close the connection, an error occurs 
 stating:
 The request has exceeded the allowable time limit Tag: cfftp

 Therefore, my cfmail tag does fire to send me a successful download message.

 Seems I'm stuck between a rock and a hard place.  Make the timeout long enough
 to get the full download and cause a exceeded the allowable time limit or
 have too short a time for the download, which causes a I/O Exception while 
 reading
 error.

 Clues?  Hints?  Suggestions?

 Thanks,

 Rick



 

~|
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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297538
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


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 argument. 

~|
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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297539
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: WOW, what a plight!!

2008-01-26 Thread Scott Stewart
Had a similar situation last February... my wife and I had decided to move
from DC to Raleigh, I found a job in Raleigh, took a 13K/yr pay cut, and
left a job that I loved.

Got to Raleigh to discover that the company was much smaller and far less
organized than they let on, the lead developer was the only developer,
there was no documentation, schemas, notes, anything it was all in his head,
and he was too paranoid to let much go. The application was one of the most
convoluted piles of shit that I had ever had the displeasure of working on.

I was let go after two weeks, because I wasn't up to speed..just after
we'd put a contract on a house in Raleigh.

We had to dump the contract and wait. Three weeks later I found a DC
telecommute position, and I've been doing straight contract work ever since.

We moved to Raleigh at the end of July, we have 2500 sq.ft. and a half acre
of land. I've got a shiny new gov't contract, and a 25K pay raise from where
I would've been if I had stayed with the company in Raleigh.

You'll always run into people that sell themselves, and/or their company as
something that they're not. You just have to have to not let them get you
down for long, and remember that they'll get theirs in the end...



-- 
Scott Stewart
ColdFusion Developer
 
SSTWebworks
4405 Oakshyre Way
Raleigh, NC. 27616
(919) 874-6229 (home)
(703) 220-2835 (cell)
-Original Message-
From: William Seiter [mailto:[EMAIL PROTECTED] 
Sent: Friday, January 25, 2008 5:20 PM
To: CF-Jobs-Talk
Subject: WOW, what a plight!!

I was just let go yesterday.  The reason was simple, but as I review the
short time that I was with the company, there were tremendous factors that
were involved with that eventual demise of my employment for this company.
I certainly am to fault, but just as much, if not more, is the company and
management.

I was interviewed last October, extensively, for a position with Z3NC0N
[EMAIL PROTECTED] (the alphanumeric was added to keep this out of the search
engines), later to become P30PL3 M3D1@, running 37 dating websites.

I was described a position for a company that was moving to Los Angeles in
Mid November, but would continue having an office in Arizona for a few
months.  The office is an open and friendly environement that viewed
productivity above all else.  I was told that I would fly to Arizona 1 or 2
times during November and December for training, but would be posted out of
the Los Angeles office the rest of the time.  

After discussing this with my wife, we agreed that 1 or 2 times would be an
okay sacrifice, for the upside potentials that the position would give me.
(We have a 'troubled' son, so we discussed the travel at length)

I took the position and asked many, many questions regarding the street
address of the LA office, along with other questions, but was given no
response to the location of the LA office.

The friday before I would start the position in mid-november, I caught the
bad flu that was going around.  Even though I was very sick, I decided to go
ahead and take the flight and start the new job, instead of postponing until
I felt better.

When I arrived at the job that following Monday, I was not received with
open arms.  My direct manager did not, at any time during my time there
ever, look or sound happy to see me.  I was immediately given project to
work with and it was, if not said, intoned that I was now to prove myself.
(By the way, the flight made my flu much much worse).  My office was 1 of 4
fullsized 'teacher' desks in a 10x10 room.  My boss sat behind me and to the
left, my co-worker (his younger brother), sat directly behind me.  I wasn't
allowed to plug in my earbuds to help me to focus on the work at hand.  I
was expected to be 'up to speed' on their systems almost immediately.  I was
expected to know what was in my bosses head.  He would give me a task to
accomplish, not respond to my questions, or if he did he acted 'put out'
that he had to deal with me.  

I was also informed that the 'deal' for the LA office had fallen through,
and even though I could work from home on fridays (my flights had been
arranged for Monday thru Thursday), I would be required to fly to Arizona
every week until an office was found.  Due to the increased plane travel, my
flu symptoms lasted until the week prior to the holidays.  I had been told
in the interview (undocumented) that those weeks that I flew, the Friday's
would be mine, since the interviewer understood the extra hours involved
with flying back and forth.  My new 'boss' did not mirror that consent, he
actually considered the 'flight time' to be on my time and when I came in
around 11am on Mondays and left at around 4:30pm on Thursdays, I was
'ill-preforming'.

My home life severely decomposed as my son started acting out at school and
at home with my wife.  This along with my severe lack of feeling appreciated
at work started me to look at this position and company with disgust.  I
felt that if I could make it to 

Re: WOW, what a plight!!

2008-01-26 Thread Jerry Johnson
It is not always an intentional bait and switch

Sometimes it is people fooling themselves into believing their own
hype (or plans without substance). Sometimes it is just people who are
so unorganized and confused (or without any real understanding of the
job and needs and how to get work done)

You can potentially rescue people from the second (that is probably
why they are hiring a professional developer), but if they already
have experts in house, or if they won't listen to real critique and
take your professional advice, then you are lucky to get out quick.



On Jan 26, 2008 12:58 PM, William Seiter [EMAIL PROTECTED] wrote:
 I really do appreciate all of the support here.  It helps a lot to know that
 this type of 'bait and switch' isn't as uncommon as I thought it was.
 (although it is a little disheartening at the same timethat it is so
 common.)

~|
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

Archive: 
http://www.houseoffusion.com/groups/CF-Jobs-Talk/message.cfm/messageid:3581
Subscription: http://www.houseoffusion.com/groups/CF-Jobs-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11


php job list?

2008-01-26 Thread RobG
Hey does anybody know if there is a jobs list for php developers like 
CF-Jobs?  Now that I'm starting to learn php, I wouldn't mind picking up 
some entry-level work so I can gain more experience with it.

Thanks!

Rob


~|
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

Archive: 
http://www.houseoffusion.com/groups/CF-Jobs-Talk/message.cfm/messageid:3582
Subscription: http://www.houseoffusion.com/groups/CF-Jobs-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11