JRUN Intermittent Death

2013-06-06 Thread Paul Alkema

Hi All,
A couple of weeks ago I applied the APSB13-13, APSB13-03 and ColdFusion 9.0.2 
Cumulative Hotfix 1. After applying this patch however, I've been experiencing 
intermittent outages where the jrun service seems to spike. I'm not totally 
confident it was the patches that did it, but that's the only thing I can think 
of that changed since then. The issue actually started popping up two days 
after the patches were successfully applied.

Do you guys think it could be the patches? I would really hate to un-patch my 
server. One thing that had occurred to me, is that my server instance of 
ColdFusion is currently using JVM 1.6. Does anyone thing upgrading to JVM 1.7 
would help?

What are the pros and cons of using JVM 1.7?

Thanks,
Paul 

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


Re: Sessions failing due to multiple CFID / CFTOKEN cookies

2012-07-25 Thread Paul Alkema

 We're encountering the following issue with some percentage of IE 
 users (Definitely but not necessarily limited to IE8 8.0.7601.17514  
 windows 7).  Basically their SESSION is failing the same way it might 
 if they're cookies were disabled, however, we are able to set cookies 
 manually using CFCOOKIE.  After running several tests, we found that 
 the users request headers include 2 CFID and CFTOKEN cookies.  It 
 seems like Coldfusion writes both into the COOKIE scope, then can't 
 translate them into the SESSION so creates a new (third) CFID and 
 CFTOKEN pair, then overwrites the value of both in the COOKIE scope.
 
 CGI.HTTP_COOKIES
 --
 CFID=19602005; CFTOKEN=13461642; (other cookies removed); 
 CFID=20907643; CFTOKEN=42056124; (other cookies removed);
 
 
 COOKIES
 --
 struct
 CFID  20907644
 CFID  20907644
 CFTOKEN   22098534
 CFTOKEN   22098534
 
 
 SESSION
 --
 struct
 cfid  20907644
 cftoken   22098534
 sessionid APPNAME_20907644_22098534
 urltoken  CFID=20907644CFTOKEN=22098534
 
 
 Anybody know what could be going on here? Thanks in advance! 


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


Maximum Post Variables

2012-06-28 Thread Paul Alkema

Hi All,
I'm running into an issue, where when I create over 100 different form elements 
with different content I get a 500 error. I'd like to increase this number up 
from 100 however I can't find an area to do this.

My original thought was that it was in the ColdFusion Administrator -- 
settings -- Maximum size of post data however, when I upped this, it had no 
effect on the number of post variables. I think this setting seems to be the 
post variable size, as like for file uploads ect...

I'm running on ColdFusion 9.0.2 and when I run the code below and hit submit I 
receive an error. Anyone have any ideas?

form action= method=post
cfoutput
cfloop from=1 to=100 index=i
input name=txtBox#i# type=hidden value=txtValue#i# /
/cfloop
/cfoutput
input type=submit name=txtButton /
/form 


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


Maximum Post Variables

2012-06-28 Thread Paul Alkema

Hi All,
I'm running into an issue, where when I create over 100 different form elements 
with different content I get a 500 error. I'd like to increase this number up 
from 100 however I can't find an area to do this.

My original thought was that it was in the ColdFusion Administrator -- 
settings -- Maximum size of post data however, when I upped this, it had no 
effect on the number of post variables. I think this setting seems to be the 
post variable size, as like for file uploads ect...

I'm running on ColdFusion 9.0.2 and when I run the code below and hit submit I 
receive an error. Anyone have any ideas?

form action= method=post
cfoutput
cfloop from=1 to=100 index=i
input name=txtBox#i# type=hidden value=txtValue#i# /
/cfloop
/cfoutput
input type=submit name=txtButton /
/form 


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


Re: Maximum Post Variables

2012-06-28 Thread Paul Alkema

Hi Wil,
This is exactly what I was looking for. Thanks!!

Paul


 There are several blogs that talk about this.  It is a 'setting'
 
 http://www.cutterscrossing.com/index.
 cfm/2012/3/27/ColdFusion-Security-Hotfix-and-Big-Forms
 
 
 Here's one.
 
 
 
 
 Wil Genovese
 Sr. Web Application Developer/
 Systems Administrator
 CF Webtools
 www.cfwebtools.com
 
 wilg...@trunkful.com
 www.trunkful.com
 
 On Jun 29, 2012, at 3:55 PM, Paul Alkema wrote:
 
  
  Hi All,
  I'm running into an issue, where when I create over 100 different 
 form elements with different content I get a 500 error. I'd like to 
 increase this number up from 100 however I can't find an area to do 
 this.
  
  My original thought was that it was in the ColdFusion Administrator 
 -- settings -- Maximum size of post data however, when I upped 
 this, it had no effect on the number of post variables. I think this 
 setting seems to be the post variable size, as like for file uploads 
 ect...
  
  I'm running on ColdFusion 9.0.2 and when I run the code below and 
 hit submit I receive an error. Anyone have any ideas?
  
  form action= method=post
  cfoutput
 cfloop from=1 to=100 index=i
 input name=txtBox#i# type=hidden value=txtValue#i# 
 /
 /cfloop
 /cfoutput
 input type=submit name=txtButton /
  /form 
  
  
  



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


Re: Encrypt/Decrypt

2011-06-17 Thread Paul Alkema

My preferred encryption algorithm is AES, as this is what the Government
uses to encrypt classified documents. :)

Paul Alkema
http://paulalkema.com
http://twitter.com/#!/paulalkema


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


Re: CDN and Coldfusion

2011-06-15 Thread Paul Alkema

Hi Donnie,
First off, let me just say I'm no CDN expert but have used CDN's several
times and am fairly familiar with them.

From what it sounds like, your asking if you can have a CDN run and
distribute ColdFusion applications? As far as I know, this isn't a
capability of a CDN, that would be more for something like a mirrored
server.

CDN's are for distributing content like images, css, javascript and any
other client based content. One thing worth mentioning though, is that
(according to yahoo***) an average of 80% of the front end load time is
spent loading what a CDN is capable of distributing. Also, when your server
is far away from your client user, the client based content will be slower
however the server response time won't slow down.

IE; if a page take 5 seconds to load from china and 2 seconds from the US,
the server response time will be the same for both users. It is the time
taken to load the client content like images and css that will slow the load
time, not the server response. Make sense?

***http://developer.yahoo.com/performance/rules.html

Thanks,
Paul Alkema
http://paulalkema.com
http://twitter.com/#!/paulalkema



On Tue, Jun 14, 2011 at 5:17 PM, Donnie Carvajal 
donnie.carva...@transformyx.com wrote:


 Has anyone ever worked with a CDN like Akamai with Coldfusion where the
 actual content is distributed, not just images and documents?

 Thanks,

 Donnie

 

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


Re: CDN and Coldfusion

2011-06-15 Thread Paul Alkema

Oh yeah! Something else just mentioning is that if your not hooked on Akamai
as your CDN, I've found Amazon CloudFront to be reliable and relatively
inexpensive. : )
http://aws.amazon.com/cloudfront/

Paul Alkema
http://paulalkema.com
http://twitter.com/#!/paulalkema


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


Re: CDN and Coldfusion

2011-06-15 Thread Paul Alkema

I think what your describing is more of mirrored servers than a Content
Delivery Network. Mirrored servers are a completely different story, he
could use mirrored servers if he doesn't mind spending that kind of money.

I prefer CDN's. Cheaper, almost as effective and easier to maintain.

On Wed, Jun 15, 2011 at 10:52 AM, Dave Watts dwa...@figleaf.com wrote:


  From what it sounds like, your asking if you can have a CDN run and
  distribute ColdFusion applications? As far as I know, this isn't a
  capability of a CDN, that would be more for something like a mirrored
  server.

 CDNs can be used with dynamic content, but it gets ... complicated.
 You can, for example, distribute edge servers, use in-memory database
 replication, etc, etc.

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

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

 

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


cgi.host_name Security Exploit

2011-05-13 Thread Paul Alkema

Greetings and Salutations My Fellow Programmers!

I have recently discovered a security flaw that I have reported to the Adobe
team regarding the use of the variable cgi.host_name.

 

As you know, the cgi.host_name is typically the hostname of the server or
the websites domain name. I've discovered an exploit that allows a user to
basically change this variable to anything they want for the user's current
session. This exploit could be spread across sessions  in instances where a
website is caching absolute links using the cgi.host_name variable. It could
also be used to take advantage of applications that assume the cgi.host_name
variable is a constant, therefore developed applications don't take
precautions to sanitize this variable before inserting it into a database
could have issues.

 

Just wanted to give the community a heads up on this. :)

 

Regards,

Paul Alkema

http://paulalkema.com/



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


64-bit ColdFusion 8 Download

2011-04-07 Thread Paul Alkema

Hi,

I'm migrating one of our ColdFusion 8 servers to a 64-bit server and was
wondering if anyone knows of a place to download the 64-bit version of
ColdFusion 8?

 

Thanks,

Paul



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


RE: 64-bit ColdFusion 8 Download

2011-04-07 Thread Paul Alkema

Thanks dave. :)

-Original Message-
From: Dave Watts [mailto:dwa...@figleaf.com] 
Sent: Thursday, April 07, 2011 9:39 AM
To: cf-talk
Subject: Re: 64-bit ColdFusion 8 Download


 I'm migrating one of our ColdFusion 8 servers to a 64-bit server and was
 wondering if anyone knows of a place to download the 64-bit version of
 ColdFusion 8?

You should still be able to get all versions here:
https://www.adobe.com/cfusion/tdrc/index.cfm?product=coldfusion8

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

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



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


Charge for meetings

2011-02-05 Thread Paul Alkema

Hi All,
I have a question; when you guys do consulting or freelance programming, do
you charge for meetings? Or do you absorb meeting time into your fees?

Thanks,
Paul


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


RE: Odd Code Showing up in URL

2011-01-14 Thread Paul Alkema

I've found that a lot of these issues are caused by either bots, or someone
linking to a webpage and made a typo. Most likely bots.

In your error reporting do you have anything that grabs the user agent of
the error? I've found that looking at user agents can sometime help me to
determine if it's a bot or not but you have to keep in mind that there are
definitely tricky bots out there that emulate real people.

One of the websites I maintain has around 800,000 pageviews a month. This
website also has an error reporting like yours and I've found that the
majority of them are just bots.

I would just make sure you take proper security precautions on all of your
code and you should be fine. 

-Original Message-
From: David Moore [mailto:dgmoor...@hotmail.com] 
Sent: Friday, January 14, 2011 12:48 PM
To: cf-talk
Subject: Odd Code Showing up in URL


I recently added an cferror to my websites and it has helped me discover a
lot of issues I needed to fix. At the same time, I have some very odd code
showing up and didn't know if it is something I should address or is it
someone trying to hack into my websites. Here is an example:

http://www.oconeemed.org/index.cfm?PageID=21ParentPageID=4NavID=4ServiceI
D=-1%27PageText=off

You will notice the ServiceID of -1%27 which should be an integer. It also
did not come from a Search Engine, which is a whole other issue I have
noticed that I did not before.

I guess I am asking is if I should be concerned about this or is it just
some kind of oddity. I am noticing it showing up on many of the websites I
host.

Thank you in advance,

David G. Moore, Jr. 



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


RE: IP Address 1.1.1.1

2010-12-07 Thread Paul Alkema

I don't think this has anything to do with your CGI script. I would say it's
most likely just a bot.

If it was me, I would just exclude this IP from Google Analytics. I think
this would solve your issue. :)
http://www.google.com/support/analytics/bin/answer.py?hl=enanswer=55481
 

Regards,
Paul Alkema
http://paulalkema.com/

-Original Message-
From: Robert Harrison [mailto:rob...@austin-williams.com] 
Sent: Tuesday, December 07, 2010 11:46 AM
To: cf-talk
Subject: IP Address 1.1.1.1


On one of our sites Google Analytics is reporting lots of hits from IP
1.1.1.1 as a referral.  It's also showing a very high bounce rate from that
IP. 

I looked this up and saw a bunch of differing ideas on this, ranging from a
dude in Australia to a bot attack, but one that comment that seemed vaguely
possible was about this IP coming from CGI script used within a site.  I am
using CGI script to do 301 redirects (via CFLOCATION) and I'm wondering if
this sounds like that may be the cause.

Has anyone seen referrals from IP 1.1.1.1 or know what it may be from?

Thanks.
Robert

Robert B. Harrison
Director of Interactive Services
Austin  Williams
125 Kennedy Drive, Suite 100 
Hauppauge NY 11788
P : 631.231.6600 Ext. 119 
F : 631.434.7022
http://www.austin-williams.com 

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

Plug in to our blog: AW Unplugged
http://www.austin-williams.com/unplugged





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


RE: Free ColdFusion Hosting

2010-11-24 Thread Paul Alkema

That link looks familiar. ; )

I found one place: http://www.cfmldeveloper.com/ but it's out of country
(USA) which, I don't have a problem with, but at the same time I'm hesitant
to just go anywhere with the way the world is today.



-Original Message-
From: Gerald Guido [mailto:gerald.gu...@gmail.com] 
Sent: Wednesday, November 24, 2010 1:41 PM
To: cf-talk
Subject: Re: Free ColdFusion Hosting


IIRC Russ Michaels has something going to that effect on cfmldeveloper.com

HTH
G!




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


RE: Free ColdFusion Hosting

2010-11-24 Thread Paul Alkema

Matthew,
If it was me, I wouldn't poo-poo it just because it's hosted out of the
country. If it's free, I wouldn't expect GREAT honest but it's free right!?
I would think as long as your not looking to put anything that you want to
keep secure on it IE; credit card data, SSN's, other people's passwords ect,
that you'd be fine.

If it was me I would just sign up, pay the £1.00 setup fee (don't know if
you saw that or not) and if they charge you more than £1.00 than it's credit
card fraud, file a dispute with your cc company which is really easy and you
get your money back.

If you do, do it, make sure you share your experience with everyone so we
can see how it worked out for you. ;)

