Re: ColdFusion Peformance Blog Down

2011-09-28 Thread David McGuigan

Down again.

http://www.cfwhisperer.com/post.cfm/good-practices-for-scaling-coldfusion-applications



On Fri, Aug 26, 2011 at 1:42 PM, David McGuigan davidmcgui...@gmail.comwrote:

 This has been down for the last few days: http://www.cfwhisperer.com/

 Anyone have a quick way of getting ahold of Mike?



~|
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:347779
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: CF Standard License

2011-09-23 Thread David McGuigan

You sure you don't want a CF8 Enterprise license? You can buy mine at a hell
of a discount!


On Fri, Sep 23, 2011 at 11:45 AM, Richard White rich...@j7is.co.uk wrote:


 Hi,

 Am i right in understanding that the only places to get CF9 Standard
 licenses are from Adobe or hosting companies?

 Our hosting company doesn't resell them and we looking for the most
 competitive pricing!

 thanks

 

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


Re: 20USD/Hour Seriously?

2011-09-23 Thread David McGuigan

Morality.


On Fri, Sep 23, 2011 at 7:59 AM, Al Musella, DPM
muse...@virtualtrials.comwrote:


 This may be a stupid question - I never worked by the hour, but I do
 sometimes hire people by the hour to do programming - but prefer
 paying by by the job..

 There is no way to know how much time was spent programming
 something.  What is to stop someone from charging $20 an hour, but
 doubling the amount of hours on the invoice so they really get $40 an hour?
 I know when I am programming, sometimes I get an awful lot of work
 done in an hour, and sometimes I am stuck looking for a bug or
 adjusting something to be perfect and waste



 

~|
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:347645
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: 20USD/Hour Seriously?

2011-09-23 Thread David McGuigan

Do I?


On Fri, Sep 23, 2011 at 2:49 PM, Larry Lyons larrycly...@gmail.com wrote:


 Morality.
 

 Ethics you mean.

 

~|
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:347675
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: 20USD/Hour Seriously?

2011-09-22 Thread David McGuigan

Is it just me or does this post smell of trollage?


On Thu, Sep 22, 2011 at 9:03 AM, Phillip Vector
vec...@mostdeadlygame.comwrote:


 IMHO, you get what you pay for. I've talked with several clients who
 hired at $20/hr or even less. I'm usually called in to clean up the
 mess at my standard rate ($50/hr) and they almost always don't bat an
 eye paying it having learned their lesson.

 I will admit though... I HAVE done work for $20/hr. But only if the
 extras (how fun it will be to code it, free trips to seminars, etc)
 make it worth it.

 On Thu, Sep 22, 2011 at 7:45 AM, Integration Developer
 tyrsbl...@gmail.com wrote:
 
  I'm bit confused why so cheap? Just 6 months ago I was hiring out at
 50-75USD/hour.
  If this is typical cf-jobs side work rate now I am disappointed.
 
 

 

~|
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:347595
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: 20USD/Hour Seriously?

2011-09-22 Thread David McGuigan

Ok just wondering, because this is how I read that post:

Hey guys I found a CF job for $20 an hour :( :( :(  I can't effing believe
that every CF job on Earth doesn't pay AT LEAST 1 Million Dollars per hour.
This is stupid right? ColdFusion is stupid now right?

But I get that you're sincere.

You could always not take that job and look for something $$$ier.

I personally know some full time students that work at CF jobs that start at
$13 an hour, and some pros that work at salaried gigs that equate to about
$70 an hour.

Depending on what project you're working on, who you're working for, and
your talent/productivity level, your pay will vary wildly. In pretty much
every industry and career on Earth. That's just life my friend.

If you find that you're not earning as much as you'd like, upgrade yourself.
Education, work ethic, a focus on technique. The world is your oyster and so
forth!



On Thu, Sep 22, 2011 at 9:55 AM, Phillip Vector
vec...@mostdeadlygame.comwrote:


 No trollage was intended. Seriously.

 On Thu, Sep 22, 2011 at 8:50 AM, David McGuigan davidmcgui...@gmail.com
 wrote:
 
  Is it just me or does this post smell of trollage?
 
 
  On Thu, Sep 22, 2011 at 9:03 AM, Phillip Vector
  vec...@mostdeadlygame.comwrote:
 
 
  IMHO, you get what you pay for. I've talked with several clients who
  hired at $20/hr or even less. I'm usually called in to clean up the
  mess at my standard rate ($50/hr) and they almost always don't bat an
  eye paying it having learned their lesson.
 
  I will admit though... I HAVE done work for $20/hr. But only if the
  extras (how fun it will be to code it, free trips to seminars, etc)
  make it worth it.
 
  On Thu, Sep 22, 2011 at 7:45 AM, Integration Developer
  tyrsbl...@gmail.com wrote:
  
   I'm bit confused why so cheap? Just 6 months ago I was hiring out at
  50-75USD/hour.
   If this is typical cf-jobs side work rate now I am disappointed.
  
  
 
 
 
 

 

~|
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:347599
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: 20USD/Hour Seriously?

2011-09-22 Thread David McGuigan

I didn't mean that you were actually saying CF was stupid. I was trying to
just paraphrase your sentiment into a tantrum. Which is what it sounded
like. But I get what you mean.


On Thu, Sep 22, 2011 at 10:25 AM, Phillip Vector
vec...@mostdeadlygame.comwrote:


 On Thu, Sep 22, 2011 at 9:11 AM, David McGuigan davidmcgui...@gmail.com
 wrote:
 
  Ok just wondering, because this is how I read that post:
 
  Hey guys I found a CF job for $20 an hour :( :( :(  I can't effing
 believe
  that every CF job on Earth doesn't pay AT LEAST 1 Million Dollars per
 hour.
  This is stupid right? ColdFusion is stupid now right?

 I I don't see how you can see that in my post... I'm honestly
 trying, but I don't follow.. That's pretty much has nothing to do with
 what I posted.

 What I was trying to say is that I usually work for $50 an hour. If a
 company contracted me out to (let's say.. Valve) for $20/hr, I would
 lower my rate of pay to go work that company (especially when you get
 every game on steam for it and they have on-call massages available.
 Yes, I'm being serious).

 So if $20/hr + perks means I am making more then $50/hr, then I'll
 take the cut in pay for the extras (and the prestige of working
 there).

 I, in no way, think CF is stupid. I just got off a contract for
 $40/hr. for 6 months. The length of time of the contract helped me
 decide to go to $40 an hour. CF right now is keeping me working. :)
 That's a good thing in my mind.

  You could always not take that job and look for something $$$ier.

 I'm ALWAYS looking for more work. Even if I'm working for the $50/hr.,
 if someone comes along and offers me $80/hr., I'll take it (finishing
 up my initial contract of course).

  I personally know some full time students that work at CF jobs that start
 at
  $13 an hour, and some pros that work at salaried gigs that equate to
 about
  $70 an hour.

 As do I. The 13-20/hr. I hear about are the people I'm usually called
 on to clean up after. Spaghetti code and such. Usually, I tell clients
 to nuke it from orbit to be sure and they agree. Once I have their
 site back up to how it should be (usually taking less time then the
 other guy), they are happy to pay the last part of the invoice. Hence
 my You get what you pay for

 

~|
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:347603
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


oAuth and MySQL

2011-09-14 Thread David McGuigan

Saw the oAuth library at RIAForge, and it appears to support errything BUT
MySQL. Has anyone done it before? Should I just port all of the table
generation and sql myself?

Thanks!


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


Re: SOT: Workstation recommendations

2011-09-07 Thread David McGuigan

Dell and HP here, have had not a single issue with more than 5 systems of
each over the last decade except a single broken key on a Dell laptop which
they overnighted a replacement for for free with no extra service plan or
warrantee service.

Dell's refurbished outlet gives you some great deals with identical
warranties to their new products.

The main reason I prefer Dell and HP systems ( particular models only
disclaimer ) is that they're much more attractive than all of the other
Windows brands.

As far as performance, you can buy any cheap windows desktop with anything
i5 or better and 8GB of RAM and throw a PCIE revo drive into it for a few
hundred dollars and get better performance than any high end workstation for
ColdFusion development. Just make sure you do your research, they've
released 4-5 generations of the Revo drive ( a simple SSD Raid 0 on a PCI
express card ) in the last few years, you'll want the newest generation that
fits your price point.




On Wed, Sep 7, 2011 at 10:33 AM, Mike Chabot mcha...@gmail.com wrote:


 I normally build my own workstations, but if I were to buy a
 workstation today I would likely get one from Puget Systems, such as
 the Puget Serenity SPCR Edition. I've never ordered from that store,
 but they get universally good reviews.

 -Mike Chabot

 On Wed, Sep 7, 2011 at 11:44 AM, Matt Williams mgw...@gmail.com wrote:
 
  My HP desktop at work died last night. This morning we took the hard
  drive out and put it into another box whose drive had died a couple
  months ago. It worked at first, but after about 20 minutes it croaked
  too.
 
  Anyway, I'll be shopping for a new desktop and just wondered what
  brands people recommend these days. I'll probably stay away from HP
  and plan to stay with a Windows machine. I run CF Developer, SQL
  Server Mgt Studio, CF Builder, Adobe Creative Suite (primarily DW and
  PS), MS Office, and various browsers and other tools.
 
  Dell?
  Lenovo?
  Asus (seems to be mostly gaming oriented)?
  Acer?
  Gateway?
  Others?
 
  Thanks,
 
  -Matt

 

~|
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:347282
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: How do you compose your dev teams?

2011-09-02 Thread David McGuigan

Two words. Walkie talkies.


On Fri, Sep 2, 2011 at 1:12 PM, Nathan Strutz str...@gmail.com wrote:


 Hi everybody.

 I have a little management-type dilemma that I can't solve. I'm no manager,
 so I'm trying to collect info about how other people do it.

 I work in a small group of CF developers (7 of us) inside a big company
 (100k+ of us). The way we work is that pretty much everybody owns one or
 more applications in our group's portfolio of programs (probably 10 apps, 3
 or 4 are big  important). My manager has noticed that we don't communicate
 enough and has started threatening drastic measures, moving people around
 and putting us where we don't want to be. I am not sure of his motivation,
 but it may be partially the hit-by-a-bus protection, wondering if his apps
 will be supported if one of us eats a piece of public transportation.

 So my question to the list is this: How do you organize your teams of
 developers successfully? Please let me know what you do, or what you have
 seen that actually works.



 I'll start us off.

 I asked my friend Mario, who says they have a team of core developers that
 do RD at a higher level, overseeing the technical direction of their
 applications. Those RD projects are flowed out into application
 development
 teams, and then they have a lot of other developers who do front-ends and
 integration work. Regular flow-down meetings help people share ideas and
 copy  adapt similar projects.

 Mario's team compositon sounds awesome, but he has a lot more people than I
 do. What do you do?

 nathan strutz
 [www.dopefly.com] [hi.im/nathanstrutz] [about.me/nathanstrutz]


 

~|
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:347191
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Bulk image upload and in-browser cropping?!?

2011-08-30 Thread David McGuigan

Anyone built anything that lets you select multiple image files from a web
browser for upload ( as well as folders ) like Facebook has?

How about anything that lets you do in-browser image cropping?

I can probably fire up Flash and develop the 2nd part myself, but I'm hoping
there's something out there that I can just plug in and use particularly
smoothly with ColdFusion.

Thanks.


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


ColdFusion Peformance Blog Down

2011-08-26 Thread David McGuigan

This has been down for the last few days: http://www.cfwhisperer.com/

Anyone have a quick way of getting ahold of Mike?


~|
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:347038
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: ColdFusion Peformance Blog Down

2011-08-26 Thread David McGuigan

Thanks. Trying to get to one of his posts!


On Fri, Aug 26, 2011 at 2:08 PM, Raymond Camden raymondcam...@gmail.comwrote:


 I pinged him.

 On Fri, Aug 26, 2011 at 2:42 PM, David McGuigan davidmcgui...@gmail.com
 wrote:
 
  This has been down for the last few days: http://www.cfwhisperer.com/
 
  Anyone have a quick way of getting ahold of Mike?
 
 
 

 

~|
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:347041
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: What the heck

2011-08-22 Thread David McGuigan

IsDefined takes a string. But you'll want to do structKeyExists instead
anyway.



On Mon, Aug 22, 2011 at 11:50 AM, Robert Harrison 
rob...@austin-williams.com wrote:


 What am I missing here

 Element USERID is undefined in SESSION.
 The error occurred in
 C:\inetpub\wwwroot\vaughn_college_portal\_main_securecheck.cfm: line 3
 1 : !--- if the cookie is here, procees to dashboard ---
 2 : cfset validated_id=0
 3 : cfif isDefined(session.userid)



 

~|
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:346938
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: cf enterprise quad cpu box

2011-08-15 Thread David McGuigan

Are you saying that one of your cores has high utilization and the others
none? Your server should use all cores *as necessary* *if ever necessary*
*automatically* *without the intervention or management of your
application*.

That said you can break certain parts of code off into separate threads
using the cfthread tag, but that's to make a specific URL or process more
performant by prioritizing or simulprocessing code chunks, not to try to
balance workload across multiple cores or processors.




On Mon, Aug 15, 2011 at 12:53 PM, Dan Baughman dan.baugh...@gmail.comwrote:


 With the one jrun.exe process running, I can never get coldfusion to really
 utilize multiple processors.

 Is there a way in enterprise mode that you can set it to spawn multiple
 jrun.exe processes, one per processor to work collaboratively serving one
 web site?


 

~|
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:346760
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: ColdFusion 10 and beyond

2011-08-11 Thread David McGuigan

What's the login?


On Thu, Aug 11, 2011 at 3:58 AM, mac jordan mac.jor...@gmail.com wrote:


 On Thu, Aug 11, 2011 at 3:16 AM, David McGuigan davidmcgui...@gmail.com
 wrote:

 
  Don't get me wrong, WordPress is great. But it's not anything astounding.
  And it is slow.



 I run WordPress on our own servers, and it is nothing like as slow as you
 report.

 --
 mac jordan
 www.kestrel.org | www.reactivecooking.com |  www.jordan-cats.org |
 www.georgethefish.com
 twitter: @ramtops


 

~|
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:346693
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: ColdFusion 10 and beyond

2011-08-10 Thread David McGuigan

Nah, WordPress is just slow. Clicking Dashboard takes up to 5 seconds for me
on the hosted version consistently.

And WordPress does seem to do some pretty intelligent ( though slow as crap
) caching on every change to any of your content, which is worth it to them
and their scale I'm sure but annoying to users.

I just logged into my WordPress and made a 1 sentence change to a post from
earlier today to verify, it was about 5 seconds before the post was updated
and I got a response from the server.

That with speedtest.net reporting 22 Mbps down and 4.84 up with cloud
streaming in Zune and no other network traffic active.

Don't get me wrong, WordPress is great. But it's not anything astounding.
And it is slow.



On Wed, Aug 10, 2011 at 5:47 PM, Russ Michaels r...@michaels.me.uk wrote:


 you probably have a lot of errors. You really need to turn on the debugging
 and have a look, there are often plugins that conflict with each other or
 are not compatible with current version and as result you can have tons of
 error sin the background.
 You also need to make sure you are using FastCGI on windows to speed things
 up.


 On Wed, Aug 10, 2011 at 11:05 PM, Gerald Guido gerald.gu...@gmail.com
 wrote:

 
  As for WP being so much better than BlogCFC and Mango -I'm sure it is.
 
  That depends how you define better. I use both and bog.cfc is way
 faster
  than WP. Page loads with blog.cfc is like flipping channels on the tv.
 
  G!
  On Aug 10, 2011 5:47 PM, Raymond Camden raymondcam...@gmail.com
 wrote:
  
   Hey, we always have room on the BlogCFC team too. ;)
  
   As for WP being so much better than BlogCFC and Mango - I'm sure it
   is. Yet oddly - I've been successfully blogging for years (as have
   hundreds of Mango and BlogCFC users). Maybe I don't know what I'm
   missing, but I'm certainly getting content out there.
  
   On Tue, Aug 9, 2011 at 6:46 PM, Russ Michaels r...@michaels.me.uk
  wrote:
  
   there is hope, if people continue writing plugins for Mangoblog then
 it
   could be the cf equivalent of wordpress, although it does need some
   performance tuning as it is not the fastest app, although very well
  written.
  
   On Tue, Aug 9, 2011 at 10:44 PM, Eric Roberts 
   ow...@threeravensconsulting.com wrote:
  
  
  
 
 

 

~|
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:346668
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: ColdFusion 10 and beyond

2011-08-10 Thread David McGuigan

I should probably clarify that the rest of the web for me is nearly instant
and I have an average ping of about 4 ms. In other words WordPress being
slow is based on repeat observation, not a potential one-off fluctuation.


On Wed, Aug 10, 2011 at 8:16 PM, David McGuigan davidmcgui...@gmail.comwrote:

 Nah, WordPress is just slow. Clicking Dashboard takes up to 5 seconds for
 me on the hosted version consistently.

 And WordPress does seem to do some pretty intelligent ( though slow as crap
 ) caching on every change to any of your content, which is worth it to them
 and their scale I'm sure but annoying to users.

 I just logged into my WordPress and made a 1 sentence change to a post from
 earlier today to verify, it was about 5 seconds before the post was updated
 and I got a response from the server.

 That with speedtest.net reporting 22 Mbps down and 4.84 up with cloud
 streaming in Zune and no other network traffic active.

 Don't get me wrong, WordPress is great. But it's not anything astounding.
 And it is slow.



 On Wed, Aug 10, 2011 at 5:47 PM, Russ Michaels r...@michaels.me.ukwrote:


 you probably have a lot of errors. You really need to turn on the
 debugging
 and have a look, there are often plugins that conflict with each other or
 are not compatible with current version and as result you can have tons of
 error sin the background.
 You also need to make sure you are using FastCGI on windows to speed
 things
 up.


 On Wed, Aug 10, 2011 at 11:05 PM, Gerald Guido gerald.gu...@gmail.com
 wrote:

 
  As for WP being so much better than BlogCFC and Mango -I'm sure it is.
 
  That depends how you define better. I use both and bog.cfc is way
 faster
  than WP. Page loads with blog.cfc is like flipping channels on the tv.
 
  G!
  On Aug 10, 2011 5:47 PM, Raymond Camden raymondcam...@gmail.com
 wrote:
  
   Hey, we always have room on the BlogCFC team too. ;)
  
   As for WP being so much better than BlogCFC and Mango - I'm sure it
   is. Yet oddly - I've been successfully blogging for years (as have
   hundreds of Mango and BlogCFC users). Maybe I don't know what I'm
   missing, but I'm certainly getting content out there.
  
   On Tue, Aug 9, 2011 at 6:46 PM, Russ Michaels r...@michaels.me.uk
  wrote:
  
   there is hope, if people continue writing plugins for Mangoblog then
 it
   could be the cf equivalent of wordpress, although it does need some
   performance tuning as it is not the fastest app, although very well
  written.
  
   On Tue, Aug 9, 2011 at 10:44 PM, Eric Roberts 
   ow...@threeravensconsulting.com wrote:
  
  
  
 
 

 

~|
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:346669
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: ColdFusion 10 and beyond

2011-08-10 Thread David McGuigan

Very astute observation.


On Wed, Aug 10, 2011 at 8:27 PM, Sean Corfield seancorfi...@gmail.comwrote:


 So you're talking about the hosted Wordpress service rather than installing
 and running Wordpress on your own server...

 On Wed, Aug 10, 2011 at 7:16 PM, David McGuigan davidmcgui...@gmail.com
 wrote:

 
  Nah, WordPress is just slow. Clicking Dashboard takes up to 5 seconds for
  me
  on the hosted version consistently.
 
  And WordPress does seem to do some pretty intelligent ( though slow as
 crap
  ) caching on every change to any of your content, which is worth it to
 them
  and their scale I'm sure but annoying to users.
 
  I just logged into my WordPress and made a 1 sentence change to a post
 from
  earlier today to verify, it was about 5 seconds before the post was
 updated
  and I got a response from the server.
 
  That with speedtest.net reporting 22 Mbps down and 4.84 up with cloud
  streaming in Zune and no other network traffic active.
 
  Don't get me wrong, WordPress is great. But it's not anything astounding.
  And it is slow.
 
 
 
  On Wed, Aug 10, 2011 at 5:47 PM, Russ Michaels r...@michaels.me.uk
  wrote:
 
  
   you probably have a lot of errors. You really need to turn on the
  debugging
   and have a look, there are often plugins that conflict with each other
 or
   are not compatible with current version and as result you can have tons
  of
   error sin the background.
   You also need to make sure you are using FastCGI on windows to speed
  things
   up.
  
  
   On Wed, Aug 10, 2011 at 11:05 PM, Gerald Guido gerald.gu...@gmail.com
   wrote:
  
   
As for WP being so much better than BlogCFC and Mango -I'm sure it
  is.
   
That depends how you define better. I use both and bog.cfc is way
   faster
than WP. Page loads with blog.cfc is like flipping channels on the
 tv.
   
G!
On Aug 10, 2011 5:47 PM, Raymond Camden raymondcam...@gmail.com
   wrote:

 Hey, we always have room on the BlogCFC team too. ;)

 As for WP being so much better than BlogCFC and Mango - I'm sure it
 is. Yet oddly - I've been successfully blogging for years (as have
 hundreds of Mango and BlogCFC users). Maybe I don't know what I'm
 missing, but I'm certainly getting content out there.

 On Tue, Aug 9, 2011 at 6:46 PM, Russ Michaels r...@michaels.me.uk
 
