RE: CFHTTP SSL Cert

2014-04-17 Thread Brook Davies

It continues to work fine in the browser. Its pretty weird how it will work
for a day and then start generating this error:

AxisFault
 faultCode: {http://schemas.xmlsoap.org/soap/envelope/}Server.userException
 faultSubcode: 
 faultString: javax.net.ssl.SSLException: java.lang.RuntimeException: Could
not generate secret
 faultActor: 
 faultNode: 
 faultDetail: 
{http://xml.apache.org/axis/}stackTrace:javax.net.ssl.SSLException:
java.lang.RuntimeException: Could not generate secret
at
com.sun.net.ssl.internal.ssl.Alerts.getSSLException(Alerts.java:190)
at
com.sun.net.ssl.internal.ssl.SSLSocketImpl.fatal(SSLSocketImpl.java:1731)
at
com.sun.net.ssl.internal.ssl.SSLSocketImpl.fatal(SSLSocketImpl.java:1692)
at
com.sun.net.ssl.internal.ssl.SSLSocketImpl.handleException(SSLSocketImpl.jav
a:1675)
at
com.sun.net.ssl.internal.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java
:1204)
at
com.sun.net.ssl.internal.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java
:1181)
at
org.apache.axis.components.net.JSSESocketFactory.create(JSSESocketFactory.ja
va:186)
at
org.apache.axis.transport.http.HTTPSender.getSocket(HTTPSender ''/pre


Note, this is the error from a webservice call, using CFHTTP generates the
I/O Exception: peer not authenticated. 

Restarting the CFService resolves the problem temporarily. I deleted and
re-added the CERT to the cacerts store yesterday with no change...

Just weird right?

Brook

-Original Message-
From: John M Bliss [mailto:bliss.j...@gmail.com] 
Sent: April-16-14 11:02 AM
To: cf-talk
Subject: Re: CFHTTP  SSL Cert


When cfhttp is broken, can you drop the URL into your browser and have it
work? Or is it broken there too?


On Wed, Apr 16, 2014 at 12:27 PM, Brook Davies cft...@logiforms.com wrote:


 Hey Peeps,

 After heartbleed, I had to re-add the EchoSign Cert to our keystore 
 (via the
 keytool) on all our servers. It worked as expected, and the connection 
 started working again. However, on one our webservers, it works, and 
 then later that day stops being able to connect and I get I/O 
 Exception: peer not authenticated when I try to CFHTTP to the HTTPS 
 address. If I restart the server, it works again, and then stops working
again later in the day.

 What the heck could cause that? My other webservers work without an issue.
 But this one seems to keep failing. The cert IS in the keystore...

 Any ideas?

 Brook





 



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358343
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


CFHTTP SSL Cert

2014-04-16 Thread Brook Davies

Hey Peeps,

After heartbleed, I had to re-add the EchoSign Cert to our keystore (via the
keytool) on all our servers. It worked as expected, and the connection
started working again. However, on one our webservers, it works, and then
later that day stops being able to connect and I get I/O Exception: peer
not authenticated when I try to CFHTTP to the HTTPS address. If I restart
the server, it works again, and then stops working again later in the day. 

What the heck could cause that? My other webservers work without an issue.
But this one seems to keep failing. The cert IS in the keystore...

Any ideas?

Brook 





~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358341
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: danger in increasing PostParameterLimit ?

2014-01-19 Thread Brook Davies

Umm - maybe it’s a big form??!

-Original Message-
From: Casey Dougall - Uber Website Solutions
[mailto:ca...@uberwebsitesolutions.com] 
Sent: January-19-14 5:07 PM
To: cf-talk
Subject: Re: danger in increasing PostParameterLimit ?


On Fri, Jan 17, 2014 at 10:52 AM, Chris 0404tow...@gmail.com wrote:

 How dangerous is increasing PostParameterLimit in CFv9 ?  We have 
 increased from the default 100 to 1,100 to meet applications' needs. 
 We are now requested to consider increasing it to 2,000.  The 
 developers are reviewing updating the design to use fewer PostParameters.


They should update the design to us XML or JSON for all those parameters. I
don't understand the need for all those post parameters where you could be
using json or xml in one parameter.



--
Casey Dougall
Über Website Solutions
(518) 633-1621
Saratoga Springs, NY
http://uberwebsitesolutions.com/




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:357483
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Simple SQL Query sometimes really Slow?

2013-12-05 Thread Brook Davies

This may not be the right place to post this (man, CF-TALK has changed a lot
in the last 5 or so years ;)).

 

I have a simple SQL query that is showing up as running slow. When I run it
via the Management Studio it is sometimes fast 0.1 seconds and sometimes,
seemingly randomly slow 1.5 minutes!). Other queries on other tables are
executing normally. This table only has 50k records and even a simple query
is sometimes really slow.

 

The query that runs slow is as simple as

 

select commitDate,id from databaseChangeLog 

where usr_id = 62622 and form_id = 312468 

and commitDate  '2013-12-04 11:00:05.0'

 

But is just as slow without the date part. The table has a clustered index
on the primary key (id) and a non-clustered index on usr_id,form_id and
commitDate. The index doesn't seem to make any difference.

 

My guess is the table is locked. My question is:

 

How can I determine if it is locked? What would be locking it. I checked all
my code and there are no CFTRANSACTIONS or ISOLATED READS or anything like
that. There are some inserts and the table has 2 TEXT columns which are
being updated at times with fairly large values. But the only queries
reported as slow are these simple SELECTS. The query execution plan uses the
non-clustered index on (usr_id,form_id and commitDate).

 

I'm just at a loss as to why this specific query is sometimes so slow..
where to look?

 

Brook




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:357289
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Simple SQL Query sometimes really Slow?

2013-12-05 Thread Brook Davies

Thank you everyone for all  your suggestions. Gonna start testing them out. 

Byron: I have this issue when running the query via management studio and
via cfquery so not sure if that is relevant..

Jon: I'm still running 2005 (if it ain't broke...), but was also thinking
about trying READ UNCOMMITTED (maybe that would have the same effect as your
suggestion?)

Mark: The select is only returning a couple of columns (date/int) and no
text.. I'll check the activity monitor.. the execution plan shows the index
usage and doesn't appear to account for the delays...

Jeff: Thanks for the Queries, I'll try them! 

Whohoo! Cftalk is alive!!

Brook

-Original Message-
From: Byron Mann [mailto:byronos...@gmail.com] 
Sent: December-05-13 10:22 AM
To: cf-talk
Subject: Re: Simple SQL Query sometimes really Slow?


Could never figure this out, but we had a similar issue on 2005 with a date
time column.

I remember we changed from a cfquery to a stored procedure and it was
resolved.

Byron Mann
Lead Engineer  Architect
HostMySite.com
On Dec 5, 2013 12:27 PM, Brook Davies cft...@logiforms.com wrote:


 This may not be the right place to post this (man, CF-TALK has changed 
 a lot in the last 5 or so years ;)).



 I have a simple SQL query that is showing up as running slow. When I 
 run it via the Management Studio it is sometimes fast 0.1 seconds and 
 sometimes, seemingly randomly slow 1.5 minutes!). Other queries on 
 other tables are executing normally. This table only has 50k records 
 and even a simple query is sometimes really slow.



 The query that runs slow is as simple as



 select commitDate,id from databaseChangeLog

 where usr_id = 62622 and form_id = 312468

 and commitDate  '2013-12-04 11:00:05.0'



 But is just as slow without the date part. The table has a clustered 
 index on the primary key (id) and a non-clustered index on 
 usr_id,form_id and commitDate. The index doesn't seem to make any
difference.



 My guess is the table is locked. My question is:



 How can I determine if it is locked? What would be locking it. I 
 checked all my code and there are no CFTRANSACTIONS or ISOLATED READS 
 or anything like that. There are some inserts and the table has 2 TEXT 
 columns which are being updated at times with fairly large values. But 
 the only queries reported as slow are these simple SELECTS. The query 
 execution plan uses the non-clustered index on (usr_id,form_id and 
 commitDate).



 I'm just at a loss as to why this specific query is sometimes so slow..
 where to look?



 Brook




 



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:357295
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


When I flatten an acroform, the radio buttons no longer show as checked.

2013-11-13 Thread Brook Davies

If I don't call flatten (CFPDFflatten=true), the PDF shows the radio
buttons selected, but as soon as I flatten the PDF, the radio buttons are
not shown as selected. Checkboxes work, text fields work, but radio buttons
just all show as unselected.

This is on CF 9,0,1,274733. Has anyone else seen this?

Any suggestions?

 




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:357067
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


JSON Encoding bug (again...)

2013-08-05 Thread Brook Davies

I have had to do so many hacks to get serializeJSON() to play nice. I add a
~ to all yes/no strings so I don't get back true/false values, I have a
series of regular expressions that quote values in the resulting JSON that
don't get quoted and break on the client side. And now I have this issue:

cfset x = {testval='.0006'}
cfdump var=#serializeJSON(x)#

Which outputs:

{TESTVAL:6.0E-4}

WTF?

 I am using CF 9,0,1,274733   
Update Level /C:/ColdFusion9/lib/updates/hf901-4.jar   

Anybody know of a workaround for this? The source data is in a query which
gets serialized after being converted to an array of structs. It would be
too slow to check each field for values like this and modify them to return
to the client. I need another Idea. Anyone?

Brook



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356382
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Getting lots of DB Errors: Transaction was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

2013-07-16 Thread Brook Davies

Hey Guys,

I am getting a lot of these errors today:

Transaction (Process ID 65) was deadlocked on lock | communication buffer
resources with another process and has been chosen as the deadlock victim.
Rerun the transaction.

On a system that is used to track 'views' of a page via an ajax request. All
of the errors are related to updating a specific table with a query like
this (this is not the CFML query..):

update formAnalytics_view 
set INLINESTART={ts '2013-07-16 10:04:21'} , 
INTERACTED=1 
where sessionid = '5BAC1158-D89E-4CB5-A8FB-1DC06D3E82A9'

The table has 4,925,131 rows and growing. It is has more writes than reads.
Is there something I can do to optimize this table to avoid these deadlock
errors? 

I had added a try/catch around the transactions that were causing these
deadlocks, and then I was re-running the failed transaction in the catch
segment, but it looks like the lock was not yet removed and this was just
leading to more errors. What is the best way to resolve this? Would adding a
thread.sleep() statement and then re-trying the transaction work or would
that just lead to more errors?

Note the queries should 9 times out of 10 be updating different rows of this
table. Should I add an index on the sessionID? Or would that make writes
slower?

Brook



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356191
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Getting lots of DB Errors: Transaction was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

2013-07-16 Thread Brook Davies

Thanks Jeff and Byron!

-Original Message-
From: Jeff Garza [mailto:j...@garzasixpack.com] 
Sent: July-16-13 10:38 AM
To: cf-talk
Subject: re: Getting lots of DB Errors: Transaction was deadlocked on lock |
communication buffer resources with another process and has been chosen as
the deadlock victim. Rerun the transaction.


Absolutely you should have an index on sessionID.  Without that index you
are forcing a table scan for that id so the engine can do the update.  When
your table was smaller, SQL could deal with that a lot easier.  Once you
start getting to 3-4 million rows, the performance starts to slow down on a 
flat table scan.   I have tables with 500 million rows and I can find a 
unique record using a clustered index scan in under a second...  
If you are only indexing the sessionID column you shouldn't see any major
performance hits on inserts and you should see dramatic performance
increases on your updates.
--Jeff

 Original Message 
 From: Brook Davies cft...@logiforms.com
 Sent: Tuesday, July 16, 2013 10:03 AM
 To: cf-talk cf-talk@houseoffusion.com
 Subject: Getting lots of DB Errors: Transaction was deadlocked on lock 
 |
communication buffer resources with another process and has been chosen as
the deadlock victim. Rerun the transaction.
 
 Hey Guys,
 
 I am getting a lot of these errors today:
 
 Transaction (Process ID 65) was deadlocked on lock | communication
buffer
 resources with another process and has been chosen as the deadlock
victim.
 Rerun the transaction.
 
 On a system that is used to track 'views' of a page via an ajax request. 
All
 of the errors are related to updating a specific table with a query 
 like this (this is not the CFML query..):
 
 update formAnalytics_view
 set INLINESTART={ts '2013-07-16 10:04:21'} ,
 INTERACTED=1
 where sessionid = '5BAC1158-D89E-4CB5-A8FB-1DC06D3E82A9'
 
 The table has 4,925,131 rows and growing. It is has more writes than
reads.
 Is there something I can do to optimize this table to avoid these
deadlock
 errors? 
 
 I had added a try/catch around the transactions that were causing 
 these deadlocks, and then I was re-running the failed transaction in 
 the catch segment, but it looks like the lock was not yet removed and 
 this was
just
 leading to more errors. What is the best way to resolve this? Would
adding a
 thread.sleep() statement and then re-trying the transaction work or
would
 that just lead to more errors?
 
 Note the queries should 9 times out of 10 be updating different rows 
 of
this
 table. Should I add an index on the sessionID? Or would that make 
 writes slower?
 
 Brook
 
 
 
 



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356194
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Memory consumption issue in CF 9

2013-07-09 Thread Brook Davies

You need to look at the threads that were running when your memory started
to spike. Or  look under the slow pages in fusion reactor and then look and
see what they are doing, what queries are executing (seems like a pretty
high number of JDBC requests per second) and how long they are taking. Or do
a stack trace of the hung threads to see where they are hung...

Brook

-Original Message-
From: Ben Conner [mailto:b...@webworldinc.com] 
Sent: July-09-13 5:23 PM
To: cf-talk
Subject: Memory consumption issue in CF 9


Hi,

I have a CF 9 server, version 9,0,0,251028 running on top of Java vsn
1.6.0_38.

Recently I've started having significant out-of-memory conditions that cause
the JVM to crash.  I have Fusion Reactor running on this machine and have
taken snapshots of the appropriate screens. Running a manual garbage collect
does not reduce the memory to a significant degree.

The graphs, along with the config parms passed to the JVM, are at:

http://www.webworldinc.com/cf9/

Suggestions on where to look for the root cause for this?

Thanks!

--Ben

-- 
Ben Conner  b...@webworldinc.com
Web World, Inc. 888-206-6486 or
PO Box 1122 480-704-2000
Queen Creek, AZ 85142





~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356151
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Geargian Dates??

2013-05-17 Thread Brook Davies

Hi Guys,

I am interfacing with a webservice and the dates returned are in Gregorian
format. For example I get back:

{ts '1582-10-04 16:00:00'}

How do you convert Gregorian dates into something CF can use and format?

Brook





~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355758
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: dragon dictation and CF

2013-03-22 Thread Brook Davies

Yeah, I ditched dragon too, what a waste of time. And their sales people
can't keep calling me every since...

-Original Message-
From: Mike Chabot [mailto:mcha...@gmail.com] 
Sent: March-22-13 2:44 PM
To: cf-talk
Subject: Re: dragon dictation and CF


That program takes a lot of training to be able to recognize your voice and
is frustrating to use during the learning period. Trying to program with
dictation software would result in a huge decrease in productivity compared
to a good keyboard with macro keys for all the common code, the benefit of
code-completion features within the IDE, and the use to two fully functional
hands. I think the technology is only suitable for programmers who cannot
use their hands and work at home or in an quiet office with a door that can
be closed. I didn't watch the video since it is 30min long. I assume the
presenter has a higher opinion of voice recognition software than I do. I
only spent a day using Dragon before giving up on it.

-Mike Chabot


On Fri, Mar 22, 2013 at 3:01 PM, Chad Gray cg...@careyweb.com wrote:


 Has anyone tried to use Dragon dictation software to write CF code?



 I saw this video and it got my brain going.

 https://www.youtube.com/watch?feature=player_embeddedv=8SkdfdXWYaI



 My fingers are developing some numbness and I need to be pro-active.



 Chad



 



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355138
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Flying Saucer instead of CFDocument

2013-03-05 Thread Brook Davies

I am looking at integrating Flying Saucer to replace CFDOCUMENT mostly to
add support for page-break-inside:avoid.

Anybody been down this road and have any advice before I get started?

Brook



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354816
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Localization , French Accents...

2013-02-28 Thread Brook Davies

Thanks Paul!

-Original Message-
From: Paul Hastings [mailto:p...@sustainablegis.com] 
Sent: February-27-13 5:31 PM
To: cf-talk
Subject: Re: Localization , French Accents...


On 2/28/2013 3:05 AM, Brook Davies wrote:

 Sorry, Unicode/utf-8 are the same thing...my mistake..

they're not the same thing. unicode is a *standard* (the unicode
consortium produces a book the unicode standard). utf-8 (UCS
Transformation Format 8 bit) is one *encoding* implementing that standard,
there are others.







~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354737
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Localization , French Accents...

2013-02-27 Thread Brook Davies

I am trying to read in a number of text files that contain translations
(using French in this example) and store them in my applications app scope.
The file I am reading in looks like this:
http://screencast.com/t/DZTv3iVrbyo

When I dump the results from reading in the file, or try to use them in
output, the accents get munged:
http://screencast.com/t/aoRcLWWHn

I have tried everything I can think of to get this to work and everything
has failed. I have tried manually setting the charset on the CFFILE tag and
that has not helped. I tried using  UTF-8, and WINDOWS-1255.

Since I have numerous language files I have even tried implementing this
java class org.mozilla.universalchardet.UniversalDetector that detects the
encoding of a file, and then using the detected encoding when reading in the
translation files. But no matter what I do, the encoding is not preserved.
Note, this library tells me my French files are WINDOWS-1255./

Does anyone have any suggestions on how I can handle this? 

Brook



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354707
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Localization , French Accents...

2013-02-27 Thread Brook Davies

Should I be saving it in Unicode or UTF-8?

-Original Message-
From: Bobby [mailto:bo...@acoderslife.com] 
Sent: February-27-13 11:01 AM
To: cf-talk
Subject: Re: Localization , French Accents...


My first guess is that it is happening when the file is read in. Was it
saved as unicode? I think notepad lets you do that. If not, notepad++ does.


On 2/27/13 12:52 PM, Brook Davies cft...@logiforms.com wrote:


I am trying to read in a number of text files that contain translations 
(using French in this example) and store them in my applications app 
scope.
The file I am reading in looks like this:
http://screencast.com/t/DZTv3iVrbyo

When I dump the results from reading in the file, or try to use them in 
output, the accents get munged:
http://screencast.com/t/aoRcLWWHn