Paul Alkema
http://paulalkema.com/


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


Performance Monitoring

2010-11-23 Thread Paul Alkema

Hi All,

Does anyone know if there is any performance issues with enabling
performance monitoring settings? 

 

This setting is in the ColdFusion administrator under Debugging And Logging
à  Debug Output Settings à Enable Performance Monitoring.

 

Is this setting ok to enable in a production environment?

 

Thanks,

Paul



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


RE: Detect users based on country???

2010-11-23 Thread Paul Alkema

I've ran into this issue before and have found the best solution to
detecting a county is by asking the customer for it via a modal window.

EXAMPLES
http://www.xerox.com/
http://www.edmundoptics.com/


I know some people really like using geo-location, but I've found this
method to be not always accurate. I've found in the US is usually more
accurate than overseas.

-Original Message-
From: Tony Bentley [mailto:cascadefreehee...@gmail.com] 
Sent: Monday, November 22, 2010 5:41 PM
To: cf-talk
Subject: Re: Detect users based on country???


Use a public geo-location service:

cfhttp method=get
URL=http://ipinfodb.com/ip_query.php?ip=#cgi.REMOTE_ADDR#;
result=response /

Then use the response XML tree to extract the country or zip:

cfset xmmm = xmlparse(response.filecontent)
cfset countryname = xmmm.response.countryname.xmltext

cfif countryname neq Canada
div id=price#price#/div
/cfif

I wouldn't actually do it in this order because of the lag in http
posts. I've had good luck with this method but it isn't perfect
because web services can go down and then your checking system breaks.
If the location service isn't working, then don't allow anyone to use
the module you've built with the integrated geo-location service. Use
cookies as you stated to keep from having to do this every time.



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


RE: Performance Monitoring

2010-11-23 Thread Paul Alkema

I'm on ColdFusion 8. :)

-Original Message-
From: Wil Genovese [mailto:jugg...@trunkful.com] 
Sent: Tuesday, November 23, 2010 1:18 PM
To: cf-talk
Subject: Re: Performance Monitoring


Paul,

Which version of ColdFusion is running?  Some settings in the CF8 and CF9
Enterprise edition may have some performance hit on high load servers.  In
rare cases the Server Monitor may have a large impact on performance with
certain settings (Enable Memory Tracking) enabled. 

In general the Debug settings should be disabled on production servers be
cause there is a performance hit. It's a small one and may never be noticed
on minimally used sites. Highly used high load sites may experience
performance issues with the Debug settings enabled.  In my experience none
of them will completely crash the server. 



Wil Genovese 
Owner / Sr Web Application Developer / Systems Administrator
Trunkful Technologies, inc.
http://www.trunkful.com
729 Dodd Road Saint Paul, MN 55107 | m: 651-894-4238 | wilg...@trunkful.com


On Nov 23, 2010, at 10:35 AM, Paul Alkema wrote:

 
 Hi All,
 
 Does anyone know if there is any performance issues with enabling
 performance monitoring settings? 
 
 
 
 This setting is in the ColdFusion administrator under Debugging And
Logging
 à  Debug Output Settings à Enable Performance Monitoring.
 
 
 
 Is this setting ok to enable in a production environment?
 
 
 
 Thanks,
 
 Paul
 
 
 
 



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


RE: Where to put your code

2010-11-17 Thread Paul Alkema

Hey Sean,
Thanks, this doc looks great. It would be nice if we could get an updated
version of this doc someday but for now this is a great point of reference.
;)

Paul

-Original Message-
From: Sean Corfield [mailto:seancorfi...@gmail.com] 
Sent: Monday, November 15, 2010 7:44 PM
To: cf-talk
Subject: Re: Where to put your code


On Mon, Nov 15, 2010 at 2:13 PM, Paul Alkema
paulalkemadesi...@gmail.com wrote:
 Does anyone out there have any written coding standards or coding
 documentation that they would be willing to share? I would be interested
in
 seeing what other development teams use as far as coding standards.

Here's what my team developed / used back when I was at Macromedia:

http://livedocs.adobe.com/wtg/public/
-- 
Sean A Corfield -- (904) 302-SEAN
Railo Technologies, Inc. -- http://getrailo.com/
An Architect's View -- http://corfield.org/

If you're not annoying somebody, you're not really alive.
-- Margaret Atwood



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


RE: Where to put your code

2010-11-17 Thread Paul Alkema

What makes you think this? It looks to me like most files have a .html
extension. I'm sure these html files are dynamic though, perhaps they're
rendering ColdFusion in the html pages.

http://www.codemonkeysteve.com/blog/2010/03/coldfusion-parsing-coldfusion-in
-a-htm-extension-on-iis6/

I do agree that it seems silly to do this though. I would think that if a
company is selling a product it seems like they should be using the product
themselves and not try to mask that they are or are not using the product. I
do know they have a lot of flex integration on the site.

:)


-Original Message-
From: Michael Grant [mailto:mgr...@modus.bz] 
Sent: Wednesday, November 17, 2010 10:54 AM
To: cf-talk
Subject: Re: Where to put your code



 although a lot of what is adobe.com seems to be moving away from CF


I noticed this the other day. Seems like Adobe isn't all that proud of CF.




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


RE: Where to put your code

2010-11-15 Thread Paul Alkema

I think that when working on a team of programmers that are all working on
the same applications or the same website that it's important to have a
programming standard or a guide. I think this goes with any language be it
web or desktop applications. I think that it's ok for programmers to have
their own style of programming style and own methods to programming however
when multiple programmers get together they should be writing applications
in the same style using the same guides or else applications and websites
looks and unprofessional. I also think it really helps the programmers to
work together and be in sync with one another. Ie; if you have a guide of
where to put code you can know exactly the location of a script if your
teammate wrote it.

Do I really think there is a right of wrong in the discussion of where you
should put code? Not really. I just think that when working on a team of
developers that it is necessary to have guides like these so that all
programmers are working consistently. : )

Paul




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


RE: Where to put your code

2010-11-15 Thread Paul Alkema

Thanks for your feedback. You make some good points.

Does anyone out there have any written coding standards or coding
documentation that they would be willing to share? I would be interested in
seeing what other development teams use as far as coding standards.


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


Re: Where to put your code

2010-11-13 Thread Paul Alkema

I second this. : )

On Fri, Nov 12, 2010 at 8:05 PM, James Holmes james.hol...@gmail.comwrote:


 I'd argue that CF didn't allow for well written applications before
 CFCs came along.

 --
 WSS4CF - WS-Security framework for CF
 http://wss4cf.riaforge.org/



 On 13 November 2010 02:16, Dave Watts dwa...@figleaf.com wrote:
  Functions existed well before CFCs - does that mean that
  well-written applications predating the use of CFCs are now
  poorly-written?

 

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


Where to put your code

2010-11-12 Thread Paul Alkema

Hi All,

I recently had a discussion with some other programmers on my team dealing
with where to put application code and when. This is a small little guide I
wrote that I try to use and I wanted some second opinions on my coding
logic.

 

Thanks,

Paul

 


-

 

When to put your code where. In my opinion this is the IDEAL location for
code. 

 

Straight on CFM Page

Should Contain: UI or presentation code. HTML, JavaScript, simple ColdFusion
(IE; does var.foo exist output etc..).

Should Not Contain: Application Logic. Processes or functions.

 

Includes

Should Contain:  Code should contain same type of code as CFM pages however
includes should be used to split large CFM pages into smaller segments. 

Should Not Contain: Application Logic. Processes or functions.

 

Custom Tags

Should Contain: Reusable UI or presentation code. HTML, JavaScript, simple
ColdFusion. Code that's going to be used more than once.

Should Not Contain: Application Logic. Processes or functions.

 

CFC's

Should Contain: Application Logic. Processes or functions.

Should Not Contain: UI or presentation code.

 



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


RE: Where to put your code

2010-11-12 Thread Paul Alkema

Oh yeah. Of course ideally we would be on an MVC framework but we can't do
that due to internal reasons. This doc is for those not on an MVC. Don't
want any non MVC haters to yell at me. Haha.

 

Paul Alkema



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


RE: Where to put your code

2010-11-12 Thread Paul Alkema

I agree with those additions. Thanks!

-Original Message-
From: Scott Stewart [mailto:webmas...@sstwebworks.com] 
Sent: Friday, November 12, 2010 10:46 AM
To: cf-talk
Subject: Re: Where to put your code


I'd only modify it a little:

Straight on CFM Page

Should Contain: UI or presentation code. HTML, JavaScript, simple
ColdFusion to implement UI/Presentation
(IE; does var.foo exist output etc..).
Should Not Contain: Application Logic. Processes or functions.

Includes

Should Contain:  reusable ui code that doesn't require inputs (IE:
headers, footers, sidebars, etc)
Should Not Contain: Application Logic. Processes or functions.

Custom Tags

Should Contain: Reusable,  Dynamic UI or presentation code. (IE
generic headers that accept passed parameters for customization)
HTML, JavaScript, simple
ColdFusion. Code that's going to be used more than once.

Should Not Contain: Application Logic. Processes or functions.

CFC's

Should Contain: Application Logic. Processes or functions. should not
be dependent on any scoped variables
Should Not Contain: UI or presentation code.

On Fri, Nov 12, 2010 at 10:23 AM, Paul Alkema
paulalkemadesi...@gmail.com wrote:

 Hi All,

 I recently had a discussion with some other programmers on my team dealing
 with where to put application code and when. This is a small little guide
I
 wrote that I try to use and I wanted some second opinions on my coding
 logic.



 Thanks,

 Paul





 -



 When to put your code where. In my opinion this is the IDEAL location for
 code.



 Straight on CFM Page

 Should Contain: UI or presentation code. HTML, JavaScript, simple
ColdFusion
 (IE; does var.foo exist output etc..).

 Should Not Contain: Application Logic. Processes or functions.



 Includes

 Should Contain:  Code should contain same type of code as CFM pages
however
 includes should be used to split large CFM pages into smaller segments.

 Should Not Contain: Application Logic. Processes or functions.



 Custom Tags

 Should Contain: Reusable UI or presentation code. HTML, JavaScript, simple
 ColdFusion. Code that's going to be used more than once.

 Should Not Contain: Application Logic. Processes or functions.



 CFC's

 Should Contain: Application Logic. Processes or functions.

 Should Not Contain: UI or presentation code.





 



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


RE: Where to put your code

2010-11-12 Thread Paul Alkema

I work on a fairly large team for a large multi-million dollar ecommerce
corporation. I can see if your building small application for small websites
and you're not on a team of people working on the same website how it might
not be ideal to have guidelines set up like these.

I think in a team environment in order to avoid coding inconsistencies on
large websites at least general guidelines are a must. :)

-Original Message-
From: Russ Michaels [mailto:r...@michaels.me.uk] 
Sent: Friday, November 12, 2010 12:20 PM
To: cf-talk
Subject: Re: Where to put your code


You cannot really apply such rules to everyone.
If someone just has a very simple mostly flat, then using mvc frameworks and
CFC's will probably be overkill and create 10 x more code is actually
required.
In those situations you are probably just going to use some cfm pages and
maybe a few cfincludes for header, footer and menu etc.

For large code-centric applications and when working within teams your rules
work fine though.



--
Russ Michaels
www.cfmldeveloper.com - Supporting the CF community since 1999
FREE ColdFusion/Railo hosting for developers.

blog: www.michaels.me.uk




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


RE: Where to put your code

2010-11-12 Thread Paul Alkema

Hm, I respectfully disagree with putting functions in cfm pages entirely no
matter how it's being pulled. I think there's a place for functions and
that's in cfcs.

You say you have a lot of utility functions that don't need to be in a cfc.
If you have a lot of them, why not just create a cfc called utility and
stick them all in one cfc?

Also, if you stick functions and include them most likely your talking to
that function using scoped variables which as other have mentioned is
usually a bad practice to do using functions.

Paul

-Original Message-
From: Gerald Guido [mailto:gerald.gu...@gmail.com] 
Sent: Friday, November 12, 2010 12:54 PM
To: cf-talk
Subject: Re: Where to put your code


My only exceptions to these would be:


 Includes

 Should Not Contain: Application Logic. Processes or functions.


A lot of times (depending on the app) I stick functions  (UDFs) in an
include. I have a lot of utility functions that (arguably) don't really need
to be in a cfc.

Custom Tags

 Should Contain: Reusable,  Dynamic UI or presentation code. (IE
 generic headers that accept passed parameters for customization)



I generally use custom tags as views for encapsulation purposes. What
happens in Vegas, stays in Vegas. Then I stick the aforementioned functions
in the request scope or a stuct and/or array to pass into the views.

G!


-- 
Gerald Guido
http://www.myinternetisbroken.com

Wait. We can't stop here. This is bat country.
-- HST




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


RE: CF (8.0.0) performance vs PHP (5)

2010-11-05 Thread Paul Alkema

I think the cfexecute tag is definitely not the faster cf tag ever.

As an ex php programmer and a current ColdFusion programmer I do have to say
that there is usually a speed benefit to php over ColdFusion however, I do
have to say that I think the overall benefits to ColdFusion far outweigh the
cons to ColdFusion over php. I personally have had very, very few server or
speed issues on my ecommerce site, which receives over a million page views
a month.

Check out my article about php vs ColdFusion.
http://paulalkema.com/post.cfm/php-vs-coldfusion

Paul Alkema



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


RE: Coldfusion Search

2010-11-02 Thread Paul Alkema

Anyone have any ideas on this? 

-Original Message-
From: Paul Alkema [mailto:paulalkemadesi...@gmail.com] 
Sent: Monday, November 01, 2010 4:46 PM
To: cf-talk
Subject: Coldfusion Search

Hi All,

I've created a file index of all of my ColdFusion files so I can quickly
search the files and find what I'm looking for. So far, it's working great
except it doesn't seem to be searching inside any coldfusion tags.

For example

pIf I searched for this text, It would return a result/p

cfset variables.foo = however, If I search for this text it wouldn't
return any results. /

