Re: Web Team Project Management App

2004-08-07 Thread Matthew Fusfield
We've been pretty happy with dotProject (http://www.dotproject.net/) While not written in CF, it is pretty flexible and you can customize the PHP code to do whatever you need. Matt - Original Message - From: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: Fri, 06 Aug 2004 18:15:45 + Subje

Re: MySQL query help

2004-08-07 Thread Jochem van Dieten
Marco Antonio C. Santos wrote: > How can I do MySQL works fine with this simple query: > > SELECT DISTINCT User_ID,(SELECT Count(User_ID) FROM users p1 WHERE > p1.User_ID = users.User_ID) AS CountID > FROM users SELECT User_ID, count(User_ID) FROM users GROUP BY User_ID Jochem [Todays Threads]

Re: query Problem

2004-08-07 Thread S . Isaac Dealey
> TRANSFORM > sum (dp.cantidad) as totalt > select sum (dp.cantidad) as total, dp.idproducto as codigo > from pedidos p, detallesdepedido dp > where p.idpedido=dp.idpedido > and p.mesenvio = 7 > group by dp.idproducto > PIVOT > p.diaenvio > In CFMX i can make a query like this, if i can how i

RE: Can the following be written in cfscript?

2004-08-07 Thread Joe Eugene
"and cfml list loop is even more efficient than array..." WOW!... There must be something really wrong with the CFMX Implementation of Arrays. That is completely backwards to Java Implementation. Bruce Eckel's (Thinking in Java) compares the Collection Classes and i believe mentions... There is N

BLACKSTONE Sneak Preview Posted

2004-08-07 Thread dcooper
http://www.macromedia.com/software/coldfusion/ A few of the new ColdFusion "Blackstone" release features are discussed in some detail.   Enjoy! Damon Cooper Dir of Eng, ColdFusion Macromedia [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settin

RE: Can the following be written in cfscript?

2004-08-07 Thread Jim Davis
First off it's only sometimes the case that a CFML list loop is more efficient than an array.  In most of the cases that it is the hit comes in the form of converting/creating the array.  This seems natural: it should take less time to assign a string value than to create an array.  So while using

RE: Can the following be written in cfscript?

2004-08-07 Thread S . Isaac Dealey
> "and cfml list loop is even more efficient than array..." > WOW!... There must be something really wrong with the CFMX > Implementation of > Arrays. > That is completely backwards to Java Implementation. Bruce > Eckel's (Thinking > in Java) > compares the Collection Classes and i believe mention

RE: Can the following be written in cfscript?

2004-08-07 Thread S . Isaac Dealey
> Lastly it may also be that you're right.  CF Arrays aren't > Java Arrays. > They're counted from 1, not zero.  They're passed by value > not by reference > (which I wish would change).  I'm not sure what's under > the covers to do > this "conversion".  I assume, at least for looping, that > it's

RE: Can the following be written in cfscript?

2004-08-07 Thread Jim Davis
I agree completely - the argument is always that you can't change something so fundamental because you don't know how people've used it. I applaud, mostly, MM's desire to remain as backwards compatible as possible.  Sometimes it's just awkward tho'.  ;^) Jim Davis If they changed the behavior of

Re: Can the following be written in cfscript?

2004-08-07 Thread Dave Carabetta
On Sat, 7 Aug 2004 10:59:25 -0400, Joe Eugene <[EMAIL PROTECTED]> wrote: > "and cfml list loop is even more efficient than array..." > > WOW!... There must be something really wrong with the CFMX Implementation of > Arrays. > That is completely backwards to Java Implementation. Bruce Eckel's (Thin

Re: CFHEADER and IE showing wrong file and FireFox 0 Bytes

2004-08-07 Thread Jochem van Dieten
It is well known that IE is broken. MS made it gues the content of the response based on the first X bytes instead of following RFC 2616 19.5.1. Do you have a URL so we can observe the FireFox behaviour? Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Set

Redistribute CF Runtime was: BLACKSTONE Sneak Preview Posted