I have tried everything I can think of to get this to work and 
everything has failed. I have tried manually setting the charset on the 
CFFILE tag and that has not helped. I tried using  UTF-8, and 
WINDOWS-1255.

Since I have numerous language files I have even tried implementing 
this java class org.mozilla.universalchardet.UniversalDetector that 
detects the encoding of a file, and then using the detected encoding 
when reading in the translation files. But no matter what I do, the 
encoding is not preserved.
Note, this library tells me my French files are WINDOWS-1255./

Does anyone have any suggestions on how I can handle this?

Brook







~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354714
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Localization , French Accents...

2013-02-27 Thread Brook Davies

Sorry, Unicode/utf-8 are the same thing...my mistake..

-Original Message-
From: Bobby [mailto:bo...@acoderslife.com] 
Sent: February-27-13 11:01 AM
To: cf-talk
Subject: Re: Localization , French Accents...


My first guess is that it is happening when the file is read in. Was it
saved as unicode? I think notepad lets you do that. If not, notepad++ does.


On 2/27/13 12:52 PM, Brook Davies cft...@logiforms.com wrote:


I am trying to read in a number of text files that contain translations 
(using French in this example) and store them in my applications app 
scope.
The file I am reading in looks like this:
http://screencast.com/t/DZTv3iVrbyo

When I dump the results from reading in the file, or try to use them in 
output, the accents get munged:
http://screencast.com/t/aoRcLWWHn

I have tried everything I can think of to get this to work and 
everything has failed. I have tried manually setting the charset on the 
CFFILE tag and that has not helped. I tried using  UTF-8, and 
WINDOWS-1255.

Since I have numerous language files I have even tried implementing 
this java class org.mozilla.universalchardet.UniversalDetector that 
detects the encoding of a file, and then using the detected encoding 
when reading in the translation files. But no matter what I do, the 
encoding is not preserved.
Note, this library tells me my French files are WINDOWS-1255./

Does anyone have any suggestions on how I can handle this?

Brook







~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354716
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Localization , French Accents...

2013-02-27 Thread Brook Davies

Bobby, thanks for the notepad+ idea - it was the encoding on the source
file

-Original Message-
From: Bobby [mailto:bo...@acoderslife.com] 
Sent: February-27-13 12:05 PM
To: cf-talk
Subject: Re: Localization , French Accents...


UTF-8 should do it.

On 2/27/13 3:00 PM, Brook Davies cft...@logiforms.com wrote:


Should I be saving it in Unicode or UTF-8?

-Original Message-
From: Bobby [mailto:bo...@acoderslife.com]
Sent: February-27-13 11:01 AM
To: cf-talk
Subject: Re: Localization , French Accents...


My first guess is that it is happening when the file is read in. Was it 
saved as unicode? I think notepad lets you do that. If not, notepad++ 
does.


On 2/27/13 12:52 PM, Brook Davies cft...@logiforms.com wrote:


I am trying to read in a number of text files that contain 
translations (using French in this example) and store them in my 
applications app scope.
The file I am reading in looks like this:
http://screencast.com/t/DZTv3iVrbyo

When I dump the results from reading in the file, or try to use them 
in output, the accents get munged:
http://screencast.com/t/aoRcLWWHn

I have tried everything I can think of to get this to work and 
everything has failed. I have tried manually setting the charset on 
the CFFILE tag and that has not helped. I tried using  UTF-8, and 
WINDOWS-1255.

Since I have numerous language files I have even tried implementing 
this java class org.mozilla.universalchardet.UniversalDetector that 
detects the encoding of a file, and then using the detected encoding 
when reading in the translation files. But no matter what I do, the 
encoding is not preserved.
Note, this library tells me my French files are WINDOWS-1255./

Does anyone have any suggestions on how I can handle this?

Brook











~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354721
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Email attachment problem

2013-01-04 Thread Brook Davies

Don't use CFsleep to sleep for 15 minutes unless you want to tie up a thread
for 15 minutes doing nothing. Depending on the max requests/threads
settings, you could stall/crash the server just by reloading that page 10+
times...

Brook

-Original Message-
From: Robert Harrison [mailto:rob...@austin-williams.com] 
Sent: January-04-13 11:34 AM
To: cf-talk
Subject: RE: Email attachment problem


Use a delay between sending the file and deleting it, like CFSleep. The file
is being deleted too quickly. I usually give it about 15 minutes. 


Robert Harrison
Director of Interactive Services

Austin  Williams
Advertising I Branding I Digital I Direct
125 Kennedy Drive,  Suite 100   I  Hauppauge, NY 11788 T 631.231.6600 X 119
  F 631.434.7022 http://www.austin-williams.com

Blog:  http://www.austin-williams.com/blog
Twitter:  http://www.twitter.com/austin_williams 


-Original Message-
From: Rob Voyle [mailto:robvo...@voyle.com]
Sent: Friday, January 04, 2013 1:27 PM
To: cf-talk
Subject: Email attachment problem


Hi folks

I have an online classroom that enables participants to email each other
including sending attachments.
The attachments are uploaded to a private temporay directory and then
attached to the email.
After the email is sent i want to delete the file from the temp directory.
If the file is large (several mb) and the list is large the delete function
interferes with the cfmail program, by deleting the file before all the
email is processed.

Is there a way to tell when the email is sent to automatically delete the
temporary file and/or is there a way to set up routine that would
automatically delete the temp directory every day.

Thanks
Rob 







~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353783
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


UTF-8 encoding when writing to a PDF

2012-09-27 Thread Brook Davies

I am totally stuck on this one. I am using an old Ben Forta tag cf_pdfform.
I’m still using it because it makes writing to a PDF form and populating
fields easier than using the native cfpdf form population methods.

The problem is that any strings with UTF-8 characters get truncated at the
first character.

The method basically takes an XMl string of form data and the PDF form/file
and returns the populated PDF document (in this case in bytes). The XML I am
testing with looks good:

?xml version=1.0 encoding=UTF-8? xfdffieldsfield
name=activitiesvalueGrave accent (à, è, ù): Over a or u, used primarily
to distinguish homophones: à (to) vs. a (has), ou (or) vs1. où
(where, note that ù exists1 only in this word). Over an e, 1indicates the
sound/value/field/fields/xfdf

// PDF form input stream
formIS=CreateObject(java, java.io.FileInputStream);
formIS.init(ARGUMENTS.PDFForm);

// Get PDF document object
PDFfactory=server.javaLoader.create(com.adobe.pdf.PDFFactory);
PDFdoc=PDFfactory.openDocument(formIS);

// Convert raw XML data to byte array
bytes=ARGUMENTS.XMLData.getBytes(UTF-8);
byteArrayIS=CreateObject(java, java.io.ByteArrayInputStream);
byteArrayIS.init(bytes);

// Perform actual import
PDFdoc.importFormData(byteArrayIS);

//Call the PDFDocument object's save method
outputIS=PDFdoc.save();

// Read bytes
byteClass=CreateObject(java, java.lang.Byte).TYPE;
PDFBytes=CreateObject(java,
java.lang.reflect.Array).newInstance(byteClass, outputIS.available());

// And store them
outputIS.read(PDFBytes);

But when I executed the code below and then write the bytes via CFILE
CHARSET=”UTF-8”, the form field data is truncated in the resulting PDF.
Anybody have any ideas?

Brook



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:352781
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Any reason a cfhttp post can't be made in a component method?

2012-09-25 Thread Brook Davies

Hi Rick,

There is no reason why this should not work via the CFC method or even via
the direct ajax method. Some gateways however restrict access to approved
IPs, so the ajax method, originating from the end user IP may not work
directly, which is why you probably want to route it through a CFC. The CFC
method is the best option anyways, because otherwise you would need to do 2
ajax requests to talk to Authorize and then send the results to your server.
You should just call a CFC (via ajax), your CFC should post to Auth.net and
then return record the result and return to the client.

If your transactions are getting approved via your CFHTTP post, then you
should be getting a result. What do you see when you dump the
cfhttp.fileContent result?

I have some authorize.net code you can look at that uses CFHTTP, just email
me off list and I'll send it to you. Its nothing special though.. just a
CFHTTP post and some list parsing code to parse the result...

Brook

-Original Message-
From: Rick Faircloth [mailto:r...@whitestonemedia.com] 
Sent: September-25-12 8:34 AM
To: cf-talk
Subject: RE: Any reason a cfhttp post can't be made in a component method?


Ok... next question.

Can a jQuery ajax function be used to send post variables to a component
method and have a cfhttp function post those variables to another domain, in
this case, https://test.authorize.net/gateway/transact.dll ???

I'm at my wits end trying to process form data into two parts.
The data fields that can go to authorize.net and the parts that need to stay
with me and go into my database. Authorize.net forbids personally
identifiable info from going into the merchant-defined fields.

Ergo, I need to post some of the form data to Authorize.net and if a
transaction is approved, post some of that info (not CC numbers, etc) to my
database, along with other info not pertinent to the transaction, such as
in honor of etc.

The easiest way I thought to do this was to use AJAX and submit some of the
data that way (I couldn't get a straight jQuery AJAX post to work...couldn't
get a response from the Authorize.net server, although the transaction was
successful) and I haven't been successful getting the form values with
jQuery AJAX and posting them to Authorize.net by send the form values via
AJAX to a CFC method, which utilizes CFHTTP for the post.  No response from
the Authorize.net server.

If you know this will work, Ray, how much would it cost you to guide me
through a solution. I have a patient client, but this needs to get done.
I'm at the point now where I'm either considering going to session variables
or just putting all the post variables into a temp table in a database, then
processing the transaction, and, if successful, putting the transaction data
into a permanent table.

I just can't seem to work up a solution from everything I've read (which is
all I could find) and everyone that would discuss this with me, including
calling Authorize.net, who said we don't support developers...

Can it be done? Can you do it? If so, how much to guide me through it?

Still have my hair, but not for long!

Rick


-Original Message-
From: Raymond Camden [mailto:raymondcam...@gmail.com]
Sent: Tuesday, September 25, 2012 10:54 AM
To: cf-talk
Subject: Re: Any reason a cfhttp post can't be made in a component method?


Nope.

On Tue, Sep 25, 2012 at 7:15 AM, Rick Faircloth
r...@whitestonemedia.com wrote:

 Can anyone think of a reason that a cfhttp post can't be
 made within a component method?

 Rick







~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:352746
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: CF Long Text Truncation

2012-07-17 Thread Brook Davies

Don't forget you need the Enable long text retrieval (CLOB). checkbox
checked within the cfadmin  datasource settings.

(its under advanced settings...)

Brook

-Original Message-
From: DURETTE, STEVEN J [mailto:sd1...@att.com] 
Sent: July-17-12 8:35 AM
To: cf-talk
Subject: RE: CF Long Text Truncation


Don't know if this will help but try looking at this:
http://cutesoft.net/forums/thread/42292.aspx

It's for IIS7 but it was quickly googled, so it may be a start.

Before going that way though I would test. Submit one of these long posts to
a test page and determine if what you sent is what got through. If its not
then look at IIS.

Steve


-Original Message-
From: Robert Harrison [mailto:rob...@austin-williams.com] 
Sent: Tuesday, July 17, 2012 11:14 AM
To: cf-talk
Subject: RE: CF Long Text Truncation


 are you sure that all the data is getting to your query ... are you
hitting the HTML Post limit

Where is this setting?  Is this an IIS setting or something?

Robert Harrison 
Director of Interactive Services

Austin  Williams
Advertising I Branding I Digital I Direct  
125 Kennedy Drive,  Suite 100   I  Hauppauge, NY 11788
T 631.231.6600 X 119   F 631.434.7022   
http://www.austin-williams.com

Blog:  http://www.austin-williams.com/blog
Twitter:  http://www.twitter.com/austin_





~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351917
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Urgent: Server queues all requests for one loop

2012-06-13 Thread Brook Davies

I have a jar file with a couple of methods that do decryption that I am
calling in a loop. The loop is big, 6000 iterations and while its running
the server is basically brought to a grinding halt and other requests start
to queue and/or execute very slowly.

The cpu is at 40% or so, memory usage does not spike.

How does one thread cause the entire server to grind to a halt? 

The funny thing is, If I add a thread.sleep(10) in between each iteration
then the server is able to serve other requests fairly quickly and nothing
queues.

This code does not cause the server to queue all other requests because of
the thread.sleep(), without it, this loop takes over and everything else
queues (or completes very slowly):

cfset thread = CreateObject(java, java.lang.Thread)

cfloop from=1 to=6000 index=i

  !--- adding this sleep command, saves the day and allows processing
to continue ---
cfset thread.sleep(10)

cfinvoke
component=#application.util.RSACrypt#
method=decrypt
inputCollection=#encryptedData#
key=#private_key#
returnvariable=encryptedData
/cfloop

This is the method that is being called:

/**
  * Decodes a string encoded using its corresponding private key.
This must be done manually due to the unusual padding and
  * byte ordering involved.
  * @param encryptedString the encrypted string, in aec/TRSA's
version of RSA, in aec's version of base-64 encoding.
  * @param aecPrivateKey the corresponding private key, in
aec/TRSA's version of base-64 encoding.
  * @return a String representing the original plaintext message.
  */
public static String aecDecrypt(String encryptedString, String
aecPrivateKey) {
RSAPrivateKeySpec privKeySpec =
AECKeyToPrivateKeySpec(aecPrivateKey);
BigInteger d = privKeySpec.getPrivateExponent();
BigInteger n = privKeySpec.getModulus();
 
byte[] src = unpackAECEncodedBase64(encryptedString); //
this is where the time is spent..
BigInteger c = new BigInteger(1,src);

BigInteger m = c.modPow(d,n);

byte[] decrypted = m.toByteArray();
for(int i=0; idecrypted.length/2; i+=1) {
byte a = decrypted[decrypted.length-i-1];
byte b = decrypted[i];
decrypted[decrypted.length-i-1] = b;
decrypted[i] = a;
}

int padBytes = decrypted[decrypted.length-1];
String dest = ;
for(int i=0; i(64-padBytes-1); i++)
dest+=(char)decrypted[i];
d.finalize(); //just to be helpful...
return dest;
}



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351563
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Calling custom Java class in a loop kills the server

2012-06-07 Thread Brook Davies

I think I found out what was killing my server the other day. We used to use
an encryption CFX called textCrypt, actually we've been using it for years
and years, but it stopped working on our new CF9 64bit server. 

 

So we  hired a Java developer to write a java class that would handle
decrypting strings using the existing private keys generated with this CFX
(aec/TRSA.). The new java class seems to work pretty good, but when called
in a loop, ohh, 6000 times, it is really slow and the entire server
basically seems to stop and wait for it to finish before serving other
threads. I don't understand why this is the case..

 

We're calling the method below aecDecrypt() to decrypt each string (6000
times.) and its killing our server and taking too long to finish processing.
I don't know Java, does anyone see a way that this could be improved? One
thing I notice is that each time its called it takes the private key
provided and calls AECKeyToPrivateKeySpec() to convert the private key to
the format needed. I guess this really only needs to be called once each
time.

 

If anyone thinks they can help me with this I am willing to pay some one to
help me optimize this before I setup a new server specifically for
decryption so that it doesn't bring my webserver to its knees. I still don't
understand why that happens though.

 

 

/**

  * Decodes a string encoded using its corresponding private
key. This must be done manually due to the unusual padding and

  * byte ordering involved.

  * @param encryptedString the encrypted string, in
aec/TRSA's version of RSA, in aec's version of base-64 encoding.

  * @param aecPrivateKey the corresponding private key, in
aec/TRSA's version of base-64 encoding.

  * @return a String representing the original plaintext
message.

  */

public static String aecDecrypt(String encryptedString,
String aecPrivateKey) {

RSAPrivateKeySpec privKeySpec =
AECKeyToPrivateKeySpec(aecPrivateKey);

BigInteger d =
privKeySpec.getPrivateExponent();

BigInteger n = privKeySpec.getModulus();

 

byte[] src =
unpackAECEncodedBase64(encryptedString);

BigInteger c = new BigInteger(1,src);



BigInteger m = c.modPow(d,n);



byte[] decrypted = m.toByteArray();

for(int i=0; idecrypted.length/2; i+=1) {

byte a =
decrypted[decrypted.length-i-1];

byte b = decrypted[i];

 
decrypted[decrypted.length-i-1] = b;

decrypted[i] = a;

}



int padBytes =
decrypted[decrypted.length-1];

String dest = ;

for(int i=0; i(64-padBytes-1); i++)
dest+=(char)decrypted[i];

d.finalize(); //just to be helpful...

return dest;

}

  ,

 

 

/**

* Creates an RSAPrivateKeySpec object based on a private key
generated with the aecRSA library (such as TextCrypt).

* @param aecPrivateKeyA base64-encoded string in
the aecRSA format

* @return
an RSAPrivateKeySpec object representing the same 'n' and 'd' values. If the
key is invalid, returns null.

*/

public static RSAPrivateKeySpec
AECKeyToPrivateKeySpec(String aecPrivateKey) {

String[] pieces = aecPrivateKey.split(:);

if (pieces.length2) {

return null;

}



String nString =
unpackWeirdMPInt(pieces[0]);

while(nString.endsWith(?)) nString =
nString.substring(0,nString.length()-1);

String dString =
unpackWeirdMPInt(pieces[1]);

while(dString.endsWith(?)) dString =
dString.substring(0,dString.length()-1);





BigInteger n = new
BigInteger(1,unpackHexString(nString));

BigInteger d = new
BigInteger(1,unpackHexString(dString));



//BigInteger d = new BigInteger(dString,16);

//BigInteger n = new 

CF 9 Server restart

2012-06-04 Thread Brook Davies

Hey guys,

 

My Brand new CF9 Server (64 bit), for a site I just launched on Friday
restarted itself 3 times in a row this morning while logging only:

 

Potentially fatal error in generated byte array length: 63

AWT blocker activation interrupted:06/04 05:55:59 user CFInternalServlet:
destroy

 

1)

 

java.lang.InterruptedException

at java.lang.Object.wait(Native Method)

at java.lang.Object.wait(Object.java:485)

at
sun.awt.AWTAutoShutdown.activateBlockerThread(AWTAutoShutdown.java:315)

at
sun.awt.AWTAutoShutdown.setToolkitBusy(AWTAutoShutdown.java:232)

at
sun.awt.AWTAutoShutdown.notifyToolkitThreadBusy(AWTAutoShutdown.java:118)

at sun.awt.windows.WToolkit.eventLoop(Native Method)

at sun.awt.windows.WToolkit.run(WToolkit.java:293)

at java.lang.Thread.run(Thread.java:662)

