RE: Login protection and verification

[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

Login protection and verification

[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: Can application scope gateways/DAOs returning an array of Objects?

[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

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

[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
 wrote:
>
> Yeah, we're on CF8 for better or worse.  So I redid the previous function to 
> look like this:
>
> 
>
>        
>
>        
>
>        
>        
>                 '#REQUEST.cfcPathDot#.Program').init(programID = q_programs.ProgramID)>
>            
>        
>
>        
>
> 
>
>
> 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: CFFILE move is copying

[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: hosting

[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 
> 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

[Dave Watts]

> Basically, if I'm writing to the "badFiles" location, I have almost
> invariably broken out of a  loop before
> reaching the end of the file (using ).  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: CFFILE move is copying

[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  loop before
reaching the end of the file (using ).  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  wrote:
> Well, here's a wrinkle:
>
> This line (same as before) doesn't delete the file in the source:
>  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:
>  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  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,   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 
>>> Date: Tue, January 12, 2010 3:46 pm
>>> To: cf-talk 
>>>
>>>
>>> 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  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: jQuery tableSorter & tab plugins

[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:


 //jQuery table sorter function
$(document).ready(function()
{$("##attributes.tableName#").tablesorter();});



On Thu, Jan 14, 2010 at 4:37 PM, Qing Xia  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

jQuery tableSorter & tab plugins

[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: For the old time ColdFusion developers on the list.

[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

RE: hosting

[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  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

cfchart - stacked bar chart

[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:

 
  

  

   
 

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

cfchart - stacked bar chart

[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:

 
  

  

   
 

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

RE: another beginner orm question

[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  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

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

[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: For the old time ColdFusion developers on the list.

[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.

[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" 
Date: Thu, January 14, 2010 12:26 pm
To: cf-talk 


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: another beginner orm question

[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: CF 9 Install/Migration Hangs

[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: For the old time ColdFusion developers on the list.

[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?






  








-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: Centralized hosting of custom tags

[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 

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

another beginner orm question

[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):

 

 





/*

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();   



  




~|
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

Centralized hosting of custom tags

[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

Re: File Upload with CFKeditor in CF8

[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 wrote:

>
> 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

Re: orm beginner

[Dave Watts]

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



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: orm beginner

[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?






  










-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

CF 9 Install/Migration Hangs

[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: For the old time ColdFusion developers on the list.

[mark]

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






  








-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

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

[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: orm beginner

[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: Can application scope gateways/DAOs returning an array of Objects?

[brad]

> So the  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

For the old time ColdFusion developers on the list.

[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

orm beginner

[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 
documentation to verify that you are using the correct syntax.
*   Search the Knowledge Base 
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 :

 











 











 




~|
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/

Re: Stored Procedure throwing error in CF but ran successfully

[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  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

RE: hosting

[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
wrote:

>
> 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 
> 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: hosting

[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 wrote:

>
> 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 
> 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

[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  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

[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  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: Recent SQL Injection attacks

[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: Can application scope gateways/DAOs returning an array of Objects?

[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  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

[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  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: Recent SQL Injection attacks

[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: Can application scope gateways/DAOs returning an array of Objects?

[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: Can application scope gateways/DAOs returning an array of Objects?

[Jonathan Price]

So the  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?

[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