2004-08-07 Thread Dick Applebaum
Damon Thanks for the post Some very nice, and much anticipated capabilities. One thing that is of particular interest (to me) is in the next to last paragraph: Java Application Deployment   With ColdFusion MX, you can already deploy ColdFusion as a Java archive (EAR  or WAR file) and then

RE: Can the following be written in cfscript?

2004-08-07 Thread S . Isaac Dealey
> I agree completely - the argument is always that you can't > change something > so fundamental because you don't know how people've used > it. > I applaud, mostly, MM's desire to remain as backwards > compatible as > possible.  Sometimes it's just awkward tho'.  ;^) Yea... I often wish they wer

Re: Can the following be written in cfscript?

2004-08-07 Thread Dick Applebaum
Can't resist getting in on this. On Aug 7, 2004, at 11:05 AM, S. Isaac Dealey wrote: > > I agree completely - the argument is always that you can't >  > change something >  > so fundamental because you don't know how people've used >  > it. > >  > I applaud, mostly, MM's desire to remain as backw

RE: Can the following be written in cfscript?

2004-08-07 Thread Tangorre, Michael
Good points. It would be very cool to see this in a future release; maybe NewAtlanta will offer it first, putting the pressure on MM. :-) Michael T. Tangorre   > One way this has been done, historically, with other products, is to > support both new implementations and prior implementations with

Re: Redistribute CF Runtime was: BLACKSTONE Sneak Preview Posted

2004-08-07 Thread dcooper
All great questions...what's on the Macromedia ColdFusion website is all we can talk about publicly so far.   Licensing, editioning, pricing and packaging details haven't yet been announced. >Damon > >Thanks for the post > >Some very nice, and much anticipated capabilities. > >One thing that is o

Re: Redistribute CF Runtime was: BLACKSTONE Sneak Preview Posted

2004-08-07 Thread Dick Applebaum
Ok! Is there a separate wishlist for Blackstone, if so where? Dick On Aug 7, 2004, at 11:59 AM, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: > All great questions...what's on the Macromedia ColdFusion website is > all we can talk about publicly so far.   > >  Licensing, editioning, pricing and

Re: Redistribute CF Runtime was: BLACKSTONE Sneak Preview Posted

2004-08-07 Thread dcooper
We don't have a Blackstone-specific wishlist setup, but we do review submissions to the regular wishlist here: http://www.macromedia.com/support/email/wishform/ >Ok! > >Is there a separate wishlist for Blackstone, if so where? > >Dick > >On Aug 7, 2004, at 11:59 AM, [EMAIL PROTECTED] >[EMAIL PRO

Re: Can the following be written in cfscript?

2004-08-07 Thread Peter Farrell
Big question... I've been writing a lot in cfscript lately.  Seems easier a lot of the time, especially when writing long logic blocks and it can be a lot easier to read.  Is MM going to do away with cfscript or should I write more in CFML. [Todays Threads] [This Message] [Subscription] [Fas

Re: Pulling results from 1 Text field and 2 Select Lists