Does anyone know if there's a way to search inside of a coldfusion tag like
that?

This is my index.

cfindex 
   collection = fileIndex
   action=refresh
   type=path
   key=d:\my-websites-location\ 
   urlpath=http://mywebsite/;
   extensions=.cfm, .cfml, .cfc
   recurse=Yes

This is my search.
 
  cfsearch 
 name = testSearch
 collection = fileIndex
 type=internet
 criteria = variables.foo
   /

Any ideas?

Thanks,

Paul : )





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


Coldfusion Search

2010-11-01 Thread Paul Alkema

Hi All,

I've created a file index of all of my ColdFusion files so I can quickly
search the files and find what I'm looking for. So far, it's working great
except it doesn't seem to be searching inside any coldfusion tags.

 

For example.

 

pIf I searched for this text, It would return a result/p

cfset variables.foo = however, If I search for this text it wouldn't
return any results. /

 

Does anyone know if there's a way to search inside of a coldfusion tag like
that?

 

This is my index..

 

cfindex 

   collection = fileIndex

   action=refresh

   type=path

   key=d:\my-websites-location\ 

   urlpath=http://mywebsite/;

   extensions=.cfm, .cfml, .cfc

   recurse=Yes

 

This is my search.

 

  cfsearch 

  name = testSearch

  collection = fileIndex

  type=internet

  criteria = variables.foo

   /

 

 

Any ideas?

 

Thanks,

Paul : )



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


RE: hostek.com - is anyone else experiencing extreme downtime today

2010-10-27 Thread Paul Alkema

My site seems to be doing well. I think my site's gone down maybe twice in
the last two years. Which I think it pretty good considering I pay like 5
bucks a month and.

-Original Message-
From: Casey Dougall [mailto:ca...@uberwebsitesolutions.com] 
Sent: Wednesday, October 27, 2010 7:53 AM
To: cf-talk
Subject: Re: hostek.com - is anyone else experiencing extreme downtime today


On Wed, Oct 27, 2010 at 5:24 AM, Mike Little m...@nzsolutions.co.nz wrote:


 several of our sites have been down for at least 4 hours now.

 we think the problem appears to be their connection to mysql. even their
 own faq page has been down for ages with the following error...



My sites seem to be OK.




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


RE: left outer join in query of query

2010-10-25 Thread Paul Alkema

Hi Nathan,
Both cf8 and cf9 allow for left outer joins when doing normal queries
however as far as I know query of query's does not support joins.

On a side note though, my general rule of thumb is if I need to use a query
of queries for anything other than changing the order of my structure, than
I really need to evaluate my original SQL query and looped query of queries
are big programming no no.

Just my 2 cents.. : )

Paul Alkema
http://paulalkema.com/


-Original Message-
From: Nathan Chen [mailto:nathan.c...@cu.edu] 
Sent: Monday, October 25, 2010 1:53 PM
To: cf-talk
Subject: left outer join in query of query


All:

 

I am on CF 8 now. Does anyone know if CF 9 supports left outer join in
query of query? CF 8 doesn't allow left outer join.

 

Nathan Chen





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


RE: left outer join in query of query

2010-10-25 Thread Paul Alkema

You may find this article useful.

http://instantbadger.blogspot.com/2006/07/faking-left-outer-join-in-query-of
.html

Paul Alkema
http://paulalkema.com/


-Original Message-
From: Mahcsig [mailto:mahc...@mahcsig.com] 
Sent: Monday, October 25, 2010 4:43 PM
To: cf-talk
Subject: Re: left outer join in query of query


You can actually use the old SQL syntax to do inner joins in a qoq,
haven't gotten a left join to work though.
this fails:
cfquery dbtype=query name=tmp
SELECT *
FROM t1 inner join t2
  ON t1.id = t2.id
/cfquery
this works though:
cfquery dbtype=query name=tmp
SELECT *
FROM t1, t2
WHERE t1.id = t2.id
/cfquery

~Mahcsig




On Mon, Oct 25, 2010 at 1:35 PM, Paul Alkema
paulalkemadesi...@gmail.com wrote:

 Hi Nathan,
 Both cf8 and cf9 allow for left outer joins when doing normal queries
 however as far as I know query of query's does not support joins.

 On a side note though, my general rule of thumb is if I need to use a
query
 of queries for anything other than changing the order of my structure,
than
 I really need to evaluate my original SQL query and looped query of
queries
 are big programming no no.

 Just my 2 cents.. : )

 Paul Alkema
 http://paulalkema.com/


 -Original Message-
 From: Nathan Chen [mailto:nathan.c...@cu.edu]
 Sent: Monday, October 25, 2010 1:53 PM
 To: cf-talk
 Subject: left outer join in query of query


 All:



 I am on CF 8 now. Does anyone know if CF 9 supports left outer join in
 query of query? CF 8 doesn't allow left outer join.



 Nathan Chen





 



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


RE: cant access cf administrator

2010-10-19 Thread Paul Alkema

I know on windows server you have to set up a virtual directory to 
C:\inetpub\wwwroot\CFIDE called CFIDE in order for the administrator to be
viewed.

Paul

-Original Message-
From: Jay Birdsell [mailto:john_birds...@hotmail.com] 
Sent: Tuesday, October 19, 2010 11:33 AM
To: cf-talk
Subject: cant access cf administrator


 HI 
I have just installed CF9 on a Solaris 10 box with weblogic 11g, when i try
to log into cf administrator, I get a 500 error, cf itself is running as I
can pull the log in pages for all my apps, of course when actually log in i
get an error, as expected, because I have not configured anything. anyone
have an idea what could be causeing the 500 error? 

tia

jb 



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


RE: CF jQuery Grid

2010-10-18 Thread Paul Alkema

I LOVE ColdFusion! But.. I think that the code in asp.net is usually easier
to look at than ColdFusion as with asp.net by default the user interface and
the domain logic are separated. I know CF has MVC's that help with this, but
I'm talking CF out of the box here.

That's my 2 cents. :)

Paul Alkema
http://paulalkema.com/


-Original Message-
From: Gerald Guido [mailto:gerald.gu...@gmail.com] 
Sent: Friday, October 15, 2010 11:44 PM
To: cf-talk
Subject: Re: CF jQuery Grid


God asp is ugly to look at.

???

ASP.net looks just like imported CF custom tags , C# looks just like
cfscript and VB looks just like... well.. VB looks like VB.

Actually working with COM objects with CF reminds me of VB.

G!


On Fri, Oct 15, 2010 at 8:04 PM, Michael Grant mgr...@modus.bz wrote:


 God asp is ugly to look at.


 On Fri, Oct 15, 2010 at 7:16 PM, Andrew Scott andr...@andyscott.id.au
 wrote:

 
  That is very true about IE9, however ExtJS doesn't have any problems
with
  IE9 at this stage. jQuery I don't use enough of to make a judgement
call.
 
  As for being outside of the .Net world I mean with the likes:
 
 
 

http://demos.telerik.com/aspnet-ajax/controls/examples/default/defaultcs.asp
  x
 
  Regards,
  Andrew Scott
  http://www.andyscott.id.au/
 
 
   -Original Message-
   From: Judah McAuley [mailto:ju...@wiredotter.com]
   Sent: Saturday, 16 October 2010 10:10 AM
   To: cf-talk
   Subject: Re: CF jQuery Grid
  
  
   Given that IE9 was first released in a public beta exactly one month
 ago,
  I
   think that Dojo can be forgiven for not supporting it yet.  I'm also
 not
  sure
   what you mean by outside the .Net world. If you are looking at
  javascript,
   .Net MVC bundles JQuery. If you are looking at a control, there are
 some
   decent ones, but for web pages they are all ActiveX which means they
  won't
   be cross-browser or cross-platform.
  
   Cheers,
   Judah
 
 
 

 



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


RE: What difference does the parenthesis make?

2010-10-18 Thread Paul Alkema

In mssql there shouldn't be a difference in the records returns. I would
double check that the input variable #law.paid# is the same in both of these
scenarios and also that none of these queries are cached. 

-Original Message-
From: Les Mizzell [mailto:lesm...@bellsouth.net] 
Sent: Monday, October 18, 2010 3:17 PM
To: cf-talk
Subject: What difference does the parenthesis make?


What's the difference between

1. --
SELECT nl_id
FROM vw_newsletters
WHERE
  (paID=cfqueryparam value=#law.paid# cfsqltype=cf_sql_integer /)
AND (nl_status = 'published' OR nl_status = 'archived')


2. --
SELECT nl_id
FROM vw_newsletters
WHERE
  paID=cfqueryparam value=#law.paid# cfsqltype=cf_sql_integer /
AND (nl_status = 'published' OR nl_status = 'archived')



#1 returns the correct records
#2 returns nothing

Not sure what difference the first set of parenthesis makes in #1



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


RE: CF jQuery Grid

2010-10-15 Thread Paul Alkema

I don't know if this is what you're looking for or not, but I thought I'd at
least mention it.

jQuery version of cfgrid.
http://www.webtrenches.com/post.cfm/jquery-replacements-for-cfgride-cfwindow
e-and-cftooltip

Demo
http://www.webtrenches.com/cfjq/


-Original Message-
From: Doug Ford [mailto:doug.e.f...@gmail.com] 
Sent: Thursday, October 14, 2010 8:12 PM
To: cf-talk
Subject: CF jQuery Grid


Hi Folks - 

I am hoping that some of you might have used a Grid based plug in into your
work and have some experience.

I have been using Ingrid for a while but there is a problem with it.
If you put the Ingrid table/grid within a DIV and use any type of
positioning in that DIV, the divider bar causes problems, and sometimes
locks up the browser window.

It's nice for relatively simple instances, but it has limitations when used
within a nicely laid out site.

Now then, here are my requirements - 

1) I need to pass a CLASS  TITLE attribute to different random cells to
display tool tips.

So any plug in that generates a grid with JSON and XML only is out of the
mix.
(So this might nix jqGrid from the list)

2) I need to be able to have paging controls, where I can either read in an
HTML table generated on the backend, or pull back the data to generate my
table but CLASS  TITLE attributes have to be included.

3) I need to be able to expand the grid object beyond the screen's edge if
need be.

The data is truly dynamic.  One time the page will show 4 columns, the next
20.  Probably not, but I have to prepare for the worst.


Any and all ideas are appreciated.

Thanks,

Doug

 



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


RE: Subversion Software

2010-10-14 Thread Paul Alkema

What do you all use to manage your svn on the client side? IE; tortoiseSvn,
Dreamweaver, subeclipse?

-Original Message-
From: enigment [mailto:enigm...@gmail.com] 
Sent: Thursday, October 14, 2010 7:46 AM
To: cf-talk
Subject: Re: Subversion Software


+1 VisualSVN

Dave



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


Subversion Software

2010-10-13 Thread Paul Alkema

Hey All,

I'm looking to set up a subversion server and was wondering what types of
subversion servers you all have set up and what software do you use to
manage it?

 

Paul Alkema



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


SQL ColdFusion Encryption

2010-09-07 Thread Paul Alkema

Hi,

I know how to encrypt data using ColdFusion using AES_128. I also know how
to encrypt data using MSSQL AES_128. Does anyone know if it's possible to
encrypt data in ColdFusion using AES_128, then decrypt the string in MSSQL?

 

I've played around with it a lot and can't seem to figure it out.

 

Thanks,

Paul



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


CFID integer?

2010-08-18 Thread Paul Alkema

Hi All,
Does anyone have any idea why one server would give me a session.cftoken
that's an integer and the other would give me a session.cftoken that's a
alpha-numeric? It's seems to be very consistently this way.

EXAMPLE

SERVER A
Session.cftoken = 316809


Server B
Session.cftoken = 8a30c3300f9be8f6-858271FD-1D10-FABB-008190F5BC0804CA


I'm assuming that there is a setting in the ColdFusion administrator I'm
missing somewhere or something. Any ideas?

Thanks,
Paul


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


RE: CFID integer?

2010-08-18 Thread Paul Alkema

Oh, oops. I just figured it out.

In the ColdFusion administrator, if the setting Use UUID for cftoken is
unchecked than the cftoken will be an integer.

Thanks,
Paul

-Original Message-
From: Paul Alkema [mailto:paulalkemadesi...@gmail.com] 
Sent: Wednesday, August 18, 2010 10:19 AM
To: 'cf-talk@houseoffusion.com'
Subject: CFID integer?

Hi All,
Does anyone have any idea why one server would give me a session.cftoken
that's an integer and the other would give me a session.cftoken that's a
alpha-numeric? It's seems to be very consistently this way.

EXAMPLE

SERVER A
Session.cftoken = 316809


Server B
Session.cftoken = 8a30c3300f9be8f6-858271FD-1D10-FABB-008190F5BC0804CA


I'm assuming that there is a setting in the ColdFusion administrator I'm
missing somewhere or something. Any ideas?

Thanks,
Paul


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


RE: CF9 Developer on Windows 7 Home Premium?

2010-08-03 Thread Paul Alkema

I've run CF9 on Windows 7 with absolutely no issues at all.

Paul Alkema
T:@paulalkema

-Original Message-
From: Matt Robertson [mailto:websitema...@gmail.com] 
Sent: Tuesday, August 03, 2010 3:43 PM
To: cf-talk
Subject: CF9 Developer on Windows 7 Home Premium?


I'm looking at buying a couple of laptops that will get some light
development use.  The trouble I am seeing is every laptop whose
feature set I am interested in is running Win7 Home Premium.

If I am running CF9 developer on them and would only be using the
development web server, will CF9 run on it or will the installer kick
me out when it sees the Win version I'd be running?

-- 
-...@robertson--
Janitor, The Robertson Team
mysecretbase.com



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


RE: HTML spec for mobile devices

2010-08-02 Thread Paul Alkema

1+ - I attended this, He did an excellent job, very informative.

T:@paulalkema
-Original Message-
From: Andy Matthews [mailto:li...@commadelimited.com] 
Sent: Monday, August 02, 2010 1:25 PM
To: cf-talk
Subject: RE: HTML spec for mobile devices


