RE: Anyone going to Webmaniacs next week?

[Ryan, Terrence]

I'm going to.  I'm doing a session on using SQLite in AIR (HTML and Javascript.)

Terrence Ryan
I.T. Director
Wharton Computing and Information Technology
E-mail: [EMAIL PROTECTED]


-Original Message-
From: Michael Brennan-White [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 14, 2008 12:07 PM
To: CF-Talk
Subject: Re: Anyone going to Webmaniacs next week?

I am going.  Very excited as it is my first CF conference.

>> Myself and two of my coworkers are going to be at Webmaniacs
>> next week. I'm just wondering if any of you are planning on
>> attending.
>
>I'll be there, of course.
>
>Dave Watts, CTO, Fig Leaf Software
>http://www.figleaf.com/
>
>Fig Leaf Training: Adobe/Google/Paperthin Certified Partners
>http://training.figleaf.com/
>
>WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers!
>http://www.webmaniacsconference.com/



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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

RE: ColdFusion: Some People Just Don't Know Any Better

[Ryan, Terrence]

I feel the desire to jump in and defend Adam here.  

It's definitely a different tone the we're used to.  But we talk about how 
ColdFusion gets bashed on Digg and it isn't attracting new developers.  Having 
someone who speaks in the same tone as those audiences isn't a bad thing.  If 
you want gravitas and decorum - Ben's not going anywhere. But Adam opens up the 
community to a new audience in my humble opinion, and that's a good thing. 


Gerald Guido [EMAIL PROTECTED] said 
>Personally I do not want an "Evangelist" for my stack of choice who uses
>terms like "PHP and open sores fanboys" in the about section of his blog.

>Nothing personal, and I am all for free expression, and I am sure he is very
>good at what he does etc., but I don't want a person with that sort of
>sophomoric mentality being a spokesperson for a technology I have spent
>years mastering. Especially in the Enterprise.

>It doesn't give me warm fuzzies.

Terrence Ryan
I.T. Director
Wharton Computing and Information Technology   
E-mail:     [EMAIL PROTECTED]



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

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

RE: CFExchange Permission Problems

[Ryan, Terrence]

Basically, do the logs give a reason for the denial?

As for the service account, you can pass in a username/password AND a mailbox. 
The username doesn't have the username for the mailbox owner.  As long as the 
service account has permissions for the mailbox, then it should work. 

What kind of filtering do you want? 

Terrence Ryan
I.T. Director
Wharton Computing and Information Technology   
E-mail:     [EMAIL PROTECTED]



-Original Message-
From: Sehlmeyer, Jason [mailto:[EMAIL PROTECTED] 
Sent: Thursday, February 07, 2008 9:21 AM
To: CF-Talk
Subject: RE: CFExchange Permission Problems

I do have access to the logs, let me know specifically what you're looking for 
and where and I can find it.

I'm using the users' credentials to login to the mailbox.  If I could use a 
single service account and just tell it which mailbox to look in that would 
work better, any suggestions on how to filter this scenario?


Jason
[EMAIL PROTECTED]

-Original Message-
From: Ryan, Terrence [mailto:[EMAIL PROTECTED] 
Sent: Thursday, February 07, 2008 8:00 AM
To: CF-Talk
Subject: RE: CFExchange Permission Problems

Do you have access to the exchange logs?

Also, are you using a service account, or the user's actual credentials?

Terrence Ryan
I.T. Director
Wharton Computing and Information Technology   
E-mail:     [EMAIL PROTECTED]


-Original Message-
From: Sehlmeyer, Jason [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, February 06, 2008 2:39 PM
To: CF-Talk
Subject: CFExchange Permission Problems

Any Idea why all of my users can access their mailbox by using a
cfexchange connection except one?

 

I can OWA with the name/password that is used in the connection string
and everything works fine, but Coldfusion complains of invalid access
when trying to access the users.

 

Access to the Exchange server denied. 

Ensure that the user name and password are correct.

 

  

 



 




  

 

Jason

[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> 

 









~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

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

RE: CFExchange Permission Problems

[Ryan, Terrence]

Do you have access to the exchange logs?

Also, are you using a service account, or the user's actual credentials?

Terrence Ryan
I.T. Director
Wharton Computing and Information Technology   
E-mail:     [EMAIL PROTECTED]


-Original Message-
From: Sehlmeyer, Jason [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, February 06, 2008 2:39 PM
To: CF-Talk
Subject: CFExchange Permission Problems

Any Idea why all of my users can access their mailbox by using a
cfexchange connection except one?

 

I can OWA with the name/password that is used in the connection string
and everything works fine, but Coldfusion complains of invalid access
when trying to access the users.

 

Access to the Exchange server denied. 

Ensure that the user name and password are correct.

 

  

 



 




  

 

Jason

[EMAIL PROTECTED]  

 





~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

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

RE: Adobe ColdFusion IDE survey

[Ryan, Terrence]

I got the sense talking to some Adobe people at Max that a large chuck of 
customers were clamoring for an IDE.  I would seem that the group of customers 
that don't participate in the community, (that vast majority) but that Adobe 
reaches out to through sales and support, want this.  

I was originally very opposed to the idea, mostly because I felt it was a waste 
of resources that they could be putting to CFVideo, or CFAir. But since part of 
ColdFusion continued health depends on keeping large numbers of paying 
customers happy, the IDE does sound like a smart move for them.  



Terrence Ryan
I.T. Director
Wharton Computing and Information Technology   
E-mail:     [EMAIL PROTECTED]


-Original Message-
From: Todd [mailto:[EMAIL PROTECTED] 
Sent: Monday, January 07, 2008 12:07 PM
To: CF-Talk
Subject: Re: Adobe ColdFusion IDE survey

Tom, I'm sorry, are you implying that CFStudio was more than HomeSite
"dressed up"?

CFS wasn't an IDE either, it was an HTML Editor (called HomeSite) with some
CFML widgits tacked on.

Don't get me wrong.  I'm _GLAD_ Adobe is taking customer requests seriously
(no, really!)... I guess I'm surprised that a IDE is at the top of the list
of "serious issues."  That being said, maybe clarification should have been
"IDE for *nix" or something.  Just seems weird that anyone would think about
reinventing the wheel when the wheel has already been made and rolling for
some time with and without Adobe official stamp on it (I'm speaking of
DW/CFEclipse).

On Jan 7, 2008 11:52 AM, Tom Chiverton <[EMAIL PROTECTED]> wrote:

> On Monday 07 Jan 2008, Todd wrote:
> > fix issues inside of DW.
>
> Like you, I'd rather they had offical support (like, payed developers) for
> CFE.
> DW isn't a ColdFusion IDE, it's an HTML editor with some CFML widgits
> tacked
> on. When there was Studio, this was fine, because 'serious' CFML coders
> could
> just use that. Now though, it's CFE or a generic code editor with a
> community
> syntax template.
>
> It also doesn't run (natively) on Linux - this is a show stopper for us,
> as
> our desktops are 'nix.
>
>




~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

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

RE: To AIR or not to AIR?

[Ryan, Terrence]

You can also package any CF-rendered HTML and javascript into an AIR 
application. So in that way, you can use ColdFusion to create an Air 
Application. 

http://www.forta.com/blog/index.cfm/2007/11/8/Converting-ColdFusion-Web-Apps-To-AIR-Apps
http://www.numtopia.com/terry/blog/archives/2007/11/cf_air_compiler.cfm
http://cfair.riaforge.org/


Terrence Ryan
I.T. Director
Wharton Computing and Information Technology   
E-mail:     [EMAIL PROTECTED]


-Original Message-
From: James Holmes [mailto:[EMAIL PROTECTED] 
Sent: Friday, December 14, 2007 6:13 PM
To: CF-Talk
Subject: Re: To AIR or not to AIR?

Remember that one can use a live CF rendered page directly within an
HTML based AIR app just by using an iframe in the AIR app. In this
use, the AIR runtime becomes a browser.

On Dec 15, 2007 1:23 AM, Brad Wood <[EMAIL PROTECTED]> wrote:

>
> The only connection HTML or Flash would have in the context of a web
> page, is that the HTML/swf is requested from the server and CF might
> have controlled what HTML or swf the server returned.  AIR apps don't
> request their pages from the server-- they are predetermined and
> compiled into the app, AIR simply populates the interfaces it has with
> data retrieved via it's web service calls.


-- 
mxAjax / CFAjax docs and other useful articles:
http://www.bifrost.com.au/blog/



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

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

RE: Trouble Using Exchange Tags

[Ryan, Terrence]

Okay, so you have to use https, that explains perfectly why you can't do it 
with http. Let me try again.  

Taking another look at the error message, it looks to me like the certificate 
on the exchange server isn't properly installed on the ColdFusion box.

Do a search for "cacerts" 

If you are using a single instance of ColdFusion it should be in 
ColdfusionDir/runtime/jre/lib/security, 

If you are using Jrun it should be in
Jrun/jre/lib/security

Make sure the date on the file matches when you used the keytool.  If not you 
could be experiencing the same problem I was in this post: 
http://www.numtopia.com/terry/blog/archives/2006/07/importing_ssl_certificates_with_keytool_finally.cfm




Terrence Ryan
I.T. Director
Wharton Computing and Information Technology   
E-mail:     [EMAIL PROTECTED]

~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs wiki.
http://labs/adobe.com/wiki/index.php/ColdFusion_8

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

RE: Trouble Using Exchange Tags

[Ryan, Terrence]

Okay, so you have to use https, that explains perfectly why you can't do it 
with http. Let me try again.  

Taking another look at the error message, it looks to me like the certificate 
on the exchange server isn't properly installed on the ColdFusion box.

Do a search for "cacerts" 

If you are using a single instance of ColdFusion it should be in 
ColdfusionDir/runtime/jre/lib/security, 

If you are using Jrun it should be in
Jrun/jre/lib/security

Make sure the date on the file matches when you used the keytool.  If not you 
could be experiencing the same problem I was in this post: 
http://www.numtopia.com/terry/blog/archives/2006/07/importing_ssl_certificates_with_keytool_finally.cfm




Terrence Ryan
I.T. Director
Wharton Computing and Information Technology   
E-mail:     [EMAIL PROTECTED]


-Original Message-
From: Brian Case [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, November 13, 2007 9:30 AM
To: CF-Talk
Subject: RE: Trouble Using Exchange Tags

It's being served up by the exchange server. The redirect may be in due part 
because if you type the address (mail.ourdomain.com) with http to get to OWA it 
redirects it to https.

Thanks for the response. Any other ideas?


Brian Case
SR. MLS Technical Support Rep
Tucson Association of REALTORS® / MLS
2445 N Tucson Blvd.   Tucson, AZ 85716
Ph: (520) 795-1293 Fax: (520) 322-6613
Direct Line: (520) 382-8802
http://www.tarmls.com
http://www.tucsonrealtors.org
mailto:[EMAIL PROTECTED]



-Original Message-
From: Ryan, Terrence [mailto:[EMAIL PROTECTED] 
Sent: Monday, November 12, 2007 9:29 PM
To: CF-Talk
Subject: RE: Trouble Using Exchange Tags

Is the OWA actually being served up by the Exchange Server or is another server 
running OWA? The 302 means that it is trying to redirect you to another server.



Terrence Ryan
I.T. Director
Wharton Computing and Information Technology   
E-mail:     [EMAIL PROTECTED]


-Original Message-
From: Brian Case [mailto:[EMAIL PROTECTED] 
Sent: Monday, November 12, 2007 4:46 PM
To: CF-Talk
Subject: Trouble Using Exchange Tags

I am trying to test out the new cfexchange tags in Colldfusion 8 so that I can 
integrate in with our intranet at some point but am having some difficulty.

I am just testing by using the tag:



I keep getting the error, Unable to connect to the Exchange server using 
HTTP/HTTPS protocol. 
HTTP response code : 302 

Here is what I have currently checked.

1) I can ping the exchange server from the server that is running Colfusion 8
2) The Exchange server has "allow" for MS Exchange Server in the "Web service 
Extension" of IIS
3) Outlook Web Access is working and is enabled for my user account
4) Rechecked the ip address of the Exchange Server 
5) tried username/passsword combo that I use for Exchange and OWA and even 
tried appending [EMAIL PROTECTED]
6) I have also tried using protocol="https" and used the keytool option to 
install the certificate to the Coldfusion server. I get the message 
"SSLHandshakeException when connecting to the Exchange server at 192.168.0.20 
using HTTPS protocol. 
The SSL certificate installed on the Exchange server is not found on the 
ColdFusion server. Ensure that the required certificates are installed in the 
certificate store of the JVM".



Anyone have any ideas to test further

Thanks,

Brian








~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648

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

RE: Trouble Using Exchange Tags

[Ryan, Terrence]

Is the OWA actually being served up by the Exchange Server or is another server 
running OWA? The 302 means that it is trying to redirect you to another server.



Terrence Ryan
I.T. Director
Wharton Computing and Information Technology   
E-mail:     [EMAIL PROTECTED]


-Original Message-
From: Brian Case [mailto:[EMAIL PROTECTED] 
Sent: Monday, November 12, 2007 4:46 PM
To: CF-Talk
Subject: Trouble Using Exchange Tags

I am trying to test out the new cfexchange tags in Colldfusion 8 so that I can 
integrate in with our intranet at some point but am having some difficulty.

I am just testing by using the tag:



I keep getting the error, Unable to connect to the Exchange server using 
HTTP/HTTPS protocol. 
HTTP response code : 302 

Here is what I have currently checked.

1) I can ping the exchange server from the server that is running Colfusion 8
2) The Exchange server has "allow" for MS Exchange Server in the "Web service 
Extension" of IIS
3) Outlook Web Access is working and is enabled for my user account
4) Rechecked the ip address of the Exchange Server 
5) tried username/passsword combo that I use for Exchange and OWA and even 
tried appending [EMAIL PROTECTED]
6) I have also tried using protocol="https" and used the keytool option to 
install the certificate to the Coldfusion server. I get the message 
"SSLHandshakeException when connecting to the Exchange server at 192.168.0.20 
using HTTPS protocol. 
The SSL certificate installed on the Exchange server is not found on the 
ColdFusion server. Ensure that the required certificates are installed in the 
certificate store of the JVM".



Anyone have any ideas to test further

Thanks,

Brian




~|
ColdFusion is delivering applications solutions at at top companies 
around the world in government.  Find out how and where now
http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us

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

