Re: [CFCDev] Composition and SQL

2005-01-28 Thread Sean Corfield
On Thu, 27 Jan 2005 12:40:27 -0500, Roland Collins [EMAIL PROTECTED] wrote: I would wager that none of them will be able to match the performance of custom-tailored SQL queries. They will the horribly inefficient code that winds up in most DAOs. Not necessarily horrible but many of thse trade

Re: [CFCDev] Composition and SQL

2005-01-28 Thread Joe Rinehart
The CF Query object is consumable from CF, Java, and .NET - those are our target platforms. It works quite nicely. I didn't realize it was consumable from anything other than CF but it's good to know. I haven't seen, or been able to consume a CFQuery directly from .NET - how've you been

RE: [CFCDev] Composition and SQL

2005-01-28 Thread Ben Rogers
Acutally, I think the proper description would be that the CF Query object is an object wrapping a data structure, but I think we're really just discussing semantics here :) The CFQuery object itself (coldfusion.sql.QueryTable) has much more functionality than is revealed by default - here

Re: [CFCDev] Composition and SQL

2005-01-28 Thread Bill Rawlinson
I have alwasy considered data types such as strings, integers, floats, etc to be objects that just come built in to the language - simple objects, perhaps, but objects none-the-less. Its kind of hard for me to explain but they do in fact model real world objects (words, sentencs, numbers, etc)

RE: [CFCDev] Composition and SQL

2005-01-28 Thread Ben Rogers
I have alwasy considered data types such as strings, integers, floats, etc to be objects that just come built in to the language - simple objects, perhaps, but objects none-the-less. A big problem I had when first trying to wrap my head around object oriented programming was that the

RE: [CFCDev] Composition and SQL

2005-01-28 Thread Roland Collins
) Next Debug.Write(vbCrLf) Next Works like a champ :) Roland -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Joe Rinehart Sent: Friday, January 28, 2005 7:48 AM To: cfcdev@cfczone.org Subject: Re: [CFCDev] Composition

RE: [CFCDev] Composition and SQL

2005-01-27 Thread Kerry
, elegant solution or nasty hack? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Roland Collins Sent: 27 January 2005 01:28 To: cfcdev@cfczone.org Subject: RE: [CFCDev] Composition and SQL Sorry for the double post (early ctrl-s on the last one

Re: [CFCDev] Composition and SQL

2005-01-27 Thread Stuart Miller
Of Roland Collins Sent: 27 January 2005 01:28 To: cfcdev@cfczone.org Subject: RE: [CFCDev] Composition and SQL Sorry for the double post (early ctrl-s on the last one). For performance reasons. I still use OOP as much as possible, but not the DAO pattern in particular. OOP and DAO/BO

Re: [CFCDev] Composition and SQL

2005-01-27 Thread Patrick McElhaney
On Thu, 27 Jan 2005 13:34:14 -, Kerry [EMAIL PROTECTED] wrote: yeah i know about argumentcollection, but i like being able to call the function like this: myobj.foo(form); just laziness on my part i guess (but it just looks nicer than myobj.foo(argumentcollection=form) !!!)

RE: [CFCDev] Composition and SQL

2005-01-27 Thread Ben Rogers
PROTECTED] On Behalf Of Joe Rinehart Sent: Wednesday, January 26, 2005 8:11 PM To: cfcdev@cfczone.org Subject: Re: [CFCDev] Composition and SQL LOL. Sorry if I helped start any of that back on the ColdFusion Day of the DAO. I think DAO/BO is a friendly place to start thinking about things

Re: [CFCDev] Composition and SQL

2005-01-27 Thread Joe Rinehart
On Thu, 27 Jan 2005 14:33:52 -, Kerry [EMAIL PROTECTED] wrote: But why make the rest of us programmers figure out your proprietary objArgs technique? in this particular case, my boss would be very happy if i made the app incomprehensible to anyone outside the company, but i see your

RE: [CFCDev] Composition and SQL

2005-01-27 Thread Kerry
To: cfcdev@cfczone.org Subject: Re: [CFCDev] Composition and SQL On Thu, 27 Jan 2005 14:33:52 -, Kerry [EMAIL PROTECTED] wrote: But why make the rest of us programmers figure out your proprietary objArgs technique? in this particular case, my boss would be very happy if i made the app

Re: [CFCDev] Composition and SQL

2005-01-27 Thread Joe Rinehart
Surely if the arguments are named,typed and/or required, then the outside world needs very in depth knowledge of what to pass? unlike in my scenario? (Keep in mind that this is all my opinion, and that I am still rather new at this as well.) The outside world knowing what you need to pass is

RE: [CFCDev] Composition and SQL

2005-01-27 Thread Nando
point down the road. I'm seeing the value of it more and more. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Kerry Sent: Thursday, January 27, 2005 5:12 PM To: cfcdev@cfczone.org Subject: RE: [CFCDev] Composition and SQL What if you grow hire a new

Re: [CFCDev] Composition and SQL

2005-01-27 Thread Doug Keen
in depth knowledge of what to pass? unlike in my scenario? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Joe Rinehart Sent: 27 January 2005 14:57 To: cfcdev@cfczone.org Subject: Re: [CFCDev] Composition and SQL On Thu, 27 Jan 2005 14:33:52 -

RE: [CFCDev] Composition and SQL

2005-01-27 Thread Kerry
Rinehart Sent: 27 January 2005 17:05 To: cfcdev@cfczone.org Subject: Re: [CFCDev] Composition and SQL Surely if the arguments are named,typed and/or required, then the outside world needs very in depth knowledge of what to pass? unlike in my scenario? (Keep in mind that this is all my opinion

RE: [CFCDev] Composition and SQL

2005-01-27 Thread Roland Collins
Inline comments :) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ben Rogers Sent: Thursday, January 27, 2005 9:25 AM To: cfcdev@cfczone.org Subject: RE: [CFCDev] Composition and SQL There are some relatively simple ways to solve that. Fowler addresses

Re: [CFCDev] Composition and SQL

2005-01-27 Thread Joe Rinehart
Option 1 means that you must write and maintain all insert/select/update/delete SQL for your app? Is that correct? Yes. Into every life a little SQL must fall. I think you'd find, however, that writing SQL for individual types to be persisted is less work than cooking a metadata scheme that

RE: [CFCDev] Composition and SQL

2005-01-26 Thread Roland Collins
I gotta ask - is there anyone else here that eschews the DAO pattern? This list is more about the DAO/BO pattern than CFC development anymore! :S -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Mandel Sent: Wednesday, January 26, 2005 7:16 PM To:

Re: [CFCDev] Composition and SQL

2005-01-26 Thread Mark Mandel
::: mumbles something about hijacked threads ::: :o( Mark On Thu, 27 Jan 2005 13:14:01 +1000, Darryl Lyons [EMAIL PROTECTED] wrote: Roland, For performance reasons. I still use OOP as much as possible, but not the DAO pattern in particular. OOP and DAO/BO in particular add a level of

RE: [CFCDev] Composition and SQL

2005-01-26 Thread Roland Collins
Sorry! I didn't mean it to go this far off! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Mandel Sent: Wednesday, January 26, 2005 10:23 PM To: cfcdev@cfczone.org Subject: Re: [CFCDev] Composition and SQL ::: mumbles something about hijacked