Re: CSV Generation MEMORY SUCK
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 This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.com. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306685 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Left Join on 4 Tables
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 well as using query
params) I get errors when trying to create the left joins, any ideas?
Thanks
cfquery name=getCustomers2008 datasource=#application.dsn#
SELECT retailCustomer.*, retailOrders.*, retOrderItems.*, products.*
FROM products INNER JOIN ((retailCustomer INNER JOIN retailOrders ON
retailCustomer.retailCustID = retailOrders.ocustID) INNER JOIN retOrderItems ON
retailOrders.orderNo = retOrderItems.piOrderNo) ON products.productID =
retOrderItems.piProductID
WHERE 0=0
cfif IsDefined('FORM.scCounty') AND FORM.scCounty NEQ
AND (retCustCounty) LIKE '%#scCounty#%'/cfif
cfif IsDefined('FORM.scpdName') AND FORM.scpdName NEQ 1
AND (products.productID) = #scPdname#/cfif
/cfquery
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306686
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Left Join on 4 Tables
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.orderNo = retOrderItems.piOrderNo
LEFT JOIN products ON retOrderItems.piProductID = products.productID
WHERE 0=0
cfif IsDefined('FORM.scCounty') AND FORM.scCounty NEQ
AND (retCustCounty) LIKE '%#scCounty#%'/cfif
cfif IsDefined('FORM.scpdName') AND FORM.scpdName NEQ 1
AND (products.productID) = #scPdname# OR products.productID IS NULL
/cfif
On Tue, Jun 3, 2008 at 4:15 AM, Jason Congerton
[EMAIL PROTECTED] wrote:
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
well as using query params) I get errors when trying to create the left
joins, any ideas?
Thanks
cfquery name=getCustomers2008 datasource=#application.dsn#
SELECT retailCustomer.*, retailOrders.*, retOrderItems.*, products.*
FROM products INNER JOIN ((retailCustomer INNER JOIN retailOrders ON
retailCustomer.retailCustID = retailOrders.ocustID) INNER JOIN retOrderItems
ON retailOrders.orderNo = retOrderItems.piOrderNo) ON products.productID =
retOrderItems.piProductID
WHERE 0=0
cfif IsDefined('FORM.scCounty') AND FORM.scCounty NEQ
AND (retCustCounty) LIKE '%#scCounty#%'/cfif
cfif IsDefined('FORM.scpdName') AND FORM.scpdName NEQ 1
AND (products.productID) = #scPdname#/cfif
/cfquery
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306687
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFAdmin API reference?
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 Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306688 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFAdmin API reference?
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, 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 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 Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306690 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFAdmin API reference?
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 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 Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306689 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CSV Generation MEMORY SUCK
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- From: Brian Kotek [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 03, 2008 10:12 AM To: CF-Talk Subject: Re: CSV Generation MEMORY SUCK 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! ;-) ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306696 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Left Join on 4 Tables
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
retOrderItems.piProductID = products.productID'.
Tried troubleshooting but to no avail.
Jason
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.orderNo = retOrderItems.piOrderNo
LEFT JOIN products ON retOrderItems.piProductID = products.productID
WHERE 0=0
cfif IsDefined('FORM.scCounty') AND FORM.scCounty NEQ
AND (retCustCounty) LIKE '%#scCounty#%'/cfif
cfif IsDefined('FORM.scpdName') AND FORM.scpdName NEQ 1
AND (products.productID) = #scPdname# OR products.productID IS NULL
/cfif
On Tue, Jun 3, 2008 at 4:15 AM, Jas
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306697
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: do not increase counter is returns 0
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 cfif getTimeAvg1.recordcount gt 0 cfif getTimeAvg1.recordcount gt 0 and query.hours neq 0 and query.mineutes neq 0 ? -- Tom Chiverton This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.com. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306698 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CSV Generation MEMORY SUCK
On Tuesday 03 Jun 2008, Brian Kotek wrote: 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! ;-) I'm leaving for Scotch on the Rocks in ~12 hours, where a fair chunk of the CF9 team are hosting a BOF session :-) -- Tom Chiverton This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.com. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306699 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: market rates
On Saturday 31 May 2008, Richard White wrote: we are based in the UK, does anyone know of anywhere we could go to fund out the current market rates for coldfusion and mysql web application developers? Ring a company that offers a CF coding service and pretend your a potential customer ? -- Tom Chiverton This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.com. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306700 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Left Join on 4 Tables
Not sure what is up. It's kinda difficult without having the actual
tables set up. Can you post the entire query you have again?
One way to troubleshoot would be to build one join at a time. Start
with the Customer table, join Orders and test; Then join OrderItems
and test, etc.
Matt
On Tue, Jun 3, 2008 at 10:18 AM, Jason Congerton
[EMAIL PROTECTED] wrote:
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
retOrderItems.piProductID = products.productID'.
Tried troubleshooting but to no avail.
Jason
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.orderNo = retOrderItems.piOrderNo
LEFT JOIN products ON retOrderItems.piProductID = products.productID
WHERE 0=0
cfif IsDefined('FORM.scCounty') AND FORM.scCounty NEQ
AND (retCustCounty) LIKE '%#scCounty#%'/cfif
cfif IsDefined('FORM.scpdName') AND FORM.scpdName NEQ 1
AND (products.productID) = #scPdname# OR products.productID IS NULL
/cfif
On Tue, Jun 3, 2008 at 4:15 AM, Jas
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306701
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: do not increase counter is returns 0
If Erik would bother to read even the most basic book on SQL he could answer this himself since this could all be done in a couple of lines of SQL with no loops and no CFML at all. But he'd rather waste everyone else's time instead of spending 10 dollars. So please don't encourage him, Tom. ;-) On Tue, Jun 3, 2008 at 11:26 AM, Tom Chiverton [EMAIL PROTECTED] wrote: 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 cfif getTimeAvg1.recordcount gt 0 cfif getTimeAvg1.recordcount gt 0 and query.hours neq 0 and query.mineutes neq 0 ? -- Tom Chiverton This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.com. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306702 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: ColdFusion 6.1 installer?
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. - Sir William Bragg ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306693 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Left Join on 4 Tables
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 cfif IsDefined('FORM.scpdName') AND FORM.scpdName NEQ 1
AND (products.productID) = #scPdname#
/cfif
Although not sure if that works with all databases.
On Tue, Jun 3, 2008 at 6:27 AM, Matt Williams [EMAIL PROTECTED] wrote:
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.orderNo = retOrderItems.piOrderNo
LEFT JOIN products ON retOrderItems.piProductID = products.productID
WHERE 0=0
cfif IsDefined('FORM.scCounty') AND FORM.scCounty NEQ
AND (retCustCounty) LIKE '%#scCounty#%'/cfif
cfif IsDefined('FORM.scpdName') AND FORM.scpdName NEQ 1
AND (products.productID) = #scPdname# OR products.productID IS NULL
/cfif
On Tue, Jun 3, 2008 at 4:15 AM, Jason Congerton
[EMAIL PROTECTED] wrote:
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 well as using query params) I get errors when trying to create the
left joins, any ideas?
Thanks
cfquery name=getCustomers2008 datasource=#application.dsn#
SELECT retailCustomer.*, retailOrders.*, retOrderItems.*, products.*
FROM products INNER JOIN ((retailCustomer INNER JOIN retailOrders ON
retailCustomer.retailCustID = retailOrders.ocustID) INNER JOIN retOrderItems
ON retailOrders.orderNo = retOrderItems.piOrderNo) ON products.productID =
retOrderItems.piProductID
WHERE 0=0
cfif IsDefined('FORM.scCounty') AND FORM.scCounty NEQ
AND (retCustCounty) LIKE '%#scCounty#%'/cfif
cfif IsDefined('FORM.scpdName') AND FORM.scpdName NEQ 1
AND (products.productID) = #scPdname#/cfif
/cfquery
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306691
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Guide for reviewing a website
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 topic but any other add ins you guys find useful? On Mon, Jun 2, 2008 at 5:42 PM, Dave Francis [EMAIL PROTECTED] wrote: This might point out areas where load times could be improved: http://developer.yahoo.com/performance/index.html#rules along with the YSlow plugin for firebug. -Original Message- From: Richard Dillman [mailto:[EMAIL PROTECTED] Sent: Monday, June 02, 2008 1:51 PM To: CF-Talk Subject: Re: Guide for reviewing a website Lets not forget: Branding Logo Compatibility (IE,NS,FF,O...)(win,Mac,Lynux...) Load Time (10 sec) SEO There is a LOT that goes into a good website. On Mon, Jun 2, 2008 at 11:59 AM, Tom Chiverton [EMAIL PROTECTED] wrote: On Monday 02 Jun 2008, Toby King wrote: looking at include overall look and feel,navigation, content, ease of use. You might want to have standards compliance, graceful degradation or accessibility in there. -- Tom Chiverton This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.com. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306694 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFAdmin API reference?
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 Subject: Re: CFAdmin API reference? 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, 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 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 Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306692 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CSV Generation MEMORY SUCK
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, 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 This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.com. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306695 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CSV Generation MEMORY SUCK
Building up strings in cfsavecontent also concatenates to the result variable so the problem is the same. On Tue, Jun 3, 2008 at 11:16 AM, Brad Wood [EMAIL PROTECTED] wrote: 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- From: Brian Kotek [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 03, 2008 10:12 AM To: CF-Talk Subject: Re: CSV Generation MEMORY SUCK 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! ;-) ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306703 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CSV Generation MEMORY SUCK
Good to know. What is your source of this information? ~Brad From: Brian Kotek [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 03, 2008 11:11 AM Building up strings in cfsavecontent also concatenates to the result variable so the problem is the same. On Tue, Jun 3, 2008 at 11:16 AM, Brad Wood [EMAIL PROTECTED] wrote: I wonder what Java string objects are used when you create a large string by outputting inside a cfsavecontent. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306704 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CSV Generation MEMORY SUCK
where a fair chunk of the CF9 team are hosting a BOF session :-) That was a fun and ruckus BOF session at CF.Objective()! Wil Genovese ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306705 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Left Join on 4 Tables
Please paste your entire query statement. Also, try pasting your query into a SQL formatter such as: http://www.wangz.net/cgi-bin/pp/gsqlparser/sqlpp/sqlformat.tpl The formatter may help you find where the problem is. m!ke -Original Message- From: Jason Congerton [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 03, 2008 10:19 AM To: CF-Talk Subject: Re: Left Join on 4 Tables 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 retOrderItems.piProductID = products.productID'. Tried troubleshooting but to no avail. Jason ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306706 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CSV Generation MEMORY SUCK
Hmm, I don't think you are correct Brian. I just whipped up a test of string concatenation. Please spare the proper load test flames. This is NOT a load test-- it is intended to make a process run long enough to capture a thread stack. Actually, in the context of large file generations I would call it quite appropriate. Concatenation Hello World. together 30 thousand times on CF 7.0.2 Ent (Win) shows a vast difference between using and simply outputting it inside a cfsavecontent. The definitely spent all its time doing a Java.lang.String.concat(). The cfsavecontent not only executed 211 times faster, I didn't see a single String.contat() happening. Here are the results: And here is the code: cfset string1 = cftimer label=string string type=outline cfloop from=1 to=3 index=i cfset string1 = string1 Hello World. /cfloop /cftimer cfoutputString Length: #len(string1)#/cfoutput cfsetting enablecfoutputonly=true cftimer label=cfsavecontent type=outline cfsavecontent variable=string2 cfloop from=1 to=3 index=i cfoutputHello World./cfoutput /cfloop /cfsavecontent /cftimer cfsetting enablecfoutputonly=false cfoutputString Length: #len(string2)#/cfoutput ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306707 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
mysqldump question
hi, we have been doing mysqldump of our database and realise that it is not doing exactly what we want it to do it is dumping out all the data and if we load into another database then it loads the data in and creates the tables it needs in order to enter the database. however it does not delete any unneccasy tables that doesnt exist in the dump we want to have a process where if we load in a dump it creates an exact replica of all tables and data etc... - not just the data is there a way to do this? thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306708 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CSV Generation MEMORY SUCK
Update: I experienced the same behavior on CF 8 JVM 1.6 (Win). Well, almost the same-- the CF8 server was actually faster overall. I would like to point out it is actually a slower server too! string string: 9141ms String Length: 39 cfsavecontent: 31ms String Length: 39 -Original Message- From: Brad Wood Sent: Tuesday, June 03, 2008 11:45 AM To: Brad Wood; 'cf-talk@houseoffusion.com' Subject: RE: CSV Generation MEMORY SUCK Here are the results: string string: 17093ms String Length: 39 cfsavecontent: 125ms String Length: 39 ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306710 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CSV Generation MEMORY SUCK
Did you compare the memory usage by chance? G On Tue, Jun 3, 2008 at 1:07 PM, Brad Wood [EMAIL PROTECTED] wrote: Update: I experienced the same behavior on CF 8 JVM 1.6 (Win). Well, almost the same-- the CF8 server was actually faster overall. I would like to point out it is actually a slower server too! string string: 9141ms String Length: 39 cfsavecontent: 31ms String Length: 39 -Original Message- From: Brad Wood Sent: Tuesday, June 03, 2008 11:45 AM To: Brad Wood; 'cf-talk@houseoffusion.com' Subject: RE: CSV Generation MEMORY SUCK Here are the results: string string: 17093ms String Length: 39 cfsavecontent: 125ms String Length: 39 ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306711 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: mysqldump question
Prefix the load with a delete database;create database pair, so you always start blank. cheers, barneyb On Tue, Jun 3, 2008 at 9:48 AM, Richard White [EMAIL PROTECTED] wrote: hi, we have been doing mysqldump of our database and realise that it is not doing exactly what we want it to do it is dumping out all the data and if we load into another database then it loads the data in and creates the tables it needs in order to enter the database. however it does not delete any unneccasy tables that doesnt exist in the dump we want to have a process where if we load in a dump it creates an exact replica of all tables and data etc... - not just the data is there a way to do this? thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306709 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: mysqldump question
Hi Barney, thanks for the reply, are these options in the mysqldump or do you mean physically do this? if they are options in mysqldump can you provide an example please thanks again Prefix the load with a delete database;create database pair, so you always start blank. cheers, barneyb On Tue, Jun 3, 2008 at 9:48 AM, Richard White [EMAIL PROTECTED] wrote: ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306712 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CSV Generation MEMORY SUCK
No, but I would like to. The problem is I'm not sure how to get any exact numbers. I have SeeFusion installed which will tell me the overall heap size of my JVM, but it might be difficult to nail down how much was used by one thread. Alternatively, there are the totalMemory() and maxMemory() methods in the runtime object available in java.lang.Runtime. I could run that before and after the code ran, but I'm not sure how garbage collection would affect that. Suggestions? ~Brad -Original Message- From: Gerald Guido [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 03, 2008 12:11 PM To: CF-Talk Subject: Re: CSV Generation MEMORY SUCK Did you compare the memory usage by chance? G On Tue, Jun 3, 2008 at 1:07 PM, Brad Wood [EMAIL PROTECTED] wrote: ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306714 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: mysqldump question
You have to manually do it. mysqldump just dumps out tables and/or databases to a SQL script. Once mysqldump is done, there's no way to tell that the SQL file was generated by mysqldump, hand coding, or arbitrary automated process X - it's just a SQL file. When you load the script, you need to make sure you load it into the right thing, which in your case sounds like an empty database. So it's up to you to ensure you have an empty database. I suppose you could prefix your script with the database drop/create commands after mysqldump is done with it, but it's simple enough to just do that before loading the script. cheers, barneyb On Tue, Jun 3, 2008 at 10:14 AM, Richard White [EMAIL PROTECTED] wrote: Hi Barney, thanks for the reply, are these options in the mysqldump or do you mean physically do this? if they are options in mysqldump can you provide an example please thanks again Prefix the load with a delete database;create database pair, so you always start blank. cheers, barneyb On Tue, Jun 3, 2008 at 9:48 AM, Richard White [EMAIL PROTECTED] wrote: ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306713 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CSV Generation MEMORY SUCK
Ok, here are my memory usage stats on CF 7. Someone please correct me if my code is wrong. It's a little messy, and I apologize for that. Memory Before: 83 Megs string string: 52795ms String Length: 65 Memory After: 101 Megs -- Increase of 17 Megs Memory Before: 85 Megs cfsavecontent: 172ms String Length: 65 Memory After: 97 Megs -- Increase of 12 Megs As you can see, cfsavecontent used about 1/3 less memory that the other method. Not nearly as proportional savings the execution time... Wow-- here are the numbers from my CF8 box: Memory Before: 161 Megs string string: 26530ms String Length: 65 Memory After: 195 Megs -- Increase of 35 Megs Memory Before: 158 Megs cfsavecontent: 47ms String Length: 65 Memory After: 165 Megs -- Increase of 7 Megs This time the cfsavecontent used 4/5ths less memory! Very interesting indeed... Of course, please understand there are many factors and JVM settings that go into this. I'm not trying to claim everyone else will get results like this. Here the latest version of my (slightly sloppy) code: cfset runtime = CreateObject(java, java.lang.Runtime).getRuntime() cfset total_memory = runtime.totalMemory() cfset runtime.gc() cfset memory_before = (total_memory-runtime.freeMemory()) / 1024 / 1024 cfoutputMemory Before: #round(memory_before)# Megsbr cfset string1 = cftimer label=string string type=outline cfloop from=1 to=5 index=i cfset string1 = string1 Hello World. /cfloop /cftimer cfoutputString Length: #len(string1)#/cfoutputbr cfset memory_after = (total_memory-runtime.freeMemory()) / 1024 / 1024 Memory After: #round(memory_after)# Megs -- Increase of #round(memory_after - memory_before)# Megsbr br / /cfoutput cfset runtime.gc() cfset memory_before = (total_memory-runtime.freeMemory()) / 1024 / 1024 cfoutputMemory Before: #round(memory_before)# Megsbr/cfoutput cfsetting enablecfoutputonly=true cftimer label=cfsavecontent type=outline cfsavecontent variable=string2 cfloop from=1 to=5 index=i cfoutputHello World./cfoutput /cfloop /cfsavecontent /cftimer cfsetting enablecfoutputonly=false cfoutputString Length: #len(string2)#/cfoutputbr cfset memory_after = (total_memory-runtime.freeMemory()) / 1024 / 1024 cfoutputMemory After: #round(memory_after)# Megs -- Increase of #round(memory_after - memory_before)# Megsbr/cfoutput ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306715 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: do not increase counter is returns 0
Please ignore the buttheads Katrina...it is still like that. Eric /*-Original Message- /*From: Katrina Chapman [mailto:[EMAIL PROTECTED] /*Sent: Tuesday, June 03, 2008 1:17 PM /*To: CF-Talk /*Subject: Re: do not increase counter is returns 0 /* /*I haven't been a member of this list for a few years now, but I remember /*it being a place where even the most beginning person could come for /*advice. This is a community and not a place for you to show how much more /*you know than the next guy. /*I really don't think this response is appropriate and I'm sure that most /*of the community feels the same way. How about next time instead of /*saying You're an idiot, you either give some good advice or don't /*respond? That way there's no waste of everyone else's time reading /*posts that aren't helpful. You might also find that you'll get better /*responses to any questions you have if you're nice. /**Down off my soap box now* /* Thank you, /*Katrina /* /*If people knew how hard I worked to gain my mastery, /*it wouldn't seem so wonderful after all. /*--Michelangelo /* /* /* /*- Original Message /*From: Brian Kotek [EMAIL PROTECTED] /*To: CF-Talk cf-talk@houseoffusion.com /*Sent: Tuesday, June 3, 2008 9:37:46 AM /*Subject: Re: do not increase counter is returns 0 /* /*If Erik would bother to read even the most basic book on SQL he could /*answer /*this himself since this could all be done in a couple of lines of SQL with /*no loops and no CFML at all. But he'd rather waste everyone else's time /*instead of spending 10 dollars. So please don't encourage him, Tom. ;-) /* /* /*On Tue, Jun 3, 2008 at 11:26 AM, Tom Chiverton /*[EMAIL PROTECTED] /*wrote: /* /* 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 /* cfif getTimeAvg1.recordcount gt 0 /* /* cfif getTimeAvg1.recordcount gt 0 and query.hours neq 0 and /*query.mineutes /* neq 0 ? /* -- /* Tom Chiverton /* /* /* /* This email is sent for and on behalf of Halliwells LLP. /* /* Halliwells LLP is a limited liability partnership registered in England /*and /* Wales under registered number OC307980 whose registered office address /*is at /* Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A /* list of members is available for inspection at the registered office. /*Any /* reference to a partner in relation to Halliwells LLP means a member of /* Halliwells LLP. Regulated by The Solicitors Regulation Authority. /* /* CONFIDENTIALITY /* /* This email is intended only for the use of the addressee named above and /* may be confidential or legally privileged. If you are not the addressee /*you /* must not read it and must not use any information contained in nor copy /*it /* nor inform any person other than Halliwells LLP or the addressee of its /* existence or contents. If you have received this email in error please /* delete it and notify Halliwells LLP IT Department on 0870 365 2500. /* /* For more information about Halliwells LLP visit www.halliwells.com. /* /* /* /* /* /* ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306717 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: mysqldump question
ok great, thanks barney, appreciate it You have to manually do it. mysqldump just dumps out tables and/or databases to a SQL script. Once mysqldump is done, there's no way to tell that the SQL file was generated by mysqldump, hand coding, or arbitrary automated process X - it's just a SQL file. When you load the script, you need to make sure you load it into the right thing, which in your case sounds like an empty database. So it's up to you to ensure you have an empty database. I suppose you could prefix your script with the database drop/create commands after mysqldump is done with it, but it's simple enough to just do that before loading the script. cheers, barneyb On Tue, Jun 3, 2008 at 10:14 AM, Richard White [EMAIL PROTECTED] wrote: ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306718 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: do not increase counter is returns 0
Erik, why can't you just exclude those records in the SQL? select hours,minutes from TimesOnline where empID=#EID# and coursename like 'Activity Programming%' and (hours != 0 and minutes != 0) ?? On Tue, Jun 3, 2008 at 1:19 PM, Eric Roberts [EMAIL PROTECTED] wrote: Please ignore the buttheads Katrina...it is still like that. Eric /*-Original Message- /*From: Katrina Chapman [mailto:[EMAIL PROTECTED] /*Sent: Tuesday, June 03, 2008 1:17 PM /*To: CF-Talk /*Subject: Re: do not increase counter is returns 0 /* /*I haven't been a member of this list for a few years now, but I remember /*it being a place where even the most beginning person could come for /*advice. This is a community and not a place for you to show how much more /*you know than the next guy. /*I really don't think this response is appropriate and I'm sure that most /*of the community feels the same way. How about next time instead of /*saying You're an idiot, you either give some good advice or don't /*respond? That way there's no waste of everyone else's time reading /*posts that aren't helpful. You might also find that you'll get better /*responses to any questions you have if you're nice. /**Down off my soap box now* /* Thank you, /*Katrina /* /*If people knew how hard I worked to gain my mastery, /*it wouldn't seem so wonderful after all. /*--Michelangelo /* /* /* /*- Original Message /*From: Brian Kotek [EMAIL PROTECTED] /*To: CF-Talk cf-talk@houseoffusion.com /*Sent: Tuesday, June 3, 2008 9:37:46 AM /*Subject: Re: do not increase counter is returns 0 /* /*If Erik would bother to read even the most basic book on SQL he could /*answer /*this himself since this could all be done in a couple of lines of SQL with /*no loops and no CFML at all. But he'd rather waste everyone else's time /*instead of spending 10 dollars. So please don't encourage him, Tom. ;-) /* /* /*On Tue, Jun 3, 2008 at 11:26 AM, Tom Chiverton /*[EMAIL PROTECTED] /*wrote: /* /* 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 /* cfif getTimeAvg1.recordcount gt 0 /* /* cfif getTimeAvg1.recordcount gt 0 and query.hours neq 0 and /*query.mineutes /* neq 0 ? /* -- /* Tom Chiverton /* /* /* /* This email is sent for and on behalf of Halliwells LLP. /* /* Halliwells LLP is a limited liability partnership registered in England /*and /* Wales under registered number OC307980 whose registered office address /*is at /* Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A /* list of members is available for inspection at the registered office. /*Any /* reference to a partner in relation to Halliwells LLP means a member of /* Halliwells LLP. Regulated by The Solicitors Regulation Authority. /* /* CONFIDENTIALITY /* /* This email is intended only for the use of the addressee named above and /* may be confidential or legally privileged. If you are not the addressee /*you /* must not read it and must not use any information contained in nor copy /*it /* nor inform any person other than Halliwells LLP or the addressee of its /* existence or contents. If you have received this email in error please /* delete it and notify Halliwells LLP IT Department on 0870 365 2500. /* /* For more information about Halliwells LLP visit www.halliwells.com. /* /* /* /* /* /* ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306720 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: do not increase counter is returns 0
I haven't been a member of this list for a few years now, but I remember it being a place where even the most beginning person could come for advice. This is a community and not a place for you to show how much more you know than the next guy. I really don't think this response is appropriate and I'm sure that most of the community feels the same way. How about next time instead of saying You're an idiot, you either give some good advice or don't respond? That way there's no waste of everyone else's time reading posts that aren't helpful. You might also find that you'll get better responses to any questions you have if you're nice. *Down off my soap box now* Thank you, Katrina If people knew how hard I worked to gain my mastery, it wouldn't seem so wonderful after all. --Michelangelo - Original Message From: Brian Kotek [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, June 3, 2008 9:37:46 AM Subject: Re: do not increase counter is returns 0 If Erik would bother to read even the most basic book on SQL he could answer this himself since this could all be done in a couple of lines of SQL with no loops and no CFML at all. But he'd rather waste everyone else's time instead of spending 10 dollars. So please don't encourage him, Tom. ;-) On Tue, Jun 3, 2008 at 11:26 AM, Tom Chiverton [EMAIL PROTECTED] wrote: 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 cfif getTimeAvg1.recordcount gt 0 cfif getTimeAvg1.recordcount gt 0 and query.hours neq 0 and query.mineutes neq 0 ? -- Tom Chiverton This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.com. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306716 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: market rates
:) like it On Saturday 31 May 2008, Richard White wrote: we are based in the UK, does anyone know of anywhere we could go to fund out the current market rates for coldfusion and mysql web application developers? Ring a company that offers a CF coding service and pretend your a potential customer ? -- Tom Chiverton This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.com. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306719 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: do not increase counter is returns 0
On Tue, Jun 3, 2008 at 11:17 AM, Katrina Chapman [EMAIL PROTECTED] wrote: I haven't been a member of this list for a few years now, but I remember it being a place where even the most beginning person could come for advice. This is a community and not a place for you to show how much more you know than the next guy. I really don't think this response is appropriate and I'm sure that most of the community feels the same way. How about next time instead of saying You're an idiot, you either give some good advice or don't respond? That way there's no waste of everyone else's time reading posts that aren't helpful. You might also find that you'll get better responses to any questions you have if you're nice. *Down off my soap box now* ok so this is just my $0.02... It's not unreasonable to expect that when somebody asks for help (asks for you to give up your own time) that they've already made *reasonable* efforts to solve the problem on their own. The How To Ask Questions The Smart Way page (http://www.catb.org/~esr/faqs/smart-questions.html) is pretty well known for illustrating... well, how to ask questions the smart way. That being said, the person in question has posted numerous times to this list and his questions never seem to indicate that he's even put forth the smallest amount of effort to learn how to do what needs doing. In Brian's defense, he (Brian) has responded to questions posed by Erik numerous times in what I considered to be a fairly courteous manner. He's pointed out the link that I referenced above, he's tried to teach Erik how to figure things out on his own. When you've been doing this for a while (answering questions on mailing lists), you get a sense for who is genuinely making an effort and who is just looking for a quick answer. When it's the latter, you're hesitant to provide that quick answer because you *know* that person will just keep coming back for the quick answer, expecting others to spend their time answering his/her question. Brian's advice (again, IMHO) *has* been good. Very good. Assuming that the person actually has an interest in learning. I like to believe the purpose of lists like this is to teach people. Not to answer questions for (e.g. do the work for) people who don't want to learn. /me passes the soapbox to the next person in line. -- A byte walks into a bar and orders a pint. Bartender asks him What's wrong? Byte says Parity error. Bartender nods and says Yeah, I thought you looked a bit off. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306721 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CSV Generation MEMORY SUCK
I did a million loops - I don't know what possessed me to do that. Memory was measured using task manager. Totally unscientific. I did a restart on the service before each trial. CF 8 developer 2 gig ram Java v. 1.6.0_01 cfsavecontent 2281 ms 192,356 k start 260,872K after 68.516 k difference concatenation using cfset timed out after 15 min 192,362 k start 580,952 k after 388,590 k difference I find this very interesting in that my totally unscientific though process was: Since cfsavecontent is so damn easy to use it *must* be resource intensive. G On Tue, Jun 3, 2008 at 1:55 PM, Brad Wood [EMAIL PROTECTED] wrote: Ok, here are my memory usage stats on CF 7. Someone please correct me if my code is wrong. It's a little messy, and I apologize for that. -- The important thing in science is not so much to obtain new facts as to discover new ways of thinking about them. - Sir William Bragg ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306722 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF8 not validating CFFORM fields
We've just upgraded our servers to CF8 and now forms containing CFFORM with required fields do not run the javascript at run time. Does anything need to be configured in the CF admin? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306723 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: do not increase counter is returns 0
I think the thing to remember is not everyone reading mailing lists as things come in or worse later down the road in some sort of archives, is not going to always be familiar with the history of users. So depending on the person lashing out, it could bite them in the butt later on. Obviously someone more known in the community though it would be doubtful to bite them but guess it depends on how often they do it. So with that said, sometimes it is best just not to say anything at all if someone is asking questions that annoy people. On Tue, Jun 3, 2008 at 1:42 PM, Charlie Griefer [EMAIL PROTECTED] wrote: On Tue, Jun 3, 2008 at 11:17 AM, Katrina Chapman [EMAIL PROTECTED] wrote: I haven't been a member of this list for a few years now, but I remember it being a place where even the most beginning person could come for advice. This is a community and not a place for you to show how much more you know than the next guy. I really don't think this response is appropriate and I'm sure that most of the community feels the same way. How about next time instead of saying You're an idiot, you either give some good advice or don't respond? That way there's no waste of everyone else's time reading posts that aren't helpful. You might also find that you'll get better responses to any questions you have if you're nice. *Down off my soap box now* ok so this is just my $0.02... It's not unreasonable to expect that when somebody asks for help (asks for you to give up your own time) that they've already made *reasonable* efforts to solve the problem on their own. The How To Ask Questions The Smart Way page (http://www.catb.org/~esr/faqs/smart-questions.htmlhttp://www.catb.org/%7Eesr/faqs/smart-questions.html) is pretty well known for illustrating... well, how to ask questions the smart way. That being said, the person in question has posted numerous times to this list and his questions never seem to indicate that he's even put forth the smallest amount of effort to learn how to do what needs doing. In Brian's defense, he (Brian) has responded to questions posed by Erik numerous times in what I considered to be a fairly courteous manner. He's pointed out the link that I referenced above, he's tried to teach Erik how to figure things out on his own. When you've been doing this for a while (answering questions on mailing lists), you get a sense for who is genuinely making an effort and who is just looking for a quick answer. When it's the latter, you're hesitant to provide that quick answer because you *know* that person will just keep coming back for the quick answer, expecting others to spend their time answering his/her question. Brian's advice (again, IMHO) *has* been good. Very good. Assuming that the person actually has an interest in learning. I like to believe the purpose of lists like this is to teach people. Not to answer questions for (e.g. do the work for) people who don't want to learn. /me passes the soapbox to the next person in line. -- A byte walks into a bar and orders a pint. Bartender asks him What's wrong? Byte says Parity error. Bartender nods and says Yeah, I thought you looked a bit off. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306724 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: USAePay.com SOAP API? Anyone using it?
So, no one is using usaePay soap integration with a Adobe Coldfusion? Doesn't matter what version. I'm receiving the same errors on each. Cannot generate stub objects for web service invocation. - Yes I've refreshed the webservice in cfadmin. The same exact code works fine on BlueDragon. Just checking back to see if anyone had implemented anything. Hit me up off list if this is the case. Would love to pick your brain for a couple of minutes. regards, Casey On Wed, May 28, 2008 at 2:55 PM, Casey Dougall [EMAIL PROTECTED] wrote: I'm totally stuck. USAePay has a API that list with a shit load of coldfusion examples that do squat. I ask them about it, and they are like, yeah those work for simple transactions. I'm like ok, I'll use the SOAP api instead... I tried cfinvoke no luck... Cannot generate stub objects for web service invocation. I'm trying cfhttp with a xml document but that doesn't seem to be passing back the correct data. When I dump the results it just seems to be the whole api in dump format. If you are using this soap api in one way or another (wsdl) version, could you please with muffins on top, post a sample call to the api and what happens with the returned information. Thanks -- Casey ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306725 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CSV Generation MEMORY SUCK
Wow, I just came back to this thread. REALLY makes me wonder how they're handling cfsavecontent! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306726 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF8 not validating CFFORM fields
Check to see if if the mapping for /CFIDE points to a dir that contains contans the scripts dir. Server Settings Mappings On Tue, Jun 3, 2008 at 2:44 PM, Maryam Jami [EMAIL PROTECTED] wrote: We've just upgraded our servers to CF8 and now forms containing CFFORM with required fields do not run the javascript at run time. Does anything need to be configured in the CF admin? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306727 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CSV Generation MEMORY SUCK
timed out after 15 min lol I find this very interesting in that my totally unscientific though process was: Since cfsavecontent is so damn easy to use it *must* be resource intensive. Go figure-- ColdFusion strikes again. If string.concat() creates a brand new string object in memory to hold the combination of the two original strings, then given a consistently average sized string being added each time I would expect memory consumption to be exponential. For instance, if you concatenated a string 1 byte in size 10 times over, you would consume 55 bytes of memory. 1+2+3+4+5+6+7+8+9+10=55 For the life of me I can't figure out what the Big-O notation would be for that though... ~Brad -Original Message- From: Gerald Guido [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 03, 2008 1:44 PM To: CF-Talk Subject: Re: CSV Generation MEMORY SUCK I did a million loops - I don't know what possessed me to do that. Memory was measured using task manager. Totally unscientific. I did a restart on the service before each trial. CF 8 developer 2 gig ram Java v. 1.6.0_01 cfsavecontent 2281 ms 192,356 k start 260,872K after 68.516 k difference concatenation using cfset 192,362 k start 580,952 k after 388,590 k difference G On Tue, Jun 3, 2008 at 1:55 PM, Brad Wood [EMAIL PROTECTED] wrote: Ok, here are my memory usage stats on CF 7. Someone please correct me if my code is wrong. It's a little messy, and I apologize for that. -- The important thing in science is not so much to obtain new facts as to discover new ways of thinking about them. - Sir William Bragg ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306728 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Page refresh to current position after record delete
Haven't figured a solution for this yet... I've got a simple admin page for a client to add/edit/delete records as needed. If he runs a search that returns 600 records, scrolls down to record 278, and deletes that record - after the page refreshes he wants to still be in the same position on the page as before so he doesn't have to scroll the list again to get back where he was. Maybe a dynamically named anchor attached to each row returned, and you're returned to the next (anchor+1) on the next row after the delete? Any better ideas - in theory? Thanks, Les ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306729 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: do not increase counter is returns 0
Then the better option would be to just not reply instead of giving the impression that the list is not friendly to people who ask questions. Eric /*-Original Message- /*From: Charlie Griefer [mailto:[EMAIL PROTECTED] /*Sent: Tuesday, June 03, 2008 1:43 PM /*To: CF-Talk /*Subject: Re: do not increase counter is returns 0 /* /*On Tue, Jun 3, 2008 at 11:17 AM, Katrina Chapman [EMAIL PROTECTED] /*wrote: /* I haven't been a member of this list for a few years now, but I remember /*it being a place where even the most beginning person could come for /*advice. This is a community and not a place for you to show how much more /*you know than the next guy. /* I really don't think this response is appropriate and I'm sure that most /*of the community feels the same way. How about next time instead of /*saying You're an idiot, you either give some good advice or don't /*respond? That way there's no waste of everyone else's time reading /*posts that aren't helpful. You might also find that you'll get better /*responses to any questions you have if you're nice. /* *Down off my soap box now* /* /*ok so this is just my $0.02... /* /*It's not unreasonable to expect that when somebody asks for help (asks /*for you to give up your own time) that they've already made /**reasonable* efforts to solve the problem on their own. The How To /*Ask Questions The Smart Way page /*(http://www.catb.org/~esr/faqs/smart-questions.html) is pretty well /*known for illustrating... well, how to ask questions the smart way. /* /*That being said, the person in question has posted numerous times to /*this list and his questions never seem to indicate that he's even put /*forth the smallest amount of effort to learn how to do what needs /*doing. In Brian's defense, he (Brian) has responded to questions /*posed by Erik numerous times in what I considered to be a fairly /*courteous manner. He's pointed out the link that I referenced above, /*he's tried to teach Erik how to figure things out on his own. When /*you've been doing this for a while (answering questions on mailing /*lists), you get a sense for who is genuinely making an effort and who /*is just looking for a quick answer. When it's the latter, you're /*hesitant to provide that quick answer because you *know* that person /*will just keep coming back for the quick answer, expecting others to /*spend their time answering his/her question. /* /*Brian's advice (again, IMHO) *has* been good. Very good. Assuming /*that the person actually has an interest in learning. /* /*I like to believe the purpose of lists like this is to teach people. /*Not to answer questions for (e.g. do the work for) people who don't /*want to learn. /* /*/me passes the soapbox to the next person in line. /* /* /*-- /*A byte walks into a bar and orders a pint. Bartender asks him What's /*wrong? Byte says Parity error. Bartender nods and says Yeah, I /*thought you looked a bit off. /* /* ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306730 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CSV Generation MEMORY SUCK
Well, since we're all conducting our own little tests, here's MY test code: the cfset method took 64 seconds. The cfsavecontent method only takes 203ms. It has GOT to be using a stringbuffer then converting the result to a string at the end. cfsetting enablecfoutputonly=yes cfsetting requesttimeout=600 cfset reps = 10 cfif 1 cfset start = now().gettime() cfset result = cfloop from=1 to=#reps# step=1 index=i cfset result = result i /cfloop cfset end = now().gettime() cfoutputp#end-start#ms : #len(result)#/p/cfoutput cfelse cfset start = now().gettime() cfsavecontent variable=result cfloop from=1 to=#reps# step=1 index=i cfoutput#i#/cfoutput /cfloop /cfsavecontent cfset end = now().gettime() cfoutputp#end-start#ms : #len(result)#/p/cfoutput /cfif ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306731 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CSV Generation MEMORY SUCK
Dang closed source apps-- if only we could just go look at the code! :) ~Brad -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 03, 2008 2:26 PM To: CF-Talk Subject: Re: CSV Generation MEMORY SUCK Well, since we're all conducting our own little tests, here's MY test code: the cfset method took 64 seconds. The cfsavecontent method only takes 203ms. It has GOT to be using a stringbuffer then converting the result to a string at the end. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306732 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Adobe ColdFusion Survey
There is a new quick survey for everyone in the CF community to participate in. The results will be shared directly with Adobe and the general public. We want to know what version of ColdFusion you are using now. Plus a few questions to help us prepare for the CFUnited conference. Answer all 8 questions by June 11th and be entered in a raffle to win a brand new iTouch! http://cfunited.com/blog/index.cfm/2008/5/28/Adobe-ColdFusion-Survey-and-Scavenger-Hunt Thanks! -- Due to TeraTech's growth we are seeking winning sales people to sell custom software. For more details: http://www.teratech.com/go/about-us/jobsjobsaction=detailjobid=3 Michael Smith, TeraTech, Inc 405 E Gude Dr Ste 207, Rockville MD 20850 Voice: +1-301-424-3903 x110 Fax:301-762-8185 Web: http://www.teratech.com/ Email: mailto:[EMAIL PROTECTED] ICQ: 66057682 Winner in CFDJ awards Best Consulting. Member Team Fusebox. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306733 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: do not increase counter is returns 0
I haven't been a member of this list for a few years now, but I remember it being a place where even the most beginning person could come for advice. This is a community and not a place for you to show how much more you know than the next guy. I really don't think this response is appropriate and I'm sure that most of the community feels the same way. How about next time instead of saying You're an idiot, you either give some good advice or don't respond? That way there's no waste of everyone else's time reading posts that aren't helpful. You might also find that you'll get better responses to any questions you have if you're nice. Sometimes, the best advice is to say read a book. Brian didn't call Erik an idiot, he just advised Erik to read an SQL book. That might not be the advice the poster wants to receive, but I think it's a fair piece of advice. If you post one or two simple SQL questions to a list, that might not a very appropriate response. If you frequently post similar questions that indicate a basic lack of knowledge of a subject, you should expect responses like that on any list, no matter how much of a community it is. 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! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306734 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Adobe ColdFusion Survey
This is pretty bad... I filled out the first 5 questions... Then I have to do research to answer the last 3? C'mon.. Stop with the marketing. It's annoying. On Tue, Jun 3, 2008 at 12:33 PM, Michael Smith [EMAIL PROTECTED] wrote: There is a new quick survey for everyone in the CF community to participate in. The results will be shared directly with Adobe and the general public. We want to know what version of ColdFusion you are using now. Plus a few questions to help us prepare for the CFUnited conference. Answer all 8 questions by June 11th and be entered in a raffle to win a brand new iTouch! http://cfunited.com/blog/index.cfm/2008/5/28/Adobe-ColdFusion-Survey-and-Scavenger-Hunt Thanks! -- Due to TeraTech's growth we are seeking winning sales people to sell custom software. For more details: http://www.teratech.com/go/about-us/jobsjobsaction=detailjobid=3 Michael Smith, TeraTech, Inc 405 E Gude Dr Ste 207, Rockville MD 20850 Voice: +1-301-424-3903 x110 Fax:301-762-8185 Web: http://www.teratech.com/ Email: mailto:[EMAIL PROTECTED] ICQ: 66057682 Winner in CFDJ awards Best Consulting. Member Team Fusebox. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306736 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: do not increase counter is returns 0
On Tue, Jun 3, 2008 at 12:24 PM, Eric Roberts [EMAIL PROTECTED] wrote: Then the better option would be to just not reply instead of giving the impression that the list is not friendly to people who ask questions. I'll further point out that Brian didn't call anybody names. You, on the other hand, referred to him so eloquently as a butthead. You might want to look at a person's overall contributions to the community before making such a statement on a public forum. -- A byte walks into a bar and orders a pint. Bartender asks him What's wrong? Byte says Parity error. Bartender nods and says Yeah, I thought you looked a bit off. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306737 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Adobe ColdFusion Survey
I submitted without answering those. So I don't qualify for the drawing, but answered the poll questions. On Tue, Jun 3, 2008 at 3:47 PM, Phillip Vector [EMAIL PROTECTED] wrote: This is pretty bad... I filled out the first 5 questions... Then I have to do research to answer the last 3? C'mon.. Stop with the marketing. It's annoying. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306738 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Adobe ColdFusion Survey
I did as well.. But it was just annoying seeing questions that I would have to research for a conference that I won't be able to attend anyway. On Tue, Jun 3, 2008 at 12:53 PM, Jerry Johnson [EMAIL PROTECTED] wrote: I submitted without answering those. So I don't qualify for the drawing, but answered the poll questions. On Tue, Jun 3, 2008 at 3:47 PM, Phillip Vector [EMAIL PROTECTED] wrote: This is pretty bad... I filled out the first 5 questions... Then I have to do research to answer the last 3? C'mon.. Stop with the marketing. It's annoying. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306739 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Adobe ColdFusion Survey
It is an interesting marketing technique, make us think Adobe cares and give away an iTouch. In return, we have to learn more about the conference and give them our email address so they can send us announcements. Where can I send the 3x5 postcard with my entry printed on the back (no purchase/research necessary)? Matt On Tue, Jun 3, 2008 at 2:55 PM, Phillip Vector [EMAIL PROTECTED] wrote: I did as well.. But it was just annoying seeing questions that I would have to research for a conference that I won't be able to attend anyway. On Tue, Jun 3, 2008 at 12:53 PM, Jerry Johnson [EMAIL PROTECTED] wrote: I submitted without answering those. So I don't qualify for the drawing, but answered the poll questions. On Tue, Jun 3, 2008 at 3:47 PM, Phillip Vector [EMAIL PROTECTED] wrote: This is pretty bad... I filled out the first 5 questions... Then I have to do research to answer the last 3? C'mon.. Stop with the marketing. It's annoying. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306740 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Page refresh to current position after record delete
I would suggest a named anchor, as you mentioned. If you wanted to get fancier and put in a bit more effort, you could use AJAX. m!ke -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 03, 2008 2:23 PM To: CF-Talk Subject: Page refresh to current position after record delete Haven't figured a solution for this yet... I've got a simple admin page for a client to add/edit/delete records as needed. If he runs a search that returns 600 records, scrolls down to record 278, and deletes that record - after the page refreshes he wants to still be in the same position on the page as before so he doesn't have to scroll the list again to get back where he was. Maybe a dynamically named anchor attached to each row returned, and you're returned to the next (anchor+1) on the next row after the delete? Any better ideas - in theory? Thanks, Les ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306741 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: do not increase counter is returns 0
As your post clearly indicates. On Tue, Jun 3, 2008 at 2:19 PM, Eric Roberts [EMAIL PROTECTED] wrote: Please ignore the buttheads Katrina...it is still like that. Eric /*-Original Message- /*From: Katrina Chapman [mailto:[EMAIL PROTECTED] /*Sent: Tuesday, June 03, 2008 1:17 PM /*To: CF-Talk /*Subject: Re: do not increase counter is returns 0 /* /*I haven't been a member of this list for a few years now, but I remember /*it being a place where even the most beginning person could come for /*advice. This is a community and not a place for you to show how much more /*you know than the next guy. /*I really don't think this response is appropriate and I'm sure that most /*of the community feels the same way. How about next time instead of /*saying You're an idiot, you either give some good advice or don't /*respond? That way there's no waste of everyone else's time reading /*posts that aren't helpful. You might also find that you'll get better /*responses to any questions you have if you're nice. /**Down off my soap box now* /* Thank you, /*Katrina /* /*If people knew how hard I worked to gain my mastery, /*it wouldn't seem so wonderful after all. /*--Michelangelo /* /* /* /*- Original Message /*From: Brian Kotek [EMAIL PROTECTED] /*To: CF-Talk cf-talk@houseoffusion.com /*Sent: Tuesday, June 3, 2008 9:37:46 AM /*Subject: Re: do not increase counter is returns 0 /* /*If Erik would bother to read even the most basic book on SQL he could /*answer /*this himself since this could all be done in a couple of lines of SQL with /*no loops and no CFML at all. But he'd rather waste everyone else's time /*instead of spending 10 dollars. So please don't encourage him, Tom. ;-) /* /* /*On Tue, Jun 3, 2008 at 11:26 AM, Tom Chiverton /*[EMAIL PROTECTED] /*wrote: /* /* 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 /* cfif getTimeAvg1.recordcount gt 0 /* /* cfif getTimeAvg1.recordcount gt 0 and query.hours neq 0 and /*query.mineutes /* neq 0 ? /* -- /* Tom Chiverton /* /* /* /* This email is sent for and on behalf of Halliwells LLP. /* /* Halliwells LLP is a limited liability partnership registered in England /*and /* Wales under registered number OC307980 whose registered office address /*is at /* Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A /* list of members is available for inspection at the registered office. /*Any /* reference to a partner in relation to Halliwells LLP means a member of /* Halliwells LLP. Regulated by The Solicitors Regulation Authority. /* /* CONFIDENTIALITY /* /* This email is intended only for the use of the addressee named above and /* may be confidential or legally privileged. If you are not the addressee /*you /* must not read it and must not use any information contained in nor copy /*it /* nor inform any person other than Halliwells LLP or the addressee of its /* existence or contents. If you have received this email in error please /* delete it and notify Halliwells LLP IT Department on 0870 365 2500. /* /* For more information about Halliwells LLP visit www.halliwells.com. /* /* /* /* /* /* ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306742 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: do not increase counter is returns 0
That's the whole point. If he actually spent a fraction of the time that he does asking these kinds of questions and instead just read a book, everyone would benefit. On Tue, Jun 3, 2008 at 2:26 PM, Greg Morphis [EMAIL PROTECTED] wrote: Erik, why can't you just exclude those records in the SQL? select hours,minutes from TimesOnline where empID=#EID# and coursename like 'Activity Programming%' and (hours != 0 and minutes != 0) ?? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306743 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: do not increase counter is returns 0
Thank you, Charlie. Yes, as you point out, I have tried over and over to explain things to Erik as well as reiterate that what he asks about are things that would be explained in the first few chapters of any book (or even website tutorial) on the subject. Instead, he absolutely refuses to try to learn himself and instead keeps on asking questions. Why? Because people keep answering them. I'm trying to help him AND the list because the current situation is harming both. But to be honest, the fact that Mr. Roberts misses the point completely and resorts to the very ad hominid attacks he condemns is not shocking in the slightest. On Tue, Jun 3, 2008 at 2:42 PM, Charlie Griefer [EMAIL PROTECTED] wrote: ok so this is just my $0.02... It's not unreasonable to expect that when somebody asks for help (asks for you to give up your own time) that they've already made *reasonable* efforts to solve the problem on their own. The How To Ask Questions The Smart Way page (http://www.catb.org/~esr/faqs/smart-questions.htmlhttp://www.catb.org/%7Eesr/faqs/smart-questions.html) is pretty well known for illustrating... well, how to ask questions the smart way. That being said, the person in question has posted numerous times to this list and his questions never seem to indicate that he's even put forth the smallest amount of effort to learn how to do what needs doing. In Brian's defense, he (Brian) has responded to questions posed by Erik numerous times in what I considered to be a fairly courteous manner. He's pointed out the link that I referenced above, he's tried to teach Erik how to figure things out on his own. When you've been doing this for a while (answering questions on mailing lists), you get a sense for who is genuinely making an effort and who is just looking for a quick answer. When it's the latter, you're hesitant to provide that quick answer because you *know* that person will just keep coming back for the quick answer, expecting others to spend their time answering his/her question. Brian's advice (again, IMHO) *has* been good. Very good. Assuming that the person actually has an interest in learning. I like to believe the purpose of lists like this is to teach people. Not to answer questions for (e.g. do the work for) people who don't want to learn. /me passes the soapbox to the next person in line. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306744 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Page refresh to current position after record delete
If you wanted to get fancier and put in a bit more effort, you could use AJAX. Point me towards a relevant tutorial? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306745 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Page refresh to current position after record delete
www.w3schools.com On Tue, Jun 3, 2008 at 1:12 PM, Les Mizzell [EMAIL PROTECTED] wrote: If you wanted to get fancier and put in a bit more effort, you could use AJAX. Point me towards a relevant tutorial? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306746 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: do not increase counter is returns 0
On Tue, Jun 3, 2008 at 12:24 PM, Eric Roberts [EMAIL PROTECTED] wrote: Then the better option would be to just not reply instead of giving the impression that the list is not friendly to people who ask questions. Not answering is not helpful. Suggesting that reading a book on SQL is helpful (as Dave says, even if it's not the answer the poster wants to hear). -- A byte walks into a bar and orders a pint. Bartender asks him What's wrong? Byte says Parity error. Bartender nods and says Yeah, I thought you looked a bit off. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306735 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: do not increase counter is returns 0
The list is and should be friendly to people who ask questions. The list should not, however, be friendly to people who repeatedly ignore help and advice and instead continue to ask the same class of questions over and over, relying on the charity of others rather than spending any effort resolving the underlying problem. On Tue, Jun 3, 2008 at 3:24 PM, Eric Roberts [EMAIL PROTECTED] wrote: Then the better option would be to just not reply instead of giving the impression that the list is not friendly to people who ask questions. Eric ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306747 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: load balancing / failover
AJ Mercer wrote: When it comes to connecting to the JRun (CF) cluster, does IIS work differently than Apache? Not significantly. They both depend on a library that gets plugged in to the server, they both bootstrap etc. For what we have been experiencing (IIS [separate server] | CF702/JRun 4 updater 7 [2 servers, 2 instances each]; recently JVM1.5), it seems to me that there is too much dependence between IIS and individual CF instances. - at times, if one instance does off line, the whole site goes down. - if an instance is off-line when IIS comes up, it is not added to the cluster when it comes back on-line I have experienced both issues quite frequently. Luckily so far this behavior is pretty consistent and detectable befor you bring systems online. Once you have a working setup it keeps working. - IIS needs to be restarted if there is a change in the cluster For some changes that is correct. For instance, if you switch on sticky sessions the connector library in the webserver needs to re-initialize so it knows it has to start paying attention to the jsessionid. For that you need to restart the webserver. Has any one noticed any improvements in clustering in CF8? Updater 7 for JRun was meant to have clustering fixes, but we have not noticed it :-( I have noticed differences between a JRun installed with the CF 7.02 installer + JRun Updater 7 + CF 8.01 EAR files + JDK 1.6U5 versus a clean CF 8.01 install with the same CF 8.01 EAR files. In my setup (and I do some tricky things to get EAR file autodeployment working) I see more errors in the upgraded setup as in the clean setup. Jochem ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306748 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Adobe ColdFusion Survey
d'oh! i got #2 wrong. i thought it asked what time it ends :( On Tue, Jun 3, 2008 at 1:26 PM, Andy Matthews [EMAIL PROTECTED] wrote: So as to make it simple, the answers to the last 3 questions are: 1) 2005 2) 1:30 3) Ray Camden While I'd love to win a touch, it's a little over the top to research questions when we're already giving you information about our purchase and upgrade habits, PLUS our email addresses. -Original Message- From: Michael Smith [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 03, 2008 2:34 PM To: CF-Talk Subject: Adobe ColdFusion Survey There is a new quick survey for everyone in the CF community to participate in. The results will be shared directly with Adobe and the general public. We want to know what version of ColdFusion you are using now. Plus a few questions to help us prepare for the CFUnited conference. Answer all 8 questions by June 11th and be entered in a raffle to win a brand new iTouch! http://cfunited.com/blog/index.cfm/2008/5/28/Adobe-ColdFusion-Survey-and-Sca venger-Hunt Thanks! -- Due to TeraTech's growth we are seeking winning sales people to sell custom software. For more details: http://www.teratech.com/go/about-us/jobsjobsaction=detailjobid=3 Michael Smith, TeraTech, Inc 405 E Gude Dr Ste 207, Rockville MD 20850 Voice: +1-301-424-3903 x110 Fax:301-762-8185 Web: http://www.teratech.com/ Email: mailto:[EMAIL PROTECTED] ICQ: 66057682 Winner in CFDJ awards Best Consulting. Member Team Fusebox. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306750 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CSV Generation MEMORY SUCK
Just experience, since I've tried all three options (concatenation, cfsavecontent, and StringBuffer) and have had the first two generate out of memory errors while the StringBuffer worked correctly. So while cfsavecontent may indeed be faster and use less memory, I'm still pretty sure that the StringBuffer approach is better especially for very large strings (these were 100+ megabyte CSV files). On Tue, Jun 3, 2008 at 12:14 PM, Brad Wood [EMAIL PROTECTED] wrote: Good to know. What is your source of this information? ~Brad From: Brian Kotek [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 03, 2008 11:11 AM Building up strings in cfsavecontent also concatenates to the result variable so the problem is the same. On Tue, Jun 3, 2008 at 11:16 AM, Brad Wood [EMAIL PROTECTED] wrote: I wonder what Java string objects are used when you create a large string by outputting inside a cfsavecontent. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306751 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Cold Fusion 8 Question
Matt Altman wrote: I am trying to set up a new instance of Cold Fusion 8 on one of our servers. We have a three-tier environment set up with a separate web server. The problem we are running into is that we want to be able to deploy compiled code. We are running through the multi-server configuration because we do not have JRun installed anywhere. We want to be able to deploy sites/modules separately which would be through a CAR file. However, if I am remembering correctly, CAR files are not compiled. CAR files are created from sources present in the location specified during the creation. So if you compile your sources before creating a CAR file, your CAR file will contain compiled code. We were going to use WAR files since they were compiled WAR files may be compiled, but are not necessarily. we do not need deploy the entire application, settings, sites, etc. We just want to deploy the individual sites themselves. Create an Ant script that compiles and zip's the code? Jochem ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306752 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: do not increase counter is returns 0
I really don't think this response is appropriate and I'm sure that most of the community feels the same way. How about next time instead of saying You're an idiot, you either give some good advice or don't respond? That way there's no waste of everyone else's time reading posts that aren't helpful. You might also find that you'll get better responses to any questions you have if you're nice. -- Normally I do not get involved with this sort of thing but I feel the need to offer my unsolicited opinion. ;) Katrina I agree with you 100% in spirit. There are a lot of ugly communities on the web where people are flat out mean to each other, and I hate that with a passion. All in all, this is a very good group of people. IMHO, the CF community is one of the best on the net. There is some bickering here and there but in general most everyone here is extremely helpful and very polite. Often time people go *way out their way* to help people. Not to mention that some people here are down right brilliant. With that said, before you pass judgment on Brian, please take a moment to review at the questions that Erik Tom posts here. I think you will find that nearly all of them are poorly thought out, poorly worded, full of horrendous grammar and spelling errors and at times don't even make sense. It is as if he doesn't care. Look, we are talking about a guy who forwarded a Nigerian Lotto scam email to this list. People come here to learn and share their knowledge with the community. This list is a two way street. If you expect someone to take the time to answer your question please be respectful enough to take the time to ask a thoughtful, well worded question. Or at least Google it or crack open a book or RTM before post to a list. We are talking Netiquette 101. Respectfully, Gerald -- The important thing in science is not so much to obtain new facts as to discover new ways of thinking about them. - Sir William Bragg ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306753 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Adobe ColdFusion Survey
So as to make it simple, the answers to the last 3 questions are: 1) 2005 2) 1:30 3) Ray Camden While I'd love to win a touch, it's a little over the top to research questions when we're already giving you information about our purchase and upgrade habits, PLUS our email addresses. -Original Message- From: Michael Smith [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 03, 2008 2:34 PM To: CF-Talk Subject: Adobe ColdFusion Survey There is a new quick survey for everyone in the CF community to participate in. The results will be shared directly with Adobe and the general public. We want to know what version of ColdFusion you are using now. Plus a few questions to help us prepare for the CFUnited conference. Answer all 8 questions by June 11th and be entered in a raffle to win a brand new iTouch! http://cfunited.com/blog/index.cfm/2008/5/28/Adobe-ColdFusion-Survey-and-Sca venger-Hunt Thanks! -- Due to TeraTech's growth we are seeking winning sales people to sell custom software. For more details: http://www.teratech.com/go/about-us/jobsjobsaction=detailjobid=3 Michael Smith, TeraTech, Inc 405 E Gude Dr Ste 207, Rockville MD 20850 Voice: +1-301-424-3903 x110 Fax:301-762-8185 Web: http://www.teratech.com/ Email: mailto:[EMAIL PROTECTED] ICQ: 66057682 Winner in CFDJ awards Best Consulting. Member Team Fusebox. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306749 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Page refresh to current position after record delete
www.w3schools.com That was very helpful. Thanks so much. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306754 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Adobe ColdFusion Survey
On Tue, Jun 3, 2008 at 3:30 PM, Charlie Griefer [EMAIL PROTECTED] wrote: d'oh! i got #2 wrong. i thought it asked what time it ends :( On Tue, Jun 3, 2008 at 1:26 PM, Andy Matthews [EMAIL PROTECTED] wrote: So as to make it simple, the answers to the last 3 questions are: 1) 2005 2) 1:30 3) Ray Camden Thanks Andy. Of course your entry will somehow get misplaced now that you gave the answers. And mine too for admitting I used them. Oh well, iTouch - SchmiTouch. :P -- Matt Williams It's the question that drives us. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306755 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Adobe ColdFusion Survey
Woah - whats the last question? (Yes I'm too lazy to click on a link.) On Tue, Jun 3, 2008 at 3:26 PM, Andy Matthews [EMAIL PROTECTED] wrote: So as to make it simple, the answers to the last 3 questions are: 1) 2005 2) 1:30 3) Ray Camden While I'd love to win a touch, it's a little over the top to research questions when we're already giving you information about our purchase and upgrade habits, PLUS our email addresses. -Original Message- From: Michael Smith [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 03, 2008 2:34 PM To: CF-Talk Subject: Adobe ColdFusion Survey There is a new quick survey for everyone in the CF community to participate in. The results will be shared directly with Adobe and the general public. We want to know what version of ColdFusion you are using now. Plus a few questions to help us prepare for the CFUnited conference. Answer all 8 questions by June 11th and be entered in a raffle to win a brand new iTouch! http://cfunited.com/blog/index.cfm/2008/5/28/Adobe-ColdFusion-Survey-and-Sca venger-Hunt Thanks! -- Due to TeraTech's growth we are seeking winning sales people to sell custom software. For more details: http://www.teratech.com/go/about-us/jobsjobsaction=detailjobid=3 Michael Smith, TeraTech, Inc 405 E Gude Dr Ste 207, Rockville MD 20850 Voice: +1-301-424-3903 x110 Fax:301-762-8185 Web: http://www.teratech.com/ Email: mailto:[EMAIL PROTECTED] ICQ: 66057682 Winner in CFDJ awards Best Consulting. Member Team Fusebox. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306756 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Page refresh to current position after record delete
That was very helpful. Thanks so much. By using an ajax approach, the page would not refresh when you deleted the item. You hit the 'delete' button, javascript sends an asynchronous request to the system to delete the record; when the response comes back, javascript removes the display of the record in the page and the user's scroll position has not changed. There would be no tutorial for that as such. If you have not used ajax, google 'getting started with ajax', etc. Dominic -- Blog it up: http://fusion.dominicwatson.co.uk ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306757 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Adobe ColdFusion Survey
it was whose wish list is this: http://www.amazon.com/gp/registry/2TCL1D08EZEYE ? :) On Tue, Jun 3, 2008 at 1:51 PM, Raymond Camden [EMAIL PROTECTED] wrote: Woah - whats the last question? (Yes I'm too lazy to click on a link.) On Tue, Jun 3, 2008 at 3:26 PM, Andy Matthews [EMAIL PROTECTED] wrote: So as to make it simple, the answers to the last 3 questions are: 1) 2005 2) 1:30 3) Ray Camden While I'd love to win a touch, it's a little over the top to research questions when we're already giving you information about our purchase and upgrade habits, PLUS our email addresses. -Original Message- From: Michael Smith [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 03, 2008 2:34 PM To: CF-Talk Subject: Adobe ColdFusion Survey There is a new quick survey for everyone in the CF community to participate in. The results will be shared directly with Adobe and the general public. We want to know what version of ColdFusion you are using now. Plus a few questions to help us prepare for the CFUnited conference. Answer all 8 questions by June 11th and be entered in a raffle to win a brand new iTouch! http://cfunited.com/blog/index.cfm/2008/5/28/Adobe-ColdFusion-Survey-and-Sca venger-Hunt Thanks! -- Due to TeraTech's growth we are seeking winning sales people to sell custom software. For more details: http://www.teratech.com/go/about-us/jobsjobsaction=detailjobid=3 Michael Smith, TeraTech, Inc 405 E Gude Dr Ste 207, Rockville MD 20850 Voice: +1-301-424-3903 x110 Fax:301-762-8185 Web: http://www.teratech.com/ Email: mailto:[EMAIL PROTECTED] ICQ: 66057682 Winner in CFDJ awards Best Consulting. Member Team Fusebox. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306758 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Adobe ColdFusion Survey
Woah - whats the last question? (Yes I'm too lazy to click on a link.) Who has the biggest shoes in the CF Community? Dominic ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306759 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Adobe ColdFusion Survey
Sorry... I don't know Raymonds shoe size, but I think I would have at least 1... On my left foot, Size 17 1/2 mens. Bus accident. Don't ask. On Tue, Jun 3, 2008 at 1:56 PM, Dominic Watson [EMAIL PROTECTED] wrote: Woah - whats the last question? (Yes I'm too lazy to click on a link.) Who has the biggest shoes in the CF Community? Dominic ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306760 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: do not increase counter is returns 0
Gerald, Regarding grammar and writing skill (and forgive me because I don't know this) but is it possible there is a language barrier here? The subject line above reminds me of someone for whom English is possibly a second language. I don't know Erick but I certainly don't want to chase people away from the community on the basis of grammar if they already know (at least) one more language than I do :) -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Gerald Guido [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 03, 2008 3:37 PM To: CF-Talk Subject: Re: do not increase counter is returns 0 I really don't think this response is appropriate and I'm sure that most of the community feels the same way. How about next time instead of saying You're an idiot, you either give some good advice or don't respond? That way there's no waste of everyone else's time reading posts that aren't helpful. You might also find that you'll get better responses to any questions you have if you're nice. -- Normally I do not get involved with this sort of thing but I feel the need to offer my unsolicited opinion. ;) Katrina I agree with you 100% in spirit. There are a lot of ugly communities on the web where people are flat out mean to each other, and I hate that with a passion. All in all, this is a very good group of people. IMHO, the CF community is one of the best on the net. There is some bickering here and there but in general most everyone here is extremely helpful and very polite. Often time people go *way out their way* to help people. Not to mention that some people here are down right brilliant. With that said, before you pass judgment on Brian, please take a moment to review at the questions that Erik Tom posts here. I think you will find that nearly all of them are poorly thought out, poorly worded, full of horrendous grammar and spelling errors and at times don't even make sense. It is as if he doesn't care. Look, we are talking about a guy who forwarded a Nigerian Lotto scam email to this list. People come here to learn and share their knowledge with the community. This list is a two way street. If you expect someone to take the time to answer your question please be respectful enough to take the time to ask a thoughtful, well worded question. Or at least Google it or crack open a book or RTM before post to a list. We are talking Netiquette 101. Respectfully, Gerald -- The important thing in science is not so much to obtain new facts as to discover new ways of thinking about them. - Sir William Bragg ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306761 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Adobe ColdFusion Survey
I would have guessed Dave Watts. Or is that hat size Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Phillip Vector [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 03, 2008 3:59 PM To: CF-Talk Subject: Re: Adobe ColdFusion Survey Sorry... I don't know Raymonds shoe size, but I think I would have at least 1... On my left foot, Size 17 1/2 mens. Bus accident. Don't ask. On Tue, Jun 3, 2008 at 1:56 PM, Dominic Watson [EMAIL PROTECTED] wrote: Woah - whats the last question? (Yes I'm too lazy to click on a link.) Who has the biggest shoes in the CF Community? Dominic ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306762 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Adobe ColdFusion Survey
Who's the Advanced CF track chair. -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 03, 2008 3:52 PM To: CF-Talk Subject: Re: Adobe ColdFusion Survey Woah - whats the last question? (Yes I'm too lazy to click on a link.) On Tue, Jun 3, 2008 at 3:26 PM, Andy Matthews [EMAIL PROTECTED] wrote: So as to make it simple, the answers to the last 3 questions are: 1) 2005 2) 1:30 3) Ray Camden While I'd love to win a touch, it's a little over the top to research questions when we're already giving you information about our purchase and upgrade habits, PLUS our email addresses. -Original Message- From: Michael Smith [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 03, 2008 2:34 PM To: CF-Talk Subject: Adobe ColdFusion Survey There is a new quick survey for everyone in the CF community to participate in. The results will be shared directly with Adobe and the general public. We want to know what version of ColdFusion you are using now. Plus a few questions to help us prepare for the CFUnited conference. Answer all 8 questions by June 11th and be entered in a raffle to win a brand new iTouch! http://cfunited.com/blog/index.cfm/2008/5/28/Adobe-ColdFusion-Survey-a nd-Sca venger-Hunt Thanks! -- Due to TeraTech's growth we are seeking winning sales people to sell custom software. For more details: http://www.teratech.com/go/about-us/jobsjobsaction=detailjobid=3 Michael Smith, TeraTech, Inc 405 E Gude Dr Ste 207, Rockville MD 20850 Voice: +1-301-424-3903 x110 Fax:301-762-8185 Web: http://www.teratech.com/ Email: mailto:[EMAIL PROTECTED] ICQ: 66057682 Winner in CFDJ awards Best Consulting. Member Team Fusebox. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306763 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CSV Generation MEMORY SUCK
Just a 411 I found a nice little tute on generating csv's using the StringBuffer class in ColdFusion http://www.stillnetstudios.com/2007/03/07/java-strings-in-coldfusion/ -- The important thing in science is not so much to obtain new facts as to discover new ways of thinking about them. - Sir William Bragg ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306764 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Page refresh to current position after record delete
And I thought google.com would have been an even better answer :) While an exact example may not exist, I think searching the net for Ajax examples that delete things could be found. I can not find it right now but thought I once saw a tutorial for a contact manager that used CF and did deletion of contacts via Ajax amongst other things. On Tue, Jun 3, 2008 at 3:52 PM, Dominic Watson [EMAIL PROTECTED] wrote: That was very helpful. Thanks so much. By using an ajax approach, the page would not refresh when you deleted the item. You hit the 'delete' button, javascript sends an asynchronous request to the system to delete the record; when the response comes back, javascript removes the display of the record in the page and the user's scroll position has not changed. There would be no tutorial for that as such. If you have not used ajax, google 'getting started with ajax', etc. Dominic -- Blog it up: http://fusion.dominicwatson.co.uk ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306765 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: do not increase counter is returns 0
True. I have wondered that too. I actually thought the same thing right after I sent the email. I don't want to chase off ppl either. On Tue, Jun 3, 2008 at 5:02 PM, Mark Kruger [EMAIL PROTECTED] wrote: Gerald, Regarding grammar and writing skill (and forgive me because I don't know this) but is it possible there is a language barrier here? The subject line above reminds me of someone for whom English is possibly a second language. I don't know Erick but I certainly don't want to chase people away from the community on the basis of grammar if they already know (at least) one more language than I do :) -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -- The important thing in science is not so much to obtain new facts as to discover new ways of thinking about them. - Sir William Bragg ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306766 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: do not increase counter is returns 0
I want to thank Gerald for his thoughtful post to this discussion. I did not understand the history behind these emails and this discussion was very unsettling. Gerald's email helped me better understand what led up to today's discussion. The only thing I want to add is that while a post may be directed at one person, it can be read by everyone and misunderstood by anyone. And not only can anyone read every post, any post can be making a first impression to a new visitor. I nearly didn't ask my first question a month ago because I was intimidated by a similar exchange. I personally appreciate every question asked and every answer provided in assistance. Since joining this list I have learned a lot from the simple questions that people post. I occasionally see a question that I can answer and then I will see an answer that is better than one I would have given or did give. I would like to thank you all for the assistance you provide. Brian -Original Message- From: Gerald Guido [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 03, 2008 1:37 PM To: CF-Talk Subject: Re: do not increase counter is returns 0 I really don't think this response is appropriate and I'm sure that most of the community feels the same way. How about next time instead of saying You're an idiot, you either give some good advice or don't respond? That way there's no waste of everyone else's time reading posts that aren't helpful. You might also find that you'll get better responses to any questions you have if you're nice. -- Normally I do not get involved with this sort of thing but I feel the need to offer my unsolicited opinion. ;) Katrina I agree with you 100% in spirit. There are a lot of ugly communities on the web where people are flat out mean to each other, and I hate that with a passion. All in all, this is a very good group of people. IMHO, the CF community is one of the best on the net. There is some bickering here and there but in general most everyone here is extremely helpful and very polite. Often time people go *way out their way* to help people. Not to mention that some people here are down right brilliant. With that said, before you pass judgment on Brian, please take a moment to review at the questions that Erik Tom posts here. I think you will find that nearly all of them are poorly thought out, poorly worded, full of horrendous grammar and spelling errors and at times don't even make sense. It is as if he doesn't care. Look, we are talking about a guy who forwarded a Nigerian Lotto scam email to this list. People come here to learn and share their knowledge with the community. This list is a two way street. If you expect someone to take the time to answer your question please be respectful enough to take the time to ask a thoughtful, well worded question. Or at least Google it or crack open a book or RTM before post to a list. We are talking Netiquette 101. Respectfully, Gerald -- The important thing in science is not so much to obtain new facts as to discover new ways of thinking about them. - Sir William Bragg ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306767 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: How do you create a scalable solution?
Some of that stuff has to do with scalability, and other bits have to do with maintainability. Basically, the golden rule of maximizing scalability is to do as little work at runtime as possible. This can be accomplished through caching (doing work before runtime) and asynchronous processing (doing work after runtime). Dave, would this include things like, removing returntypes from arguments in a cfc? Thanks, Will ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306768 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: How do you create a scalable solution?
Randy Johnson - CFConcepts wrote: If I had to make a site like Twitter that was scalable, how would I do that? But really that's only part of it. My coldfusion site needs to be coded to be scalable too.. So writing code to be scalable doesn't seem to be all that difficult, writing good efficient code in a modular way seems to be a good start. Modular is good, decoupling is an important part of scalability. Static websites scale because one webserver does not need to know anything about another webserver to be able to answer a request for static content. Doubling the number of webservers quite literally doubles your capacity. Transactional databases on the other hand behave very differently, because due to their transactional nature one server needs to know what another one is doing so for each request it needs to communicate with its peers. When it gets more peers, there is more communication and in the end the number of deadlocks goes up with the third power of the number of active nodes: ftp://ftp.research.microsoft.com/pub/tr/tr-96-17.pdf The next component is databases. I have read with Mysql that replication is how you can use multiple databases. I haven't done to much research on this, my initial questions would you use a db server for users, a db server for messages, db for each component?? If you were to do that, you would need to join the users in one database to the messages in another one. If those databases are on different servers, that is incredibly slow. Even a 1 Gbit/s network is 50 times slower then the connection between a CPU and RAM and has 100 (1000?) times more latency. A good way to make your database scale is to make sure it remains small and local. Stick X users on each database server together with everything they need to answer any request from the database that may arrive from the application. And user X+1 goes on a new database on the next piece of hardware. I don't know much more about Twitter then you can I can see when I click on some page, but I guess for your Twitter example that would mean each database would have: - users table - friends table - followers table Whenever user X adds friend Y, you fix your application code to make sure that there are actually 2 inserts: in the friends table on the database server of user X you add name, image and URL of user Y, in the followers table on the database of user Y you add name, image and URL of user X. This is denormalized, double storage, you pay the price of having to run twice the updates (of hundreds of times the updates when somebody changes his image URL), but your thousands of gets for the latest update of a stream can use a simple, fast, in-memory local database. Utility tables like languages, a list of countries etc. are present on all servers and are completely mirrored. Obviously what you loose here if you look at the system as a whole are the A and C from ACID. For a site like twitter that would seem to be a reasonable price to pay, but nobody would want his bank to work this way. I know a few people on this list have setup Scalable websites, clusters, load balancing etc. Where did you all learn how to do such things? Read a lot (I second http://highscalability.com/), ask yourself how or why often enough and at some point you start seeing patterns. Jochem ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306769 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: How do you create a scalable solution?
On Tue, Jun 3, 2008 at 2:55 PM, Will Tomlinson [EMAIL PROTECTED] wrote: Some of that stuff has to do with scalability, and other bits have to do with maintainability. Basically, the golden rule of maximizing scalability is to do as little work at runtime as possible. This can be accomplished through caching (doing work before runtime) and asynchronous processing (doing work after runtime). Dave, would this include things like, removing returntypes from arguments in a cfc? You'll likely get a lot of different answers here, but I think if you're on CF8, you develop with type checking in place, but on the production box you set up the CF Admin to disable type checking. And... point of clarification. If you need to duck type because you need to duck type, go for it. I'm not suggesting that during development you should never duck type :) -- A byte walks into a bar and orders a pint. Bartender asks him What's wrong? Byte says Parity error. Bartender nods and says Yeah, I thought you looked a bit off. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306770 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF with PostgreSQL
Wil Genovese wrote: I have a general question. how many of you (us) CF'ers are using PostgreSQL for their database? Not that many. I've been using PostgreSQL for about 5 years. As I dig through RIAForge I see many projects are coded explicitly for a certain DB mostly MySQL or MSSQL, but not many if any for PostgreSQL. Why? If I were to guess I would say because it took a long time before PostgreSQL had a simple Windows installer and web developers needing less features. That has resulted in MySQL having significant mindshare. If you look at for instance mail servers that use a SQL backend to store account info (Postfix, Qmail, Dovecot, Exim etc.) then you will see that they can usually work with several databases (and projects I have followed usually had PostgreSQL support before they had MySQL support). Jochem ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306771 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF with PostgreSQL
Russ wrote: Does it support clustering out of the box? From what I remember the only solutions were commercial third party solutions. Clustering means something different to everybody. Some people say clustering and mean replication, other people really mean synchronous, multi-master, transactional replication with dynamic task parallelization and redistribution on a shared nothing infrastructure. What does it mean to you? Jochem ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306772 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Validating textfield in form for specific value...
Hello, I am currently fixing up a couple of forms and have hit a brick wall. I need the user to enter a code in order for the form to be submitted/verified. I need an error to be returned if the alphanumeric text in the code textfield does not match that which is specify. Will I have to do this in my MSSQL DB and compare the two? All of the data from the form is currently being pushed in to the DB and emailed if that helps. I appreciate any comments on how to do something like this. I can't find anything online. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306773 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF with PostgreSQL
Gerald Guido wrote: I understand that PostgreSQL is a lot like Oracle. So do tell, what is it that makes you adore it so? 1. I understand it. PostgreSQL internals translate extremely well to what you will read when you read a textbook on database systems. And what I don't understand I can just look up in the source code which I can actually understand despite the fact that I don't write C. 2. The emphasis on correctness, stability and security. 3. The licensing model. 4. The developers community is very open and very much a meritocracy. Jochem ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306774 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Page refresh to current position after record delete
And I thought google.com would have been an even better answe Forty two?! yelled Loonquawl. Is that all you've got to show for seven and a half million years' work? I checked it very thoroughly, said the computer, and that quite definitely is the answer. I think the problem, to be quite honest with you, is that you've never actually known what the question is. By using an ajax approach, the page would not refresh when you deleted the item. You hit the 'delete' button, javascript sends an asynchronous request to the system to delete the record; when the response comes back, javascript removes the display of the record in the page and the user's scroll position has not changed. I just needed to know the theory behind what AJAX would do. Gives me something solid to chase! Thanks very much. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306775 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CF with PostgreSQL
What I want is what the latest MySQL sort of provides. I want to have separate machines with local storage each running a DB daemon, and to be able to at least have automatic failover, and even better to have them both be master's (basically being able to do load balancing). So I would say something like the latter of what you've described. Russ -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 03, 2008 6:14 PM To: CF-Talk Subject: Re: CF with PostgreSQL Russ wrote: Does it support clustering out of the box? From what I remember the only solutions were commercial third party solutions. Clustering means something different to everybody. Some people say clustering and mean replication, other people really mean synchronous, multi-master, transactional replication with dynamic task parallelization and redistribution on a shared nothing infrastructure. What does it mean to you? Jochem ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306776 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: do not increase counter is returns 0
Katrina, I held off responding to you to wait for the other replies that I knew would be coming. Hopefully by this point you realize that your comments to me were rather far off the mark, and that folks with knowledge of this ongoing situation actually agree with me. I assume you must not have known what has gone on with Erik and hopefully these additional postings have supplied the context that my initial reply did not. But even still, I neither called him an idiot nor attempted to show how much more I know than the next guy. I would humbly ask that in the future, before you condemn me or put words in my mouth that you please make sure you aren't missing essential background information. I promise to do the same. ;-) Thanks, Brian On Tue, Jun 3, 2008 at 2:17 PM, Katrina Chapman [EMAIL PROTECTED] wrote: I haven't been a member of this list for a few years now, but I remember it being a place where even the most beginning person could come for advice. This is a community and not a place for you to show how much more you know than the next guy. I really don't think this response is appropriate and I'm sure that most of the community feels the same way. How about next time instead of saying You're an idiot, you either give some good advice or don't respond? That way there's no waste of everyone else's time reading posts that aren't helpful. You might also find that you'll get better responses to any questions you have if you're nice. *Down off my soap box now* Thank you, Katrina If people knew how hard I worked to gain my mastery, it wouldn't seem so wonderful after all. --Michelangelo - Original Message From: Brian Kotek [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, June 3, 2008 9:37:46 AM Subject: Re: do not increase counter is returns 0 If Erik would bother to read even the most basic book on SQL he could answer this himself since this could all be done in a couple of lines of SQL with no loops and no CFML at all. But he'd rather waste everyone else's time instead of spending 10 dollars. So please don't encourage him, Tom. ;-) On Tue, Jun 3, 2008 at 11:26 AM, Tom Chiverton [EMAIL PROTECTED] wrote: 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 cfif getTimeAvg1.recordcount gt 0 cfif getTimeAvg1.recordcount gt 0 and query.hours neq 0 and query.mineutes neq 0 ? -- Tom Chiverton This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.com. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306777 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: How do you create a scalable solution?
Dave, would this include things like, removing returntypes from arguments in a cfc? Yes, although it's generally more complicated and extensive than that. You'd simply do that in the CF 8 admin console. If you're using CF 7 or earlier, I wouldn't recommend writing your code not to specify data types just for that reason, though. 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! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306778 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Adobe ColdFusion Survey
I would have guessed Dave Watts. Or is that hat size That's not shoe size. Aww yeahh. 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! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306779 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Adobe ColdFusion Survey
That's not shoe size. Aww yeahh. Nice. I haven't been following this thread. Did anyone post the answers yet? Just askin'... ;) Fair is fair, right? G On Tue, Jun 3, 2008 at 8:05 PM, Dave Watts [EMAIL PROTECTED] wrote: I would have guessed Dave Watts. Or is that hat size That's not shoe size. Aww yeahh. 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! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306780 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Adobe ColdFusion Survey
On Tue, Jun 3, 2008 at 7:44 PM, Gerald Guido [EMAIL PROTECTED] wrote: That's not shoe size. Aww yeahh. Nice. I haven't been following this thread. Did anyone post the answers yet? Just askin'... ;) From Andy M. So as to make it simple, the answers to the last 3 questions are: 1) 2005 2) 1:30 3) Ray Camden -- Matt Williams It's the question that drives us. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306781 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Adobe ColdFusion Survey
Kind of defeats the spirit of the contest. Doesn't seem too bad to ask for 3 minutes of Googling to hit up their site when a prize is offered. Nic Matt Williams wrote: From Andy M. So as to make it simple, the answers to the last 3 questions are: 1) 2005 2) 1:30 3) Ray Camden -- Nicholas M. Tunney Blog: http://www.nictunney.com Adobe Certified Advanced ColdFusion MX7 Developer Adobe Certified Instructor Adobe Community Expert ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306782 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Adobe ColdFusion Survey
they're getting e-mail addresses out of it still. that's what they're going for and offering up the prize for :) On Tue, Jun 3, 2008 at 6:20 PM, Nicholas M Tunney [EMAIL PROTECTED] wrote: Kind of defeats the spirit of the contest. Doesn't seem too bad to ask for 3 minutes of Googling to hit up their site when a prize is offered. Nic Matt Williams wrote: From Andy M. So as to make it simple, the answers to the last 3 questions are: 1) 2005 2) 1:30 3) Ray Camden -- Nicholas M. Tunney Blog: http://www.nictunney.com Adobe Certified Advanced ColdFusion MX7 Developer Adobe Certified Instructor Adobe Community Expert ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306783 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Adobe ColdFusion Survey
Eh, oh well. If I were Michael I'd still be torqued ;) Nic Charlie Griefer wrote: they're getting e-mail addresses out of it still. that's what they're going for and offering up the prize for :) On Tue, Jun 3, 2008 at 6:20 PM, Nicholas M Tunney [EMAIL PROTECTED] wrote: Kind of defeats the spirit of the contest. Doesn't seem too bad to ask for 3 minutes of Googling to hit up their site when a prize is offered. Nic -- Nicholas M. Tunney Blog: http://www.nictunney.com Adobe Certified Advanced ColdFusion MX7 Developer Adobe Certified Instructor Adobe Community Expert ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306784 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