2004-08-07 Thread Joe Rinehart
Hey Steve, At first glance, you need to partition off the seperate conditional queries in your clause. This should help: SELECT * FROM tblLawyers WHERE 0=0  AND LName LIKE '%#FORM.LName#%'  AND ( County1 LIKE '%#FORM.County#%' OR County2 LIKE '%#FORM.County#%'    

Count logged in user sessions

2004-08-07 Thread Ewok
This has got to be possible. Seems like I remember the question being asked before but can't seem to word it right in the archives to get any results. Anyone know a link or a solution? I am using sessions to log people in and keep them logged in. There must be a way to count active sessions right?

Re: Can the following be written in cfscript?

2004-08-07 Thread Dave Carabetta
On Sat, 07 Aug 2004 17:44:54 -0400, Peter Farrell <[EMAIL PROTECTED]> wrote: > Big question... > I've been writing a lot in cfscript lately.  Seems easier a lot of the time, especially when writing long logic blocks and it can be a lot easier to read.  Is MM going to do away with cfscript or should

RE: Can the following be written in cfscript?

2004-08-07 Thread Jim Davis
I'm not sure why you'd ask the question.  What have you heard to make you worry? CFSCRIPT appeared in CF 4.x - it's "newer" than CFML and a core part of the language.  They really couldn't get rid of it at all easily. That being said the other side of the coin is also true: it doesn't appear as i

Re: Count logged in user sessions

2004-08-07 Thread Dave Carabetta
On Sat, 7 Aug 2004 18:15:08 -0400, Ewok <[EMAIL PROTECTED]> wrote: > This has got to be possible. Seems like I remember the question being asked before but can't seem to word it right in the archives to get any results. Anyone know a link or a solution? > > I am using sessions to log people in and

RE: Pulling results from 1 Text field and 2 Select Lists

2004-08-07 Thread Steve Sawyer
Joe, That was just the ticket!  Thanks!! It is by design that they are limited to 4. Thanks again.   _   From: Joe Rinehart [mailto:[EMAIL PROTECTED] Sent: Saturday, August 07, 2004 3:07 PM To: CF-Talk Subject: Re: Pulling results from 1 Text field and 2 Select Lists Hey Steve, At first

Re: Web Team Project Management App

2004-08-07 Thread Mike Alberts
I second a vote for dotProject. I tried out dozens of open source project management apps awhile ago and this was the one that I thought was the best all around package. Looks nice, runs well and easy to use. Cheers, Mike >We've been pretty happy with dotProject (http://www.dotproject.net/) >Whi

Outputting to Excel Question

2004-08-07 Thread Les Mizzell
I'm outputting a file to Excel like this:     SELECT * FROM CAT_ORD     --->    DATE    NAME    ...more columns    #HN_DATE#    #HN_Name#    ...more columns Is working sorta OK. Got a question 1. One field comes in as a list. I'd like all the values in that list to end up in one

Count logged in user sessions

2004-08-07 Thread Ewok
Doesn't look like this came through the first time... if its double posted you can hang me by my ... ummm...parts This has got to be possible. Seems like I remember the question being asked before but can't seem to word it right in the archives to get any results. Anyone know a link or a solution?

Re: Count logged in user sessions

2004-08-07 Thread Ewok
Looks promising, I'll give it a whirl. Thanks for the link   - Original Message -   From: Dave Carabetta   To: CF-Talk   Sent: Saturday, August 07, 2004 6:21 PM   Subject: Re: Count logged in user sessions   On Sat, 7 Aug 2004 18:15:08 -0400, Ewok <[EMAIL PROTECTED]> wrote:   > This has

Re: Can the following be written in cfscript?

2004-08-07 Thread Dick Applebaum
In a way, that is odd: 1) cfscript resembles is based on _javascript_ 2) so is Flash ActionScript 3) both cfml and ActionScript interface _javascript_ contained in html You would think it would benefit developers using MM products to have a common scripting language. It has always bothered me t

Is this possible with CFMX or BD?

2004-08-07 Thread Dick Applebaum
You can execute scripts most scripting languages (Perl, PHP, Python, Ruby, Tcl, OASscript, etc.) from the command line with something like: #!/usr/bin/php /* Some PHP script */ function SomePHPFunction($someVar)   {  $myVar=$someVar + $someVar;  return $myVar;   } * * * This can be qu

RE: Is this possible with CFMX or BD?

2004-08-07 Thread Jim Davis
In the pre-mx work you could do this by passing the template to the CF Executable (something like "cfserver.exe /myTemplate.cfm", but I forget the exact syntax).  And you're right - it was very useful.  ;^) In the MX world things aren't that simple.  You can't just call a template from the command

Toggling Insert key off and on

2004-08-07 Thread Arden Weiss
Is there a way to determine the setting of the Insert key and toggle it to either off or on -- on entry to a form -- I assume it is done with _javascript_ -- need the script. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Test

2004-08-07 Thread JWest
This is just a test, please don't respond Jason [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Re: Can the following be written in cfscript?