You might also head over to Dan Vega's blog. He just gave a mobile session
at CFUnited that was really well attended:

http://www.danvega.org/blog/
 

-Original Message-
From: Marc Funaro [mailto:subscripti...@advantex.net] 
Sent: Monday, August 02, 2010 9:14 AM
To: cf-talk
Subject: SOT: HTML spec for mobile devices


I'm looking for a basic web resource coover what would be considered best
practices for building a website that will be viewed on mobile devices... a
general reference guide/best practices document, that might cover (x)html,
css, etc... I can't seem to find the right keywords to Google with.  The
last mobile xml/html spec I could find was from 2001.  I knwo i could just
wing it and use basic html and go from there, but I'd rather follow at least
a proposed standard, if there is one.

Thanks for any links you can provide! 





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


RE: HTML spec for mobile devices

2010-08-02 Thread Paul Alkema

To summarize it, I would look into mobile js frameworks like Sencha
(http://www.sencha.com/). Also, to get an idea of screen resolution look at
your Google analytics stats they should give you an idea of what mobile
browsers are looking at your site and what the screen resolutions are.

-Original Message-
From: Andy Matthews [mailto:li...@commadelimited.com] 
Sent: Monday, August 02, 2010 1:25 PM
To: cf-talk
Subject: RE: HTML spec for mobile devices


You might also head over to Dan Vega's blog. He just gave a mobile session
at CFUnited that was really well attended:

http://www.danvega.org/blog/
 

-Original Message-
From: Marc Funaro [mailto:subscripti...@advantex.net] 
Sent: Monday, August 02, 2010 9:14 AM
To: cf-talk
Subject: SOT: HTML spec for mobile devices


I'm looking for a basic web resource coover what would be considered best
practices for building a website that will be viewed on mobile devices... a
general reference guide/best practices document, that might cover (x)html,
css, etc... I can't seem to find the right keywords to Google with.  The
last mobile xml/html spec I could find was from 2001.  I knwo i could just
wing it and use basic html and go from there, but I'd rather follow at least
a proposed standard, if there is one.

Thanks for any links you can provide! 





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


RE: How to dispaly flash video in coldfusion pages

2010-07-22 Thread Paul Alkema

Hi Kamru,
This is really more of a web development issue than a ColdFusion issue as
ColdFusion. It shouldn't matter what ColdFusion server your on. This can be
done multiple ways, you could create a player in flash or use a flash
template however I would check our flowplayer, it's a really robust flash
movie player that's built in jQuery. Very cool.

http://flowplayer.org/index.html

Paul Alkema
http://paulalkema.com
t: @PaulAlkema

-Original Message-
From: Kamru Miah [mailto:k.m...@csl.gov.uk] 
Sent: Thursday, July 22, 2010 10:58 AM
To: cf-talk
Subject: How to dispaly flash video in coldfusion pages


Hello,

Could some please advise me if it's possible to play MPEG video files on
Coldfusion 8 pages, perhaps after conversion to Shock Wave Flash (.swf)
files? It would be nice to have the user controls like Youtube as well!

Thanks in anticipation. 



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


RE: cfwindow - dynamically setting window title using javascript?

2010-07-07 Thread Paul Alkema

You could use ColdFusion.Window.create.

Example

cfajaximport tags=cfwindow
script type=text/javascript
url = 'http://www.google.com/';
title = 'This is my title';
name = 'newWindow';
ColdFusion.Window.create(name, title, url,{initshow:false});
/script

a href=javascript:ColdFusion.Window.show('newWindow');Show
Window/a

-Original Message-
From: Pete Ruckelshaus [mailto:pruckelsh...@gmail.com] 
Sent: Wednesday, July 07, 2010 9:08 AM
To: cf-talk
Subject: cfwindow - dynamically setting window title using javascript?


Is there a way to dynamically set the cfwindow title using JavaScript?  What
I mean is, I have the cfwindow's title attribute set to a fairly generic
value.  Once I display the window, it always contains dynamic data, and I
would like the cfwindow title to reflect the dynamic content.  I would
assume that this would be done via a Javascript snippet from within the
cfwindow content display page.

Thanks,

Pete




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


Re: Trouble with international characters

2010-07-05 Thread Paul Alkema

Hi,
What's your data type for the sql column that your trying to insert this
data into? If your inserting Unicode characters into varchar column you
should change the datatype to nvarchar.

Also, when using unicode in ColdFusion with cfqueryparam's I would confirm
that String Format is checked in your ColdFusion administrator. It should
be noted however that if this is enabled for your main dsn that it could
possibly cause performance issues.

I have two datasources one called nMainDns and another called mainDns. The
nMainDns is used to insert Unicode statements while using cfqueryparam's
while the other is used for select statements or stored procedures.

Paul Alkema
http://paulalkema.com/

On Mon, Jul 5, 2010 at 1:40 PM, Pete Ruckelshaus pruckelsh...@gmail.comwrote:


 Oh, and here's the code for my SQL that's inserting the data:

 cfquery name=insertRecords datasource=holocaustlearning
  INSERT INTO tblHLMapLocations(name, description, latitude, longitude,
 locationIsApproximate, active)
  VALUES (cfqueryparam cfsqltype=CF_SQL_VARCHAR value=#trim(
 workingset.name)#,
  cfqueryparam cfsqltype=CF_SQL_VARCHAR
 value=#stripHTML(trim(workingset.description))#,
  #trim(workingset.latitude)#,
  #trim(workingset.longitude)#,
  cfqueryparam cfsqltype=CF_SQL_BIT
 value=#locationIsApproximate(workingset.description)#,
  cfqueryparam cfsqltype=CF_SQL_BIT value=false);
 /cfquery



 2010/7/5 Pete Ruckelshaus pruckelsh...@gmail.com

  I am using CF to import data from an Excel spreadsheet to an MS SQL
 Server
  2005 database.  Salient points: Characters are showing properly in the
 .XLSX
  file; text fields in the SQL server database are all nvarchar or ntext; I
 am
  using cfprocessingdirective pageencoding=UTF-8 / at the top of the
 page
  that is processing this page; and, finally, I am using cfspreadsheet to
  read the spreadsheet and put it into a query object.  Here's the data
  processing code:
 
  cffile action=UPLOAD destination=#getTempDirectory()#
  filefield=uploadxls nameconflict=MAKEUNIQUE
 
  cfspreadsheet action=read
  src=#cffile.serverdirectory#\#cffile.serverfile# sheetname=sheet1
  query=getData
 
  cfloop query=getdata startrow=1 endrow=1
   cfset workingset =
 
 queryNew(#getdata.col_1#,#getdata.col_2#,#getdata.col_3#,#getdata.col_4#,varchar,varchar,varchar,varchar)
   cfset workingset_col1 = getdata.col_1
   cfset workingset_col2 = getdata.col_2
   cfset workingset_col3 = getdata.col_3
   cfset workingset_col4 = getdata.col_4
  /cfloop
  cfloop query=getdata startrow=2
   cfset t1 = queryAddRow(workingset)
   cfset t1 = querySetCell(workingset, workingset_col1,
  stripOuterQuotes(getdata.col_1))
   cfset t1 = querySetCell(workingset, workingset_col2,
  stripOuterQuotes(getdata.col_2))
   cfset t1 = querySetCell(workingset, workingset_col3,
  stripOuterQuotes(getdata.col_3))
   cfset t1 = querySetCell(workingset, workingset_col4,
  stripOuterQuotes(getdata.col_4))
  /cfloop
  hr /
  cfquery name=workingset dbtype=query
   SELECT name, description, latitude, longitude
   FROM workingset
   ORDER BY name
  /cfquery
 
  Now, the problem that I am having is that SOME (and not all) of the
  international characters are not showing up properly.  For instance:
 
  These show up properly:
  Großraming SB, Flossenbürg, Mirošov Labor Camp, Munkács Ghetto, Terezín
 
  These do NOT show up properly (correct versions in parentheses):
  Brn?nec (Brněnec)
  Auschwitz (Che?mek subcamp) - (Auschwitz (Chełmek subcamp))
  Che?mno Extermination Camp - (Chełmno Extermination Camp)
  Soldau (Dzia?dowo) Concentration Camp - (Soldau (Działdowo) Concentration
  Camp)
 
  In case you're curious, I teach high school English and am working on a
  Holocaust Location mapping project for my Holocaust Literature class.
 
  Does anyone have any ideas as to why some international characters are
  making it through just fine, but others are getting munched?  This is
 really
  the first time I've worked with anything beyond the basic Latin character
  set.
 
  Thanks,
 
  Pete
 


 

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


Vote ColdFusion

2010-07-01 Thread Paul Alkema

Hi All,

So I've been a member of this Linux forum for awhile now and I recently came
across a poll on the forum called The best languages. I know, I know how
long are people going to debate this; but the one thing that gets me is
ColdFusion isn't even on the list. 

 

I've made a post to complain about this and I received some crap about how
CF isn't a good language. I just thought it might be nice to share with the
Linux community how great CF is and why it should be added to this list of
The best languages. This is a very popular Linux board and is read by
many.

 

http://www.linuxquestions.org/questions/programming-9/your-opinions-of-the-b
est-combination-of-programming-languages-to-learn-813373/page3.html

 

Best Regards,

Paul Alkema

http://paulalkema.com/

 



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


RE: Order By question

2010-06-30 Thread Paul Alkema

I secont John's SQL. To expand explain further see my example.

SELECT *
FROM   folks
ORDER  BY CASE
WHEN last_name = 'Smith'
OR last_name = 'Jones' THEN 0
ELSE last_name
  END  

Paul Alkema
http://paulalkema.com/


-Original Message-
From: John M Bliss [mailto:bliss.j...@gmail.com] 
Sent: Wednesday, June 30, 2010 3:09 PM
To: cf-talk
Subject: Re: Order By question


Something like...

select last_name
from table
order by
case ID
when #ID1# then 0
when #ID2# then 0
else 1
end,
last_name

On Wed, Jun 30, 2010 at 2:02 PM, Les Mizzell lesm...@bellsouth.net wrote:


 Not 100% sure how to do this...

 Need to return a list of folks ordered by last_name (no problem), EXCEPT
 for 2 of them. They need to be LAST regardless of their last names
 (problem)...

 Perhaps something with their 2 ID numbers?

 Ideas?


 __ Information from ESET NOD32 Antivirus, version of virus
 signature database 5241 (20100630) __

 The message was checked by ESET NOD32 Antivirus.

 http://www.eset.com



 



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


RE: Order By question

2010-06-30 Thread Paul Alkema

I love how almost every question asked on this list will eventually turn
into some kind of debate. It's great. :)

-Original Message-
From: =?ISO-8859-1?Q?Claude_Schn=E9egans [mailto:schneeg...@interneti=71?=
=?ISO-8859-1?Q?ue.com=3E?=] 
Sent: Wednesday, June 30, 2010 5:03 PM
To: cf-talk
Subject: Re: Order By question


 I respectfully disagree with this approach. Doing it in the db will 
be much
faster.

Not so sure:
If the query has to be ordered by the name, it could use an internal index.
If it has to be sorted by some artificial column, there is no index and 
the query could be much longer.

So IMO this approach may be the best, especially if the two exceptions 
have to be added at the end of the query.



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


RE: Seriously PO'd - cfqueryparam and/or struct dereference flakes out

2010-06-25 Thread Paul Alkema

Are your integer fields datatype int in your database? I think a similar
error could occur if your integer fields were changed to varchar or a
different non-integer based field.

Paul Alkema
http://paulalkema.com/

-Original Message-
From: Brad Wood [mailto:b...@bradwood.com] 
Sent: Thursday, June 24, 2010 9:57 PM
To: cf-talk
Subject: Re: Seriously PO'd - cfqueryparam and/or struct dereference flakes
out


It's a bit more code, but if you switch to having a cfargument tag for each
parameter and enforce the type there,  you can pass in your struct as an
argument collection.  You'll get a more meaningful error that way.



Sent from my HTC on the Now Network from Sprint!

- Reply message -
From: Marc Funaro subscripti...@advantex.net
Date: Thu, Jun 24, 2010 5:43 pm
Subject: Seriously PO'd - cfqueryparam and/or struct dereference flakes out
To: cf-talk cf-talk@houseoffusion.com


The function below was written literally MONTHS ago.  Worked fine the whole
time, even today... then suddenly it's throwing the error:

Invalid data '' for CFSQLTYPE CF_SQL_INTEGER.

The error points to the line in the WHERE clause, referencing a.articleId.

Next, I purposely set the output=true on this function, and did a cfdump
of #a.articleId# -- it's definitely a valid integer.  but it's now choking
on it for some reason.

as a test, i hard coded an article id into the where clause, removing the
cfqueryparam.  with a hard coded number, it chokes on the next cfqueryparam
up.  if i reference #a.articleId# directly (outside of cfqueryparam), I also
get the same error.  how can a.articleId suddenly become '' right after
dumping it and successfully showing it to be an integer??

I've restarted both the cf server and the database server, wondering if
there was some sort of strange hangup there... no joy.

I'm losing my mind... help!!



cffunction name=updateArticle returntype=void access=private
output=true

cfargument name=structArticle required=true
type=Struct
hint=A
structure containing all fields of an article, and the values to be saved.

cfset var a = arguments.structArticle
cfset var qUpdateArticle = 

!--- uncommenting this line gives me a valid integer on screen ---
!--- cfdump var=#a.articleId#cfabort ---


cfquery name=qUpdateArticle datasource=#request.dsn#

UPDATE
Article

SET
categoryId = cfqueryparam
value=#a.categoryId# cfsqltype=cf_sql_integer /,
title = cfqueryparam value=#a.title#
cfsqltype=cf_sql_varchar /,
byLine = cfqueryparam value=#a.byLine#
cfsqltype=cf_sql_varchar /,
imageId = cfqueryparam value=#a.imageId#
cfsqltype=cf_sql_integer /,
imageCaption = cfqueryparam
value=#a.imageCaption# cfsqltype=cf_sql_varchar /,
abstract = cfqueryparam
value=#a.abstract# cfsqltype=cf_sql_varchar /,
body = cfqueryparam value=#a.body#
cfsqltype=cf_sql_varchar /,
isLead = cfqueryparam value=#a.isLead#
cfsqltype=cf_sql_bit /,
publishDateTime = cfqueryparam
value=#a.publishDateTime# cfsqltype=cf_sql_timestamp /

WHERE
articleId = cfqueryparam
value=#a.articleId# cfsqltype=cf_sql_integer /

/cfquery

/cffunction 





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


RE: CF Shopping carts

2010-06-25 Thread Paul Alkema

@jonah,
Your site looks excellent. Good work.

Paul Alkema
http://paulalkema.com/

-Original Message-
From: jonah blossom [mailto:jonah@creori.com] 
Sent: Thursday, June 24, 2010 9:13 PM
To: cf-talk
Subject: Re: CF Shopping carts


@Kevin,

I feel that this is one area that is completely overlooked in the CF
world--
Especially since OO was introduced to CF in MX.

So true.

When I was looking for a ecommerce solution several years ago, I evaluated
all the current offerings and joined the CFCommerce google group, etc.

I wasn't finding anything remotely like what I needed, so wrote a solution.
I'm now at the point of opening it up for others to use and am evaluating
business model and licensing options.

(Here's a live example: https://store.apolisactivism.com/)

If you'd like to talk more here or offline let me know.

Cheers,
.jonah 




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


RE: Is it time for Adobe to Rebrand Cold Fusion?

2010-06-25 Thread Paul Alkema

RapidFusion! Because developing is so rapid compared to developing in other
languages. haha

-Original Message-
From: =?ISO-8859-1?Q?Claude_Schn=E9egans [mailto:schneeg...@interneti=71?=
=?ISO-8859-1?Q?ue.com=3E?=] 
Sent: Friday, June 25, 2010 3:13 PM
To: cf-talk
Subject: Re: Is it time for Adobe to Rebrand Cold Fusion?


 Java Fusion

Please NO !
Enough Java con-fusion with Java and Javascript. ;-)




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


RE: cfdot.net (was: CF vs. ASP.Net)

2010-06-23 Thread Paul Alkema

@Jose,
I think that cfdot.net looks excellent. Thank you for doing this for both
the CF and ASP.NET community's.

@hatton,
I prefer C# over Visual Basic because of two reasons.

1. C# Has More Jobs available
a.
http://www.careerbuilder.com/Jobseeker/Jobs/JobResults.aspx?SB%3Asbkw=C%23 -
2,399 jobs found
b.
http://www.careerbuilder.com/Jobseeker/Jobs/JobResults.aspx?SB%3Asbkw=Visual
+Basic - 1,568 jobs found

2. On average C# developers make more money.
a. http://www.indeed.com/salary/VB-Net-Developer.html
b. http://www.indeed.com/salary?q1=C%23+Developer


Paul Alkema
http://paulalkema.com/


-Original Message-
From: C. Hatton Humphrey [mailto:chumph...@gmail.com] 
Sent: Tuesday, June 22, 2010 8:16 PM
To: cf-talk
Subject: Re: cfdot.net (was: CF vs. ASP.Net)


 Im not trying to nitpick, I only noticed them (except for Coldfusion...
that
 usually stands out to me) because I sent the link to my colleagues along
 with the text from the home page as a description for the link.

Two things that bug me -

1. It's C# which is one code-behind language for .NET.  I have yet to
have someone give me a quantifiable performance-based reason why it
better than other languages in the family.

2. The .NET version does not include the ASP.NET part of the
equation.  For example:
http://www.cfdot.net/cfdot/Pages/CodeDetail.aspx?id=7 (CFOutput) the
.NET code is simply setting the .Text property of a text box.  Where's
the creation of the object?

It's a great concept but as implemented it only confuses the whole CF
vs .NET conversation.

Hatton



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


RE: cfdot.net

2010-06-23 Thread Paul Alkema

I agree with Eric. I think this site's purpose is to help CFML programmers
understand C# from a CFML perspective. Not try to prove that CFML is better
than C#.

Paul Alkema
http://paulalkema.com/


-Original Message-
From: Eric Cobb [mailto:cft...@ecartech.com] 
Sent: Wednesday, June 23, 2010 3:28 PM
To: cf-talk
Subject: Re: cfdot.net


Calling him dishonest is very short sighted on your part (to say the 
least!).  Has the thought occurred to you that perhaps the reason there 
was so much extra code in the .Net example was because he's not a 
seasoned .Net developer?  I know I certainly wouldn't know the absolute 
best way to do something when just transferring over to a new language.  
I'm willing to bet there are many seasoned .Net developers who would 
make plenty of rookie mistakes when just starting out with CF. 

Perhaps instead of jumping to conclusions and making accusations, you 
should offer to help him clean up his examples so they are more accurate. 

Thanks,

Eric Cobb
ECAR Technologies, LLC
http://www.ecartech.com
http://www.cfgears.com



Matthew Small wrote:
 All language religion aside - it's not a fair comparison, it's biased
towards CF. You should be more honest in your comparisons if you expect
anyone to take it seriously.

 Example:

 CFEXECUTE:

 CF:
 cfexecute name=C:\WinNT\System32\netstat.exe 
 /cfexecute


 ASP.NET

 01.using System; 
 02.using System.Drawing; 
 03.using System.Collections; 
 04.using System.ComponentModel; 
 05.using System.Windows.Forms; 
 06.using System.Data; 
 07.using System.Diagnostics; 
 08. 
 09.... 
 10. 
 11.//Declare and instantiate a new process component. 
 12.System.Diagnostics.Process process1; 
 13.process1= new System.Diagnostics.Process(); 
 14.  
 15.//Do not receive an event when the process exits. 
 16.process1.EnableRaisingEvents = false; 
 17.  
 18.  
 19.//The /C Tells Windows to Run The Command then Terminate  
 20.string strCmdLine; 
 21.strCmdLine = /C netstat ; 
 22.System.Diagnostics.Process.Start(CMD.exe,strCmdLine); 
 23.process1.Close(); 



 All that is actually needed is:

 System.Diagnostics.Process.Start(netstat.exe); 

 All of the other stuff is extraneous.  The need for the using statements
is negated by the fully-qualified name for the method.  The object
process1 isn't used at all for the actual execution.  Passing the
netstat.exe executable to the cmd.exe process is ridiculous - you could do
the same with CFEXECUTE. Adding in extra string arguments just builds up the
amount of code you want to display. And FYI: this one line of code can be
executed in the .aspx page:

 % System.Diagnostics.Process.Start(netstat.exe) %

There are numerous similar examples on your website. It's a dishonest
misrepresentation.

 - Matt Small






   
 This is pretty sweet Jose.

 Thanks for taking the time to create this site! An excellent resource 
 indeed.

 Warm regards,
 Jordan Michaels
 Vivio Technologies
 http://www.viviotech.net/
 Open BlueDragon Steering Committee
 Railo Community Distributions

 On 06/22/2010 06:47 AM, Jose Diaz wrote:
 


 



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


Cfwindow

2010-06-22 Thread Paul Alkema

Hi,

Does anyone know if there is any possible way to close all open cfwindows
when a new cfwindow is opened? I would like to have only one cfwindow open
at a time.

 

Regards,

Paul 



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


RE: CFContent failing on large files since moving to ColdFusion 9

2010-06-22 Thread Paul Alkema

Did you restart the ColdFusion service after making this change? Increasing
the Maximum JVM Heap Size doesn't take effect until the cf service is
restarted.

How much disk space is left on your server? How much ram does your server
have?

-Original Message-
From: Daniel Mackey [mailto:dmac...@gmail.com] 
Sent: Tuesday, June 22, 2010 10:39 AM
To: cf-talk
Subject: Re: CFContent failing on large files since moving to ColdFusion 9


Unfortunately changing the heap (to 1024) didn't make a blind bit of
difference :-(

Anyone got any suggestions on a possible work around?

Dan.

On Tue, Jun 22, 2010 at 3:24 PM, Daniel Mackey dmac...@gmail.com wrote:

 That's interesting. I don't get any messages logged and the server stays
 up

 I might give the heap space a lash and see

 I'm always confused as to where to set the heap, perma and all that jazz
 and what effects it all has

 Dan.


 On Tue, Jun 22, 2010 at 3:11 PM, Tom Chiverton 
 tom.chiver...@halliwells.com wrote:


 Update:
 I now can't get anything to work on the box, because :

 Error,jrpp-15,06/22/10,15:10:25,billpack,Java heap space The
 specific sequence of files included or processed is:
 /home/chivertont/workspace/billpack/webroot/t.cfm'' 
 java.lang.OutOfMemoryError: Java heap space

 Of course a swift bounce of CF fixes that, but I wonder if you could try
 increasing you heap size to beyond the file size and see what happens ?

 --
 Tom Chiverton
 Helping to greatly seize B2B mission-critical compelling niches as part
of
 the
 IT team of the year 2010, '09 and '08

 

 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 Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3
3EB.
  A list of members is available for inspection at the registered office
 together with a list of those non members who are referred to as
partners.
  We use the word partner to refer to a member of the LLP, or an
employee
 or consultant with equivalent standing and qualifications. Regulated by
the
 Solicitors Regulation Authority.

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

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

 



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


RE: Pathing Problem

2010-06-21 Thread Paul Alkema

Make sure that the user that the web server is running has access to the E
drive. If you remote into the box and you have access to it doesn't mean
that the user running the server has access to it.

Paul

-Original Message-
From: Richard Steele [mailto:r...@photoeye.com] 
Sent: Monday, June 21, 2010 9:14 AM
To: cf-talk
Subject: Pathing Problem


Our images reside on a separate drive e:/images. Our website is on
c:\inetpub\wwwroot.

How do I show the images on the e drive?

Adding a virtual directory images in IIS and having img src in our code
point to  e:\images doesn't seem to work. 

Thanks in advance. 



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


ColdFusion 9 CSS Reset Warning

2010-06-18 Thread Paul Alkema

Hi All,

I just upgraded one my old sites to CF9 and was surprised all of a sudden to
see some changes in formatting on some pages but not others. IE; strong tags
not bolding, h1's looking different than previously and other issues as
well. After some investigating I found the issue, apparently CF9's ext
framework has a built in CSS reset.

 

See the code below.

 

File: CFIDE/scripts/ajax/resources/ext/css/ext-all.css

 

html,body,div,dl,dt,dd,h1,h2,h3,h4,h5,h6,pre,form,fieldset,input,p,blockquot
e,th,td{margin:0;padding:0;}

img,body,html{border:0;}

address,caption,cite,code,dfn,em,strong,th,var{font-style:normal;font-weight
:normal;}

//ol,ul {list-style:none;}

caption,th {text-align:left;}

//h1,h2,h3,h4,h5,h6{font-size:100%;}

q:before,q:after{content:'';}

 

I know, this is something that I should have probably been doing already and
strong tags are deprecated, but still. If I wanted to do a css reset, I
would do a css reset and wouldn't expect a ColdFusion upgrade to do it for
me.

 

Note: to make it more odd, this only effects pages that are using ColdFusion
tags that use the ext framework like cfgrid, cfwindow, cftooltip ect.

 

Best Regards,

Paul Alkema

http://paulalkema.com/

 



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


RE: ColdFusion 9 CSS Reset Warning

2010-06-18 Thread Paul Alkema

Ah, ok. I Googled it and didn't find much. Maybe I just didn't search the
correct thing. Anyway, I fixed it by just going into the file on the server
and commenting out the reset. Don't know if that was the correct thing to do
or not, but it fixed it for me and my ajax tags seem to be ok.

-Original Message-
From: Raymond Camden [mailto:rcam...@gmail.com] 
Sent: Friday, June 18, 2010 9:59 AM
To: cf-talk
Subject: Re: ColdFusion 9 CSS Reset Warning


Yep - this is a known issue. I just saw a blog entry on it a little
while ago - and it had a good workaround too. Give me a minute to dig
it up.

On Fri, Jun 18, 2010 at 8:56 AM, Paul Alkema
paulalkemadesi...@gmail.com wrote:

 Hi All,

 I just upgraded one my old sites to CF9 and was surprised all of a sudden
to
 see some changes in formatting on some pages but not others. IE; strong
tags
 not bolding, h1's looking different than previously and other issues as
 well. After some investigating I found the issue, apparently CF9's ext
 framework has a built in CSS reset.



 See the code below.



 File: CFIDE/scripts/ajax/resources/ext/css/ext-all.css




html,body,div,dl,dt,dd,h1,h2,h3,h4,h5,h6,pre,form,fieldset,input,p,blockquot
 e,th,td{margin:0;padding:0;}

 img,body,html{border:0;}


address,caption,cite,code,dfn,em,strong,th,var{font-style:normal;font-weight
 :normal;}

 //ol,ul {list-style:none;}

 caption,th {text-align:left;}

 //h1,h2,h3,h4,h5,h6{font-size:100%;}

 q:before,q:after{content:'';}



 I know, this is something that I should have probably been doing already
and
 strong tags are deprecated, but still. If I wanted to do a css reset, I
 would do a css reset and wouldn't expect a ColdFusion upgrade to do it for
 me.



 Note: to make it more odd, this only effects pages that are using
ColdFusion
 tags that use the ext framework like cfgrid, cfwindow, cftooltip ect.



 Best Regards,

 Paul Alkema

 http://paulalkema.com/





 



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


RE: ColdFusion 9 CSS Reset Warning

2010-06-18 Thread Paul Alkema

Thanks Ray, This was very helpful.

-Original Message-
From: Raymond Camden [mailto:rcam...@gmail.com] 
Sent: Friday, June 18, 2010 10:05 AM
To: cf-talk
Subject: Re: ColdFusion 9 CSS Reset Warning


http://nm1m.blogspot.com/2009/11/cfwindow-css-bug-workaround.html

On Fri, Jun 18, 2010 at 8:59 AM, Raymond Camden rcam...@gmail.com wrote:
 Yep - this is a known issue. I just saw a blog entry on it a little
 while ago - and it had a good workaround too. Give me a minute to dig
 it up.

 On Fri, Jun 18, 2010 at 8:56 AM, Paul Alkema
 paulalkemadesi...@gmail.com wrote:

 Hi All,

 I just upgraded one my old sites to CF9 and was surprised all of a sudden
to
 see some changes in formatting on some pages but not others. IE; strong
tags
 not bolding, h1's looking different than previously and other issues as
 well. After some investigating I found the issue, apparently CF9's ext
 framework has a built in CSS reset.


-- 
===
Raymond Camden, ColdFusion Jedi Master

Email: r...@camdenfamily.com
Blog  : www.coldfusionjedi.com
AOL IM : cfjedimaster

Keep up to date with the community: http://www.coldfusionbloggers.org



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


CF9 Developer Edition - IP Addresses

2010-06-16 Thread Paul Alkema

Hi,

Does anyone know how to edit the allowed allocated IP addresses for the CF9
developer edition license?

 

Thanks,

Paul



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


RE: CF9 Developer Edition - IP Addresses

2010-06-16 Thread Paul Alkema

That did it. Thanks.

-Original Message-
From: Charlie Griefer [mailto:charlie.grie...@gmail.com] 
Sent: Wednesday, June 16, 2010 9:57 AM
To: cf-talk
Subject: Re: CF9 Developer Edition - IP Addresses


On Wed, Jun 16, 2010 at 6:52 AM, Paul Alkema
paulalkemadesi...@gmail.comwrote:


 Does anyone know how to edit the allowed allocated IP addresses for the
CF9
 developer edition license?


AFAIK, not configurable.  The allowed addresses are 127.0.0.1, and whatever
the first 2 addresses that hit the server are.

You can reset them by restarting the CF service, but you can't configure
which 2 external addresses they are.

-- 
Charlie Griefer
http://charlie.griefer.com/

I have failed as much as I have succeeded. But I love my life. I love my
wife. And I wish you my kind of success.




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


RE: Avoiding SQL deadlocks

2010-06-10 Thread Paul Alkema

I've found this article on SQL deadlocks extremely helpful.

Reducing SQL Server Deadlocks
http://www.sql-server-performance.com/tips/deadlocks_p1.aspx

Paul Alkema
http://paulalkema.com/


-Original Message-
From: Mark A. Kruger [mailto:mkru...@cfwebtools.com] 
Sent: Wednesday, June 09, 2010 11:15 PM
To: cf-talk
Subject: RE: Avoiding SQL deadlocks


Even in a larger application if, for example, you are supported 150k
users against a database. Say there is regular uniform logging going on  -
say search results or whatever. Whether the code is in different files or
not if insert update queries are being run against the same tables you may
suffer DB performance issues (including deadlocks). It's not wether the code
is split - it's how the DB is being used and how much pressure is put on
shared resources.

Mark A. Kruger, MCSE, CFG
(402) 408-3733 ext 105
Skype: markakruger
www.cfwebtools.com
www.coldfusionmuse.com
www.necfug.com



-Original Message-
From: Bobby Hartsfield [mailto:bo...@acoderslife.com] 
Sent: Wednesday, June 09, 2010 10:03 PM
To: cf-talk
Subject: RE: Avoiding SQL deadlocks


In a smaller app where there is only one piece of code that performs the
actions that are causing deadlocks, sure.

.:.:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
 

-Original Message-
From: Dave Watts [mailto:dwa...@figleaf.com] 
Sent: Wednesday, June 09, 2010 7:28 PM
To: cf-talk
Subject: Re: Avoiding SQL deadlocks


 Since there is no deadlock error until a deadlock exists, the error you
 reported is most likely the victim and not the culprit. Of course it could
 have caused it then the same page was hit again and reported the error.

In most CF applications with deadlocks that I've seen, the same code
run concurrently is usually the cause of the deadlock. That is,
there's a single script being run by multiple users, and that causes
the deadlock.

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

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







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


List Of Custom Tags

2010-06-07 Thread Paul Alkema

Is there any possible way to pull a list of all custom tags available?


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


RE: ColdFusion and .NET Web Services running WSE 3.0

2010-06-07 Thread Paul Alkema

James, 
I too have had issue connecting to Exact Target's poorly documented API.

I did manage to figure out how to add a user via an older API though.

http://paulalkema.com/post.cfm/how-to-subscribe-a-user-in-exact-target-via-t
heir-api

Regards,
Paul Alkema

-Original Message-
From: Dan O'Keefe [mailto:dan.oke...@gmail.com] 
Sent: Sunday, June 06, 2010 2:36 PM
To: cf-talk
Subject: Re: ColdFusion and .NET Web Services running WSE 3.0


James,

I would be interested in participating on this as well as I have a
current need for the WS-Security piece with ExactTarget API.

Dan


On Sat, Jun 5, 2010 at 7:13 AM, James Holmes james.hol...@gmail.com wrote:

 OK, I'll finish up the webservice wrapper CFC on which I'm working and
then
 look at what's necessary to add the digest password type (currently I just
 have the text type working) and any other parts of WS-Security that are
 possible in CF.

 The code will work in CF8 and higher, although parts of it will probably
 work in CF7 (since that's when we got addSoapRequestHeader()).

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


 On 5 June 2010 21:15, Phillip Duba phild...@gmail.com wrote:


 James, I know I will definitely need something like that in the future.
 While this project went the .NET route, there are two follow-on projects
 that will most likely be needed, one requested by my group, so I know
I'll
 be working on at least one more integration using WS-Securit. Thanks,

 Phil

 On Sat, Jun 5, 2010 at 8:12 AM, James Holmes james.hol...@gmail.com
 wrote:

 
  Coincidentally, I've just finished developing the code necessary to do
a
  basic WS-SECURITY call in CF, using standard cf webservices code (i.e.
no
  extra Java jars or other external dependencies).
 
  If people need this sort of thing, let me know because I'm thinking of
  starting an open source project to flesh it out.
 
  mxAjax / CFAjax docs and other useful articles:
  http://www.bifrost.com.au/blog/
 
 
  On 5 June 2010 01:04, Phillip Duba phild...@gmail.com wrote:
 
  
   It did for the pure web services, not for the HTTP Post method (not
   recommended for production). It was a proof-of-concept under a tight
   deadline so I didn't have time to follow the web service all the way
to
  the
   conclusion I would need for production. I did find a few blog posts
 that
   got
   me pointed in the direction I probably needed to go. The specific
   implementation was the Username Token profile. I eventually got to
   receiving
   an error of cannot authorize/validate the username token. It probably
 had
   to
   do with timestamps and the makeup of the token itself. Again, I just
 ran
   out
   of time and the project was chosen to be done by another organization
   internally doing .NET work for which the WS-Security implementation
was
   seamless using MS's WSE library. It wasn't the deciding factor, but
it
  was
   definitely a differentiator,
  
   Phil
  
   On Fri, Jun 4, 2010 at 12:53 PM, Dan O'Keefe dan.oke...@gmail.com
  wrote:
  
   
Philip,
   
Did you authorization require WS-Security?
   
Dan
--
Dan O'Keefe
   
   
   
On Thu, Apr 29, 2010 at 12:13 PM, Phillip Duba phild...@gmail.com
   wrote:

 Dave, thanks for the response. I've gone to executing the request
  using
 CFHTTP, creating the soap:Header tag and building it as I go
 through
   the
WSE
 spec and examples. I've gotten to the point that I get
unauthorized
  so
 that's where I'm at now. I may have to use CFHTTP to do it, but
 we'll
see.
 Thanks again,

 Phil



   
   
  
  
 
 



 



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


Coldfusion Builder Stored Procedures

2010-06-01 Thread Paul Alkema

Hi,

Does anyone know if there's a way to view a databases stored procedures from
inside CF builder's RDS Dataview pane? From what I see it displays tables,
views, synonyms and system tables but no way to display stored procedures
for easy use. This seems like a major flaw to me.

 

Any ideas?

 

Paul Alkema

http://paulalkema.com/

 



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


RE: How to delete a post in House of fusion?

2010-05-27 Thread Paul Alkema

If your name or company is on something you want to get off Google, I would
instead of working to deleting it, get other content out on the web with
your name or company that would appear before it. 

Also just a note, the company I work for won't hire a developer unless their
name is our on development sites, either asking or answering questions.
-Original Message-
From: Matt Quackenbush [mailto:quackfu...@gmail.com] 
Sent: Thursday, May 27, 2010 1:49 PM
To: cf-talk
Subject: Re: How to delete a post in House of fusion?


There is no way to delete it.




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


RE: CF 9 Hosting

2010-05-20 Thread Paul Alkema

I've been using hostek for awhile and really like it.

http://hostek.com/

One of the best features I think is that you can run cf9 applications,
asp.net applications and php applications all from 1 hosting package which
is awesome since I develop in all of those languages. 

Also they're CF package is only $5/month which is awesome.

One down side I think is the hosting control panel isn't all that great, but
it works well and does that I want.

Regards,
Paul Alkema
http://paulalkema.com/


-Original Message-
From: James Holmes [mailto:james.hol...@gmail.com] 
Sent: Thursday, May 20, 2010 11:10 AM
To: cf-talk
Subject: Re: CF 9 Hosting


http://www.viviotech.net/


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


On 20 May 2010 06:10, Kelly Matthews ke...@webdiva.org wrote:


 Anyone know any good, reasonable CF 9 hosting companies w/ mysql.
 Thanks!




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


RE: CF 9 Hosting

2010-05-20 Thread Paul Alkema

Um, that's not good. That's odd, I've never had my site go down.

Oh well, good luck anyway. :)

-Original Message-
From: Kelly Matthews [mailto:ke...@webdiva.org] 
Sent: Thursday, May 20, 2010 11:41 AM
To: cf-talk
Subject: Re: CF 9 Hosting


Actually while hostek's prices are great, the fact that they go down 2-3
times PER day is far too much for my client, which is why I'm looking to
move.  Should have mentioned anyone but hostek.

I've been using hostek for awhile and really like it.

http://hostek.com/

One of the best features I think is that you can run cf9 applications,
asp.net applications and php applications all from 1 hosting package which
is awesome since I develop in all of those languages. 

Also they're CF package is only $5/month which is awesome.

One down side I think is the hosting control panel isn't all that great,
but
it works well and does that I want.

Regards,
Paul Alkema
http://paulalkema.com/


http://www.viviotech.net/


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


On 20 May 2010 06:10, Kelly Matthews ke...@webdiva.org wrote:


 Anyone know any good, reasonable CF 9 hosting companies w/ mysql.
 Thanks! 



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


RE: CF 9 Hosting

2010-05-20 Thread Paul Alkema

Coldfusion is going out of business and know one uses it any more?

Ignorant scum.

-Original Message-
From: Dawn Sekel [mailto:dawnt...@yahoo.com] 
Sent: Thursday, May 20, 2010 12:57 PM
To: cf-talk
Subject: Re: CF 9 Hosting


I have used them for years too -- but I have recently had a really bad
experience with them.  I signed one of my new customers up under a shared
hosting account -- just a small application.  The server he was on kept
crashing.  Their technical support told him that the problem was Coldfusion
and that he needed to switch to another technology.  They said Coldfusion is
going out of business and know one uses it any more.  Anyway -- I don't user
them any more for my smaller customers that can't afford a dedicated server.


I'll +1 for CrystalTech. I've been using them for years.

Thanks,

Eric Cobb
ECAR Technologies, LLC
http://www.ecartech.com
http://www.cfgears.com



Alan Rother wrote:
 



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


RE: Remove html characters

2010-05-18 Thread Paul Alkema

Try this...

cfset html = 'pa href=test with link/a /p' 
 
cfset withoutHtml = REReplaceNoCase(html,a .*(href=[']?)([^' ]+)['
][^]+([^]+)/a,\3: \2,all) 
cfset withoutHtml = REReplaceNoCase(withoutHtml,p[^]*,Chr(10),all) 
cfset withoutHtml = REReplaceNoCase(withoutHtml,[^]+,,all) 
cfoutput#withoutHtml#/cfoutput

Paul Alkema
http://Paulalkema.com/



-Original Message-
From: Rick Sanders [mailto:c...@webenergy.ca] 
Sent: Tuesday, May 18, 2010 9:38 AM
To: cf-talk
Subject: Remove html characters


Hey all,

 

What's the best way to remove html characters and make something plain text?
reReplace?

 

Thanks,

 

Rick

Webenergy

 

 






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


RE: Remove html characters

2010-05-18 Thread Paul Alkema

I don't know if this will actually help you or not, But I figured it might
help someone someday. Lol

If your using MSSQL and pulling the data your looking to strip from a
database, than you can actually do this from a mssql user defined function.



-- FIRST, RUN THE CODE BELOW ONCE TO CREATE YOUR INITIAL FUNCTION

USE [yourDataBaseName] --  yourDataBaseName  
GO
/** Strips html **/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE FUNCTION [dbo].[stripHTML]
(@HTMLText NVARCHAR(MAX))
RETURNS NVARCHAR(MAX)
AS
BEGIN
DECLARE @Start INT
DECLARE @End INT
DECLARE @Length INT
SET @Start = CHARINDEX('',@HTMLText)
SET @End = CHARINDEX('',@HTMLText,CHARINDEX('',@HTMLText))
SET @Length = (@End - @Start) + 1
WHILE @Start  0
AND @End  0
AND @Length  0
BEGIN
SET @HTMLText = STUFF(@HTMLText,@Start,@Length,'')
SET @Start = CHARINDEX('',@HTMLText)
SET @End = CHARINDEX('',@HTMLText,CHARINDEX('',@HTMLText))
SET @Length = (@End - @Start) + 1
END
RETURN LTRIM(RTRIM(@HTMLText))
END

-- USAGE EXAMPLE
SELECT dbo.udf_StripHTML('pa href=Test/a/p') as noHtml

-- OR YOU COULD DO THIS
SELECT dbo.udf_StripHTML(table.column) noHTML
FROM table

I've found this very helpful. :)

Regards,
Paul Alkema
http://paulalkema.com/


-Original Message-
From: Tom Chiverton [mailto:tom.chiver...@halliwells.com] 
Sent: Tuesday, May 18, 2010 11:21 AM
To: cf-talk
Subject: Re: Remove html characters


On Tuesday 18 May 2010 15:33:01 you wrote:
 #REReplace(trim(MYTEXTSTRING), [^]*, , All)#

But if I say that this is  the other thing, which is  that thing, it'll go

all wrong...

-- 
Tom Chiverton
Helping to centrally extend industry-wide plug-and-play slick products as
part 
of the IT team of the year 2010, '09 and '08



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
Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB.  A
list of members is available for inspection at the registered office
together with a list of those non members who are referred to as partners.
We use the word partner to refer to a member of the LLP, or an employee or
consultant with equivalent standing and qualifications. Regulated by the
Solicitors Regulation Authority.

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

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



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


RE: Comma Prepending to a form variable

2010-05-18 Thread Paul Alkema

Is it possible that you have more than one field with the name varList on
the page? If you have two form field on the same page with the same name.
Your action page will insert a comma in the form fields to delimit the
fields.

Paul Alkema
http://paulalkema.com/

-Original Message-
From: funand learning [mailto:funandlrnn...@gmail.com] 
Sent: Tuesday, May 18, 2010 1:50 PM
To: cf-talk
Subject: Comma Prepending to a form variable


Hi All,

I have a form variable which contains a list of names like

input type=hidden name=varList value=coldfusion,java,dotnet

when I go from the current page to another page and I check the above form
value, I have it as

 input type=hidden name=varList value=,coldfusion,java,dotnet

I am getting that extra comma before the first value. How to make sure I do
not have that extra comma?

Thanks




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


RE: Automate FTP

2010-05-14 Thread Paul Alkema

Have you tried seeing if it's possible to upload some of these big files
manually? It's not uncommon for FTP servers to have a max files size
restriction.

What's the error that your receiving?

Paul Alkema
http://paulalkema.com/


-Original Message-
From: Greg Luce [mailto:luce...@gmail.com] 
Sent: Friday, May 14, 2010 4:58 PM
To: cf-talk
Subject: Automate FTP


I have a remote server with some transaction logs I would like to automate
the ftp retrieval of. I have a scheduled task that uses cfftp to do so, but
it seems no matter how long I set the timeouts in the CF Admin for the task,
or in the cfftp tag, it fails for files larger than ~ 30-40M.

I can get 100M files via cmd like this either one step at a time in the cmd
window or with this in a batch script:
open 10.10.1.49
DBUser
DBPW
get Eligibility_tlog_201005141200.TRN
quit

I have tried all afternoon to use cfexecute to do this such that I can let
CF provide the filename programmatically with no luck.

So basically I would like to use some FTP inside my cf scheduled task rather
than using cfftp. Or any other ideas would be greatly appreciated. My
scheduled task has worked until the transaction logs started getting too
big.

-- 
Greg




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


RE: Converting Video uploads with ffmpeg on a shared host

2010-05-13 Thread Paul Alkema

I would say call your hosting company and talk to them to see if it would be
possible to remove that restriction. I would say that most likely they
won't.

If they won't perhaps you need a dedicated server.


-Original Message-
From: Carey Duryea [mailto:ca...@keepingitgreen.net] 
Sent: Thursday, May 13, 2010 12:35 AM
To: cf-talk
Subject: Converting Video uploads with ffmpeg on a shared host


i am uploading the videos and after uploading the video i need to convert it
into flash format and for that i found ffmpeg to conver vedio into flv.. but
to run this exe to convert vedio into flv format i should have access to run
the cfexecute tag which is current blocked byt the host...  i'm not sure
what to do for  a work around on this 



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


RE: ColdFusion Session Variables in Distributed Config

2010-05-12 Thread Paul Alkema

ColdFusion stores the session variables in the web server local RAM, however
when using ColdFusion with distributed configuration you should store the
sessions in the database because you don't know which machine will serve the
next page causing inconsistent sessions.

Paul Alkema
http://paulalkema.com/


-Original Message-
From: Mike Chabot [mailto:mcha...@gmail.com] 
Sent: Wednesday, May 12, 2010 1:46 PM
To: cf-talk
Subject: Re: ColdFusion Session Variables in Distributed Config


Sessions are stored on the server running ColdFusion.

-Mike Chabot

On Wed, May 12, 2010 at 1:07 PM, Donnie Carvajal
donnie.carva...@transformyx.com wrote:

 Does anyone know where the session variables are stored if Coldfusion is
running in a distributed configuration?  My assumption is the session
variables are stored on the server running ColdFusion and not the web
server, but you know what they say about assuming.

 Thanks,

 Donnie

 



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


RE: How are other developers handling big SVN repositories?

2010-05-07 Thread Paul Alkema

GIT does have an eclipse pluggin called eGit for use in your IDE.

http://www.eclipse.org/egit/

Paul Alkema
http://PaulAlkema.com

-Original Message-
From: Andrew Scott [mailto:andr...@andyscott.id.au] 
Sent: Friday, May 07, 2010 3:41 AM
To: cf-talk
Subject: RE: How are other developers handling big SVN repositories?


Wow you have lost me.

First let's look at a great Client UI first, SmartGit looks awesome have
been using the SamrtSVN version for awhile but I prefer it inside my IDE
first and foremost.

A lot of things you mention below I am not sure if you are referring to SVN
or GIT, you can certainly hide code in SVN now by just ignoring it. Might
have to look a bit closer how GIT does this.

Are you saying that GIT can't check out a part of a project, by revision? I
know you can in SVN so you must be talking about GIT here.

From what I read about GIT and Subversion 1.6 they are almost identical when
it comes to merging and patching code, not having used GIT at this point I
may have to look a bit harder at the differences.

But SVN is as powerful or not depending on if you utilise that power, and by
the sounds of it GIT is no different in that area as well.

If I have misread what you are trying to say, you didn't make it easy which
parts you are talking about for which application although I see a could
majority of it can be used in SVN.



-Original Message-
From: denstar [mailto:valliants...@gmail.com] 
Sent: Friday, 7 May 2010 4:35 PM
To: cf-talk
Subject: Re: How are other developers handling big SVN repositories?


Yes!  Git has been around a lot longer than I thought it had (catch
the wave, right?  I'm as bad as the anyone. :]), yet chunks of it are
still in flux as if it's brand new.

Nothing wrong with that, but with folks jumping on the wagon like they
have been, you'd think things like submodules (SVN:externals-ish
stuff) and other things like, say,  java implementations and 3rd party
tools/integrations would be there already.

For sure there'd be a decent windows implementation, right?  Not so,
until just recently (Understandable?  Plenty of linux heads hate
windoze (see?) with a passion.  Can't really blame 'em either.  I
mean... file locking from the 60s? WTF?  =)p).

