RE: Can application scope gateways/DAOs returning an array of Objects?

2010-01-14 Thread brad

 should I not worry about running 'createObject' on the same local.o_program 
 structure member everytime? 

The fact that createObject is INSIDE the loop is precisely why it is
working now and that is good.  When you posted your first real code
sample (the second one) with the createObject outside the loop you were
only creating one instance of your CFC and reusing it over and over. 
That is not what you wanted.  If you have 7 programs, than you need to
create 7 objects.

 It's not completely obvious to me how 'local' magic is working. 

It's not magic really.  When you place anything (like a CFC) in the
application scope it is shared by all running requests.  This is the
same as a database table that is being used by several requests at once.
 Changes made by one request will be visible to any other request
looking in the table.  Think of a CFC in the application scope the same
way.  There are 3 main scopes in a CFC-- this, variables, and local. 
This and variables are shared by everyone calling methods on that CFC. 
Local is specific to a particular method call.  If this still does not
make sense, PLEASE ask questions now and get it cleared up or you will
be asking for pain down the road when your app starts crashing under
load due to concurrency issues because you didn't understand how to make
thread-safe singletons.  Print this off, read it, and post it on your
cube wall: http://www.coldfusionjedi.com/downloads/cfcscopes.pdf

 And is there not a memory leak issue with running createObject on every 
 iteration? 

I'm not sure what you're asking here but the short answer is no.  Now,
creating objects DOES consume a nominal amount of memory-- this is true,
but that is not a memory leak.  There was a recent memory leak fixed
in the  last cumulative hot fix for CF8 that had to do with placing CFCs
in shared scopes.  I don't see how it would affect your code, but if you
want to, you can install the hot fix.

 Should my previous version have worked? 

Which one?
 *The very first code you posted was somewhat usable.  It would have
created a separate object for each record except for the fact that you
had some syntax errors [arrayNew()] and didn't locally var your
variables.  
 *The second code sample you sent only used one program object and still
didn't use locally-scoped variables.  
 *Your third code sample is getting closer yet, but still not correct. 
You need to locally scope ALL VARIABLES THAT ARE SPECIFIC TO THAT METHOD
CALL.  This includes q_programs.  Otherwise two people running this
code at the exact same time will be sharing the exact same contents of
the q_programs variable since is in the variables scope by default.

 I don't mind doing this 'local' trick everywhere, but I am curious about why 
 the original wasn't working properly.

It's hard to say since your first code sample seemed to be
altered-to-protect-the-innocent to the point that you significantly
changed the flow of the code. However, I would guess that your first
iteration of the code did not work because you were not creating a new
program object for every record in your result set.

One more thing, I would stay away from duplicating your CFCs.  It might
work in some scenarios, but duplicate is a deep-copy and that can mean
bad things if your CFC has references to a framework or some other
complex variable that you do not actually wish to copy.

~Brad



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329658
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Can application scope gateways/DAOs returning an array of Objects?

2010-01-14 Thread Jonathan Price

So the cfset var local = {} worked fine in our CF8 environment, but CF7 is 
complaining about it.  Is {} just a CF8 shorthand for struct?  I replaced the 
{} with StructNew(), and it seems to work.  I'm just terrified of screwing this 
up and having to chase down some phantom bugs three months from now. 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329659
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Can application scope gateways/DAOs returning an array of Objects?

2010-01-14 Thread Jonathan Price

Thanks for the reply!  I'm definitely trying to get a handle on this as I don't 
want to chase down the repercussions in the future!  Thank so much for your 
help.  It almost makes sense to me now...


  should I not worry about running 'createObject' on the same local.
 o_program structure member everytime? 
 
 The fact that createObject is INSIDE the loop is precisely why it is
 working now and that is good.  When you posted your first real code
 sample (the second one) with the createObject outside the loop you 
 were
 only creating one instance of your CFC and reusing it over and over. 
 That is not what you wanted.  If you have 7 programs, than you need 
 to
 create 7 objects.
 
  It's not completely obvious to me how 'local' magic is working. 
 
 It's not magic really.  When you place anything (like a CFC) in the
 application scope it is shared by all running requests.  This is the
 same as a database table that is being used by several requests at 
 once.
 
 Changes made by one request will be visible to any other request
 looking in the table.  Think of a CFC in the application scope the 
 same
 way.  There are 3 main scopes in a CFC-- this, variables, and local. 
 This and variables are shared by everyone calling methods on that CFC. 
 
 Local is specific to a particular method call.  If this still does 
 not
 make sense, PLEASE ask questions now and get it cleared up or you 
 will
 be asking for pain down the road when your app starts crashing under
 load due to concurrency issues because you didn't understand how to 
 make
 thread-safe singletons.  Print this off, read it, and post it on your
 cube wall: http://www.coldfusionjedi.com/downloads/cfcscopes.pdf
 
  And is there not a memory leak issue with running createObject on 
 every iteration? 
 
 I'm not sure what you're asking here but the short answer is no.  
 Now,
 creating objects DOES consume a nominal amount of memory-- this is 
 true,
 but that is not a memory leak.  There was a recent memory leak 
 fixed
 in the  last cumulative hot fix for CF8 that had to do with placing 
 CFCs
 in shared scopes.  I don't see how it would affect your code, but if 
 you
 want to, you can install the hot fix.
 
  Should my previous version have worked? 
 
 Which one?
 
 *The very first code you posted was somewhat usable.  It would have
 created a separate object for each record except for the fact that 
 you
 had some syntax errors [arrayNew()] and didn't locally var your
 variables.  
 
 *The second code sample you sent only used one program object and 
 still
 didn't use locally-scoped variables.  
 
 *Your third code sample is getting closer yet, but still not correct. 
 
 You need to locally scope ALL VARIABLES THAT ARE SPECIFIC TO THAT 
 METHOD
 CALL.  This includes q_programs.  Otherwise two people running this
 code at the exact same time will be sharing the exact same contents 
 of
 the q_programs variable since is in the variables scope by default.
 
  I don't mind doing this 'local' trick everywhere, but I am curious 
 about why the original wasn't working properly.
 
 It's hard to say since your first code sample seemed to be
 altered-to-protect-the-innocent to the point that you significantly
 changed the flow of the code. However, I would guess that your first
 iteration of the code did not work because you were not creating a 
 new
 program object for every record in your result set.
 
 One more thing, I would stay away from duplicating your CFCs.  It 
 might
 work in some scenarios, but duplicate is a deep-copy and that can 
 mean
 bad things if your CFC has references to a framework or some other
 complex variable that you do not actually wish to copy.
 
 ~Brad
 


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329660
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Recent SQL Injection attacks