RE: Question about "writeToBrowser" image action...

[Ryan, Terrence]

Secure images elsewhere on the file system.  

You don't want them browsable, but you do want them displayed. 

Terrence Ryan
I.T. Director
Wharton Computing and Information Technology   
E-mail:     [EMAIL PROTECTED]



-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED] 
Sent: Sunday, November 04, 2007 4:06 PM
To: CF-Talk
Subject: Question about "writeToBrowser" image action...

What would be the possible use(es) of the "writeToBrowser" image action?

Rick





~|
ColdFusion is delivering applications solutions at at top companies 
around the world in government.  Find out how and where now
http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us

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

RE: Compiling Oracle Stored Procedures from ColdFusion

[Ryan, Terrence]

In case anyone has this problem in the future. The solution is to strip out all 
chr(13)'s from the procedure creation code.

Terrence Ryan
I.T. Director
Wharton Computing and Information Technology   
E-mail:     [EMAIL PROTECTED]



~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648

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

Compiling Oracle Stored Procedures from ColdFusion

[Ryan, Terrence]

I figure this is a pretty random problem, but I figured I would try to
ask here.

 

Does anyone know how to compile Oracle stored procedures from
ColdFusion?

 

I can successful write stored procedures in Oracle from ColdFusion, they
show up as uncompiled when I use Oracle Tools to view them.  When I
compile them through Oracle tools, they work perfectly. However when I
try and run ALTER PROCEDURE [name] COMPILE;  They don't compile, but
without any error.

 

Can anyone point me in the right direction here?  

 

Terrence Ryan
I.T. Director
Wharton Computing and Information Technology
3733 Spruce Street
216 Vance Hall 
Philadelphia, PA  19104 
   
E-mail: [EMAIL PROTECTED]
 
Phone:  (215) 898-6705 
Mobile: (267) 252-9727

 



~|
ColdFusion 8 - Build next generation apps
today, with easy PDF and Ajax features - download now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

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

RE: [OT] Populating a MySQL Database from Active Directory

[Ryan, Terrence]

I'll clean it up and send it to this weekend.

Terrence Ryan
I.T. Director
Wharton Computing and Information Technology   
E-mail:     [EMAIL PROTECTED]