I freaking *love* svn externals.  I love that you can check out any
part of a project, vs. the whole she-bang.  I love having that linear
history, at this point (maybe I'll change as I become more familiar
with the concepts of editing/deleting commit histories and whatnot).

The parts I love about Git are the parts that let me work the way I
*want* to work-- meaning, perhaps, not the way I *should* work.  Just
perhaps.

For Git, I love:  Shelving/stashing stuff.  Keeping stuff private and
then going public with it, yet with continuity (sorta).  Offline
commits!  ***sharing patches***! (it's built in!)

It's the bomb for open source, mostly because of github + easy
patching.  Love that social coding aspect it's got going on.

For closed source, or more centrally managed projects, something
centralized (like SVN) seems to make more sense.  At least for the
repository of record, ja know?  Nothing stopping anyone from using
both tools, which I find pretty freaking cool.

You don't /really/ *have* to choose, you see?

The one thing you *don't* have a choice about:  Learning the
methodologies of managing code changes when multiple people are
involved in the code.

There's just nothing that's going to save you from learning that.
It's sorta like a coder trying to get away from SQL ( ;) a weak
analogy, but I tossed it in for Barney).

I'm big on flexibility, and Git is more flexible than SVN (for good or
ill), so it probably will be the new SVN, eventually.  Ironically, I
think this flexibility is an boon to the lone developer, but actually
complicates multi-developer interaction.  With power, comes
responsibility.