06/04 05:55:59 Information [Thread-1] - Stopping Event Gateways.

 

2)

 

Potentially fatal error in generated byte array length: 63

06/04 05:56:36 user CFInternalServlet: destroy

 

3)

 

Potentially fatal error in generated byte array length: 63

06/04 05:58:25 user CFInternalServlet: destroy

 

Anyone seen this error before?

 

Brook




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351437
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


CFC returns escaped strings.. grrrr

2012-06-03 Thread Brook Davies

I am trying to do some jsonP stuff and call a CFC directly. The problem is
the CFC doesn't return the correctly formatted string. I want to return a
string from the remote CFC call but it quotes the string and escapes the
quotes. I return:

jsonp_fa({RESULT:ok})

And I get:

jsonp_fa({\RESULT\:\ok\})

My CFC method is set to return a string with no formatting, so why does it
escape the string???!!

cffunction name=record access=remote returntype=string
returnformat=plain output=true


Brook



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351422
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: CFC returns escaped strings.. grrrr

2012-06-03 Thread Brook Davies

omg! - your right!!! Thank you  - I don't know how I missed that! 

Brook

-Original Message-
From: Raymond Camden [mailto:raymondcam...@gmail.com] 
Sent: June-03-12 11:59 AM
To: cf-talk
Subject: Re: CFC returns escaped strings.. g


When you call it, are you adding returnformat=json in the url? It will
override the returnformat in your function call.

On Sun, Jun 3, 2012 at 1:31 PM, Brook Davies cft...@logiforms.com wrote:

 I am trying to do some jsonP stuff and call a CFC directly. The 
 problem is the CFC doesn't return the correctly formatted string. I 
 want to return a string from the remote CFC call but it quotes the 
 string and escapes the quotes. I return:

 jsonp_fa({RESULT:ok})

 And I get:

 jsonp_fa({\RESULT\:\ok\})

 My CFC method is set to return a string with no formatting, so why 
 does it escape the string???!!

 cffunction name=record access=remote returntype=string
 returnformat=plain output=true


 Brook



 



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351424
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


ZenDesk Rest API

2012-05-28 Thread Brook Davies

Hello,

 

Has any one done any integration with ZenDesks API that they care to share?
I am just looking for the basics, actually, I would be happy with an example
of how to 'create' a ticket from a web form submission and then I think I
can figure the rest out from there..

 

Anyways, thought I would check here before I dive in (nothing on
riaForge..).

 

Brook

 




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351338
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Application Scoped CFC's and the Request Scope

2012-05-01 Thread Brook Davies

Hey Guys,

 

While I know its not best practice, I am setting some variables in the
request scope that are then referenced by several application scoped CFCs.
Can  this lead to collisions? I am seeing some strange errors that only
happen when I run multiple requests at the same time and seem to involve the
request scoped data. Could this potentially be the issue?

 

Brook




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350929
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Somewhat OT....Making us look bad...For the adobe engineers on the list..

2012-04-27 Thread Brook Davies

Maybe Adobe Support also had a hard time 'understanding' what you were
trying to tell them. I do some support, and if the customer doesn't provide
the right information, it can be difficult to provide a good response. I'm
not saying that's what happened, but look how easily it can happen as it did
here.

Brook

-Original Message-
From: Eric Roberts [mailto:ow...@threeravensconsulting.com] 
Sent: April-27-12 12:44 PM
To: cf-talk
Subject: Re: Somewhat OTMaking us look bad...For the adobe engineers on
the list..


Oops... meant 8...yes...I am so used to saying CF9, it just comes naturally
:-D.  Sorry for the confusion...

On Fri, Apr 27, 2012 at 2:06 PM, Wil Genovese jugg...@trunkful.com wrote:


 ColdFusion 9.0.x not ColdFusion 8.0.x  What you are describing was 
 true for ColdFusion 8.0.x.  When ColdFusion 9.0.x was released ALL 
 editions were 64bit.

 Read this product Matrix

 http://www.adobe.com/products/coldfusion-family/buying-guide.html

  All ColdFusion 9 editions can run as 64-bit applications on the 
 64-bit versions of Microsoft Windows, Sun Solaris, Linux, and Mac OS. 
 For detailed information about supported platforms

 http://www.adobe.com/products/coldfusion-standard/faq.html

 Wil Genovese
 Sr. Web Application Developer/
 Systems Administrator
 CF Webtools
 www.cfwebtools.com

 wilg...@trunkful.com
 www.trunkful.com

  On Apr 27, 2012, at 1:59 PM, Eric Roberts wrote:

 
  Not according to the website. It is compatable with 64 bit, but it 
  is not
  64 bit.  If you download a 64 bit version and enter in a standard
 password,
  it will not accept it.
 
 
 
  On Fri, Apr 27, 2012 at 1:57 PM, Wil Genovese jugg...@trunkful.com
 wrote:
 
 
  ColdFusion 9/9.0.1 IS 64 bit for Standard AND Enterprise.
 
 
 
 
  Wil Genovese
  Sr. Web Application Developer/
  Systems Administrator
  CF Webtools
  www.cfwebtools.com
 
  wilg...@trunkful.com
  www.trunkful.com
 
  On Apr 27, 2012, at 1:54 PM, Eric Roberts wrote:
 
 
  Standard doesn't have a 64 bit vesion...it is only Enterprise that
 does.
  Standard is 32 bit only.
 
  On Fri, Apr 27, 2012 at 1:46 PM, Kris Jones 
  kris.jon...@verizon.net
  wrote:
 
 
  Wow. That's pretty tough. I didn't know that was required when 
  installing 64-bit version of CF.
 
  -KJ
 
 
  On Fri, Apr 27, 2012 at 2:40 PM, Eric Roberts 
  ow...@threeravensconsulting.com wrote:
 
  Why doesn't support seem to know to tell a customer, when they 
  are installing CF9 standard on a 64 bit box that they need to go 
  into the
  IIS
  application pool setting and enable 32 bit apps?  I am doing a 
  gig
 for
  a
  client that could get CF( installed and that was all it was).  
  That
  should
  have been a quick fix.  While i glad for the business, I just 
  think
  this
  makes us as a community look bad when Adobe's support is that
  incompetent.
  I have a stack of emails going back and forth about an inch 
  thick and
  not
  one mentioned.  My client got a CF app dumped in their lap and 
  they
  didn't
  have any CF resources.  Sorry for the rant, but since I know we 
  have
  some
  Adobe folks here...I thought this would be as good as a spot as any.
  This
  is a HUGE company that could potentially get impressed by CF and
  create a
  lot of CF jobs.  I won't name them, but i can tell you that 
  probably everyone on this list has consumed their 
  products...some on a regular basis.  This is how companies get 
  turned off of products.  This could
  have
  been a big win on Adobe's part.  Way to drop the ball.  Some 
  days I
  think
  Adobe purposely tries to sabotage their own product. Adobe
 folks...feel
  free to pass this on to the appropriate people.
 
 
  back to your regularly scheduled topics...
 
  Eric
 
 
 
 
 
 
 
 
 
 

 



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350871
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: FusionReactor - Development server

2012-04-15 Thread Brook Davies

No, you have to buy a separate license for your dev server. I know this
because I just went through this process. They did offer me a bit of a
discount on the dev server license when I asked really nicely and said
please.

Brook

-Original Message-
From: Bobby [mailto:bo...@acoderslife.com] 
Sent: April-14-12 7:39 AM
To: cf-talk
Subject: Re: FusionReactor - Development server


I saw that but it doesn't mention development. Their license does talk about
a development license but doesn't talk about cost in the license.

You ever have one of those dreams that seems s real? Apparently I have
:-)



On 4/14/12 10:23 AM, andy matthews li...@commadelimited.com wrote:


Looks like you might have been dreaming:

http://www.fusion-reactor.com/fr/faq.cfm#licencing1