2010-01-14 Thread Peter Boughton

The qpscanner is ok in general but I want something that will only get
me numeric variables that are not in a cfqueryparam.

That is not enough to protect you!

It is not hard to create injection attacks that bypass CF's auto-doubling of 
quotes.

qpscanner deliberately errs on the side of paranoia, because it only takes one 
small hole for an attacker to get in and cause havoc. 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329661
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Recent SQL Injection attacks

2010-01-14 Thread Michael Dinowitz

I know it's not enough but the point was that there has to be a
priority in what gets fixed. If there are 300+ query vars to fix,
which do you do first? My solution is to fix the numeric vars first
and then fix everything else after. In the end it all gets done but
until I get to the end, the most dangerous vars have to be hit before
the 'less' dangerous ones.

It would be prefered to take the app down, fix it, and put it back up
but with this client that is not an option. That means I have to work
fast and smart to get the job done on a live site. Ug. :(

--
Michael




On Thu, Jan 14, 2010 at 5:43 AM, Peter Boughton bought...@gmail.com wrote:

The qpscanner is ok in general but I want something that will only get
me numeric variables that are not in a cfqueryparam.

 That is not enough to protect you!

 It is not hard to create injection attacks that bypass CF's auto-doubling of 
 quotes.

 qpscanner deliberately errs on the side of paranoia, because it only takes 
 one small hole for an attacker to get in and cause havoc.

 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329662
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Can application scope gateways/DAOs returning an array of Objects?

2010-01-14 Thread Kym Kovan

Jonathan Price wrote:
 Thanks for the reply!  I'm definitely trying to get a handle on this as I 
 don't want to chase down the repercussions in the future!  Thank so much for 
 your help.  It almost makes sense to me now...


A useful trick if you are creating your CFC in any persistent scope, 
like the application scope in this case, is to do a cfdump of that 
scope at the end of the page. Look at all of the vars showing in there. 
If you have failed to properly local scope a var in a CFC function you 
will see it sitting there at the top level of the dump.


-- 

Yours,

Kym Kovan
mbcomms.net.au


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329663
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Recent SQL Injection attacks

2010-01-14 Thread Peter Boughton

I think there's at least one or two more too.  I should really make a
note of them somewhere...

Charlie Arehart's list.

Pretty sure he's got all this listed in a security/similar category.


Yep, here we go:
http://www.carehart.org/cf411/#testing 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329664
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: hosting

2010-01-14 Thread Raymond Camden

Please consider how cheap you want to go. Your host is like the
foundation of your business. Would you set up your store on top of a
volcano? Quicksand? Cheap isn't always the way you want to go for
hosts.

On Wed, Jan 13, 2010 at 7:58 PM, Mark Mandel mark.man...@gmail.com wrote:

 I've used atoz before, and it was just an aweful experience all around. I'd
 vote no to atoz.



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329665
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: hosting

2010-01-14 Thread Scott Stewart

Ray, 

I appreciate the sentiment, but right now cheap is all I can do

-Original Message-
From: Raymond Camden [mailto:rcam...@gmail.com] 
Sent: Thursday, January 14, 2010 9:20 AM
To: cf-talk
Subject: Re: hosting


Please consider how cheap you want to go. Your host is like the
foundation of your business. Would you set up your store on top of a
volcano? Quicksand? Cheap isn't always the way you want to go for
hosts.

On Wed, Jan 13, 2010 at 7:58 PM, Mark Mandel mark.man...@gmail.com wrote:

 I've used atoz before, and it was just an aweful experience all around.
I'd
 vote no to atoz.





~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329666
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: hosting

2010-01-14 Thread Gerald Guido

http://hostek.com/
Plans start $5

I have hosted with them on a couple of sites. Over all I was pleased. They
have good support for the price. Much better than I expected. They will work
to keep your business (or did with me) They also have CF 9.

HTH

On Thu, Jan 14, 2010 at 9:40 AM, Scott Stewart sstwebwo...@bellsouth.netwrote:


 Ray,

 I appreciate the sentiment, but right now cheap is all I can do

 -Original Message-
 From: Raymond Camden [mailto:rcam...@gmail.com]
 Sent: Thursday, January 14, 2010 9:20 AM
 To: cf-talk
 Subject: Re: hosting


 Please consider how cheap you want to go. Your host is like the
 foundation of your business. Would you set up your store on top of a
 volcano? Quicksand? Cheap isn't always the way you want to go for
 hosts.

 On Wed, Jan 13, 2010 at 7:58 PM, Mark Mandel mark.man...@gmail.com
 wrote:
 
  I've used atoz before, and it was just an aweful experience all around.
 I'd
  vote no to atoz.
 
 



 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329667
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: hosting

2010-01-14 Thread Rick Sanders

We also host CF:
http://host.webenergy.ca/plans.htm

Executive Plan is for CF

-Original Message-
From: Gerald Guido [mailto:gerald.gu...@gmail.com] 
Sent: January-14-10 11:01 AM
To: cf-talk
Subject: Re: hosting


http://hostek.com/
Plans start $5

I have hosted with them on a couple of sites. Over all I was pleased. They
have good support for the price. Much better than I expected. They will work
to keep your business (or did with me) They also have CF 9.

HTH

On Thu, Jan 14, 2010 at 9:40 AM, Scott Stewart
sstwebwo...@bellsouth.netwrote:


 Ray,

 I appreciate the sentiment, but right now cheap is all I can do

 -Original Message-
 From: Raymond Camden [mailto:rcam...@gmail.com]
 Sent: Thursday, January 14, 2010 9:20 AM
 To: cf-talk
 Subject: Re: hosting


 Please consider how cheap you want to go. Your host is like the
 foundation of your business. Would you set up your store on top of a
 volcano? Quicksand? Cheap isn't always the way you want to go for
 hosts.

 On Wed, Jan 13, 2010 at 7:58 PM, Mark Mandel mark.man...@gmail.com
 wrote:
 
  I've used atoz before, and it was just an aweful experience all around.
 I'd
  vote no to atoz.
 
 



 



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329668
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Stored Procedure throwing error in CF but ran successfully

2010-01-14 Thread Mike Chabot

Double-execution of CFML code can happen when people close their
custom tags with a trailing slash, not realizing that the closing
slash causes a second-run of the custom tag. Most commonly
double-execution happens when users double-click submit buttons or
when a user gets frustrated at a slow page and refreshes it a few
times, although I doubt this is happening in your case since you are
able to reproduce the error in a controlled environment.

-Mike Chabot

On Wed, Jan 13, 2010 at 7:58 PM, Ali Awan aawa...@gmail.com wrote:

 Brad,

 Thanks for the helpful suggestions.

 In terms of numbers of inserts, well it's an insert statement within a cursor 
 loop.
 There's 305 records being added so it loops 305 times and does an insert.

 As I mentioned in my last post.

 When I take my execution page out of the pseudo-fusebox app and run it 
 separately, it works perfectly each time.

 So what I did was add an application counter in the original app on the query 
 page, and yes it was calling it multiple times for no reason.

 So fine, I figured, I'd just put an IF statement around the stored proc.

 However, what I found was that the error was happening even if my counter was 
 1 or 0, meaning that the first time through, it was still getting a primary 
 key constraint error.

 So, I have determined that internally, either the CF server or the JDBC 
 driver or some way in which the cfstoredproc is being handled, is executing 
 the stored procedure in SQL multiple times.

 Even if I have a SQL Profiler, it's not going to help in telling me how to 
 stop that.

 And if that is true, then how come ColdFusion handles it differently when I 
 pull that CF page out of that app, and run it by itself?

 Ali

 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329669
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


orm beginner

2010-01-14 Thread Mark Fuqua MdProfinish

Trying to get my head wrapped around the new orm features.not doing well J.

 

I used an example I got from Manju's blog.trying to get one to many
relationships working.  I set up a Contacts.cfc with three one to many cfc's
(emails, addresses, phoneNumbers).  Then I created an index.cfm to set
things up and display results. I got an error.  So I commented out all the
code on index.cfm and tried again.same error.  

 

I'm guessing that would mean the error must be in application.cfc, but it's
pretty simple and I don't see what might be wrong.  Could the error be
coming from one of the other cfc's even though index is commented out?  Does
Coldfusion attempt to build the map as soon as it see ormenabled = true?

 

Here is the error and below that the code for application cfc

 

Thanks,

 

Mark

 

Error casting an object of type java.lang.String cannot be cast to
java.util.Map to an incompatible type. This usually indicates a programming
error in Java, although it could also mean you have tried to use a foreign
object in a different way than it was designed. 



java.lang.String cannot be cast to java.util.Map 

 



 



Resources: 

*   Check the ColdFusion http://www.adobe.com/go/prod_doc
documentation to verify that you are using the correct syntax.
*   Search the Knowledge Base http://www.adobe.com/go/prod_support/
to find a solution to your problem.



Browser  

Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.17)
Gecko/2009122116 Firefox/3.0.17 GTB6 (.NET CLR 3.5.30729)