2004-08-07 Thread S . Isaac Dealey
> Sooner or later, backwards compatibility inhibits > progress.  Macromedia > will need to address the BC issue or others will > NewAtlanta has an > advantage, here because they do not (necessarily) need to > worry about > protecting  an install base of older versions. > One way this has been done

Re: Test

2004-08-07 Thread S . Isaac Dealey
> This is just a test, please don't respond > Jason Okay I won't... D'oh! s. isaac dealey 954.927.5117 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.sys-con.com/story/?storyid=44477&DE=1 http://www.sys-con.com/story/?s

Re: Test

2004-08-07 Thread JWest
LOL! I was just checking to see if this mail list server was going to have an issue with my Lotus Notes account. Thanks for the reply Jason S. Isaac Dealey <[EMAIL PROTECTED]> wrote on 08/07/2004 20:42:15: > > This is just a test, please don't respond > > > Jason > > Okay I won't... D'oh! >

Re: Test

2004-08-07 Thread S . Isaac Dealey
You're welcome. D'oh! > LOL! I was just checking to see if this mail list server > was going to have > an issue with my Lotus Notes account. > Thanks for the reply > Jason > S. Isaac Dealey <[EMAIL PROTECTED]> wrote on 08/07/2004 > 20:42:15: >> > This is just a test, please don't respond >> >>

RE: Can the following be written in cfscript?

2004-08-07 Thread Dave Watts
> I'm just demonstrating that often when people say "this is faster > than that" it's not the primitive thing they're talking about their > implementation of it: even in simple testing code can often be > optimized. More importantly, though, most of the "which is faster" stuff is practically us

Re: Toggling Insert key off and on

2004-08-07 Thread S . Isaac Dealey
> Is there a way to determine the setting of the Insert key > and toggle it to either off or on -- on entry to a form -- > I assume it is done with _javascript_ -- need the script. No there's not. At least none that I'm aware of, and given the state of browser "security" nowadays, I wouldn't expec

RE: Can the following be written in cfscript?

2004-08-07 Thread Dave Watts
> In a way, that is odd: > > 1) cfscript resembles is based on _javascript_ > 2) so is Flash ActionScript > 3) both cfml and ActionScript interface _javascript_ contained in html > > You would think it would benefit developers using MM products to > have a common scripting language. > > It has alw

RE: Can the following be written in cfscript?

2004-08-07 Thread Dave Watts
> I've been writing a lot in cfscript lately. Seems easier a lot of the > time, especially when writing long logic blocks and it can be a lot > easier to read. Is MM going to do away with cfscript or should I write > more in CFML. I wouldn't worry about CFSCRIPT going away - the CF development tea

Re: Can the following be written in cfscript?

2004-08-07 Thread Dick Applebaum
I only meant that they added a new feature by including it within tags -- that are, essentially, compiler directives. Dick On Aug 7, 2004, at 5:40 PM, S. Isaac Dealey wrote: >  > On reflection, though this is exactly the way that they >  > added scripting with ... > >  Say what? cfscript has no

RE: Can the following be written in cfscript?

2004-08-07 Thread Dave Watts
> Sooner or later, backwards compatibility inhibits progress.   > Macromedia will need to address the BC issue or others will Unfortunately, we all have different definitions of progress. Most of the things that people have mentioned in this thread - NULL values, strong typing, etc - are things th

RE: Can the following be written in cfscript?

2004-08-07 Thread S . Isaac Dealey
> That being said the other side of the coin is also true: > it doesn't appear > as if they're particularly anxious to add to CFSCRIPT, > either.  ;^) Well yea, they created CFFUNCTION to be an end-run around the need to support more featurees in cfscript... I understand why they took that approac

Re: Toggling Insert key off and on

2004-08-07 Thread Arden Weiss
Bummer :-) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Re: Can the following be written in cfscript?