wrote:

 there is hope, if people continue writing plugins for Mangoblog
 then
   it
 could be the cf equivalent of wordpress, although it does need
 some
 performance tuning as it is not the fastest app, although very
 well
written.

 On Tue, Aug 9, 2011 at 10:44 PM, Eric Roberts 
 ow...@threeravensconsulting.com wrote:



   
   
  
  
 
 

 

~|
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:346672
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: ColdFusion 10 and beyond

2011-08-09 Thread David McGuigan

If Adobe did stop development of ColdFusion, they'd either

1. Sell it to a company that wanted it to make it even better and more
popular.

or

2. Release it as open source to the community.


In either case, we win like champions.



On Tue, Aug 9, 2011 at 12:06 PM, andy matthews li...@commadelimited.comwrote:


 How sad is it that the ColdFusion team blog is using WordPress? Why not
 BlogCFC or MangoBlog?



 andy

 -Original Message-
 From: Guust Nieuwenhuis [mailto:i...@lagaffe.be]
 Sent: Tuesday, August 09, 2011 12:51 PM
 To: cf-talk
 Subject: Re: ColdFusion 10 and beyond


 Richard,

 The next version of ColdFusion, code name Zeus is on its way...

 Here are some resources for you about it:
 - Next version of ColdFusion is codenamed Zeus

 http://blogs.adobe.com/coldfusion/2011/06/08/next-version-of-coldfusion-is-c
 odenamed-zeus/
 - ColdFusion X Writeup
 http://www.coldfusionjedi.com/index.cfm/2011/3/3/ColdFusion-X-Writeup
 - ColdFusion 10 - Sneak Peak at RIACON
 http://www.askbenore.com/2011/08/06/coldfusion-10-sneak-peak-at-riacon/

 Make sure you follow ColdFusionBloggers (
 http://www.coldfusionbloggers.org/)
 and you'll be up to date when something new is announced.

 Kind regards,
 Guust


 On 09 Aug 2011, at 19:00, Richard Steele wrote:

 
  I'm concerned that at some point Adobe will pull the plug on CF as free
 PHP continues to grow its user base. I know that there is an open source
 version of CF, but I'm not sure if it has Enterprise features such as the
 ability to create load balanced multiple instances. What's the general
 feeling about this? Should I be concerned?  Is there any work being done on
 ColdFusion 10?
 
 



 

~|
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:346609
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: ColdFusion 10 and beyond

2011-08-09 Thread David McGuigan

I had the opposite experience. Became overjoyed to stick with Adobe CF to
avoid the significant headaches of Railo.


On Tue, Aug 9, 2011 at 3:03 PM, Maureen mamamaur...@gmail.com wrote:


 I'm moving everything to Railo, and loving it.  Wish I had done it a
 year ago, and saved myself some significant headaches.

 On Tue, Aug 9, 2011 at 10:40 AM, Russ Michaels r...@michaels.me.uk
 wrote:
 
  plus even if CF did die, we could all continue on Railo just fine as
 well.
  Sure you may have to workaround a few Adobe specific features and rewrite
  some code, but it could be done.

 

~|
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:346626
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: ColdFusion 10 and beyond

2011-08-09 Thread David McGuigan

But why when Adobe CF is so freaking sweet? I was only checking Railo out
for the performance advantage I'd heard about, but then I stumbled upon a
lil' something called Trusted Cache hee hee.

Also my Railo dabblings were  1 year ago so hopefully installation and set
up has significantly improved so if you haven't already invested the time in
getting savvy and quick with J2EE techs you won't have to and can continue
to live your simple, powerful CFMLesque lifestyle. But I wouldn't be
surprised if they hadn't either.


On Tue, Aug 9, 2011 at 4:44 PM, Bryan Stevenson 
br...@electricedgesystems.com wrote:


 David...Maureenyou should both try OpenBD then ;-)

 On Tue, 2011-08-09 at 15:24 -0600, David McGuigan wrote:

  I had the opposite experience. Became overjoyed to stick with Adobe CF to
  avoid the significant headaches of Railo.
 
 
  On Tue, Aug 9, 2011 at 3:03 PM, Maureen mamamaur...@gmail.com wrote:
 
  
   I'm moving everything to Railo, and loving it.  Wish I had done it a
   year ago, and saved myself some significant headaches.
  
   On Tue, Aug 9, 2011 at 10:40 AM, Russ Michaels r...@michaels.me.uk
   wrote:
   
plus even if CF did die, we could all continue on Railo just fine as
   well.
Sure you may have to workaround a few Adobe specific features and
 rewrite
some code, but it could be done.
  
  
 
 

 

~|
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:346629
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: NCDevCon

2011-08-09 Thread David McGuigan

Oh man, didn't know about this conference or I would've attended. Cheapest
flights are in the $400 range at this point. Next year.


On Tue, Aug 9, 2011 at 1:26 PM, Raymond Camden raymondcam...@gmail.comwrote:


 Forgive the slightly commercial note, but please consider going to
 NCDevCon this September. Adobe is sponsoring it and will be doing 5
 sessions. We will also have Rakshith, the new CF PM, doing the
 keynote. I've got two sessions myself and the price is a pretty cheap
 60 bucks. Details may be found here:

 http://ncdevcon.com/

 This will be my first public presentation as an official evangelist,
 so you should attend at minimum just to laugh at how nervous I get.
 See you there!

 --
 ===
 Raymond Camden, Adobe Developer Evangelist

 Email : raymondcam...@gmail.com
 Blog : www.coldfusionjedi.com
 Twitter: cfjedimaster

 

~|
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:346637
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Its ColdFusion's Fault

2011-07-26 Thread David McGuigan

It's.

On Tue, Jul 26, 2011 at 3:41 AM, Kevin Parker tras...@internode.on.netwrote:


 May be of interest for some readers... ColdFusion is responsible for the
 demise of MySpace (well one of the reasons anyway ;-)


 http://blogs.forbes.com/stephenwunker/2011/07/25/4-morals-from-myspaces-fall
 /


 ++
 Kevin Parker
 Advanced Imaging

 e: webmas...@advancedimaging.com.au
 w: www.advancedimaging.com.au
 m: 0418 815 527

 ++

 http://au.linkedin.com/in/krparker



 

~|
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:346342
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Adobe Solution?

2011-07-13 Thread David McGuigan

I would just convince him that it should be web based and that it's
absolutely silly to go in any other direction, and that you can do the
entire project in ColdFusion in about 14 seconds because ColdFusion can do
anything on Earth.


On Wed, Jul 13, 2011 at 1:13 PM, Scott Spurlock spurlock.sc...@yahoo.comwrote:


 I apologize in advance since this isn't a CF question, but I'm desperate
 and hoping this is at least an Adobe question.  A client of mine wants to
 create a form for users to fill out electronically.  He then wants to take
 their responses (attached via email) and upload the data to an Access 2007
 database.  He absolutely does not want this to be web-based.  He ideally
 wanted me to create an interactive form in PDF.  I thought, Sure, no
 problem.  The problems I'm running into?  Importing PDF data into Access
 appears to involve an extra step (converting the PDF to text or XML or
 Excel) which he/the client would have to do (since he's the one getting the
 returned forms).  Worse is that he wants some multi-select drop-down lists
 in the form and I'm not seeing a way to do this in a PDF (I've played around
 with both Acrobat Pro and LiveCycle Designer).  And without VBA skills I
 don't have, I'm not even seeing how to do this in an Excel or Word
  form.  I'm getting stuck and turn to you kind sirs for your advice.  How
 would you do this?


 Tha

 

~|
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:346214
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Adobe Solution?

2011-07-13 Thread David McGuigan

I think you can submit PDF forms to ColdFusion backends in any case (
http://coldfusion.sys-con.com/node/101381 ).

That'd let you feed it into Access in .014 seconds.

You could do the multiselect as checkboxes if there's really no other way I
think.

The end.




On Wed, Jul 13, 2011 at 1:13 PM, Scott Spurlock spurlock.sc...@yahoo.comwrote:


 I apologize in advance since this isn't a CF question, but I'm desperate
 and hoping this is at least an Adobe question.  A client of mine wants to
 create a form for users to fill out electronically.  He then wants to take
 their responses (attached via email) and upload the data to an Access 2007
 database.  He absolutely does not want this to be web-based.  He ideally
 wanted me to create an interactive form in PDF.  I thought, Sure, no
 problem.  The problems I'm running into?  Importing PDF data into Access
 appears to involve an extra step (converting the PDF to text or XML or
 Excel) which he/the client would have to do (since he's the one getting the
 returned forms).  Worse is that he wants some multi-select drop-down lists
 in the form and I'm not seeing a way to do this in a PDF (I've played around
 with both Acrobat Pro and LiveCycle Designer).  And without VBA skills I
 don't have, I'm not even seeing how to do this in an Excel or Word
  form.  I'm getting stuck and turn to you kind sirs for your advice.  How
 would you do this?


 Tha

 

~|
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:346217
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Total Execution Time

2011-07-12 Thread David McGuigan

0.001 ms

On Tue, Jul 12, 2011 at 11:34 AM, Mark A. Kruger mkru...@cfwebtools.comwrote:


 Depends on the site and application is it data mining? Ecommerce?
 Public? Intranet?

 A public site designed for marketing and/or sales should target 50 to
 150ms. there may be pages that should be considered separately from
 your average - like the shopping cart page that sends transactions to your
 gateway for example - it might naturally take 300 or 400 miliseconds
 because
 it has to wait for a response. But internal applications might have a much
 higher threshold before you have to worry too much.

 -mark


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


 -Original Message-
 From: Torrent Girl [mailto:moniqueb...@gmail.com]
 Sent: Tuesday, July 12, 2011 11:06 AM
 To: cf-talk
 Subject: Total Execution Time


 What is a good total execution time to aim for in Coldfusion? Is there a
 standard benchmark?

 Thank you.



 

~|
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:346195
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Total Execution Time

2011-07-12 Thread David McGuigan

Turn on ColdFusion 9's trusted cache. That'll win.


On Tue, Jul 12, 2011 at 12:47 PM, Mark A. Kruger mkru...@cfwebtools.comwrote:


 Remember that the first run of a CF page compiles the page to java byte
 code. For comparison you should only be testing subsequent loads of the
 page
 (after the compile). It's also useful to explain that compiling process to
 the user. :)

 -mark


 -Original Message-
 From: Wil Genovese [mailto:jugg...@trunkful.com]
 Sent: Tuesday, July 12, 2011 1:02 PM
 To: cf-talk
 Subject: Re: Total Execution Time


 Well, converting a site from one platform to another may not be very
 comparable.  At least not until the final product is done and optimized.
 There are a lot of factors to execution times including many factors
 outside
 of ColdFusion. Database, OS, JVM Tuning, firewall(s), proxies, IIS/Apache
 and so on.





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

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

 On Jul 12, 2011, at 12:54 PM, Torrent Girl wrote:

 
  What is a good total execution time to aim for in Coldfusion? Is there
  a standard benchmark?
 
  Thank you.
 
 
  Thanks All. I am converting ASP code to CF 9 and have someone comparing
 the page load results to the ASP server and they are supposedly getting
 faster times on the ASP server.
 
  I told her that I develop my pages within a certain benchmark (the pages
 she tested have a 45 MS total execution time) and I am not understanding
 why
 we are comparing the CF and ASP servers.
 
  Would any of you recommend this? It doesn't make sense to me.
 
 



 

~|
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:346200
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: CFDirectory on mapped drives

2011-07-12 Thread David McGuigan

Thanks Dave!

I'll try that out tonight.

The ISAPI extensions used by CF... If I used the web connector to tie CF to
IIS do you perchance know where those might be? Just now switching over from
Apache and kind of blind on stuff like this.


On Tue, Jul 12, 2011 at 4:50 PM, Dave Watts dwa...@figleaf.com wrote:


  If it's a totally dedicated box and we only have 1 developer's code
 running,
  is it still a security risk?

 Yes, absolutely.

  I tried running it as a limited account and even set full permissions on
 every file in the
  webroot but still got an immediate IIS 500 error until I flipped it to
 either the local system
  account or an admin.

 You must also set read/execute permissions on the directory containing
 the CF install and the directory containing the ISAPI extensions used
 by CF.

 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:346207
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


CFDirectory on mapped drives

2011-07-11 Thread David McGuigan