Remote Address  

127.0.0.1


Referrer  



Date/Time  

14-Jan-10 11:18 AM

 


Stack Trace 


 

java.lang.ClassCastException: java.lang.String cannot be cast to
java.util.Map
   at
coldfusion.orm.hibernate.ConfigurationManager.initConfiguration(Configuratio
nManager.java:63)
   at
coldfusion.orm.hibernate.HibernateProvider.InitializeORMForApplication(Hiber
nateProvider.java:182)
   at
coldfusion.orm.hibernate.HibernateProvider.beforeApplicationStart(HibernateP
rovider.java:85)
   at
coldfusion.filter.ApplicationFilter.fireBeforeAppStartEvent(ApplicationFilte
r.java:475)
   at
coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:221)
   at
coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48)
   at
coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
   at coldfusion.filter.PathFilter.invoke(PathFilter.java:87)
   at
coldfusion.filter.LicenseFilter.invoke(LicenseFilter.java:27)
   at
coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70)
   at
coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:74)
   at
coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistence
Filter.java:28)
   at
coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
   at
coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46)
   at
coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
   at
coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
   at
coldfusion.filter.CachingFilter.invoke(CachingFilter.java:53)
   at coldfusion.CfmServlet.service(CfmServlet.java:200)
   at
coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
   at jrun.servlet.FilterChain.doFilter(FilterChain.java:86)
   at
coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletF
ilter.java:42)
   at
coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
   at jrun.servlet.FilterChain.doFilter(FilterChain.java:94)
   at jrun.servlet.FilterChain.service(FilterChain.java:101)
   at
jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106)
   at
jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
   at
jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286)
   at
jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543)
   at
jrun.servlet.http.WebService.invokeRunnable(WebService.java:172)
   at
jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:
320)
   at
jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428
)
   at
jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:26
6)
   at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)

 

 

Application.cfc :

 

cfcomponent



!---define the application---

cfset this.name = myORMApplication

cfset this.ormenabled = true

 

!---store the datasource for the entire application---

cfset this.datasource = OrmTesting

! ORM Setting this tells ORM to drop and create 

For the old time ColdFusion developers on the list.

2010-01-14 Thread Ian Skinner

I have a venerable ColdFusion 4.5 server, oh how I look forward to 
replacing it with a new server - but that is still some months into the 
future.

Anyways, I have not looked at this server in a year.  Needed to do 
something on it today and find all CFM code on the server, including the 
ColdFusion Administrator portal is returning the following message:


  Error Occurred While Processing Request


Error Diagnostic Information

An error occurred while attempting to establish a connection to the server.

The most likely cause of this problem is that the server is not 
currently running. Verify that the server is running and restart it if 
necessary.

Unix error number 2 occurred: No such file or directory


This is a Solaris 8, Unix installation of ColdFusion 4.5 Professional.  
I am not an administrator on this box so I do not have any permissions 
to snoop around beyond what can be accessed through a browser.  But, 
when my support ticket finally gets to such a sysop, I know they are not 
going to know much about ColdFusion. Can any of the old hats on this 
list give me some insight on what this error may mean for when they come 
asking me.

TIA



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329671
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Can application scope gateways/DAOs returning an array of Objects?