2004-08-07 Thread S . Isaac Dealey
Well if you included in a template executed on a CF3 server, the page would produce an error, so I guess I'm still unsure how that equates to ... or your saying that their addition of cfscript in version 4 was exactly that sort of phenomenon... :-/ ... I'm confused. > I only meant that they adde

Re: Toggling Insert key off and on

2004-08-07 Thread Arden Weiss
Guess the follow-up question is how to clear spaces behind cursor when entering data into a field -- a script to remove trailing spaces as the user types. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

RE: Can the following be written in cfscript?

2004-08-07 Thread S . Isaac Dealey
>> Sooner or later, backwards compatibility inhibits >> progress. >> Macromedia will need to address the BC issue or others >> will > Unfortunately, we all have different definitions of > progress. Most of the > things that people have mentioned in this thread - NULL > values, strong > typing, etc

Re: Toggling Insert key off and on

2004-08-07 Thread S . Isaac Dealey
> Bummer :-) Yea, sorry. :) s. isaac dealey 954.927.5117 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.sys-con.com/story/?storyid=44477&DE=1 http://www.sys-con.com/story/?storyid=45569&DE=1 http://www.fusiontap.com [To

Re: Toggling Insert key off and on

2004-08-07 Thread S . Isaac Dealey
> Guess the follow-up question is how to clear spaces behind > cursor when entering data into a field -- a script to > remove trailing spaces as the user types. I don't believe there's a DOM standard way to do this (at least that I know of)... IE has an onKeyUp attribute, which would be a nice add

Re: Can the following be written in cfscript?

2004-08-07 Thread Dick Applebaum
I haven't been clear... sorry, my bad! To me, backward compatibility means a new version runs prior version code just like the prior version -- not that the new version additions will run on a prior version. I meant that new version of CF could accept prior version syntax, assumptions. etc, by

RE: Can the following be written in cfscript?

2004-08-07 Thread Dave Watts
> To me, backward compatibility means a new version runs prior version > code just like the prior version -- not that the new version additions > will run on a prior version. > > I meant that new version of CF could accept prior version syntax, > assumptions. etc, by enclosing the target code wi

Re: Toggling Insert key off and on

2004-08-07 Thread Arden Weiss
Thanks for pointing me in the right direction. At minimum I can do a trim of the field contents on screen display and then use the kind of script you suggest to omit trailing spaces. Alternatively, I could just increase the max length of the field to double the number of allowable characters and

forms and sub-forms best practices feedback desired

2004-08-07 Thread Arden Weiss
In many cases I have a master form/page with a dozen or so fields. On the master form/page I also have one or more buttons that call sub-forms/pages for purposes of maintaining multiple records associated with the master form/record (in a one to many relationship). The question I have is "What i

Re: Can the following be written in cfscript?

2004-08-07 Thread Dick Applebaum
Aw c'mon Dave -- be reasonable, application.cfm & onRequestEnd.cf, Even I can understand that. Dick On Aug 7, 2004, at 7:29 PM, Dave Watts wrote: > > To me, backward compatibility means a new version runs prior version >  > code just like the prior version -- not that the new version > additio

Re: BLACKSTONE Sneak Preview Posted

2004-08-07 Thread Don
Question, for the "Sourceless Deployment", is it possible to have "mixed mode", that is, say, 99% code are compiled while leaving one or two templates like application.cfm source code editable?  TIA. > http://www.macromedia.com/software/coldfusion/ > > A few of the new ColdFusion "Blackstone" rel

Re: BLACKSTONE Sneak Preview Posted

2004-08-07 Thread Dick Applebaum
O... good point. Would save a lot of 1-time configuration coding to define datasources, etc. -- very important! Dick On Aug 7, 2004, at 8:01 PM, Chunshen Li (Don) wrote: > Question, for the "Sourceless Deployment", is it possible to have > "mixed mode", that is, say, 99% code are compiled

Re: forms and sub-forms best practices feedback desired

2004-08-07 Thread Ewok
I guess that's up to you. I just did a form with MANY steps, after I validated each step and made sure all values entered were ok, I dumped the entire form results into a session structure (Thanks to a tip from a fellow cftalker it was extremely simple) as for keeping the data in the f

