Re: RecordCount and Sub(?) Counts?

2007-06-21 Thread Nicholas Tunney
Actually, I would try to stay away from count(*) IMO.  Count an actual 
field.

Nicholas M. Tunney
Blog: http://www.nictunney.com

Adobe Certified Advanced ColdFusion MX7 Developer
Adobe Certified Instructor
Adobe Community Expert



Dawson, Michael wrote:
> SELECT
>   color
>   ,COUNT(*) AS colorCount
> FROM
>   ShoeTable
> GROUP BY
>   color
>
> M!ke 
>
> -Original Message-
> From: Les Mizzell [mailto:[EMAIL PROTECTED] 
> Sent: Thursday, June 21, 2007 11:12 PM
> To: CF-Talk
> Subject: RecordCount and Sub(?) Counts?
>
> I can think of all kinds of evil "use a loop" and stuff to do this, but
> what's a more compact way, or is there one?
>
> Stupid Example - a query that returns shoes
>
> 100 total shoes returned (shoeQUERY.recordcount)
>
> How can I get the query to also tell me there's 45 red shoes, 15 blue
> shoes and 40 green shoes without doing dome kind of loop with a counter
> outside the query? Or can you?
>
> 

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

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


Re: Application.cfc execution order

2011-02-11 Thread Nicholas Tunney

Sounds like either a) and error is occurring in onApplicationStart() or b)
you didn;t reinitialize your app and onApplicationStart isn;t running
since the app already exists.

nic

On 2/11/11 3:49 PM, "Mike P"  wrote:

>
>I recently modified my Application.cfc to email all errors for debugging.
>While sending the error, I referenced some email settings I saved in the
>application scope. It was my understanding that OnApplicationStart()
>fired before anything else, but it looks like ColdFusion is trying to
>parse OnError() first. Since the application variables are set in the
>OnApplicationStart() function, my app errors out.
>
>Is this the order the functions are supposed to execute in or should I be
>looking for something else that might be wrong?
>
>

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


Re: Change in ColdFusion management

2011-02-15 Thread Nicholas Tunney

Wow, its like history in the making, bridges being built, right here on
the cf-talk list.  I'll expect the president to claim this was his doing
on CNN at 5PM EDT.  Don't miss it!

-Nic

On 2/15/11 4:01 PM, "Adrocknaphobia"  wrote:

>
>Dropped.
>
>-Adam
>
>On Tue, Feb 15, 2011 at 12:26 PM, Russ Michaels 
>wrote:
>
>>
>> Other way round Adam, you need to drop the vendetta.
>>
>> On Tue, Feb 15, 2011 at 8:11 PM, Adrocknaphobia
>>> >wrote:
>>
>> >
>> > Russ,
>> >
>> > It's clear you have beef with me. Saying I "post first and think
>>later"
>> is
>> > an insult. Just because you don't like what I post, doesn't mean I
>>don't
>> > think about it. I promise that if you don't attack me, I won't attack
>> you.
>> >
>> > -Adam
>> >
>> > On Tue, Feb 15, 2011 at 11:28 AM, Russ Michaels 
>> > wrote:
>> >
>> > >
>> > > Brian, if you think it is wrong I wont argue, all I can suggest is
>>try
>> > > searching the cf-talk archives and will find otherwise. I only read
>>the
>> > > occasional post on here and even I  seen it to be a fairly
>> > > regular occurrence, and that is discounting the ones directed at me.
>> > > If I am in a tiny minority then fair enough, but I personally can't
>> > imagine
>> > > too many people go around insulting their customers and trying to
>>turn
>> > them
>> > > into anti-customers, especially when they are evangelists and are
>> > defending
>> > > your product.
>> > > Sorry if I can't see the sense in that, perhaps I am just weird.
>> > >
>> > >
>> > >
>> > > On Tue, Feb 15, 2011 at 6:42 PM, Brian Kotek 
>> wrote:
>> > >
>> > > >
>> > > > That's one way to look at it. But the much more likely view (and
>>the
>> > one
>> > > > Adobe sees) is that the people who think he's guilty of "bad
>> behavior"
>> > > are
>> > > > not only a tiny minority, but are also wrong.
>> > > >
>> > > > On Tue, Feb 15, 2011 at 1:17 PM, Russ Michaels
>>
>> > > > wrote:
>> > > >
>> > > > >
>> > > > > Crikey, well if Adobe promote staff for bad behavior then we are
>> all
>> > in
>> > > > the
>> > > > > wrong job :-)
>> > > > >
>> > > > >
>> > > > > On Tue, Feb 15, 2011 at 6:09 PM, Brian Kotek
>>
>> > > wrote:
>> > > > >
>> > > > > >
>> > > > > > lol. Maybe you should wait until you see what "poor replaced
>> Adam"
>> > is
>> > > > > doing
>> > > > > > next. (hint: it's not what a company does with an employee
>>they
>> are
>> > > > upset
>> > > > > > with or "replacing").
>> > > > > >
>> > > > > >
>> > > > > > On Tue, Feb 15, 2011 at 12:42 PM, Russ Michaels <
>> > r...@michaels.me.uk
>> > > >
>> > > > > > wrote:
>> > > > > >
>> > > > > > >
>> > > > > > > Adam,
>> > > > > > >
>> > > > > > > insulting people that try to support/defend you and Adobe is
>> > > > certainly
>> > > > > > not
>> > > > > > > very smart, and I suspect is one of the reasons you are
>>being
>> > > > replaced.
>> > > > > > >
>> > > > > > >
>> > > > > > >
>> > > > > >
>> > > > > >
>> > > > >
>> > > > >
>> > > >
>> > > >
>> > >
>> > >
>> >
>> >
>>
>> 
>
>

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