2010-01-14 Thread brad

 So the cfset var local = {} worked fine in our CF8 environment, but CF7 is 
 complaining about it. Is {} just a CF8 shorthand for struct? I replaced the 
 {} with StructNew(),  and it seems to work. I'm just terrified of screwing 
 this up and having to chase down some phantom bugs three months from now. 


Yeah, don't worry about that.  {} is just the cool kids way of saying
structNew() in CF8 and up.  :)  Google ColdFusion Implicit Struct
Creation to see what else it dose.

~Brad


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329672
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: orm beginner

2010-01-14 Thread Dave Watts

 I'm guessing that would mean the error must be in application.cfc, but it's
 pretty simple and I don't see what might be wrong.  Could the error be
 coming from one of the other cfc's even though index is commented out?  Does
 Coldfusion attempt to build the map as soon as it see ormenabled = true?

The ormSettings variable is a structure, not a string.

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

Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
GSA Schedule, and provides the highest caliber vendor-authorized
instruction at our training centers, online, or onsit

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329673
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: For the old time ColdFusion developers on the list.

2010-01-14 Thread Dave Watts

 This is a Solaris 8, Unix installation of ColdFusion 4.5 Professional.
 I am not an administrator on this box so I do not have any permissions
 to snoop around beyond what can be accessed through a browser.  But,
 when my support ticket finally gets to such a sysop, I know they are not
 going to know much about ColdFusion. Can any of the old hats on this
 list give me some insight on what this error may mean for when they come
 asking me.

I don't have any insight on what it is, but trying to start it as an
application rather than having it start up by itself might show the
sysop what's going on.

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

Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
GSA Schedule, and provides the highest caliber vendor-authorized
instruction at our training centers, online, or onsite

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329674
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: For the old time ColdFusion developers on the list.

2010-01-14 Thread mark

Forgive my ignorance, please.  What should be different in my
application.cfc?

cfcomponent

cfset this.name = myORMApplication

cfset this.ormenabled = true
  
cfset this.datasource = OrmTesting

! ORM Setting this tells ORM to drop and create database

cfset this.ormsettings = dropcreate

/cfcomponent

-Original Message-
From: Dave Watts [mailto:dwa...@figleaf.com] 
Sent: Thursday, January 14, 2010 11:41 AM
To: cf-talk
Subject: Re: For the old time ColdFusion developers on the list.


 This is a Solaris 8, Unix installation of ColdFusion 4.5 Professional.
 I am not an administrator on this box so I do not have any permissions
 to snoop around beyond what can be accessed through a browser.  But,
 when my support ticket finally gets to such a sysop, I know they are not
 going to know much about ColdFusion. Can any of the old hats on this
 list give me some insight on what this error may mean for when they come
 asking me.

I don't have any insight on what it is, but trying to start it as an
application rather than having it start up by itself might show the
sysop what's going on.

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

Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
GSA Schedule, and provides the highest caliber vendor-authorized
instruction at our training centers, online, or onsite



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329675
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


CF 9 Install/Migration Hangs

2010-01-14 Thread Phillip Duba

I installed CF 9 as the Developer edition on my laptop yesterday and every
time I go to the administrator URL, it attempts to complete the
installation/migration/configuration and I get a The request has exceeded
the allowable time limit Tag: cfoutput. I thought there was a way to
disable the migration in on of the .xml files, but I don't recall where
that's at or if that was even an option. Anyone else experience this and/or
know where that flag is? Thanks,

Phil


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329676
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: orm beginner

2010-01-14 Thread mark

Opps, I responded to the wrong email last time.  I got the right one this
time :)



Forgive my ignorance, please.  What should be different in my
application.cfc?

cfcomponent

cfset this.name = myORMApplication

cfset this.ormenabled = true
  
cfset this.datasource = OrmTesting

! ORM Setting this tells ORM to drop and create database

cfset this.ormsettings = dropcreate

/cfcomponent



-Original Message-
From: Dave Watts [mailto:dwa...@figleaf.com] 
Sent: Thursday, January 14, 2010 11:38 AM
To: cf-talk
Subject: Re: orm beginner


 I'm guessing that would mean the error must be in application.cfc, but
it's
 pretty simple and I don't see what might be wrong.  Could the error be
 coming from one of the other cfc's even though index is commented out?
 Does
 Coldfusion attempt to build the map as soon as it see ormenabled = true?

The ormSettings variable is a structure, not a string.

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

Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
GSA Schedule, and provides the highest caliber vendor-authorized
instruction at our training centers, online, or onsit



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329677
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: orm beginner

2010-01-14 Thread Dave Watts

 Forgive my ignorance, please.  What should be different in my
 application.cfc?

 cfset this.ormsettings = dropcreate

cfset this.ormsettings.dbcreate = dropcreate

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

Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
GSA Schedule, and provides the highest caliber vendor-authorized
instruction at our training centers, online, or onsite

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329678
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: File Upload with CFKeditor in CF8

2010-01-14 Thread Pete Freitag

Hi Mallory,

If you have applied the security hotfix (hf801-77218) it will actually block
any CFM request matching /fckeditor/editor/filemanager/ anywhere in the URI,
unless you add -Dcoldfusion.fckupload=true to your JVM startup arguments.

I have posted details on my blog here:
http://www.petefreitag.com/item/718.cfm

You might have a different issue as well, but I thought that was worth
pointing out.

--
Pete Freitag
http://foundeo.com/ - ColdFusion Consulting  Products
http://petefreitag.com/ - My Blog
http://hackmycf.com - Is your ColdFusion Server Secure?


On Tue, Jan 12, 2010 at 2:07 PM, Mallory Woods mallory.wo...@gmail.comwrote:


 Hello all,

 I have been trying to get file uploading working with cftextarea , CF 8.01
 on a UNIX host.
 I am able to see the entire FCKEditor toolbar and I have made the tweaks to
 get the file upload option as described here:

 http://www.rakshith.net/blog/?p=58

 However, when I try to upload an image, I get this error:  Variable
 SENDERROR is undefined

 Thanks in Advance.


 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329679
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Centralized hosting of custom tags

2010-01-14 Thread Michael Christensen

My question is simple - are there any options other than having the custom tag 
file on every server? 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329680
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


another beginner orm question

2010-01-14 Thread Mark Fuqua MdProfinish