I've triple checked that an empty folder on a 2nd server in the same
datacenter allows full write permissions for any type of user, and have it
mapped from the CF server. But when I run cfdirectory calls, for lists it
returns an empty query even if there are subfolders or files there, for
rename calls it claims that the target subfolder doesn't exist, and for
create calls it simply errors: the specified directory could not be created.

Is there some best practice way to set this up with CF? Do I have to
configure the windows service of the CF box to run as an identical user to
one on the recipient box? If so other than making sure it's an administrator
is there anything else I need to do?

Thanks guys.


~|
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:346178
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: CFDirectory on mapped drives

2011-07-11 Thread David McGuigan

Thanks Russ.

I'm not sure what you wanted me to see in that link, maybe the fact that you
can have multiple admin logins now?

If it's a totally dedicated box and we only have 1 developer's code running,
is it still a security risk? I tried running it as a limited account and
even set full permissions on every file in the webroot but still got an
immediate IIS 500 error until I flipped it to either the local system
account or an admin.

Thanks!
David


On Mon, Jul 11, 2011 at 11:17 AM, Russ Michaels r...@michaels.me.uk wrote:


 sorry I didn't read all of your post, I see your final paragraph asking if
 you must do this, and the answer is yes.
 however do not run CF as an administrator as this will open up your
 security
 and allow every cfm page to run with administrator access, you need to run
 it as a limited user that can only do what you need it to do.

 see this security white paper


 http://www.adobe.com/products/coldfusion/pdfs/coldfusion_8_product_security_brief.pdf

 Russ

 On Mon, Jul 11, 2011 at 6:11 PM, Russ Michaels r...@michaels.me.uk
 wrote:

 
  If you are just using the default installation and running cf as system
  then you will have problems access network paths.
  You need to set CF to run under a user account that have network access.
 
  Russ
 
 
  On Mon, Jul 11, 2011 at 5:40 PM, David McGuigan davidmcgui...@gmail.com
 wrote:
 
 
  I've triple checked that an empty folder on a 2nd server in the same
  datacenter allows full write permissions for any type of user, and have
 it
  mapped from the CF server. But when I run cfdirectory calls, for lists
 it
  returns an empty query even if there are subfolders or files there, for
  rename calls it claims that the target subfolder doesn't exist, and for
  create calls it simply errors: the specified directory could not be
  created.
 
  Is there some best practice way to set this up with CF? Do I have to
  configure the windows service of the CF box to run as an identical user
 to
  one on the recipient box? If so other than making sure it's an
  administrator
  is there anything else I need to do?
 
  Thanks guys.
 
 
 

 

~|
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:346186
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: SOT: most important CFML framework

2010-05-16 Thread David McGuigan

It's the total number of people who have ever heard of them.



On Sun, May 16, 2010 at 11:04 AM, Carey Duryea ca...@keepingitgreen.netwrote:


 So I thought I'd revisit this three months later (SEE OP for context):
 
 Integers are number of explicit hits on indeed.com:
 
 - Framework - 11/16 hits - 2/21 hits - 5/16 hits
 - FuseBox - 76 - 130 - 161
 - Mach-ii - 72 - 42 - 51
 - Model-Glue - 61 - 27 - 38
 - ColdBox - 13 - 5 - 38
 - CFWheels - 0 - 0 - 4
 - OnTap - 0 - 0 - 0
 - FW1 - ? - ? - 1
 
 - All CF - ? - ? - 3523
 





 i don't understand what these numbers represent???  anyone for a
 simiplified explanation?  dos this have something to do with the popularity
 of these frameworks?

 
 
 

 

~|
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:333731
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: ColdFusion memory leaks

2010-05-14 Thread David McGuigan

Ironically, I'd double-check to make sure that you have the built in CF
server monitor turned off. It can bring a production server to its knees,
and we had a ton of crashing and burning that we couldn't figure out until
we finally discovered that someone had turned the server monitor on by
mistake.




On Fri, May 14, 2010 at 3:24 PM, Qing Xia txiasum...@gmail.com wrote:


 Hi,

 I am new to ColdFusion server monitoring, so I am trying to get some ideas
 here to get me move in the right direction.

 We have a situation where our production ColdFusion applications are using
 more and more memory until they bring the server to a halt. I was informed
 (I am new here) that our systems administrator actually wrote a batch
 script
 to automatically restart the ColdFusion server every Sunday morning to
 avoid
 this very problem. Despite this, the memory leaks still make it necessary
 to
 manually restart the ColdFusion server from time to time (could be every
 couple of weeks).

 CF8 comes with pretty decent server monitoring tools including memory
 monitoring but I dare not run it in production since it is such a memory
 monster. Without purchasing other monitoring software like SeeFusion or
 BlueDragon, what are my options here? I see that there is an option in
 CFAdmin to periodically recycle JVM memory once it reaches a threshold, but
 I am a little too concerned to use it--it is not really like fixing the
 problem.

 Any idea will be most appreciated!

 Thanks,

 Qing Xia


 

~|
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:333711
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: New CF security bulletin

2010-05-11 Thread David McGuigan

Man it would've been nice if the ER to make this all automatic had gone
through right now.



On Tue, May 11, 2010 at 1:47 PM, Dave Watts dwa...@figleaf.com wrote:


 http://www.adobe.com/support/security/bulletins/apsb10-11.html

 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:333589
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 David McGuigan

Thanks a milly.


On Thu, May 6, 2010 at 10:43 PM, Andrew Scott andr...@andyscott.id.auwrote:


 The book is title Pragmatic Version Control - Using Subversion 2nd Edition.
 It might be updated by now as that was published in 2006.


 On Fri, May 7, 2010 at 7:22 AM, David McGuigan davidmcgui...@gmail.com
 wrote:

 
  Please do post the book title. 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:333478
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-06 Thread David McGuigan

I'd also be interested to know of this paradise.


On Thu, May 6, 2010 at 3:16 PM, Andrew Scott andr...@andyscott.id.auwrote:


 Not having used Git how is it paradise?


 -Original Message-
 From: Brian Kotek [mailto:brian...@gmail.com]
 Sent: Friday, 7 May 2010 6:08 AM
 To: cf-talk
 Subject: Re: How are other developers handling big SVN repositories?


 Probably won't help right now, but for future reference, Git's branching
 and
 merging is like paradise compared to SVN. Might be worth thinking about
 trying on a future project.

 Brian



 

~|
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:333448
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-06 Thread David McGuigan

Please do post the book title. Thanks!


On Thu, May 6, 2010 at 3:13 PM, Andrew Scott andr...@andyscott.id.auwrote:


 No, this is not the best solution. It is the worst solution.

 All developers should be working in the trunk, when they finish their side
 project they then commit/merge that into the trunk. When you are ready to
 test/qa/release then you branch it off so it becomes the snapshot of what
 will be released.

 Any bugs that are found that need fixing during this phase, should then be
 committed to that branch and then merged back into the trunk.

 Once the QA/Test phase is ready for release you then tag this branch, and
 delete the branch.

 There is a very good book out there, if you want when I get to work I'll
 post the name of it and it describes this process in greater detail.



 -Original Message-
 From: Jeff Gladnick [mailto:jeff.gladn...@gmail.com]
 Sent: Friday, 7 May 2010 2:35 AM
 To: cf-talk
 Subject: How are other developers handling big SVN repositories?


 We have about 8 or 9 engineers and QA people working on a big cf
 application, all stored in SVN.  The way we currently handle source control
 is at the outset of each mini-project, then one or two developers will
 branch the svn and work on that until they're done, then QA will merge the
 changes back into the trunk.

 The problem has become, we now have like 30+ branches, about 8 of which are
 used regularly, and QA is getting into merge hell.

 SoHow do other developers handle svn with large projects and multiple
 people?



 

~|
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:333449
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Adobe ColdFusion Anthology released

2010-05-05 Thread David McGuigan

Oops.

Chapter 2 lists onApplicationStart as onApplicationStar ( unless that's a
new application event in CF9 that's not in the docs ), but more importantly
has an arrow pointing from Requested template missing to onError, when
in reality onMissingTemplate is what happens first. Which isn't listed in
the diagram at all.

And really, there should be a big set of brackets wrapping all of the
appropriate events off to the left side pointing to the onError event, I
say.




On Wed, May 5, 2010 at 12:27 PM, Judith Dinowitz jdino...@houseoffusion.com
 wrote:


 I also would have liked to include an article on CFWheels and one on
 ColdBox, but as Sean noted, we didn't have any articles on those topics.
 Right now I'm talking to one of our authors about doing a CFWheels article,
 and I'd welcome a ColdBox article as well. If you would like to write one,
 just send an email to me (http://www.fusionauthority.com/contact.cfm).
 Maybe we can get those frameworks into future editions.

 Thanks so much for all of the good wishes. I'm proud of the book (and happy
 to see it out there.) A lot of people -- authors, technical reviewers and
 editors -- put a lot of effort into it across the board, and we thank them
 all in the acknowledgments and author's pages in the book itself (which you
 can read in the Amazon.com link).

 Judith

  On Tue, May 4, 2010 at 6:29 PM, David McGuigan davidmcgui...@gmail.
  com wrote:
   I was really disappointed to see that the two frameworks with the
  most momentum ( impression ) and that I'm most excited to learn about
  aren't covered in the book ( ColdBox and CFWheels ), while a few less
  relevant topics are ( Reactor, CFPresentation, CFEclipse ).
 
  I guess no one has written articles on those frameworks for the
  Fusion
  Authority folks.
 
  I remember years ago that some people complained that macromedia.com
  had no Fusebox content back in the day when that was your only
  choice for CFML frameworks. We put out a big request for Fusebox
  articles everywhere we could and got...
 
  Just one solitary article (from Kay Smoljak).
 
  So the macromedia.com representation of Fusebox was due to the
  Fusebox
  community not actually providing any.
 
  If the ColdBox and cfWheels folks want their frameworks to be
  represented, they need to write articles :)
  --
  Sean A Corfield -- (904) 302-SEAN


 

~|
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:71
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Adobe ColdFusion Anthology released

2010-05-04 Thread David McGuigan

Bought this book yesterday and so far have read a few random chapters ( nice 
Ant tutorial! ).

I was really disappointed to see that the two frameworks with the most momentum 
( impression ) and that I'm most excited to learn about aren't covered in the 
book ( ColdBox and CFWheels ), while a few less relevant topics are ( Reactor, 
CFPresentation, CFEclipse ).

Any thoughts on this? Was it just because that was the material available? 
Anyway,  very excited for this read!





 That looks like a great ColdFusion book. Nice work guys!

As one of the technical reviewers (and contributing authors), I can
definitely say that it was a lot of work! I'm very glad to see it out
in the wild now!
-- 
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-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:41
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Stung by HostMySite price increase?

2009-09-06 Thread David McGuigan

Oh you're totally right, I obviously had it misconfigured. I must've not
even thought to research and implement strategic configuration of the MySQL
instance itself. Man I wish I had thought of that in the enormous amount of
research and testing we had to do. It sounds like such a simple, obvious
place to start. Oh wait, that was one of the things we spent the most time
on.
Or no maybe you were right the second time. It had to do with my attitude.
MySQL was particularly bad at certain types of queries because for some
reason, that's what I believed in my heart that it would be. I guess maybe
the purple dolphin logo triggered some kind of subliminal prejudice in my
mind and that's what's been holding MySQL back. Hold on I'm going to go say
a little prayer and then run them again. I'm sure that'll fix it. Thanks
buddy!
We iterated through a kaleidoscope of configuration strategies and were on
more than ample hardware ( 2 xeon quads, 16GB ram, a RAID 5 of 15k drives )
but even the ones that should've been ideal on paper, though they did
improver performance quite a bit compared to other configurations, could not
exempt MySQL from the fact that it is very bad at certain things.



On Sun, Sep 6, 2009 at 11:14 AM, denstar valliants...@gmail.com wrote:


 For Oracle and other non-free vendors, there is a benchmark:

 http://www.tpc.org/

 FWIW, David obviously had MySQL mis-configured.  :)

 Or else maybe he didn't *believe* it would work very well, and thus, it
 didn't.

 And FWIW*2, there are a couple open source versions of CF now.

 The best reason for using MS SQL is that you're an MS shop, and have
 tons of licenses for everything, don't mind the $$$ per processor, per
 user, etc., etc..

 I prefer freedom, personally.

 --
 There are admirable potentialities in every human being. Believe in
 your strength and your youth. Learn to repeat endlessly to yourself,
 'It all depends on me.'
Andre Gide

 On Sat, Sep 5, 2009 at 7:49 AM, James Holmes wrote:
 
  We use Oracle instead of SQL Server for the same reason :-)
 
  mxAjax / CFAjax docs and other useful articles:
  http://www.bifrost.com.au/blog/
 
  2009/9/5 David McGuigan :
 Now I kind of see SQL Server the same way I see ColdFusion. You pay for
 it
  because it's better.

 

~|
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:326057
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Stung by HostMySite price increase?

2009-09-06 Thread David McGuigan

I'm not against open source in any way shape or form! SOME of it is
fantastic. But that doesn't mean I think that all open source products are
great or even decent. Honestly it seems like a lot of them are pretty
fruitless, and more the personal hobbies and indulgences of the developers
than useful bits of software ( read: a few of my own open source projects
that luckily never even went public ; ). MySQL obviously not included.
I adopted Firefox literally the moment I discovered tabbed browsing back
before IE had it and when any product ( open source or otherwise ) is good
enough, I evangelize it like a Jehova's Witness ( that's a compliment, it's
pretty impressive that they hit the streets on Saturdays just to spread some
church ).

Like I said, I've loved and used MySQL for years, and am only now unlocking
its deep, dirty secrets. Clearly, it can do plenty of things very well or
well enough. So it's great ( or fine ) for a lot of projects / operations.
Unfortunately, for the stuff I was doing, it really really struggled ( and
was obliterated in comparative performance by SQL Server 2008 ).
Unfortunately ( sorry Judah ), I can't go very deeply into the explicit
details of what MySQL was struggling with because our implementation is
pretty tightly bound to some closed-sourcey commercial / intellectual
property even at the database level.

I can say that generally speaking some general issues that MySQL exhibited
were the inability to correctly determine its own best execution plans,
leverage precisely-defined indexes even when explicitly directed to with
SQL-level overrides, correctly negotiate certain types of subqueries and not
do more work than it needed to ( which was pretty ridiculous, at one point
we were using ColdFusion to mitigate MySQL's own self-inflicted overload by
feeding simulated subquery results to other queries as parameters by
relaying the results to and from CF ), and reliably join to the same table(
s ) multiple times against different subsets of its data to create highly
dynamic temporary composites. Its raw view performance was also pretty weak
at a real scale. Another thing to mention ( since you mention the storage
engine implementation in MySQL ) is that the issues we had were almost
exclusively with the InnoDB storage engine ( the most popular transactional
engine with support for foreign key cascades ), and we used a design that
was very driven by automated referential integrity with foreign and
composite keys, which some people see as a more contemporary, cutting-edgey
approach. After our complete re-architecture ( which now relies on
application-server management of most of the things we tried to let MySQL
handle automatically ) and a mostly MyISAM table design, MySQL is performing
much, much better.




On Sun, Sep 6, 2009 at 3:17 PM, Jochem van Dieten joch...@gmail.com wrote:


 On Sat, Sep 5, 2009 at 1:40 PM, David McGuigan wrote:
  Companies use open source ( and free ) software for a variety of
 reasons.
  Usually out of either stubbornness or a genetic allergy to Microsoft.

  Most of the other Google apps though have seemed really slow to me ( and
  been down completely more times than I can count on one hand ). I use
 Gmail,
  Calendar, their Spreadsheet/Docs, IM, etc. And the only app I've ever
 really
  been impressed with of theirs is Chrome ( which is my favorite browser ).

 You use Chrome? So are you stubborn or allergic?

 Jochem


 --
 Jochem van Dieten
 http://jochem.vandieten.net/

 

~|
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:326061
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Stung by HostMySite price increase?

2009-09-05 Thread David McGuigan