Val function seems buggy

2004-08-07 Thread Don
The value of dtgVar is 21 instead of 021, 021 is correct.  I have workaround to circumvent the problem though. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Re: Val function seems buggy

2004-08-07 Thread Claude Schneegans
>>The value of dtgVar is 21 instead of 021 This is another "advantage" of lousely typed language. CF is worse than lousely typed: it is "let me guess the type" :-( -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm

Re: Is this possible with CFMX or BD?

2004-08-07 Thread Dick Applebaum
Thanks Jim That gets me pointed in the right direction ... little browsers... on the desktop... little browsers, made of ticky-tacky... (paraphrasing an old Malvina Reynolds song) I was trying to figure out what the webserver (apache) connector was doing. But these little browsers are OK --

Re: forms and sub-forms best practices feedback desired

2004-08-07 Thread Arden Weiss
Very nice -- Thanks Hope to get some more inputs -- this ole brain needs all the help it can get and then some :-)) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Re: BLACKSTONE Sneak Preview Posted

2004-08-07 Thread Sean Corfield
"Sourceless Deployment" sounds like "deployment without source" which by definition would not leave Application.cfm editable... On Sat, 07 Aug 2004 23:01:11 -0400, Chunshen (Don) Li <[EMAIL PROTECTED]> wrote: > Question, for the "Sourceless Deployment", is it possible to have "mixed mode", that is

Re: forms and sub-forms best practices feedback desired - Michael Tangorre

2004-08-07 Thread Ewok
Sorry it was eating at me that I couldnt remember the name of the "fellow cftalker" who showed me this nice little trick it was Michael Tangorre http://www.houseoffusion.com/cf_lists/messages.cfm/threadid=33884&forumid=4 - Original Message -   From: Arden Weiss   To: CF-Talk   Sent

Re: Is this possible with CFMX or BD?

2004-08-07 Thread Sean Corfield
On Sat, 7 Aug 2004 20:11:08 -0400, Jim Davis <[EMAIL PROTECTED]> wrote: > In the MX world things aren't that simple.  You can't just call a template > from the command line like you used to.  However you can still call CF > Templates via the web server (as always) - and there's a few tools that let

Re: CFHEADER and IE showing wrong file and FireFox 0 Bytes

2004-08-07 Thread Carl V
Ahh ok...if I hard code the file it just plays instead of downloading (IE only)..is there a way around this? or does this come under the same issue (and yes I have tried both "inline" and "attachment") and both don't work... No there is no URL cause it would breach the privacy, so sorry.. >It is

Re: Is this possible with CFMX or BD?

2004-08-07 Thread Dick Applebaum
On Aug 7, 2004, at 9:17 PM, Sean Corfield wrote: > On Sat, 7 Aug 2004 20:11:08 -0400, Jim Davis >  <[EMAIL PROTECTED]> wrote: >  > In the MX world things aren't that simple.  You can't just call a > template >  > from the command line like you used to.  However you can still call > CF >  > Templ

RE: BLACKSTONE Sneak Preview Posted

2004-08-07 Thread Jim Davis
This kind of deployment is common in the J2EE world - there's rarely any source. In most applications many of the things that you'd normally find in Application.cfm are kept in property files (usually XML) - that way changes can be made to application without recompiling. It does take a little ef

RE: Is this possible with CFMX or BD?

2004-08-07 Thread Jim Davis
I've had conversations about this kind of stuff with Mike Nimer in the past. It's one of those things that people either really want or just see no need for at all. One thing I would REALLY LOVE is the ability to call CF from Windows Scripting Host.  I hope somebody smarter than I will take the in

RE: Val function seems buggy

2004-08-07 Thread Jim Davis
I dunno - that seems right to me.  The Val() function returns the value, not the "digits" - I would expect it to only return significant digits.  After all the value of "021" is "21" just as the value of "021" is "21". Jim Davis From: Claude Schneegans [mailto:[EMAIL PROTECTED]