Ok, got past last problem (thanks dave) and have uncommented the code on
index.cfm.  I followed the example on Manju's blog entitled Coldfusion-ORM:
Define One-to-Many and Many to One Relationships.  The article was for one
related table, mine is for three.  I used the built-in Apache database.  The
orm is creating the tables, though it doesn't seem to be reflecting my
latest changes.  Anyway, the code is below the error. 

 

Thanks,

 

Mark

 

ids for this class must be manually assigned before calling save(): Emails 

Root cause :org.hibernate.id.IdentifierGenerationException: ids for this
class must be manually assigned before calling save(): Emails   The error
occurred in C:\ColdFusion9\wwwroot\Orm\index.cfm: line 48

46 :   */

47 :   

48 :   EntitySave(newContact);

49 :

50 :   

 

 

Code for index.cfm (just a test for learning):

 

 

cfscript



/*

Create a Contact with one address, one phone number
and one email address

*/



newContact = new Contacts();

newContact.setFirstName(Mark);

newContact.setLastName(Fuqua);



newAddress = new Addresses();

newAddress.setAddressDescription(2301 Mount Carmel
Road);

newAddress.setCity(Parkton);

newAddress.setState(MD);

newAddress.setZip(21120);



newEmail = new Emails();

newEmail.setEmailDescription(Work Email);

newEmail.setEmail(m...@mdprofinish.com);



newPhoneNumber = new PhoneNumbers();

newPhoneNumber.setPhoneDescription(Cell);

newPhoneNumber.setPhoneNumber(410-215-7356);



/*

Associate the Addresses, Emails and
PhoneNumbers with Contacts

*/



newContact.addaddresses(newAddress);

newContact.addEmails(newEmail);

newContact.addphoneNumbers(newPhoneNumber);



/*

Establish the relationship from the
other side

*/



newPhoneNumber.setContacts(newContact);

newAddress.setContacts(newContact);

newEmail.setContacts(newContact);



/*

Save new Contacts, email, address, phone
info should be saved as well

*/



EntitySave(newContact);





DisplayContacts();   



/cfscript  




~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329681
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Centralized hosting of custom tags

2010-01-14 Thread brad

You could map a network drive on each server to a central custom tag
location and point a coldfusion mapping to it.

On the other end of the spectrum you could use some file-replication
software to keep the files in synch across multiple servers.

~Brad


 Original Message 
Subject: Centralized hosting of custom tags
From: Michael Christensen mich...@strib.dk

My question is simple - are there any options other than having the
custom tag file on every server? 



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329682
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: For the old time ColdFusion developers on the list.

2010-01-14 Thread Andy Matthews

That'll be your problem. If you're trying to use a CFC on ColdFusion 4.5
it's going to fail.

Versions of CF before CF MX didn't support CFCs.


andy

-Original Message-
From: mark [mailto:m...@mdprofinish.com] 
Sent: Thursday, January 14, 2010 10:49 AM
To: cf-talk
Subject: RE: For the old time ColdFusion developers on the list.


Forgive my ignorance, please.  What should be different in my
application.cfc?

cfcomponent

cfset this.name = myORMApplication

cfset this.ormenabled = true
  
cfset this.datasource = OrmTesting

! ORM Setting this tells ORM to drop and create database

cfset this.ormsettings = dropcreate

/cfcomponent

-Original Message-
From: Dave Watts [mailto:dwa...@figleaf.com]
Sent: Thursday, January 14, 2010 11:41 AM
To: cf-talk
Subject: Re: For the old time ColdFusion developers on the list.


 This is a Solaris 8, Unix installation of ColdFusion 4.5 Professional.
 I am not an administrator on this box so I do not have any permissions
 to snoop around beyond what can be accessed through a browser.  But,
 when my support ticket finally gets to such a sysop, I know they are not
 going to know much about ColdFusion. Can any of the old hats on this
 list give me some insight on what this error may mean for when they come
 asking me.

I don't have any insight on what it is, but trying to start it as an
application rather than having it start up by itself might show the
sysop what's going on.

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

Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
GSA Schedule, and provides the highest caliber vendor-authorized
instruction at our training centers, online, or onsite





~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329683
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: CF 9 Install/Migration Hangs

2010-01-14 Thread Debbie Morris

Check your adminconfig.xml file. There are several setup/migration settings in 
there.

Debbie Morris

-Original Message-
From: Phillip Duba [mailto:phild...@gmail.com]
Sent: Thursday, January 14, 2010 11:51 AM
To: cf-talk
Subject: CF 9 Install/Migration Hangs


I installed CF 9 as the Developer edition on my laptop yesterday and every
time I go to the administrator URL, it attempts to complete the
installation/migration/configuration and I get a The request has exceeded
the allowable time limit Tag: cfoutput. I thought there was a way to
disable the migration in on of the .xml files, but I don't recall where
that's at or if that was even an option. Anyone else experience this and/or
know where that flag is? Thanks,

Phil




~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329684
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: another beginner orm question

2010-01-14 Thread brad

 ids for this class must be manually assigned before calling save(): Emails 

Have you defined which property in your components are the primary key?

~Brad





~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329685
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: For the old time ColdFusion developers on the list.

2010-01-14 Thread brad

Andy, that post was supposed to go under the orm beginner thread.  

~Brad

 Original Message 
Subject: RE: For the old time ColdFusion developers on the list.
From: Andy Matthews li...@commadelimited.com
Date: Thu, January 14, 2010 12:26 pm
To: cf-talk cf-talk@houseoffusion.com


That'll be your problem. If you're trying to use a CFC on ColdFusion 4.5
it's going to fail.

Versions of CF before CF MX didn't support CFCs.


andy



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329686
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: For the old time ColdFusion developers on the list.

2010-01-14 Thread Ian Skinner

On 1/14/2010 10:26 AM, Andy Matthews wrote:
 That'll be your problem. If you're trying to use a CFC on ColdFusion 4.5
 it's going to fail.

 Versions of CF before CF MX didn't support CFCs.


 andy



And thus Andy points out why it is such a bad Idea to reply to an 
unrelated thread with a brand new question.

The CFC question is a new question from somebody else, and has nothing 
to do with my 4.5 server not responding.

Ian


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329687
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: For the old time ColdFusion developers on the list.

2010-01-14 Thread Ian Skinner

On 1/14/2010 8:40 AM, Dave Watts wrote:
 I don't have any insight on what it is, but trying to start it as an
 application rather than having it start up by itself might show the
 sysop what's going on.

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