Each physical or virtual server requires one FusionReactor license - 
all of the instances which are installed on that server are covered by 
the one FusionReactor license. So, if you have (say) 6 physical boxes, 
then you need
6 licenses. Note, that on a single box you may have multiple instances 
(ColdFusion, JRun, Tomcat, JBoss) installed on it, but you still only 
need 1 license for that (virtual or physical) server. Virtual Machines 
(VM's) are also classed as separate physical servers and therefore 
require a license.


andy

-Original Message-
From: Bobby [mailto:bo...@acoderslife.com]
Sent: Saturday, April 14, 2012 8:31 AM
To: cf-talk
Subject: FusionReactor - Development server


I figured if anyone knew the answer to this (outside of FR Support), it 
would be someone on this listC

I may have dreamed this because I can't find it again but I thought I 
read that if you bought a FusionReactor enterprise license, you were 
also allowed to install a second copy on a development server at no 
extra cost.

Does anyone know whether or not that is true?

Thanks











~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350704
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: RSACrypt.cfc help

2012-03-26 Thread Brook Davies

Hi Jen,

Are the keys generated via the Bounce Castle API? They should be in order to
be used with this CFC.

Brook

-Original Message-
From: Jen McVicker [mailto:snarkmeis...@gmail.com] 
Sent: March-26-12 11:00 AM
To: cf-talk
Subject: RSACrypt.cfc help


I'm getting an error trying to decrypt a string with RSACrypt.cfc.  The
error is:

 

javax.crypto.BadPaddingException: blocktype mismatch 

 

Has anyone else come across this and found a solution?  My google-fu is
failing me.it looks like perhaps one of the strings (either the private key
or the encrypted string) needs to be padded to reach a certain length, but
I'm not sure how to determine which string needs to be padded, how much
padding is required, and how that needs to be done.

 

Please note: RSACrypt is decrypting just fine for other private
key/encrypted string pairs.  It is only *some* that are failing, so it's
likely not a coding error in the CFC or in the java crypto lib.

 

Thanks bunches for any help you can provide.

 

Jen Perkins McVicker

Adobe Certified ColdFusion Developer

 mailto:jen.mcvic...@gmail.com jen.mcvic...@gmail.com

Phone/Fax: 925.757.1839

Mobile: 925.759-3321

 http://www.linkedin.com/in/jmcvicker http://www.linkedin.com/in/jmcvicker

 





~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350549
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Browser and OS detection with CF

2012-03-19 Thread Brook Davies

Does anyone know of a good script to detect the browser and OS (including
versions) with CF? So far I have found BrowserDetect UDF
(http://www.cflib.org/udf/browserDetect) which looks good, but I would also
like to record the OS and Screen Resolution. Are these things better suited
to JS?

 

Brook




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350475
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Browser and OS detection with CF

2012-03-19 Thread Brook Davies

I guess there is some benefit to using a 3rd party paid tool like
browserHawk since they keep it up to date. I'll take another look at it...

Brook

-Original Message-
From: Cameron Childress [mailto:camer...@gmail.com] 
Sent: March-19-12 11:10 AM
To: cf-talk
Subject: Re: Browser and OS detection with CF


On Mon, Mar 19, 2012 at 1:00 PM, Russ Michaels r...@michaels.me.uk wrote:

 http://www.cyscape.com/

 used to be written in CF, dunno if it still is.


I haven't used it in years, but BrowserHawk is kept up to date and is a
great solution for this work of thing.  If you want things like screen
resolution, you're going to have to pick something that runs on the client
side, not the server side.  No amount of looking at CGI variables is going
to get you that information.

-Cameron

--
Cameron Childress
--
p:   678.637.5072
im: cameroncf
facebook http://www.facebook.com/cameroncf |
twitterhttp://twitter.com/cameronc |
google+ https://profiles.google.com/u/0/117829379451708140985






~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350482
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Migrate back and forth between cf7 and cf8 on IIS

2012-03-09 Thread Brook Davies

Just set the ISAPI paths at the website level for the CF7 site to point to
your CF7 install directory (specifically at the jrun dll's)..

Brook

-Original Message-
From: daniel kessler [mailto:dani...@umd.edu] 
Sent: March-09-12 8:55 AM
To: cf-talk
Subject: Re: Migrate back and forth between cf7 and cf8 on IIS


What services are running?
On Mar 9, 2012 11:47 AM, daniel kessler dani...@umd.edu wrote:

In going through my web site configuration - application configuration, I
see a bunch of paths that go through ColdFusion8 and end with jrun.dll.
Could this be the problem?

Will I need to delete these and import the cf7 ones each time I switch?  oy.




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350319
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Migrate back and forth between cf7 and cf8 on IIS

2012-03-09 Thread Brook Davies

Hey Daniel,

If you set it at the site level then you should be able to have different
settings for each website. Not sure if you would need a bat file to the
changes. But you could probably script it by using the connectors that CF
comes with (c:\coldfusion7\bin\connectors\IIS_connector.bat) or using some
of the code in  those bat files and specifying the correct site ID. 

Note, there are also cfstart.bat and cfstop.bat you could script the whole
thing...

Brook


-Original Message-
From: daniel kessler [mailto:dani...@umd.edu] 
Sent: March-09-12 9:21 AM
To: cf-talk
Subject: Re: Migrate back and forth between cf7 and cf8 on IIS


Just set the ISAPI paths at the website level for the CF7 site to point 
to your CF7 install directory (specifically at the jrun dll's)..


ok, that worked.  Thank you very much.

Is that the sort of thing that can be adjusted using a .bat file?  I don't
know much about them.  However, I'm trying to make switching between these
two environments as easy as possible.

I appreciate the assistance everyone.

daniel 



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350332
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


JSON Encoding Bug

2012-03-04 Thread Brook Davies

I just want to say I think that it is seriously lame that Adobe has not
fixed the encoding issues with serializeJSON() converting 'yes' / 'no' to
true/false. Yes, you can append as string and then convert it back
afterwards and all that, but that's just adding extra processing overhead
and hoakiness(?), and this bug has been around for so long - its now
officially annoying. 

 

Sorry, I know, I'm just ranting.

 

Brook

 




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350229
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Zen Desk Single Sign On

2012-03-02 Thread Brook Davies

Just about to work on getting the Single Sign on for ZenDesk working this
weekend. Before I start I thought I would check if any one had already done
it and had any code they wanted to share?

 

Brook




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350217
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Zen Desk Single Sign On

2012-03-02 Thread Brook Davies

Well, it was super easy to implement! 

I just created a page on my server called zendesk_auth.cfm. Zendesk sends
login requests here and I send back a response after logging the user in, or
if the user is already logged in.  In my code, if a user is not logged in I
redirect to a login page which sends them back to zendesk after
authentication (you have to pass around the timestamp and return_to values
to send back). This is basically the code I used, I didn't include my login
page and login check, but that's pretty simple...

!---
zendesk_auth.lf

Description:
Called from zendesk when a user attempts to log in at zendesk.
Check if the user is already logged in here and send that info to
zendesk
or show the login page (zendesk themed) and let them log in here and
redirect
to zendesk

 Parameters:
  @param {String} url.return_to  The url to return to
  @param {Number} url.locale_id
  @param {Number} url.timestamp
---

cfparam name=url.timestamp   default=
cfparam name=url.return_to   default=

cfset sToken= application.gs.zendesk_sharedsecret !--- you get
this from zendesk ---
cfset sUrl  = ''
cfset sMessage = ''
cfset sDigest  = ''

!--- user is logged in send back to zendesk ---
cfif structKeyExists(client,'isLoggedIn')
!--- create auth string and send back to zen desk ---
cfset sMessage = client.name  client.username  sToken 
url.timestamp
cfset sDigest  = hash(sMessage)

!--- and the url ---
cfset sUrl = url.return_to  '?name=' 
urlencodedformat(client.name) 
'email='  urlencodedformat(client.username) 
'timestamp='  url.timestamp 
'hash='  sDigest

!--- redirect back to ZenDesk ---
cflocation url=#sUrl#
/cfif

!--- not logged in, show login screen ---
cfinclude template=zendesk_login.lf


-Original Message-
From: Brook Davies [mailto:br...@logiforms.com] 
Sent: March-02-12 3:35 PM
To: cf-talk
Subject: Zen Desk Single Sign On


Just about to work on getting the Single Sign on for ZenDesk working this
weekend. Before I start I thought I would check if any one had already done
it and had any code they wanted to share?

 

Brook






~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350220
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Application Mappings RE: Ram Disk problem under load

2012-02-23 Thread Brook Davies

So we ran a load test last night with 100 concurrent users. Everything went
fine *except* this ram disk problem  and another problem with a missing
template include. Looking at it closer, both errors Could not find the
included template used application mappings to do the include. 

These are defined in the application.cfc:

cfcomponent output=false extends=coldfireApplication

 cfset this.name= 'YourMama'
 cfset this.mappings[ /publicroot ]   = webroot  'web\public\' /
 cfset this.mappings[ /ram ]   = ram:// /

/cfcomponent

Cf 8.01 had a hotfix that was supposed to fix  custom tag path mappings
acting up under load:
http://kb2.adobe.com/cps/529/cpsid_52915.html

73761   Fix for the error Cannot find CFML template for custom tag thrown
under load when using THIS.customtagpath in application.cfc and enable per
app settings is enabled.


But I am running CF 9.01 with all the hotfixes. BTW, I dumped the ram disk
after some failed includes and the file *did exist* on the ram disk.

--

I just did another load test this morning, however this time the load was
all done on a single application testing a form submission process (this is
where the include error was generated). No errors this time. The difference
between this test and the last test that generated lots of errors is that
this test did not run concurrent load on the other side of this application
which uses an application.cfc that extends the main application.cfc via
applicationProxy.cfc. It’s a child application that shares the main
applications name and scope but also enables client variables and does some
other stuff (pseudo code below)

cfcomponent output=false extends=ApplicationProxy
   cfset this.clientManagement= true
  cfset this.setClientCookies= true
  cfset this.setDomainCookies= true
 cfset this.clientStorage= 'LF-CLIENTVARS'
   
 !--- NO MAPPINGS HERE LIKE IN THE MAIN APPLICATION.CFC. COULD THAT
BE THE PROBLEM?? ---

  cffunction name=onRequestStart returnType=boolean output=false
cfargument name=thePage type=string required=true
 cfset super.onRequestStart(arguments.thePage)
cfreturn true
  /cffunction

/cfcomponent

---

So my guess is that because it doesn't include the application mappings that
it is somehow overwriting them when two requests run at the same time.
Strange I know, but that’s the best I can figure. I am gonna run another
load test tomorrow night, and try adding the mappings into the child
application and see if that helps.



Brook


-Original Message-
From: Brook Davies [mailto:cft...@logiforms.com] 
Sent: February-22-12 12:30 PM
To: cf-talk
Subject: RE: Ram Disk problem under load


Hi Raymond,

I don't see your reply actually... oh here it is in my junk
folder...g...

Tonight when the load test is running, I'll pause midway and swap in a real
file path and see how that runs. 

The only other thing I can think is that there is a name collision and the
file is deleted by another thread who was using the same filename. But the
filename variable IS var scoped (FYI, this IS inside an application scoped
CFC).  

Brook



-Original Message-
From: Raymond Camden [mailto:raymondcam...@gmail.com]
Sent: February-22-12 11:38 AM
To: cf-talk
Subject: Re: Ram Disk problem under load


Noticed you didn't reply to my idea... can you also ensure that it really is
a VFS issue by simply switching to a real folder - just for testing?

On Wed, Feb 22, 2012 at 12:05 PM, Brook Davies cft...@logiforms.com wrote:

 Good idea, I'll check the contents of the ram disk after any failures...

 Brook

 -Original Message-
 From: Pete Freitag [mailto:p...@foundeo.com]
 Sent: February-22-12 9:58 AM
 To: cf-talk
 Subject: Re: Ram Disk problem under load


 Hi Brook,

 Certainly you will want to have a try / catch around that, you could 
 put the delete of the ram file in a cffinally tag to ensure it runs, 
 otherwise if an error is thrown in the cfinclude the file never gets 
 deleted and stays in ram.

 Also to answer your question about the garbage collection, I don't 
 think that would be the issue, the garbage collector only removes 
 objects that have a reference count of zero, I would assume that when 
 you have a file on the ram disk ColdFusion maintains a reference to 
 it, when you delete the file CF will delete the reference and allow the GC
to cleanup.

 I don't think reducing the size of your ram disk will make the problem 
 go away.

 What you might want to do is run this after you run your load test to 
 see whats in there:

 cfdirectory directory=ram:// action=list recurse=true 
 name=dir cfdump variable=#dir#

 --
 Pete Freitag - Adobe Community Professional http://foundeo.com/ - 
 ColdFusion Consulting  Products http://petefreitag.com/ - My Blog 
 http://hackmycf.com
 - Is your ColdFusion Server Secure?




 On Wed, Feb 22, 2012 at 12:44 PM, Brook Davies cft

RE: Application Mappings RE: Ram Disk problem under load

2012-02-23 Thread Brook Davies

Nope, no code that called onApplicationStop() at all...

-Original Message-
From: Pete Freitag [mailto:p...@foundeo.com] 
Sent: February-23-12 10:36 AM
To: cf-talk
Subject: Re: Application Mappings RE: Ram Disk problem under load


Do you have code that calls ApplicationStop() on error or something I wonder
if that might cause the application scoped mappings to be undefined for a
split second while the application is reloading? Just a guess.



On Thu, Feb 23, 2012 at 1:10 PM, Brook Davies cft...@logiforms.com wrote:


 So we ran a load test last night with 100 concurrent users. Everything 
 went fine *except* this ram disk problem  and another problem with a 
 missing template include. Looking at it closer, both errors Could not 
 find the included template used application mappings to do the include.

 These are defined in the application.cfc:

 cfcomponent output=false extends=coldfireApplication

  cfset this.name= 'YourMama'
  cfset this.mappings[ /publicroot ]   = webroot  'web\public\' /
  cfset this.mappings[ /ram ]   = ram:// /

 /cfcomponent

 Cf 8.01 had a hotfix that was supposed to fix  custom tag path 
 mappings acting up under load:
 http://kb2.adobe.com/cps/529/cpsid_52915.html

 73761   Fix for the error Cannot find CFML template for custom tag
thrown
 under load when using THIS.customtagpath in application.cfc and 
 enable per app settings is enabled.


 But I am running CF 9.01 with all the hotfixes. BTW, I dumped the ram 
 disk after some failed includes and the file *did exist* on the ram disk.

 --

 I just did another load test this morning, however this time the load 
 was all done on a single application testing a form submission process 
 (this is where the include error was generated). No errors this time. 
 The difference between this test and the last test that generated lots 
 of errors is that this test did not run concurrent load on the other 
 side of this application which uses an application.cfc that extends 
 the main application.cfc via applicationProxy.cfc. It's a child 
 application that shares the main applications name and scope but also 
 enables client variables and does some other stuff (pseudo code below)

 cfcomponent output=false extends=ApplicationProxy
   cfset this.clientManagement= true
  cfset this.setClientCookies= true
  cfset this.setDomainCookies= true
 cfset this.clientStorage= 'LF-CLIENTVARS'

 !--- NO MAPPINGS HERE LIKE IN THE MAIN APPLICATION.CFC. COULD 
 THAT BE THE PROBLEM?? ---

  cffunction name=onRequestStart returnType=boolean output=false
cfargument name=thePage type=string required=true
 cfset super.onRequestStart(arguments.thePage)
cfreturn true
  /cffunction

 /cfcomponent

 ---

 So my guess is that because it doesn't include the application 
 mappings that it is somehow overwriting them when two requests run at 
 the same time.
 Strange I know, but that's the best I can figure. I am gonna run 
 another load test tomorrow night, and try adding the mappings into the 
 child application and see if that helps.



 Brook


 -Original Message-
 From: Brook Davies [mailto:cft...@logiforms.com]
 Sent: February-22-12 12:30 PM
 To: cf-talk
 Subject: RE: Ram Disk problem under load


 Hi Raymond,

 I don't see your reply actually... oh here it is in my junk 
 folder...g...

 Tonight when the load test is running, I'll pause midway and swap in a 
 real file path and see how that runs.

 The only other thing I can think is that there is a name collision and 
 the file is deleted by another thread who was using the same filename. 
 But the filename variable IS var scoped (FYI, this IS inside an 
 application scoped CFC).

 Brook



 -Original Message-
 From: Raymond Camden [mailto:raymondcam...@gmail.com]
 Sent: February-22-12 11:38 AM
 To: cf-talk
 Subject: Re: Ram Disk problem under load


 Noticed you didn't reply to my idea... can you also ensure that it 
 really is a VFS issue by simply switching to a real folder - just for 
 testing?

 On Wed, Feb 22, 2012 at 12:05 PM, Brook Davies cft...@logiforms.com
 wrote:
 
  Good idea, I'll check the contents of the ram disk after any failures...
 
  Brook
 
  -Original Message-
  From: Pete Freitag [mailto:p...@foundeo.com]
  Sent: February-22-12 9:58 AM
  To: cf-talk
  Subject: Re: Ram Disk problem under load
 
 
  Hi Brook,
 
  Certainly you will want to have a try / catch around that, you could 
  put the delete of the ram file in a cffinally tag to ensure it 
  runs, otherwise if an error is thrown in the cfinclude the file 
  never gets deleted and stays in ram.
 
  Also to answer your question about the garbage collection, I don't 
  think that would be the issue, the garbage collector only removes 
  objects that have a reference count of zero, I would assume that 
  when you have a file on the ram disk ColdFusion maintains

RE: Application Mappings RE: Ram Disk problem under load

2012-02-23 Thread Brook Davies

Whats the best way to contact Adobe Support? 

-Original Message-
From: Raymond Camden [mailto:raymondcam...@gmail.com] 
Sent: February-23-12 10:51 AM
To: cf-talk
Subject: Re: Application Mappings RE: Ram Disk problem under load


I'd suggest pinging Adobe support. You are right - this is something that
was fixed. But it sounds like you have a -very- reproduceable case, which
makes it easier for them to fix.


On Thu, Feb 23, 2012 at 12:36 PM, Pete Freitag p...@foundeo.com wrote:

 Do you have code that calls ApplicationStop() on error or something I 
 wonder if that might cause the application scoped mappings to be 
 undefined for a split second while the application is reloading? Just a
guess.





~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350080
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Ram Disk problem under load

2012-02-22 Thread Brook Davies

Hey everyone,

Did some very light pre-load testing yesterday in preparation for a larger
test tomorrow. This limited load threw some errors. I'm writing to the in
memory file system some CFML code, that I then cfinclude to execute it.  Its
pretty straight forward code, and this was under very little load (10
concurrent users only).

Note: I have an application mapping for the ram disk in application.cfc:

cfset this.mappings[ /ram ]  = ram:// /

And then in the problem code:

-
!--- set the filename to a unique name ---
cfset filename = 'wildcardparsing-#createUUID()#.cfm'
!--- write the file ---
cffile action=write output=#cfml# file=ram://#filename#/
!--- include and execute the cfml ---
cfinclude template=/ram/#filename# /
!--- clean up ---
cffile action=delete file=ram://#filename#/

-

The error I got was:

Could not find the included template
/ram/wildcardparsing-66031760-EEDC-69FB-8F2EFEC77564096A.cfm.

I got a similar error in another template on a different execution that uses
similar code to generate the CFML for a CFDOCUMENT tag and then writes it to
ram disk and includes. I have never seen this error in development it only
started happening under a wee bit of load. What could be the problem? The In
memory file system is set to 500 megs in the cfadmin (which is probably
overkill..). Would a garbage collection before the include had been
completed cause this to happen?

Brook




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350019
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Ram Disk problem under load

2012-02-22 Thread Brook Davies

Hi Pete,

I don't think its possible because the ram disk size is set to 500 megs, and
this was only 10 concurrent users!  I have another test with 100 cuncurrent
users running tonight and I guess we'll see what happens though I am sure
this is going to be an issue. I added a try/catch around the write/read and
am them attempting to do it again, so I guess we'll see what happens. 

Maybe I should reduce the size allocated to the ram disk?

Brook

-Original Message-
From: Pete Freitag [mailto:p...@foundeo.com] 
Sent: February-22-12 9:35 AM
To: cf-talk
Subject: Re: Ram Disk problem under load


Another thing to consider is that the Ram disk has a size limit specified in
the ColdFusion administrator. Is it possible that the write failed (perhaps
silently) because the ram disk was full.


--
Pete Freitag - Adobe Community Professional http://foundeo.com/ - ColdFusion
Consulting  Products http://petefreitag.com/ - My Blog http://hackmycf.com
- Is your ColdFusion Server Secure?



On Wed, Feb 22, 2012 at 3:12 AM, Brook Davies cft...@logiforms.com wrote:


 Hey everyone,

 Did some very light pre-load testing yesterday in preparation for a 
 larger test tomorrow. This limited load threw some errors. I'm writing 
 to the in memory file system some CFML code, that I then cfinclude to
execute it.
  Its
 pretty straight forward code, and this was under very little load (10 
 concurrent users only).

 Note: I have an application mapping for the ram disk in application.cfc:

 cfset this.mappings[ /ram ]  = ram:// /

 And then in the problem code:

 -
 !--- set the filename to a unique name --- cfset filename = 
 'wildcardparsing-#createUUID()#.cfm'
!--- write the file ---
cffile action=write output=#cfml# file=ram://#filename#/
!--- include and execute the cfml ---
cfinclude template=/ram/#filename# /
 !--- clean up ---
 cffile action=delete file=ram://#filename#/

 -

 The error I got was:

 Could not find the included template
 /ram/wildcardparsing-66031760-EEDC-69FB-8F2EFEC77564096A.cfm.

 I got a similar error in another template on a different execution 
 that uses similar code to generate the CFML for a CFDOCUMENT tag and 
 then writes it to ram disk and includes. I have never seen this error 
 in development it only started happening under a wee bit of load. What 
 could be the problem? The In memory file system is set to 500 megs in 
 the cfadmin (which is probably overkill..). Would a garbage collection 
 before the include had been completed cause this to happen?

 Brook




 



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350031
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Ram Disk problem under load

2012-02-22 Thread Brook Davies

Good idea, I'll check the contents of the ram disk after any failures...

Brook

-Original Message-
From: Pete Freitag [mailto:p...@foundeo.com] 
Sent: February-22-12 9:58 AM
To: cf-talk
Subject: Re: Ram Disk problem under load


Hi Brook,

Certainly you will want to have a try / catch around that, you could put the
delete of the ram file in a cffinally tag to ensure it runs, otherwise if
an error is thrown in the cfinclude the file never gets deleted and stays in
ram.

Also to answer your question about the garbage collection, I don't think
that would be the issue, the garbage collector only removes objects that
have a reference count of zero, I would assume that when you have a file on
the ram disk ColdFusion maintains a reference to it, when you delete the
file CF will delete the reference and allow the GC to cleanup.

I don't think reducing the size of your ram disk will make the problem go
away.

What you might want to do is run this after you run your load test to see
whats in there:

cfdirectory directory=ram:// action=list recurse=true name=dir
cfdump variable=#dir#

--
Pete Freitag - Adobe Community Professional http://foundeo.com/ - ColdFusion
Consulting  Products http://petefreitag.com/ - My Blog http://hackmycf.com
- Is your ColdFusion Server Secure?




On Wed, Feb 22, 2012 at 12:44 PM, Brook Davies cft...@logiforms.com wrote:


 Hi Pete,

 I don't think its possible because the ram disk size is set to 500 
 megs, and this was only 10 concurrent users!  I have another test with 
 100 cuncurrent users running tonight and I guess we'll see what 
 happens though I am sure this is going to be an issue. I added a 
 try/catch around the write/read and am them attempting to do it again, 
 so I guess we'll see what happens.

 Maybe I should reduce the size allocated to the ram disk?

 Brook

 -Original Message-
 From: Pete Freitag [mailto:p...@foundeo.com]
 Sent: February-22-12 9:35 AM
 To: cf-talk
 Subject: Re: Ram Disk problem under load


 Another thing to consider is that the Ram disk has a size limit 
 specified in the ColdFusion administrator. Is it possible that the 
 write failed (perhaps
 silently) because the ram disk was full.


 --
 Pete Freitag - Adobe Community Professional http://foundeo.com/ - 
 ColdFusion Consulting  Products http://petefreitag.com/ - My Blog 
 http://hackmycf.com
 - Is your ColdFusion Server Secure?



 On Wed, Feb 22, 2012 at 3:12 AM, Brook Davies cft...@logiforms.com
 wrote:

 
  Hey everyone,
 
  Did some very light pre-load testing yesterday in preparation for a 
  larger test tomorrow. This limited load threw some errors. I'm 
  writing to the in memory file system some CFML code, that I then 
  cfinclude to
 execute it.
   Its
  pretty straight forward code, and this was under very little load 
  (10 concurrent users only).
 
  Note: I have an application mapping for the ram disk in application.cfc:
 
  cfset this.mappings[ /ram ]  = ram:// /
 
  And then in the problem code:
 
  -
  !--- set the filename to a unique name --- cfset filename = 
  'wildcardparsing-#createUUID()#.cfm'
 !--- write the file ---
 cffile action=write output=#cfml# file=ram://#filename#/
 !--- include and execute the cfml ---
 cfinclude template=/ram/#filename# /
  !--- clean up ---
  cffile action=delete file=ram://#filename#/
 
  -
 
  The error I got was:
 
  Could not find the included template 
  /ram/wildcardparsing-66031760-EEDC-69FB-8F2EFEC77564096A.cfm.
 
  I got a similar error in another template on a different execution 
  that uses similar code to generate the CFML for a CFDOCUMENT tag and 
  then writes it to ram disk and includes. I have never seen this 
  error in development it only started happening under a wee bit of 
  load. What could be the problem? The In memory file system is set to 
  500 megs in the cfadmin (which is probably overkill..). Would a 
  garbage collection before the include had been completed cause this to
happen?
 
  Brook
 
 
 
 
 



 



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350034
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Ram Disk problem under load

2012-02-22 Thread Brook Davies

Hi Raymond,

I don't see your reply actually... oh here it is in my junk
folder...g...

Tonight when the load test is running, I'll pause midway and swap in a real
file path and see how that runs. 

The only other thing I can think is that there is a name collision and the
file is deleted by another thread who was using the same filename. But the
filename variable IS var scoped (FYI, this IS inside an application scoped
CFC).  

Brook



-Original Message-
From: Raymond Camden [mailto:raymondcam...@gmail.com] 
Sent: February-22-12 11:38 AM
To: cf-talk
Subject: Re: Ram Disk problem under load


Noticed you didn't reply to my idea... can you also ensure that it really is
a VFS issue by simply switching to a real folder - just for testing?

On Wed, Feb 22, 2012 at 12:05 PM, Brook Davies cft...@logiforms.com wrote:

 Good idea, I'll check the contents of the ram disk after any failures...

 Brook

 -Original Message-
 From: Pete Freitag [mailto:p...@foundeo.com]
 Sent: February-22-12 9:58 AM
 To: cf-talk
 Subject: Re: Ram Disk problem under load


 Hi Brook,

 Certainly you will want to have a try / catch around that, you could 
 put the delete of the ram file in a cffinally tag to ensure it runs, 
 otherwise if an error is thrown in the cfinclude the file never gets 
 deleted and stays in ram.

 Also to answer your question about the garbage collection, I don't 
 think that would be the issue, the garbage collector only removes 
 objects that have a reference count of zero, I would assume that when 
 you have a file on the ram disk ColdFusion maintains a reference to 
 it, when you delete the file CF will delete the reference and allow the GC
to cleanup.

 I don't think reducing the size of your ram disk will make the problem 
 go away.

 What you might want to do is run this after you run your load test to 
 see whats in there:

 cfdirectory directory=ram:// action=list recurse=true 
 name=dir cfdump variable=#dir#

 --
 Pete Freitag - Adobe Community Professional http://foundeo.com/ - 
 ColdFusion Consulting  Products http://petefreitag.com/ - My Blog 
 http://hackmycf.com
 - Is your ColdFusion Server Secure?




 On Wed, Feb 22, 2012 at 12:44 PM, Brook Davies cft...@logiforms.com
wrote:


 Hi Pete,

 I don't think its possible because the ram disk size is set to 500 
 megs, and this was only 10 concurrent users!  I have another test 
 with
 100 cuncurrent users running tonight and I guess we'll see what 
 happens though I am sure this is going to be an issue. I added a 
 try/catch around the write/read and am them attempting to do it 
 again, so I guess we'll see what happens.

 Maybe I should reduce the size allocated to the ram disk?

 Brook

 -Original Message-
 From: Pete Freitag [mailto:p...@foundeo.com]
 Sent: February-22-12 9:35 AM
 To: cf-talk
 Subject: Re: Ram Disk problem under load


 Another thing to consider is that the Ram disk has a size limit 
 specified in the ColdFusion administrator. Is it possible that the 
 write failed (perhaps
 silently) because the ram disk was full.


 --
 Pete Freitag - Adobe Community Professional http://foundeo.com/ - 
 ColdFusion Consulting  Products http://petefreitag.com/ - My Blog 
 http://hackmycf.com
 - Is your ColdFusion Server Secure?



 On Wed, Feb 22, 2012 at 3:12 AM, Brook Davies cft...@logiforms.com
 wrote:

 
  Hey everyone,
 
  Did some very light pre-load testing yesterday in preparation for a 
  larger test tomorrow. This limited load threw some errors. I'm 
  writing to the in memory file system some CFML code, that I then 
  cfinclude to
 execute it.
   Its
  pretty straight forward code, and this was under very little load
  (10 concurrent users only).
 
  Note: I have an application mapping for the ram disk in
application.cfc:
 
  cfset this.mappings[ /ram ]              = ram:// /
 
  And then in the problem code:
 
  -
  !--- set the filename to a unique name --- cfset filename = 
  'wildcardparsing-#createUUID()#.cfm'
         !--- write the file ---
         cffile action=write output=#cfml# 
  file=ram://#filename#/
         !--- include and execute the cfml ---
         cfinclude template=/ram/#filename# /
  !--- clean up ---
  cffile action=delete file=ram://#filename#/
 
  -
 
  The error I got was:
 
  Could not find the included template 
  /ram/wildcardparsing-66031760-EEDC-69FB-8F2EFEC77564096A.cfm.
 
  I got a similar error in another template on a different execution 
  that uses similar code to generate the CFML for a CFDOCUMENT tag 
  and then writes it to ram disk and includes. I have never seen this 
  error in development it only started happening under a wee bit of 
  load. What could be the problem? The In memory file system is set 
  to
  500 megs in the cfadmin (which is probably overkill..). Would a 
  garbage collection before the include had been completed cause this 
  to
 happen?
 
  Brook

RE: Fusion Reactor and Fusion Analytics Kick Ass

2012-02-20 Thread Brook Davies

My thoughts exactly...

-Original Message-
From: Raymond Camden [mailto:raymondcam...@gmail.com] 
Sent: February-20-12 8:24 AM
To: cf-talk
Subject: Re: Fusion Reactor and Fusion Analytics Kick Ass


On Sun, Feb 19, 2012 at 10:03 AM, Dan Baughman dan.baugh...@gmail.com
wrote:

 Thats great, but I guess outside of being cool none of that really 
 provides any value.

Have you even looked at FusionReactor and FusionAnalytics? I find it
_incredible_ you would say these tools don't provide any value, but I guess
to each his own.

-Ray



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349965
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Fusion Reactor and Fusion Analytics Kick Ass

2012-02-19 Thread Brook Davies

Hi Dan,

That wasn't a good example, and no it doesn't take a CF tool to determin a
server reboot. However, this was a brand new server install that didn't have
any monitoring services setup (which would notify me of a restart etc).
Sure, I could have looked in the event viewer or other logs, but that wasn't
really the point of my comment.  The fact that I was able to see a spike in
CPU usage (when my otherwise dormant application server was re-initializing)
, click on it and see the exact CF log file entries at that time (which
showed the restart) is useful and more than just cool. Plus that is just one
of the options to inspect at any point of the graph. Fusion Analytics can
pull up all of the JDBC requests at that time, and like I said, a ton of
other useful information. 

I don't see how that's not of value and I have been administrating CF
servers for over 10 years without the help of FR/FA . **For me** it is of
value and makes my job that much easier.
 
Brook


-Original Message-
From: Dan Baughman [mailto:dan.baugh...@gmail.com] 
Sent: February-19-12 8:03 AM
To: cf-talk
Subject: Re: Fusion Reactor and Fusion Analytics Kick Ass


Thats great, but I guess outside of being cool none of that really provides
any value.

It shouldn't take a Coldfusion tool to determine your server is rebooting at
3AM.

On Fri, Feb 17, 2012 at 3:31 PM, Brook Davies cft...@logiforms.com wrote:


 I just set up fusionAnalytics - its awesome. It really makes 
 fusionReactor that much better. I have a new server setup I am working 
 on, I was looking at the CPU and memory graph today and saw a spike at 
 3 am on all 3 of our servers. I right clicked on the memory spike and 
 was able to choose from a ton of options from that time period I 
 choice to show the logs (FusionAnalytics stores and indexes/aggregates 
 all the CF logs..) and saw immediately that the CF server was doing a 
 restart. Turns out windows update was set to do automatic updates and 
 automatic restarts on our brand new out the box server.

 Simple example, and sure, I could have just went  through the logs and 
 found this manually, but to be able to see spike in 
 memory/requests/response/jdbc/cpu and just right click the spike and get:

 JDBC requests at that exact time
 Threads at that time
 Log file entries
 CF Scope sizes
 System Metrics
 And more

 For that exact moment. Priceless :)

 Brook

 -Original Message-
 From: Nick Gleason [mailto:n.glea...@citysoft.com]
 Sent: February-17-12 2:14 PM
 To: cf-talk
 Subject: RE: Fusion Reactor and Fusion Analytics Kick Ass


 +1 for FusionReactor.  We've got but have not yet installed Fusion
 Analytics.  But we're looking forward to that addition as well.

 Nick

 PS - also no affiliation with them.



.
..
 ...

 CitySoft, Inc. | http://www.citysoft.com

 Phone: (866) 751-1992 | Direct: (617) 899-5395 | Fax: (617) 507-0444

 Spend Less  Do More - Community Enterprise combines great features 
 with an affordable price.



.
..
 ...

  -Original Message-
  From: Brook Davies [mailto:cft...@logiforms.com]
  Sent: Friday, February 17, 2012 12:19 PM
  To: cf-talk
  Subject: Fusion Reactor and Fusion Analytics Kick Ass
 
 
  Hey people,
 
 
 
  I'm sure most of you already know this, but Fusion Reactor and 
  Fusion Analytics for monitoring CF servers kick some serious ass. 
  I've been a seefusion customer for years, and while it does a decent 
  job its not in the same class as the Fusion Reactor/Analytics 
  Products.  This pair of products is phenomenal and give you 
  incredible insight into your CF server. If you're a CF sys admin, you
really want to check em out.
 
 
 
  I have absolutely zero affiliation with the company, I just bought 
  and setup
  3 licenses and am so happy with it, that I wanted to share how great 
  they are. I've had them running for a few days and they have already 
  helped resolve problems.
 
 
 
  Now for the load testing J
 
 
 
  Brook
 
 
 
 
 
 
 



 



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349947
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Fusion Reactor and Fusion Analytics Kick Ass

2012-02-17 Thread Brook Davies

Hey people,

 

I'm sure most of you already know this, but Fusion Reactor and Fusion
Analytics for monitoring CF servers kick some serious ass. I've been a
seefusion customer for years, and while it does a decent job its not in the
same class as the Fusion Reactor/Analytics Products.  This pair of products
is phenomenal and give you incredible insight into your CF server. If you're
a CF sys admin, you really want to check em out. 

 

I have absolutely zero affiliation with the company, I just bought and setup
3 licenses and am so happy with it, that I wanted to share how great they
are. I've had them running for a few days and they have already helped
resolve problems.

 

Now for the load testing J

 

Brook 

 




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349931
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Fusion Reactor and Fusion Analytics Kick Ass

2012-02-17 Thread Brook Davies

I just set up fusionAnalytics - its awesome. It really makes fusionReactor
that much better. I have a new server setup I am working on, I was looking
at the CPU and memory graph today and saw a spike at 3 am on all 3 of our
servers. I right clicked on the memory spike and was able to choose from a
ton of options from that time period I choice to show the logs
(FusionAnalytics stores and indexes/aggregates all the CF logs..) and saw
immediately that the CF server was doing a restart. Turns out windows update
was set to do automatic updates and automatic restarts on our brand new out
the box server.

Simple example, and sure, I could have just went  through the logs and found
this manually, but to be able to see spike in
memory/requests/response/jdbc/cpu and just right click the spike and get:

JDBC requests at that exact time
Threads at that time
Log file entries
CF Scope sizes
System Metrics
And more

For that exact moment. Priceless :)

Brook

-Original Message-
From: Nick Gleason [mailto:n.glea...@citysoft.com] 
Sent: February-17-12 2:14 PM
To: cf-talk
Subject: RE: Fusion Reactor and Fusion Analytics Kick Ass


+1 for FusionReactor.  We've got but have not yet installed Fusion
Analytics.  But we're looking forward to that addition as well.

Nick

PS - also no affiliation with them.

.
...
 
CitySoft, Inc. | http://www.citysoft.com
 
Phone: (866) 751-1992 | Direct: (617) 899-5395 | Fax: (617) 507-0444
 
Spend Less  Do More - Community Enterprise combines great features with an
affordable price.

.
...

 -Original Message-
 From: Brook Davies [mailto:cft...@logiforms.com]
 Sent: Friday, February 17, 2012 12:19 PM
 To: cf-talk
 Subject: Fusion Reactor and Fusion Analytics Kick Ass
 
 
 Hey people,
 
 
 
 I'm sure most of you already know this, but Fusion Reactor and Fusion 
 Analytics for monitoring CF servers kick some serious ass. I've been a 
 seefusion customer for years, and while it does a decent job its not 
 in the same class as the Fusion Reactor/Analytics Products.  This pair 
 of products is phenomenal and give you incredible insight into your CF 
 server. If you're a CF sys admin, you really want to check em out.
 
 
 
 I have absolutely zero affiliation with the company, I just bought and 
 setup
 3 licenses and am so happy with it, that I wanted to share how great 
 they are. I've had them running for a few days and they have already 
 helped resolve problems.
 
 
 
 Now for the load testing J
 
 
 
 Brook
 
 
 
 
 
 
 



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349933
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Load Testing - what to look for and monitor/report

2012-02-11 Thread Brook Davies

Hi Dave,

We're doing performance analysis and looking for bottlenecks and also memory
leaks since we have a lot of application scoped components and large numbers
of objects created per request. That's one of my main concerns actually..

Brook

-Original Message-
From: Dave Watts [mailto:dwa...@figleaf.com] 
Sent: February-11-12 7:46 AM
To: cf-talk
Subject: Re: Load Testing - what to look for and monitor/report


 Anyhow, what I really want to know from you experts is what should I 
 be watching and recording during these load tests?

Generally, you're interested in response time and throughput.

 Also should I pair down from a load balanced solution to a single 
 server to make it easier to debug log files and track memory etc?

 And then scale up after a specific duration? Or for the second test 
 interval?

 I don't have much experience with load testing and just want to make 
 sure that this is money well spend in terms of having some actionable
data.

It's hard to answer this without more information. What is the goal of the
load test? What kind of actionable data are you looking for?

You can use load tests to answer a couple of different questions.
There are two basic types of load test: performance analysis, and capacity
planning. In a performance analysis test, you're looking for bottlenecks in
your application with the goal of improving application performance. In a
capacity planning test, you're trying to identify how many users your
application can support as it's currently written.
Which one of these are you doing?

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
http://training.figleaf.com/

Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule,
and provides the highest caliber vendor-authorized instruction at our
training centers, online, or onsite.



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349863
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Load Testing - what to look for and monitor/report

2012-02-10 Thread Brook Davies

Hey Guys,

 

I am hiring a load testing company, Neustar, to run some load tests on a new
cf app and server deployment. I have FusionReactor installed and the
platform is CF9 Standard on windows 2008 web server, and the backend is a
separate MS SQL box. A beefy one at that J. The server environment is
virtualized running on vmware on Dell 610s (in case any one cared..)..

 

Anyhow, what I really want to know from you experts is what should I be
watching and recording during these load tests? 

 

Also should I pair down from a load balanced solution to a single server to
make it easier to debug log files and track memory etc? 

 

And then scale up after a specific duration? Or for the second test
interval?

 

I don't have much experience with load testing and just want to make sure
that this is money well spend in terms of having some actionable data.

 

Thank yo! 

 

Brook




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349861
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Accessing the Application Scope of another App

2012-02-08 Thread Brook Davies

Hi,

Can you guys tell me if this is bad practice or will lead to memory issues.
I have a CF app that has the main app and an admin module, each with their
own cfapplication, and application namepace. From within the admin app I
need to clear some application scoped data in the main app. 

I do something like this:

cffunction..

cfif application.applicationName is  COREAPP
cfset local.appScopeReference = application
cfelse
cfset local.appScopeReference =
createObject(java,coldfusion.runtime.ApplicationScopeTracker)
..getApplicationScope('COREAPP')
/cfif

cflock scope=application type=exclusive
  cfset structDelete(local.appScopeReference,'somekey')
/cflock

/cffunction

Is there gonna be an issues with dumping the app scope into a local variable
like this? Or something else?

Brook 




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349841
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


(ot) Were to store admin passwords?

2012-02-06 Thread Brook Davies

This is a bit OT, but I'm starting to get paranoid. Where is the best place
to store server administrator account password and passwords for the
cfadministrator etc.

 

Brook




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349783
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: CFFILE to \\tsclient\c$\

2012-01-30 Thread Brook Davies

Hi Andrew,

Essentially, yes. I want the remote CF server that I am connecting to via
RDP to write a file to my local filesystem. I can access the local file
system using \\tsclient, so I thought CF, provided it has permissions, would
be able to aswell. But it doesn't look like its gonna happen

Brook

-Original Message-
From: Andrew Scott [mailto:andr...@andyscott.id.au] 
Sent: January-29-12 10:02 PM
To: cf-talk
Subject: Re: CFFILE to \\tsclient\c$\


Are you saying that you are using a Remote Desktop Client to connect to the
server, and you want ColdFusion to be able to access the remote drive
resource of that RDC?

I don't think that it is permissible under any circumstances, and the OS
will not see the remote resourced drive as this is something that the RDC
can only see.

I maybe wrong.


--
Regards,
Andrew Scott
WebSite: http://www.andyscott.id.au/
Google+: http://plus.google.com/108193156965451149543



On Mon, Jan 30, 2012 at 4:52 PM, Brook Davies cft...@logiforms.com wrote:


 Hi AJ, I am doing that - have you done this successfully?

 Brook



 -Original Message-
 From: AJ Mercer [mailto:ajmer...@gmail.com]
 Sent: January-29-12 5:25 PM
 To: cf-talk
 Subject: Re: CFFILE to \\tsclient\c$\


 you will need to run your CF services with a named account and that
account
 will need access permissions to that share


 On 30 January 2012 09:17, Brook Davies br...@logiforms.com wrote:

 
  Anybody ever tried to call CFFILE or CFDIRECTORY to a connected RDP
  session?
  I'm getting an access denied error even though I have added the cf
  account on my local box. Maybe this is just not possible?
 
 
 
  Brook
 
 
 
 
 



 



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349669
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: CFFILE to \\tsclient\c$\

2012-01-30 Thread Brook Davies

Hi Andrew,

That's make sense, thanks.

The reason I wanted to be able to do this is to be able to automate the
transfer of some objects from the server to my local development
environment. Basically on my site clients can build forms. The form, on the
backend is a series of database records with JSON encoded objects and some
related file resources. I wanted to be able to automate the transfer of a
form that a user was getting errors on in the form designer to my local
database and filesystem in order to do debugging on It and re-create the
problem. I can't just copy the DB rows because of the file structure and
files that are integrated with the form object...


Brook

-Original Message-
From: Andrew Scott [mailto:andr...@andyscott.id.au] 
Sent: January-30-12 8:28 AM
To: cf-talk
Subject: Re: CFFILE to \\tsclient\c$\


That's because you are doing it from the RDC, due to security reasons you
are in a session that is allowed this. But if you were to physically go to
the machine / server you would not be able to see your machine this way.

Now this is where I could be wrong, because my understanding is that if this
was allowed that means any other session, or the server could potentially
open up more security implications. And as ColdFusion is running well before
your RDC session starts, then there will be no way ColdFusion or any other
system outside of your RDC session can access your drives.

So the next question, is why would you want ColdFusion to be able to access
your drive over an RDC session?


--
Regards,
Andrew Scott
WebSite: http://www.andyscott.id.au/
Google+: http://plus.google.com/108193156965451149543




On Tue, Jan 31, 2012 at 2:59 AM, Brook Davies cft...@logiforms.com wrote:


 Hi Andrew,

 Essentially, yes. I want the remote CF server that I am connecting to via
 RDP to write a file to my local filesystem. I can access the local file
 system using \\tsclient, so I thought CF, provided it has permissions,
 would
 be able to aswell. But it doesn't look like its gonna happen

 Brook






~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349671
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: CFFILE to \\tsclient\c$\

2012-01-30 Thread Brook Davies

Yeah, that's an option, I could create a zip file.. really though this
system is intended to transfer the objects from a production server to
another server used specifically for debugging. So I wanted to leverage the
same code base that used UNC file paths to copy the data. Being able to
plugin my localhost as a list of available servers to copy the data to would
have been nice, but its not a 100% requirement.  

Brook

-Original Message-
From: Andrew Scott [mailto:andr...@andyscott.id.au] 
Sent: January-30-12 9:31 AM
To: cf-talk
Subject: Re: CFFILE to \\tsclient\c$\


Why don't you just get ColdFusion to generate what you want to transfer, to
a file and when you RDC just add a resource to your RDC settings for a drive
on your machine, then just copy this file to your resourced drive manually?


--
Regards,
Andrew Scott
WebSite: http://www.andyscott.id.au/
Google+: http://plus.google.com/108193156965451149543



On Tue, Jan 31, 2012 at 4:17 AM, Brook Davies cft...@logiforms.com wrote:


 Hi Andrew,

 That's make sense, thanks.

 The reason I wanted to be able to do this is to be able to automate the
 transfer of some objects from the server to my local development
 environment. Basically on my site clients can build forms. The form, on
the
 backend is a series of database records with JSON encoded objects and some
 related file resources. I wanted to be able to automate the transfer of a
 form that a user was getting errors on in the form designer to my local
 database and filesystem in order to do debugging on It and re-create the
 problem. I can't just copy the DB rows because of the file structure and
 files that are integrated with the form object...


 Brook

 -Original Message-
 From: Andrew Scott [mailto:andr...@andyscott.id.au]
 Sent: January-30-12 8:28 AM
 To: cf-talk
 Subject: Re: CFFILE to \\tsclient\c$\


 That's because you are doing it from the RDC, due to security reasons you
 are in a session that is allowed this. But if you were to physically go to
 the machine / server you would not be able to see your machine this way.

 Now this is where I could be wrong, because my understanding is that if
 this
 was allowed that means any other session, or the server could potentially
 open up more security implications. And as ColdFusion is running well
 before
 your RDC session starts, then there will be no way ColdFusion or any other
 system outside of your RDC session can access your drives.

 So the next question, is why would you want ColdFusion to be able to
access
 your drive over an RDC session?


 --
 Regards,
 Andrew Scott
 WebSite: http://www.andyscott.id.au/
 Google+: http://plus.google.com/108193156965451149543




 On Tue, Jan 31, 2012 at 2:59 AM, Brook Davies cft...@logiforms.com
 wrote:

 
  Hi Andrew,
 
  Essentially, yes. I want the remote CF server that I am connecting to
via
  RDP to write a file to my local filesystem. I can access the local file
  system using \\tsclient, so I thought CF, provided it has permissions,
  would
  be able to aswell. But it doesn't look like its gonna happen
 
  Brook
 
 




 



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349673
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: CFFILE to \\tsclient\c$\

2012-01-30 Thread Brook Davies

I do? Why?

-Original Message-
From: Andrew Scott [mailto:andr...@andyscott.id.au] 
Sent: January-30-12 10:11 AM
To: cf-talk
Subject: Re: CFFILE to \\tsclient\c$\


Sounds like you need a better debugging strategy then.


-- 
Regards,
Andrew Scott
WebSite: http://www.andyscott.id.au/
Google+: http://plus.google.com/108193156965451149543



On Tue, Jan 31, 2012 at 5:01 AM, Brook Davies cft...@logiforms.com wrote:


 Yeah, that's an option, I could create a zip file.. really though this
 system is intended to transfer the objects from a production server to
 another server used specifically for debugging. So I wanted to leverage
the
 same code base that used UNC file paths to copy the data. Being able to
 plugin my localhost as a list of available servers to copy the data to
 would
 have been nice, but its not a 100% requirement.

 Brook






~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349675
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: CFFILE to \\tsclient\c$\

2012-01-30 Thread Brook Davies

Hey Andrew,

I do use redgate (love it!), but I need to be able to transfer objects from
a number of tables, and there is also lots of JSON encoded data that itself
contains id references from other records and file path references for
media. Also, for each 'object' there is a specific directory structure and
supplemental files.  Its hella complicated :(  

Anyhow, I already wrote the code to copy the forms and its really
multipurpose as customers often ask to transfer/copy forms between accounts
aswell. So now we can do that via a web ui, and also port a problematic form
to our debugging server where we can replay their failed commit (we store
the commit array which describes each change made before saving) and find
where the problem is. 

Brook

-Original Message-
From: Andrew Scott [mailto:andr...@andyscott.id.au] 
Sent: January-30-12 11:02 AM
To: cf-talk
Subject: Re: CFFILE to \\tsclient\c$\


Because of your comment this system is intended to transfer the objects
from a production server to another server used specifically for debugging
, I think there has to be a better way to sync and debug than what you're
doing.

I mean why can't you use red-gate for MS SQL server sync and beyond compare
for files, to your testing environment?

Or even backup your database and transfer it to your testing server, and
restore the database to a local SQL Server, and file sync the files.

Just throwing some ideas out there, as I do not know much about your
situation.


--
Regards,
Andrew Scott
WebSite: http://www.andyscott.id.au/
Google+: http://plus.google.com/108193156965451149543



On Tue, Jan 31, 2012 at 5:53 AM, Brook Davies cft...@logiforms.com wrote:


 I do? Why?

 -Original Message-
 From: Andrew Scott [mailto:andr...@andyscott.id.au]
 Sent: January-30-12 10:11 AM
 To: cf-talk
 Subject: Re: CFFILE to \\tsclient\c$\


 Sounds like you need a better debugging strategy then.


 --
 Regards,
 Andrew Scott
 WebSite: http://www.andyscott.id.au/
 Google+: http://plus.google.com/108193156965451149543



 On Tue, Jan 31, 2012 at 5:01 AM, Brook Davies cft...@logiforms.com
 wrote:

 
  Yeah, that's an option, I could create a zip file.. really though this
  system is intended to transfer the objects from a production server to
  another server used specifically for debugging. So I wanted to leverage
 the
  same code base that used UNC file paths to copy the data. Being able to
  plugin my localhost as a list of available servers to copy the data to
  would
  have been nice, but its not a 100% requirement.
 
  Brook
 
 




 



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349677
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


CFFILE to \\tsclient\c$\

2012-01-29 Thread Brook Davies

Anybody ever tried to call CFFILE or CFDIRECTORY to a connected RDP session?
I'm getting an access denied error even though I have added the cf account
on my local box. Maybe this is just not possible?

 

Brook




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349664
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: CFFILE to \\tsclient\c$\

2012-01-29 Thread Brook Davies

Hi AJ, I am doing that - have you done this successfully?

Brook



-Original Message-
From: AJ Mercer [mailto:ajmer...@gmail.com] 
Sent: January-29-12 5:25 PM
To: cf-talk
Subject: Re: CFFILE to \\tsclient\c$\


you will need to run your CF services with a named account and that account
will need access permissions to that share


On 30 January 2012 09:17, Brook Davies br...@logiforms.com wrote:


 Anybody ever tried to call CFFILE or CFDIRECTORY to a connected RDP 
 session?
 I'm getting an access denied error even though I have added the cf 
 account on my local box. Maybe this is just not possible?



 Brook




 



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349666
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Best Practice question about database access between Dev and Production Servers

2012-01-28 Thread Brook Davies

Hello,

 

I'm setting up a new environment and I would like to have the ability,
through a web UI to copy objects from our production database (separate
server) to a development/debugging database (separate server). My question
is not about how to implement this but rather whether this is bad practice.
It would involve exposing the production database on the dev server (via a
datasource mapping in the cfadmin).

 

This would mean that any developer that is using our dev server (my concern
is contractors..) would be able to write a query against the production
database and potentially download sensitive data. How to people handle this
type of risk?

 

One idea I had was to not hardcode the database username/password in the
CFadmin and instead prompt for it when accessing this specific tool through
the web UI. Does that sound like a reasonable means of protecting the data
in the production database from developers working on the development
server? 

 

Anybody have better ideas?

 

Brook

 




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349658
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Way OT: Funny video

2012-01-27 Thread Brook Davies

Its Friday, so don't hate:

 

If you haven't seen this, you need to. Its an oldie but a goody:

 

http://www.youtube.com/watch?v=zV0OgsRK0Bc

 

Brook




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349650
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: [ANNOUNCE] CF-FireLogger

2012-01-26 Thread Brook Davies

Looks cool! I'm gonna try it

-Original Message-
From: Max Paperno [mailto:m...@wdg.us] 
Sent: January-26-12 2:25 PM
To: cf-talk
Subject: [ANNOUNCE] CF-FireLogger


Hello all,

Please pardon the interruption but CF-Community is high on politics and low
on CF content.  I haven't posted to this list in at least 10 years, so I
might be out of practice :)

CF-FireLogger is a ColdFusion server-side library for the FireLogger
(http://firelogger.binaryage.com) Firebug extension. It enables logging of
information from within ColdFusion code directly to the Firebug/FireLogger
console. Think of it as the equivalent of JavaScript console.log() but for
your CF apps. An optional feature allows viewing of ColdFusions debugging
information in the console instead of inline. CF-FireLogger is a great
debugging tool for any situation, and is especially useful for AJAX style
applications where showing debug info inline isn't always an option.
CF-FireLogger can be used as a standalone feature, or integrated with CFs
built-in cftrace/trace() commands. CF-FireLogger can be used alongside the
ColdFire debugging output console, or as a replacement.

More details available here: http://www.wdg.us/cf-firelogger Get the code:
https://github.com/mpaperno/CF-FireLogger
Or at RIA Forge: http://cffirelogger.riaforge.org/

Cheers,
-Max



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349634
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: [ANNOUNCE] CF-FireLogger

2012-01-26 Thread Brook Davies

Hey Max,

Got it installed (painless) and it looks cool. What I am wondering is it
seems like you advocate using trace() instead of console().  And it sounds
like if firebug/firelogger is not enabled, that no debugging output would be
sent. Is that true? If so, is there a performance penalty to using this on a
production server to track a bug? Wouldn't any client that does not have the
firebug/firelogger combo and their IP added to the CF debugging IP list not
get any additional overhead? Does the trace tag have overhead when debugging
is not enabled?

Just some thoughts

Thanks again for a very cool extension and contribution to the community!

Brook

-Original Message-
From: Brook Davies [mailto:cft...@logiforms.com] 
Sent: January-26-12 9:16 PM
To: cf-talk
Subject: RE: [ANNOUNCE] CF-FireLogger


Looks cool! I'm gonna try it

-Original Message-
From: Max Paperno [mailto:m...@wdg.us] 
Sent: January-26-12 2:25 PM
To: cf-talk
Subject: [ANNOUNCE] CF-FireLogger


Hello all,

Please pardon the interruption but CF-Community is high on politics and low
on CF content.  I haven't posted to this list in at least 10 years, so I
might be out of practice :)

CF-FireLogger is a ColdFusion server-side library for the FireLogger
(http://firelogger.binaryage.com) Firebug extension. It enables logging of
information from within ColdFusion code directly to the Firebug/FireLogger
console. Think of it as the equivalent of JavaScript console.log() but for
your CF apps. An optional feature allows viewing of ColdFusions debugging
information in the console instead of inline. CF-FireLogger is a great
debugging tool for any situation, and is especially useful for AJAX style
applications where showing debug info inline isn't always an option.
CF-FireLogger can be used as a standalone feature, or integrated with CFs
built-in cftrace/trace() commands. CF-FireLogger can be used alongside the
ColdFire debugging output console, or as a replacement.

More details available here: http://www.wdg.us/cf-firelogger Get the code:
https://github.com/mpaperno/CF-FireLogger
Or at RIA Forge: http://cffirelogger.riaforge.org/

Cheers,
-Max





~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349635
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: [ANNOUNCE] CF-FireLogger

2012-01-26 Thread Brook Davies

Hey Max,

I set everything up according to the docs. I can see the output in
firelogger when I do  this:

cfscript
console = new firelogger(debugMode=false, debugLevel=info,
fallbackLogMethod=trace-inline);
console.log(arguments.commitArray);
/cfscript

But when I try this:

cftrace var=commitArray type=information
text=Starting FormArray Commit
category=FormModel Update,silver,black
inline=false abort=false

I get an error:

Variable DEBUGGER is undefined.
StackTrace  coldfusion.runtime.UndefinedVariableException: Variable
DEBUGGER is undefined. at
coldfusion.runtime.CfJspPage._get(CfJspPage.java:377) at
coldfusion.runtime.CfJspPage._get(CfJspPage.java:339) at
cftrace2ecfm1786375826.runPage(E:\cf9_final\cfusion\wwwroot\WEB-INF\cftags\t
race.cfm:194) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at
coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at
coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at
cftrace2ecfm2140486297$funcDOTRACE.runFunction(C:\ColdFusion9\wwwroot\WEB-IN
F\cftags\trace.cfm:232) at
coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472) at
coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:
368) at
coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321) at
coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220) at
coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:2582) at
cftrace2ecfm2140486297._factor1(C:\ColdFusion9\wwwroot\WEB-INF\cftags\trace.
cfm:40) at
cftrace2ecfm2140486297.runPage(C:\ColdFusion9\wwwroot\WEB-INF\cftags\trace.c
fm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at
coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:
56) at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:271) at
coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at
cfFormDesignController2ecfc2073814296$funcUPDATEFORMMODEL.runFunctio

