Re: do not increase counter is returns 0

2008-06-03 Thread Tom Chiverton
On Friday 30 May 2008, erik tom wrote: > not return returns a record then do not increase the counter (this part is > working) Also if the query.hours eq 0 and query.minutes eq 0 also should > not increase the counter > ? -- Tom Chiverton *

Re: Left Join on 4 Tables

2008-06-03 Thread Jason Congerton
Hi Thanks for your replys have tried the code and am getting the following error, Syntax error (missing operator) in query expression 'retailCustomer.retailCustID = retailOrders.ocustID LEFT JOIN retOrderItems ON retailOrders.orderNo = retOrderItems.piOrderNo LEFT JOIN products ON retOrderIte

RE: CSV Generation MEMORY SUCK

2008-06-03 Thread Brad Wood
I wonder what Java string objects are used when you create a large string by outputting inside a cfsavecontent. I'm sure ColdFusion implements strings the way it does because it was found to be the most efficient method for the majority of programming needs. ~Brad -Original Message- Fr

Re: CSV Generation MEMORY SUCK

2008-06-03 Thread Brian Kotek
Probably because it can't know if that's what you actually want to do. We probably need a new function StringAppend or something that would be able to do this. Might be time to hit the wish list! ;-) On Tue, Jun 3, 2008 at 4:36 AM, Tom Chiverton <[EMAIL PROTECTED]> wrote: > On Monday 02 Jun 2008

Re: Guide for reviewing a website

2008-06-03 Thread Richard Dillman
Oh Yea, The absolute first thing I do with any newly inherited site is to view it via Firefox with a few plug ins: - Cold Fire - Firebug - Firefox accessibility extension - HTML Validator - Kgen - Load time Validator - SE Open - Window Resizer - YSlow Not to hijack a t

Re: ColdFusion 6.1 installer?

2008-06-03 Thread Gerald Guido
>>Dave, you're the bomb. Thanks. +1 on Dave's Bomb-iness. G$ On Mon, Jun 2, 2008 at 6:15 PM, Willy Ray <[EMAIL PROTECTED]> wrote: > Dave, you're the bomb. Thanks. > > /w > > -- "The important thing in science is not so much to obtain new facts as to discover new ways of thinking about them."

RE: CFAdmin API reference?

2008-06-03 Thread Andy Matthews
Yep...after I fully read the thread on your site, I remembered that I could get the info via the browser. There's some kickass stuff in that server monitor CFC. andy -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 03, 2008 8:34 AM To: CF-Talk Sub

Re: Left Join on 4 Tables

2008-06-03 Thread Aaron Rouse
I sometimes will put an AND in my JOIN clause in order to work around that, something like LEFT JOIN products ON retOrderItems.piProductID = products.productID AND (products.productID) = #scPdname# Although not sure if that works with all databases. On Tue, Jun 3, 2008 at 6:27 AM, Matt Williams

Re: CFAdmin API reference?

2008-06-03 Thread Raymond Camden
Just view the CFCs in your browser. Remember they are self-documenting. Unfortunately that is the best you will get. On Tue, Jun 3, 2008 at 8:23 AM, Andy Matthews <[EMAIL PROTECTED]> wrote: > I found a small reference on Ray Camden's site, but it's not comprehensive. > Is there something, anywher

Re: CFAdmin API reference?

2008-06-03 Thread Andy Matthews
I found a small reference on Ray Camden's site, but it's not comprehensive. Is there something, anywhere, that contains a list of all of the methods available? I'm specifically looking at the methods which would allow me to get information about active sessions, and memory usage. > I'm looking

CFAdmin API reference?

2008-06-03 Thread Andy Matthews
I'm looking to gain access to the CFAdmin API for some basic stats about our servers. Where would be the best place to go to get that info? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date G

Re: Left Join on 4 Tables

2008-06-03 Thread Matt Williams
Try this. Note that if you use a where on one of the left joined tables it kind of negates the "left" part of that. One way around this is to add "or x is null" FROM retailCustomer LEFT JOIN retailOrders ON retailCustomer.retailCustID = retailOrders.ocustID LEFT JOIN retOrderItems ON retailOrders.

Left Join on 4 Tables

2008-06-03 Thread Jason Congerton
Hi I need to query four tables and return all the results from the retailCustomer table regardless of matching records in retailOrders, retOrderItems and products. The innner join query i use is below (please note i will individually reference items in select stat. once i get this right, as wel

Re: CSV Generation MEMORY SUCK

2008-06-03 Thread Tom Chiverton
On Monday 02 Jun 2008, Rick Root wrote: > I found a nice little java class library called JavaCSV that handles all > the file writing and dropped my time from 68 seconds to 18 seconds. That > has potential! Why CF can't translate '&' to a StringBuffer append I'll never know... -- Tom Chiverton

<    1   2