Thanks Dave, I'll try and remember that trick if the server miss-behaves 
again in the near future.  When the sysop finally got in after a morning 
doctor's appointment, he found that ColdFusion was apparently not 
running.  Issuing a normal start seemed to fire it right up and all CFML 
pages responded normally.

When we started to look at the logs to see if we could quickly get a 
sense of when and possible why ColdFusion and stopped, we just started 
turning up a bunch of strangeness.  At that point we bailed as this 
server is just not important enough to spend any real brain power or man 
hours.

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329688
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: another beginner orm question

2010-01-14 Thread mark

I have, but I have made several changes to the cfc's, which have not been
reflected in the database.  I put ormFlush() at the top of application.cfc,
is there some other way to make sure a new mapping/new database  is created?
I have cfset this.ormsettings.dbcreate=dropcreate in application.cfc as
well.  But I look at the database and the changes are not reflected.

I want to use the ORM to create the database so I am forced to start
thinking about objects all the time.  I want to create Flex front ends for
my web apps and that is all OOP.  It is a very hard leap for a small and
smooth, well aged brain.

Mark

-Original Message-
From: b...@bradwood.com [mailto:b...@bradwood.com] 
Sent: Thursday, January 14, 2010 1:43 PM
To: cf-talk
Subject: RE: another beginner orm question


 ids for this class must be manually assigned before calling save(): Emails


Have you defined which property in your components are the primary key?

~Brad







~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329689
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


cfchart - stacked bar chart

2010-01-14 Thread Chris D

I just upgraded from CF7 MX to CF9 and now my stacked bar charts are incorrect. 
 

Here is my query:
SELECT a.account_type, a.dept_num, count(a.ids) AS counter
FROM accounts a 
WHERE a.dept_num between 1401 AND 1499
GROUP BY a.account_type,a.dept_num
ORDER BY a.dept_num, a.account_type ASC

The table of data looks like this:
Dept_numcounter account_type
14011   Faculty
140140  Staff
147225  Faculty
14722   Professor
147259  Staff
147417  Faculty
14742   Professor
147469  Staff   

Previously with CF7, the chart had all account totals stacked in their 
appropriate departments. Like 1401 had 41 accounts (40+1 stacked), 1472 had 86 
accounts (25+2+59 stacked), etc.

Now running the same code with CF9, it's taking all of the totals and stacking 
them into each dept so the total accounts is the same in every department.
1401 has 215 accounts; 1+40+25...+69 stacked. 1472 also has 215 accounts... etc.

Here's the code:

cfchart format=jpg xaxistitle=Department: showlegend=yes 
seriesplacement=stacked yaxistitle=Accounts: fontSize=9 chartHeight=400 
chartWidth=800 
  cfloop query=accttype2
cfchartseries type=Bar seriesLabel=#accttype2.account_type#
  cfchartdata item=#accttype2.dept_num# value=#accttype2.counter# 
/cfchartseries
  /cfloop 
/cfchart 

I'm out of ideas on how to fix this.  Anyone have some suggestions?

Thanks,
Chris


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329690
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


cfchart - stacked bar chart

2010-01-14 Thread Chris Dicamillo

I just upgraded from CF7 MX to CF9 and now my stacked bar charts are
incorrect.  

Here is my query:
SELECT a.account_type, a.dept_num, count(a.ids) AS counter
FROM accounts a 
WHERE a.dept_num between 1401 AND 1499
GROUP BY a.account_type,a.dept_num
ORDER BY a.dept_num, a.account_type ASC

The table of data looks like this:
Dept_numcounter account_type
14011   Faculty
140140  Staff
147225  Faculty
14722   Professor
147259  Staff
147417  Faculty
14742   Professor
147469  Staff   

Previously with CF7, the chart had all account totals stacked in their
appropriate departments. Like 1401 had 41 accounts (40+1 stacked), 1472 had
86 accounts (25+2+59 stacked), etc.

Now running the same code with CF9, it's taking all of the totals and
stacking them into each dept so the total accounts is the same in every
department.
1401 has 215 accounts; 1+40+25...+69 stacked. 1472 also has 215 accounts...
etc.

Here's the code:

cfchart format=jpg xaxistitle=Department: showlegend=yes
seriesplacement=stacked yaxistitle=Accounts: fontSize=9
chartHeight=400 chartWidth=800 
  cfloop query=accttype2
cfchartseries type=Bar seriesLabel=#accttype2.account_type#
  cfchartdata item=#accttype2.dept_num# value=#accttype2.counter# 
/cfchartseries
  /cfloop 
/cfchart 

I'm out of ideas on how to fix this.  Anyone have some suggestions?

Thanks,
Chris


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329691
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: hosting

2010-01-14 Thread Eric Roberts

I hear that Scott...I just had to go with GoDaddy because I realty can't
afford anything else.

Eric

-Original Message-
From: Scott Stewart [mailto:sstwebwo...@bellsouth.net] 
Sent: Thursday, January 14, 2010 8:41 AM
To: cf-talk
Subject: RE: hosting


Ray, 

I appreciate the sentiment, but right now cheap is all I can do

-Original Message-
From: Raymond Camden [mailto:rcam...@gmail.com] 
Sent: Thursday, January 14, 2010 9:20 AM
To: cf-talk
Subject: Re: hosting


Please consider how cheap you want to go. Your host is like the
foundation of your business. Would you set up your store on top of a
volcano? Quicksand? Cheap isn't always the way you want to go for
hosts.

On Wed, Jan 13, 2010 at 7:58 PM, Mark Mandel mark.man...@gmail.com wrote:

 I've used atoz before, and it was just an aweful experience all around.
I'd
 vote no to atoz.







~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329692
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: For the old time ColdFusion developers on the list.

2010-01-14 Thread Andy Matthews

:)

Sorry about that. I was a little surprised about that being there...I
thought surely he knows that already.

:) 

-Original Message-
From: Ian Skinner [mailto:h...@ilsweb.com] 
Sent: Thursday, January 14, 2010 12:47 PM
To: cf-talk
Subject: Re: For the old time ColdFusion developers on the list.


On 1/14/2010 10:26 AM, Andy Matthews wrote:
 That'll be your problem. If you're trying to use a CFC on ColdFusion 
 4.5 it's going to fail.

 Versions of CF before CF MX didn't support CFCs.


 andy