Anyways, Git really is cool, and approaching problems from multiple
angles will better prepare you for future problems, so give it a spin!

Just don't let the power of the non-linear blind you to the weaknesses
of it, or blind you to the power of the linear.  We're beyond good and
evil. :)

Or something like that.  I'm not 100% wrapped around all this crap
yet, if ever.  They have *both* been awesome *and* painful, for me.  I
think that might just be life, though.

Or something like that.  :)

:den

-- 




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


RE: Convert image to its negative

2010-05-04 Thread Paul Alkema

I've never used this, but the cftagstore has a cfx tag that claims to do
this.

http://www.cftagstore.com/tags/cfximagesystem.cfm

Paul Alkema
http://PaulAlkema.com


-Original Message-
From: Les Irvin [mailto:les.cft...@gmail.com] 
Sent: Monday, May 03, 2010 8:05 PM
To: cf-talk
Subject: Convert image to its negative


Does anyone know of a CF custom tag that will convert an image to its
negative?  For example, converting a medical x-ray image to its
positive, etc.

Thanks in advance for any help,
Les



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


JRun

2010-05-04 Thread Paul Alkema

I'm getting a JRun error on the houseoffusion website. Just letting you all
know. J

 

Paul Alkema

 

 

ERROR BELOW


-

Server Error