-Original Message-
From: Steve Good [mailto:[EMAIL PROTECTED] 
Sent: Friday, October 26, 2007 9:03 PM
To: CF-Talk
Subject: Re: [OT] Populating a MySQL Database from Active Directory

I would LOVE to see this!  Thank you for the offer!

On 10/26/07, Ryan, Terrence <[EMAIL PROTECTED]> wrote:
>
> I have some code that can pull down the entire contents of an active
> directory domain from ldap.
>
> From there you could do anything you want with it.  (Including inserting
> it into mysql. )
>
> Care for a look?
>
> Terrence Ryan
> I.T. Director
> Wharton Computing and Information Technology
> E-mail: [EMAIL PROTECTED]
>
>
>
> -Original Message-
> From: Steve Good [mailto:[EMAIL PROTECTED]
> Sent: Friday, October 26, 2007 4:54 PM
> To: CF-Talk
> Subject: [OT] Populating a MySQL Database from Active Directory
>
> I have an internal app that is working pretty well.  Users log in using
> credentials stored in Active Directory and the App runs on a MySQL DB.  As
> I
> expand the app I find I am running into problems with talking to AD.  My
> bigest issue is with my Dev Enviro.  I have to code in a way to circumvent
> checking usernames and passwords against AD and pull them from a DB
> instead.  This is a pain and ends up adding a ton of extra lines to
> maintain.  Is there a way to populate the database from info stored in AD
> and then keep it synchronized?  I'd love to keep my user info stored in
> the
> DB since that would let me start developing my app without worrying about
> where the app is running.
>
> Thanks yall.
>
> ~Steve
>
>
>
>
> 



~|
ColdFusion is delivering applications solutions at at top companies 
around the world in government.  Find out how and where now
http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us

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

RE: [OT] Populating a MySQL Database from Active Directory

[Ryan, Terrence]

I have some code that can pull down the entire contents of an active directory 
domain from ldap. 

>From there you could do anything you want with it.  (Including inserting it 
>into mysql. )

Care for a look?

Terrence Ryan
I.T. Director
Wharton Computing and Information Technology   
E-mail:     [EMAIL PROTECTED]



-Original Message-
From: Steve Good [mailto:[EMAIL PROTECTED] 
Sent: Friday, October 26, 2007 4:54 PM
To: CF-Talk
Subject: [OT] Populating a MySQL Database from Active Directory

I have an internal app that is working pretty well.  Users log in using
credentials stored in Active Directory and the App runs on a MySQL DB.  As I
expand the app I find I am running into problems with talking to AD.  My
bigest issue is with my Dev Enviro.  I have to code in a way to circumvent
checking usernames and passwords against AD and pull them from a DB
instead.  This is a pain and ends up adding a ton of extra lines to
maintain.  Is there a way to populate the database from info stored in AD
and then keep it synchronized?  I'd love to keep my user info stored in the
DB since that would let me start developing my app without worrying about
where the app is running.

Thanks yall.

~Steve




~|
ColdFusion 8 - Build next generation apps
today, with easy PDF and Ajax features - download now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

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

RE: Best Database Engine for ColdFusion (Survey)

[Ryan, Terrence]

I think it's all a trade-off.

I think MS Sql 2005 is great for developing.  You get really good graphical 
execution plans, and it's pretty easy to tune your database. The gui tools make 
everything fairly easy to use. However setting it up is a bit of a pain. 
Especially if you are going for high performance. For that matter just getting 
the SQL server port to serve up to ColdFusion isn't straight forward, even if 
CF is on the same box.

On the other hand.  I struggle with things in MySql like performance testing, 
adding constraints, and moving columns around in MySQL that are simple in 
MSSQL.  But it is a lot easier to install, and get working properly, and for 
simple setups it's really not that harder to do most things than in MSSQL.

I leave MS 2000 off, because well, it's 2007, and if your app has any life to 
it at all, you might run against end of life for 2000. 

I haven't run up against the performance limits of either, so I can't tell you 
one is better than the other. 

When I have my choice I go with MSSQL, as I am much more comfortable with it. 


Terrence Ryan
I.T. Director
Wharton Computing and Information Technology   
E-mail:     [EMAIL PROTECTED]

~|
ColdFusion 8 - Build next generation apps
today, with easy PDF and Ajax features - download now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

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

OT Sys-con at it again

[Ryan, Terrence]

Just saw this today.  http://java.sys-con.com/read/441186.htm 

 

I'm intentionally not blogging it to not give them my (paltry) traffic,
but talk about sour grapes. 

 

I guess none of us can ever leave a job, because according to sys-con,
it means that as we walk out the door our former company or office
EXPOLDES!

 

Terrence Ryan
I.T. Director
Wharton Computing and Information Technology
3733 Spruce Street
216 Vance Hall 
Philadelphia, PA  19104 
   
E-mail: [EMAIL PROTECTED]
 
Phone:  (215) 898-6705 
Mobile: (267) 252-9727

 



~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648

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

RE: Help with DB design delimma

[Ryan, Terrence]

I would go the second table route. It's possible that down the road you'll want 
to set featured articles to only persist for a time.  Then you'll need a start 
and end date. Or you'll need something else that you can't predict right now.

Terrence Ryan
I.T. Director
Wharton Computing and Information Technology   
E-mail:     [EMAIL PROTECTED]


-Original Message-
From: Aaron Roberson [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, October 09, 2007 9:01 PM
To: CF-Talk
Subject: Help with DB design delimma

Hey all,
Here is my simple use case: I have a table of articles. I would like to
indicates some as featured.

Here is my dilemma: Since only a few rows in the table will be featured
articles I figured it would be bad to have an "isfeatured" field in the
table. Why have a field for every row when a small minority will actually
use it? My thought was to create a second table with all of the featured
article id's. However, should I really create a table with one field just
for maintaining a list of article id's?

What would be the "best" approach?

Thanks,
Aaron




~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs wiki.
http://labs/adobe.com/wiki/index.php/ColdFusion_8

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

RE: Authenticate with Windows Active Directory, Windows Server 2003?

[Ryan, Terrence]

Terrence Ryan
I.T. Director
Wharton Computing and Information Technology   
E-mail:     [EMAIL PROTECTED]


-Original Message-
From: Tom Hines [mailto:[EMAIL PROTECTED] 
Sent: Monday, October 08, 2007 11:10 AM
To: CF-Talk
Subject: Authenticate with Windows Active Directory, Windows Server 2003?

What is the Coldfustion Script, CF version MX7 to Authenticate with Windows 
Active Directory, Windows Server 2003?




~|
Check out the new features and enhancements in the
latest product release - download the "What's New PDF" now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

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

RE: CF8 Exchange integration

[Ryan, Terrence]

I've done a bunch of stuff with Exchange, but I haven't blogged too much of it.

Here is an example of getting calendar date from Exchange:
http://www.numtopia.com/terry/blog/archives/2007/05/my_cfobjective_schedule.cfm

What else are you looking for I'd be happy to share.

Terrence Ryan
I.T. Director
Wharton Computing and Information Technology   
E-mail:     [EMAIL PROTECTED]


-Original Message-
From: WebSite CFtalk [mailto:[EMAIL PROTECTED] 
Sent: Friday, October 05, 2007 8:03 AM
To: CF-Talk
Subject: CF8 Exchange integration

Hello,

I'm trying to find information/example apps on Exchange integration. 

Besides the docs/example apps there doesn't seem to be anything out
there yet.

I'm looking for something I can use as a start for an intranet app. 

Open source / source code license etc..

Any pointers?

Thx,
Helge Hetland



~|
ColdFusion 8 - Build next generation apps
today, with easy PDF and Ajax features - download now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

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

RE: CF equivalent to PHP pack() function

[Ryan, Terrence]

I had to simulate pack(L) from perl. I don't know if this will help, but I 
figured I would share it. 


/*
create_perl_packed_string_L 
This simulates the command pack ("L", $now) function from 
perl.  It converts a number from numerals into the asci 
character representation of it's 32 bit binary form. 

*/


function create_perl_packed_string_L(number)
{
// convert number to binary 
bin_number=formatBaseN(number,2);

// Figure out how many 0's make it 32 bit
bin_number_length=Len(bin_number);
prepend_count=32- bin_number_length;

prepend="";
for (i=1;i lte prepend_count; i=i+1)
{
prepend = prepend & "0";
}

// add prefixed 0's
bin_number= prepend & bin_number; 

//break into octets 
octet_array=arrayNew(1);
j=1;
for (i=1; i lte 32; i=i+8)
{
octet_array[j]=Mid(bin_number,i,8);
j=j+1;

}


//convert to proper string 
packed_string="";
for (i=1; i lte 4; i=i+1)
{
packed_string=packed_string & 
Chr(InputBaseN(octet_array[i],2));

}



return(packed_string);
}

Terrence Ryan
I.T. Director
Wharton Computing and Information Technology   
E-mail:     [EMAIL PROTECTED]




~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and Dreamweaver updates.
http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta

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

RE: CFEXECUTE and PSCP

[Ryan, Terrence]

Not an exact answer to your question, but have you tried logging on 
interactively as the user CF runs as?

I think from my memory that the first time pscp runs it sets up a key for your 
user profile.  Assuming that your machine is running some flavor of windows.

Terrence Ryan
I.T. Director
Wharton Computing and Information Technology   
E-mail:     [EMAIL PROTECTED]


~|
ColdFusion 8 - Build next generation apps
today, with easy PDF and Ajax features - download now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

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

RE: XHTML Style CF?

[Ryan, Terrence]

Well, I do it because I like XHTML formatting. 

Additionally there is a suggestion here: 
http://livedocs.adobe.com/wtg/public/coding_standards/style.html 
that says: 

CFML & XHTML Compliance

ColdFusion source code cannot quite be written to be purely XHTML-compliant 
because of certain tags (cfif / cfelse, cfreturn, cfset) but you should make an 
effort to be as XHTML-compliant as possible. cfelse cannot have a closing tag 
so it cannot be XHTML-compliant; cfif and cfreturn do not have an 
attribute="value" syntax so they cannot be XHTML-compliant (but cfif has a 
closing /cfif tag and cfreturn can and should have a self-closing /); cfset 
does not in general follow the attribute="value" syntax and these guidelines 
recommend that for readability you do not quote the value in cfset - but cfset 
can and should have a self-closing /. This makes the source code more 
consistent (across CFML and HTML) and will also help you avoid subtle errors 
such as unterminated nested cfmodule calls.

If a simple custom tag invocation is written as XHTML-compliant, i.e., with a 
closing />, it will be executed twice as if it were a paired tag with an empty 
body. This can be surprising at first and cause subtle bugs if your code 
doesn't expect it! You can guard against this in simple custom tags by 
enclosing the code with:


...


Complex custom tags will probably already use thisTag.hasEndTag and have 
different code executed for thisTag.executionMode is "start" and 
thisTag.executionMode is "end".

All built-in CFML tags should be written as XHTML-compliant where possible 
(cfif, cfelse, cfset and cfreturn are notable exceptions).


Terrence Ryan
I.T. Director
Wharton Computing and Information Technology   
E-mail:     [EMAIL PROTECTED]



-Original Message-
From: Robert Harrison [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, September 12, 2007 3:05 PM
To: CF-Talk
Subject: XHTML Style CF?

I've noticed some other programmers are now using a close tag indicator in
stand-alone cftags, like .

 

As far as I know it's only an XHTML requirement to close all tags (e.g., ) and not a CF issue.  Since CF never outputs CFtags to the browser is
this actually necessary?

 

 

Robert B. Harrison
Director of Interactive services
Austin & Williams
125 Kennedy Drive, Suite 100 Hauppauge NY 11788
T : 631.231.6600 Ext. 119 

F : 631.434.7022
www.austin-williams.com

Great advertising can't be either/or... It must be &.






~|
Enterprise web applications, build robust, secure 
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps

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

RE: CFFILE Makes No Sense - the file is there

[Ryan, Terrence]

Are the spaces between the last \ and the file name really there, or an issue 
with email. 

If it is there it could be the source of the problem as ..baby\ 
38035273713000.jpg and ..baby\38035273713000.jpg are two different files. 

Terrence Ryan
I.T. Director
Wharton Computing and Information Technology   
E-mail:     [EMAIL PROTECTED]


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Monday, August 06, 2007 10:08 AM
To: CF-Talk
Subject: CFFILE Makes No Sense - the file is there

WHy is CFFILE doing this?  I'm getting an error that says it can't find the 
file and I've checked several times, the file is there, on the server in the 
correct folder with the exact file name!!!

The following information is meant for the website developer for debugging 
purposes. 

Error Occurred While Processing Request 
An exception occurred when performing a file operation COPY on files 
D:\Inetpub\wwwroot\baby\ 38035273713000.jpg and 
D:\Inetpub\wwwroot\baby\images\babycontest\2007\picture_people\Tina_Nicorette_CHARLOTTE_0806_
 38035273713000_pp.jpg. 
The cause of this exception was: java.io.FileNotFoundException: 
D:\Inetpub\wwwroot\Yobaby\ 38035273713000.jpg (The system cannot find the file 
specified). 

~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648

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

RE: retrieve mac address with CF?

[Ryan, Terrence]

You can use Cfexecute to run the OS command to get the Mac Address.

I know that ipconfig /all is the way to get it in the Windows world. 

Terrence Ryan
Senior Systems Programmer
Wharton Computing and Information Technology   
E-mail:     [EMAIL PROTECTED]

-Original Message-
From: Bob Imperial [mailto:[EMAIL PROTECTED] 
Sent: Monday, June 25, 2007 9:27 AM
To: CF-Talk
Subject: retrieve mac address with CF?

Good morning folks ... or at least it's morning here ;)
I was just asked if I could retrieve mac addresses via coldfusion and have no 
idea. Is this possible with cf, if so or if someone knows of a good reference 
to point me in the direction of, I would appreciate it greatly.

Thanks! Bob


~|
Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & 
Flex 2
Free Trial 
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU

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

RE: My eyes, my eyes!

[Ryan, Terrence]

Actually there's a great article by Joel Spolsky about the difference in 
philosophy between Apple and Microsoft in regards to font rendering. 

 

http://www.joelonsoftware.com/items/2007/06/12.html

 

It makes sense of the difference

 

Terrence Ryan

Senior Systems Programmer

Wharton Computing and Information Technology   

E-mail: [EMAIL PROTECTED]

 

 

-Original Message-
From: Mark Picker [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, June 13, 2007 7:06 PM
To: CF-Talk
Subject: Re: My eyes, my eyes!

 

Really?  I had eye surgery last Monday as well (cryotherapy on the 
retina).and still having a few vision problems.  To me the text is harder 
to read.  Certainly won’t be looking at it again until much further down 
the track.

 

Why they decide they need to be different, I don’t know.  Typical Apple 
approach. 

 

Cheers

Mark

 

 



~|
Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & 
Flex 2
Free Trial 
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU

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

RE: CFC Typeof()

[Ryan, Terrence]

The Struct returned from GetMetaData has a member named "name" which contains 
the full CFCpath of the CFC used to instantiate the object.

Terrence Ryan
Senior Systems Programmer
Wharton Computing and Information Technology   
E-mail:     [EMAIL PROTECTED]

-Original Message-
From: Zaphod Beeblebrox [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, June 06, 2007 11:14 PM
To: CF-Talk
Subject: Re: CFC Typeof()

regardless of whether or not CF is duck typed or dynamic, the dynamic
languages I've used   have all had this ability.  Say you have an cfc
that expects a vehicle, you send it a bike and you send it a car, both
are vehicles, but both behave differently in some aspects.  They may
both have a 'go', but only the car will have 'checkFuelLevel'.  Which
would be the bigger performance hit, using a try catch block or just
checking the type or class of an object?


~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ 

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

RE: Choosing an ORM

[Ryan, Terrence]

I'm fairly certain both Reactor and Transfer do so. 

Terrence Ryan
Senior Systems Programmer
Wharton Computing and Information Technology   
E-mail:     [EMAIL PROTECTED]


-Original Message-
From: Dave Hoff [mailto:[EMAIL PROTECTED] 
Sent: Monday, June 04, 2007 10:54 AM
To: CF-Talk
Subject: Re: Choosing an ORM

Can anyone recommend an ORM that works with MySql? 

ts/unsubscribe.cfm?user=22052.16742.4

~|
Upgrade to Adobe ColdFusion MX7
The most significant release in over 10 years. Upgrade & see new features.
http://www.adobe.com/products/coldfusion?sdid=RVJR

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

RE: Choosing an ORM

[Ryan, Terrence]

Well 

When it generates the code it's not blazingly fast.  A simple application takes 
about 5 seconds on my laptop, a more complicated one takes anywhere from 20 
seconds to a minute. (On server class hardware it is obviously much faster.)  
But that's why it's a passive code generator, instead of an active one.

However once the code is generated, it's executed pretty fast, assuming that 
the underlying table structures are properly indexed and whatnot.  Even an 
improperly indexed table will be okay, at least for awhile. I typically see 
either 0 or 16ms for individual calls.  



Terrence Ryan
Senior Systems Programmer
Wharton Computing and Information Technology   
E-mail:     [EMAIL PROTECTED]


-Original Message-
From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] 
Sent: Monday, June 04, 2007 10:08 AM
To: CF-Talk
Subject: RE: Choosing an ORM

Certainly does look nifty..be good to see what kind of performance his it
has though...



-Original Message-
From: Robert Rawlins - Think Blue
[mailto:[EMAIL PROTECTED] 
Sent: 04 June 2007 14:40
To: CF-Talk
Subject: RE: Choosing an ORM

Thanks Terrance,

I've not seen Squidhead before, but if it's as good as it sounds then It
would be perfect for me, anything to avoid writing DAO code ;-)

I'll have a look at it this afternoon, but it sounds fantastic,

Rob

-----Original Message-
From: Ryan, Terrence [mailto:[EMAIL PROTECTED] 
Sent: 04 June 2007 14:32
To: CF-Talk
Subject: RE: Choosing an ORM

I'm not going to jump in to Reactor vs Transfer.  They're both great
products.  I wish I could use them. (We have a mandate for stored procs. )  

But if you're looking to handle stored procedures, may I make a plug for my
product, Squidhead (http://squidhead.riaforge.org/).

It doesn't have hooks for any of the other frameworks yet, but it does
implement the DAO and Gateway for a MSSQL database using stored procedures.
And while it doesn't have any hooks for the frameworks, there's nothing to
stop it from working with modelglue, or fusebox. 

In addition to writing its own CRUD in stored procs, it also reads in and
makes available your stored procedures as CFC methods. It can handle
multiple queries proc call, etc.


   

Terrence Ryan
Senior Systems Programmer
Wharton Computing and Information Technology   
E-mail:     [EMAIL PROTECTED]


-Original Message-
From: Robert Rawlins - Think Blue
[mailto:[EMAIL PROTECTED] 
Sent: Monday, June 04, 2007 4:06 AM
To: CF-Talk
Subject: Choosing an ORM

Hello Guys,

 

I've just started work on a large scale rebuild of my core business
application, and to aid me the gruelling task I'm toying with implementing
MG, ColdSpring and one of the ORM's. I've done some small work with these in
the past but used Reactor. Now, I'm sure I've read somewhere that Reactor
and MG got a divorce, and that MG would most likely end up sleeping with
Transfer, is this the case?

 

Another thing to take into consideration is that I had planned to take all
my queries and move them into stored procs on my SQL Server as some of them
were getting pretty fat and needed a helping hand to keep performance where
I want it, will I still be able to do this when working with an ORM?

 

What are your thoughts on this stuff? What's hot? And what's not?

 

Look forward to hearing from you guys,

 

Rob











~|
Create Web Applications With ColdFusion MX7 & Flex 2. 
Build powerful, scalable RIAs. Free Trial
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS 

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

RE: Choosing an ORM

[Ryan, Terrence]

I'm not going to jump in to Reactor vs Transfer.  They're both great products.  
I wish I could use them. (We have a mandate for stored procs. )  

But if you're looking to handle stored procedures, may I make a plug for my 
product, Squidhead (http://squidhead.riaforge.org/).

It doesn't have hooks for any of the other frameworks yet, but it does 
implement the DAO and Gateway for a MSSQL database using stored procedures. And 
while it doesn't have any hooks for the frameworks, there's nothing to stop it 
from working with modelglue, or fusebox. 

In addition to writing its own CRUD in stored procs, it also reads in and makes 
available your stored procedures as CFC methods. It can handle multiple queries 
proc call, etc.


   

Terrence Ryan
Senior Systems Programmer
Wharton Computing and Information Technology   
E-mail:     [EMAIL PROTECTED]


-Original Message-
From: Robert Rawlins - Think Blue [mailto:[EMAIL PROTECTED] 
Sent: Monday, June 04, 2007 4:06 AM
To: CF-Talk
Subject: Choosing an ORM

Hello Guys,

 

I've just started work on a large scale rebuild of my core business
application, and to aid me the gruelling task I'm toying with implementing
MG, ColdSpring and one of the ORM's. I've done some small work with these in
the past but used Reactor. Now, I'm sure I've read somewhere that Reactor
and MG got a divorce, and that MG would most likely end up sleeping with
Transfer, is this the case?

 

Another thing to take into consideration is that I had planned to take all
my queries and move them into stored procs on my SQL Server as some of them
were getting pretty fat and needed a helping hand to keep performance where
I want it, will I still be able to do this when working with an ORM?

 

What are your thoughts on this stuff? What's hot? And what's not?

 

Look forward to hearing from you guys,

 

Rob





~|
Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & 
Flex 2
Free Trial 
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU

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

RE: How do you stay up on blogs?

[Ryan, Terrence]

I'm a big fan of Sharpreader. 

It's desktop. It treats feeds similar to mail, in that you can read/delete 
individual entries. It will pop up notification of new feeds. Etc. But it 
doesn't make noise for you. 






Terrence Ryan
Senior Systems Programmer
Wharton Computing and Information Technology   
E-mail:     [EMAIL PROTECTED]


~|
Macromedia ColdFusion MX7
Upgrade to MX7 & experience time-saving features, more productivity.
http://www.adobe.com/products/coldfusion?sdid=RVJW

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

RE: RIAForge Downtime

[Ryan, Terrence]

Sorry, Ray. 

I didn't mean to imply that RIAForge needed any new features.

Terrence Ryan
Senior Systems Programmer
Wharton Computing and Information Technology   
E-mail:     [EMAIL PROTECTED]



~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ 

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

RE: RIAForge Downtime

[Ryan, Terrence]

Cool that probably means something new and awesome is coming. Right?

Terrence Ryan
Senior Systems Programmer
Wharton Computing and Information Technology   
E-mail:     [EMAIL PROTECTED]


~|
ColdFusion MX7 by Adobe®
Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. 
Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV

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

RE: Problems with Event Gateways

[Ryan, Terrence]

Mark, are you seeing any errors in the eventgateway.log, or in the jrun.logs. 

You said you get this: Error invoking CFC for gateway directory_test: null

I assume that's on the calling page.  

Is the gateway started?

What are your gateway instance settings?  In the administrator?


Terrence Ryan
Senior Systems Programmer
Wharton Computing and Information Technology   
E-mail:     [EMAIL PROTECTED]

-Original Message-
From: Mark Drew [mailto:[EMAIL PROTECTED] 
Sent: Monday, April 23, 2007 10:06 AM
To: CF-Talk
Subject: Re: Problems with Event Gateways

Oh yeah.. first place I checked before I removed what was left of my  
hair...

CFC works fine, its a shell, does nothing. the cfg is obviously  
looking in the right place (since it is running when a file changes  
in a directory). and the code runs on 4 other servers that I have  
tested...

I am a  bit stumped, unless its some hidden winderz security setting  
(I have made the directory modifiable by all so it isnt that)

MD


On 23 Apr 2007, at 13:33, AJ Mercer wrote:

> Hi Mark,
>
> just to ask the obvious, is the gateway services enabled?
> cfadmin -> Event gateways -> settings
>
> On 4/23/07, Mark Drew <[EMAIL PROTECTED]> wrote:




~|
Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & 
Flex 2
Free Trial 
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU

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

RE: Emergency Problem with ColdFusion

[Ryan, Terrence]

Also the jrun logs might also contain the reason the server won't start. They 
can be found in:
\logs
Or
\runtime\logs 

Terrence Ryan
Senior Systems Programmer
Wharton Computing and Information Technology   
E-mail:     [EMAIL PROTECTED]


-Original Message-
From: James Holmes [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 17, 2007 9:23 PM
To: CF-Talk
Subject: Re: Emergency Problem with ColdFusion

Hopefully you get the hands-on help you need, but in the meantime you
need to look in the logs (from the OS, since CF won't start) to see
what the error is.


~|
Macromedia ColdFusion MX7
Upgrade to MX7 & experience time-saving features, more productivity.
http://www.adobe.com/products/coldfusion?sdid=RVJW

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

RE: Scorpio Prerelease Program

[Ryan, Terrence]

I doubt this violates NDA. But I'll still speak ambiguously just in case. 

Something I heard, from someone at Adobe, is that the Beta program queues up 
requests per Alpha/Beta release. So, if you made it before Adobe sent out the 
last batch of accounts, then you got in.  If not, you have to wait until the 
next release.

Releases occur once every few months or so I imagine, because I can only 
speculate


  

Terrence Ryan
Senior Systems Programmer
Wharton Computing and Information Technology   
E-mail:     [EMAIL PROTECTED]



~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP

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

RE: CF & Socket Connections

[Ryan, Terrence]

I did some stuff sockets to get my ColdFusion Exchange stuff working.  
Basically, when you need to manipulate things at the telnet level sockets are 
your only options.  I would have preferred to use CFX_socket, which handled all 
of this stuff, but it stopped working for me a while back. 

There's not much out there, for this, I basically took Java socket tutorials, 
and kept trying stuff and trying stuff until I got it to work.  



Here's a https socket function I wrote. 




  












  
















 


 








Terrence Ryan
Senior Systems Programmer
Wharton Computing and Information Technology   
E-mail:     [EMAIL PROTECTED]




~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ 

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

RE: CFQUERY vs SQL Server Stored Procedures

[Ryan, Terrence]

There are two reasons my organization encourages/forces all SQL to be in stored 
procedures. And they don't directly touch on performance.

1. A belief that keeping SQL code in the database is of itself a good thing. By 
keeping the database interaction in the database you make it easier for DBA's 
to do their job. Especially when a query goes awry, and your SQL server starts 
bombing.  It's in my humble opinion easier to troubleshoot SQL problems on the 
SQL server when the actual SQL is present. Especially during a crisis. 

Now, if you're a one person development team, or all of your CF developers are 
also doing their own DBA work it might not make a whole lot of sense for this 
argument.

However, having all of the SQL there allows you to more easily use SQL tuning 
tools, which can improve indexing, which can make either inline queries or 
stored procedures run faster. 


2. It forces developers to concentrate on the database first, as that seems to 
be the hardest thing to change once an application gets past the planning stage.

Granted this is just enforcing good programming practices (taking a good long 
look at the database in this case) through policy. But considering that the 
database side of things was causing the majority of our server problems, it was 
the right call.

So... 

Someone who tells you that all stored procedures are faster than inline queries 
is wrong.
Someone who tells you that all stored procedures are "better", is probably 
wrong.
Someone who tells you that stored procedures are better for their organization, 
group or specific problem might be right.


Terrence Ryan
Senior Systems Programmer
Wharton Computing and Information Technology       
E-mail:         [EMAIL PROTECTED]






~|
ColdFusion MX7 and Flex 2 
Build sales & marketing dashboard RIA’s for your business. Upgrade now
http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT

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

RE: Updating MSExchange PDL using CFLDAP tag

[Ryan, Terrence]

Assuming you have variables named ldapserver, ldapuser, and ldappassword ... 
This should work






 






 







Terrence Ryan
Senior Systems Programmer
Wharton Computing and Information Technology   
E-mail:     [EMAIL PROTECTED]



-Original Message-
From: Michael Bondar [mailto:[EMAIL PROTECTED] 
Sent: Thursday, February 08, 2007 5:07 PM
To: CF-Talk
Subject: Re: Updating MSExchange PDL using CFLDAP tag

Tarrence,

You are correct. PDL stands for "Public Distribution List"
I do not have permissions to add a group to the user's record, but I do have 
permission to add a user to a PDL. That's what I need to do using ColdFusion.

Thanks,
Michael



~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

RE: Updating MSExchange PDL using CFLDAP tag

[Ryan, Terrence]

What exactly is a PDL?  A distribution list? 

Terrence Ryan
Senior Systems Programmer
Wharton Computing and Information Technology   
E-mail:     [EMAIL PROTECTED]



-Original Message-
From: Michael Bondar [mailto:[EMAIL PROTECTED] 
Sent: Thursday, February 08, 2007 4:36 PM
To: CF-Talk
Subject: Updating MSExchange PDL using CFLDAP tag

Hello!

Does anyone know how to add a user to the MS Exchange 2003 PDL from ColdFusion 
(I assume using CFLDAP tag).
An example would be great.

Thanks,
Michael



~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

RE: Resetting Active Directory Password using CFLDAP ?

[Ryan, Terrence]

Your best bet is to:

Query the person first filtering on their username first:



Then make the change Using ldapresults.DN

More steps, but I think a little more sure to be accurate. 




Terrence Ryan
Senior Systems Programmer
Wharton Computing and Information Technology   
E-mail:     [EMAIL PROTECTED]


-Original Message-
From: Ian Vaughan [mailto:[EMAIL PROTECTED] 
Sent: Friday, February 02, 2007 10:19 AM
To: CF-Talk
Subject: RE: Resetting Active Directory Password using CFLDAP ?

So if I wanted it just to change the name of the user who entered their
details in the change password form

It would be   dn="uid=sAMAccountName,ou=Users,DC=domain,dc=co,dc=uk"






~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

RE: Coldfusion using network resources

[Ryan, Terrence]

What happens when you try and start the ColdFusion service?  Is it starting?  
What do the Windows Security logs tell you? Is the service account 
authenticating properly?  

Terrence Ryan
Senior Systems Programmer
Wharton Computing and Information Technology   
E-mail:     [EMAIL PROTECTED]


-Original Message-
From: So Kenfused [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, January 31, 2007 8:11 AM
To: CF-Talk
Subject: Coldfusion using network resources

I am trying to allow Coldfusion (7 Enterprise) access to other network 
resources (I want to read and write to directories and files) on other servers 
within our network. 

Coldfusion logs on as a local user that has access to all the required local 
directories.  However, if I create a windows user on the network (CFUser) and 
use that user as the ColdFusion and the Macromedia Instance logon in services 
everything goes to Hades in a heart a beat.  I get the following error.

500 There is no web application configured to service your request
There is no web application configured to service your request.

I have added the CFUser to the administrators group on the server thinking it 
would give it pretty much global access locally, then I could give the CFUser 
the appropriate access on the other system resources.  However, I seem to have 
killed CF.  

Any help would be appreciated



~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

RE: Not able to enable debugging in CF server

[Ryan, Terrence]

Correct, assuming that you are not viewing the pages on the same machine as the 
ColdFusion server is running on. 

Conversely, you could just add your client machine's ip address to the allowed 
list.  It would be a bit more secure. 

Terrence Ryan
Senior Systems Programmer
Wharton Computing and Information Technology   
E-mail:     [EMAIL PROTECTED]



-Original Message-
From: hussain shaikh [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, January 23, 2007 11:46 PM
To: CF-Talk
Subject: Re: Not able to enable debugging in CF server

So that means I should remove that IP addr from the list for the debugging to 
work.

Hussain.



~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

RE: Not able to enable debugging in CF server

[Ryan, Terrence]

Yep.  Pull it. 

Terrence Ryan
Senior Systems Programmer
Wharton Computing and Information Technology   
E-mail:     [EMAIL PROTECTED]



> There is only 1 ip addr in that list i.e. 127.0.0.1(I think it's the Loopback 
> IP Addr).
Shall I remove this for debugging to be enabled?


~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

RE: Not able to enable debugging in CF server

[Ryan, Terrence]

Are there any IP addresses in " View / Remove Selected IP Addresses for Debug 
Output" under "Debugging IP List."

If so, only requests with cgi.remote_host as these would see the debug output. 

Terrence Ryan
Senior Systems Programmer
Wharton Computing and Information Technology   
E-mail:     [EMAIL PROTECTED]





But I had enabled the debugging in both the Admin and the Application.cfm page 
and still the debugin was not enabled.
Is there something which I am missing?
Is it related to restarting the server?



~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

RE: securing files via cf

[Ryan, Terrence]

I've done this by placing such files in a directory not in the webroot.  Then 
using cffile to retrieve them, and cfcontent to output them to the user upon 
request.

Terrence Ryan
Senior Systems Programmer
Wharton Computing and Information Technology   
E-mail:     [EMAIL PROTECTED]





~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

RE: Acceptable processing time

[Ryan, Terrence]

I'll take a stab. 

I really depends, on what you're doing. 

I would say for most requests on a production level machine, it should fire off 
in 0 to 16ms, assuming the application and session were already initialized, 
and the template has already been compiled. It also assumes you have a vanilla 
page that just makes a request to a database and displays it. 

If you are doing something more complicated involving calls to a machine other 
than a database server (webservice, or FTP or pop) or IO, higher times are to 
be expected.  I tend to trust the 250 ms that is set as the default debug 
warning time, for calls like these. And start to consider performance tuning at 
that point. 

I say consider because, maybe it's a call that a user will only make every once 
in a while (Say a preference change, or image process.) If that's the case, 
performance tuning might not be needed.  However if your main page (the one 
users hit the most) is taking that long, you probably should performance tune.  
   

Hopefully this helps, or enough people think I'm wrong and give you better 
answers. 
  

Terrence Ryan
Senior Systems Programmer
Wharton Computing and Information Technology   
E-mail:     [EMAIL PROTECTED]




~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

RE: CFC Question

[Ryan, Terrence]

My particular way around this is to set a CFC path variable in the application 
scope.  So I call CFC's like this:



Or 




Yeah it's extra typing, but is a lot easier to maintain.  If that option is 
palatable to you. 


Terrence Ryan
Senior Systems Programmer
Wharton Computing and Information Technology   
E-mail:     [EMAIL PROTECTED]


-Original Message-
From: Bruce Sorge [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, January 09, 2007 1:39 PM
To: CF-Talk
Subject: CFC Question

I have a site on my laptop under Nascar. The CFC directory is Nascar.cfc. On
the live server though the root directory is SynergyDale. So of course my
CFC's cannot be found. Do I need to change the directory name on my laptop
to SynergyDale or is there a way for me to keep my directory the same name
and still reference the CFC. I am going to guess that I have to change my
local directory since the CFC is referenced as NASCAR.CFC.Queries?

-- 
Bruce Sorge

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

RE: Disregard last email

[Ryan, Terrence]

Cfcatch :P

Terrence Ryan
Senior Systems Programmer
Wharton Computing and Information Technology   
E-mail:     [EMAIL PROTECTED]



-Original Message-
From: Christopher Jordan [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, December 19, 2006 3:52 PM
To: CF-Talk
Subject: Re: Disregard last email

It's probably worth mentioning then, that *ALL* of the ColdFusion scopes 
are structures.
   Server,
   Application,
   Client,
   Variables,
   This (in CFCs),
   Form,
   URL,
   Session,
   Caller (in custom tags)

Have I missed any? :o)

Cheers,
Chris


Bruce Sorge wrote:
> yes it is. What was messing me up though was not realizing that passed form
> fields are actually structures. So, I was basically creating a structure of
> a structure when all I had to do was parse through the existing one. Now
> that I know that, I understand and will have a much easier time of it next
> time.
>
> Bruce
>
> On 12/19/06, Christopher Jordan <[EMAIL PROTECTED]> wrote:
>   
>> Bruce,
>>
>> I had trouble getting my head around structures too (about two years
>> ago), and now they're like my best friend. :o) I can probably help you
>> to get your head around them too if you like.
>> You solved your problem using a two dimensional array. That's fine. That
>> works, but in referencing it later it would probably be nice to have an
>> array of structures. I'll try and work with your example to show you
>> what I mean. (or at least this is what I *think* your example was trying
>> to accomplish). :o'
>>
>> GIVEN: Form.FieldNames = "Germany,UK,Spain,Australia,Marz"
>>Form.Germany = "German"
>>Form.UK = "English"
>>Form.Spain = "Spanish"
>>Form.Australia = "English"
>>Form.Marz = "Martian"
>>
>> Then you could do something like this:
>> 
>>
>> 
>> 
>> 
>> 
>> 
>> 
>>
>> What this code should result in is a single dimensioned array each
>> element of which is a structure. This makes for easy looping and easy
>> reference. It's *almost* the same as referencing a query object
>> (queryName.columnName). One thing that *really* helped me to get my head
>> around this stuff, was to dump these structures and arrays and what-not
>> using CFDump. It's amazing the clarity that I gained from seeing these
>> things graphically represented on screen! It was the "click" that I
>> needed to get me over the hump of understanding.
>>
>> Notice also, that it's not really necessary to use StructInsert (there
>> may be advantages to doing so, but if there are I don't know of them).
>> You can simply follow the name of your struct (i.e. MyStruct) by a
>> period and a key name. It didn't have to exist up until that point. By
>> the act of assigning a value to the structure key (> MyStruct.KeyName = "Hello World"), you have just created that key as a
>> member of that structure, and given it a value.
>>
>> Easy right? :o)
>>
>> If you still want help understanding structures, give a shout and I'd be
>> happy to help you out however I can. Best of all, use CFDump to look at
>> these things. It gives amazing clarity. :o)
>>
>> Cheers,
>> Chris
>>
>> Bruce Sorge wrote:
>> 
>>> OK, I figure it out so please disregard the last message.
>>>
>>> I did it like this:
>>>
>>> 
>>> 
>>>
>>> 
>>> 
>>> 
>>> 
>>>  
>>>  
>>>  
>>> 
>>> 
>>>
>>>
>>>
>>>   
>> 
>
> 



~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

RE: Application.cfc vs cfm

[Ryan, Terrence]

I need to stop writing such terse responses. 

I was referring to his particular case.

I've used application.cfm's for subfolders like CFC collections to block direct 
web access.  It's often easier then writing a whole application cfc, just to 
redirect direct directory calls.

Terrence Ryan
Senior Systems Programmer
Wharton Computing and Information Technology   
E-mail:     [EMAIL PROTECTED]


-Original Message-
From: Raymond Camden [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, December 19, 2006 10:03 AM
To: CF-Talk
Subject: Re: Application.cfc vs cfm

No - the .CFC wins. But in his case, the CFM was int he most immediate folder.

On 12/19/06, Ryan, Terrence <[EMAIL PROTECTED]> wrote:
> In my experience, the application.cfm wins out.
>
> Terrence Ryan
> Senior Systems Programmer
> Wharton Computing and Information Technology
> E-mail: [EMAIL PROTECTED]
>
>
> -Original Message-
> From: Ray Champagne [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, December 19, 2006 9:58 AM
> To: CF-Talk
> Subject: RE: Application.cfc vs cfm
>
> That file structure formatting got messed up in the transfer.  Amended:
>
>  /root
>
>  -  Application.cfc
>
>  -  Index.cfm
>
>  /root/subdirectory
>
>  o Application.cfm
>
> o index.cfm
>
>
>
>
> 



~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

RE: Application.cfc vs cfm

[Ryan, Terrence]

In my experience, the application.cfm wins out.  

Terrence Ryan
Senior Systems Programmer
Wharton Computing and Information Technology   
E-mail:     [EMAIL PROTECTED]


-Original Message-
From: Ray Champagne [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, December 19, 2006 9:58 AM
To: CF-Talk
Subject: RE: Application.cfc vs cfm

That file structure formatting got messed up in the transfer.  Amended:

 /root
 
 -  Application.cfc
 
 -  Index.cfm
 
 /root/subdirectory
 
 o Application.cfm
 
o index.cfm




~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

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

RE: Reliability

[Ryan, Terrence]

I really am Terrence Ryan.  No need for the quotes. :)

Terrence Ryan
Senior Systems Programmer
Wharton Computing and Information Technology
E-mail:     [EMAIL PROTECTED]
 


-Original Message-
From: Brent Nicholas [mailto:[EMAIL PROTECTED] 
Sent: Friday, September 15, 2006 11:32 AM
To: CF-Talk
Subject: Re: Reliability

I think that "Terrence Ryan" had the best approach to the situation. CFMX is a 
stable product, we've run about 15 CFMX servers around the world supporting 
corporate intranets and extranets with a constant load and rarely have problems.

Take a look at Terrence's pragmatic approach and try to emulate that. I think 
you'll find your answer.

BN


~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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

RE: Reliability

[Ryan, Terrence]

We, at Wharton, used to have this problem.  So we wrote a home grown monitoring 
service for CF that would tell us when it was down. 

Then as we started to examine the servers exactly when problems were occurring 
we were able to track down the source of many of our problems.  Typically we 
found problems the following ways: 
ColdFusion Logs
Jrun Logs
IIS Logs

Then we would research the hell out of the problem, and track down information 
we were seeing in the logs.

The problems tended to be one of the following:
A needed patch
A needed setting tweak (Most common source of a problem for us.)
Developer related (Bad code)

By iteratively going through, and combating issues *as soon as they come up*, 
we were able to make our environment extremely stable. 



Terrence Ryan
Senior Systems Programmer
Wharton Computing and Information Technology
E-mail:     [EMAIL PROTECTED]
 


-Original Message-
From: Neil Middleton [mailto:[EMAIL PROTECTED] 
Sent: Thursday, September 14, 2006 6:22 PM
To: CF-Talk
Subject: Reliability

Bit of an odd one this - but does anyone else find CF a little more 
"unreliable" than other similar products when using them in day to day use.

The only reason I ask is that our CF servers always seem a little more unstable 
than some of our other servers running things such as ASP.NET or Ruby on Rails. 
 CF just seems to restart itself more than I believe it should.

I am the only one?  I'm pretty sure our code is fairly sound, and that our 
servers aren't under too much load.

--
Neil Middleton

Visit feed-squirrel.com




~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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

RE: CFLdap

[Ryan, Terrence]

It depends on how the ldap server handles these fields. 

Active Directory's will removes empty fields from the entry. 

So 

The filter would be: 

!(mailLocalAddress=*)

Or "where not (mailLocalAddress is any value)"

Assuming your ldap server has a field named "mailLocalAddress" and it is the 
one that you would use to determine if the item is mail enabled.

Terrence Ryan
Senior Systems Programmer
Wharton Computing and Information Technology
E-mail:     [EMAIL PROTECTED]
 

-Original Message-
From: Ian Skinner [mailto:[EMAIL PROTECTED] 
Sent: Thursday, September 14, 2006 6:07 PM
To: CF-Talk
Subject: CFLdap

What would one put into a filter to select all ldap entities that do not have 
an mail object?



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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

RE: CFC question

[Ryan, Terrence]

Typically if you are doing manipulation of the value, you don't want to alter 
the input value, but rather a copy of it. 


Vs 


If you're not manipulating it further, then it might be a bit redundant at 
first:


 
But by writing it this way, you make sure that if further down the road, if you 
find out that whitespace is being added to the end of certain firstnames, and 
you want to add the trim operation, you don't have to add it for every 
reference to arguments.firstname.  

So it's a best practice in that it allows you for more maintainable code. 


Terrence Ryan
Senior Systems Programmer
Wharton Computing and Information Technology
E-mail:     [EMAIL PROTECTED]
 

-Original Message-
From: Victor Moore [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, September 13, 2006 10:54 AM
To: CF-Talk
Subject: CFC question

Hi,

I have seen in a number of examples the following:

 any particular reason/advantage 
why the arguments are assigned to a local variable inside a cfc function 
instead of using it directly?

Thanks
Victor




~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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

RE: CF Memory problems?

[Ryan, Terrence]

If debugging is enabled at all on the machine, it still creates the information 
for every request, regardless of any restrictions of display.  

If this is the cause what you will see happen is memory utilization for the 
ColdFusion will rise and rise as the process spins.  Then one of two things 
will happen.  The request will end, and utilization will go back down, or you 
will hit the upper limit for memory allocated to the JVM (I think ) and 
ColdFusion will hang. 

To test that this is the cause, just turn off debugging for the whole server, 
and rerun the request. 


Terrence Ryan
Senior Systems Programmer
Wharton Computing and Information Technology
E-mail:     [EMAIL PROTECTED]
 

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, September 12, 2006 10:50 AM
To: CF-Talk
Subject: Re: CF Memory problems?

As ar as creating the XML that gets sent out to the webservice, I'm simply 
using a 
blah blah blah  followed by a call to 
TOSTRING

I ripped out all of the code that created the intermediate query, and so far 
memory usage is staying under 100mb, as opposed to 1200+ MB that it was doing 
previously. So I guess it was all of those calls to set the contents of each 
cell in the query.  Which might also point to having debugging enabled.  BUT, I 
thought that I read/heard when CF MX7 came out that the overhead of having 
debugging enabled was drastically reduced from what it had been in previous 
versions - that CF was now checking the debugging IP list before storing 
debugging information during execution, rather than the old method of always 
storing the info and only checking the IP list at the end of the request to see 
if it needed to be displayed.  Am I imagining that?

thanks,
Reed


~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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

RE: CF Memory problems?

[Ryan, Terrence]

Is debugging on the server turn on at all?  

Even if the page is set to not show debugging it is still being collected. If 
you are doing many function calls with the loop, they all get thrown into the 
debugging info too. Which will then eat up memory, but be very hard to detect. 

But this theory depends on debugging being turned on. 

Terrence Ryan
Senior Systems Programmer
Wharton Computing and Information Technology
E-mail:     [EMAIL PROTECTED]
 


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Monday, September 11, 2006 11:28 AM
To: CF-Talk
Subject: CF Memory problems?

I have a CFMX script that continually comes close (and sometimes succeeds) in  
eating up all of the CFMX sever's memory.   I've put tracking code in various 
places to watch the memory stats (using calls to 
CreateObject("java","java.lang.Runtime").getRuntime() ).  I've also tried 
running (while this script is executing) another page that uses the 
runtime.gc() call to force a garbage collect, which only has a negligable 
effect on the memory usage.  I can run this on a testing server, to be sure 
that some other script isn't the real culprit, but see the same results.

Here is what the script does:

Run a query to determine which accounts need processing

Loop over that query (usually about 300 records):
1. Build a 10 line XML doc.  Use the same var name for this doc everytime
2. CFHTTP that doc to a website/service, get another XML doc back.
3. XMLParse the returned doc
4. Create a Query var, using the same var name everytime
5. Loop over the parsed XML doc, creating a row in the Query var with
   about 20 calls to QuerySetCell for each pass over the XML doc.
6. Loop over the Query structure created in step 5, and do 3 CFQUERY
   INSERTs to a various tables

That's it!  Note that for each iteration through the main loop I already know 
how many records will be returned from the website I'm HTTPing to, and I 
throttle it to only return 200 at a time (ie, I might make multiple passes 
through steps 1-5 whenever I know that there are more than 200 records to be 
returned.

Note also that I'm still trying to figure out why this was written to even 
create the intermediate query to begin with (instead of just looping over the 
XML doc to do the database inserts).

Are there any known problems with creating the same query var over and over? Or 
creating the same XML doc over and over? 

I've seen this problem with memory being eaten up when I execute a QoQ with the 
same name over and over (around 1000 times or more), and got around that by 
using array and list functions instead QoQ table lookups.

If this were a "normal" memory problem then I'd expect the periodic calls for a 
garbage collection to help out, but like I said, those calls are having just 
about 0 effect.

I'm running the latest CFMX update, and have upped the maxmem for JVM to 1200.

I'm going juts on this one, since the script is pretty simple and 
straightforward - just a lot of looping!  I'm looking at trying to break it up, 
but that's going to take some time.

TIA!
Reed




~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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

RE: Could not perform Web service invocation

[Ryan, Terrence]

Sure, but I have no power to do such things.  I was just trying to help you get 
working. :)


Terrence Ryan
Senior Systems Programmer
Wharton Computing and Information Technology
E-mail:     [EMAIL PROTECTED]
 


-Original Message-
From: Ryan Duckworth [mailto:[EMAIL PROTECTED] 
Sent: Monday, September 11, 2006 11:22 AM
To: CF-Talk
Subject: Re: Could not perform Web service invocation

Terrence,

Thank you very much.  I think this will solve the problem.  I really appreciate 
it.

Just a comment though: Shouldn't this "refreshWebService" function be called 
from within ColdFusion's createObject function of type 'webservice'.  Why 
should we have to do this everywhere we make a web service call when ColdFusion 
should not flush the stub component from memory and then blow up.

I think this is a true ColdFusion bug that should have a hot fix.

Ryan


~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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

RE: Could not perform Web service invocation

[Ryan, Terrence]

Have you tried resetting the webservice in the factory before making a call to 
it. Basically it causes the stub object to be re-written (as far as I can 
remember.) 

http://www.achex.com/ws/Authorization.wsdl"; />


I just wrap every delicate webservice call I make in a try/catch block, and 
then reset it in case of an error and rerun. It eliminates a lot of the 
problems I've had with calling webservices.

Terrence Ryan
Senior Systems Programmer
Wharton Computing and Information Technology
E-mail:     [EMAIL PROTECTED]
 

-Original Message-
From: Ryan Duckworth [mailto:[EMAIL PROTECTED] 
Sent: Monday, September 11, 2006 10:30 AM
To: CF-Talk
Subject: Could not perform Web service invocation

I recently integrated with TeleCheck to accept eChecks on our sites.
Everything seems to work perfectly except for ColdFusion's ability to generate 
and hold onto the stub code for the webservice.

The worst kind of problem too... it is intermittent with no obvious pattern.

The WSDL files look good.  TeleCheck web service calls will work great, but 
after we restart a server SOMETIMES we receive the "Could not perform web 
service invocation" error.

Test Server:
http://test.achex.com/ws/Authorization.wsdl

Production Server:
http://www.achex.com/ws/Authorization.wsdl

I have tried to search forums for a possible solution, but can't seem to get it 
to work.

Personally, I believe this is a bug with ColdFusion.  Some forums have 
mentioned that ColdFusion does not handle complex web service types very well.  
However, TeleCheck wrote the web service and I can not change their data types.

I have also read that ColdFusion "flushes" the stub objects from memory.  We 
have installed Cumulative Hot Fix 7.0.2 which stated that it solved some web 
service flushing problems.

The only way we have been able to somewhat solve this problem temporarily is to 
delete everything in the \CFusionMX7\stubs before restarting ColdFusion.  This 
solution is not acceptable for our production environment and I would like a 
true solution to this problem.

This problem has lasted for many months and it is critical that we be able to 
restart our CF servers without messing with this problem.

Any suggestions?

Thanks,
Ryan



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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

RE: Overiding the Timout setting in CF Administrator

[Ryan, Terrence]

Terrence Ryan 
Senior Systems Programmer
Wharton Computing and Information Technology 

E-mail: [EMAIL PROTECTED]


-Original Message-
From: Smith, Daron [PA] [mailto:[EMAIL PROTECTED] 
Sent: Thursday, August 31, 2006 2:50 PM
To: CF-Talk
Subject: Overiding the Timout setting in CF Administrator

Is there a way to override the timeout setting in the CF administrator?
I want the setting there for almost all requests, except my page that
indexes my website.  Any thoughts?
 
Thanks,
Daron Smith
 

"PSEA E-mail Firewall" annotation on Thu Aug 31 2006 14:50:27
-
NOTICE: Only the individual sender is responsible for the content of the
message, and the message does not necessarily reflect the position or
policy of the Pennsylvania State Education Association.
-




~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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

RE: CF Mail - What info available...

[Ryan, Terrence]

Another low tech approach to this problem would be to use cfdirectory to
poll these directories directly. 
















Terrence Ryan 
Senior Systems Programmer
Wharton Computing and Information Technology 

E-mail: [EMAIL PROTECTED]

-Original Message-
From: D F [mailto:[EMAIL PROTECTED] 
Sent: Thursday, August 31, 2006 11:07 AM
To: CF-Talk
Subject: CF Mail - What info available...

Is there anything built into CF ( such as java classes ) OR otherwise...
that will tell me current status of CF's mailing feature.

For example... 

to poll how many emails are in the CF Spool directory.


I've used the following before and found it useful for getting
information on CF's scheduled tasks..



Was wondering what else this or similar functionality was exposed.



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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

RE: performance and CFC gateways

[Ryan, Terrence]

The next step I would do would be to add cfflush to the mix. 
Then append periods (.) and some other output indicators throughout your
loops. 
See if the process experiences a slowdown at any point. 

Terrence Ryan 
Senior Systems Programmer
Wharton Computing and Information Technology 

E-mail: [EMAIL PROTECTED]



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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

RE: performance and CFC gateways

[Ryan, Terrence]

I have a feeling that it will take a couple passes to improve the
performance of the operation. 

Are you using ArrayResize to allocate the size of the array before hand?
This helps the performance of Large Arrays.

Are you a CFC function to assign the results to a bean, and repeating
all 1100 times?
If so is debugging turned on? 
If this is true than maybe you are collecting so much
debugging info 
that it is impacting performance. 

That's what I have without seeing any code.


Terrence Ryan 
Senior Systems Programmer
Wharton Computing and Information Technology 

E-mail: [EMAIL PROTECTED]



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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

RE: Stored procs (was Top 100 ColdFusion Programmers)

[Ryan, Terrence]

There are other concerns for using stored proc's other than just
performance and security.  

We decided to enforce a "stored procedure only" policy because we were
experiencing issues with our cf servers related to database operations.
In addition we noticed a very number of database calls per page (using
cfstat server statistics collected over time.)

Because of this we decided we needed more eyes taking a harder look at
database operations, and the best way *that we found* to do that was to
make sure all SQL was in the database, and easily accessible by the
DBA's. 

In our environment, developers don't have access to production SQL
servers at all.  SQL changes must go through the DBA's. They also don't
have direct access to the production CF servers, but can publish to the
production servers at will. However accept for a code review to get on
to the production CF servers, there is no oversight of CF after a code
review, (unless an application starts misbehaving.) Additionally to
this, we had been recommending and urging developers for years to use
only stored procedures, but we didn't really make a dent.  

So because of all of these factors, when we rolled out a new environment
for CF 7, we made "stored proc's only" part of the rules of using the
new systems.  We don't have the "having to ask the DBA's to make every
change" problem because we have a development SQL server with databases
to which developers have owner access.  They still have to ask for
changes in production, but that's a constraint of our environment, and
the DBA's are fairly responsive to changes during the working day. 

Has this solved our problems?  Well to some degree, yes.  We don't have
random, hard-to-diagnose problems due to database operations anymore.
>From time to time, when we do have issues with our database connections,
I have found them to be much easier to troubleshoot on the MS SQL side,
than on the CF side.  The developers are less happy about it, and I
understand that, but it was something we needed to do.  The important
thing we did though was make sure that many of the disadvantages of
doing this we mitigated.  Like all things it's a trade off, and these
decisions should be made in response to the actual conditions in play,
as opposed to some philosophical or religious reasons.

Terrence Ryan 
Senior Systems Programmer
Wharton Computing and Information Technology 

E-mail: [EMAIL PROTECTED]




~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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

RE: CFexecute in onSessionEnd.

[Ryan, Terrence]

This might be a dumb thing but doen't you have to pass in the session to
onSessionEnd?




It might be causing an error which wouldn't get thrown to anything. 

Terrence Ryan 
Senior Systems Programmer
Wharton Computing and Information Technology 

E-mail: [EMAIL PROTECTED]


-Original Message-
From: Ian Skinner [mailto:[EMAIL PROTECTED] 
Sent: Friday, August 25, 2006 5:37 PM
To: CF-Talk
Subject: CFexecute in onSessionEnd.

Any reason this code would not work in an onSessionEnd function, but a
similar one works just fine in an onApplicationStart function of an
Application.cfc file.


   


~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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

RE: Easy way to kill application

[Ryan, Terrence]

So it the remedy there to surround the OnApplicationStart method with a CFlock?


Terrence Ryan 
Senior Systems Programmer
Wharton Computing and Information Technology 

E-mail: [EMAIL PROTECTED]

-Original Message-
From: Raymond Camden [mailto:[EMAIL PROTECTED] 
Sent: Thursday, August 24, 2006 5:48 PM
To: CF-Talk
Subject: Re: Easy way to kill application

THis is the same method I use. To be anal though - do not forget that when CF 
runs your onApplicationStart, it is thread safe. When you run it, it is not. 
(But for most people this will not matter.)

On 8/24/06, Ryan, Terrence <[EMAIL PROTECTED]> wrote:
> In the OnRequestStart method of the application cfc I have a cf that looks 
> for a url switch.  It then calls OnApplicationStart, which should do what you 
> are trying to achieve.
>
> Terrence Ryan
> Senior Systems Programmer
> Wharton Computing and Information Technology
>
> E-mail: [EMAIL PROTECTED]
>
>
> -Original Message-
> From: Charles Sheehan-Miles [mailto:[EMAIL PROTECTED]
> Sent: Thursday, August 24, 2006 4:38 PM
> To: CF-Talk
> Subject: Easy way to kill application
>
> Never having used application.cfc, I have a question.
>
> In the past (in development only) when I wanted to completely kill my app, I 
> had a url switch which would clear all scopes (including application) on my 
> box. Based on some of the feedback I got earlier today, I downloaded the 
> development version of MX7 and I¹m looking at that as an option.  Is there an 
> easy way (other than restarting CFMX) to completely kill the app?
>
> Charles
>
>
> 



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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

RE: Easy way to kill application

[Ryan, Terrence]

In the OnRequestStart method of the application cfc I have a cf that looks for 
a url switch.  It then calls OnApplicationStart, which should do what you are 
trying to achieve. 

Terrence Ryan 
Senior Systems Programmer
Wharton Computing and Information Technology 

E-mail: [EMAIL PROTECTED]


-Original Message-
From: Charles Sheehan-Miles [mailto:[EMAIL PROTECTED] 
Sent: Thursday, August 24, 2006 4:38 PM
To: CF-Talk
Subject: Easy way to kill application

Never having used application.cfc, I have a question.

In the past (in development only) when I wanted to completely kill my app, I 
had a url switch which would clear all scopes (including application) on my 
box. Based on some of the feedback I got earlier today, I downloaded the 
development version of MX7 and I¹m looking at that as an option.  Is there an 
easy way (other than restarting CFMX) to completely kill the app?

Charles


~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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

RE: Top 100 ColdFusion Programmers

[Ryan, Terrence]

Ray, won't that validate the criticism that you have hordes of followers
that goes after anyone who criticizes you or BlogCFC? 

Although, maybe that's not a bad thing.  

Terrence Ryan 
Senior Systems Programmer
Wharton Computing and Information Technology 

E-mail: [EMAIL PROTECTED]


-Original Message-
From: Raymond Camden [mailto:[EMAIL PROTECTED] 
Sent: Thursday, August 24, 2006 2:43 PM
To: CF-Talk
Subject: Re: Top 100 ColdFusion Programmers

I can say for a fact that there are many CFers who - for whatever reason
- never post to the lists. At most they go to conferences, but they
aren't part of the "noise" of this community. (I say noise in a nice way
of course. ;)

Of course, you do realize that if you make such a list, all you will do
is tick people off... unless you put me on top. :)



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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

RE: OT: Finding Server IP

[Ryan, Terrence]

The thought just occurred to me The original intent of the request
is to figure out basically how to uniquely identify the machine.  IP
address was the tool the guy wanted to use. But there are other ways of
uniquely identifying machines, such as mac address.  But you can't get
that. 

However the docs for CreateUUID states that:

'The ColdFusion UUID generation algorithm uses the unique time-of-day
value, the IEEE 802 Host ID, and a cryptographically strong random
number generator to generate UUIDs that conform to the principles laid
out in the draft IEEE RFC "UUIDs and GUIDs."'

So if ColdFusion can get that IEEE 802 Host ID it must be using Java to
do so, and if Java can do it, you can call that method in ColdFusion. 

However I don't know that method that CF uses to get at that.  I look
around, but couldn't find anything obvious.   Anybody have any clues?

Terrence Ryan 
Senior Systems Programmer
Wharton Computing and Information Technology 

E-mail: [EMAIL PROTECTED]


-Original Message-
From: Snake [mailto:[EMAIL PROTECTED] 
Sent: Saturday, August 19, 2006 4:26 AM
To: CF-Talk
Subject: RE: OT: Finding Server IP

Yes but again you have totally changed the topic and are just trying to
be clever instead of answering the guys question. We were never talking
about machines with virtual servers, vmware, DCHP etc. 
You will also note that I have previously posted that there is no REAL
default.

Snake




~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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

RE: OT: Finding Server IP

[Ryan, Terrence]

Okay, my cfregistry thing probably won't work in that case. 

This may be low-tech and missing the point,  but if you have access to
the code in all places, couldn't you just set a static file with the
name of the host, that you could query on each one.

Terrence Ryan 
Senior Systems Programmer
Wharton Computing and Information Technology 

E-mail: [EMAIL PROTECTED]


-Original Message-
From: Paul Giesenhagen [mailto:[EMAIL PROTECTED] 
Sent: Friday, August 18, 2006 9:50 AM
To: CF-Talk
Subject: Re: OT: Finding Server IP

Example, You are hosting a website at hostmysite.com and another over at
crystaltech.com and yet another at some other server farm.

I want to find out what machine the information is coming from, but not
by website address because there may be 2-3 different sites on each of
the servers and I want to  know that these 2-3 sites are coming from
this server and those 2-3 sites are responding from that server.



Paul Giesenhagen
QuillDesign
417-885-1375
http://www.quilldesign.com
SiteDirector Shopping Cart Software


~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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

RE: OT: Finding Server IP

[Ryan, Terrence]

A. 

If it is a Windows host, this will work:



Assuming you have access to cfregistry.

Terrence Ryan 
Senior Systems Programmer
Wharton Computing and Information Technology 

E-mail: [EMAIL PROTECTED]

-Original Message-
From: Paul Giesenhagen [mailto:[EMAIL PROTECTED] 
Sent: Friday, August 18, 2006 9:20 AM
To: CF-Talk
Subject: Re: OT: Finding Server IP

When I run this script, I am getting the "websites" script, not the
SERVER'S IP Address.

What I am trying to do is verify which server the website is sitting on,
but looking at the servers  IP address, now that may not be the best way
to do this, if someone knows of a better way to IDENTIFY a machine via
CF Code .. 
(and not CFExecute) I would love to hear it.

Thanks!!

Paul Giesenhagen
QuillDesign
417-885-1375
http://www.quilldesign.com
SiteDirector Shopping Cart Software


- Original Message -
From: "John Beynon" <[EMAIL PROTECTED]>
To: "CF-Talk" 
Sent: Friday, August 18, 2006 2:31 AM
Subject: Re: OT: Finding Server IP


> 
> function GetServerIP() {
>  var iaclass="";
>  var addr="";
>
>  // Init class
>  iaclass=CreateObject("java", "java.net.InetAddress");
>
>  //Get Local host variable
>  addr=iaclass.getLocalHost();
>
>  // Return ip address
>  return addr.getHostAddress();
> }
> 
>
> john.
>
> On 8/18/06, Ryan, Terrence <[EMAIL PROTECTED]> wrote:
>> Neil: The CGI Scope would reveal the ip address that the request came
>> through, not the base ip of the server.
>>
>> Paul: You say "not look it up in the operating system tools" does
that
>> mean that using cfexecute to call ipconfig.exe is out?
>>
>>
>> Terrence Ryan
>> Senior Systems Programmer
>> Wharton Computing and Information Technology
>>
>> E-mail: [EMAIL PROTECTED]
>>
>> -Original Message-
>> From: Robertson-Ravo, Neil (RX)
>> [mailto:[EMAIL PROTECTED]
>> Sent: Friday, August 18, 2006 2:14 AM
>> To: CF-Talk
>> Subject: Re: OT: Finding Server IP
>>
>> This info should in the CGI scope.
>>
>>
>>
>> -Original Message-
>> From: Paul Giesenhagen
>> To: CF-Talk
>> Sent: Fri Aug 18 06:21:28 2006
>> Subject: OT: Finding Server IP
>>
>> I am wanting to find out what the SERVER IP address (main IP) of the
>> server my application is running on, not the website's IP address but
>> it's server.
>> Our server runs a number of websites and they all have different IP
>> addresses .. those are not what I am interested in... I want to find
out
>> the SERVER that they are running on's IP address (coding method) not
>> look it up in the operating system tools.
>>
>>
>> Paul Giesenhagen
>> QuillDesign
>> 417-885-1375
>> http://www.quilldesign.com
>> SiteDirector Shopping Cart Software
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>
> 



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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

RE: OT: Finding Server IP

[Ryan, Terrence]

Neil: The CGI Scope would reveal the ip address that the request came
through, not the base ip of the server. 

Paul: You say "not look it up in the operating system tools" does that
mean that using cfexecute to call ipconfig.exe is out? 


Terrence Ryan 
Senior Systems Programmer
Wharton Computing and Information Technology 

E-mail: [EMAIL PROTECTED]

-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED] 
Sent: Friday, August 18, 2006 2:14 AM
To: CF-Talk
Subject: Re: OT: Finding Server IP

This info should in the CGI scope.



-Original Message-
From: Paul Giesenhagen
To: CF-Talk
Sent: Fri Aug 18 06:21:28 2006
Subject: OT: Finding Server IP

I am wanting to find out what the SERVER IP address (main IP) of the
server my application is running on, not the website's IP address but
it's server.
Our server runs a number of websites and they all have different IP
addresses .. those are not what I am interested in... I want to find out
the SERVER that they are running on's IP address (coding method) not
look it up in the operating system tools.


Paul Giesenhagen
QuillDesign
417-885-1375
http://www.quilldesign.com
SiteDirector Shopping Cart Software









~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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

RE: Application.CFC unusual behavior.

[Ryan, Terrence]

I just ran your code and did see it in the source. 

Is it possible that due to whitespace, the string was pushed down in the
source?

Terrence Ryan 
Senior Systems Programmer
Wharton Computing and Information Technology 

E-mail: [EMAIL PROTECTED]

-Original Message-
From: Ian Skinner [mailto:[EMAIL PROTECTED] 
Sent: Thursday, August 17, 2006 5:51 PM
To: CF-Talk
Subject: Application.CFC unusual behavior.

Ok this is a bit weird.  I am playing with Application.cfc trying to
figure out its peculiarities.  I saw in the CFML documentation an
example of an output in the onApplicationStart function.  That seemed
odd but I gave it a try.  It worked in that the string I outputted was
sent to the browser, but the really weird part was that the string does
not appear in the source!

Is there somewhere that might document this behavior?  Is it a bug or a
feature?  If a feature, how would one use this in a legitimate manner?


 
this.name="AppCFC Testing";
this.applicationTimeout = createTimeSpan(0,0,5,0);
this.clientManagement = false;
loginStorage = "Session";
sessionManagement = true;
sessionTimeout = createTimeSpan(0,0,2,0); 



This is where code that runs when the application starts goes.





I haven't tried this form other functions yet.

--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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

RE: Using SMS on Coldfusion 7

[Ryan, Terrence]

I go this information from Dan Alig, one of my co-workers:


http://www.m-qube.com/ (they're now owned by VeriSign)

If they're just pushing messages out and won't be receiving them or
initiating interactive sessions, then the gateway might be overkill (and
an unnecessary expense).  If they know the users' cell numbers and
carriers, they could probably get away with using cfmail

Terrence Ryan 
Senior Systems Programmer
Wharton Computing and Information Technology 

E-mail: [EMAIL PROTECTED]

-Original Message-
From: Chad McCue [mailto:[EMAIL PROTECTED] 
Sent: Thursday, August 17, 2006 1:17 PM
To: CF-Talk
Subject: Using SMS on Coldfusion 7

I am trying to develop a system that will send short text message to
some contractors cell phones when a bid has been approved and I am
trying to figure out what providers people are using and how to go about
setting up an account with a provider that supports SMPP 3.4 over
TCP/IP.
 
I am from the Boston area if that helps anyone.
 
Thanks.




~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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

RE: Performance problem

[Ryan, Terrence]

If for some reason the thought of resorting to Java scares you, (or you
didn't know about Ben's solution)  you could change the way you are
concatenating. 

If you are doing loops within loops, you can you temporary string
variables that you use only for the loop, then rejoin it to the larger
string. 

I've seen a 10 minute process drop to 11 seconds after doing this in
selected locations. 

You can use a combination of  and "." characters spread
throughout your code to see the actual slowdown occur, then fix those
sections. 

Terrence Ryan 
Senior Systems Programmer
Wharton Computing and Information Technology 

E-mail: [EMAIL PROTECTED]


-Original Message-
From: Ben Nadel [mailto:[EMAIL PROTECTED] 
Sent: Thursday, August 17, 2006 1:07 PM
To: CF-Talk
Subject: RE: Performance problem

When doing a lot of string concatenation, you should totally use the
Java string buffer:








To only does the concatentation once at the end via the ToString()
method.
This will make it blazing fast.

This should replace anywhere you build the output for the file.


Ben Nadel
www.bennadel.com

-Original Message-
From: Rick Root [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 17, 2006 11:03 AM
To: CF-Talk
Subject: Performance problem

I have some code that dynamically generates CSV, TAB, and EXCEL (HTML
tables) from a query, and it is running pretty slowly.  A lot slower
than I'd like it to.  Essentially, I set a bunch of variables like
START_PAGE, END_PAGE, START_ROW, END_ROW, START_FIELD, and END_FIELD
that allow me to loop through the query and loop through the list of
fields and output the data in the appropriate format.

I added some debugging code and generating 124 rows took 19 seconds. 
Generating 1416 rows took 309 seconds.  Which means if someone wants to
generate a drop with 5,000 rows, it's gonna take a long freakin' time!

It seems like it shouldn't be that slow.  It's only writing every 100
rows to disk (the 124 record file was 445KB).  And a couple of cflog
statements indicate that the file write takes less than a second.

Here's the query loop that outputs the rows of data.






















I suspect that it's the Evaluate() that's running slowly.

Any ideas on how to speed this code up?

Thanks!

Rick





~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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

RE: getMetricData function not work on CF 7 multiserver installation ?

[Ryan, Terrence]

>From what I remember, getMetricData doesn't work at all on a Multiserver
configuration.  

What I think that technote does is tell you how to get equivalent metric
data out of Jrun and into a log file, which you can't consume in
ColdFusion (without using cffile.)



Terrence Ryan 
Senior Systems Programmer
Wharton Computing and Information Technology 

E-mail: [EMAIL PROTECTED]


-Original Message-
From: Hua Wei [mailto:[EMAIL PROTECTED] 
Sent: Thursday, August 10, 2006 10:39 AM
To: CF-Talk
Subject: getMetricData function not work on CF 7 multiserver
installation ?

Hello,

For some reason, I can't get metrics running on our coldfusion 7.0.2
servers (Enterprise Multiserver Version on windows 2003, window 2000). I
got  "The metrics service is not available" error when calling
getMetricData function. 

I followed the instruction of TechNote "ColdFusion MX: Enabling metrics
logging"
(http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=tn_19120)
and enabled JRun metrics logging, seemed the metrics info was logged
into cfusion-out.log, ===
08/09 00:30:56 metrics Web threads (busy/total): 3/5 Sessions: 1 Total
Memory=46144 Free=26914 ===

but when i tried to call function getMetricData("perf_monitor"), I got
"The metrics service is not available." error and the log showed


08/09 00:43:10 Error [jrpp-4] - The metrics service is not
available.This exception is usually caused by service startup failure.
Please check your server configuration. The specific sequence of files
included or processed is: F:\wwwroot\test.cfm, line: 6


I noticed the following message during server setup:
"08/09 00:29:46 Information [scheduler-9] - The metrics service is
disabled for the J2EE edition"

also, according to coldfusion help manual "To receive data, you must
enable PerfMonitor in ColdFusion Administrator before executing the
function.", but I couldn't find the "enable PerfMonitor" option in
coldfusion admin.
(http://livedocs.macromedia.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/com
mon/html/wwhelp.htm?context=ColdFusion_Documentation&file=0489.htm )


What am i missing here? How to enable the metrics service on multiserver
installs? Does getMetricData not work on multiserver installs ? 

Thanks

Hua



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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

RE: Limits on Blob Size in Datasource

[Ryan, Terrence]

Thanks for the info, James, and Dave. 

I'm still torn.  Secretly I was hoping someone would say "You can't do
that, your Coldfusion server will explode!" But as it is, it's another
exercise in tradeoffs. 

Maybe I will add a new tag to the Scorpio request queue:



Terrence Ryan 
Senior Systems Programmer
Wharton Computing and Information Technology 

E-mail: [EMAIL PROTECTED]



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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

Limits on Blob Size in Datasource

[Ryan, Terrence]

I've come up against a problem where I need to consider using SQL to
handle image storage.  I know the positives and negatives of doing so
(File system might be a better choice, but SQL is easier to manage
across cluster nodes... etc etc.)

I'm wondering, if I decide to do this, what are the possible downsides
from a server performance standpoint.  I ask, because I assume that if
there was none, then the "Enable binary large object retrieval (BLOB)"
setting would be defaulted to TRUE instead of FALSE.  

Another way to do this would just to raise the Blob buffer size and
program in a limit to the application.  

Is there any common wisdom about this?  Is there a preferred solution,
or has anyone had any nightmare experiences?

Terrence Ryan
Senior Systems Programmer
Wharton Computing and Information Technology   
E-mail: [EMAIL PROTECTED]





~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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

RE: Advanced Developer Average Salary

[Ryan, Terrence]

I'm in. 

Terrence Ryan 
Senior Systems Programmer
Wharton Computing and Information Technology 

E-mail: [EMAIL PROTECTED]


-Original Message-
From: Matt Williams [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, August 01, 2006 11:23 AM
To: CF-Talk
Subject: Re: Advanced Developer Average Salary

If people are interested, willing and not offended, I'll set up a quick
anonymous poll so people here could enter their annual salary, city,
state, country, years with CF, and comments.

It wouldn't be scientific by any means, but it could be some interesting
data.

A few yes's and I'll get it going.

Matt

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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

RE: cfproperty vs. setting variables for in a cfc

[Ryan, Terrence]

 doesn't create values, or parameterize them.  It creates
meta data.  It tells an introspecting agent (webservice user) to expect
values, but that's about it. 

Additionally, the values that correspond to the cfproperties would be
created by setting them like this: 


 This.myVar = "Hello";


As variable scoped variables within a CFC are unavailable outside the
CFC. 

Terrence Ryan 
Senior Systems Programmer
Wharton Computing and Information Technology 

E-mail: [EMAIL PROTECTED]

-Original Message-
From: Ken Fused [mailto:[EMAIL PROTECTED] 
Sent: Friday, July 28, 2006 1:53 PM
To: CF-Talk
Subject: cfproperty vs. setting variables for in a cfc

In creating a CFC, what is the difference between 





 variables.myVar = "Hello";


I realize that the  tag is used for webservices.  But if I
am not creating a webservice, just a simple cfc is there an advantage in
using  over just setting the variable.  It would appear as
though I have the advantage of establishing a data type. 



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:248058
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: CF 8 feature survey

[Ryan, Terrence]

Can't this particular issue be resolved if you use the existing "failto"
attribute of CFMAIL?

As this would route failed mail to a specific email address instead of
the Undelivr folder.

Granted it's sub optimal, in that you have to look someplace else for
the messages. 



Terrence Ryan 
Senior Systems Programmer
Wharton Computing and Information Technology 

E-mail: [EMAIL PROTECTED]

-Original Message-
From: Mike Kear [mailto:[EMAIL PROTECTED] 
Sent: Friday, July 28, 2006 1:10 AM
To: CF-Talk
Subject: Re: CF 8 feature survey

I would like to see some better email debugging.   At the moment
there's none.  You fill out a form, click submit, then wait .. and wait
... and wait .. and eventually conclude that your email isnt going to
arrive.

Then with nothing to go on except the assumption that your email didnt
work, you try to debug what might be the problem.   THen try again ..

and wait . and wait . and wait . and wait.

In  a shared environment you dont even get to see the failed emails cos
they are in a system level folder.  Try to ask the  sysadmin to pick out
yours and they are confronted with a undelivr folder with who knows how
many emails in there and they are asked to scan through them
all for you.   If they feel like it.

I reckon it should be possible for the CFMAIL tag to produce far better
error reporting than just  ** *NOTHING **

And Peter TIlbrook came up with a great idea today - why cant the
Undelivr folder be in the shared web space somewhere  - each site owner
can have their own maybe a "failto="" kind of parameter in the CFMAIL
tag. so the failed emails will be where we can all get at them and have
a look at what the problem is.

It's got to be better than "send an email and see if it works, if it
doesnt  try something else  and see if that works "

Cheers
Mike Kear
Windsor, NSW, Australia
Certified Advanced ColdFusion Developer
AFP Webworks
http://afpwebworks.com
ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:248000
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: CF 8 feature survey

[Ryan, Terrence]

To be a little more... verbose. 

You have to install 7.0.1 before you install 7.0.2 or you get an
annoying error about it not being able to find the CFIDE directory. 


Terrence Ryan 
Senior Systems Programmer
Wharton Computing and Information Technology 

E-mail: [EMAIL PROTECTED]


-Original Message-
From: loathe [mailto:[EMAIL PROTECTED] 
Sent: Thursday, July 27, 2006 4:35 PM
To: CF-Talk
Subject: RE: CF 8 feature survey

Nope.

> -Original Message-
> From: Steve Brownlee [mailto:[EMAIL PROTECTED]
> Sent: Thursday, July 27, 2006 4:30 PM
> To: CF-Talk
> Subject: RE: CF 8 feature survey
> 
> Yep
> 
> -Original Message-
> From: Raymond Camden [mailto:[EMAIL PROTECTED]
> Sent: Thursday, July 27, 2006 4:27 PM
> To: CF-Talk
> Subject: Re: CF 8 feature survey
> 
> Isn't that what CF 7.0.2 does?
> 
> On 7/27/06, loathe <[EMAIL PROTECTED]> wrote:
> > Hey Adobe, how about integrating updater one and updater 2?
> >
> > Thanks
> >
> 
> 
> 
> --
> ==
> ==
> ===
> Raymond Camden, Vice President of Technology for roundpeg
> 
> Email: [EMAIL PROTECTED]
> Blog : ray.camdenfamily.com
> AOL IM   : cfjedimaster
> 
> "My ally is the Force, and a powerful ally it is." - Yoda
> 
> 
> 
> 



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247929
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Reactor informational page?

[Ryan, Terrence]

Joe Rinehart has some good posts about Reactor, and why he chose to use
it.

http://clearsoftware.net/index.cfm?mode=entry&entry=69912BE8-3048-55C9-4
3004A57A7D89D52
http://clearsoftware.net/index.cfm?mode=entry&entry=6A93519A-3048-55C9-4
301E984440DF01B

and this might be helpful too:
http://www.talkingtree.com/blog/index.cfm/2006/1/19/Doug-Hughes-on-React
or


Terrence Ryan 
Senior Systems Programmer
Wharton Computing and Information Technology 

E-mail: [EMAIL PROTECTED]

-Original Message-
From: Andy Matthews [mailto:[EMAIL PROTECTED] 
Sent: Thursday, July 27, 2006 10:20 AM
To: CF-Talk
Subject: RE: Reactor informational page?

Yeah. but it's all jargon. Given the time he put into the Image
Component and the great docs there, I'm surprised he went this route.
Those docs are really only helpful if you're actually installing it, not
just trying to determine whether it's worth even downloading.

It's no biggie...my user group is discussing Reactor this evening and I
just wanted to read up on it so that I could ask some informed
questions.



-Original Message-
From: Tom Chiverton [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 27, 2006 8:45 AM
To: CF-Talk
Subject: Re: Reactor informational page?


On Wednesday 26 July 2006 18:35, Andy Matthews wrote:
> Does anyone have a page that walks through using Reactor? I've found 
> the livedocs site for it but that's more detailed. I'm looking for 
> more of a basic informational page on it's benefits.

Did you see the background / getting started bits of the live doc ?

--
Tom Chiverton



This email is sent for and on behalf of Halliwells LLP.

Halliwells LLP is a limited liability partnership registered in England
and Wales under registered number OC307980 whose registered office
address is at St James's Court Brown Street Manchester M2 2JF.  A list
of members is available for inspection at the registered office. Any
reference to a partner in relation to Halliwells LLP means a member of
Halliwells LLP.
Regulated by the Law Society.

CONFIDENTIALITY

This email is intended only for the use of the addressee named above and
may be confidential or legally privileged.  If you are not the addressee
you must not read it and must not use any information contained in nor
copy it nor inform any person other than Halliwells LLP or the addressee
of its existence or contents.  If you have received this email in error
please delete it and notify Halliwells LLP IT Department on 0870 365
8008.

For more information about Halliwells LLP visit www.halliwells.com.






~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247867
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: Creating an indented department directory

[Ryan, Terrence]

I would recommend using nested lists for this. 

So 

Division 1

Department 1-a
Department 1-b


Division 2

Department 2-a
Department 2-b




It has the advantage of already indenting this stuff for you, and being
semantically correct.(In that these are lists of departments contained
within a list of divisions )

Terrence Ryan 
Senior Systems Programmer
Wharton Computing and Information Technology 

E-mail: [EMAIL PROTECTED]


-Original Message-
From: Steven Sprouse [mailto:[EMAIL PROTECTED] 
Sent: Friday, July 21, 2006 9:58 AM
To: CF-Talk
Subject: Creating an indented department directory

I posted the other day about creating school pages and all of you were
extremely helpful.  Thank you!  I have another issue today.

I'm trying to create a department directory where we list the six main
divisions and then indented a little bit are the departments that fall
under that division (I know the indeted part will be done with some
css).

I have a table with DeptID, DeptName and SubDeptOf where SubDeptOf
corresponds to the DeptID it falls under.  I got CF to generate a
department listing (see here
http://www.ccboe.com/website/departments/departments_main.cfm) but I
want to take it to the next level.

Any help???



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:247280
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: CFLDAP and AD

[Ryan, Terrence]

Here's the query I use to do this. 



Notice that you have to append the domain to the username to get it to
work.

I'm currently trying to get LDAPS working, so if you can do it, that
would be preferable to what I currently have.

Terrence Ryan 
Senior Systems Programmer
Wharton Computing and Information Technology 

E-mail: [EMAIL PROTECTED]


-Original Message-
From: Sam Mayes [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, July 18, 2006 12:27 PM
To: CF-Talk
Subject: CFLDAP and AD

Hi All Im trying to do some authentication with cfldap and Active
Directory and was wondering if anyone has come across this. Using cf
7.02


if my cn and displayname are the same ie: cn=test123 displayname=test123
i can authenticate just fine with just username and pass in the cfldap
call.

if they are different cn=test123 displayname=testuser I have to pass the
whole dn as the user ie: cn=test123 cn=users dn=orgname dn=company
dn=com


Is it a permission issue with the subtree query? Im at a loss as far as
why they authenticate differently ANY help would be lovely here is my
cfldap call:

   










Sam




~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:246921
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Low-tech asychronous call to ColdFusion

[Ryan, Terrence]

I posted a different solution here:
http://www.numtopia.com/terry/blog/archives/2006/07/asynchronous_cfml_wi
thout_a_gateway.cfm

It does require using a cfc though. 

Terrence Ryan 
Senior Systems Programmer
Wharton Computing and Information Technology 

E-mail: [EMAIL PROTECTED]




~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:246794
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: CFMail Throttling for CFerror handling

[Ryan, Terrence]

You could add code to all of your error trapping that specifically traps
database errors. Then in the handling for that check for the existence
of a application or server scope (depending on how many applications you
have on the server) variable like say "server.dberrorReported." If it
does not exist or is false, send the email and set
"server.dberrorReported" to true.  If "server.dberrorReported" is true,
than just log the error.   You would then have to remember to reset the
variable to false when the problem is over.

There are caveats to using the server scope.  Which I'm sure people will
chime in about. 
 
I would also recommend trying to go after the underlying issue.  If
losing your database server and generating enough errors to clogs your
mailserver, is happening frequently enough to cause you to try and
change your error handling techniques, you may need to re-evaluate your
configuration, hardware or networking. 

Terrence Ryan 
Senior Systems Programmer
Wharton Computing and Information Technology 

E-mail: [EMAIL PROTECTED]





~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:246769
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: CFNTauthenticate and PDC emulator

[Ryan, Terrence]

I left that out, but yes, to no avail.

I'm wondering if there is a good reason to use CFNTauthenticate at all
if it is so fragile.  

Terrence Ryan 
Senior Systems Programmer
Wharton Computing and Information Technology 

E-mail: [EMAIL PROTECTED]

-Original Message-
From: Dawson, Michael [mailto:[EMAIL PROTECTED] 
Sent: Friday, July 14, 2006 5:33 PM
To: CF-Talk
Subject: RE: CFNTauthenticate and PDC emulator

I don't think you are overthinking it.  I build a ldap CFC that will
test a list of DCs until it finds one that is responding to ldap
requests.

You have a pretty-detailed post, so I may be stating the obvious.  Did
you restart your CF services yet?

M!ke 

-Original Message-----
From: Ryan, Terrence [mailto:[EMAIL PROTECTED]
Sent: Friday, July 14, 2006 12:19 PM
To: CF-Talk
Subject: CFNTauthenticate and PDC emulator

Environment: 
ColdFusion 6 and 7 running on Windows 2003  Servers Active Directory
Domain running in Native Mode on Windows 2003 Servers

I recently had a problem where CFNTauthenticate on ColdFusion 7 stopped
working. All attempts to authenticate were failing with the error of
"UserNotInDir" failure if thrownonerror was set to false.  If
throwonerror was set to true, then I got the message that : "Could not
find domain controller for this domain "

Additionally, similar results were experienced by ColdFusion 6 servers
using the ntauth class for domain authentication. 

At the same time this occurred one of our domain controllers was down
due to a switch failure.  However we have many redundant domain
controllers spread over three sites, including one in the same rack as
our CF servers. No other services (Exchange, Machine Logins, etc) were
impacted.

Upon further inspection, it was determined that one of the dc's that was
down was playing the Active Directory FSMO role of PDC emulator.
Further testing shows that we cannot get authentication to work if a
ColdFusion machine is unable to contact the PDC emulator regardless of
the state of the rest of the domain. 

In order to work around this, I'm developing a alternative
authentication piece that uses LDAP authentication against the domain,
and can switch between domain controllers if one is down.  I can do it,
and make it pretty robust, but I'm worried though that I may be over
thinking this.   

Has anyone else experienced this?  If you have, short of getting the PDC
emulator back online, is there a way around this.  Any other opinions or
feedback would be welcome. 
 

Terrence Ryan
Senior Systems Programmer
Wharton Computing and Information Technology   
E-mail: [EMAIL PROTECTED]









~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:246644
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

CFNTauthenticate and PDC emulator

[Ryan, Terrence]

Environment: 
ColdFusion 6 and 7 running on Windows 2003  Servers
Active Directory Domain running in Native Mode on Windows 2003 Servers

I recently had a problem where CFNTauthenticate on ColdFusion 7 stopped
working. All attempts to authenticate were failing with the error of
"UserNotInDir" failure if thrownonerror was set to false.  If
throwonerror was set to true, then I got the message that : "Could not
find domain controller for this domain "

Additionally, similar results were experienced by ColdFusion 6 servers
using the ntauth class for domain authentication. 

At the same time this occurred one of our domain controllers was down
due to a switch failure.  However we have many redundant domain
controllers spread over three sites, including one in the same rack as
our CF servers. No other services (Exchange, Machine Logins, etc) were
impacted.

Upon further inspection, it was determined that one of the dc's that was
down was playing the Active Directory FSMO role of PDC emulator.
Further testing shows that we cannot get authentication to work if a
ColdFusion machine is unable to contact the PDC emulator regardless of
the state of the rest of the domain. 

In order to work around this, I'm developing a alternative
authentication piece that uses LDAP authentication against the domain,
and can switch between domain controllers if one is down.  I can do it,
and make it pretty robust, but I'm worried though that I may be over
thinking this.   

Has anyone else experienced this?  If you have, short of getting the PDC
emulator back online, is there a way around this.  Any other opinions or
feedback would be welcome. 
 

Terrence Ryan
Senior Systems Programmer
Wharton Computing and Information Technology   
E-mail: [EMAIL PROTECTED]





~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:246595
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: FAQ?

[Ryan, Terrence]

I think another cool thing to point out about the ColdFusion Cookbook is
that you don't have to wait for Ray or Jeremy to speak Ex Cathedra about
the best practices.  Anyone can submit a page for consideration.  

Which is really cool, in my opinion, yours may vary.

Thanks for it, Ray. 

Terrence Ryan 
Senior Systems Programmer
Wharton Computing and Information Technology 

E-mail: [EMAIL PROTECTED]

-Original Message-
From: Raymond Camden [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, July 12, 2006 9:58 AM
To: CF-Talk
Subject: Re: FAQ?

Speaking just for myself (www.coldfusioncookbook.com), my philosophy
behind the site is that every answer is the best. Now - I know that
sounds egotistical. What I meant is, like CFLib, we try to publish what
we consider best practice 100% of the time. Obviously I'm no
brainiac.What I'm trying to get through is that what you see on the
cookbook site would be considered best practice, at least by myself,
Jeremy, and the other authors. (And again, I know the sites aren't
perfect.)

The cookbook site seems to almost be in stealth mode.We have over 100
entries, all available via PDF, so the content is growing, but the
traffic is still a bit light. Hopefully these posts will help drive some
traffic to the site. :)

On 7/12/06, Mingo Hagen <[EMAIL PROTECTED]> wrote:
> Raymond Camden wrote:
> > While they don't say "best", there is cffaq.com from Ben Forta and 
> > www.coldfusioncookbook.com from myself and Jeremy Petersen.
> >
> Well... this is almost exactly what i meant (I need to google better) 
> I do miss some stuff like I mentioned in my other mails, more geared 
> towards different solutions to one problem and perhaps you could add a

> function (like on imdb.com) where users can say 'this tip was useful
to me'.
>
> Mingo.
>
>
> 



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:246270
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Select * in SQL

[Ryan, Terrence]

Thanks to all who responded. 

You have given me a better set of answers now. 

Terrence Ryan 
Senior Systems Programmer
Wharton Computing and Information Technology 

E-mail: [EMAIL PROTECTED]


-Original Message-
From: Ryan, Terrence [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, July 11, 2006 11:05 AM
To: CF-Talk
Subject: Select * in SQL

I have a dumb question. Can someone point me to a definitive explanation
of why select * in SQL is bad?   

I've found this : http://www.adopenstatic.com/faq/selectstarisbad.asp
but I  don't thing it effectively counters the argument "But I need all
of the columns in the table."

Mind you, that I'm not looking for convincing for myself, rather I'm
doing a code review, and want to be have a stronger footing for saying:
"Get rid of the select *'s."

Terrence Ryan
Senior Systems Programmer
Wharton Computing and Information Technology   
E-mail: [EMAIL PROTECTED]







~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:246113
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: Code Colors

[Ryan, Terrence]

I have a cfc that generates styled HTML that does it for me.  Using it
to do that might be a bit of a cludge, but I'd be happy to share it with
you. 

But it has difficulty with complex code. 

Terrence Ryan 
Senior Systems Programmer
Wharton Computing and Information Technology 

E-mail: [EMAIL PROTECTED]

-Original Message-
From: Troy Simpson [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, July 11, 2006 11:11 AM
To: CF-Talk
Subject: Code Colors

I need to write some documentation and I need to included some code in
the documentation.  I would like to color the code that is in the
documentation the way that Dreamweaver or Homesite does.

Has anyone had to do this before?

Is there anyway to do this easily?
Or am I going to have to set the font color for each little bit of text.
This is going to take forever.

--
Thanks,
Troy



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:246109
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Select * in SQL

[Ryan, Terrence]

I have a dumb question. Can someone point me to a definitive explanation
of why select * in SQL is bad?   

I've found this : http://www.adopenstatic.com/faq/selectstarisbad.asp
but I  don't thing it effectively counters the argument "But I need all
of the columns in the table."

Mind you, that I'm not looking for convincing for myself, rather I'm
doing a code review, and want to be have a stronger footing for saying:
"Get rid of the select *'s."

Terrence Ryan
Senior Systems Programmer
Wharton Computing and Information Technology   
E-mail: [EMAIL PROTECTED]





~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:246095
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: GPG and cfexecute, or...

[Ryan, Terrence]

Not necessarily.  I've had issues with apps not working through
ColdFusion, but working through the command line.  The only way they get
picked up is if you restart the machine, and then you get a DEP popup
error, explaining what happened. 

Terrence Ryan 
Senior Systems Programmer
Wharton Computing and Information Technology 

E-mail: [EMAIL PROTECTED]


-Original Message-
From: Tom Chiverton [mailto:[EMAIL PROTECTED] 
Sent: Monday, July 10, 2006 11:43 AM
To: CF-Talk
Subject: Re: GPG and cfexecute, or...

On Monday 10 July 2006 16:33, Ryan, Terrence wrote:
> Depending on the OS of the ColdFusion server (Windows 2003, or XP) it 
> could be that DEP is blocking GPG.

In which case you wouldn't be able to run it by hand either.
You did try that, right Ken ? :-)

--
Tom Chiverton



This email is sent for and on behalf of Halliwells LLP.

Halliwells LLP is a limited liability partnership registered in England
and Wales under registered number OC307980 whose registered office
address is at St James's Court Brown Street Manchester M2 2JF.  A list
of members is available for inspection at the registered office. Any
reference to a partner in relation to Halliwells LLP means a member of
Halliwells LLP. Regulated by the Law Society.

CONFIDENTIALITY

This email is intended only for the use of the addressee named above and
may be confidential or legally privileged.  If you are not the addressee
you must not read it and must not use any information contained in nor
copy it nor inform any person other than Halliwells LLP or the addressee
of its existence or contents.  If you have received this email in error
please delete it and notify Halliwells LLP IT Department on 0870 365
8008.

For more information about Halliwells LLP visit www.halliwells.com.




~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:245954
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: GPG and cfexecute, or...

[Ryan, Terrence]

Cfexecute should still return the command line error. 

Depending on the OS of the ColdFusion server (Windows 2003, or XP) it
could be that DEP is blocking GPG. 

If you have access to the server see if you can add gpg.exe to the list
of applications not excluded by DEP. 

To edit DEP:
Go to System Properties -> Advanced - > Performance -> Settings - > Data
Execution Prevention. 
 

Terrence Ryan 
Senior Systems Programmer
Wharton Computing and Information Technology 

E-mail: [EMAIL PROTECTED]

-Original Message-
From: Ken Ferguson [mailto:[EMAIL PROTECTED] 
Sent: Monday, July 10, 2006 11:22 AM
To: CF-Talk
Subject: GPG and cfexecute, or...

I'm trying to encrypt a download file with gpg and I'm having some
problems. First off, I'm just running the following code as a test of
returning anything from the exe:



Every time I get the error that "Variable fp is undefined". I copied the
netsat executable into the same directory and I can run/dump it just
fine from there, but the gpg just doesn't seem to have any success
running. Is anyone else using gpg who may be able to help me out a
little -- maybe there's a better alternative to using cfexecute even?? 
I've got Wayne Graham's java wrapper and cfc from a year or two ago, but
as he warned it's not really working very well with the latest versions
of gpg. It always just returns "no valid OpenPGP data found."

Anyway, TIA

-- 


*
Ken Ferguson
214.636.6126
*





~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:245940
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: Good Programming Books or Other Resources

[Ryan, Terrence]

I second the nod for "Code Complete."

Terrence Ryan 
Senior Systems Programmer
Wharton Computing and Information Technology 

E-mail: [EMAIL PROTECTED]

-Original Message-
From: Howard Owens [mailto:[EMAIL PROTECTED] 
Sent: Monday, July 10, 2006 2:43 AM
To: CF-Talk
Subject: RE: Good Programming Books or Other Resources

I liked "pragmatic programmer" and "code complete."


-Original Message-
From: PETER SHEATS [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, July 05, 2006 6:17 AM
To: CF-Talk
Subject: Good Programming Books or Other Resources


So my question would be this: What books, tutorials, or resources would
you recommend that a beginning programmer should read that would 1) give
him the best foundation in programming and 2) save him from headaches
and trouble down the road.  So basically, what do you know now that you
wish you knew back at the beginning of your career, and how should I go
about learning that?







~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:245876
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: File ftp from cfserver to a data server

[Ryan, Terrence]

 should be able to do it using UNC paths.  As long as the
ColdFusion service is running under a user account that has access to
the UNC share.

Terrence Ryan 
Senior Systems Programmer
Wharton Computing and Information Technology 

E-mail: [EMAIL PROTECTED]

-Original Message-
From: John Lucania [mailto:[EMAIL PROTECTED] 
Sent: Saturday, July 08, 2006 10:48 PM
To: CF-Talk
Subject: File ftp from cfserver to a data server

I have an .xls file on cfserver and need to ftp the file to database
server daily (= to be on the Schedule Task).   The source path is
\\intranet\dfs\HR\EMPList.xls and the target path is
\\IntraEDU\E:\EMPData

how do you accomplish this task?

tia

jl



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:245831
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4