Re: How secure is RDS

2011-02-28 Thread Nicholas Tunney

I don't see anything about RDS in that article.  The only thing I can
think of if you saw it somewhere else is that RDS can be used to generate
CFCs, but still, do this in dev only.

You have several options for hitting CFC via remoting, including RTMP and
AMF.  There are lots of good articles out there on configuring endpoints
in your services config.  As for creating the objects in CF and making
them available to Flex, here's one from a fellow I quite trust:
http://blog.nictunney.com/2010/10/using-coldfusion-orm-with-flash.html

-Nic

On 2/28/11 7:21 PM, "nic.tun...@nictunney.com" 
wrote:

>
>I'll check the link when I am home, but I use flash remoting all the time
>which uses blaze ds under the hood.  You should never install rds in
>production. 
>
>Sent from my Verizon Wireless Phone
>
>- Reply message -
>From: "Andrew Scott" 
>Date: Mon, Feb 28, 2011 7:08 pm
>Subject: How secure is RDS
>To: "cf-talk" 
>
>
>I don't see any where that it mentions using RDS to communicate with
>Flex<->ColdFusion.
>
>I am no expert in Flash/Flex development but I am under the impression the
>Flash Remoting on ColdFusion is the way Flash talks to ColdFusion, however
>in development the Flash Builder might require RDS to do Flash
>development.
>
>Regards,
>Andrew Scott
>http://www.andyscott.id.au/
>
>
>> -Original Message-
>> From: Bryan Stevenson [mailto:br...@electricedgesystems.com]
>> Sent: Tuesday, 1 March 2011 11:03 AM
>> To: cf-talk
>> Subject: Re: How secure is RDS
>> 
>> 
>> OK then Nic/Mark
>> 
>> http://www.adobe.com/devnet/flex/articles/fcf_ataglance_flex_coldfusion.
>> html
>> 
>> Seems to contradict you guys
>> 
>> I'd love a non-webservice and non-RDS enabled solution, but Adobe seems
>> to think RDS is the way??  I am in no way wanting to use RDS and not
>> disagreeing with anyone's comments about its insecurty.
>> 
>> ...and please"it doesn't" is not a solution.  Nic, if you know it
>doesn'tcan
>> you provide the method of using CFCs in Flex that works for you?
>> 
>> Thanks in advance
>> 
>> Cheers
>> 
>
>
>
>
>

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


Re: How secure is RDS

2011-02-28 Thread Nicholas Tunney

Check out my other reply.  For the CF side of things you should be good to
go.  In Flex the wizard should help you point ot your services-config, but
I;ve seen Flash Builder mess that up.  Let us know if you have issues.
Also, make sure you can hit http://yourdomain.com/flex2gateway in a
browser (should return a blank page) to ensure remoting is properly
configured.

Nic

On 2/28/11 7:43 PM, "Bryan Stevenson" 
wrote:

>
>Thanks Nic et al
>
>I think the confusion was all mineand glad that's all it was as
>having to use RDS in PROD (as I thought was the case) would have been
>brutalamen!!
>
>Nicif I need more than to set CFC accesstype to "remote" and setup
>the data services in Flex via the wizard, please fill in the blanks for
>meif not...I think I'm done
>
>back under my rock I go ;-)
>
>Cheers
>
>On Mon, 2011-02-28 at 19:21 -0500, nic.tun...@nictunney.com wrote:
>
>> I'll check the link when I am home, but I use flash remoting all the
>>time which uses blaze ds under the hood.  You should never install rds
>>in production. 
>> 
>> Sent from my Verizon Wireless Phone
>> 
>> - Reply message -
>> From: "Andrew Scott" 
>> Date: Mon, Feb 28, 2011 7:08 pm
>> Subject: How secure is RDS
>> To: "cf-talk" 
>> 
>> 
>> I don't see any where that it mentions using RDS to communicate with
>> Flex<->ColdFusion.
>> 
>> I am no expert in Flash/Flex development but I am under the impression
>>the
>> Flash Remoting on ColdFusion is the way Flash talks to ColdFusion,
>>however
>> in development the Flash Builder might require RDS to do Flash
>>development.
>> 
>> Regards,
>> Andrew Scott
>> http://www.andyscott.id.au/
>> 
>> 
>> > -Original Message-
>> > From: Bryan Stevenson [mailto:br...@electricedgesystems.com]
>> > Sent: Tuesday, 1 March 2011 11:03 AM
>> > To: cf-talk
>> > Subject: Re: How secure is RDS
>> > 
>> > 
>> > OK then Nic/Mark
>> > 
>> > 
>>http://www.adobe.com/devnet/flex/articles/fcf_ataglance_flex_coldfusion.
>> > html
>> > 
>> > Seems to contradict you guys
>> > 
>> > I'd love a non-webservice and non-RDS enabled solution, but Adobe
>>seems
>> > to think RDS is the way??  I am in no way wanting to use RDS and not
>> > disagreeing with anyone's comments about its insecurty.
>> > 
>> > ...and please"it doesn't" is not a solution.  Nic, if you know it
>> doesn'tcan
>> > you provide the method of using CFCs in Flex that works for you?
>> > 
>> > Thanks in advance
>> > 
>> > Cheers
>> > 
>> 
>> 
>> 
>> 
>> 
>
>

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


Re: How secure is RDS

2011-02-28 Thread Nicholas Tunney

The article is about CF 9 ORM, but the pattern remains the same.  The ORM
methods are generated in cf9, but in CF8 your objects would probably still
have the same accessor methods.

Nic

On 2/28/11 8:01 PM, "Bryan Stevenson" 
wrote:

>
>Oopsone last thing for now I think Nic
>
>The article seems to perhaps be more about CF 9 and ORM than Flex and
>CFis that a safe assumption?
>
>I'm asking because I'm stuck on CF 8 for the time being and hoping to
>avoid confusion between what I'm trying to do and what CF 9 can do ;-)
>
>Cheers
>-- 
>
>
>Bryan Stevenson B.Comm.
>VP & Director of E-Commerce Development
>Electric Edge Systems Group Inc.
>phone: 250.480.0642
>fax: 250.480.1264
>cell: 250.920.8830
>e-mail: br...@electricedgesystems.com
>web: www.electricedgesystems.com
> 
>Notice:
>This message, including any attachments, is confidential and may contain
>information that is privileged or exempt from disclosure. It is intended
>only for the person to whom it is addressed unless expressly authorized
>otherwise by the sender. If you are not an authorized recipient, please
>notify the sender immediately and permanently destroy all copies of this
>message and attachments.
>Please consider the environment before printing this e-mail
>
>
>
>

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


Re: How secure is RDS

2011-02-28 Thread Nicholas Tunney

Most of my apps use multiple clients.  I many times have a serviceProxy
and remotingProxy.  At a real basic level the remotingProxy mirrors
whatever I need in the serviceProxy as remote methods.  The service layer
can be RESTful (put/get/post/delete), as Andrew suggested, or can be
regular methods depending ont he needs of your application.  What the blog
post shows I how to package up your data using data transfer objects.

Nic

On 2/28/11 8:49 PM, "Bryan Stevenson" 
wrote:

>
>and it was the "accessor" stuff that lost me ;-)
>
>In simple terms are you talking about a single CFC that all other CFC
>calls pass-through?  I've heard that called a "facade", but whatever you
>call it, it is a way of not requiring all CFCs to be of accessType
>remote when using AJAX_CFC for example (at least that's what I do).
>
>The idea is that you pass the component and method name you want to call
>and all other args are passed as part of the arg collection to the
>target CFC.
>
>Any real code samples you know of?
>
>TIA
>
>Cheers
>
>On Mon, 2011-02-28 at 20:34 -0500, Nicholas Tunney wrote:
>
>> The article is about CF 9 ORM, but the pattern remains the same.  The
>>ORM
>> methods are generated in cf9, but in CF8 your objects would probably
>>still
>> have the same accessor methods.
>> 
>> Nic
>> 
>> On 2/28/11 8:01 PM, "Bryan Stevenson" 
>> wrote:
>> 
>> >
>> >Oopsone last thing for now I think Nic
>> >
>> >The article seems to perhaps be more about CF 9 and ORM than Flex and
>> >CFis that a safe assumption?
>> >
>> >I'm asking because I'm stuck on CF 8 for the time being and hoping to
>> >avoid confusion between what I'm trying to do and what CF 9 can do ;-)
>> >
>> >Cheers
>> >-- 
>> >
>> >
>> >Bryan Stevenson B.Comm.
>> >VP & Director of E-Commerce Development
>> >Electric Edge Systems Group Inc.
>> >phone: 250.480.0642
>> >fax: 250.480.1264
>> >cell: 250.920.8830
>> >e-mail: br...@electricedgesystems.com
>> >web: www.electricedgesystems.com
>> > 
>> >Notice:
>> >This message, including any attachments, is confidential and may
>>contain
>> >information that is privileged or exempt from disclosure. It is
>>intended
>> >only for the person to whom it is addressed unless expressly authorized
>> >otherwise by the sender. If you are not an authorized recipient, please
>> >notify the sender immediately and permanently destroy all copies of
>>this
>> >message and attachments.
>> >Please consider the environment before printing this e-mail
>> >
>> >
>> >
>> >
>> 
>> 
>
>

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


Re: Coldfusion service crashing and unable to restart

2007-07-09 Thread Nicholas Tunney
_13 is supported now as well.  I've not run it, but have run _12 with 
great success.

Nicholas M. Tunney
Blog: http://www.nictunney.com

Adobe Certified Advanced ColdFusion MX7 Developer
Adobe Certified Instructor
Adobe Community Expert



Dave Watts wrote:
>> Hi.  We're running CF MX 7.0.2.142559 on a Win2003 server and 
>> we're having the following problem:
>>
>> Coldfusion is periodically crashing (leaving our users with a 
>> "Could not connect to jrun server" error) and the only way to 
>> restart it is to restart the machine.  When we try to restart 
>> the application service it is unable to restart.  When I try 
>> to restart it from the command line with cfstart, I get this error: 
>>
>> # An unexpected error has been detected by HotSpot Virtual Machine:
>> #
>> #  EXCEPTION_ACCESS_VIOLATION (0xc005) at pc=0x080cacc2, 
>> pid=3692, tid=3932 # # Java VM: Java HotSpot(TM) Server VM 
>> (1.4.2_09-b05 mixed mode) # Problematic frame:
>> # V  [jvm.dll+0xcacc2]
>> 
>
> I recommend that you upgrade your JVM to the latest supported version:
> 1.4.2_11 or _13, I forget which. In fact, I would go for _13 even if it's
> not officially supported.
>
> 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!
>
> This email has been processed by SmoothZap - www.smoothwall.net
>
>
> 

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

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


Re: SURVEY RESULTS: Is ColdFusion OO?

2007-07-10 Thread Nicholas Tunney
You would almost have to set up a hierarchy in a dynamically typed 
language.  If you didn't and had an overloaded method, one expecting 
string and one expecting numeric, and passed in 1.92, which method would 
it call?

Nicholas M. Tunney
Blog: http://www.nictunney.com

Adobe Certified Advanced ColdFusion MX7 Developer
Adobe Certified Instructor
Adobe Community Expert



Eric Roberts wrote:
> Why can't you have overloading in a dynamically typed language?  Overloading
> isn't just sending over an argument with a different type...it is also
> sending over different numbers of arguments.  If I remember correctly from
> my C days, you can overload in C...so I would agree that these have nothing
> to do with OO.
>
> Eric
>
> -Original Message-
> From: Sean Corfield [mailto:[EMAIL PROTECTED] 
> Sent: Tuesday, July 10, 2007 3:02 AM
> To: CF-Talk
> Subject: Re: SURVEY RESULTS: Is ColdFusion OO?
>
> On 7/9/07, Steve Brownlee <[EMAIL PROTECTED]> wrote:
>   
>> - Overloading
>> - Generics
>> - Method overriding
>> - Static methods
>> - And most importantly, it's not typed (i.e. you can't cast a Sphere CFC
>> 
> as
>   
>> a Ball CFC, among a myriad of other possibilities)
>> 
>
> None of these has the slightest thing to do with OO. Lots of OO
> languages out there do not have any of these features!
>
> This is exactly my point: you're blinded by Java. Generics in
> particular are ANTI-OO. Generic programming is completely orthogonal
> to OO. Read some of the literature. Read about the STL in C++.
>
> You CANNOT have overloading in a dynamically typed language.
>
> ColdFusion already has method overriding.
>
> Static methods have nothing to do with OO (they are in fact more
> procedural than OO).
>
> Casting types has nothing to do with OO - in a dynamic language, you
> don't NEED casts - the objects already behave the right way.
>   

~|
ColdFusion 8 beta – Build next generation applications today.
Free beta download on Labs
http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta

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