And thus Andy points out why it is such a bad Idea to reply to an unrelated
thread with a brand new question.

The CFC question is a new question from somebody else, and has nothing to do
with my 4.5 server not responding.

Ian




~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329693
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


jQuery tableSorter tab plugins

2010-01-14 Thread Qing Xia

Hello all,

I am having a dilemma regarding two jQuery plugins: the tableSorter and
tab.

Here is a brief summary of the problem:


   1. I have a task list, which is further broken into sub-categories such
   as Problems, Maintenance and Requests.
   2. I am using the jQuery tab plugin to make each sub-category a tab.
This works well.
   3. Then for each tab, I am also implementing the tableSorter plugin so
   that users can click on table headers and sort either ascending or
   descending on that column.
   4. The tableSorter plugin only works for the first tab. I've tried
   switching the tabs around and discovered that regardless which one is made
   the first tab, it only works for it.
   5. I've got the tableSorter plugin in multiple places throughout my
   application without tabs so I know it definitely works.

I **think** the cause of the problem is: the task lists are done through a
custom tag which gets called for each tab to conjure up the list. So even
though the tableSorter plugin gets called 3 times, they all have the same
table ID which makes jQuery think they are one big happy table family!

I do not want to not use custom tag for my task lists because that would
lead to gross duplication of code... but I am also a jQuery newbie... I
understand in theory that I'd have to pass in a new table ID to the jQuery
tableSorter plugin each time it is called... but I am a little hazy on the
syntax of how that can be done.

I am sure someone on this list has done that before. If so, I would be most
grateful for any suggestions! [?]

Cheers,

Qing Xia


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329694
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: jQuery tableSorter tab plugins

2010-01-14 Thread Qing Xia

D'oh!

Please ignore question! Apparently just writing the question down on paper
helps clear the thought.  Don't know what I was thinking...

I could easily make the table name an attribute to the custom tag and then
do this in my call to the jQuery tableSorter plugin:

script type=text/javascript
 //jQuery table sorter function