.16 seconds in 2009 is the equivalent of ~20 minutes in 1990's time. I'm
kind of kidding.
But are we sure that Google's search ( which is probably its best performing
software ) uses MySQL anyway? I thought it used BigTable or whatev (
http://labs.google.com/papers/bigtable.html )

Most of the other Google apps though have seemed really slow to me ( and
been down completely more times than I can count on one hand ). I use Gmail,
Calendar, their Spreadsheet/Docs, IM, etc. And the only app I've ever really
been impressed with of theirs is Chrome ( which is my favorite browser ).
I actually really like SQLYog ( save the logo ) and use it in combination
with Navicat and MySQL Query Browser ( each one does a few things well,
other things horribly, so I alternate for specific tasks ).
But once you get into some less-common, complex-ier shiz it struggles pretty
badly. Trying to edit compound views derived from composite alphanumeric
keys was a total fail for example. The SQL it generated under the hood (
which you can inspect in the history tab, a feature I love ), was totally
wrong and would error if I was lucky ( and if not just execute incorrect
operations against the d.b. ).

But anyway, just as a quick anecdote. In the last few months I have been
able to repeatedly, accidentally drop MySQL to its knees with what I'd
consider to be basic ( though highly dynamic ), clean, structurally sound
database designs and not-that-fancy querying. Even taking a scalpel and
microscope and patching every gap with highly designed indexes and
directives to MySQL to use them on even an SQL level couldn't make it do
what it should and perform even acceptably in certain cases.

Popping the exact same tables, data, and SQL into an SQL Server 2008
instance? Instantly, from the very first execution took operations that were
taking 15-120 full seconds to execute down to  5 MILLISECONDS. WITHOUT EVEN
ADDING ONE MANUAL INDEX AT ALL. That knocked my socks off, and was how I
would've expected any modern database system to perform with what I was
doing before the MySQL struggle.

Granted, there are some things MySQL does plenty well, but scattered all
around the feature set are bugs and land mines waiting to go off in your
application or development that may or may not affect you depending on what
your application does. And you either need the luxury of an infinite amount
of time to throw rocks and try to discover and pick off all of the triggers,
or to hire a bomb expert last minute ( which I would bet money that most of
the high-scale companies that went with MySQL end up doing, which is how it
makes its money ) to come in and fix everything and divvy you the hacks and
secrets at the rate of 8 million dollars per minute of support.

Up until I started developing an application that needed to support
thousands of concurrent users with real, instajax performance I'd loved
MySQL and never seen any reason to even check out other options. It was
free, the IDEs worked well enough, and it seemed pretty popular. But when I
did. And development came to a standstill... And I found myself doing more
scavenger hunting, experimentation, and research than coding... just to make
the software perform its sole function acceptably... everything changed.
What a waste of my time.

Now I kind of see SQL Server the same way I see ColdFusion. You pay for it
because it's better. It saves you time. It lets you focus on what you should
be focusing on and producing great applications. Total ROI.

This whole thread has actually gotten me kind of excited to move to SQL
Server. So thanks Billy!

PS Gerald I think we should write our congressman and get America to adopt a
new standard unit of measurement of time. I would much rather measure
everything in blips than seconds.




On Fri, Sep 4, 2009 at 9:30 PM, Gerald Guido gerald.gu...@gmail.com wrote:


 
  Out of the companies you listed, I've only ever used Facebook, Flickr,
  Google, eBay, iStockPhoto, Ticketmaster, and Yahoo.
 
  I'm not saying this is a litmus test, but with the exception of maybe
 Yahoo
  ( but I haven't really used Yahoo THAT much ), I have always consciously
  THOUGHT as I used every single one of those other sites that their
  performance was pretty lackluster.



 Searching for the letter a on google.

 Results *1* - *100* of about *17,790,000,000* for *a*. (*0.16* seconds) 

 But yeah That isn't a MySLQ query. Gmail can be sluggish but I think it
 is more of a JS engine issue more than anything else.


 Better IDE and tools ( the MySQL enterprise tools, at least the ones I've
  used, are all but a joke ).
 
 
 The MySQL software bundle is pretty crappy. I stopped using them years ago.
 I was never able to get the migration tools to work right.

 However, SQLyog, Toad for MySQL and the EMS tools rock IMHO.

  a genetic allergy to Microsoft.

 Now that is funny.

 But yeah, I moved to MySQL cuz it was free and I was a freelancer at the
 time. $5k is a lot of beer and donuts.

 But at 

Re: Stung by HostMySite price increase?

2009-09-04 Thread David McGuigan

This link: http://www.microsoft.com/sqlserver/2008/en/us/pricing.aspx
http://www.microsoft.com/sqlserver/2008/en/us/pricing.aspxMentions a Web
edition for $15 per month ( per processor, not core I believe ),
specifically targeted at web apps deployment.

If you end up exploring that and find out that the licensing is just as
simple as that please let us know. I've been repeatedly disappointed with
MySQL and would love to migrate. Thanks.



On Fri, Sep 4, 2009 at 10:06 AM, Mark Kruger mkru...@cfwebtools.com wrote:


 Yes the proc license is really the only way to go... The difficulty in
 switching depends greatly on your code. IT could be quite easy - or require
 rewriting every query.

 I recently helped a customer go from MySQL to MSSQL and I wrote a couple of
 posts on it. It will give you an idea of the type of difficulty you might
 encounter.

 http://www.coldfusionmuse.com/index.cfm/2009/7/13/MySQL.to.MSSQL


 http://www.coldfusionmuse.com/index.cfm/2009/7/23/data.truncation.mysql.to.m
 ssql

 Hope this helps (a little)


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

 -Original Message-
 From: Billy Cox [mailto:bi...@oldworldspices.com]
 Sent: Friday, September 04, 2009 10:18 AM
 To: cf-talk
 Subject: Stung by HostMySite price increase?


 We recently got a note from HostMySite (now Hosting.com) telling us about a
 big price increase in SQL Server licensing. We've had a dedicated server
 with HMS for about a year and the mere thought of shopping for a new
 hosting
 provider makes me feel tired.

 Has anyone else encountered this?

 We have considered purchasing our own SQL Server licensing and I am
 wondering (predictably) whether a processor license is the only way to go
 for a web app database.

 How hard is it to switch from SQL Server to MySQL?

 --
 *Billy Cox*
 IT Manager
 *Old World Spices*
 bi...@oldworldspices.com
 816.861.0400 x138





 

~|
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:326001
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Stung by HostMySite price increase?

2009-09-04 Thread David McGuigan

There are about 1,000 reasons I can think of, but I only have limited
experience with SQL Server ( just enough to observe these differences ):
Less administration and maintenance.
Less tuning necessary for pureformance.
Exponentially superior performance out of the box.
A single, superhero storage engine ( which itself has about 1,000 other
benefits IMO ).
Way more stable.
Better IDE and tools ( the MySQL enterprise tools, at least the ones I've
used, are all but a joke ).
Significantly lower total cost of ownership for teams and companies without
expert MySQL in-house knowledge that know how to solve all of MySQL's
shortcomings without investing a lot of time in research and scavenger
hunting ).

Companies use open source ( and free ) software for a variety of reasons.
Usually out of either stubbornness or a genetic allergy to Microsoft.

Out of the companies you listed, I've only ever used Facebook, Flickr,
Google, eBay, iStockPhoto, Ticketmaster, and Yahoo.

I'm not saying this is a litmus test, but with the exception of maybe Yahoo
( but I haven't really used Yahoo THAT much ), I have always consciously
THOUGHT as I used every single one of those other sites that their
performance was pretty lackluster. Obviously we can only speculate as to
what their bottlenecks are/were, how much a factor their scale actually is,
etc, but I have felt, and noticed myself feeling, very disappointed with
their software performance. Clearly MySQL is to blame ( kidding ).




On Fri, Sep 4, 2009 at 7:48 PM, Andrew Grosset rushg...@yahoo.com wrote:


 Yes the proc license is really the only way to go... The difficulty in
 switching depends greatly on your code. IT could be quite easy - or
 require
 rewriting every query.
 
 I recently helped a customer go from MySQL to MSSQL and I wrote a couple
 of
 posts on it. It will give you an idea of the type of difficulty you might
 encounter.
 
 http://www.coldfusionmuse.com/index.cfm/2009/7/13/MySQL.to.MSSQL
 
 
 http://www.coldfusionmuse.com/index.cfm/2009/7/23/data.truncation.mysql.to.m
 ssql
 
 I recently helped a customer go from MySQL to MSSQL and I wrote a couple
 of
 posts on it. It will give you an idea of the type of difficulty you might
 encounter.
 

 curious as to why anyone would want to switch from MySQL to MSSQL..

 a quick look at mysql.com/customers showed the following:

 facebook
 feedster
 flickr
 fotolog

 and that was just in f

 also found craigslist, ebay, Google, istockphoto, ticketmaster, webtrends,
 yahoo and the list goes on and on...

 I found the switch fairly easy, definitely worth a look as its free to
 download.


 

~|
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:326027
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: access dynamic structure value

2009-09-01 Thread David McGuigan

#currentRecord[ item_name#cartEntry# ]#
You don't even need to assign it to currentEntry.



On Tue, Sep 1, 2009 at 6:15 PM, Matthew Smith chedders...@gmail.com wrote:


 I am trying to do this, referencing the currentrecord structure:
 cfloop from=1 to=#currentrecord.NUM_CART_ITEMS# index=cartentry
cfset currententry = currentrecord.ITEM_NAME#cartentry#
#currententry#br
 /cfloop

 what is the syntax?

 

~|
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:325916
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Enabling debug outout without access to administrator?

2009-08-30 Thread David McGuigan

If you have the admin credentials but not mapped access to the administrator
you can use the Admin API (
http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=basiconfig_37.html
)
to modify the debugging IPs and settings.
But if not the real solution is to contact whoever's server you're using and
have them enable your IP.

P.S. It's a lot more fun to develop on developer edition off of your
workstation and do your debugging that way.



On Sun, Aug 30, 2009 at 10:47 AM, Pete Ruckelshaus
pruckelsh...@gmail.comwrote:


 I'm having some difficulty with some code that's on a web host's servers.
  Accessing the CF Administrator to enable debug output isn't an option.  Is
 there any way of enabling debug output for a single remote IP address
 without having access to CF administrator?
 Thanks,

 Pete


 

~|
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:325863
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: ColdFusion Builder - free or commercial product?

2009-08-25 Thread David McGuigan

I'd heard that a set number of Builder licenses came with every server
license, obviously proportional to the price of the edition. That makes a
lot of sense. And then shared-host-only developers would need to purchase
their own IDE license, etc.



On Tue, Aug 25, 2009 at 1:53 AM, Will Swain w...@hothorse.com wrote:


 I'd be very surprised if it's free. I suppose it might be bundled with CF9.

 I'm guessing a couple of hundred dollars personally.

 -Original Message-
 From: Pete Ruckelshaus [mailto:pruckelsh...@gmail.com]
 Sent: 25 August 2009 04:34
 To: cf-talk
 Subject: ColdFusion Builder - free or commercial product?


 I've been using ColdFusion Builder and am more or less happy with it (any
 unhappiness stems from Eclipse quirks and limitations), but I have a
 question: Once it's out of beta, will CF Builder be a commercial product
 that will need to be purchased, or will it be available for free?
 Thanks

 Pete




 

~|
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:325686
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: hardaware question for cf local server

2009-08-23 Thread David McGuigan

Unfortunately, I think the Atom is probably the least-well-suited to running
serverware processor there is. You may also struggle to find Server 2003
drivers for it.
You might have better luck with a dirt cheap consumer desktop. I would check
out dell.com/outlet, you can get super cheap desktops fully capable of
running all of your serverware for development purposes ( with significantly
better performance ) for netbook price range. And they come with full
warrantees.

There's a 2.33 Ghz Core 2 Quad w/ 8 GB of RAM for $435, a Core 2 2.8 Ghz w/
6GB for $350, or a
2.7 Ghz AMD Athlon w/ 4GB for $300 right now, for example, all with large
7200 RPM HDs.

Dell's outlet is where I've gotten most of my dev servers over the years and
I've been more than happy. They also don't charge a restocking fee if you
buy one and find out it can't do what you want it to. My 2 cents.

They also offer coupons every other week to cut 10-25% off of the purchase
price. Here's the one I used to find those prices I listed:
http://www.xpbargains.com/index.php/send_deal/116189

Good luck.




On Sun, Aug 23, 2009 at 10:25 AM, Stephane Vantroyen s...@emakina.comwrote:


 Well, I meant, i don't know what it is capable of; the processor is a Intel
 Atom Dual Core 330 2 Go (1,6 GHz, DDR2 800 - PC2-6400). I'd say it will
 suit, but wanted to be sure of it before buying it (really cheap, not the
 problem, but not interessant if doesn't work at all with windows server 2003
 and CF)



 I don't know the processor and its capabilities
 
 This is too bad, because I would say that the performance will mostly
 depend on the speed
 of the processor, and the amount of RAM it has.

 

~|
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:325619
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Macromedia Dreamweaver Tab Key

2009-08-18 Thread David McGuigan

Vidya:
After you pull up the find and replace panel, you're going to want to copy
and paste a tab from your source code into the find pane. If you hit the tab
key from within it it'll just transfer the focus to the replace pane. To
replace the code in all of your files in the application change the Find in
dropdown to folder and browse to the root in your application before
processing the replace ( by clicking replace all ).

Azadi:
Don't be an ass. Dreamweaver is one of the primarily used ColdFusion-capable
IDEs on the market.

2. Making an itemized list, some of the items of which are ornery, baseless
chastisements of someone asking a perfectly legitimate question on a mailing
list meant to answer users' questions, makes you a stone cold DBA ( douche
bag alert ). I guess go ahead and try to change yourself pretty quickly,
thanks bud.



On Tue, Aug 18, 2009 at 10:54 AM, Azadi Saryev az...@sabai-dee.com wrote:


 1) this is a ColdFusion list, not Dreamweaver list
 2) you didn't even say which OS you are running DW on - the
 shortcuts/keys are OS-specific
 3) in DW CS4 on Windows (and iirc the same in earlier Win versions):
 a) press Ctrl+F to open Find/Replace dialog, select where to search
 (Find in), click inside Find textbox and press Ctrl+Tab, click Find
 All button
 b) press Ctrl+U to bring up Preferences dialog, click Code Format in
 the left-side list, edit Tab size value



 Azadi Saryev
 Sabai-dee.com
 http://www.sabai-dee.com/


 On 19/08/2009 00:18, vidya yegnaraman wrote:
 
  Hi,
  Can anybody let me know the shortcut to globally search for any tab keys
 used for spacing or indentation in coldfusion pages in macromedia
 dreamweaver?
 
  Also, please let me know how to set the tab key to a specific no of
 spacing?
 
  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:325528
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: (ot) Twitter down

2009-08-06 Thread David McGuigan

I think you mean DOSN attack.

On Thu, Aug 6, 2009 at 11:50 AM, Robert Harrison rob...@austin-williams.com
 wrote:


 It's a self-fulfilling problem. Spread enough news there's a DOS attack so
 everyone goes to check it out, and there is a DOS attack.


 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




 __ Information from ESET Smart Security, version of virus signature
 database 4312 (20090806) __

 The message was checked by ESET Smart Security.

 http://www.eset.com


 

~|
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:325251
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Question on page reloads and include refresh

2009-07-29 Thread David McGuigan

Are you using frames?


On Wed, Jul 29, 2009 at 1:17 PM, Torrent Girl torrentg...@gmail.com wrote:


 I have an issue where I have header and left nav includes.

 My site has spanish and english text that allows the user to switch back
 and forth between the two languages.


 My problem is that the header, which includes a topNav doesn't refresh when
 the page reloads. Everything else does.

 So what happens is, the users clicks the spanish button, the text changes
 correctly in the body of the page but the everything in the headers stays on
 english. When a link is clicked, then it changes to spanish.

 Any suggestions?

 

~|
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:325100
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: integrating with quick books merchant services

2009-07-28 Thread David McGuigan

!--- Prep request ---
cfset qAppId = XXX
cfset qAppLogin = whatev.yourdomain.com
cfset qTimeStamp =
#dateformat(now(),-mm-dd)#T#timeformat(now(),HH:mm:ss)#
cfset qConnTicket = XX

cfsavecontent variable=QBMSXML?xml
version=1.0?
?qbmsxml version=2.0?
QBMSXML
SignonMsgsRq
SignonDesktopRq

 ClientDateTime#qTimeStamp#/ClientDateTime

 ApplicationLogin#qAppLogin#/ApplicationLogin

 ConnectionTicket#qConnTicket#/ConnectionTicket
LanguageEnglish/Language
AppID#qAppId#/AppID
AppVer1.0/AppVer
/SignonDesktopRq
/SignonMsgsRq
QBMSXMLMsgsRq
CustomerCreditCardChargeRq

 TransRequestID#CreateUUID()#/TransRequestID

 CreditCardNumber#form.ccNumber#/CreditCardNumber

 ExpirationMonth#form.ccMonth#/ExpirationMonth

 ExpirationYear#form.ccYear#/ExpirationYear

 IsCardPresentfalse/IsCardPresent
Amount#numberformat( (
form.quantity * form.price ),_.99)#/Amount

 NameOnCard#form.ccName#/NameOnCard

 CreditCardAddress#yourCodeThatAssemblesTheAddress( form
)#/CreditCardAddress

 CreditCardPostalCode#form.contactZipcode#/CreditCardPostalCode

 SalesTaxAmount0.00/SalesTaxAmount

 CardSecurityCode#form.ccCCD#/CardSecurityCode
   /CustomerCreditCardChargeRq
/QBMSXMLMsgsRq
/QBMSXML
/cfsavecontent

!--- Submit request to Quickbooks ---
cfhttp url=
https://merchantaccount.quickbooks.com/j/AppGateway; method=post
port=443
cfhttpparam type=Header
name=Accept-Encoding value=*
cfhttpparam type=Header name=TE
value=deflate;q=0
cfhttpparam type=header name=content-type
value=application/x-qbmsxml /
cfhttpparam type=header name=content-length
value=#len(QBMSXML)# /
cfhttpparam type=body name=requestXML
encoded=no value=#QBMSXML# /
/cfhttp

