Re: ColdFusion, MySQL 5.0.45, cfqueryparam, and the LIMIT keyword?

2008-01-29 Thread Tom Chiverton
On Tuesday 29 Jan 2008, Andy Matthews wrote:
 commenting out various portions of the query, etc. I finally tracked it
 down to my LIMIT keyword, which previously used cfqueryparams1. It appears

i.e.
SELCT a,b,c LIMIT cfqueryparam value=... 
?

I though CFQP only worked in WHERE clauses. Odd it didn't happen during your 
testing or development though ...

-- 
Tom Chiverton
Helping to assertively fashion real-time interfaces
on: http://thefalken.livejournal.com



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;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297634
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, MySQL 5.0.45, cfqueryparam, and the LIMIT keyword?

2008-01-29 Thread Andy Matthews
That's exactly what I thought. Worked just fine locally...but blows up with
that error when in production.


andy 

-Original Message-
From: Tom Chiverton [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, January 29, 2008 4:46 AM
To: CF-Talk
Subject: Re: ColdFusion, MySQL 5.0.45, cfqueryparam, and the LIMIT keyword?

On Tuesday 29 Jan 2008, Andy Matthews wrote:
 commenting out various portions of the query, etc. I finally tracked 
 it down to my LIMIT keyword, which previously used cfqueryparams1. It 
 appears

i.e.
SELCT a,b,c LIMIT cfqueryparam value=... 
?

I though CFQP only worked in WHERE clauses. Odd it didn't happen during your
testing or development though ...

--
Tom Chiverton
Helping to assertively fashion real-time interfaces
on: http://thefalken.livejournal.com



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;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297636
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Using __type__ to return objects to Flex

2008-01-29 Thread Tom Chiverton
On Tuesday 29 Jan 2008, Tom Chiverton wrote:
 Now, if I CFDUMP 'res', my 'prop's are correctly camelCased - just like in
 the query and the ActionScript object I'm aiming at.

Oh no, their not (not if I cfdump the right result !).

So the problem boils down to - given a query, how do you get the correctly 
cased column names ? 
GetMetaData[n].name is all lower case, for instance, and query.columnlist is 
all uppercase.

-- 
Tom Chiverton
Helping to preemptively build strategic solutions
on: http://thefalken.livejournal.com



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;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297638
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Using __type__ to return objects to Flex

2008-01-29 Thread Brian Kotek
Tom, are you sure your keys have the proper case? As far as I know, query
column names are all uppercase so I'm pretty sure that is where the problem
is coming from. To deal with this, I passed a list of property names with
the correct case to the AOP Advice doing this translation (using the
MetadataAwareAdvice that I blogged about) and loop over that list to set the
key names. That worked out fine for me so you can definitely use the
__type__ approach and have the translate to an ActionScript class with the
proper case. It just won't work using only the query column names as far as
I know.

On Jan 29, 2008 9:39 AM, Tom Chiverton [EMAIL PROTECTED] wrote:

 I'm playing with the method that seems to have been hiding from me for a
 while
 at :

 http://www.briankotek.com/blog/index.cfm/2008/1/28/Returning-Typed-Structs-vs-CFCs-to-Flex
 to generate arrays of value objects based of a query, without using
 createObject().
 Here, I've given my function a 'results' query, and a 'queryObect' string:
cfset res=ArrayNew(1)
cfset props=arguments.result.columnlist
cfoutput query=arguments.result
cfset res[arguments.result.currentRow
 ]=structNew()
cfset res[arguments.result.currentRow
 ]['__type__']=variables.queryObject
cfloop list=#props# index=prop
cfset res[arguments.result.currentRow][prop]
 = arguments.result[prop]
 [arguments.result.currentRow]  
/cfloop
/cfoutput

 Now, if I CFDUMP 'res', my 'prop's are correctly camelCased - just like in
 the
 query and the ActionScript object I'm aiming at.

 *BUT* the Serializing AMF/HTTP response output in the ColdFusion log
 file,
 indicates that all the keys of the struct have been changed to uppercase:
 [Flex] Serializing AMF/HTTP response
 Version: 3
  (Message #0 targetURI=/2/onResult, responseURI=)
(Typed Object #0 'flex.messaging.messages.AcknowledgeMessage')
  timestamp = 1.201616773456E12
  headers = (Object #1)
  body = (Object #2)
RESULT = true
DATA = (Array #3)
  [0] = (Typed Object #4 'reactor.project.foo.To.casesTo')
CLAIMHANDLERADRESS = Senior Legal Counsel  Group Head of
 Claims
 20 Manchester Square  London  W10 3AN

 And, of course, I get errors in Builders debug console when debugging the
 Flex
 application (before the result handler is called) saying :
 ReferenceError: Error #1056: Cannot create property CLAIMHANDLERADRESS on
 com.halliwells.flex.ici.vo.Cases.

 So, can __type__ not be used when properties are mixed case ? Or is there
 an
 alternative approach I've missed ?
 --
 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;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297639
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Using __type__ to return objects to Flex

2008-01-29 Thread Tom Chiverton
I'm playing with the method that seems to have been hiding from me for a while 
at : 
http://www.briankotek.com/blog/index.cfm/2008/1/28/Returning-Typed-Structs-vs-CFCs-to-Flex
to generate arrays of value objects based of a query, without using 
createObject().
Here, I've given my function a 'results' query, and a 'queryObect' string:
cfset res=ArrayNew(1) 
cfset props=arguments.result.columnlist   
cfoutput query=arguments.result
cfset res[arguments.result.currentRow]=structNew()
cfset 
res[arguments.result.currentRow]['__type__']=variables.queryObject
cfloop list=#props# index=prop
cfset res[arguments.result.currentRow][prop] = 
arguments.result[prop]
[arguments.result.currentRow]  
/cfloop
/cfoutput

Now, if I CFDUMP 'res', my 'prop's are correctly camelCased - just like in the 
query and the ActionScript object I'm aiming at.

*BUT* the Serializing AMF/HTTP response output in the ColdFusion log file, 
indicates that all the keys of the struct have been changed to uppercase:
[Flex] Serializing AMF/HTTP response
Version: 3
  (Message #0 targetURI=/2/onResult, responseURI=)
(Typed Object #0 'flex.messaging.messages.AcknowledgeMessage')
  timestamp = 1.201616773456E12
  headers = (Object #1)
  body = (Object #2)
RESULT = true
DATA = (Array #3)
  [0] = (Typed Object #4 'reactor.project.foo.To.casesTo')
CLAIMHANDLERADRESS = Senior Legal Counsel  Group Head of Claims  
20 Manchester Square  London  W10 3AN

And, of course, I get errors in Builders debug console when debugging the Flex 
application (before the result handler is called) saying :
ReferenceError: Error #1056: Cannot create property CLAIMHANDLERADRESS on 
com.halliwells.flex.ici.vo.Cases.

So, can __type__ not be used when properties are mixed case ? Or is there an 
alternative approach I've missed ?
-- 
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;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297637
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 v8.0 Standard Edition - Academic Edition

2008-01-29 Thread Don L
Ok, got you, so, in essence it's really you pay what you get, 'academic' less 
than 'standard', 'standard' less than 'enterprise'...
Thanks.

 No, it doesn't mean it's restricted to one IP address - it means it's
 simply not going to cope with enterprise-level demand. Some of the
 features are either absent or single-threaded and your deployment
 options are limited.
 


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297651
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Using __type__ to return objects to Flex

2008-01-29 Thread Tom Chiverton
On Tuesday 29 Jan 2008, Brian Kotek wrote:
 property names, is simple using my MetaDataAwareAdvice. You might have a
 
http://www.briankotek.com/blog/index.cfm/2008/1/16/Creating-A-MetadataAware-ColdSpring-Advice

I saw that, but I'd have to list the column names in the metadata XML as well 
as the reactor XML, if I'm following along...
 hmmm
My Advice could be passed the ReactorConfiguration bean, and use that to find 
out the (correctly cased) column names of a particular query (on the 
assumption that if you're __type__ is com.foo.bar.baz.data.vo.TableVO, you 
probably want the 'table' object from Reactor.

Does that sound totally unreasonable ?

-- 
Tom Chiverton
Helping to simultaneously aggregate open-source patterns
on: http://thefalken.livejournal.com



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;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297658
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 v8.0 Standard Edition - Academic Edition

2008-01-29 Thread Todd
And, after 30 days, Trial becomes Developer.

On Jan 29, 2008 10:55 AM, Dave Watts [EMAIL PROTECTED] wrote:

  Ok, got you, so, in essence it's really you pay what you get,
  'academic' less than 'standard', 'standard' less than 'enterprise'...

 There is no academic edition. There are four editions: Enterprise,
 Standard, Developer and Trial. Academic pricing is available for
 Enterprise
 and Standard. Developer is free in any case. Trial is a 30-day limited
 version of Enterprise.

 Dave Watts, CTO, Fig Leaf Software
 http://www.figleaf.com/


-- 
http://www.web-rat.com/


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297657
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: ColdFusion v8.0 Standard Edition - Academic Edition

2008-01-29 Thread Don L
Thank you, guys, for your very helpful info.  It looks like I'll have to bite 
the bullet (getting the standard edition...)

 Ok, got you, so, in essence it's really you pay what you get, 
 'academic' less than 'standard', 'standard' less than 'enterprise'...

There is no academic edition. There are four editions: Enterprise,
Standard, Developer and Trial. Academic pricing is available for Enterprise
and Standard. Developer is free in any case. Trial is a 30-day limited
version of Enterprise.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297656
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: ColdFusion v8.0 Standard Edition - Academic Edition

2008-01-29 Thread Todd
No.  It's a licensing terminology issue here, nothing more.  If you're
getting Academic Standard, then you're getting an Standard Edition with
Academic restrictions on it (i.e. Don't expect to be running a ecommerce
website on this license).  There is no degrading of versions except between
standard and enterprise and really, the feature degrading boils down to your
typical CARs / Server Monitor / unlimited threading are available in
enterprise, etc.

You should really contact your Adobe sales people and ask.  They're not
going to shoot you for asking.

On Jan 29, 2008 10:36 AM, Don L [EMAIL PROTECTED] wrote:

 Ok, got you, so, in essence it's really you pay what you get, 'academic'
 less than 'standard', 'standard' less than 'enterprise'...
 Thanks.

  No, it doesn't mean it's restricted to one IP address - it means it's
  simply not going to cope with enterprise-level demand. Some of the
  features are either absent or single-threaded and your deployment
  options are limited.
 


http://www.web-rat.com/


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297655
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, MySQL 5.0.45, cfqueryparam, and the LIMIT keywor d?

2008-01-29 Thread Dave Watts
 I though CFQP only worked in WHERE clauses.

No, you can use it anywhere you can put data in an SQL command. This varies
somewhat by database platform.

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;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297654
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Using __type__ to return objects to Flex

2008-01-29 Thread Brian Kotek
The column_name is actually in whatever case the column name is using in the
database. For a one-time generation this might be fine, but one definitely
wouldn't want to be doing this on every method call.

However, passing a DSN to an advice, or just a properly-formatted list of
property names, is simple using my MetaDataAwareAdvice. You might have a
look at that to see if it would work for you.
http://www.briankotek.com/blog/index.cfm/2008/1/17/Yet-More-ColdSpring-Joy-Example-Files-for-AbstractMetadataAwareAdvice

On Jan 29, 2008 10:35 AM, Tom Chiverton [EMAIL PROTECTED]
wrote:

 On Tuesday 29 Jan 2008, João_Fernandes wrote:
  I usually have dbinfo to get the needed metadata and generate my code
  based on that.

 This in the context of a piece of AOP AfterAdvice, so it doesn't really
 have
 the DSN to hand, never mind the table name, other wise yeah, that might
 work
 but I bet (without checking) that COLUMN_NAME is wrongly cased there too.




~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297653
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: ColdFusion v8.0 Standard Edition - Academic Edition

2008-01-29 Thread Dave Watts
 Ok, got you, so, in essence it's really you pay what you get, 
 'academic' less than 'standard', 'standard' less than 'enterprise'...

There is no academic edition. There are four editions: Enterprise,
Standard, Developer and Trial. Academic pricing is available for Enterprise
and Standard. Developer is free in any case. Trial is a 30-day limited
version of Enterprise.

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;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297652
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: ColdFusion v8.0 Standard Edition - Academic Edition

2008-01-29 Thread Todd
Pony up the money like any other long time cf'er?  I had at one point in
time, my own 2 licenses of standard.  I'm down to 1 now.

On Jan 29, 2008 11:23 AM, Don L [EMAIL PROTECTED] wrote:

 I know that part, thanks though.  How can one as a long time cfer to get a
 good deal out of this?

 And, after 30 days, Trial becomes Developer.




~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297660
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 8 code analyzer question

2008-01-29 Thread Andy Chen
 According to the article, CF 8 requires that 

This sounds like an error in the code analyzer. If your code works in CF8,
it's correct.

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!

I concur, I get errors with the Code Analyzer with the GetUserRoles and 
IsUserLoggedIn system functions. It thinks that I am having a UDF under that 
name. Now I just ignore those particular errors since everything is running 
fine. 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297662
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Using __type__ to return objects to Flex

2008-01-29 Thread Brian Kotek
On Jan 29, 2008 11:08 AM, Tom Chiverton [EMAIL PROTECTED]
wrote:

 On Tuesday 29 Jan 2008, Brian Kotek wrote:
  property names, is simple using my MetaDataAwareAdvice. You might have a
 

 http://www.briankotek.com/blog/index.cfm/2008/1/16/Creating-A-MetadataAware-ColdSpring-Advice

 I saw that, but I'd have to list the column names in the metadata XML as
 well
 as the reactor XML, if I'm following along...
  hmmm
 My Advice could be passed the ReactorConfiguration bean, and use that to
 find
 out the (correctly cased) column names of a particular query (on the
 assumption that if you're __type__ is com.foo.bar.baz.data.vo.TableVO, you
 probably want the 'table' object from Reactor.

 Does that sound totally unreasonable ?


It depends. The key would be to make sure that the overhead of doing this
doesn't outweigh the benefit. Might take some experimentation. One option
might be to cache the lookup for the property names of a given type in the
Advice, so that the lookup in the Reactor Config bean only happens once and
afterwards the cached data is used.

Regarding the type to table mapping, you could rely on a convention like
that, or again you could pass some metadata in that defines the table to use
along with the type.



 --
 Tom Chiverton
 Helping to simultaneously aggregate open-source patterns
 on: http://thefalken.livejournal.com

 

 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;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297661
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 v8.0 Standard Edition - Academic Edition

2008-01-29 Thread Don L
I know that part, thanks though.  How can one as a long time cfer to get a good 
deal out of this?

And, after 30 days, Trial becomes Developer.



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297659
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Using __type__ to return objects to Flex

2008-01-29 Thread Tom Chiverton
On Tuesday 29 Jan 2008, João_Fernandes wrote:
 I usually have dbinfo to get the needed metadata and generate my code
 based on that.

This in the context of a piece of AOP AfterAdvice, so it doesn't really have 
the DSN to hand, never mind the table name, other wise yeah, that might work 
but I bet (without checking) that COLUMN_NAME is wrongly cased there too.

-- 
Tom Chiverton
Helping to dynamically reintermediate interdependent segments
on: http://thefalken.livejournal.com



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;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297649
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: CF8 and IPv6

2008-01-29 Thread Ben Forta
Yes, CF8 does support IPv6 for debugging IP addresses. CF7 does have some
IPv6 support, but (if I remember correctly)) not for debugging addresses.

--- Ben


-Original Message-
From: Brian Kotek [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, January 29, 2008 10:08 AM
To: CF-Talk
Subject: Re: CF8 and IPv6

There was an update to CF7 to allow some support for IPv6 (in things like
GetLocalHostIP()), which obviously are carried over to CF8. But for debug
IPs I have no idea. I'd download the developer edition and try it.

On Jan 29, 2008 9:55 AM, DURETTE, STEVEN J (ATTASIAIT) [EMAIL PROTECTED]
wrote:

 Hi all,

 Just a quick question.  Is CF8 (or even 7) IPv6 compatible?  Will the
 ColdFusion Administrator debug ips work with IPv6?

 I'm being asked because our network is switching to IPv6 and this could
 be an issue if it doesn't handle it.

 Right now we are on CF7 (we own CF8 but change comes slowly around
 here), but if it can't handle it and CF8 does I might be able to force
 an early upgrade (they want 3rd or 4th qtr).


 Thanks,
 Steve


  Steve Durette
 586-466-7654
 [EMAIL PROTECTED]





 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297648
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Using __type__ to return objects to Flex

2008-01-29 Thread Tom Chiverton
On Tuesday 29 Jan 2008, Brian Kotek wrote:
 Yep, there's no way to do it directly from the query columns. 

That's what I was afraid of having hacked with various combinations of 
getMetaData() etc.
For us, it's going to be better to sticking to using the Adobe Eclipse plug in 
to generate AS VOs from Reactor's generated VOs.
We're not really hitting the performance issues because we only return a 
hundred or so (tops, and even then only once at start up) CFCs.

Still, it's a neat feature.

-- 
Tom Chiverton
Helping to widespreadedly orchestrate vertical products
on: http://thefalken.livejournal.com



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;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297647
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: ColdFusion, MySQL 5.0.45, cfqueryparam, and the LIMIT keyword?

2008-01-29 Thread Steve Brownlee
Andy:

Any idea how large your resultset is?  I know that the MySQL JDBC driver has
had problems crapping out on extremely large resultsets.  And by crapping
out, I mean, throwing the exception you're seeing.

- Steve Brownlee 

-Original Message-
From: Andy Matthews [mailto:[EMAIL PROTECTED] 
Sent: Monday, January 28, 2008 11:17 PM
To: CF-Talk
Subject: ColdFusion, MySQL 5.0.45, cfqueryparam, and the LIMIT keyword?

I've been dealing with a very odd, seemingly fringe issue and wanted to post
about it. I believe I figured out how to get around it, but I'm not sure
what's causing it.

My host is running the following apps/versions:

ColdFusion: 8,0,0,176276
MySQL: 5.0.45-community-nt

I have a dynamic query that I'm calling via a CFC. On my environment it
works just fine, but on my host's servers, calling this specific query
returned a Communications Link Failure error. After doing some debugging,
commenting out various portions of the query, etc. I finally tracked it down
to my LIMIT keyword, which previously used cfqueryparams1. It appears that
when using this unique combination of things, I get this error. But when I
remove them, and just use plain old pounded variables, it works.

Does anyone know anything about this, why it's happening, and what I might
do for my host? Is it possible that they're just running a few point
releases behind? Doing some online research for that error, I find some
posts from Ray Camden (and others) suggesting that it might be the JDBC
drivers.





~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297646
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Using __type__ to return objects to Flex

2008-01-29 Thread Brian Kotek
Yep, there's no way to do it directly from the query columns. You either
have to write your own VO CFC (which can then obviously have the proper
case), or you have to give this code a list of the properly-formatted
property names. Or of course you can have your AS class use all uppercase
property names.

On Jan 29, 2008 9:53 AM, Tom Chiverton [EMAIL PROTECTED] wrote:

 On Tuesday 29 Jan 2008, Tom Chiverton wrote:
  Now, if I CFDUMP 'res', my 'prop's are correctly camelCased - just like
 in
  the query and the ActionScript object I'm aiming at.

 Oh no, their not (not if I cfdump the right result !).

 So the problem boils down to - given a query, how do you get the correctly
 cased column names ?
 GetMetaData[n].name is all lower case, for instance, and query.columnlistis
 all uppercase.

 --
 Tom Chiverton
 Helping to preemptively build strategic solutions
 on: http://thefalken.livejournal.com

 

 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;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297641
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


CF8 and IPv6

2008-01-29 Thread DURETTE, STEVEN J (ATTASIAIT)
Hi all,
 
Just a quick question.  Is CF8 (or even 7) IPv6 compatible?  Will the
ColdFusion Administrator debug ips work with IPv6?
 
I'm being asked because our network is switching to IPv6 and this could
be an issue if it doesn't handle it.
 
Right now we are on CF7 (we own CF8 but change comes slowly around
here), but if it can't handle it and CF8 does I might be able to force
an early upgrade (they want 3rd or 4th qtr).
 
 
Thanks,
Steve
 
 
 Steve Durette
586-466-7654
[EMAIL PROTECTED] 
 
 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297640
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 and IPv6

2008-01-29 Thread Brian Kotek
There was an update to CF7 to allow some support for IPv6 (in things like
GetLocalHostIP()), which obviously are carried over to CF8. But for debug
IPs I have no idea. I'd download the developer edition and try it.

On Jan 29, 2008 9:55 AM, DURETTE, STEVEN J (ATTASIAIT) [EMAIL PROTECTED]
wrote:

 Hi all,

 Just a quick question.  Is CF8 (or even 7) IPv6 compatible?  Will the
 ColdFusion Administrator debug ips work with IPv6?

 I'm being asked because our network is switching to IPv6 and this could
 be an issue if it doesn't handle it.

 Right now we are on CF7 (we own CF8 but change comes slowly around
 here), but if it can't handle it and CF8 does I might be able to force
 an early upgrade (they want 3rd or 4th qtr).


 Thanks,
 Steve


  Steve Durette
 586-466-7654
 [EMAIL PROTECTED]





 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297644
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 and IPv6

2008-01-29 Thread Todd
 Yes, it is... in the debugging IP textbox, one of the IP sets is:

0:0:0:0:0:0:0:1

My understanding, that's localhost equivalent of 127.0.0.1

On Jan 29, 2008 9:55 AM, DURETTE, STEVEN J (ATTASIAIT) [EMAIL PROTECTED]
wrote:

 Hi all,

 Just a quick question.  Is CF8 (or even 7) IPv6 compatible?  Will the
 ColdFusion Administrator debug ips work with IPv6?

 I'm being asked because our network is switching to IPv6 and this could
 be an issue if it doesn't handle it.

 Right now we are on CF7 (we own CF8 but change comes slowly around
 here), but if it can't handle it and CF8 does I might be able to force
 an early upgrade (they want 3rd or 4th qtr).


 Thanks,
 Steve


  Steve Durette
 586-466-7654
 [EMAIL PROTECTED]





 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297642
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: cfinput binding onchange

2008-01-29 Thread Dominic Watson
Ok, I have come up with a solution that works - if there's a better way
please let me know! First, I created a couple of simple javascript
functions to blur and then refocus the supplied input object after a given
delay (object passed by id, IE won't do the delay thing the way I would like
just passing the object):

keyUpRefresh = function(objId, delay){
window.setTimeout(refreshFocus(' + objId + '), delay);
}

refreshFocus
= function(objId){
var obj = document.getElementById(objId);
obj.blur(); obj.focus();;
}

Then, in the cfinput, I just do something like:

cfinput name=foo onkeyup=keyUpRefresh(this.id,1000)
It feels a little hacky but it does work :)

Dominic


On 28/01/2008, Dominic Watson [EMAIL PROTECTED] wrote:

 I've just started out with CF8 and all the Ajax stuff is blowing me away,
 gonna save me a ton of time on my current job :). Anyways, I have a cfgrid
 that is bound to a cfc method and has arguments that are bound to other form
 elements:

 cfgrid name=SchoolGrid striperows=true format=html pagesize=10
   bind=cfc:AjaxController.GetSchools({cfgridpage}, {cfgridpagesize},
 {cfgridsortcolumn}, {cfgridsortdirection}, {RegionId}, {CountyId}, {TownId},
 {SchoolTypeId}, {PostCode})

 RegionId, CountyId, TownId and SchoolTypeId are all cfselects and
 PostCode is a cfinput (text). So far so good and it all works like a dream
 with the exception that, in order for the PostCode entry to effect the
 results in the cfgrid, the user has to click outside the cfinput.
 So my question is, is there an easy way to get this bind to update on an
 onchange event for the cfinput? i.e. as the user types into the
 'postcode' input, the contents of the cfgrid change according to the
 binding.
 Thanks in advance,

 Dominic

 --
 Blog it up: http://fusion.dominicwatson.co.uk




-- 
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;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297635
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: CMS Solution Recommendations

2008-01-29 Thread Brian Kotek
Not sure where you're looking, FarCry is constantly updated. I'd definitely
check it out. http://www.farcrycms.org/

On Jan 29, 2008 12:39 PM, Nate Willard [EMAIL PROTECTED] wrote:

 Hello,

 Can anyone recommend a Coldfusion CMS solution? Also,
 is your recommendation currently supported?

 I look at FarCry and it seems that the web site and
 code hasn't been updated in 2 years?

 Thanks


 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297666
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: CMS Solution Recommendations

2008-01-29 Thread Bruce Sorge
Actually FarCry has been recently update to v-4. I played around with it 
for quite a bit and was very very impressed, and even made sure to vote 
for it in the webby awards recently. And if it were not for the fact 
that I could not get the stupid navigation to do exactly what I wanted I 
would have already converted out entire district website over to FarCry. 
That was the ONLY thing keeping me from implementing it.
There are some other CF cms's that you might want to look at.

Speck (http://www.speckcms.org/)

There is one by someone on this list named Matt Robertson but I cannot 
recall the name. It was a pretty solid app as well but lacked recent 
documentation.

I am sure that there are others that will be mentioned  but these are 
the three that I have had personal experience with.

Bruce

-- 
Throttle Jockey - 
Why golf courses should be motocross tracks


Nate Willard wrote:
 Hello,

 Can anyone recommend a Coldfusion CMS solution? Also,
 is your recommendation currently supported?

 I look at FarCry and it seems that the web site and
 code hasn't been updated in 2 years? 

 Thanks
   


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297667
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: CMS Solution Recommendations

2008-01-29 Thread Mark Kruger
Nate,

FC released version 4 last summer and version 5 is in progress. It has a
vibrant development community. Where were you looking?

-mark
 

-Original Message-
From: Nate Willard [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, January 29, 2008 11:39 AM
To: CF-Talk
Subject: CMS Solution Recommendations

Hello,

Can anyone recommend a Coldfusion CMS solution? Also, is your recommendation
currently supported?

I look at FarCry and it seems that the web site and code hasn't been updated
in 2 years? 

Thanks




~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297668
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: ColdFusion, MySQL 5.0.45, cfqueryparam, and the LIMIT keyword?

2008-01-29 Thread Josh Nathanson
I am having the same issue, with CF8/MySql 5 on my installation of BlogCFC, 
and haven't seen any solutions thus far.  The problem is intermittent but it 
seems to happen pretty regularly.

The BlogCFC forum at RIAforge has this post:
http://www.coldfusionjedi.com/forums/messages.cfm?threadid=83FA26F7-19B9-E658-9D258B669DE98D60

And I also posted there:
http://www.coldfusionjedi.com/forums/messages.cfm?threadid=2BDF68EF-19B9-E658-9DDB2C6260E2CD89

Not saying it's BlogCFC related specifically, but there is some code in 
there that seems to bring up the JDBC database connectivity issue.  Not sure 
what the problem is though, everything there looks hunky dory to me.

-- Josh


- Original Message - 
From: Andy Matthews [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Monday, January 28, 2008 9:16 PM
Subject: ColdFusion, MySQL 5.0.45, cfqueryparam, and the LIMIT keyword?


 I've been dealing with a very odd, seemingly fringe issue and wanted to 
 post about it. I believe I figured out how to get around it, but I'm not 
 sure what's causing it.

 My host is running the following apps/versions:

 ColdFusion: 8,0,0,176276
 MySQL: 5.0.45-community-nt

 I have a dynamic query that I'm calling via a CFC. On my environment it 
 works just fine, but on my host's servers, calling this specific query 
 returned a Communications Link Failure error. After doing some 
 debugging, commenting out various portions of the query, etc. I finally 
 tracked it down to my LIMIT keyword, which previously used cfqueryparams1. 
 It appears that when using this unique combination of things, I get this 
 error. But when I remove them, and just use plain old pounded variables, 
 it works.

 Does anyone know anything about this, why it's happening, and what I might 
 do for my host? Is it possible that they're just running a few point 
 releases behind? Doing some online research for that error, I find some 
 posts from Ray Camden (and others) suggesting that it might be the JDBC 
 drivers.



 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297663
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, MySQL 5.0.45, cfqueryparam, and the LIMIT keyword?

2008-01-29 Thread Andy Matthews
4 records, with about 6 or 7 columns apiece. 

-Original Message-
From: Steve Brownlee [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, January 29, 2008 9:12 AM
To: CF-Talk
Subject: RE: ColdFusion, MySQL 5.0.45, cfqueryparam, and the LIMIT keyword?

Andy:

Any idea how large your resultset is?  I know that the MySQL JDBC driver has
had problems crapping out on extremely large resultsets.  And by crapping
out, I mean, throwing the exception you're seeing.

- Steve Brownlee 

-Original Message-
From: Andy Matthews [mailto:[EMAIL PROTECTED]
Sent: Monday, January 28, 2008 11:17 PM
To: CF-Talk
Subject: ColdFusion, MySQL 5.0.45, cfqueryparam, and the LIMIT keyword?

I've been dealing with a very odd, seemingly fringe issue and wanted to post
about it. I believe I figured out how to get around it, but I'm not sure
what's causing it.

My host is running the following apps/versions:

ColdFusion: 8,0,0,176276
MySQL: 5.0.45-community-nt

I have a dynamic query that I'm calling via a CFC. On my environment it
works just fine, but on my host's servers, calling this specific query
returned a Communications Link Failure error. After doing some debugging,
commenting out various portions of the query, etc. I finally tracked it down
to my LIMIT keyword, which previously used cfqueryparams1. It appears that
when using this unique combination of things, I get this error. But when I
remove them, and just use plain old pounded variables, it works.

Does anyone know anything about this, why it's happening, and what I might
do for my host? Is it possible that they're just running a few point
releases behind? Doing some online research for that error, I find some
posts from Ray Camden (and others) suggesting that it might be the JDBC
drivers.







~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297650
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Using __type__ to return objects to Flex

2008-01-29 Thread Jo�o_Fernandes
I usually have dbinfo to get the needed metadata and generate my code 
based on that.

Something that should be implemented for CF9 would be something similar 
that LCDS support that is QueryRowType. With this kind of functionality, 
you can return directly your queries to the client and they will get 
converted to the corresponding AS classes.
-- 

João Fernandes

http://www.onflexwithcf.org
http://www.riapt.org


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297645
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


CMS Solution Recommendations

2008-01-29 Thread Nate Willard
Hello,

Can anyone recommend a Coldfusion CMS solution? Also,
is your recommendation currently supported?

I look at FarCry and it seems that the web site and
code hasn't been updated in 2 years? 

Thanks


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297664
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: CMS Solution Recommendations

2008-01-29 Thread C. Hatton Humphrey
 Can anyone recommend a Coldfusion CMS solution? Also,
 is your recommendation currently supported?

 I look at FarCry and it seems that the web site and
 code hasn't been updated in 2 years?

I have recently become a BIG fan of BeSavvy.  That is where I was
recommended some time back and I will wholeheartedly forward that
recommendation.

Hatton

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297665
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


CF-Based CRMs?

2008-01-29 Thread Rey Bango
I'm looking for a CF-based CRM. Anyone know of a good one?

Rey

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297669
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: CF8 and IPv6

2008-01-29 Thread Todd
I meant to clarify that this is CF8 Debugging.

On Jan 29, 2008 10:03 AM, Todd [EMAIL PROTECTED] wrote:

 Yes, it is... in the debugging IP textbox, one of the IP sets is:

 0:0:0:0:0:0:0:1

 My understanding, that's localhost equivalent of 127.0.0.1




~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297643
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 8 code analyzer question

2008-01-29 Thread Matthew Smith
Thank you both for the response. 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297672
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: CFIMAGE- stacking images

2008-01-29 Thread Ben Forta
ImageNew() to create a new blank image. ImageRead() and ImagePaste() to
paste first image, then another ImageNew() and ImagePaste() setting the x
and y so that it is where you want it relative to first image. Or just take
all of that and make a ImageAppend() function that dos it for you.

--- Ben


-Original Message-
From: Daniel Baughman [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, January 29, 2008 2:14 PM
To: CF-Talk
Subject: CFIMAGE- stacking images

Hello all,

I keep trying to find ways to use CFIMAGE but almost every time am forced to
use another tool...

Is there any way to append images?  IE I have one image, a photo, that I
want to append a polaroid-like bottom to. It seems this is outside the
functionality of the CFIMAGE tag.  Or am I missing something?

- Dan




~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297671
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


CFIMAGE- stacking images

2008-01-29 Thread Daniel Baughman
Hello all,

I keep trying to find ways to use CFIMAGE but almost every time am forced to
use another tool...

Is there any way to append images?  IE I have one image, a photo, that I
want to append a polaroid-like bottom to. It seems this is outside the
functionality of the CFIMAGE tag.  Or am I missing something?

- Dan


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297670
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: CFIMAGE- stacking images

2008-01-29 Thread Ian Skinner
Ben Forta wrote:
 ImageNew() to create a new blank image. ImageRead() and ImagePaste() to
 paste first image, then another ImageNew() and ImagePaste() setting the x
 and y so that it is where you want it relative to first image. Or just take
 all of that and make a ImageAppend() function that dos it for you.

 --- Ben
   
An important point to get out of this is that the cfimage... tag is
for basic day-in and day-out image tasks.  If one needs more power the
image functions are where they are at.  They can be combined in many
powerful ways.





~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297675
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 v8.0 Standard Edition - Academic Edition

2008-01-29 Thread Azadi Saryev
and, if i am not mistaken, any time you enter a valid licence key, your 
trial/dev edition turns into a standard/enterprise one.
and if you remove the licence key it reverts back to dev edition (?)

---
Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com



Todd wrote:
 And, after 30 days, Trial becomes Developer.

 On Jan 29, 2008 10:55 AM, Dave Watts [EMAIL PROTECTED] wrote:

   
 Ok, got you, so, in essence it's really you pay what you get,
 'academic' less than 'standard', 'standard' less than 'enterprise'...
   
 There is no academic edition. There are four editions: Enterprise,
 Standard, Developer and Trial. Academic pricing is available for
 Enterprise
 and Standard. Developer is free in any case. Trial is a 30-day limited
 version of Enterprise.

 Dave Watts, CTO, Fig Leaf Software
 http://www.figleaf.com/

 

   

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297674
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Speaking of nudity (NSFW)

2008-01-29 Thread Andy Matthews
Keep looking Dave...you'll see it eventually. 

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, January 29, 2008 3:47 PM
To: CF-Talk
Subject: RE: Speaking of nudity (NSFW)

 Just ran into this one:
 
 http://fr.news.yahoo.com/afp/20080128/img/pod-allemagne-touris
 me-nudi-44ec2938cfb00.html

No matter how long I stare at that, I fail to see the connection with CF.

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;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297684
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: CMS Solution Recommendations

2008-01-29 Thread Geoff Bowers
On 30/01/2008, Bruce Sorge [EMAIL PROTECTED] wrote:
 Actually FarCry has been recently update to v-4. I played around with it
 for quite a bit and was very very impressed, and even made sure to vote
 for it in the webby awards recently.

That's great to hear :)

 And if it were not for the fact
 that I could not get the stupid navigation to do exactly what I wanted I
 would have already converted out entire district website over to FarCry.
 That was the ONLY thing keeping me from implementing it.

FarCry generates navigation information as either a cfquery or more
usefully as a semantically correct, nested, unordered list.  The vast
majority of CSS based navigation UI is based on the latter.  You
probably need a little CSS help on a forum dedicated to CSS design to
get things going.

The default Mollio [1] template menus are based on the Son of
Suckerfish [2] menus. But there are many, many different
implementations of UL/LI element based menus out there.

All the best,

-- 
geoff
http://www.daemon.com.au/

[1]: http://www.mollio.org/
[2]: http://www.htmldog.com/articles/suckerfish/

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297683
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: ColdFusion slow database connection to SQL2005

2008-01-29 Thread Dana Kowalski
is the data source setup as a native sql driver or ODBC? I've run into speed 
problems in the past when we had to use the ODBC instead of the native sql one.

also, if you go into the mgmt. studio and run the same query in the query tool 
is the response immediate and much faster? If not, maybe check the tables 
themselves for proper indexing? 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297682
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Speaking of nudity (NSFW)

2008-01-29 Thread Bruce Sorge
Sorry. My bad. moving it now.

Dave Watts wrote:

 No matter how long I stare at that, I fail to see the connection with CF.
   

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297681
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: CMS Solution Recommendations

2008-01-29 Thread Geoff Bowers
On 30/01/2008, Nate Willard [EMAIL PROTECTED] wrote:
 I look at FarCry and it seems that the web site and
 code hasn't been updated in 2 years?

Apologies for letting the side down there.  The main website is due
for a major revamp and some areas are a little stale.. we're just
about to put out a supported beta of FarCry v5 so we're a little bit
busy -- its going to be an awesome release.

The pubilc site is really just a landing point for the following
primary areas of FarCry activity:
http://bugs.farcrycms.org/ (issue tracking, roadmaps, etc)
http://docs.farcrycms.org/ (docs: user, developer  plugins)
http://groups.google.com/group/farcry-dev (primary dev forum)

FarCry is about to see its 2nd major release in 2 years -- not to
mention v4 has had over 9 maintenance releases.  It's a pretty vibrant
code base.  For those that are interested you can review commits and
changes as they happen here:
http://fisheye.farcrycms.org/changelog/core/

Best regards,

-- 
geoff
http://www.daemon.com.au/

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297685
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: Speaking of nudity (NSFW)

2008-01-29 Thread Dave Watts
 Just ran into this one:
 
 http://fr.news.yahoo.com/afp/20080128/img/pod-allemagne-touris
 me-nudi-44ec2938cfb00.html

No matter how long I stare at that, I fail to see the connection with CF.

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;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297680
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: CFIMAGE- stacking images

2008-01-29 Thread Raymond Camden
Good point Ian. That's exactly what I tell folks as well. About the
only thing I think the tag can do that the functions can't is the
writeToBrowser action. Of course, CAPTCHA Is a _heck_ of a lot easier
with the tag.

On Jan 29, 2008 2:23 PM, Ian Skinner [EMAIL PROTECTED] wrote:
 Ben Forta wrote:
  ImageNew() to create a new blank image. ImageRead() and ImagePaste() to
  paste first image, then another ImageNew() and ImagePaste() setting the x
  and y so that it is where you want it relative to first image. Or just take
  all of that and make a ImageAppend() function that dos it for you.
 
  --- Ben
 
 An important point to get out of this is that the cfimage... tag is
 for basic day-in and day-out image tasks.  If one needs more power the
 image functions are where they are at.  They can be combined in many
 powerful ways.





 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297678
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: ColdFusion slow database connection to SQL2005

2008-01-29 Thread Tom Mollerus
Kevin, were you using ODBC socket connections, or ODBC connections?  Or, which 
driver exactly was it that you selected in the CF admin?  I'm having the same 
problems that you are, and I'm not sure that the upgrade of the JDBC drivers is 
going to fix the problem.  Thanks!

 Well I have just replaced the JDBC Drivers with the latest version 3.5. 
 This has reduced the time taken by a huge amount. There is no mention 
 in the docs of there being anything that would do that.
 
 The same change on the test server made no difference.
 
 Kevin 


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297679
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 v8.0 Standard Edition - Academic Edition

2008-01-29 Thread Todd
That's correct.

On Jan 29, 2008 11:32 AM, Azadi Saryev [EMAIL PROTECTED] wrote:

 and, if i am not mistaken, any time you enter a valid licence key, your
 trial/dev edition turns into a standard/enterprise one.
 and if you remove the licence key it reverts back to dev edition (?)

 ---
 Azadi Saryev
 Sabai-dee.com
 http://www.sabai-dee.com


-- 
http://www.web-rat.com/


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297676
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: CFIMAGE- stacking images

2008-01-29 Thread Ben Forta
Here's an ImageAppend() function for you. Pass it two image paths, and the
3rd Boolean flag is TRUE (default) to stack images on top of each other, or
FALSE to have them side by side. It returns an image object which you can
save, or write to the browser with cfimage action=writetobrowser.

--- Ben

cffunction name=ImageAppend returntype=any output=yes
cfargument name=image1 type=string required=yes
cfargument name=image2 type=string required=yes
cfargument name=vertical type=boolean required=no
default=TRUE

!--- Local vars ---
cfset var resultImage=
cfset var img1=ImageRead(ARGUMENTS.image1)
cfset var img2=ImageRead(ARGUMENTS.image2)
cfset var imgHeight=0
cfset var imgWidth=0
cfset var img2x=0
cfset var img2y=0

!--- Calculate size of new image ---
cfif ARGUMENTS.vertical
!--- Height is sum of both heights ---
cfset imgHeight=ImageGetHeight(img1)+ImageGetHeight(img2)
!--- Width is greater of the two widths ---
cfset imgWidth=ImageGetWidth(img1)
cfif ImageGetWidth(img2) GT imgWidth
cfset imgWidth=ImageGetWidth(img2)
/cfif
!--- Location of second image ---
cfset img2x=0
cfset img2y=ImageGetHeight(img1)
cfelse
!--- Width is sum of both widths ---
cfset imgWidth=ImageGetWidth(img1)+ImageGetWidth(img2)
!--- Height is greater of the two heights ---
cfset imgHeight=ImageGetHeight(img1)
cfif ImageGetHeight(img2) GT imgHeight
cfset imgHeight=ImageGetHeight(img2)
/cfif
!--- Location of second image ---
cfset img2x=ImageGetWidth(img1)
cfset img2y=0
/cfif

!--- Next create new image ---
cfset resultImage=ImageNew(, imgWidth, imgHeight)

!--- Paste first image ---
cfset ImagePaste(resultImage, img1, 0, 0)

!--- Paste second image ---
cfset ImagePaste(resultImage, img2, img2x, img2y)

cfreturn resultImage
/cffunction




-Original Message-
From: Ben Forta [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, January 29, 2008 2:18 PM
To: CF-Talk
Subject: RE: CFIMAGE- stacking images

ImageNew() to create a new blank image. ImageRead() and ImagePaste() to
paste first image, then another ImageNew() and ImagePaste() setting the x
and y so that it is where you want it relative to first image. Or just take
all of that and make a ImageAppend() function that dos it for you.

--- Ben


-Original Message-
From: Daniel Baughman [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, January 29, 2008 2:14 PM
To: CF-Talk
Subject: CFIMAGE- stacking images

Hello all,

I keep trying to find ways to use CFIMAGE but almost every time am forced to
use another tool...

Is there any way to append images?  IE I have one image, a photo, that I
want to append a polaroid-like bottom to. It seems this is outside the
functionality of the CFIMAGE tag.  Or am I missing something?

- Dan






~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297673
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


CF8 and MySQL Zero 0000-00-00 Dates

2008-01-29 Thread Jim McAtee
Is there a way of dealing with MySQL default -00-00 dates beyond going 
through all of our databases and changing them to NULL or a valid date?

I came across an aticle suggesting that there may be a JDBC connection 
setting that will keep the MySQL JDBC driver from choking on them, but 
there weren't instructions on how it's done. 


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297686
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Speaking of nudity (NSFW)

2008-01-29 Thread Bruce Sorge
Just ran into this one:

http://fr.news.yahoo.com/afp/20080128/img/pod-allemagne-tourisme-nudi-44ec2938cfb00.html

Bruce

-- 
Throttle Jockey - 
Why golf courses should be motocross tracks


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297677
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: Using __type__ to return objects to Flex

2008-01-29 Thread Kevin Aebig
There's a setting for the AMF gateway that automatically cases the column
names to lowercase if you're interested. You can view the associated
configurations inside:

CF install dir\wwwroot\WEB-INF\flex\services-config.xml

Cheers,

!k

-Original Message-
From: Tom Chiverton [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, January 29, 2008 8:40 AM
To: CF-Talk
Subject: Using __type__ to return objects to Flex

I'm playing with the method that seems to have been hiding from me for a
while 
at : 
http://www.briankotek.com/blog/index.cfm/2008/1/28/Returning-Typed-Structs-v
s-CFCs-to-Flex
to generate arrays of value objects based of a query, without using 
createObject().
Here, I've given my function a 'results' query, and a 'queryObect' string:
cfset res=ArrayNew(1) 
cfset props=arguments.result.columnlist   
cfoutput query=arguments.result
cfset res[arguments.result.currentRow]=structNew()
cfset
res[arguments.result.currentRow]['__type__']=variables.queryObject
cfloop list=#props# index=prop
cfset
res[arguments.result.currentRow][prop] = arguments.result[prop]
[arguments.result.currentRow]  
/cfloop
/cfoutput

Now, if I CFDUMP 'res', my 'prop's are correctly camelCased - just like in
the 
query and the ActionScript object I'm aiming at.

*BUT* the Serializing AMF/HTTP response output in the ColdFusion log file,

indicates that all the keys of the struct have been changed to uppercase:
[Flex] Serializing AMF/HTTP response
Version: 3
  (Message #0 targetURI=/2/onResult, responseURI=)
(Typed Object #0 'flex.messaging.messages.AcknowledgeMessage')
  timestamp = 1.201616773456E12
  headers = (Object #1)
  body = (Object #2)
RESULT = true
DATA = (Array #3)
  [0] = (Typed Object #4 'reactor.project.foo.To.casesTo')
CLAIMHANDLERADRESS = Senior Legal Counsel  Group Head of Claims

20 Manchester Square  London  W10 3AN

And, of course, I get errors in Builders debug console when debugging the
Flex 
application (before the result handler is called) saying :
ReferenceError: Error #1056: Cannot create property CLAIMHANDLERADRESS on 
com.halliwells.flex.ici.vo.Cases.

So, can __type__ not be used when properties are mixed case ? Or is there an

alternative approach I've missed ?
-- 
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;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297687
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Using __type__ to return objects to Flex

2008-01-29 Thread Brian Kotek
Interesting and good to know! But forcing them to lowercase is just about as
bad as forcing them to uppercase. Unfortunately, it still means I can't
properly camel case the property names in the AS class.

On Jan 29, 2008 5:23 PM, Kevin Aebig [EMAIL PROTECTED] wrote:

 There's a setting for the AMF gateway that automatically cases the column
 names to lowercase if you're interested. You can view the associated
 configurations inside:

 CF install dir\wwwroot\WEB-INF\flex\services-config.xml

 Cheers,

 !k




~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297688
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: CMS Solution Recommendations

2008-01-29 Thread s. isaac dealey
 There is one by someone on this list named Matt Robertson but I cannot 
 recall the name. It was a pretty solid app as well but lacked recent 
 documentation.

ContentMonger ... All of Matt's apps are mongers, though last I knew
he was looking for someone else to take over his software projects 
clients because he was taking over a different business that had been
surprisingly willed to him and it was going to take up all his time, so
he was looking for someone to buy him out so to speak with regard to
software so his clients would have a full-time person supporting them. 

-- 
s. isaac dealey  ^  new epoch
 isn't it time for a change? 
 ph: 503.236.3691

http://onTap.riaforge.org/blog



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297690
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Using __type__ to return objects to Flex

2008-01-29 Thread Jo�o_Fernandes
Tom, if you are using Reactor why don't you use the metadata generated 
by reactor itself?

You could call getObjectMetadata() which has a getFieldList() which will 
return the list of fields with the proper case if I'm not mistaken.

-- 

João Fernandes

http://www.onflexwithcf.org
http://www.riapt.org


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297692
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Browser and security

2008-01-29 Thread Don L
Not directly CF-related but web app related.  I think it would be nice that 
future IE and FF releases would include an option (to the effect of for public 
use?), and if yes, that version of web browser would not be able to save 
cookie etc.  Does that make sense?  At one point, I saw a user with yahoo 
account still logged to a public computer... Then, institution like library's 
computers would add security a notch, maybe, am thinking loud here...


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297689
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Browser and security

2008-01-29 Thread Todd Rafferty
It's up to the developer to do it and it's not that difficult.  Ben Nadel
just wrote an example today.

http://www.bennadel.com/blog/1131-Ask-Ben-Ending-ColdFusion-Session-When-User-Closes-Browser.htm

On Jan 29, 2008 6:21 PM, Don L [EMAIL PROTECTED] wrote:

 Not directly CF-related but web app related.  I think it would be nice
 that future IE and FF releases would include an option (to the effect of
 for public use?), and if yes, that version of web browser would not be
 able to save cookie etc.  Does that make sense?  At one point, I saw a user
 with yahoo account still logged to a public computer... Then, institution
 like library's computers would add security a notch, maybe, am thinking loud
 here...



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297691
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Speaking of nudity (NSFW)

2008-01-29 Thread Mark Picker
Maybe it's so COLD the guys nads have sunk back in and are reFUSing (close 
enough) to come out  I was trying to work an ION, but couldn't think of 
anything.

:)

Keep looking Dave...you'll see it eventually. 

 Just ran into this one:
 
 http://fr.news.yahoo.com/afp/20080128/img/pod-allemagne-touris
 me-nudi-44ec2938cfb00.html

No matter how long I stare at that, I fail to see the connection with CF.

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;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297693
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Speaking of nudity (NSFW)

2008-01-29 Thread Mark Picker
Maybe it's so COLD that their nads have sunk back in and are reFUSing to come 
back out?  I did try to work an ION in there but can't think of anything.

:)

Keep looking Dave...you'll see it eventually. 

 Just ran into this one:
 
 http://fr.news.yahoo.com/afp/20080128/img/pod-allemagne-touris
 me-nudi-44ec2938cfb00.html

No matter how long I stare at that, I fail to see the connection with CF.

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;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297694
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Browser and security

2008-01-29 Thread Don L
You missed my point entirely.  Were a version of browser not to support cookie 
in particular (use env = public) then it would SYSTEMATICALLY addd a measure of 
security.  No, it's NOT difficult to implement it at all!!

I fully understood it's not exactly a good forum for this topic.

 It's up to the developer to do it and it's not that difficult.  Ben 
 Nadel
 just wrote an example today.
 
 http://www.bennadel.
co m/blog/1131-Ask-Ben-Ending-ColdFusion-Session-When-User-Closes-Browser.
 htm
 
 On Jan 29, 2008 6:21 PM, Don L [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;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297695
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Browser and security

2008-01-29 Thread Charlie Griefer
Why can't the institution in question just disable cookies on the
workstations that they provide?  Why should there be a whole new
version of a given browser (or browsers) when every browser that I'm
aware of currently allows the people deploying them to configure them
in the manner that you're describing (e.g. to disable cookies)?

On Jan 29, 2008 5:16 PM, Don L [EMAIL PROTECTED] wrote:
 You missed my point entirely.  Were a version of browser not to support 
 cookie in particular (use env = public) then it would SYSTEMATICALLY addd a 
 measure of security.  No, it's NOT difficult to implement it at all!!

 I fully understood it's not exactly a good forum for this topic.

  It's up to the developer to do it and it's not that difficult.  Ben
  Nadel
  just wrote an example today.
 
  http://www.bennadel.
 co m/blog/1131-Ask-Ben-Ending-ColdFusion-Session-When-User-Closes-Browser.
  htm
 
  On Jan 29, 2008 6:21 PM, Don L [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;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297697
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: ColdFusion v8.0 Standard Edition - Academic Edition

2008-01-29 Thread Don L
Have ordered a standard edition.  Though I have a license of a previous version 
(even if it would work, most likely not, it won't be legal).  Thanks for the 
info.

and, if i am not mistaken, any time you enter a valid licence key, your 
trial/dev edition turns into a standard/enterprise one.
and if you remove the licence key it reverts back to dev edition (?)

---
Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com



Todd wrote:
 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297696
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Browser and security

2008-01-29 Thread Dave Watts
 Why can't the institution in question just disable cookies on 
 the workstations that they provide?  Why should there be a 
 whole new version of a given browser (or browsers) when every 
 browser that I'm aware of currently allows the people 
 deploying them to configure them in the manner that you're 
 describing (e.g. to disable cookies)?

This is a solved problem, assuming you're willing to invest in the
appropriate infrastructure. Many school systems use a product called Deep
Freeze (http://www.faronics.com/), or something similar, which prevents any
long-term changes to be saved onto the workstation in question. Other
environments use imaging software, or virtualization, to get to the same
place.

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;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297698
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Browser and security

2008-01-29 Thread Don L
Extra work, which can easily be saved.

The logic goes like this:
The use of browser in such case is already determined, that is, for the general 
public or the  like, hence, it's inappropriate to store cookie etc. mechanism 
in such environment.  

Why can't the institution in question just disable cookies on the
workstations that they provide?  Why should there be a whole new
version of a given browser (or browsers) when every browser that I'm
aware of currently allows the people deploying them to configure them
in the manner that you're describing (e.g. to disable cookies)?

On Jan 29, 2008 5:16 PM, D
 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297699
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Browser and security

2008-01-29 Thread James Holmes
My suggestion then is:

1) Check out the Firefox source code
2) Rewrite the cookie handling code
3) Compile the code
4) ...
5) Profit

On Jan 30, 2008 11:28 AM, Don L [EMAIL PROTECTED] wrote:
 Extra work, which can easily be saved.

 The logic goes like this:
 The use of browser in such case is already determined, that is, for the 
 general public or the  like, hence, it's inappropriate to store cookie etc. 
 mechanism in such environment.

 Why can't the institution in question just disable cookies on the
 workstations that they provide?  Why should there be a whole new
 version of a given browser (or browsers) when every browser that I'm
 aware of currently allows the people deploying them to configure them
 in the manner that you're describing (e.g. to disable cookies)?


-- 
mxAjax / CFAjax docs and other useful articles:
http://www.bifrost.com.au/blog/

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297700
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Using cfinput causes form fields to show through?

2008-01-29 Thread Ryan Stille
I have a form with three text fields lined up vertically on top of each other.  
The first field was a cfinput, so I could use the autosuggest feature.  Worked 
great.  Then I changed the other two fields to be cfinputs, and now they show 
through the autosuggest popup area.

Here's a screen shot of what I'm talking about:
http://aycu24.webshots.com/image/43863/2002850445526073769_rs.jpg
Happens on IE6 for sure, don't know about other browsers yet.

Anyway to fix this?  I'm thinking it might have something to do with how 
cfinput wraps the input tag in a few other tags, including a div.





~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297703
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: CF8 and MySQL Zero 0000-00-00 Dates

2008-01-29 Thread Azadi Saryev
zeroDateTimeBehavior=convertToNull

add it to the jdbc url's query string part.

maybe entering it into the Connection String box (under Advanced 
Settings in the CF Administrator)'s Data Sources page) will work too, 
but i have not tried it.

---
Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com



Jim McAtee wrote:
 Is there a way of dealing with MySQL default -00-00 dates beyond going 
 through all of our databases and changing them to NULL or a valid date?

 I came across an aticle suggesting that there may be a JDBC connection 
 setting that will keep the MySQL JDBC driver from choking on them, but 
 there weren't instructions on how it's done. 


 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297701
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: CMS Solution Recommendations

2008-01-29 Thread Andrew Grosset
So that's why we haven't heard from Matt in a while...I used to really enjoy 
reading his posts, hopefully we'll see him here again soon!

Andrew.

 There is one by someone on this list named Matt Robertson but I cannot 
 recall the name. It was a pretty solid app as well but lacked recent 
 documentation.

ContentMonger ... All of Matt's apps are mongers, though last I knew
he was looking for someone else to take over his software projects 
clients because he was taking over a different business that had been
surprisingly willed to him and it was going to take up all his time, so
he was looking for someone to buy him out so to speak with regard to
software so his clients would have a full-time person supporting them. 

-- 
s. isaac dealey  ^  new epoch
 isn't it time for a change? 
 ph: 503.236.3691

http://onTap.riaforge.org/blog 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297702
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: CMS Solution Recommendations

2008-01-29 Thread s. isaac dealey
 So that's why we haven't heard from Matt in a while...I used to
 really enjoy reading his posts, hopefully we'll see him here again
 soon!

I actually talked to him on the phone right after he'd posted a note on
cf-jobs mentioning that he was looking for someone to take over. Based
on what he said during that conversation, it sounded to me like he's
basically retiring from software. Granted I could be mistaken, etc.
anything's possible... and he is a really nice guy. :) 


-- 
s. isaac dealey  ^  new epoch
 isn't it time for a change? 
 ph: 503.236.3691

http://onTap.riaforge.org/blog



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297704
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Mail list manager recommendations

2008-01-29 Thread Nathan C. Smith
I'm looking for a relatively simple mailing list manager or newsletter-type
system.  This would be for an outbound only newsletter-style list.  I'd like
to find something with a double opt-in option (invitees have to click a link
in order to approve their subscription).  And a link to unsubscribe from the
list.

I saw some good looking Php stuff but I was really hoping to find something
based on ColdFusion.  I prefer FOSS but reasonable licenses are fine too.

Thanks for any pointers.

-Nate

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297705
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Mail list manager recommendations

2008-01-29 Thread Kay Smoljak
It's not free, it's a third party system not installable code and it's
not ColdFusion - and with that, I guess totally inappropriate for this
list - but I have never found a better newsletter system than
MailBuild.com :)

There are so many risks associated with running newsletters out of
your own server - ask anyone who's ever ended up with their IP on the
SORBS list for no good reason, for example - that I wouldn't even
consider doing that these days.

In summary, it's a system designed for web development companies to
onsell to their customers (optionally taking a cut of the per-campaign
and per-delivery costs) with awesome templating customisations and
kick arse marketing-department friendly stats. And they are very
careful about spam, because their business hinges on getting mail
delivered.

I just realised that sounds like a sales pitch, but I'm just a happy customer :)

On Jan 30, 2008 12:54 PM, Nathan C. Smith [EMAIL PROTECTED] wrote:
 I'm looking for a relatively simple mailing list manager or newsletter-type
 system.  This would be for an outbound only newsletter-style list.  I'd like
 to find something with a double opt-in option (invitees have to click a link
 in order to approve their subscription).  And a link to unsubscribe from the
 list.

 I saw some good looking Php stuff but I was really hoping to find something
 based on ColdFusion.  I prefer FOSS but reasonable licenses are fine too.

 Thanks for any pointers.

 -Nate

 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297707
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: Using cfinput causes form fields to show through?

2008-01-29 Thread William
I am not certain of the cf solution for this problem, but i can give you some 
insight on the problem.

I had built an autosuggest system for a public website using css and 
javascript.  The solution to my problem, when the same scenario occured, was to 
change the layer number (z-index) from the default to a declared value so that 
the autosuggest was always on top.

I know that this doesn't solve your issue since you are using cf's dynamic 
solutionm, but hopefully it will help some.

William 

William Seiter (mobile)

Have you ever read a book that changed your life?
go to:  http://www.winninginthemargins.com
and use passcod: GoldenGrove

-Original Message-
From: Ryan Stille [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: 1/29/2008 7:25 PM
Subject: Using cfinput causes form fields to show through?

I have a form with three text fields lined up vertically on top of each other.  
The first field was a cfinput, so I could use the autosuggest feature.  Worked 
great.  Then I changed the other two fields to be cfinputs, and now they show 
through the autosuggest popup area.

Here's a screen shot of what I'm talking about:
http://aycu24.webshots.com/image/43863/2002850445526073769_rs.jpg
Happens on IE6 for sure, don't know about other browsers yet.

Anyway to fix this?  I'm thinking it might have something to do with how 
cfinput wraps the input tag in a few other tags, including a div.







~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297706
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: Using cfinput causes form fields to show through?

2008-01-29 Thread Jake Churchill
William,
I looked into this (see my other post) and the z-index for the input field gets 
set to 0, the autosuggestcontainer gets set to 9050 and the shadow to 9049.  
The problem lies in that IE6 and z-index don't get along (at all).  IE6 
literally resets all z-index to 0 once the page loads.

--

Jake Churchill 
 Team Leader
11204 Davenport, Ste. 100
Omaha, NE  68154 
http://www.cfwebtools.com   
 402-408-3733 x103 


From: [EMAIL PROTECTED]
Sent: Tuesday, January 29, 2008 10:08 PM
To: CF-Talk cf-talk@houseoffusion.com
Subject: RE: Using cfinput causes form fields to show through? 

I am not certain of the cf solution for this problem, but i can give you some 
insight on the problem.

I had built an autosuggest system for a public website using css and 
javascript.  The solution to my problem, when the same scenario occured, was to 
change the layer number (z-index) from the default to a declared value so that 
the autosuggest was always on top.

I know that this doesn't solve your issue since you are using cf's dynamic 
solutionm, but hopefully it will help some.

William 

William Seiter (mobile)

Have you ever read a book that changed your life?
go to:  http://www.winninginthemargins.com
and use passcod: GoldenGrove

-Original Message-
From: Ryan Stille 
To: CF-Talk 
Sent: 1/29/2008 7:25 PM
Subject: Using cfinput causes form fields to show through?

I have a form with three text fields lined up vertically on top of each other.  
The first field was a cfinput, so I could use the autosuggest feature.  Worked 
great.  Then I changed the other two fields to be cfinputs, and now they show 
through the autosuggest popup area.

Here's a screen shot of what I'm talking about:
http://aycu24.webshots.com/image/43863/2002850445526073769_rs.jpg
Happens on IE6 for sure, don't know about other browsers yet.

Anyway to fix this?  I'm thinking it might have something to do with how 
cfinput wraps the input tag in a few other tags, including a div.



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297709
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


re: Using cfinput causes form fields to show through?

2008-01-29 Thread Jake Churchill
Ryan,
I have a solution/hack for you!
If you name your input field test and set the autosuggest, it will wrap that 
in a div with ID testautosuggest and CLASS autosuggest.  Knowing that, you can 
add the following CSS:
style type=text/css #testautosuggest {  float:left!important;   
  } .autosuggest {  float:none!important; }/style
Proof of concept is at http://cse.cfwebtools.com/jake.cfm.  I tested in FF, IE6 
and IE7 and it seemed to work beautifully.
I suppose if you have access to it and can find the tag (if it's not compiled) 
you could edit that.  If you could get that far, you could also go to 
/CFIDE/scripts/ajax/resources/cf/cf.css and edit the css for the autosuggest 
stuff.  Hope that helps.

--

Jake Churchill 
 Team Leader
11204 Davenport, Ste. 100
Omaha, NE  68154 
http://www.cfwebtools.com   
 402-408-3733 x103 


From: Ryan Stille [EMAIL PROTECTED]
Sent: Tuesday, January 29, 2008 9:26 PM
To: CF-Talk cf-talk@houseoffusion.com
Subject: Using cfinput causes form fields to show through? 

I have a form with three text fields lined up vertically on top of each other.  
The first field was a cfinput, so I could use the autosuggest feature.  Worked 
great.  Then I changed the other two fields to be cfinputs, and now they show 
through the autosuggest popup area.

Here's a screen shot of what I'm talking about:
http://aycu24.webshots.com/image/43863/2002850445526073769_rs.jpg
Happens on IE6 for sure, don't know about other browsers yet.

Anyway to fix this?  I'm thinking it might have something to do with how 
cfinput wraps the input tag in a few other tags, including a div.



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297708
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: Mail list manager recommendations

2008-01-29 Thread Nathan C. Smith
Thanks Kay,

  I probably should add that it is for very low volumes and for existing
clients only that I want to use this software.   Probably less than 7000
subscribers.  Probably A LOT less ;)

Thank-you.

-Nate

 

 -Original Message-
 From: Kay Smoljak [mailto:[EMAIL PROTECTED] 
 Sent: Tuesday, January 29, 2008 10:21 PM
 To: CF-Talk
 Subject: Re: Mail list manager recommendations
 
 It's not free, it's a third party system not installable code 
 and it's not ColdFusion - and with that, I guess totally 
 inappropriate for this list - but I have never found a better 
 newsletter system than MailBuild.com :)
 
 There are so many risks associated with running newsletters 
 out of your own server - ask anyone who's ever ended up with 
 their IP on the SORBS list for no good reason, for example - 
 that I wouldn't even consider doing that these days.
 
 In summary, it's a system designed for web development 
 companies to onsell to their customers (optionally taking a 
 cut of the per-campaign and per-delivery costs) with awesome 
 templating customisations and kick arse marketing-department 
 friendly stats. And they are very careful about spam, because 
 their business hinges on getting mail delivered.
 
 I just realised that sounds like a sales pitch, but I'm just 
 a happy customer :)
 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297710
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


CFAjax Problem (parseJSON)

2008-01-29 Thread RobG
I was over at learncf.com and am trying to run their CFAjax tutorial on 
one of my servers.  When I click on either of the buttons, such as 
Server Time, I get this error:

Error: [Exception... 'SyntaxError: parseJSON' when calling method: 
[nsIOnReadyStateChangeHandler::handleEvent]  nsresult: 0x8057001c 
(NS_ERROR_XPC_JS_THREW_JS_OBJECT)  location: unknown  data: no]

Googling hasn't gotten me anything useful, unfortunately.  The box in 
question is Windows Server 2003 fully updated, CF8, MSSQL2005.

At home, I have two development systems, one Windows and one Linux.

On the Linux system (Fedora Core 7), it runs perfectly.

On the Windows system (Vista), it would probably run if I could figure 
out how to overcome the ColdFusion not defined error, which I overcame 
on the Linux box by symlinking the CFIDE directory to the dir where 
proxy.cfm and proxy.cfc were located.  The CF server already has a 
mapping for CFIDE, and I can't figure out how to specify a new one in 
Apache, though my attempts so far have only managed to break the CF 
Administrator. :)

So there's something weird on my live Windows box, but I sure can't 
figure out what.

Any ideas?

Thanks!

Rob



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297711
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Using cfinput causes form fields to show through?

2008-01-29 Thread William Seiter
Looking at the code from back then, (the pages were never launched and I
don't have php loaded locally, so can't test), this is the css I used for
that 'autofill' section.


z-index:99; 
position:absolute; 
visibility: visible; 
display: block;

It may have been the 'position:absolute' that did the trick for me.

William

-- 
William E. Seiter
 
Have you ever read a book that changed your life?
Go to: www.winninginthemargins.com
Enter passkey: goldengrove
 
Web Developer 
http://William.Seiter.com
-Original Message-
From: Jake Churchill [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, January 29, 2008 9:09 PM
To: CF-Talk
Subject: RE: Using cfinput causes form fields to show through?

William,
I looked into this (see my other post) and the z-index for the input field
gets set to 0, the autosuggestcontainer gets set to 9050 and the shadow to
9049.  The problem lies in that IE6 and z-index don't get along (at all).
IE6 literally resets all z-index to 0 once the page loads.

--

Jake Churchill 
 Team Leader
11204 Davenport, Ste. 100
Omaha, NE  68154 
http://www.cfwebtools.com   
 402-408-3733 x103 


From: [EMAIL PROTECTED]
Sent: Tuesday, January 29, 2008 10:08 PM
To: CF-Talk cf-talk@houseoffusion.com
Subject: RE: Using cfinput causes form fields to show through? 

I am not certain of the cf solution for this problem, but i can give you
some insight on the problem.

I had built an autosuggest system for a public website using css and
javascript.  The solution to my problem, when the same scenario occured, was
to change the layer number (z-index) from the default to a declared value so
that the autosuggest was always on top.

I know that this doesn't solve your issue since you are using cf's dynamic
solutionm, but hopefully it will help some.

William 

William Seiter (mobile)

Have you ever read a book that changed your life?
go to:  http://www.winninginthemargins.com
and use passcod: GoldenGrove

-Original Message-
From: Ryan Stille 
To: CF-Talk 
Sent: 1/29/2008 7:25 PM
Subject: Using cfinput causes form fields to show through?

I have a form with three text fields lined up vertically on top of each
other.  The first field was a cfinput, so I could use the autosuggest
feature.  Worked great.  Then I changed the other two fields to be cfinputs,
and now they show through the autosuggest popup area.

Here's a screen shot of what I'm talking about:
http://aycu24.webshots.com/image/43863/2002850445526073769_rs.jpg
Happens on IE6 for sure, don't know about other browsers yet.

Anyway to fix this?  I'm thinking it might have something to do with how
cfinput wraps the input tag in a few other tags, including a div.





~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297712
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: Front end developer to a ColdFusion developer

2008-01-29 Thread William Seiter
I think what I like the best about the opportunity is that this
'entry-level' position offers a very nice vehicle as part of the
Compensation package.  £3 - £35000 per annum + Bens

I wish more companies would offer professional sports style perks to their
offers

;)

As far as posting it on the cf-jobs list, I think that it would be very
related to CF.  I am sure there are many 'lurking learners' here who would
be more than happy to learn on the job.

William

-- 
William E. Seiter
 
Have you ever read a book that changed your life?
Go to: www.winninginthemargins.com
Enter passkey: goldengrove
 
Web Developer 
http://William.Seiter.com

-Original Message-
From: Judith Dinowitz [mailto:[EMAIL PROTECTED] 
Sent: Monday, January 28, 2008 8:57 PM
To: CF-Jobs-Talk
Subject: Front end developer to a ColdFusion developer

Very interesting job posting just came across my desk. This company wants a
front end developer who will work his or her way up to being a ColdFusion
developer. :) I liked that heirarchy! What do you think of the job posting
here - of the way the job is described and the levels, with ColdFusion
development being on top?

http://www.computerweekly.com/jobs/job/front-end-web-developer-digital-media
--10324896.htm
-- 
Judith Dinowitz
Editor
Fusion Authority
The House of Fusion Technical Magazine
http://www.fusionauthority.com




~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Jobs-Talk/message.cfm/messageid:3585
Subscription: http://www.houseoffusion.com/groups/CF-Jobs-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11