$(document).ready(function()
{$(#cfoutput#attributes.tableName#/cfoutput).tablesorter();});

/script

On Thu, Jan 14, 2010 at 4:37 PM, Qing Xia txiasum...@gmail.com wrote:

 Hello all,

 I am having a dilemma regarding two jQuery plugins: the tableSorter and
 tab.

 Here is a brief summary of the problem:


1. I have a task list, which is further broken into sub-categories such
as Problems, Maintenance and Requests.
2. I am using the jQuery tab plugin to make each sub-category a tab.
 This works well.
3. Then for each tab, I am also implementing the tableSorter plugin so
that users can click on table headers and sort either ascending or
descending on that column.
4. The tableSorter plugin only works for the first tab. I've tried
switching the tabs around and discovered that regardless which one is made
the first tab, it only works for it.
5. I've got the tableSorter plugin in multiple places throughout my
application without tabs so I know it definitely works.

 I **think** the cause of the problem is: the task lists are done through a
 custom tag which gets called for each tab to conjure up the list. So even
 though the tableSorter plugin gets called 3 times, they all have the same
 table ID which makes jQuery think they are one big happy table family!

 I do not want to not use custom tag for my task lists because that would
 lead to gross duplication of code... but I am also a jQuery newbie... I
 understand in theory that I'd have to pass in a new table ID to the jQuery
 tableSorter plugin each time it is called... but I am a little hazy on the
 syntax of how that can be done.

 I am sure someone on this list has done that before. If so, I would be most
 grateful for any suggestions! [?]

 Cheers,

 Qing Xia




~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329695
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: CFFILE move is copying

2010-01-14 Thread Scott Brady

Here's a thought on what might be going on (and if so, I'm open to suggestions).

Basically, if I'm writing to the badFiles location, I have almost
invariably broken out of a cfloop file=whatever loop before
reaching the end of the file (using cfbreak).  Is it possible that
ColdFusion still has a lock on the file and, therefore, can't delete
it?  (I'm thinking this may be the case, because right now I can't
manually delete that file from the source folder, either).

Assuming that's the case, any ideas on how to get around it?  Because
this is a process we don't want to bog down unnecessarily, I'd rather
not read the whole file in (the old way of looping over a file) or
loop over the entire file if I don't have to.

Scott

On Wed, Jan 13, 2010 at 1:54 PM, Scott Brady dsbr...@gmail.com wrote:
 Well, here's a wrinkle:

 This line (same as before) doesn't delete the file in the source:
 cffile action=move
 source=#arguments.stConfig.ftpFileLocations.pending##local.qFiles.name#
 destination=#arguments.stConfig.ftpFileLocations.badFiles##local.qFiles.name#
 /

 This line (different destination, same source) DOES delete the course file:
 cffile action=move
 source=#arguments.stConfig.ftpFileLocations.pending##local.qFiles.name#
 destination=#arguments.stConfig.ftpFileLocations.archived##local.qFiles.name#
 /

 The only difference between
 arguments.stConfig.ftpFileLocations.badFiles and
 arguments.stConfig.ftpFileLocations.archived is the name of the
 specific folder (same parent folders, etc.).

 It almost seems like it would be a permissions issue on the badFiles
 folder, but wouldn't that only affect whether the file could be
 written to THAT folder, not deleting it from the source?

 On Tue, Jan 12, 2010 at 4:06 PM, Scott Brady dsbr...@gmail.com wrote:
 I don't think permissions or other processes would be an issue. This
 is on my local machine, and I haven't had problems before.  Now, I'm
 doing a cffile delete and it's not even throwing an error if the file
 doesn't exist (which it should, right?).

 Maybe I'll restart CF and see what happens. :)


 On Tue, Jan 12, 2010 at 2:55 PM,  b...@bradwood.com wrote:

 I would check permissions too.  CF might have permissions to write and
 read, but not delete.

 If this was the case though, I would expect there to be an error.

 As a debugging measure, you could dump out the contents of a cfdirectory
 right after moving the file and see if the file exists.  It is possible
 some other process is writing the file back in a minute later before you
 are looking.  Also, trying a straight-up delete with cffile will show
 you if it is a delete permissions error.

 ~Brad

  Original Message 
 Subject: Re: CFFILE move is copying
 From: Scott Brady dsbr...@gmail.com
 Date: Tue, January 12, 2010 3:46 pm
 To: cf-talk cf-talk@houseoffusion.com


 That's probably it -- though, I guess I'd expect an error to result. I
 guess I can try deleting after the move -- not a solution, but it
 might tell me if the file is locked. (It's just a text file, so not
 much should be locking it)

 Scott

 On Tue, Jan 12, 2010 at 2:24 PM, Dave Watts dwa...@figleaf.com wrote:

 Well, a move is basically just a copy followed by a delete. So maybe
 CF can't delete the file? Maybe it's locked by CF itself, preventing
 it from being deleted.




 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329696
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: CFFILE move is copying

2010-01-14 Thread Dave Watts

 Basically, if I'm writing to the badFiles location, I have almost
 invariably broken out of a cfloop file=whatever loop before
 reaching the end of the file (using cfbreak).  Is it possible that
 ColdFusion still has a lock on the file and, therefore, can't delete
 it?  (I'm thinking this may be the case, because right now I can't
 manually delete that file from the source folder, either).

Yes, I think that's very likely.

 Assuming that's the case, any ideas on how to get around it?  Because
 this is a process we don't want to bog down unnecessarily, I'd rather
 not read the whole file in (the old way of looping over a file) or
 loop over the entire file if I don't have to.

You could copy the file, then schedule a task to delete it in the
future. Or, you could see how long file locks exist in your OS and see
if you can make that shorter.

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

Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
GSA Schedule, and provides the highest caliber vendor-authorized
instruction at our training centers, online, or onsi

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329697
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: hosting

2010-01-14 Thread Ravi Gehlot

I vouch for GoDaddy's PHP hosting. I have a couple of PHP projects and happy
endings. I am not sure about CF though.

Regards,
Ravi.

On Thu, Jan 14, 2010 at 3:04 PM, Eric Roberts 
ow...@threeravensconsulting.com wrote:


 I hear that Scott...I just had to go with GoDaddy because I realty can't
 afford anything else.

 Eric

 -Original Message-
 From: Scott Stewart [mailto:sstwebwo...@bellsouth.net]
 Sent: Thursday, January 14, 2010 8:41 AM
 To: cf-talk
 Subject: RE: hosting


 Ray,

 I appreciate the sentiment, but right now cheap is all I can do

 -Original Message-
 From: Raymond Camden [mailto:rcam...@gmail.com]
 Sent: Thursday, January 14, 2010 9:20 AM
 To: cf-talk
 Subject: Re: hosting


 Please consider how cheap you want to go. Your host is like the
 foundation of your business. Would you set up your store on top of a
 volcano? Quicksand? Cheap isn't always the way you want to go for
 hosts.

 On Wed, Jan 13, 2010 at 7:58 PM, Mark Mandel mark.man...@gmail.com
 wrote:
 
  I've used atoz before, and it was just an aweful experience all around.
 I'd
  vote no to atoz.
 
 





 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329698
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: CFFILE move is copying

2010-01-14 Thread denstar

What about firing off another thread to delete it after X amount of time?

Or maybe not deleting it right away, and instead adding the file to a
list, and then moving/deleting the list at the end (maybe with a
sleep() first?)

-- 
Dogs and philosophers do the greatest good and get the fewest rewards.
Diogenes

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329699
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Can application scope gateways/DAOs returning an array of Objects?

2010-01-14 Thread Sean Corfield

You have not var'd q_programs - use local.q_programs otherwise every
concurrent request will be overwriting the same variable and you'll
get unpredictable results.

Sean

On Wed, Jan 13, 2010 at 11:35 PM, Jonathan Price
jonat...@imakehthissound.com wrote:

 Yeah, we're on CF8 for better or worse.  So I redid the previous function to 
 look like this:

 CFFUNCTION name=getPrograms_a access=public returntype=Array

        CFSET VAR local = {}

        CFINVOKE method=getPrograms_q returnvariable=q_programs

        CFSET local.a_programs = ArrayNew(1)
        CFLOOP query=q_programs
                CFSET local.o_program = createObject('component', 
 '#REQUEST.cfcPathDot#.Program').init(programID = q_programs.ProgramID)
            CFSET ArrayAppend(local.a_programs, local.o_program)
        /CFLOOP

        CFRETURN local.a_programs

 /CFFUNCTION


 And I'm getting the correct info back now.  Last two questions.  1) should I 
 not worry about running 'createObject' on the same local.o_program structure 
 member everytime?  It's not completely obvious to me how 'local' magic is 
 working.  And is there not a memory leak issue with running createObject on 
 every iteration?  2)  Should my previous version have worked?  I don't mind 
 doing this 'local' trick everywhere, but I am curious about why the o

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329700
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Can application scope gateways/DAOs returning an array of Objects?

2010-01-14 Thread Leigh

 You have not var'd q_programs

Good catch.  

As someone mentioned earlier, all function local variables must var scoped. 
That includes things you often forget, like: query names, loop indexes, 
etcetera.




  

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329701
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Login protection and verification

2010-01-14 Thread David Mineer

I want to protect my site login.  I first want to lock users out after so
many failed login attempts.  Lock them out for a specified amount of time. I
also want to require them to click a link from an email that they receive
the first time they login from a computer.

The email verification seems to get real complicated real fast when I try to
program that completely myself.

I was wondering if anyone knows of any articles or even better, any plugins
or cfc that have been written that are good examples or take care of this
type of issue.

TIA,

-- 
David Mineer Jr
-
The critical ingredient is getting off your
butt and doing something. It's as simple
as that. A lot of people have ideas, but
there are few who decide to do
something about them now. Not
tomorrow. Not next week. But today.
The true entrepreneur is a doer.


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329702
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: Login protection and verification

2010-01-14 Thread brad

 The email verification seems to get real complicated real fast when I try to
 program that completely myself.

Basically, your user table needs at least these two columns:
status: use this signify if an account is pending verification
verificationKey: when the account is created, place a random string in
here (a guid works well)

When the account is started send out an E-mail to the E-mail address
that they supplied when they signed up.  In the e-mail, provide a link
back to your site that accepts the verificationKey and userID in the
URL.  Only the person owning that E-mail address will have that key. 
When they click the link, if the verificationKey matches the one stored
for their userID, activate the account.  

~Brad


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329703
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4