The server encountered an internal error and was unable to complete your
request.

Could not connect to JRun Server.

 



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


RE: cfcatch issue

2010-04-28 Thread Paul Alkema

Are you on CF8 or higher? Try dumping the cfcatch scope and see what you
get.

Paul Alkema
PaulAlkema.com

-Original Message-
From: fun and learning [mailto:funandlrnn...@gmail.com] 
Sent: Wednesday, April 28, 2010 4:26 PM
To: cf-talk
Subject: cfcatch issue


hi all- 

I am using try/catch around a cfquery, and when I use #cfcatch.SQl# within
cfcatch, I get an error saying sql is undefined
in cfcatch. The same happens with #cfcatch.where#. Everything is fine with
#cfcatch.detail#, #cfcatch.message#.

I have been working with #cfcatch.sql# and #cfcatch.where# with no issues
until today. Can any one let me know what could be
the issue 



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333196
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: CfEclipse Slow Code Hinting

2010-04-23 Thread Paul Alkema

Eh, this helped so much. Makes the world a difference. I think the default
delay for this is way to slow.

Oh well, thanks so much.

Regards,
Paul Alkema
http://Paulalkema.com


-Original Message-
From: denstar [mailto:valliants...@gmail.com] 
Sent: Wednesday, April 21, 2010 6:22 PM
To: cf-talk
Subject: Re: CfEclipse Slow Code Hinting


For CFE it's:

Preferences  CFEclipse  Editor : Insight Delay

And you can disable specific kinds of assist using:

Preferences  CFEclipse  Editor  Auto-insertion  closing: Suggest...

In case one of them gets in your way too much at the lower delay setting.

:den

-- 
Psychologically experienced consciousness is therefore no longer pure
consciousness; construed Objectively in this way, consciousness itself
becomes something transcendent, becomes an event in that spatial world
which appears, by virtue of consciousness, to be transcendent.
Edmund Husserl


On Wed, Apr 21, 2010 at 3:41 PM, Jason Fisher wrote:

 Window  Preferences

 ColdFusion  Editor Profiles  Editor  Code Assist

 There's a setting there called Dealy Before Showing Code Assist(in
 milliseconds)

 



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333103
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: SQL data integrity

2010-04-22 Thread Paul Alkema

I'm no attorney or law professor but I would look into being PCI compliant.
I don't know if this is exactly what you need, but it definitely couldn't
hurt and it is a very high level of security. Keep in mind though, that it's
not easy. Good luck.

Regards,
Paul Alkema
http://paulalkema.com



-Original Message-
From: Justin Scott [mailto:jscott-li...@gravityfree.com] 
Sent: Thursday, April 22, 2010 3:31 PM
To: cf-talk
Subject: SQL data integrity


Hi all, not a CF-specific question but I'm hoping someone can point me in
the right direction.  We're building an application where some information
stored in our database could potentially be subpoenaed to court as evidence.
One of the issues brought up by the attorneys is the integrity of the data
stored in the database and how it could be proven in court that the data has
not been altered since it was entered into the database.  Any ideas on where
to start looking for a solution to that?  The front-end is ColdFusion with a
MS-SQL back-end.  This is a new area for me, so it's interesting, but I
don't have any points of reference to work from either.  Any insight is
appreciated.  Thanks!


-Justin





~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333095
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


CfEclipse Slow Code Hinting

2010-04-21 Thread Paul Alkema

Hi,

Does any know if there's any way to change how long it takes for cfEclipse
to provide code hinting? It's so slow.

 

Regards,

Paul



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333070
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


MSSQL Where In not working with variables

2010-04-20 Thread Paul Alkema

I know this is a CF list, sorry for posting this in the wrong area, but I
thought maybe one intelligent people might know. I've been working with the
WHERE IN clause in MSQL and It seems not to be working well for me with a
variable for some reason..

 

This is an example of what I'm trying to do

 

DECLARE @idList varchar(max)

SET @idList = '1,2'

 

SELECT *

FROM table

WHERE ID IN (@idList)

 

Any ideas?

 

Thanks,

Paul



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333042
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: MSSQL Where In not working with variables

2010-04-20 Thread Paul Alkema

Eh, sorry. I've just found the solution to my own problem.

 

Just for future reference, this is my solution.

 

DECLARE @idList varchar(max)

DECLARE @sql varchar(max)

SET @idList = '1,2'

SET @sql = 'SELECT * FROM table WHERE ID IN (' + @idList + ')'

EXEC(@sql)

 

Thanks

