Re: ColdFusion for Dummies revision - CF5 features... CFSQL

2000-12-06 Thread Jon Hall
I hope for one that CFSQL supports the DISTINCT statement. Would make those category drop downs a breeze... jon - Original Message - From: "Dave Watts" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, December 05, 2000 6:03 PM Subject: RE: ColdFusion

RE: ColdFusion for Dummies revision - CF5 features

2000-12-05 Thread Dave Watts
| b.. Ability to run queries against existing query result sets (CFSQL). I don't understand the need for that. Couldn't you just run another query? Or is it some sort of performance issue thing since the query is in memory? Since the query is stored in memory (I assume resident

Re: ColdFusion for Dummies revision - CF5 features

2000-12-05 Thread pan
[Lots of message chaff on the list lately, can't find new messages amidst all the echoed old posts] From: "Dave Watts" [EMAIL PROTECTED] Sent: Monday, December 04, 2000 20:05 Subject: RE: ColdFusion for Dummies revision - CF5 features When Allaire puts in an SQL analyzer, it'

RE: ColdFusion for Dummies revision - CF5 features

2000-12-05 Thread Duane Boudreau
| b.. Ability to run queries against existing query result sets (CFSQL). I don't understand the need for that. Couldn't you just run another query? Or is it some sort of performance issue thing since the query is in memory? Since the query is stored in memory (I assume

RE: ColdFusion for Dummies revision - CF5 features

2000-12-05 Thread Dave Watts
Absent good information we've been speculating about the CF5 ability to query a query. It may not be written to emulate anything and to do no more than allow simple look-ups and other low-level ops that are not currently part of the functions toolbox. Has anyone stated that we are

Re: ColdFusion for Dummies revision - CF5 features

2000-12-04 Thread Alex Aguilar
Taken from CFVault's summary of Allaire DevCon: [http://www.cfvault.com/index.cfm/mode/DisplayContent/ContentElementID/64/El ementPage/2] CF 5.0 will be built on the existing codebase, and released during the first half of 2001. It is NOT part of the Pharaoh initiative, the next generation of

Re: ColdFusion for Dummies revision - CF5 features

2000-12-04 Thread Todd Ashworth
uilar" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, December 04, 2000 3:10 PM Subject: Re: ColdFusion for Dummies revision - CF5 features | Taken from CFVault's summary of Allaire DevCon: | [http://www.cfvault.com/index.cfm/mode/DisplayContent/ContentElementID/64/El |

Re: ColdFusion for Dummies revision - CF5 features

2000-12-04 Thread Jamie Keane
704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: Alex Aguilar [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Monday, December 04, 2000 1:38 PM Subject: Re: ColdFusion for Dummies revision - CF5 features Taken from CFVault's summary of Allaire DevCon: [http

Re: ColdFusion for Dummies revision - CF5 features

2000-12-04 Thread pan
From: "Todd Ashworth" [EMAIL PROTECTED] Subject: Re: ColdFusion for Dummies revision - CF5 features | b.. Ability to run queries against existing query result sets (CFSQL). I don't understand the need for that. Couldn't you just run another query? Or is it some sort of p

Re: ColdFusion for Dummies revision - CF5 features

2000-12-04 Thread Neil H.
TECTED] Sent: Monday, December 04, 2000 1:50 PM Subject: Re: ColdFusion for Dummies revision - CF5 features | b.. Ability to run queries against existing query result sets (CFSQL). I don't understand the need for that. Couldn't you just run another query? Or is it some sort of performan

RE: ColdFusion for Dummies revision - CF5 features

2000-12-04 Thread Duane Boudreau
Technologies Ektron, Inc. Todd Ashworth - Original Message - From: "Alex Aguilar" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, December 04, 2000 3:10 PM Subject: Re: ColdFusion for Dummies revision - CF5 features | Taken from CFVault's summa

Re: ColdFusion for Dummies revision - CF5 features

2000-12-04 Thread Jamie Keane
Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: Todd Ashworth [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Monday, December 04, 2000 3:34 PM Subject: Re: ColdFusion for Dummies revision - CF5 featur

Re: ColdFusion for Dummies revision - CF5 features

2000-12-04 Thread Peter Theobald
It will also be nice to be able to sort the data on a page, or even on a multi-page data set without going back to the database server. At 12:39 PM 12/4/00 -0800, pan wrote: From: "Todd Ashworth" [EMAIL PROTECTED] Subject: Re: ColdFusion for Dummies revision - CF5 features | b

Re: ColdFusion for Dummies revision - CF5 features

2000-12-04 Thread pan
Since the query is stored in memory (I assume resident only while the page is processing) you would be running your sub queries against memory. This would be a big time performance boost over running traditional queries because of the difference between the speed of memory access vs. db