!--- Response / debugging ---
cfset QBMSReturn = xmlParse(cfhttp.filecontent) /




On Tue, Jul 28, 2009 at 1:12 PM, Clint Tredway grum...@gmail.com wrote:


 Has anyone been able to integrate with QBMS using CF? I have looked around
 some on different forums and the last time someone posted a solution was
 over a year ago. I really need help in finding out how to do this pretty
 quickly. Any help is appreciated.

 Thanks!

 --
 “When you choose hope, anything is possible.”
 -Christopher Reeve

 

~|
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:325054
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: WildCard query

2009-07-23 Thread David McGuigan

Tom, in the ColdFusion code that handles the form submission, you can do
something like this:
cfquery name=getAllFields datasource=yourDatasource
describe yourTableName
/cfquery

That query will get a list of all of the fields of your table. Then, in your
search query, you can loop through them like this:
cfoutput
cfquery name=search datasource=yourDatasource 
select *
from yourTableName
where
cfloop query=getAllFields
   cfif currentRow gt 1  or /cfif #field# like cfqueryparam
cfsqltype=cf_sql_varchar value=%#form.yourTextInput#% /
/cfloop
/cfquery
/cfoutput

That will search every field in your table for a match to the text field
contents from the form they submitted. Good luck.




On Thu, Jul 23, 2009 at 8:17 PM, Tom Jones tjo...@acworld.com wrote:


 Sorry, I thin I might not explained my self very well. Al though the
 cfdbinfo looks really cool and I think I can use it in a report
 generator tool I want to do, so thanks.

 So what I want is a single form field that will search the entire
 table without having to specify which column.

 Thanks,
 tom



 On Jul 23, 2009, at 9:24 AM, cftalk wrote:

 
  You can also this little gem (cfdbinfo)
  http://www.cfquickdocs.com/cf8/#cfdbinfo
 
 
  -Original Message-
  From: David McGuigan [mailto:davidmcgui...@gmail.com]
  Sent: July-22-09 9:23 PM
  To: cf-talk
  Subject: Re: WildCard query
 
 
  You can grab a list of all of the columns of any table and loop
  through them
  pretty easily ( they syntax varies with your database vendor ).
 
  MySQL is just:
 
  describe tableName
 
 
  On Wed, Jul 22, 2009 at 9:10 PM, Tom Jones tjo...@acworld.com wrote:
 
 
  Hello,
  I'm migrating some pages from Lasso to Coldfusion and one of the
  current pages in Lasso has a query to search any field/column for a
  value. I have never done this with coldsuion before so I'm not sure
  how to go about this.
 
  thanks,
  tom
 
 
 
 
 
 
 
 
 
 

 

~|
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:324914
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: WildCard query

2009-07-22 Thread David McGuigan

You can grab a list of all of the columns of any table and loop through them
pretty easily ( they syntax varies with your database vendor ).

MySQL is just:

describe tableName


On Wed, Jul 22, 2009 at 9:10 PM, Tom Jones tjo...@acworld.com wrote:


 Hello,
 I'm migrating some pages from Lasso to Coldfusion and one of the
 current pages in Lasso has a query to search any field/column for a
 value. I have never done this with coldsuion before so I'm not sure
 how to go about this.

 thanks,
 tom





 

~|
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:324847
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: grouped query - groups in separate columns

2009-07-16 Thread David McGuigan

What do you mean by grouped query?

Like a two column query where the values of one of the columns match across
multiple rows?



On Thu, Jul 16, 2009 at 6:21 PM, Seamus Campbell
coldfus...@boldacious.comwrote:


 Hi

 I have a grouped query which displays fine but in a single column.
 I want to display each group in a new column, but I can't work out how to
 do this

 Any clues please

 Ta
 Seamus

 

~|
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:324615
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Problem installing ColdFusion on my new laptop.

2009-07-13 Thread David McGuigan

Ian, to administer your IIS sites you go to

Control Panel  Administrative Tools  IIS Something or Other

It might be a better idea to just uninstall ColdFusion, make sure you have
the IIS 6 Metabase compatibility enabled, and then re-run the CF install and
let it configure the IIS connections that way. I've found the web connector
wizard thing works most of the time, but sometimes it just seems to struggle
after-the-fact.




On Mon, Jul 13, 2009 at 11:26 AM, Ian Skinner h...@ilsweb.com wrote:


 Dave Sueltenfuss wrote:
  What version of CF are you trying to install?
 I downloaded a nice, fresh 8.0.1 Windows 64bit version of ColdFusion
 just before the installation.



 

~|
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:324472
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: railo and Ext

2009-07-08 Thread David McGuigan

I was actually kidding. But as for me, no, I use Adobe ColdFusion
exclusively. I actually had a bunch of apps that made extensive use of Ext,
but have recently migrated them all to jQuery which I now also use
exclusively.


On Wed, Jul 8, 2009 at 2:36 PM, Don L do...@yahoo.com wrote:


 well, if you consider ColdFusion and cfml engine are in the same category,
 it's not.  And probably this NG may also evolve... just a thought.  But more
 importantly, do you?  And I would certainly be glad to talk off this NG as
 well, donli at yahoo dot com

 Kind of a personal question.
 
 -- Sent from my Palm Pre
 D
 
 
 Anyone here using Ext with railo?
 
 Thanks.
 
 Don
 Chunshen Li

 

~|
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:324355
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: ColdFusion SME

2009-07-08 Thread David McGuigan

I've also heard PHP developers use it as slang to refer to someone
that develops with ColdFusion.

PHP developer 1: Hey guys, this is my friend Karl. He's some kind of
ColdFusion SME.
PHP developer 2: So what does the SME stand for?
PHP developer 1: Super man equivalent. Like, he develops apps about
as fast as 7 or 8 of us working together at the same time.
PHP developer 2: Eff my life.

On 7/8/09, Mark Mandel mark.man...@gmail.com wrote:

 Small to Medium Enterprise

 http://en.wiktionary.org/wiki/SME

 Mark

 On Thu, Jul 9, 2009 at 1:58 PM, Pranathi Reddy rk.prana...@gmail.comwrote:


 Hi All,

 May be this is not related to technical question but I came across this
 word many times and wanna know .. What is Coldfusion SME or Coldfusion SME
 candidate?

 In software engineering - SME is Subject Matter Expert...

 Is Coldfusion SME is same as SME...?

 Can anyone explain me in detail?

 Thanx in advance...

 Pranathi.



 

~|
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:324373
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: DSN is Saving CF Query Ops to Wrong Database?

2009-07-06 Thread David McGuigan

So do your Application.cfc files have a cfset this.name = etc / in their
pseudo constructors?


On Mon, Jul 6, 2009 at 3:43 PM, Matthew Reinbold 
matthew.reinb...@voxpopdesign.com wrote:


  Maybe. Make sure each of your applications has its own namespace by
  using this.name in Application.cfc, otherwise they'll share ( and
  overwrite eachother ) anything you put into the application scope

 Interesting. Looking through the inherited code I'm seeing that in the
 application.cfc OnApplicationStart method the DSN is set like:

 cfset application.ds = mydb /

 Would that be any different than using:

 cfset this.ds = mydb /

 ?

 Also, to clarify, the separate Coldfusion servers for Dev and Test are
 separate instances upon the same JRun, so some kind of variable scope
 leakage might make sense.

 -Matthew

 

~|
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:324273
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: New CF8 vulnerability

2009-07-03 Thread David McGuigan

So do we not need to restart ColdFusion after making this change?


On Fri, Jul 3, 2009 at 5:32 PM, Eric Roberts 
ow...@threeravensconsulting.com wrote:


 Dave (or anyone else with information),

 I know the vulnerability was in older versions of FCKEditor...if one were
 to
 install and use the current version, does it still have the vulnerability
 or
 has that been fixed?  I just got an emergency gig to fix a site that was
 hacked because of this and we need to know if it is safe to do this or just
 keep FCKEditor disabled inthe meantime.

 Eric


 On Thu, Jul 2, 2009 at 6:17 PM, Dave Watts dwa...@figleaf.com wrote:

 
  You may want to check for this on any clients/projects you've worked
 with:
  http://isc.sans.org/diary.html?storyid=6715
 
  Remediation steps available here:
  http://www.codfusion.com/blog/post.cfm/cf8-and-fckeditor-security-threat
 
  Dave Watts, CTO, Fig Leaf Software
  http://www.figleaf.com/
 
  Fig Leaf Software provides the highest caliber vendor-authorized
  instruction at our training centers in Washington DC, Atlanta,
  Chicago, Baltimore, Northern Virginia, or on-site at your location.
  Visit http://training.figleaf.com/ for more information!
 
 

 

~|
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:324212
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: cfform javascript reference

2009-06-28 Thread David McGuigan

a href= javascript: functionThatExistsButReturnsFalse( );  onclick= etc(
); etc/a

So, accessible to your page you'd have a

function mute( ){ return false( ); }

And then your buttons could be:

a href= javascript: mute( ); 
onclick=document.getElementById('form').reset()clear/a
a href= javascript: mute( ); 
onclick=document.getElementById('form').submit()send/a

You may be able to return false directly in the href, I can't remember.


On Sun, Jun 28, 2009 at 12:33 PM, Matthew Smith chedders...@gmail.comwrote:


 I have a cfform with the following for reset and submit:
 a href=## onclick=document.getElementById('form').reset()clear/a
 a href=## onclick=document.getElementById('form').submit()send/a

 Clicking the reset button clears the form but the goes to domain.com/#, as
 does the submit button.

 I can change it to this, and it works properly, but hovering over the
 button does not change the pointer.
 a onclick=document.getElementById('form').reset()clear/a
 a onclick=document.getElementById('form').submit()send/a

 Any way to do this?

 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:324032
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: cfform javascript reference

2009-06-28 Thread David McGuigan

Er,

function mute( ){ return false; }

Not false( );


On Sun, Jun 28, 2009 at 2:15 PM, David McGuigan davidmcgui...@gmail.comwrote:

 a href= javascript: functionThatExistsButReturnsFalse( );  onclick=
 etc( ); etc/a

 So, accessible to your page you'd have a

 function mute( ){ return false( ); }

 And then your buttons could be:

 a href= javascript: mute( ); 
 onclick=document.getElementById('form').reset()clear/a
 a href= javascript: mute( ); 
 onclick=document.getElementById('form').submit()send/a

 You may be able to return false directly in the href, I can't remember.



 On Sun, Jun 28, 2009 at 12:33 PM, Matthew Smith chedders...@gmail.comwrote:


 I have a cfform with the following for reset and submit:
 a href=## onclick=document.getElementById('form').reset()clear/a
 a href=## onclick=document.getElementById('form').submit()send/a

 Clicking the reset button clears the form but the goes to domain.com/#,
 as does the submit button.

 I can change it to this, and it works properly, but hovering over the
 button does not change the pointer.
 a onclick=document.getElementById('form').reset()clear/a
 a onclick=document.getElementById('form').submit()send/a

 Any way to do this?

 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:324033
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: PHP to CF pseudo code...

2009-06-25 Thread David McGuigan

Sure. Highlight about 8 out of every 10 lines of the code with your mouse,
then hit the delete key. From what's left, change the random,
cryptic-looking function names to something more semantically valuable.

That should be about right. Enjoy.


On Thu, Jun 25, 2009 at 2:22 PM, Che Vilnonis ch...@asitv.com wrote:


 Oh, I know there is no tool. But the code is pretty simple and I thought
 I
 might find a rough translation... Anyone want to to take a shot?

 -Original Message-
 From: Paul Alkema [mailto:paulalkemadesi...@gmail.com]
 Sent: Thursday, June 25, 2009 4:18 PM
 To: cf-talk
 Subject: RE: PHP to CF pseudo code...


 Hey Che,
 You're not going to find any sort of php to cf tool if that's what your
 looking for. I'm afraid if there was such a tool that it would highly
 inaccurate because there are so many different variations when working with
 both languages. There are some php to cf guides out their.

 http://sweatte.wordpress.com/syntax/

 I found this page helpful sometimes, it has multiple languages but
 sometimes
 it's hard because sometimes there aren't direct language translations.
 Paul Alkema
 AlkemaDesigns.com
 -Original Message-
 From: Che Vilnonis [mailto:ch...@asitv.com]
 Sent: Thursday, June 25, 2009 3:59 PM
 To: cf-talk
 Subject: PHP to CF pseudo code...


 Anyone know where/how to get some PHP code translated into CF pseudo code
 or
 something a CF programmer would understand?
 Is there such a beast? I can post the example... its about 50 lines of
 code.

 ~Che








 

~|
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:323949
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Full screen?

2009-06-17 Thread David McGuigan

It's part of the Flash Player. You can toggle between fullscreen and
embedded with a simple Actionscript call.


On Wed, Jun 17, 2009 at 8:54 PM, Don L do...@yahoo.com wrote:


 Hulu movie has a full screen option, I'm wondering if we could also easily
 implement that for a cf web app?  Has anyone done something like that?

 Thanks.

 Don

 

~|
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:323621
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Full screen?

2009-06-17 Thread David McGuigan

Well what's weirder ( sillier ) is that entire operating systems don't. And
by entire operating systems I mean Mac OS X. There's no fullscreen support
for any of the browsers. On most Windows browsers the user can actually
activate fullscreen mode independent of the web site they're on manually.


On Wed, Jun 17, 2009 at 9:24 PM, Don L do...@yahoo.com wrote:


 It's part of the Flash Player. You can toggle between fullscreen and
 embedded with a simple Actionscript call.
  
 On Wed, Jun 17, 2009 at 8:54 PM, D
 
 

 Thanks for the info but I'll have to stay away from Flash.  Weird though
 why web standard does not support such a useful feature?

 

~|
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:323623
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: SOA Coldfusion best practices

2009-06-08 Thread David McGuigan

Who are you kidding, you loved doing that.