Paul

 

 

From: Paul Alkema [mailto:paulalkemadesi...@gmail.com] 
Sent: Tuesday, April 20, 2010 1:55 PM
To: 'cf-talk@houseoffusion.com'
Subject: MSSQL Where In not working with variables

 

I know this is a CF list, sorry for posting this in the wrong area, but I
thought maybe one intelligent people might know. I've been working with the
WHERE IN clause in MSQL and It seems not to be working well for me with a
variable for some reason..

 

This is an example of what I'm trying to do

 

DECLARE @idList varchar(max)

SET @idList = '1,2'

 

SELECT *

FROM table

WHERE ID IN (@idList)

 

Any ideas?

 

Thanks,

Paul



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333044
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Dynamic SQL Column Names

2010-04-15 Thread Paul Alkema

You could create one table that will store dynamic columns and another to
store the dynamic columns data.

Then if you're using MSSQL 2005+ than you can use SQL Pivots to extract the
data dynamically.. if your using anything less than MSSQL 2005 than you
could use dynamic SQL and build a temp table.

Pivots
http://www.sqlprof.com/blogs/sqldev/archive/2008/04/12/pivots-with-dynamic-c
olumns-in-sql-server-2005-2008.aspx

Regards,
Paul Alkema

-Original Message-
From: Brian Thornton [mailto:vegasthorn...@gmail.com] 
Sent: Thursday, April 15, 2010 5:21 AM
To: cf-talk
Subject: Re: Dynamic SQL Column Names


Or go runa  query on the table with 1 record using a select * and loop
through the columnlist returned.

On Wed, Apr 14, 2010 at 8:39 PM, Doug Ford doug.e.f...@gmail.com wrote:

 Hi Folks -

 I am wracking my brain trying to figure out how to get the results I am
looking for.

 Here's the background -

 I am dealing with dynamic environment allowing losers, I mean users, to
enter in field names.  This is a business product so anything is possible.

 When a user of the product creates the columns, they have no knowledge of
coldfusion or sql, so if a person enters in VIN # as a piece of
information they wish to capture, VIN # becomes a column header.

 Now then, on any given random form my system would be creating, I won't
know how many fields or their names.

 If a person creates 5 or 500 fields, I have no clue, and I won't know what
column names they could ultimately create.

 I have been toying with getColumnList() to display the column titles, but
how would I get the actual data out of it?

 I have tried using evaluate on the field names, but when it comes across
VIN #, the system blows up.

 Any and info is appreciated.

 Thanks,

 Doug



 



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332904
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: What happens to session variables after redirecting to https?

2010-04-01 Thread Paul Alkema

Hmm.. I don't think this is correct. My site doesn't pass tokens in order to
keep session variables or cookies.

When a user first lands on my http site, I set sessions/cookies and pass
them to our cart which is https and both of them are transferred just fine
and I don't pass any type cf tokens.

I don't know if it makes a difference but I use 128 bit High-grade
Encryption.

Now... yoursite.com vs www.yoursite.com is a different issue. That is seen
by most browsers as being different sites and doesn't allow you to pass
cookies to between the two sites.

Paul Alkema
http://www.alkemadesigns.com/


-Original Message-
From: Jason Fisher [mailto:ja...@wanax.com] 
Sent: Wednesday, March 31, 2010 10:49 PM
To: cf-talk
Subject: Re: What happens to session variables after redirecting to https?


No, from a cookie perspective, http://mysite.com and https://mysite.com 
are 2 different domains, so you need to send the session tokens across 
the gap.  Any of a number of approaches can work, but here's the quick 
and dirty:

cflocation url=https://#mySecureURL#; addtoken=yes /

Or, if you are using some other redirection, you can append the 
following to the URL:

cfid=#cookie.cfid#cftoken=#cookie.cftoken#

(Note that the nomenclature is different if you're using Java session IDs.)



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332517
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Eclipse Compare Remote Files

2010-04-01 Thread Paul Alkema

Hi all,
Does any of you know of a plugin or a way to easily compare a remote file
for changes?

I have cfEclipse and Aptana.

Paul Alkema


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332538
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Decrypt CF scheduled job password?

2010-03-31 Thread Paul Alkema

Yeah if you do google coldfusion decrypt datasource password make sure you
click on what's currently the 4th option entitled How To Crack Coldfusion
Datasources . I think you'll find that the most helpful. ;)

Paul Alkema
AlkemaDesigns.com


-Original Message-
From: b...@bradwood.com [mailto:b...@bradwood.com] 
Sent: Tuesday, March 30, 2010 10:45 PM
To: cf-talk
Subject: RE: Decrypt CF scheduled job password?


I've never tried it, but if the cron passwords are stored the same way
data source passwords are, then they probably are crackable.
Google coldfusion decrypt datasource password

Note:  The people who figured out how to decrypt CF passwords had to
decompile CF's source Java code so enter at your own legal risk.  :)

~Brad


 Original Message 
Subject: Decrypt CF scheduled job password?
From: Qing Xia txiasum...@gmail.com
Date: Tue, March 30, 2010 8:09 pm
To: cf-talk cf-talk@houseoffusion.com


Hello folks,

I was just wondering, does anyone happen to know if the password in the
CF
scheduled job XML file (cfroot\lib\neo_cron.xml) is crackable?




~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332486
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: reverse engineer PHP to CF

2010-03-29 Thread Paul Alkema

My whole outlook on converting scripts from one language to another is to
look the front end and get an idea of what the application's purpose is and
try to figure out exactly what the application is doing, then look at the
backend and confirm your front end finding. Take notes! Then rewrite your
new application in the way that you think that it should be written keeping
in mind that you need to have the same end result as the old script. Or you
could even make improvements!

I think translating the scripts directly from one language to another will
usually result in an application that was written poorly. Languages work
differently than another. I think the important thing is that the end
results are the same.

Paul Alkema
AlkemaDesigns.com

-Original Message-
From: Glyn Jackson [mailto:glyn.jack...@newebia.co.uk] 
Sent: Monday, March 29, 2010 9:39 AM
To: cf-talk
Subject: Re: reverse engineer PHP to CF


cool final is below...

cfparam name=reportName default= /
cfset reportFile = expandPath(/Powerbase)  /  reportName  . 
reportID  _sql / 
 
 cfswitch expression=#op# 
  cfcase value=load 
   cffile action=READ file=#reportFile# variable=ff / 
   cfoutput#ff#/cfoutput 
  /cfcase 
  
  cfcase value=save  
cfoutput  
cfdump var=#form#
 cfset qry = #form.queryToSave# / 
 cffile action=WRITE file=#reportFile# output=#qry#
nameconflict=OVERWRITE / 
 cfoutput#reportName#/cfoutput saved ... 
 /cfoutput 
  /cfcase 
  
  cfcase value=list 
  
   cfdirectory action=LIST directory=#expandPath('/Powerbase')#
name=files / 
   cfoutput 
   ul class=treeview id=treeview_#reportID# 
   li class=listSaved sql files 
 ul 
cfloop query=files 
  cfif right(name, 4) is _sql 
  li class=item#listFirst(name, .)#/li

  /cfif   
 /cfloop
 /ul 
 /li   
 /ul 
/cfoutput 
  /cfcase 
 
 
 
   
cfdefaultcase 
/cfdefaultcase 
 /cfswitch 



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332413
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: ColdFusion SQL Hack

2010-03-22 Thread Paul Alkema

I would ensure that every single update / insert on your site is using
cfqueryparam's for security sake, however It sounds to me like your issue is
not SQL injection.. but more XSS attacks. An XSS attack is where data is
inserted into into a page usually via a database input field somewhere which
then executes a javascript or other piece of code into a site which can
cause users sessions to be hijacked or the user could be simpley redirected,
which is what is sounds like this xsser is doing.

Dorioo is right on about the fix for this, I would either sanitize all data
that a customer has access to input with the htmleditformat() or sanitize
the output with htmleditformat().

IE; 

INSERT INTO users (userId, userName)
VALUES ('#form.username#')

Should be..

INSERT INTO users (userId, userName)
VALUES ('#htmlEditFormat(form.username)#')

Another option would be to enable Global Script Protection in the settings
area of your coldfusion administrator. Doing this will cause you to never
have the ability to pass javascript tags and object tags via CGI, FORM and
URL variables though, so I would be careful about this global option.

Good luck!
Paul Alkema
AlkemaDesigns.com

-Original Message-
From: Mike Chabot [mailto:mcha...@gmail.com] 
Sent: Monday, March 22, 2010 9:25 AM
To: cf-talk
Subject: Re: Coldfusion SQL Hack


The query you wrote is not hackable via SQL injection. No changes need
to be made to it.

-Mike Chabot

On Mon, Mar 22, 2010 at 7:04 AM, Anthony Doherty
a.dohe...@advancesystems.co.uk wrote:

 I have a site page that is only using the query below and the site keeps
getting hit by SQL hacks.  I have looked through every SQL query and all the
queries are using cfqueryparam value=#URL.???#
cfsqltype=cf_sql_numeric so they cant be hacked.

 Can someone explain how I can amend this query so its not hackable??

 cfquery name=RS1 datasource=DS1
 SELECT     FEEDBACK.ID, FEEDBACK.FEEDBACK, FEEDBACK.LEFT_BY,
County.County, County.ID
 FROM         FEEDBACK INNER JOIN
                      County ON (FEEDBACK.COUNTY = County.ID)
 /cfquery

 Thanks

 



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331941
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Cfsearch - Spell Checker

2010-03-22 Thread Paul Alkema

Hi All,

The CfSearch tag has a built in spell checker however, the company I work
for is an engineering company so words that people would search for and make
spelling issues are a bit more advanced than the built in spell checker that
adobe has provided by default via the cfSearch tag.

 

Does anyone know if there is a way to edit the list of spell fixes?

 

Best Regards,

Paul



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331942
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Does not contain dilema

2010-03-22 Thread Paul Alkema

First off, as a general rule I would put the variable first, then the
string. So you have cfif united States contains country. I would try cfif
country contains united states.

Secondly..

You need to var your variables.

If country is a form variable refer to it as form.country... not just
country. This could really mess you up down the road, plus it's just a bad
practice.


Some something like...
cfif 
form.country contains United States 
and form.state contains IL
and not form.inType contains K-12
 /

Also, what I do in instances where I'm using multiple IF arguments and I'm
trying to find which one is causing my IF statement to fail, is I remove the
cif at the beginning and the closing IF bracket.

Then I wrap an cfoutput tag around the IF statement and put pound signs
around each statement. This should output YES or NO if the statement is
passing or not. This is a good way to diagnose which 

For instance this should tell you exactly which IF argument is causing your
IF statement to fail.

cfoutput
#United States Contains Country# and #K-12 does not contain intype# and
#(State is IL) or (State is IA)#
/cfoutput
cfabort /

Regards,
Paul Alkema
http://www.alkemadesigns.com

-Original Message-
From: Orlini, Robert [mailto:rorl...@hwwilson.com] 
Sent: Monday, March 22, 2010 11:51 AM
To: cf-talk
Subject: Does not contain dilema


I have a form with a field call intype which I need to filter and NOT send
an email if the form does contain a certain list of states, but does not
contain the value k-12 for intype.

The cfif I have that does not seem to work is:

CFIF United States Contains Country and K-12 does not contain intype
and IL Contains State or IA Contains State.

I've tried, but it still sends the email which I don't want:

CFIF United States Contains Country and K-12 does not contain intype
and (State is IL) or (State is IA)

Any easier way to do this please?

Thanks.

RO
HWW




~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331954
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: ColdFusion Builder Released!

2010-03-22 Thread Paul Alkema

I agree, I wouldn't want flashbuilder but I would want cfbuilder. I wouldn't
want to pay for flashbuilder if I don't want it.

I'm switching back to cfEclipse.


-Original Message-
From: Eric Roberts [mailto:ow...@threeravensconsulting.com] 
Sent: Monday, March 22, 2010 1:18 PM
To: cf-talk
Subject: RE: ColdFusion Builder Released!


Considering that I don't need flash...no it's not.  If flash is the cost,
then they should offer a version without flash builder.  I think it is an
outrageous price for a plugin.

Eric

-Original Message-
From: Jake Churchill [mailto:reyna...@gmail.com] 
Sent: Monday, March 22, 2010 12:14 PM
To: cf-talk
Subject: Re: ColdFusion Builder Released!


It's bundled with FlashBuilder 4 which is nice.  That's actually a pretty
decent price.

On Mon, Mar 22, 2010 at 12:10 PM, Eric Roberts 
ow...@threeravensconsulting.com wrote:


 299.00?  WTF?  What the heck is Adobe smoking?  Looks like its back to
 CFEclipse for me!

 Eric

 -Original Message-
 From: Adrocknaphobia [mailto:adrocknapho...@gmail.com]
 Sent: Monday, March 22, 2010 11:46 AM
 To: cf-talk
 Subject: ColdFusion Builder Released!


 The subject says it all.

 If you haven't looked at ColdFusion Builder since the last public beta,
you
 should check out the final release. There have been about 4 months of
 performance enhancements, bug fixes and tweaks since then. You can
download
 a 60-day trial of ColdFusion Builder from Adobe.com.

 http://bit.ly/TryBolt

 -Adam




 





~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331986
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Cfsearch - Spell Checker

2010-03-22 Thread Paul Alkema

I asked this question at 10:03 AM this morning. Does anyone have any idea's
on this?

 

Thanks,

Paul

 

From: Paul Alkema [mailto:paulalkemadesi...@gmail.com] 
Sent: Monday, March 22, 2010 10:03 AM
To: 'cf-talk@houseoffusion.com'
Subject: Cfsearch - Spell Checker

 

Hi All,

The CfSearch tag has a built in spell checker however, the company I work
for is an engineering company so words that people would search for and make
spelling issues are a bit more advanced than the built in spell checker that
adobe has provided by default via the cfSearch tag.

 

Does anyone know if there is a way to edit the list of spell fixes?

 

Best Regards,

Paul



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331989
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


  1   2   >