Note, this only happens when I try to call the TRACE() command from within
an application scoped CFC. When I run the same command from a simple cfm
template, it works as expected. Any idea why?

Brook

-Original Message-
From: Max Paperno [mailto:m...@wdg.us] 
Sent: January-26-12 2:25 PM
To: cf-talk
Subject: [ANNOUNCE] CF-FireLogger


Hello all,

Please pardon the interruption but CF-Community is high on politics and low
on CF content.  I haven't posted to this list in at least 10 years, so I
might be out of practice :)

CF-FireLogger is a ColdFusion server-side library for the FireLogger
(http://firelogger.binaryage.com) Firebug extension. It enables logging of
information from within ColdFusion code directly to the Firebug/FireLogger
console. Think of it as the equivalent of JavaScript console.log() but for
your CF apps. An optional feature allows viewing of ColdFusions debugging
information in the console instead of inline. CF-FireLogger is a great
debugging tool for any situation, and is especially useful for AJAX style
applications where showing debug info inline isn't always an option.
CF-FireLogger can be used as a standalone feature, or integrated with CFs
built-in cftrace/trace() commands. CF-FireLogger can be used alongside the
ColdFire debugging output console, or as a replacement.

More details available here: http://www.wdg.us/cf-firelogger Get the code:
https://github.com/mpaperno/CF-FireLogger
Or at RIA Forge: http://cffirelogger.riaforge.org/

Cheers,
-Max



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349636
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Hide CFC Introspection on Railo

2012-01-25 Thread Brook Davies

I'm playing around with railo and when I access a CFC directly via a URL, it
dumps the CFC methods and details. Is there someway to hide this? Searched
the docs and web to no avail..

 

Brook




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349627
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: varScoper menu not shown in CFBUILDER

2012-01-19 Thread Brook Davies

I appreciate the offer Raymond, but I am okay just running it from the CFM
code base directly. Again thanks Jedi!

Brook

-Original Message-
From: Raymond Camden [mailto:raymondcam...@gmail.com] 
Sent: January-19-12 6:31 AM
To: cf-talk
Subject: Re: varScoper menu not shown in CFBUILDER


No idea than - sorry man. You could call Adobe tech support, but I'd assume
they would put the blame on the extension. If you want to hop into a Connect
room or Google Hangout, let me know.


On Wed, Jan 18, 2012 at 10:29 PM, Brook Davies cft...@logiforms.com wrote:

 Yeah, I can right click on both.. CFB2, yeah. And I see other 
 extensions, I think, like apply CF Nature...

 Brook

 -Original Message-
 From: Raymond Camden [mailto:raymondcam...@gmail.com]
 Sent: January-18-12 6:23 PM
 To: cf-talk
 Subject: Re: varScoper menu not shown in CFBUILDER


 But to be clear, you can right click on a .cfm file in the navigator, 
 just not a folder?

 CFB2?


 On Wed, Jan 18, 2012 at 5:10 PM, Brook Davies cft...@logiforms.com
wrote:

 Hi Ray,

 I do see that bit, inside of some other XML:

 application
        namevarScoper/name
        authorMike Schierberl/author
        version1.0/version
        emailm...@schierberl.com/email
        descriptionintr



 



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349546
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


varScoper menu not shown in CFBUILDER

2012-01-18 Thread Brook Davies

Does anyone else have the problem where after installing the varscoper
extension to CFbuilder, it is listed as an extension in the extensions
window but not available for use via the context menu? I can't figure out
how to run it!

 

Other extensions, installed in the same folder ARE Listed in the context
menu. Anybody else run into this?

 

Brook




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349530
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: varScoper menu not shown in CFBUILDER

2012-01-18 Thread Brook Davies

At the top level CF project folder.  It used to be there, but its not there
any more. I tried reinstalled the extension and that made no difference. I
CAN run varscoper directly however via the CFM files...

Brook

-Original Message-
From: Raymond Camden [mailto:raymondcam...@gmail.com] 
Sent: January-18-12 11:41 AM
To: cf-talk
Subject: Re: varScoper menu not shown in CFBUILDER


Are you right clicking in the navigator?
Are you right clicking on a CFM or CFC file?


On Wed, Jan 18, 2012 at 12:36 PM, Brook Davies cft...@logiforms.com wrote:

 Does anyone else have the problem where after installing the varscoper 
 extension to CFbuilder, it is listed as an extension in the extensions 
 window but not available for use via the context menu? I can't figure 
 out how to run it!



 Other extensions, installed in the same folder ARE Listed in the 
 context menu. Anybody else run into this?



 Brook




 



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349537
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: varScoper menu not shown in CFBUILDER

2012-01-18 Thread Brook Davies

Hi Ray,

I do see that bit, inside of some other XML:

application
namevarScoper/name
authorMike Schierberl/author
version1.0/version
emailm...@schierberl.com/email  
descriptionintro.html/description   
version1.30/version
licenselicense.html/license
menucontributions 
contribution target=projectview
menu name=varScoper
action name=Run varScoper handlerid=varscoper
showResponse=true
dialog height=600 width=800 /
/action
/menu
/contribution
/menucontributions
handlers  
handler id=varscoper type=CFM filename=cfbuilder.cfm
/
/handlers
/application

I actually just downloaded and installed it from riaforge aswell, so I don’t
know either why its not working. Maybe its permissions related Thanks
for taking a look!

Brook

-Original Message-
From: Raymond Camden [mailto:raymondcam...@gmail.com] 
Sent: January-18-12 1:34 PM
To: cf-talk
Subject: Re: varScoper menu not shown in CFBUILDER


Odd - I just checked - downloaded from http://varscoper.riaforge.org/,
installed, right clicked on a project root, and it showed up as an option.
Not sure what to tell you. When you look at the extension's ide_config.xml
file, do you see this?

menucontributions 
contribution target=projectview
menu name=varScoper
action name=Run varScoper handlerid=varscoper
showResponse=true
dialog height=600 width=800 /
/action
/menu
/contribution
/menucontributions

On Wed, Jan 18, 2012 at 3:30 PM, Brook Davies cft...@logiforms.com wrote:

 At the top level CF project folder.  It used to be there, but its not 
 there any more. I tried reinstalled the extension and that made no 
 difference. I CAN run varscoper directly however via the CFM files...

 Brook

 -Original Message-
 From: Raymond Camden [mailto:raymondcam...@gmail.com]
 Sent: January-18-12 11:41 AM
 To: cf-talk
 Subject: Re: varScoper menu not shown in CFBUILDER


 Are you right clicking in the navigator?
 Are you right clicking on a CFM or CFC file?


 On Wed, Jan 18, 2012 at 12:36 PM, Brook Davies cft...@logiforms.com
wrote:

 Does anyone else have the problem where after installing the 
 varscoper extension to CFbuilder, it is listed as an extension in the 
 extensions window but not available for use via the context menu? I 
 can't figure out how to run it!



 Other extensions, installed in the same folder ARE Listed in the 
 context menu. Anybody else run into this?



 Brook








 



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349540
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: varScoper menu not shown in CFBUILDER

2012-01-18 Thread Brook Davies

Yeah, I can right click on both.. CFB2, yeah. And I see other extensions, I
think, like apply CF Nature...

Brook

-Original Message-
From: Raymond Camden [mailto:raymondcam...@gmail.com] 
Sent: January-18-12 6:23 PM
To: cf-talk
Subject: Re: varScoper menu not shown in CFBUILDER


But to be clear, you can right click on a .cfm file in the navigator, just
not a folder?

CFB2?


On Wed, Jan 18, 2012 at 5:10 PM, Brook Davies cft...@logiforms.com wrote:

 Hi Ray,

 I do see that bit, inside of some other XML:

 application
        namevarScoper/name
        authorMike Schierberl/author
        version1.0/version
        emailm...@schierberl.com/email
        descriptionintr



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349542
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Can you ever allocate too much ram to the JVM

2012-01-12 Thread Brook Davies

Quick Question. On our new server we have lots of ram (32 gigs). Its running
CF 9 Standard 64 bit. Is there any downside to allocating 12 gigs of ram to
CF?

 

Brook




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349480
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Can you ever allocate too much ram to the JVM

2012-01-12 Thread Brook Davies

Thanks for the replies. I will have to review the implications of the longer
GC with more ram allocated

Brook

-Original Message-
From: Scott Stewart [mailto:webmas...@sstwebworks.com] 
Sent: January-12-12 2:26 PM
To: cf-talk
Subject: Re: Can you ever allocate too much ram to the JVM


The 64 bit version of windows will address up to a terabyte of phyisical
memory, that doesn't mean that you can throw 500 gb at the JVM...  garbage
collection creates more problems than it solves with large amounts of memory
On Jan 12, 2012 5:18 PM, Matt Quackenbush quackfu...@gmail.com wrote:


 Additionally, he is running CF9 _Standard_, which means he is limited 
 to a single CF instance.


 On Thu, Jan 12, 2012 at 4:16 PM, Matt Quackenbush 
 quackfu...@gmail.com
 wrote:

  That limit only applies to 32-bit machines. Since he is running CF9
 64-bit
  I am assuming he is also on a 64-bit machine where the limit would 
  not apply.
 
 
 
  On Thu, Jan 12, 2012 at 4:12 PM, Scott Stewart 
 webmas...@sstwebworks.comwrote:
 
 
  Yes, the practical limit is around 3gb per JVM. The advantage to 
  that
 much
  ram is being able to run alot of separate cf instances. Each with 
  its
 own
  jvm
  On Jan 12, 2012 4:41 PM, Brook Davies cft...@logiforms.com wrote:
 
  
   Quick Question. On our new server we have lots of ram (32 gigs). 
   Its running CF 9 Standard 64 bit. Is there any downside to 
   allocating 12 gigs of
  ram to
   CF?
  
  
  
   Brook
  
  
  
  
  
 
 

 



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349487
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: cftransaction isolation=repeatable_read

2011-12-14 Thread Brook Davies

Bump... Casey - is this method thread safe?

-Original Message-
From: Brook Davies [mailto:cft...@logiforms.com] 
Sent: December-13-11 10:15 PM
To: cf-talk
Subject: RE: cftransaction isolation=repeatable_read


So this would update and select the rows at the same time? Would I need to
use transaction or would this guarantee if another request for the same
query at the exact same time happened, it would not return or update the
same rows?

Brook

-Original Message-
From: Casey Dougall [mailto:ca...@uberwebsitesolutions.com]
Sent: December-13-11 6:29 PM
To: cf-talk
Subject: Re: cftransaction isolation=repeatable_read


On Tue, Dec 13, 2011 at 6:13 PM, Brook Davies cft...@logiforms.com wrote:

 I guess my question is, will this lead to performance problems? Is 
 there a more elegant way to do this?


Are you using MS SQL server? If so you only need one query which will still
output rows like the first query with OUTPUT.

  cfquery name=getEvents
   update t1
   set t1.enabled = 0
   OUTPUT inserted.ID, inserted.cfc, inserted.runMethod, inserted.arguments,
inserted.frequency, inserted.frequencytype
   from scheduledTasks t1
   inner join scheduledTasks t2
   on t1.ID = t2.ID
where t2.enabled = 1
  and t2.nextDate  cfqueryparam cfsqltype=cf_sql_timestamp
value=#createodbcdatetime(Now())#
  and t2.startDate  cfqueryparam cfsqltype=cf_sql_timestamp
value=#createodbcdatetime(Now())#
  and t2.endDate  cfqueryparam cfsqltype=cf_sql_timestamp
value=#createodbcdatetime(Now())#
  /cfquery






~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349127
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: fresh cf 9 install can't see administrator

2011-12-13 Thread Brook Davies

You can also try, running cf as the administrator account (just temporarily)
and if that works,  then at least you *know* it's a permissions problem.
Then you can work backwards from there after setting it back to a service...

Brook

-Original Message-
From: Cameron Childress [mailto:camer...@gmail.com] 
Sent: December-13-11 1:45 PM
To: cf-talk
Subject: Re: fresh cf 9 install can't see administrator


On Tue, Dec 13, 2011 at 12:14 PM, Mr. Chedder P. Slam chedders...@gmail.com
 wrote:

 apache running on VM to wwwroot in host machine


Apache is running inside a VM?  Is CF installed on the VM or the host?


 cf service running as local system account, but wwwroot has everyone 
 full access


Is CF installed as standalone?  Multiserver?

 -Cameron

--
Cameron Childress
--
p:   678.637.5072
im: cameroncf
facebook http://www.facebook.com/cameroncf |
twitterhttp://twitter.com/cameronc |
google+ https://profiles.google.com/u/0/117829379451708140985




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349089
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


cftransaction isolation=repeatable_read

2011-12-13 Thread Brook Davies

I am using cftransaction isolation=repeatable_read to single thread
access to scheduled tasks that live in a DB table.  This application spawns
multiple servers, and each server is set to poll the scheduled task table
every 3 minutes. It grabs the tasks and executes them. 

Now, if this was on one server, I could simply use a named exclusive lock to
single thread access to the tasks so that multiple servers don't pick up and
execute the same task (they should only be run once). 

What I have ended up doing is something like the code below. Basically,
within the repeatable_read transaction I also update each row that was
picked up for processing. This has the effect of causing another server who
reads the data at the same  time (before the enabled flag is set to false)
to fail. I've tested this by adding a sleep() command after the first read
and running this from two instances. One request always fails, so that is
working as I want it to.

I guess my question is, will this lead to performance problems? Is there a
more elegant way to do this?

cftransaction isolation=repeatable_read

cfquery name=getEvents datasource=#application.gs.datasource#
   Select ID,cfc,runMethod,arguments,frequency,frequencytype
   from scheduledTasks
   where enabled=1
   and nextDate  cfqueryparam cfsqltype=cf_sql_timestamp
value=#createodbcdatetime(Now())#
   and startDate  cfqueryparam cfsqltype=cf_sql_timestamp
value=#createodbcdatetime(Now())#
   and endDate  cfqueryparam cfsqltype=cf_sql_timestamp
value=#createodbcdatetime(Now())#
/cfquery

cfoutput query=getEvents
cftry
 cfquery datasource=#application.gs.datasource#
 update scheduledtasks
 set enabled=0
 where id=cfqueryparam cfsqltype=cf_sql_integer value=#id#
/cfquery

cfcatch
cfinvoke
component=#application.core.Log#
method=call
logFile=scheduledEventLauncher
log_error=Unable to update table, another server has a lock?
#cfcatch.message# #cfcatch.detail#
email=true
  cfreturn false
   /cfcatch
/cftry

/cfoutput
/cftransaction


Thanks for the input! Hopefully the above code does not get mangled..

Brook




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349090
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: cftransaction isolation=repeatable_read

2011-12-13 Thread Brook Davies

So this would update and select the rows at the same time? Would I need to
use transaction or would this guarantee if another request for the same
query at the exact same time happened, it would not return or update the
same rows?

Brook

-Original Message-
From: Casey Dougall [mailto:ca...@uberwebsitesolutions.com] 
Sent: December-13-11 6:29 PM
To: cf-talk
Subject: Re: cftransaction isolation=repeatable_read


On Tue, Dec 13, 2011 at 6:13 PM, Brook Davies cft...@logiforms.com wrote:

 I guess my question is, will this lead to performance problems? Is 
 there a more elegant way to do this?


Are you using MS SQL server? If so you only need one query which will still
output rows like the first query with OUTPUT.

  cfquery name=getEvents
   update t1
   set t1.enabled = 0
   OUTPUT inserted.ID, inserted.cfc, inserted.runMethod, inserted.arguments,
inserted.frequency, inserted.frequencytype
   from scheduledTasks t1
   inner join scheduledTasks t2
   on t1.ID = t2.ID
where t2.enabled = 1
  and t2.nextDate  cfqueryparam cfsqltype=cf_sql_timestamp
value=#createodbcdatetime(Now())#
  and t2.startDate  cfqueryparam cfsqltype=cf_sql_timestamp
value=#createodbcdatetime(Now())#
  and t2.endDate  cfqueryparam cfsqltype=cf_sql_timestamp
value=#createodbcdatetime(Now())#
  /cfquery




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349092
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Changing Application settings at runtime

2011-12-06 Thread Brook Davies

What I ended up doing was just setting a flag in  the request scope when I
need to fallback to an alternate SMTP server. I just set request.toggleSMTP
= true and then in the onRequestEnd() method, I check for that flag and do
the processing to update this.smtpserversettings   to an available server.
This works... 

I load so much crap into the app scope, that I don't want to re-initialize
the application!!

Brook

-Original Message-
From: Judah McAuley [mailto:ju...@wiredotter.com] 
Sent: December-06-11 9:31 AM
To: cf-talk
Subject: Re: Changing Application settings at runtime


In CF9, there is the ApplicationStop() method which will restart the
application on the next request, thus reinitializing the application scope.

Ben Nadel wrote up an investigation of this awhile back:
http://www.bennadel.com/blog/1667-Learning-ColdFusion-9-Resetting-Applicatio
ns-With-ApplicationStop-.htm

One thing to note is that calling ApplicationStop() does not reset the
Session scope. This could be viewed as either a bug or a feature.

So if you are ok with restarting the application while leaving the session
scope in place, I'd place the smtpserversettings in your
OnApplicationStart() method and make a call to whatever service you have
that knows what the currently valid server settings should be.

Of course you still have to figure out how to trigger the fact that you need
to reset the application because of a downed smtp server.

Hope this helps,
Judah

On Mon, Dec 5, 2011 at 5:30 PM, Brook Davies br...@logiforms.com wrote:

 So I have something like this at the top of application.cfc:

 cfset this.smtpserversettings   = {
  server=mail.yourmama.com,
  username=b...@yourmama.com,
  password=issofat
 }

 But I want to be able to change these settings when I (somehow) detect 
 that the server is down. From what I have read the only way to do this 
 would in onRequestStart or onRequestEnd. So I can set up a request 
 scoped flag that triggers the update, fine, but is that really the 
 only way? Is there no way to call a method of application.cfc within the
scope of the application?

 Broo



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348983
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Is the CF scheduler Reliable?

2011-12-05 Thread Brook Davies

How reliable is the CF Scheduler? For years we have used the infusion
mailserver and its Infusion Scheduler App/Service. Its always worked great
but since that product is dead/no longer supported, we need to find a new
way of running scheduled tasks and adding/removing scheduled task
programmatically.  In the past I have seen lots of posts about the built in
scheduler being unreliable. 

 

What I need to know is can the built in scheduler be used reliably for
mission critical applications?

 

Thanks for your input!

 

Brook

 




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348954
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Is the CF scheduler Reliable?

2011-12-05 Thread Brook Davies

Thank you for the replies. Full steam ahead with CF Scheduler. Kym, it's a
shame Infusion just vanished into thin air eh? I mean WTF? I loved their
software! 

Briook

-Original Message-
From: Kym Kovan [mailto:dev-li...@mbcomms.net.au] 
Sent: December-05-11 3:50 PM
To: cf-talk
Subject: Re: Is the CF scheduler Reliable?


On 6/12/2011 10:25, Brook Davies wrote:

 How reliable is the CF Scheduler? For years we have used the infusion 
 mailserver and its Infusion Scheduler App/Service. Its always worked 
 great but since that product is dead/no longer supported, we need to 
 find a new way of running scheduled tasks and adding/removing 
 scheduled task programmatically.  In the past I have seen lots of 
 posts about the built in scheduler being unreliable.

We have no issues with the scheduler and we had the same problem as you
being iMS junkies. Set a schedule to run every minute and one second and
call the same page that you were calling with your iMS scheduler and it can
sort out what really needs to run.


BTW, if you are using Railo it can schedule tasks in seconds not minutes.
Useful sometimes.


-- 
Yours,

Kym Kovan
mbcomms.net.au





~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348958
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Changing Application settings at runtime

2011-12-05 Thread Brook Davies

So I have something like this at the top of application.cfc:

cfset this.smtpserversettings   = {
  server=mail.yourmama.com,
  username=b...@yourmama.com,
  password=issofat
}

But I want to be able to change these settings when I (somehow) detect that
the server is down. From what I have read the only way to do this would in
onRequestStart or onRequestEnd. So I can set up a request scoped flag that
triggers the update, fine, but is that really the only way? Is there no way
to call a method of application.cfc within the scope of the application?

Brook



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348959
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Is CFMAIL reliable??

2011-12-05 Thread Brook Davies

Hi Guys (and girls),

 

You may notice a trend in my postings! Moving away from infusion (long over
due) and looking at Native CF functions instead. So now I am looking at
CFMAIL and in the past know it has been a bit dodgy. There is a conversation
here about restarting the spooling service:

 

http://www.mail-archive.com/cf-talk@houseoffusion.com/msg342750.html

 

And Ben Nadel talks about monitoring the undeliverable folder and how the
spooler just occasionally stops working. 

http://www.bennadel.com/blog/1893-Monitoring-The-ColdFusion-Mail-Server-With
-GMail-And-A-Scheduled-Task.htm

 

The comments attest to this being an issue for a lot of people. So I guess
the question is, has this been resolved or is it necessary  to implement all
of these hacks to keep CFMAIL running well?

 

Brook




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348960
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


getPageContext() in onRequestEnd is empty?

2011-11-10 Thread Brook Davies

I run some metric updating code in onRequestEnd. In certain cases, I want to
show a message if the metric update fails. I want to replace what is already
in the output buffer. I am trying this in onRequest end:

cfset pageContent = getPageContext().getOut().getString()
cfset getPageContext().getOut().clearBuffer()
cfset pageContent = hello!
cfset writeOutput(pageContent)
cfset getPageContext().getOut().flush()

But the original HTML is still outputted and my message is not. If I dump
the getOut() result it is an empty string. I am not using CFFLUSH anywhere,
so why would the HTML already by written from the buffer in onRequestEnd?

Brook





~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348582
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Check for list of words in string

2011-10-11 Thread Brook Davies

Wouldn't this also catch words like 'myselection'?

Brook

-Original Message-
From: Matt Quackenbush [mailto:quackfu...@gmail.com] 
Sent: October-11-11 7:16 AM
To: cf-talk
Subject: Re: Check for list of words in string


Regular expressions.

if ( reFindNoCase((select|declare),myString)  0 ) {
 // at least one of the words is present }

HTH


On Tue, Oct 11, 2011 at 9:11 AM, Brian Cain bcc9...@gmail.com wrote:


 Hello all,

 I would like to check a string against a list of keywords and either 
 null the string or replace the keywords if found.

 Over the past couple of weeks someone has been probing my sites for 
 SQL injection vulnerabilities.  I have used queryparams and other 
 types of validation. but I fear I may have missed something.  I am 
 using an old version of formurl2attributes that has been modified over 
 the years.  My thought is to check the attributes list at the end of 
 the custom tag, and look for some of the common SQL injection keywords 
 there and mitigate their effectiveness.

 So in short, how do I search for keywords like select,declare in a 
 string without looping over the keywords?

 Thanks,
 Brian Cain

 



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348053
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Count rows in Excel file

2011-10-11 Thread Brook Davies

Hey Everyone,

 

Anyone know a way to count the rows in an excel file without using
cfspreadsheet to read the entire file in first? That's what I am trying to
avoid..

 

Brook




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348055
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


(ot) Awesome Eclipse Shortcut

2011-09-30 Thread Brook Davies

I know its OT, and most of you probably already know it, but this shortcut
saves me so much time, and I'm such a geek, that I had to post it:

 

CTRL + SHIFT + R - then hit Enter

 

Type a few characters of the name of the file your looking for, boom, hit
enter to open it. Or if you highlight the name of a component or an include
in your code (assuming the filename is similar or the same) and hit the
shortcut it will select that file by default. Awesome to find that CFC or
include that is buried deep somewhere.. 

 

Saves me so much time. 

 

Brook

 

 




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347860
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Way OT - Technical Writing

2011-09-26 Thread Brook Davies

Sorry for the way OT post. But I am going crazy trying to find a good
technical writer to write a user guide for our CF web app. I've gone through
a few people already. They keep writing stuff that seems to make the topics
MORE difficult. I think I would pull my hair out trying to use what they are
writing.

 

I suspect the people on this list have had to hire technical writers at one
point or another. Does anyone have a good technical writer they use for
projects that they want to refer to me???  I would be so grateful. 



Brook

 




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347697
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Linkpoint Web Service API

2011-09-06 Thread Brook Davies

I'm in the same boat over the next 1-2 months and would pay you for a CFC
that did all the heavy lifting. Its not likely that complex, but I don't
have the time right now...

Brook

-Original Message-
From: Justin Scott [mailto:leviat...@darktech.org] 
Sent: September-06-11 1:32 PM
To: cf-talk
Subject: Re: Linkpoint Web Service API


 Does anyone have any experience with Linkpoint Web Services?   I 
 installed 64bit CF9 and found that the DLL COM call does not work.  I 
 need to reprogam to use WebServices instead.

I don't yet, but I have one project that is using LinkPoint's old COM object
to handle payments and another one in the works which will need to talk to
LinkPoint as well in the next couple of months.  I'll likely be rewriting
our interface for that project and applying it to the older one as well.  If
you find something already built that works with their newer model, or hire
someone to build it (I see your post on cf-jobs as well), I'd be interested
in anything you find or potentially purchasing a copy of the one you have
built if you hire it out as it would save me some time as well.


-Just



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347264
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: CFHTTP, DNS Caching, and CF 9 won't behave.

2011-09-02 Thread Brook Davies

Is it an HTTPS connection? Have you added  their cert to the Java KeyStore?

Brook

-Original Message-
From: Eric Cobb [mailto:cft...@ecartech.com] 
Sent: September-02-11 12:00 PM
To: cf-talk
Subject: CFHTTP, DNS Caching, and CF 9 won't behave.


So, I'm having a problem with CFHTTP caching DNS and not wanting to update. 
 Basically, a vendor updated their API yesterday and now all CFHTTP calls to
the url give a Connection Failure error, even though you can pull the url
up in a browser (from the server) and it works fine.  I've already gone
through the suggestions in the following posts:

http://www.talkingtree.com/blog/index.cfm/2006/5/23/Configuring-the-Caching-
of-Hostname-Resolution-for-ColdFusion-MX
http://dcooper.org/blog/client/index.cfm?mode=entryentry=B322459B-D872-DC1E
-6F2424DDC66215E6
http://www.coldfusionmuse.com/index.cfm/2008/10/9/cfhttp-troubleshooting
http://www.coldfusionmuse.com/index.cfm/2009/1/28/cfhttp.dns.restart

and it doesn't seem to work.  I've changed every java.security file I can
find on my machine, restarted all CF services, even rebooted twice and the
cache doesn't clear.  

I'm running CF 9 on Windows 7 64-bit.  

Any suggestions?





~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347187
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


(ot) Stopping Railo via an ANT task

2011-08-19 Thread Brook Davies

Sorry for the OT post, I'm stuck on this.

Trying to get Railo Express to stop via an ANT task. The java code is the
same as in stop.bat. Note, calling stop.bat directly is not working for me
either.

target name=stopRailo description=Stopping Railo Server
echo message=Stoping Railo../

java jar=tools/build/railo/lib/start.jar
   dir=tools/build/railo/
fork=true
   failonerror=true
arg value=-DSTOP.PORT=8887/
arg value=-DSTOP.KEY=railo/
   arg value=--stop/
/java

echo message=Railo Stopped../
/target

I get this error, and can still connect to localhost:

 [java] java.net.ConnectException: Connection refused: connect
 [java] at java.net.PlainSocketImpl.socketConnect(Native Method)
 [java] at
java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
 [java] at
java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
 [java] at
java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
 [java] at
java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
 [java] at java.net.Socket.connect(Socket.java:525)
 [java] at java.net.Socket.connect(Socket.java:475)
 [java] at java.net.Socket.init(Socket.java:372)
 [java] at java.net.Socket.init(Socket.java:215)
 [java] at org.eclipse.jetty.start.Main.stop(Main.java:1096)
 [java] at
org.eclipse.jetty.start.Main.parseCommandLine(Main.java:136)
 [java] at org.eclipse.jetty.start.Main.main(Main.java:81)
 [java] Usage: java -jar start.jar [options] [properties] [configs]
 [java]java -jar start.jar --help  # for more information

I can't get it to stop no matter what I try...

Brook



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346866
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: (ot) Stopping Railo via an ANT task (SOLVED)

2011-08-19 Thread Brook Davies

It looks like I had somehow spawned multiple processes and they were not
getting stopped correctly. I think this happened when a build failed. Please
disregard..

Brook

-Original Message-
From: Brook Davies [mailto:br...@logiforms.com] 
Sent: August-19-11 1:08 PM
To: cf-talk
Subject: (ot) Stopping Railo via an ANT task


Sorry for the OT post, I'm stuck on this.

Trying to get Railo Express to stop via an ANT task. The java code is the
same as in stop.bat. Note, calling stop.bat directly is not working for me
either.

target name=stopRailo description=Stopping Railo Server echo
message=Stoping Railo../

java jar=tools/build/railo/lib/start.jar
   dir=tools/build/railo/
fork=true
   failonerror=true
arg value=-DSTOP.PORT=8887/
arg value=-DSTOP.KEY=railo/
   arg value=--stop/
/java

echo message=Railo Stopped../
/target

I get this error, and can still connect to localhost:

 [java] java.net.ConnectException: Connection refused: connect
 [java] at java.net.PlainSocketImpl.socketConnect(Native Method)
 [java] at
java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
 [java] at
java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
 [java] at
java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
 [java] at
java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
 [java] at java.net.Socket.connect(Socket.java:525)
 [java] at java.net.Socket.connect(Socket.java:475)
 [java] at java.net.Socket.init(Socket.java:372)
 [java] at java.net.Socket.init(Socket.java:215)
 [java] at org.eclipse.jetty.start.Main.stop(Main.java:1096)
 [java] at
org.eclipse.jetty.start.Main.parseCommandLine(Main.java:136)
 [java] at org.eclipse.jetty.start.Main.main(Main.java:81)
 [java] Usage: java -jar start.jar [options] [properties] [configs]
 [java]java -jar start.jar --help  # for more information

I can't get it to stop no matter what I try...

Brook





~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346870
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: coldfusion spreadsheet leading zeroes issue

2011-08-16 Thread Brook Davies

This is an excel issue, not a CF issue. If you set the data type of the
column to text it does not happen..

http://www.google.ca/search?hl=enclient=firefox-ahs=vpOrls=org.mozilla%3A
en-GB%3Aofficialbiw=1920bih=1084q=excel+truncates+leading+zerobtnG=Searc
hoq=excel+truncates+leading+zeroaq=faqi=aql=gs_sm=sgs_upl=0l0l0l18408l
0l0l0l0l0l0l0l0ll0l0

Brook

-Original Message-
From: fun and learning [mailto:funandlrnn...@gmail.com] 
Sent: August-16-11 10:35 AM
To: cf-talk
Subject: coldfusion spreadsheet leading zeroes issue


Hi All -

I am facing an issue with coldfusion9 spreadsheet functions. It cuts of
leading zeroes. This is what I am trying. I am getting array of data and
using spreadsheetaddrows. When I am constructing an array, am using quotes
so as to preserve the zeroes but with no effect. Adding some characters like
~ helps. But when I am adding space, coldfusion is not preserving the
spaces. Is there a better way to handle this issue?

Thanks 



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346790
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Setting client variable datasource via config.xml

2011-08-12 Thread Brook Davies

Good Solution, thanks!

-Original Message-
From: Brian Kotek [mailto:brian...@gmail.com] 
Sent: August-11-11 9:47 PM
To: cf-talk
Subject: Re: Setting client variable datasource via config.xml


Right, set up a function that you call to get the variables, and have it
read the XML the first time, and on any subsequent calls just use the XML
already loaded rather than load it again.


On Fri, Aug 12, 2011 at 12:17 AM, Matt Quackenbush
quackfu...@gmail.comwrote:


 No, you cannot do

 cfset this.clientStorage = application.gs.clientVarDataSource /

 You might get away with that after the application has already been 
 init'd, but even then it would be a false positive and would stop 
 working as soon as the application timed out or the application server 
 was restarted.
  However,
 you *can* do something like so:

 this.clientStorage = getClientStorageDatasource();

 function getClientStorageDatasource()
 {
 // read your xml file and extract the variable
 return theDatasource;
 }

 HTH


 On Thu, Aug 11, 2011 at 10:57 PM, Brook Davies cft...@logiforms.com
 wrote:

 
  But can you set this.clientstorage that way? Because It seems 
  setting
 that
  property within onRequestStart() does not work. In my requestStart 
  method
 I
  call another method which sets a client var. If I set the 
  this.client[(storage|Management|etc] in the onRequestStart, I get an
 error
  that the client scope is not enabled when I try to set a client var 
  in a method called from there.
 
  Sorry to be using client variables Nathan :(
 
  Brook
 
  -Original Message-
  From: Russ Michaels [mailto:r...@michaels.me.uk]
  Sent: August-11-11 5:45 PM
  To: cf-talk
  Subject: Re: Setting client variable datasource via config.xml
 
 
  I used to have this issue as well, you obviously cannot read read 
  app
 vars
  that do not exist yet and you cannot create them until the 
  application scope is initialised.
  The way I got round this is to have 2 XML files.
  One that contains the init variables that need to exist before the 
  application scope is initialised, and I load these into request 
  scope onapplicationstart. Once this is done, I then load the global 
  config into the application scope.
 
 
 
  On Thu, Aug 11, 2011 at 11:06 PM, Brook Davies 
  cft...@logiforms.com
  wrote:
 
  
   I'm trying to set all my apps properties via a config file to make 
   deployment between dev, production servers easy. Problem is the 
   application vars that are read via onApplicationStart() are not 
   available within the opening part of the application.cfc and when 
   I try to set these properties inside onRequestStart() they do not
work.
   Should I be able to set these in onRequestsStart()?
  
  
  
   cfcomponent output=false extends=coldfireApplication
  
  
  
  cfset this.clientManagement= true
  
  cfset this.setClientCookies= true
  
  cfset this.setDomainCookies= false
  
  cfset this.clientStorage   =
 application.gs.clientVarDataSource
  
  
  
  
  
  
  
 
 
 
 

 



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346723
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: CFGRID strange behaviour in Production Server (Windows 2000 + ISS)

2011-08-11 Thread Brook Davies

Steve's right, if you have unescaped HTML inside the grid (in the data),
then it can cause the grid display to be wonky.

Brook

-Original Message-
From: Steve 'Cutter' Blades [mailto:cold.fus...@cutterscrossing.com] 
Sent: August-11-11 10:28 AM
To: cf-talk
Subject: Re: CFGRID strange behaviour in Production Server (Windows 2000 +
ISS)


No, you can't update Ext on the server. You could write a straight Ext
implementation, skipping the cfajax components all together. Or, it could be
a data issue, where something in the data is breaking cfgrid's js. If you're
server versions, hotfix levels, etc are all the same then it should just
work.

Steve 'Cutter' Blades
Adobe Community Professional
Adobe Certified Expert
Advanced Macromedia ColdFusion MX 7 Developer 
http://blog.cutterscrossing.com


Co-Author Learning Ext JS 3.2 Packt Publishing 2010
https://www.packtpub.com/learning-ext-js-3-2-for-building-dynamic-desktop-st
yle-user-interfaces/book

The best way to predict the future is to help create it


On 8/11/2011 1:18 PM, Luiz Milfont wrote:
 Could it be an EXT issue? Is there any way to update EXT on production
server? I ask this, because my CFGRID component uses EXT.

 



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346709
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Setting client variable datasource via config.xml

2011-08-11 Thread Brook Davies

I'm trying to set all my apps properties via a config file to make
deployment between dev, production servers easy. Problem is the application
vars that are read via onApplicationStart() are not available within the
opening part of the application.cfc and when I try to set these properties
inside onRequestStart() they do not work. Should I be able to set these in
onRequestsStart()?

 

cfcomponent output=false extends=coldfireApplication



cfset this.clientManagement= true

cfset this.setClientCookies= true

cfset this.setDomainCookies= false

cfset this.clientStorage   = application.gs.clientVarDataSource

 

..

 

 




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346710
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Setting client variable datasource via config.xml

2011-08-11 Thread Brook Davies

I'm trying to set all my apps properties via a config file to make
deployment between dev, production servers easy. Problem is the application
vars that are read via onApplicationStart() are not available within the
opening part of the application.cfc and when I try to set these properties
inside onRequestStart() they do not work. Should I be able to set these in
onRequestsStart()?

 

cfcomponent output=false extends=coldfireApplication



cfset this.clientManagement= true

cfset this.setClientCookies= true

cfset this.setDomainCookies= false

cfset this.clientStorage   = application.gs.clientVarDataSource

 




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346711
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Setting client variable datasource via config.xml

2011-08-11 Thread Brook Davies

But can you set this.clientstorage that way? Because It seems setting that
property within onRequestStart() does not work. In my requestStart method I
call another method which sets a client var. If I set the
this.client[(storage|Management|etc] in the onRequestStart, I get an error
that the client scope is not enabled when I try to set a client var in a
method called from there. 

Sorry to be using client variables Nathan :(

Brook

-Original Message-
From: Russ Michaels [mailto:r...@michaels.me.uk] 
Sent: August-11-11 5:45 PM
To: cf-talk
Subject: Re: Setting client variable datasource via config.xml


I used to have this issue as well, you obviously cannot read read app vars
that do not exist yet and you cannot create them until the application scope
is initialised.
The way I got round this is to have 2 XML files.
One that contains the init variables that need to exist before the
application scope is initialised, and I load these into request scope
onapplicationstart. Once this is done, I then load the global config into
the application scope.



On Thu, Aug 11, 2011 at 11:06 PM, Brook Davies cft...@logiforms.com wrote:


 I'm trying to set all my apps properties via a config file to make 
 deployment between dev, production servers easy. Problem is the 
 application vars that are read via onApplicationStart() are not 
 available within the opening part of the application.cfc and when I 
 try to set these properties inside onRequestStart() they do not work. 
 Should I be able to set these in onRequestsStart()?



 cfcomponent output=false extends=coldfireApplication



cfset this.clientManagement= true

cfset this.setClientCookies= true

cfset this.setDomainCookies= false

cfset this.clientStorage   = application.gs.clientVarDataSource






 



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346713
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Run a class file generated with CF outside of CF

2011-08-07 Thread Brook Davies

Hey Nathan,

So what I was doing was this. I am working on a new web app written with
extJS. I have a CFC that I call that builds the client side app. It reads
all of the ux and util directories and generates a config file used by
jsBuilder to compress, combine and minify the JS used on the client side as
well as compress and move CSS and resources.

I am working towards getting a CI server setup and also need to ensure all
developers can run a build locally. That's where the problem arises. The
developers (JS developers) will not have CF installed on their local machine
(or our pre-configured EC2 instance), and so I need to move the process of
generating the jsBuilder config and executing it out of CF and into
something that can run on any developers workstation - without a big install
and setup. 

Since its just 1 CFC, I thought I could just use the java classes. But of
course there are dependencies.

I found a wicked, super cool solution to this last night! I downloaded Ralio
Express and was able to get it to execute my CFC with basically zero setup.
Ralio Express is freakin  awesome! There's no installer, you just run
start.bat to start the server and stop.bat to stop it. So I've added it to
my SVN and written an ANT task that starts it up and then runs the CFC that
indexes all the directories, read in an XML config file and calls (via
cfexcecute) the CFC that handles the build.

My ANT task has these targets:

target name=startRalio description=Starting Ralio Server
depends=MakeDirectories
java jar=tools/build/ralio/lib/start.jar
   dir=tools/build/ralio/
   fork=true
   spawn=true
   maxmemory=512M
arg value=-h/
arg value=-DSTOP.PORT=8887/
arg value=-DSTOP.KEY=railo/
/java

!-- wait for server to start up --
waitfor maxwait=10 maxwaitunit=second
and
socket server=localhost port=/
http url=http://localhost:/index.cfm/
/and
/waitfor


/target

target name=doBuild description=Call the Ralio script to in turn
call JsBuilder and do compilation depends=startRalio
get src=http://localhost:/build/doBuild.cfm;
dest=buildresult.txt /

!-- look for buildresult.txt, read the result and throw an
error if any errors exist --
 loadfile property=buildresult
srcFile=${desktop.build.dir}buildresult.html/
 echo message=${buildresult}/

 antcall target=checkResult /   
 antcall target=stopRalio /
/target


Never used Ralio before, but very impressed with it!

Brook

-Original Message-
From: Nathan Strutz [mailto:str...@gmail.com] 
Sent: August-06-11 12:39 PM
To: cf-talk
Subject: Re: Run a class file generated with CF outside of CF


Yeah, it's probably not going to happen. I mean, I am getting famous for
saying that it's software, so we can do anything, but the problem is the
amount of work it takes to do a thing. In this case you have to load a good
amount of the CF server into memory, all the other related classes (one
..class for the cfc, one for each cffunction, etc.), then fake a request 
response object, or whatever servlets do (I knew at one point). Your best
bet is to not do this.

It would be much easier to call your CF server rather than try to use the
generated code out of context. There are many ways to call into CF from
Java. The easiest one would be to hit it via a HTTP URI. Second easiest
would be a web service. Third, you can use the CF services gateway - you can
set up a local socket listener, which should be really performant. Also, I
think Terrence Ryan had a project on RIAForge that lets you call it via the
command line console.

I wonder, what is the underlying reason for wanting to call the generated
classes? Sort of an odd request. Why are you doing this? Maybe there's a
better way to accomplish your end goal.

nathan strutz
[www.dopefly.com] [hi.im/nathanstrutz] [about.me/nathanstrutz]


On Sat, Aug 6, 2011 at 10:53 AM, Brook Davies cft...@logiforms.com wrote:


 Hey, I don't know if this is possible. I want to take a class file 
 from the cfclasses/ directory and run it from the command line outside 
 of the CF server.  It complains about not being able to find some cf
related classes.
 I assume this is not at all possible since the classes include lots of 
 CF specific classes for various functions. Is that right? Is this not 
 possible?



 Brook




 



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346567

RE: Run a class file generated with CF outside of CF

2011-08-07 Thread Brook Davies

Sean,

Re: Railo from  the command line
That's sounds very cool and will be very useful.

Nathan,

Yeah, I know its kinda nuts to do all that just to run one CFC. But it is a
pretty big CFC and it does a lot including reading in and parsing XML config
files that are used by the application, and indexing directories etc.  While
I would agree it would be better to keep it all inside ANT without the
dependency on Railo (thank Peter!), the main factor for me was
implementation time. I'm already behind schedule and no time to re-write
this code - so using Railo was the fastest solution. It has the added
benefit that it is leveraging some existing CFML and plus, CFML scripting is
where I am strongest (that and JS..), so it made sense.

I think if I had the time I would have done it all in ANT. What you said
about using Rhino sounds very promising. 

Brook 

-Original Message-
From: Sean Corfield [mailto:seancorfi...@gmail.com] 
Sent: August-07-11 6:22 PM
To: cf-talk
Subject: Re: Run a class file generated with CF outside of CF


FWIW, Railo 4.0 will make this even easier by allowing CFML to be executed
directly from the command line (or ant) without needing a server running at
all. This will effectively make CFML a general purpose scripting language
that can be used outside the servlet container!

Builds of 4.0 are currently pre-alpha and undergoing testing in-house. Once
Railo 3.3 goes gold (should happen around the end of this month), that will
become the stable release and 4.0 will appear on the development builds /
bleeding edge provider.

Sean

On Sun, Aug 7, 2011 at 6:37 AM, Brook Davies cft...@logiforms.com wrote:

 I found a wicked, super cool solution to this last night! I downloaded 
 Ralio Express and was able to get it to execute my CFC with basically 
 zero setup.
 Ralio Express is freakin  awesome! There's no installer, you just run 
 start.bat to start the server and stop.bat to stop it. So I've added 
 it to my SVN and written an ANT task that starts it up and then runs 
 the CFC that indexes all the directories, read in an XML config file 
 and calls (via
 cfexcecute) the CFC that handles the build.






~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346580
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


  1   2   3   4   5   6   7   8   9   10   >