On Mon, Jun 8, 2009 at 4:14 PM, Nathan Strutz str...@gmail.com wrote:


 I hate to do this, but, did you try http://tinyurl.com/nx44fe ?


 nathan strutz
 [Blog and Family @ http://www.dopefly.com/]
 [AZCFUG Manager @ http://www.azcfug.org/]
 [Twitter @nathanstrutz]


 On Mon, Jun 8, 2009 at 2:49 PM, Tim Oommen toom...@playboy.com wrote:

 
  Are there any good sites or presentations that people can recommend for
  best practices when implementing a SOA architecture using ColdFusion?
 
 

 

~|
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:323251
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: DSN-Less connections in CF8

2009-06-01 Thread David McGuigan

Second that. The Admin API makes it easy.


On Mon, Jun 1, 2009 at 2:36 PM, Barney Boisvert bboisv...@gmail.com wrote:


 You can also use the Admin API to create DSNs on the fly.

 cheers,
 barneyb

 On Mon, Jun 1, 2009 at 1:26 PM, Mark Kruger mkru...@cfwebtools.com
 wrote:
 
  Scott,
 
  Here's the approach we usually use (it works pretty well).
 
  http://www.coldfusionmuse.com/index.cfm/2005/6/3/dsn_cfmx
 
  -Mark
 
 
 
  Mark A. Kruger, CFG, MCSE
  (402) 408-3733 ext 105
  www.cfwebtools.com
  www.coldfusionmuse.com
  www.necfug.com
 
  -Original Message-
  From: Scott Stewart [mailto:sstwebwo...@bellsouth.net]
  Sent: Monday, June 01, 2009 3:23 PM
  To: cf-talk
  Subject: DSN-Less connections in CF8
 
 
  Yeah, this one's been beaten to death but.
 
  I need a process where a user can upload an Access db, certain tables can
 be
  read and the data inserted into a MySQL DB.
 
 
 
  The user has to be able to upload a new db once or twice a month, and the
  name may not always be the same.
 
 
 
  I know you used to be able to do this pre-MX, but google searches come
 back
  with conflicting results.
 
 
 
  Has anyone gotten this to work successfully\?
 
 
 
  --
  Scott Stewart
  ColdFusion Developer
  4405 Oakshyre Way
  Raleigh, NC 27616
  (h) 919.874.6229 (c) 703.220.2835
 
 
 
 
 
 
 
 

 

~|
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:323053
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: DSN-Less connections in CF8

2009-06-01 Thread David McGuigan

Try omitting the driver and the port.




On Mon, Jun 1, 2009 at 7:10 PM, Scott Stewart sstwebwo...@bellsouth.netwrote:


 So I went the API route...

 cffunction name=dbMerge access=public description=I move the data
 into
 the user database returntype=any
cfargument name=dbFileName

cfset dbfile =
 D:\Sites\stlouislandscape-v1\clarity\dbStore\#arguments.dbFileName#
cfset adminLogin =
 createObject(component,cfide.adminapi.administrator).login(pil0t)
cfset dbCreate =
 createObject(component,cfide.adminapi.datasource)
cfset tempAccessDBDSN =
 dbCreate.setMSAccess(tempADSN, #dbfile#, MSAccess,
 macromedia.jdbc.MacromediaDriver, 19998)

cfquery name=getData
 datasource=tempAccessDBDSN
SELECT *
FROM MEMBERSHIP
/cfquery

cfreturn getData
 /cffunction


 I'm getting this error
 Element macromedia.jdbc.MacromediaDriver is undefined in a Java object of
 type class coldfusion.server.ConfigMap.
 The error occurred on line 1385.

 Any ideas?

 --
 Scott Stewart
 ColdFusion Developer
 4405 Oakshyre Way
 Raleigh, NC 27616
 (h) 919.874.6229 (c) 703.220.2835
 -Original Message-
 From: David McGuigan [mailto:davidmcgui...@gmail.com]
 Sent: Monday, June 01, 2009 5:04 PM
 To: cf-talk
 Subject: Re: DSN-Less connections in CF8


 Second that. The Admin API makes it easy.


 On Mon, Jun 1, 2009 at 2:36 PM, Barney Boisvert bboisv...@gmail.com
 wrote:

 
  You can also use the Admin API to create DSNs on the fly.
 
  cheers,
  barneyb
 
  On Mon, Jun 1, 2009 at 1:26 PM, Mark Kruger mkru...@cfwebtools.com
  wrote:
  
   Scott,
  
   Here's the approach we usually use (it works pretty well).
  
   http://www.coldfusionmuse.com/index.cfm/2005/6/3/dsn_cfmx
  
   -Mark
  
  
  
   Mark A. Kruger, CFG, MCSE
   (402) 408-3733 ext 105
   www.cfwebtools.com
   www.coldfusionmuse.com
   www.necfug.com
  
   -Original Message-
   From: Scott Stewart [mailto:sstwebwo...@bellsouth.net]
   Sent: Monday, June 01, 2009 3:23 PM
   To: cf-talk
   Subject: DSN-Less connections in CF8
  
  
   Yeah, this one's been beaten to death but.
  
   I need a process where a user can upload an Access db, certain tables
 can
  be
   read and the data inserted into a MySQL DB.
  
  
  
   The user has to be able to upload a new db once or twice a month, and
 the
   name may not always be the same.
  
  
  
   I know you used to be able to do this pre-MX, but google searches come
  back
   with conflicting results.
  
  
  
   Has anyone gotten this to work successfully\?
  
  
  
   --
   Scott Stewart
   ColdFusion Developer
   4405 Oakshyre Way
   Raleigh, NC 27616
   (h) 919.874.6229 (c) 703.220.2835
  
  
  
  
  
  
  
  
 
 



 

~|
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:323061
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: DSN-Less connections in CF8

2009-06-01 Thread David McGuigan

Er, all of the optional arguments. Try just the new datasource name and the
path to the file.

On Mon, Jun 1, 2009 at 8:43 PM, David McGuigan davidmcgui...@gmail.comwrote:

 Try omitting the driver and the port.





 On Mon, Jun 1, 2009 at 7:10 PM, Scott Stewart 
 sstwebwo...@bellsouth.netwrote:


 So I went the API route...

 cffunction name=dbMerge access=public description=I move the data
 into
 the user database returntype=any
cfargument name=dbFileName

cfset dbfile =
 D:\Sites\stlouislandscape-v1\clarity\dbStore\#arguments.dbFileName#
cfset adminLogin =
 createObject(component,cfide.adminapi.administrator).login(pil0t)
cfset dbCreate =
 createObject(component,cfide.adminapi.datasource)
cfset tempAccessDBDSN =
 dbCreate.setMSAccess(tempADSN, #dbfile#, MSAccess,
 macromedia.jdbc.MacromediaDriver, 19998)

cfquery name=getData
 datasource=tempAccessDBDSN
SELECT *
FROM MEMBERSHIP
/cfquery

cfreturn getData
 /cffunction


 I'm getting this error
 Element macromedia.jdbc.MacromediaDriver is undefined in a Java object of
 type class coldfusion.server.ConfigMap.
 The error occurred on line 1385.

 Any ideas?

 --
 Scott Stewart
 ColdFusion Developer
 4405 Oakshyre Way
 Raleigh, NC 27616
 (h) 919.874.6229 (c) 703.220.2835
 -Original Message-
 From: David McGuigan [mailto:davidmcgui...@gmail.com]
 Sent: Monday, June 01, 2009 5:04 PM
 To: cf-talk
 Subject: Re: DSN-Less connections in CF8


 Second that. The Admin API makes it easy.


 On Mon, Jun 1, 2009 at 2:36 PM, Barney Boisvert bboisv...@gmail.com
 wrote:

 
  You can also use the Admin API to create DSNs on the fly.
 
  cheers,
  barneyb
 
  On Mon, Jun 1, 2009 at 1:26 PM, Mark Kruger mkru...@cfwebtools.com
  wrote:
  
   Scott,
  
   Here's the approach we usually use (it works pretty well).
  
   http://www.coldfusionmuse.com/index.cfm/2005/6/3/dsn_cfmx
  
   -Mark
  
  
  
   Mark A. Kruger, CFG, MCSE
   (402) 408-3733 ext 105
   www.cfwebtools.com
   www.coldfusionmuse.com
   www.necfug.com
  
   -Original Message-
   From: Scott Stewart [mailto:sstwebwo...@bellsouth.net]
   Sent: Monday, June 01, 2009 3:23 PM
   To: cf-talk
   Subject: DSN-Less connections in CF8
  
  
   Yeah, this one's been beaten to death but.
  
   I need a process where a user can upload an Access db, certain tables
 can
  be
   read and the data inserted into a MySQL DB.
  
  
  
   The user has to be able to upload a new db once or twice a month, and
 the
   name may not always be the same.
  
  
  
   I know you used to be able to do this pre-MX, but google searches come
  back
   with conflicting results.
  
  
  
   Has anyone gotten this to work successfully\?
  
  
  
   --
   Scott Stewart
   ColdFusion Developer
   4405 Oakshyre Way
   Raleigh, NC 27616
   (h) 919.874.6229 (c) 703.220.2835
  
  
  
  
  
  
  
  
 
 



 

~|
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:323062
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Need help with dynamic form fields

2009-05-30 Thread David McGuigan

A really easy way would be to just store it in a variable like so:

script userID = #url.idUser#; /script

and then in  your form validation just do:

 document.getElementById( 'compensationType_' + userID )

to get a reference to the form control itself, and read and manipulate the
value as you please.

If you have a set of userIDs you want to loop through, just make it an
array:

script
 userIDs = [ cfloopcfif iteration gt 1 , /cfif#item# /cfloop ];
/script

Then do the same thing to read the control values.



On Sat, May 30, 2009 at 7:02 PM, Torrent Girl torrentg...@gmail.com wrote:


 hello

 I have an issue that I am stuck on.

 I need to check the value of dynamic form fields with javascript and don't
 know
 how.

 Here is what the form fields look like:

 compensationType_userID (this is the field name)

 The userID will be the dynamic part.

 How do I check for the value in javascript on the form submission?

 If compensation type = salary, then do this...

 Thank you.

 

~|
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:323009
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


MySQL IDE on OS X

2009-05-26 Thread David McGuigan

Can anyone recommend a good MySQL IDE on OS X? So far I've been using
Navicat but it's kind of a joke.

Anyone have one they actually like?


~|
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:322797
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: MySQL IDE on OS X

2009-05-26 Thread David McGuigan

You know, I use the MySQL Query Browser on Vista a lot and actually love it.
On OS X however, that app literally crashes on me within 30 seconds of
launching it each and every time, and I've got a completely fresh install of
OS X as of Saturday night with just CS4, Adium, some browsers, ColdFusion
and MySQL installed. Is it stable for you? Thanks.



On Tue, May 26, 2009 at 2:32 PM, Wil Genovese jugg...@visi.com wrote:


 From MySQL's web site

 http://dev.mysql.com/downloads/gui-tools/5.0.html

 Wil Genovese


 On Tue, May 26, 2009 at 2:54 PM, David McGuigan davidmcgui...@gmail.com
 wrote:

 
  Can anyone recommend a good MySQL IDE on OS X? So far I've been using
  Navicat but it's kind of a joke.
 
  Anyone have one they actually like?
 
 
 

 

~|
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:322799
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: MySQL IDE on OS X

2009-05-26 Thread David McGuigan

Charlie! That app is AWESOME. EXACTLY what I was looking for.

Better windowing, much more attractive, smart shortcuts, inline quick
querier. So slick.

Command 1 2 3. So simple and clever.

There's even a keyboard shortcut to execute your inline query ( though it's
a weird one: Fn + Enter ).

Seriously thanks a million.


On Tue, May 26, 2009 at 2:46 PM, Charlie Griefer
charlie.grie...@gmail.comwrote:


 On Tue, May 26, 2009 at 12:54 PM, David McGuigan davidmcgui...@gmail.com
 wrote:

 
  Can anyone recommend a good MySQL IDE on OS X? So far I've been using
  Navicat but it's kind of a joke.
 
  Anyone have one they actually like?
 

 I'm a relatively recent MBP user, so haven't really delved too deeply into
 it yet, but have heard good things about Sequel Pro (
 http://www.sequelpro.com/).  Used to be CocoaSQL.

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


 

~|
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:322801
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Join Two fields in one table to One field in Another?

2009-05-20 Thread David McGuigan

I'm actually on a computer without any serverware right now to test this out
but I think you can do something like:

select ta.*, tb1.*, tb2.*
from tableA ta, tableB tb1, tableB tb2
where ta.from = tb1.pk and ta.to = tb2.pk



On Wed, May 20, 2009 at 1:20 AM, Marie Taylore mt4yl...@yahoo.com wrote:


 I know this is probably simpler than I'm making it, but I have Table A with
 two different references to the primary key in table B.

 Table A
 ===
 From  To
   ==
 1 2
 2 4
 3 7

 Table B
 ===
 PK  Firstname  Lastname
 ==  =  
 1   John   Doe
 2   Jane   Doe
 3   John   Smith
 4   Jane   Smith
 7   Frank  Jones

 I need to be able to show the first and last names from Table A's
 references to the PK in Table B (for both fields From and To).

 Basically, I'm trying to get the following output:

 Sent From   Sent To
 ==  ===
 John DoeJane Doe
 Jane DoeJane Smith
 John Smith  Frank Jones

 What kind of join do I need to make this work?  Or does my table design not
 allow this?  Regular inner joins don't seem to be working, and I'm certainly
 no SQL wiz.

 Any help is appreciated.

 MarieT





 

~|
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:322650
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Join Two fields in one table to One field in Another?

2009-05-20 Thread David McGuigan

You'll obv want to give the * fields aliases to be able to access them more
easily.

On Wed, May 20, 2009 at 1:26 AM, David McGuigan davidmcgui...@gmail.comwrote:

 I'm actually on a computer without any serverware right now to test this
 out but I think you can do something like:

 select ta.*, tb1.*, tb2.*
 from tableA ta, tableB tb1, tableB tb2
 where ta.from = tb1.pk and ta.to = tb2.pk




 On Wed, May 20, 2009 at 1:20 AM, Marie Taylore mt4yl...@yahoo.com wrote:


 I know this is probably simpler than I'm making it, but I have Table A
 with two different references to the primary key in table B.

 Table A
 ===
 From  To
   ==
 1 2
 2 4
 3 7

 Table B
 ===
 PK  Firstname  Lastname
 ==  =  
 1   John   Doe
 2   Jane   Doe
 3   John   Smith
 4   Jane   Smith
 7   Frank  Jones

 I need to be able to show the first and last names from Table A's
 references to the PK in Table B (for both fields From and To).

 Basically, I'm trying to get the following output:

 Sent From   Sent To
 ==  ===
 John DoeJane Doe
 Jane DoeJane Smith
 John Smith  Frank Jones

 What kind of join do I need to make this work?  Or does my table design
 not allow this?  Regular inner joins don't seem to be working, and I'm
 certainly no SQL wiz.

 Any help is appreciated.

 MarieT





 

~|
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:322651
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Call .jar files like .exes with CF8

2009-05-04 Thread David McGuigan

I'm trying to execute a .jar file with some parameters from a cfc and then
use the file it generates afterward. But, Google and I cannot seem to figure
out how you execute .jars in CFML.
This is an epic fail:
cfexecute name = #expandPath( '/my.jar' )#
arguments = -o etc
outputFile = #expandPath( '/mechanics/framework/compressor/output.txt' )#

/cfexecute

I've tried placing the java keyword in the beginning of the name parameter,
java -jar, as well as both variations in the arguments param but no luck.

Thank you.


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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322154
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Call .jar files like .exes with CF8

2009-05-04 Thread David McGuigan

The solution was providing a full path to the java.exe like so if anyone's
curious:
 cfexecute name = x:\serverware\coldfusion8\...\java.exe
   arguments=-jar yourJar.jar [ options ] /cfexecute



On Mon, May 4, 2009 at 1:24 PM, David McGuigan davidmcgui...@gmail.comwrote:

 I'm trying to execute a .jar file with some parameters from a cfc and then
 use the file it generates afterward. But, Google and I cannot seem to figure
 out how you execute .jars in CFML.
 This is an epic fail:
 cfexecute name = #expandPath( '/my.jar' )#
 arguments = -o etc
 outputFile = #expandPath( '/mechanics/framework/compressor/output.txt' )#
 
 /cfexecute

 I've tried placing the java keyword in the beginning of the name parameter,
 java -jar, as well as both variations in the arguments param but no luck.

 Thank you.





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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322155
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Standard to Enterprise - load balanced

2009-04-27 Thread David McGuigan

A single license of Enterprise lets you install and activate on an unlimited
number of virtual machines on the same hardware ( up to 2 physical
processors, meaning up to 8 processing cores if you've got quads ). I
believe that if you've got more than two physical processors on your
machine, you need to get one license per 2 CPUs, but I may be wrong.


On Mon, Apr 27, 2009 at 11:09 AM, Jeff Becker jpbec...@yahoo.com wrote:


 Good morning,
 We currently have an app on CF8 Standard, but due to volume we are moving
 it to a virtualized environment in that it will be load balanced between two
 servers.

 I'm just looking for a feeler, but in that in this circumstance, would it
 be correct to say we will need to get the UPGRADE to Enterprise only  OR
  will it be neccessary for us to have 2 licenses of CF8 Enterprise, because
 we are load balancing between two servers (virtualized or not).

 What about if further volume increases this to load balancing between 3
 servers.

 Thoughts??  Thanks in advance.

 

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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321982
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Standard to Enterprise - load balanced

2009-04-27 Thread David McGuigan

Sorry, I misread your question. You do need a license for each physical
server you run.

On Mon, Apr 27, 2009 at 11:09 AM, Jeff Becker jpbec...@yahoo.com wrote:


 Good morning,
 We currently have an app on CF8 Standard, but due to volume we are moving
 it to a virtualized environment in that it will be load balanced between two
 servers.

 I'm just looking for a feeler, but in that in this circumstance, would it
 be correct to say we will need to get the UPGRADE to Enterprise only  OR
  will it be neccessary for us to have 2 licenses of CF8 Enterprise, because
 we are load balancing between two servers (virtualized or not).

 What about if further volume increases this to load balancing between 3
 servers.

 Thoughts??  Thanks in advance.

 

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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321983
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: css oodity

2009-04-18 Thread David McGuigan

I actually think you're not supposed to use quotes at all with CSS url paths
( can anyone confirm/deny? )

So this would be what browsers would expect according to the CSS spec:
form id=myfrm
input type=button style=background-image:url(/

 nav/bold.gif);width:25;height:23 /
 /form





On Sat, Apr 18, 2009 at 8:56 AM, Don L do...@yahoo.com wrote:


 see if that single quote in your bg image url is playing tricks on you
 (unless it's a typo or bad copy/paste...)
 your first machine may be just serving cached pages and that's why you
 still see the bg rendered correctly on it: hard-refresh the page to
 check for sure (ctrl+shift+r in FF, or, iirc, shift+F5 in IE)...
 
 Azadi Saryev
 Sabai-dee.com
 http://www.sabai-dee.com/

 Sorry.  Indeed, it's a typo/missing the single quote.

 Typo:
 form id=myfrm
 input type=button
 style=background-image:url('/nav/bold.gif);width:25;height:23 /
 /form

 Correct:
 form id=myfrm
 input type=button
 style=background-image:url('/nav/bold.gif');width:25;height:23 /
 /form

 The IE7 is configured to the setting of Every time I vist the webpage for
 page loading on both boxes.  I've even rebooted the box still to no avail.



 

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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321788
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Newbie ... CFSQLTYPE of CFQueryParam

2009-04-16 Thread David McGuigan

I've always been curious as to how cfqueryparam works. Does anyone know if
it just performs some scanning and filtering on the actual values of the
parameters passed to it or whether it somehow signals to the RDBMS that the
values are parameters to the query thereby treating an SQLI attack as an
escaped string or something?

cfqueryparam errors when you try to use it outside a cfquery tag, which
limits some of the stuff you can do with it. ( Like using cfsavecontent to
have various cffunctions append SQL to a query and then popping that
variable inside of a cfquery tag ).

Is there some other way to leverage the parameterized safety of
cfqueryparam? Can you do it using pure SQL? The database driver? Any ideas
on how I could provide the same security outside of cfquery tags?


On Thu, Apr 16, 2009 at 9:32 AM, Gerald Guido gerald.gu...@gmail.comwrote:


 This is the link to the function code in case it was not apparent from my
 post... I really need to slow down. ;o)

 http://coz.pastebin.com/f588cde23

 G!




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

 To invent, you need a good imagination and a pile of junk.
 -- Thomas A. Edison


 

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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321650
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Newbie ... CFSQLTYPE of CFQueryParam

2009-04-16 Thread David McGuigan

Am I correct in assuming ( after just having skimmed the topic with Google )
that to do that within CFML I'd have to drop into Java and use the MySQL
Java API to achieve that?



On Thu, Apr 16, 2009 at 10:36 AM, Dave Watts dwa...@figleaf.com wrote:


  I've always been curious as to how cfqueryparam works. Does anyone know
 if
  it just performs some scanning and filtering on the actual values of the
  parameters passed to it or whether it somehow signals to the RDBMS that
 the
  values are parameters to the query thereby treating an SQLI attack as an
  escaped string or something?

 It builds a prepared statement. It doesn't scan or filter anything.

  cfqueryparam errors when you try to use it outside a cfquery tag, which
  limits some of the stuff you can do with it. ( Like using cfsavecontent
 to
  have various cffunctions append SQL to a query and then popping that
  variable inside of a cfquery tag ).
 
  Is there some other way to leverage the parameterized safety of
  cfqueryparam? Can you do it using pure SQL? The database driver? Any
 ideas
  on how I could provide the same security outside of cfquery tags?

 You could build a prepared statement yourself.

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

 Fig Leaf Software provides the highest caliber vendor-authorized
 instruction at our training centers in Washington DC, Atlanta,
 Chicago, Baltimore, Northern Virginia, or on-site at your location.
 Visit http://training.figleaf.com/ for more information!

 

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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321664
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Newbie ... CFSQLTYPE of CFQueryParam

2009-04-16 Thread David McGuigan

Actually, it looks like as long as I managed my prepared statement naming
manually across the entire MySQL server I'd be ok to just run multiple
queries in a row ( because CF8 with MySQL breaks for me if I try more than
one statement separated by semicolons ).

So it'd play out like this, for anyone curious:

cfquery/
prepare statement #appName#_someIdentifier
' select * from ? '

cfquery/
set @p1 := '#userSuppliedValue#'

cfquery/
execute #appName#_someIdentifier using @p1

That sure is a lot of cfquery tags, considering you'd need an extra cfquery
for each parameter.
But I wonder if that would totally break because CF could be executing
multiple queries in parallel through the same MySQL connection and the
interwoven execution of all of these queries might make them overlap and
overwrite each other's values. Is that about accurate?




2009/4/16 David McGuigan davidmcgui...@gmail.com

 Am I correct in assuming ( after just having skimmed the topic with Google
 ) that to do that within CFML I'd have to drop into Java and use the MySQL
 Java API to achieve that?




 On Thu, Apr 16, 2009 at 10:36 AM, Dave Watts dwa...@figleaf.com wrote:


  I've always been curious as to how cfqueryparam works. Does anyone know
 if
  it just performs some scanning and filtering on the actual values of the
  parameters passed to it or whether it somehow signals to the RDBMS that
 the
  values are parameters to the query thereby treating an SQLI attack as an
  escaped string or something?

 It builds a prepared statement. It doesn't scan or filter anything.

  cfqueryparam errors when you try to use it outside a cfquery tag, which
  limits some of the stuff you can do with it. ( Like using cfsavecontent
 to
  have various cffunctions append SQL to a query and then popping that
  variable inside of a cfquery tag ).
 
  Is there some other way to leverage the parameterized safety of
  cfqueryparam? Can you do it using pure SQL? The database driver? Any
 ideas
  on how I could provide the same security outside of cfquery tags?

 You could build a prepared statement yourself.

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

 Fig Leaf Software provides the highest caliber vendor-authorized
 instruction at our training centers in Washington DC, Atlanta,
 Chicago, Baltimore, Northern Virginia, or on-site at your location.
 Visit http://training.figleaf.com/ for more information!

 

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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321667
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Newbie ... CFSQLTYPE of CFQueryParam

2009-04-16 Thread David McGuigan

Update: You can actually enable multiple statements in a single query in
ColdFusion by appending allowMultiQueries=true to your datasource connection
string!


2009/4/16 David McGuigan davidmcgui...@gmail.com

 Actually, it looks like as long as I managed my prepared statement naming
 manually across the entire MySQL server I'd be ok to just run multiple
 queries in a row ( because CF8 with MySQL breaks for me if I try more than
 one statement separated by semicolons ).

 So it'd play out like this, for anyone curious:

 cfquery/
 prepare statement #appName#_someIdentifier
 ' select * from ? '

 cfquery/
 set @p1 := '#userSuppliedValue#'

 cfquery/
 execute #appName#_someIdentifier using @p1

 That sure is a lot of cfquery tags, considering you'd need an extra cfquery
 for each parameter.
 But I wonder if that would totally break because CF could be executing
 multiple queries in parallel through the same MySQL connection and the
 interwoven execution of all of these queries might make them overlap and
 overwrite each other's values. Is that about accurate?




 2009/4/16 David McGuigan davidmcgui...@gmail.com

 Am I correct in assuming ( after just having skimmed the topic with Google
 ) that to do that within CFML I'd have to drop into Java and use the MySQL
 Java API to achieve that?




 On Thu, Apr 16, 2009 at 10:36 AM, Dave Watts dwa...@figleaf.com wrote:


  I've always been curious as to how cfqueryparam works. Does anyone know
 if
  it just performs some scanning and filtering on the actual values of
 the
  parameters passed to it or whether it somehow signals to the RDBMS that
 the
  values are parameters to the query thereby treating an SQLI attack as
 an
  escaped string or something?

 It builds a prepared statement. It doesn't scan or filter anything.

  cfqueryparam errors when you try to use it outside a cfquery tag, which
  limits some of the stuff you can do with it. ( Like using cfsavecontent
 to
  have various cffunctions append SQL to a query and then popping that
  variable inside of a cfquery tag ).
 
  Is there some other way to leverage the parameterized safety of
  cfqueryparam? Can you do it using pure SQL? The database driver? Any
 ideas
  on how I could provide the same security outside of cfquery tags?

 You could build a prepared statement yourself.

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

 Fig Leaf Software provides the highest caliber vendor-authorized
 instruction at our training centers in Washington DC, Atlanta,
 Chicago, Baltimore, Northern Virginia, or on-site at your location.
 Visit http://training.figleaf.com/ for more information!

 

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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321672
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Newbie ... CFSQLTYPE of CFQueryParam

2009-04-16 Thread David McGuigan

:::It builds a prepared statement. It doesn't scan or filter anything.

You could build a prepared statement yourself.

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


Are you sure? When I pass a string into a cfqueryparam of type cf_sql_integer
I get the error: Invalid data etc for CFSQLTYPE CF_SQL_INTEGER.
Which leads me to believe it is being scanned/validated before being sent to
MySQL, and also makes me wonder whether cfqueryparam even uses prepared
statements. It seems and not just inline SQL variables.
( The exception is a coldfusion.sql.Parameter$DataTypeMismatchException )



On Thu, Apr 16, 2009 at 10:36 AM, Dave Watts dwa...@figleaf.com wrote:



 It builds a prepared statement. It doesn't scan or filter anything.

 You could build a prepared statement yourself.

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

 Fig Leaf Software provides the highest caliber vendor-authorized
 instruction at our training centers in Washington DC, Atlanta,
 Chicago, Baltimore, Northern Virginia, or on-site at your location.
 Visit http://training.figleaf.com/ for more information!

 

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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321684
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Newbie ... CFSQLTYPE of CFQueryParam

2009-04-16 Thread David McGuigan

Well from what I read today it seems like the performance is improved for
reused prepared statements, which may not be how cfqueryparam is
implemented.
Prepared statements are stored and reused by name, passing in the values for
the parameters.

So if cfqueryparam is using prepared statements (which my guess would be
that it's not), cfqueryparamming all of your variable values would improve
performance because the statement itself isn't being re-sent to the RDMS on
each subsequent query, only the values. But if it's not, it could actually
slightly DIMINISH performance ( because the SQL generated is more verbose
because of the variable declarations and binding syntax ).

Any experts out there that can enlighten us?


On Thu, Apr 16, 2009 at 12:33 PM, Dominic Watson 
watson.domi...@googlemail.com wrote:


 Just a little thing to add here is that I believe you should
 parametize all values in your query, whether user generated or
 constant values or whatever. This is not for security but performance.
 So:

 SELECT fu
 FROM bar
 WHERE barId = cfqueryparam cf_sql_type=cf_sql_integer value=#id# /
 AND live = 1

 Should be:

 SELECT fu
 FROM bar
 WHERE barId = cfqueryparam cf_sql_type=cf_sql_integer value=#id# /
 AND live = cfqueryparam cf_sql_type=cf_sql_bit value=1 /

 The reason (and someone please correct me if I am wrong) is that
 prepared statements can perform better because the db engine caches
 their execution plan much in the same way as for stored procedures. By
 parametizing and supplying the type of each value, you help this
 process. Indeed I suspect that I have read somewhere that it will not
 cache at all if it finds values that are not parametized.

 This is my rough understanding of it; please somebody who knows more
 clarify or correct the point (I do know that db performance always
 goes by the rule: it depends though).

 Dominic

 

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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321689
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Newbie ... CFSQLTYPE of CFQueryParam

2009-04-16 Thread David McGuigan

Ah, thanks guys! What I didn't realize is that you can use unnamed /
unstored prepared statements through the driver. That makes so much more
sense now. So ColdFusion uses dynamically prepared statements which are
implemented in the JDBC driver, which is a totally different ballgame from
using the pure SQL interface, which requires you to register them by name
and then reuse or overwrite them per call.
So if I can hunt down the driver syntax for calling that stuff directly can
I just use the Java commands from within my dynamic SQL in a cfquery tag?

It looks like CF probably uses java.sql.PreparedStatement with syntax like
this:

PreparedStatement pstmt = con.prepareStatement(UPDATE EMPLOYEES SET SALARY
= ? WHERE ID = ?);

   pstmt.setBigDecimal(1, 153833.00);
   pstmt.setInt(2, 110592);

Does anyone know how I'd just pop that Java into a CFQuery tag? Or can I
probably not because cfquery itself is what handles all of that and will
already be either a Statement or PreparedStatement object depending on
whether it detected any cfqueryparams?

If so, does that mean my only option is writing a custom tag to simulate
cfquery and having it handle all of that stuff the same way cfquery does? (
Retrieve the datasource info from the adminapi, create and manage the
connection, call all of these execution methods and then translate their
results to a CFML query object, etc.

What a hassle. This is worse than the fact that you can't use cfform
controls outside of a cfform tag in CFC cffunctions.

Thanks again.


On Thu, Apr 16, 2009 at 1:33 PM, Dave Watts dwa...@figleaf.com wrote:


  So if cfqueryparam is using prepared statements (which my guess would be
  that it's not), cfqueryparamming all of your variable values would
 improve
  performance because the statement itself isn't being re-sent to the RDMS
 on
  each subsequent query, only the values. But if it's not, it could
 actually
  slightly DIMINISH performance ( because the SQL generated is more verbose
  because of the variable declarations and binding syntax ).

 Your guess is incorrect. CFQUERYPARAM builds a JDBC prepared
 statement. Using CFQUERYPARAM may improve or degrade performance,
 depending on additional factors. The SQL being more verbose is not one
 of those factors.

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

 Fig Leaf Software provides the highest caliber vendor-authorized
 instruction at our training centers in Washington DC, Atlanta,
 Chicago, Baltimore, Northern Virginia, or on-site at your location.
 Visit http://training.figleaf.com/ for more information!

 

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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321702
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Newbie ... CFSQLTYPE of CFQueryParam

2009-04-16 Thread David McGuigan

Nevermind, you can totally hack cfquery! Woot. Thanks for all the help.

On Thu, Apr 16, 2009 at 1:59 PM, David McGuigan davidmcgui...@gmail.comwrote:

 Ah, thanks guys! What I didn't realize is that you can use unnamed /
 unstored prepared statements through the driver. That makes so much more
 sense now. So ColdFusion uses dynamically prepared statements which are
 implemented in the JDBC driver, which is a totally different ballgame from
 using the pure SQL interface, which requires you to register them by name
 and then reuse or overwrite them per call.
 So if I can hunt down the driver syntax for calling that stuff directly can
 I just use the Java commands from within my dynamic SQL in a cfquery tag?

 It looks like CF probably uses java.sql.PreparedStatement with syntax like
 this:

 PreparedStatement pstmt = con.prepareStatement(UPDATE EMPLOYEES SET
 SALARY = ? WHERE ID = ?);

pstmt.setBigDecimal(1, 153833.00);
pstmt.setInt(2, 110592);

 Does anyone know how I'd just pop that Java into a CFQuery tag? Or can I
 probably not because cfquery itself is what handles all of that and will
 already be either a Statement or PreparedStatement object depending on
 whether it detected any cfqueryparams?

 If so, does that mean my only option is writing a custom tag to simulate
 cfquery and having it handle all of that stuff the same way cfquery does? (
 Retrieve the datasource info from the adminapi, create and manage the
 connection, call all of these execution methods and then translate their
 results to a CFML query object, etc.

 What a hassle. This is worse than the fact that you can't use cfform
 controls outside of a cfform tag in CFC cffunctions.

 Thanks again.


 On Thu, Apr 16, 2009 at 1:33 PM, Dave Watts dwa...@figleaf.com wrote:


  So if cfqueryparam is using prepared statements (which my guess would be
  that it's not), cfqueryparamming all of your variable values would
 improve
  performance because the statement itself isn't being re-sent to the RDMS
 on
  each subsequent query, only the values. But if it's not, it could
 actually
  slightly DIMINISH performance ( because the SQL generated is more
 verbose
  because of the variable declarations and binding syntax ).

 Your guess is incorrect. CFQUERYPARAM builds a JDBC prepared
 statement. Using CFQUERYPARAM may improve or degrade performance,
 depending on additional factors. The SQL being more verbose is not one
 of those factors.

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

 Fig Leaf Software provides the highest caliber vendor-authorized
 instruction at our training centers in Washington DC, Atlanta,
 Chicago, Baltimore, Northern Virginia, or on-site at your location.
 Visit http://training.figleaf.com/ for more information!

 

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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321705
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Newbie ... CFSQLTYPE of CFQueryParam

2009-04-16 Thread David McGuigan

So my real issue was that I wanted to super dynamically assemble the SQL and
then either execute it or do a variety of other things with it ( which I
won't go into ).

If you try to use cfqueryparam outside of a containing cfquery, ColdFusion
breaks.

So,

cfsavecontent
   ...cfqueryparam...
/cfsavecontent

if something
   do something else with it
else
   cfquery it

errored.

By hacking cfquery, I mean that it suddently occured to me that you can do
this, instead of the other options:

cfquery
cfsavecontent
...cfqueryparam...
/cfsavecontent
if something
 select false
else
  #cfsavecontent#
/cfquery

if something
 return cfsavecontent
else
 return queryName

Note that you'll still need to not use cfqueryparam in cases where you won't
be executing the query ( and swap in the unprocessed values or placeholders
), but in my case that still dramatically reduced the code necessary to
support the multiple channels ( solved my problem ).

It's very hacky, but worked like a charm.



On Thu, Apr 16, 2009 at 2:40 PM, Dominic Watson 
watson.domi...@googlemail.com wrote:


  If so, does that mean my only option is writing a custom tag to simulate
  cfquery and having it handle all of that stuff the same way cfquery does?
 (
  Retrieve the datasource info from the adminapi, create and manage the
  connection, call all of these execution methods and then translate their
  results to a CFML query object, etc.

 It is so, but I think the option of creating the custom tag is both
 mildly barmy and not the only option. A possible easier coding
 solution may be to create a component that builds and executes a
 cfquery by taking a java style prepared statement. A rough idea:

 cfcomponent
  set variables.dsn =  /
  cffunction name=init ... init component and set datasource
 name/cffunction
  cffunction name=executePreparedStatement returntype=query
   cfargument name=statement type=string hint=eg. select * from
 foo where bar = ? /
   cfargument name=params type=array hint=Array of structs with
 two keys, 'type' and 'value' /

   cfset var theQuery =  /
   cfquery name=theQuery datasource=#_dsn#

...// code to parse the statement and insert cfqueryparams in
 place of the '?'s
   /cfquery

   cfreturn theQuery /
  /cffunction
 /cfcompont


  What a hassle. This is worse than the fact that you can't use cfform
  controls outside of a cfform tag in CFC cffunctions.

 I don't believe it makes sense for CF to be able to do what you are
 asking. Given a bare cfqueryparam .../, how is it to know what to do
 with it?

 Dominic

 

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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321713
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: how to handle in-appropriate image uploads

2009-04-09 Thread David McGuigan

Check out Amazon Turk.


On Thu, Apr 9, 2009 at 11:34 AM, Tony Bentley t...@tonybentley.com wrote:


 The viewers are able to flag it as inappropriate content.


 

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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321482
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Per-application custom tag paths ( Application.cfc )

2009-04-07 Thread David McGuigan

Thanks Ben and Peter.
Yeah, I've got it in the pseudo constructor. I'll play around with the
snippets and see if anything gives.



On Tue, Apr 7, 2009 at 2:17 AM, Peter Boughton bought...@gmail.com wrote:


 Definitely seems to be plural (which makes sense; it's a list of multiple
 paths).

 To give another working example, I've ripped the top six lines from the
 Application.cfc for a Railo app I'm writing:

 cfcomponent output=false

cfset This.Name = {application_name} /
cfset This.CustomTagPaths = /tags /

cffunction name=onApplicationStart output=false


 Possibly that's also something worth checking: that you have the code
 *outside* onApplicationStart, or it'll only be set when that event triggers.

 

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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321400
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Per-application custom tag paths ( Application.cfc )

2009-04-06 Thread David McGuigan

Ben Forta was like, Yo, this.customtagpaths / listAppend(
this.customtagpaths, newPath ).
http://www.forta.com/blog/index.cfm/2007/4/24

But then the Adobe documentation's all like, this.customtagpath ( singular )
http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=AppEvents_01.html

Either way, neither of those combinations are working for me.

Beyond not enabling per-application settings in the administrator, is there
something else that could break this mechanism? I'm even testing it with a
single full hard path that I can paste into Windows Explorer and will take
me to the correct directory.

But it cannot find my tags. My poor, sweet tags. All of my other
per-application settings are working for this app. Any ideas?

... I don't know how involved the CFIDE folder is in the process, but it
might be worth noting that my CFIDE ( and ColdFusion install ) is somewhere
completely separate from this application/siteroot/customtagsfolder.
Basically
ColdFusion: drive:/serverware/cf8/
CFIDE: drive:/serverware/cf8/webroot/cfide/
This app: drive:/webroot/appX/

Note: My CFIDE folder is in a separate folder than where the WEB-INF
directory is, which is cf8/wwwroot/


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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321368
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: POST variables not accessible with clean URL system in IIS 7

2009-04-03 Thread David McGuigan

Dominic: You're my hero with that Microsoft link!!! Except that none of
those downloads are available!! !! !! ! ! ! ! !!! !! ! ! ! ! !  ! ! ! !
At least now I know that it's actually IIS not handing off the POST data.
Which doesn't make any sense though ( in fact the reason I stopped
researching it ) because it supposedly works out of the box with ASP. Which
led me to assume that IIS7 had just changed formats and not notified any of
other app servers to update ( which would explain PHP and CF both struggling
with it ).

If anyone can get to that link I'll be your best friend forever.

Moving on.

By extraneous I meant extraneous to my natural distribution logic, which
does not by any means just do translation to file-based URLs ( like in your
example ). Managing a config file at all to me qualifies as extraneous to my
controller mechanism, so it won't be a good fit for this application. Thank
you for the suggestion.




On Thu, Apr 2, 2009 at 2:10 PM, Dominic Watson 
watson.domi...@googlemail.com wrote:


 Using asapi rewrite rules does not need to be extraneous. The config
 file can be contained within your app source and, depending on the
 urls you want, can be a very simple thing indeed, e.g.

 /foo/bar(*.) = index.cfm?action=foo.bar$ (not real code but you get the
 idea)

 Once you have the hang of it, it actually makes for very centralised
 rewrite and redirect logic rather than the other way around. We use
 the ISAPI rewrite dll from ionic, which is free:

 http://www.codeplex.com/IIRF

 Dominic



 2009/4/2 David McGuigan davidmcgui...@gmail.com:
 
  Thanks for the suggestion. I do realize that ISAPI rewriting is an
  alternative, but my entire application controller is just a CF-based,
  dynamic translation and coordination of URLs to content, so I want to
 handle
  that with CFML logic, and not have to maintain it extraneously.
  Any Java fiends out there that can give me some Java methods to try to
  output the raw HTTP signature handed down to ColdFusion?
 
 
  On Thu, Apr 2, 2009 at 12:22 PM, Ben Nadel b...@bennadel.com wrote:
 
 
  Ooooh, you're using 404 handling. Gotcha. Yeah, I use that on my site a
  lot.
  I am not sure that I have ever submitted a FORM to it.
 
  You might want to look into something like ISAPI_REWRITE which I think
  changes the URL in a more natural way.
 
 
  On Thu, Apr 2, 2009 at 2:14 PM, David McGuigan davidmcgui...@gmail.com
  wrote:
 
  
   NP Ben, I was just confused. So you actually don't have to configure
 any
   URL
   rewriting with IIS 6+. You just grab the site, update the 404 custom
  error
   handler to use a URL ( Like /index.cfm ), and then change the
 feature
   settings mode to custom errors. It'll then pass everything through
 to
  the
   CF template you specify. From there on I'm just dumping things on that
   template, and neither FORM, or the result of GetHTTPRequestData are
   populated,
   which is the real issue.
  
   I'm guessing it's just that CF isn't parsing the (potentially new) IIS
 7
   format of custom error passthrough correctly, similar to how PHP
  struggles
   with it as described here: http://bugs.php.net/bug.php?id=38094
   I've just filed the bug with Adobe. We'll see what they say, maybe
  there's
   some workaround.
  
  
  
   2009/4/2 Jason Fisher ja...@wanax.com
  
   
At its most basic, GET will populate the URL scope, POST will
 populate
   the
FORM scope.  Is there a reason you can't look to the FORM scope
 during
processing?
   
   
  
  
 
 
 
 

 

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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321283
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: POST variables not accessible with clean URL system in IIS 7

2009-04-03 Thread David McGuigan

Nevermind got it you're my hero! I can't believe Microsoft has the nuts to
not underline their hyperlinks!!!

On Fri, Apr 3, 2009 at 10:03 AM, David McGuigan davidmcgui...@gmail.comwrote:

 Dominic: You're my hero with that Microsoft link!!! Except that none of
 those downloads are available!! !! !! ! ! ! ! !!! !! ! ! ! ! !  ! ! ! !
 At least now I know that it's actually IIS not handing off the POST data.
 Which doesn't make any sense though ( in fact the reason I stopped
 researching it ) because it supposedly works out of the box with ASP. Which
 led me to assume that IIS7 had just changed formats and not notified any of
 other app servers to update ( which would explain PHP and CF both struggling
 with it ).

 If anyone can get to that link I'll be your best friend forever.

 Moving on.

 By extraneous I meant extraneous to my natural distribution logic, which
 does not by any means just do translation to file-based URLs ( like in your
 example ). Managing a config file at all to me qualifies as extraneous to my
 controller mechanism, so it won't be a good fit for this application. Thank
 you for the suggestion.




 On Thu, Apr 2, 2009 at 2:10 PM, Dominic Watson 
 watson.domi...@googlemail.com wrote:


 Using asapi rewrite rules does not need to be extraneous. The config
 file can be contained within your app source and, depending on the
 urls you want, can be a very simple thing indeed, e.g.

 /foo/bar(*.) = index.cfm?action=foo.bar$ (not real code but you get the
 idea)

 Once you have the hang of it, it actually makes for very centralised
 rewrite and redirect logic rather than the other way around. We use
 the ISAPI rewrite dll from ionic, which is free:

 http://www.codeplex.com/IIRF

 Dominic



 2009/4/2 David McGuigan davidmcgui...@gmail.com:
 
  Thanks for the suggestion. I do realize that ISAPI rewriting is an
  alternative, but my entire application controller is just a CF-based,
  dynamic translation and coordination of URLs to content, so I want to
 handle
  that with CFML logic, and not have to maintain it extraneously.
  Any Java fiends out there that can give me some Java methods to try to
  output the raw HTTP signature handed down to ColdFusion?
 
 
  On Thu, Apr 2, 2009 at 12:22 PM, Ben Nadel b...@bennadel.com wrote:
 
 
  Ooooh, you're using 404 handling. Gotcha. Yeah, I use that on my site a
  lot.
  I am not sure that I have ever submitted a FORM to it.
 
  You might want to look into something like ISAPI_REWRITE which I think
  changes the URL in a more natural way.
 
 
  On Thu, Apr 2, 2009 at 2:14 PM, David McGuigan 
 davidmcgui...@gmail.com
  wrote:
 
  
   NP Ben, I was just confused. So you actually don't have to configure
 any
   URL
   rewriting with IIS 6+. You just grab the site, update the 404 custom
  error
   handler to use a URL ( Like /index.cfm ), and then change the
 feature
   settings mode to custom errors. It'll then pass everything through
 to
  the
   CF template you specify. From there on I'm just dumping things on
 that
   template, and neither FORM, or the result of GetHTTPRequestData are
   populated,
   which is the real issue.
  
   I'm guessing it's just that CF isn't parsing the (potentially new)
 IIS 7
   format of custom error passthrough correctly, similar to how PHP
  struggles
   with it as described here: http://bugs.php.net/bug.php?id=38094
   I've just filed the bug with Adobe. We'll see what they say, maybe
  there's
   some workaround.
  
  
  
   2009/4/2 Jason Fisher ja...@wanax.com
  
   
At its most basic, GET will populate the URL scope, POST will
 populate
   the
FORM scope.  Is there a reason you can't look to the FORM scope
 during
processing?
   
   
  
  
 
 
 
 

 

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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321284
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: POST variables not accessible with clean URL system in IIS 7

2009-04-03 Thread David McGuigan

Note sure if you got my original response to this. I got a failure message
from Gmail.
Dominic: You're my hero with that Microsoft link!!! Except that somehow,
that perfectly, exactly applicable hotfix didn't fix the issue. It's still
not handing over the POST variables. What. The. Crap.

...

Moving on.

By extraneous I meant extraneous to my natural distribution logic, which
does not by any means just do translation to file-based URLs ( like in your
example ). Managing a config file at all to me qualifies as extraneous to my
controller mechanism, so it won't be a good fit for this application. Thank
you for the suggestion.

On Thu, Apr 2, 2009 at 2:15 PM, Dominic Watson 
watson.domi...@googlemail.com wrote:


 Ok, here's a more helpful link (that I found after a few clicks from
 the other link):

 http://support.microsoft.com/kb/956578




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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321302
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


POST variables not accessible with clean URL system in IIS 7

2009-04-02 Thread David McGuigan

Using IIS7 to pass fake URLs throught to ColdFusion for parsing.
Ex: http://www.whatev.com/benForta/favoriteFoods/

Note: There is no benForta nor favoriteFoods directory.

The URL scope works perfectly but when I submit a form using POST the scope
isn't populated.

CGI.CONTENT_TYPE knows it's a application/x-www-form-urlencoded request, but
I can't get to those variables.

Is there some lower-level way to access the POST data ( I'm assuming URL and
FORM just parse from some HTTP handover collection or string )??

Thanks!


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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321239
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: POST variables not accessible with clean URL system in IIS 7

2009-04-02 Thread David McGuigan

What do you mean my underlying problem?
It just seems like ColdFusion isn't set up to correctly interpret posts when
fed from IIS 7's custom error handling mechanism.

There's nothing wrong with my code.


On Thu, Apr 2, 2009 at 11:50 AM, Ben Nadel b...@bennadel.com wrote:


 You can try looking at GetHTTPRequestData().

 Not sure if that has what you need (and I think it changes the way it
 functions if FILE data is submitted with FORM). I think you'd be better off
 trying to fix whatever the underlying problem is rather than work around
 it.
 ... I'm sure you're trying to do that already :) I was just saying

 -Ben


 On Thu, Apr 2, 2009 at 1:37 PM, David McGuigan davidmcgui...@gmail.com
 wrote:

 
  Using IIS7 to pass fake URLs throught to ColdFusion for parsing.
  Ex: http://www.whatev.com/benForta/favoriteFoods/
 
  Note: There is no benForta nor favoriteFoods directory.
 
  The URL scope works perfectly but when I submit a form using POST the
 scope
  isn't populated.
 
  CGI.CONTENT_TYPE knows it's a application/x-www-form-urlencoded request,
  but
  I can't get to those variables.
 
  Is there some lower-level way to access the POST data ( I'm assuming URL
  and
  FORM just parse from some HTTP handover collection or string )??
 
  Thanks!
 
 
 

 

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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321242
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: POST variables not accessible with clean URL system in IIS 7

2009-04-02 Thread David McGuigan

But that method is exactly what I was looking for. And it seems like it's a
bug, because the content key provided by that method is empty. Dangit.
I guess the current limitation is you have to post to literal files with CF
8 and IIS 7.


On Thu, Apr 2, 2009 at 11:50 AM, Ben Nadel b...@bennadel.com wrote:


 You can try looking at GetHTTPRequestData().

 Not sure if that has what you need (and I think it changes the way it
 functions if FILE data is submitted with FORM). I think you'd be better off
 trying to fix whatever the underlying problem is rather than work around
 it.
 ... I'm sure you're trying to do that already :) I was just saying

 -Ben


 On Thu, Apr 2, 2009 at 1:37 PM, David McGuigan davidmcgui...@gmail.com
 wrote:

 
  Using IIS7 to pass fake URLs throught to ColdFusion for parsing.
  Ex: http://www.whatev.com/benForta/favoriteFoods/
 
  Note: There is no benForta nor favoriteFoods directory.
 
  The URL scope works perfectly but when I submit a form using POST the
 scope
  isn't populated.
 
  CGI.CONTENT_TYPE knows it's a application/x-www-form-urlencoded request,
  but
  I can't get to those variables.
 
  Is there some lower-level way to access the POST data ( I'm assuming URL
  and
  FORM just parse from some HTTP handover collection or string )??
 
  Thanks!
 
 
 

 

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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321244
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: POST variables not accessible with clean URL system in IIS 7

2009-04-02 Thread David McGuigan

NP Ben, I was just confused. So you actually don't have to configure any URL
rewriting with IIS 6+. You just grab the site, update the 404 custom error
handler to use a URL ( Like /index.cfm ), and then change the feature
settings mode to custom errors. It'll then pass everything through to the
CF template you specify. From there on I'm just dumping things on that
template, and neither FORM, or the result of GetHTTPRequestData are populated,
which is the real issue.

I'm guessing it's just that CF isn't parsing the (potentially new) IIS 7
format of custom error passthrough correctly, similar to how PHP struggles
with it as described here: http://bugs.php.net/bug.php?id=38094
I've just filed the bug with Adobe. We'll see what they say, maybe there's
some workaround.



2009/4/2 Jason Fisher ja...@wanax.com


 At its most basic, GET will populate the URL scope, POST will populate the
 FORM scope.  Is there a reason you can't look to the FORM scope during
 processing?

 

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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321246
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: POST variables not accessible with clean URL system in IIS 7

2009-04-02 Thread David McGuigan

Thanks for the suggestion. I do realize that ISAPI rewriting is an
alternative, but my entire application controller is just a CF-based,
dynamic translation and coordination of URLs to content, so I want to handle
that with CFML logic, and not have to maintain it extraneously.
Any Java fiends out there that can give me some Java methods to try to
output the raw HTTP signature handed down to ColdFusion?


On Thu, Apr 2, 2009 at 12:22 PM, Ben Nadel b...@bennadel.com wrote:


 Ooooh, you're using 404 handling. Gotcha. Yeah, I use that on my site a
 lot.
 I am not sure that I have ever submitted a FORM to it.

 You might want to look into something like ISAPI_REWRITE which I think
 changes the URL in a more natural way.


 On Thu, Apr 2, 2009 at 2:14 PM, David McGuigan davidmcgui...@gmail.com
 wrote:

 
  NP Ben, I was just confused. So you actually don't have to configure any
  URL
  rewriting with IIS 6+. You just grab the site, update the 404 custom
 error
  handler to use a URL ( Like /index.cfm ), and then change the feature
  settings mode to custom errors. It'll then pass everything through to
 the
  CF template you specify. From there on I'm just dumping things on that
  template, and neither FORM, or the result of GetHTTPRequestData are
  populated,
  which is the real issue.
 
  I'm guessing it's just that CF isn't parsing the (potentially new) IIS 7
  format of custom error passthrough correctly, similar to how PHP
 struggles
  with it as described here: http://bugs.php.net/bug.php?id=38094
  I've just filed the bug with Adobe. We'll see what they say, maybe
 there's
  some workaround.
 
 
 
  2009/4/2 Jason Fisher ja...@wanax.com
 
  
   At its most basic, GET will populate the URL scope, POST will populate
  the
   FORM scope.  Is there a reason you can't look to the FORM scope during
   processing?
  
  
 
 

 

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

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321248
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


  1   2   >