Re: never ending redirect I can't spot

2010-03-04 Thread Kevin Pepperman

Are you on a load balanced server with more than 1 CFML server?

If so you will need to do some type of session replication,
session.billinginfo may not be set yet.

Also, cfmodule calls can be tricky sometimes when depending on
session/cookie variables-- you may want to put your session checks
wrapped around the cfmodule calls instaead of inside them.

-- 
/Kevin Pepperman

"They who can give up essential liberty to obtain a little temporary
safety, deserve neither liberty nor safety." - Benjamin Franklin

~|
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:331374
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: never ending redirect I can't spot

2010-03-04 Thread Maureen

What's the value of your switch?  Does it ever get changed to not be
one of the values you are testing for?

On Thu, Mar 4, 2010 at 4:33 PM, Matthew Smith  wrote:
>
> I'm reworking an old fusebox 3 app.  I'm getting a never ending redirect
> loop but I cannot figure out why

~|
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:331373
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: never ending redirect I can't spot

2010-03-04 Thread Matthew Smith

Sorry, sent early, last code snippit is:

  startPayment


I don't understand why it is looping.

On Thu, Mar 4, 2010 at 6:33 PM, Matthew Smith  wrote:

> I'm reworking an old fusebox 3 app.  I'm getting a never ending redirect
> loop but I cannot figure out why.
>
> In the main order app fbx_switch:
>
> 
>   fuseaction="#fusebox.thiscircuit#.verifyshippingaddress"
>  template="#fusebox.rootpath##modself#"
> cfid="#cfid#" cftoken="#cftoken#">
>   fuseaction="#fusebox.thiscircuit#.verifyshippingoptions"
>  template="#fusebox.rootpath##modself#"
> cfid="#cfid#" cftoken="#cftoken#">
>   fuseaction="#fusebox.thiscircuit#.verifybillingmethod"
>  template="#fusebox.rootpath##modself#"
> cfid="#cfid#" cftoken="#cftoken#">
>  
> 
> 
>
> It is hitting the verifybillingmethod fuseaction, which is:
>
> 
>  
>   
>   url="#self#/fuseaction/SECUREPayment.startPayment/index.cfm">
>   
>   
> 
>
>
> And then in the SECUREPayment.startPayment:
>
> 
> startPayment
>


~|
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:331372
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


never ending redirect I can't spot

2010-03-04 Thread Matthew Smith

I'm reworking an old fusebox 3 app.  I'm getting a never ending redirect
loop but I cannot figure out why.

In the main order app fbx_switch:


 
 
 
 



It is hitting the verifybillingmethod fuseaction, which is:


 
  
 
  
  



And then in the SECUREPayment.startPayment:


startPayment


~|
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:331371
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: How to handle large ResultSet, so that it can also be reused?

2010-03-04 Thread brad

> I'm not so sure how I feel about the phrase "well-endowed SQL server",
> though. *bow chicka wow wow*

All I'm gonna say is at my last job, we referred to our main SQL Server
as "Big Momma".  She had enough gigs of Ram to make any decent PC blush.

~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:331370
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: How to handle large ResultSet, so that it can also be reused?

2010-03-04 Thread Dave Watts

> Having read some more of your replies, I think I would recommend just
> re-running the select every time.  10's of thousands of records really
> isn't that large of a result for a well-endowed SQL server to transfer
> around.  The big question is how long it takes to generate them.
> Analyze your execution plans for starters and see if improvements can be
> made there.

I'll second this - you're not going to get the in-memory caching in CF
that you need for something like this. You may want to investigate
using an OLAP cube for this sort of data instead of a standard OLTP
database, although interacting with this from CF will probably be more
complicated.

I'm not so sure how I feel about the phrase "well-endowed SQL server",
though. *bow chicka wow wow*

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:331369
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: How to handle large ResultSet, so that it can also be reused?

2010-03-04 Thread brad

Having read some more of your replies, I think I would recommend just
re-running the select every time.  10's of thousands of records really
isn't that large of a result for a well-endowed SQL server to transfer
around.  The big question is how long it takes to generate them. 
Analyze your execution plans for starters and see if improvements can be
made there. 

As a last resort, I would suggest caching the data at a database level. 
Create a 'work file' table with columns to store everything the report
needs, plus a columns for a unique session key and timestamp.  When
someone runs the report, dump their results in that table along with a
key unique to their session and the current date.  All subsequent sorts
or filters THAT USER does on the data will come from that table.  Create
a job to clear out any old records every night.  As long as you have
some well-placed indexed on your work table, you could have a million
records in that thing, and still get zippy results back from it.  I've
set up something similar to this as a proof of concept where I had a
very expensive query I wanted to cache per user, and it worked pretty
well.  

~Brad


 Original Message 
Subject: Re: How to handle large ResultSet, so that it can also be
reused?
From: sandeep saini 
Date: Thu, March 04, 2010 12:30 pm
To: cf-talk 


Also want to mention that we will have approx 200 concurrent users
creating such big reports.



~|
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:331368
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: How to handle large ResultSet, so that it can also be reused?

2010-03-04 Thread brad

Three main questions you need to ask yourself are:

1) What is the cost of retrieving the data from the database (time, CPU,
I/O)
2) What is the cost to cache it (memory mostly, speed of retrieval,
cache management overhead)
3) How re-usable will it be/how soon will it need to be invalidated

I worked on a security system once that stored a 700,000 record result
set in the application scope and then use query of queries on each page
to get results.  In the end, it wasn't any faster than a hit to the
database (in-memory results have no indexes) but we left it there just
to take some load off the database.

Sometimes people try to cache too much when a hit to a well-indexed
database can be rather inexpensive.  Other times caching can be very
handy if the database call is a very expensive operation.  Of course,
the benefits to storing a result set are inversely proportional to the
diversity of the result set.  If every user of the site gets a different
result, you might fill up your memory very quickly.

~Brad


-Original Message-
From: sandeep saini [mailto:sandeep00...@yahoo.com] 
Sent: Thursday, March 04, 2010 11:22 AM
To: cf-talk
Subject: How to handle large ResultSet, so that it can also be reused?


Hey Guys!

I am creating a Reporting website in which we may get huge(ten of
thousands
of records) data in query ResultSet. I may want to re-use this data as
well.
So what is the best and efficient way to handle(store and retrive?) such
a
resultset? 



~|
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:331367
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: OT JS question

2010-03-04 Thread Chad Gray

Ah I think I found one that will work
Number("");

I will test it out.

Thanks for the help!


-Original Message-
From: Chad Gray [mailto:cg...@careyweb.com] 
Sent: Thursday, March 04, 2010 3:04 PM
To: cf-talk
Subject: RE: OT JS question


Thanks for the suggestions but if I do this I get NaN (not a number I am 
guessing).

parseInt("FOO",10);
parseInt("",10);



-Original Message-
From: Jake Churchill [mailto:reyna...@gmail.com] 
Sent: Thursday, March 04, 2010 2:40 PM
To: cf-talk
Subject: Re: OT JS question


http://www.w3schools.com/jsref/jsref_parseInt.asp

var value = "15";
parseInt(value,10);

On Thu, Mar 4, 2010 at 1:37 PM, Chad Gray  wrote:

>
> Anyone know if there is an equivalent to CF’s val() in Javascript?
>
> I want to check a JS variable and set it to zero if it is blank.
>
> Thanks
>
> 





~|
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:331366
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: OT JS question

2010-03-04 Thread Chad Gray

Thanks for the suggestions but if I do this I get NaN (not a number I am 
guessing).

parseInt("FOO",10);
parseInt("",10);



-Original Message-
From: Jake Churchill [mailto:reyna...@gmail.com] 
Sent: Thursday, March 04, 2010 2:40 PM
To: cf-talk
Subject: Re: OT JS question


http://www.w3schools.com/jsref/jsref_parseInt.asp

var value = "15";
parseInt(value,10);

On Thu, Mar 4, 2010 at 1:37 PM, Chad Gray  wrote:

>
> Anyone know if there is an equivalent to CF’s val() in Javascript?
>
> I want to check a JS variable and set it to zero if it is blank.
>
> Thanks
>
> 



~|
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:331365
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: How to handle large ResultSet, so that it can also be reused?

2010-03-04 Thread Jason Fisher

If you're talking about 200 copies, each of 150,000 records, then Session 
and Application storage are going to be feasible only if you have 
sufficient physical memory on the ColdFusion server.  

200 x 15 x ?? = 30,000,000 x ?? bytes average record size

So, if an average record in the report set is very limited, simple data, 
say 20 columns each at 20 bytes (say small varchars or numbers), then 
you're still looking at caching in memory something like

30,000,000 x 400 bytes = 12,000,000,000 bytes = 11.2 GB 


Better have a $*!tton of memory on that box ...



~|
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:331364
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: How do people transfer data between databases nowdays?

2010-03-04 Thread Jason Fisher

Good to know, thanks.  My next trick is to get a 356 MB script to run LOL 
... time to break things up, I guess.



~|
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:331363
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: OT JS question

2010-03-04 Thread Andy Matthews

parseInt might do the trick.

parseInt(var)

-Original Message-
From: Chad Gray [mailto:cg...@careyweb.com] 
Sent: Thursday, March 04, 2010 1:37 PM
To: cf-talk
Subject: OT JS question


Anyone know if there is an equivalent to CF's val() in Javascript?
 
I want to check a JS variable and set it to zero if it is blank.
 
Thanks



~|
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:331362
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Strange things with MX 6.1

2010-03-04 Thread Brian Bradley

LOL!!! You are right.  Rookie mistake (ducks away in shame) - thanks. 

~|
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:331361
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: OT JS question

2010-03-04 Thread Jake Churchill

http://www.w3schools.com/jsref/jsref_parseInt.asp

var value = "15";
parseInt(value,10);

On Thu, Mar 4, 2010 at 1:37 PM, Chad Gray  wrote:

>
> Anyone know if there is an equivalent to CF’s val() in Javascript?
>
> I want to check a JS variable and set it to zero if it is blank.
>
> Thanks
>
> 

~|
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:331360
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


OT JS question

2010-03-04 Thread Chad Gray

Anyone know if there is an equivalent to CF’s val() in Javascript?
 
I want to check a JS variable and set it to zero if it is blank.
 
Thanks

~|
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:331359
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: How to handle large ResultSet, so that it can also be reused?

2010-03-04 Thread Dorioo

Transfer's cache deals with individual objects. Not a 150,000 record
query. I'd cross it off your list of potentials.

- Gabriel

On Thu, Mar 4, 2010 at 1:30 PM, sandeep saini  wrote:
>
> Also want to mention that we will have approx 200 concurrent users creating 
> such big reports.
>
> -sandeep
>
> 

~|
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:331358
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: How to handle large ResultSet, so that it can also be reused?

2010-03-04 Thread sandeep saini

Also want to mention that we will have approx 200 concurrent users creating 
such big reports.

-sandeep 

~|
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:331357
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: How to handle large ResultSet, so that it can also be reused?

2010-03-04 Thread sandeep saini

Well Steve, fixing DB is not a way to go (as of now) :-)  

With "Reuse", I mean that once we have data(in an object?). I may want to 
manipulate/query that for creating some more sub-reports. e.g. if i have 15 
rows, i may still want to get a subset of it and this time I  hate to again go 
back to DB. Rather I want to use this stored data object.

I know that there are facilities in Mach II to cach data but I never used it. 
So any suggestion on that would be great.

Also, transferORM can help me lot to avoid those cranky SQLs. So can this be 
useful(in caching) as well? If so how? 

~|
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:331356
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Strange things with MX 6.1

2010-03-04 Thread Jochem van Dieten

On 3/4/10, Brian Bradley wrote:
> I am writing new security system for a site using MX 6.1.  I have it working
> fine.  User puts in their e-mail and password, the system looks up the user
> account, and redirects the user to the logged in site.  The problem is, the
> site is a frameset and in each frame at the top-left-corner is a <

You probably have a stray < in your Application.cfm (or some other
template that is used in every frame).

Jochem


-- 
Jochem van Dieten
http://jochem.vandieten.net/

~|
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:331355
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: How to handle large ResultSet, so that it can also be reused?

2010-03-04 Thread Ian Skinner

On 3/4/2010 9:54 AM, sandeep saini wrote:
> Thanks Randy. But yes, the resulted data will be different for all users, So 
> cf catchedin will not be useful.
>
> -sandeep
>

The basic question you are asking here is where do you want to spend the 
cost of these large recordsets?  You can spend the cost in CPU and 
Network time by having the data stored in the database and fetched 
whenever it is needed.  Or you can spend the cost in memory where the 
record set could be stored in session scoped variables.  You also maybe 
able to do something half and half.   Such as where you grab the large 
data set the forms the basis of all the users sets and store it once in 
memory, then you would query this large set for the individual users set 
when those are needed.



~|
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:331354
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: How to handle large ResultSet, so that it can also be reused?

2010-03-04 Thread DURETTE, STEVEN J (ATTASIAIT)

Hate to say it...  Fix the database.

Fixing the database almost always shows a better speed increase and
processing than refactoring CF code. That is if the database is a mess
in the first place.

I've just started reading Joe Celko's SQL for Smarties, and in the first
chapter I've found stuff I've been doing wrong for years.  A few db
changes and a different mindset and things are starting to go faster for
me.

Steve


-Original Message-
From: sandeep saini [mailto:sandeep00...@yahoo.com] 
Sent: Thursday, March 04, 2010 12:55 PM
To: cf-talk
Subject: Re: How to handle large ResultSet, so that it can also be
reused?


Thanks Randy. But yes, the resulted data will be different for all
users, So cf catchedin will not be useful.

-sandeep 



~|
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:331353
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: How to handle large ResultSet, so that it can also be reused?

2010-03-04 Thread sandeep saini

Thanks Randy. But yes, the resulted data will be different for all users, So cf 
catchedin will not be useful.

-sandeep 

~|
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:331352
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Setting windows directory security with ColdFusion

2010-03-04 Thread Ian Skinner

On 3/4/2010 9:45 AM, Dave Watts wrote:
> That said, you could do this using CFEXECUTE and the command-line
> cacls/xcacls/icacls tools.
>

Thanks Dave, I had a strong feeling it was going to be something that 
tapped the command-line through CFEXECUTE.  But having never done 
directory security before with the command-line I didn't really know 
what would do it.  Thanks for the name of some relevant tools to help me 
search up the appropriate syntax.



~|
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:331351
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Setting windows directory security with ColdFusion

2010-03-04 Thread Dave Watts

> If one was to build an application that could be creating directories on
> a windows system.  Is there any way to set specific permissions on that
> newly created directory.  I understand that the  tag has
> the ability to set the UNIX permissions.  But, of course, windows is not
> so simple.

You're right, Windows is not so simple. But there's no reason that
CFDIRECTORY couldn't set permissions if it were simply designed to do
that, as in both OSs the creation of a filesystem object is a separate
action from setting non-default ACLs on that object. So, you might
consider submitting this as a feature request if you care enough to do
that.

That said, you could do this using CFEXECUTE and the command-line
cacls/xcacls/icacls tools.

> If this is at all possible, would it matter if the directories being
> created where on a file server and not directly on the web server.

Not really, but you'd have permissions issues to deal with in order to
create the directory in the first place. As you know, CF needs to run
as a user with permissions to write to that remote filesystem. Other
than that, no, it wouldn't matter.

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:331350
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: How to handle large ResultSet, so that it can also be reused?

2010-03-04 Thread Andy Matthews

If you want to reuse the results of a single query then your only option is
to store it in memory. I'd say you need to ask yourself whether the results
will be different from user to user, or for the entire application. That
will determine how you store the query.

If it's consistent across all users then you might be able to cache the
query on the server side. Alternately you could look at possibly storing it
in the Application or Server scopes.

I'm sure other, more experienced, developers have better suggestions.


andy 

-Original Message-
From: sandeep saini [mailto:sandeep00...@yahoo.com] 
Sent: Thursday, March 04, 2010 11:22 AM
To: cf-talk
Subject: How to handle large ResultSet, so that it can also be reused?


Hey Guys!

I am creating a Reporting website in which we may get huge(ten of thousands
of records) data in query ResultSet. I may want to re-use this data as well.
So what is the best and efficient way to handle(store and retrive?) such a
resultset? 

FYI- 1. I am using Mach II framework. Can Mach II caching can help? If yes,
how and how much? I also have some basic knowledge of TransferORM. 
2. The database(oracle) we have is hugh and is really dirty(cant even create
ERD using some tools). 

Thanks

   



~|
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:331349
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


How to handle large ResultSet, so that it can also be reused?

2010-03-04 Thread sandeep saini

Hey Guys!

I am creating a Reporting website in which we may get huge(ten of thousands of 
records) data in query ResultSet. I may want to re-use this data as well. So 
what is the best and efficient way to handle(store and retrive?) such a 
resultset? 

FYI- 1. I am using Mach II framework. Can Mach II caching can help? If yes, how 
and how much? I also have some basic knowledge of TransferORM. 
2. The database(oracle) we have is hugh and is really dirty(cant even create 
ERD using some tools). 

Thanks

   

~|
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:331348
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Strange things with MX 6.1

2010-03-04 Thread Brian Bradley

I am writing new security system for a site using MX 6.1.  I have it working 
fine.  User puts in their e-mail and password, the system looks up the user 
account, and redirects the user to the logged in site.  The problem is, the 
site is a frameset and in each frame at the top-left-corner is a < 

I have seen this once in a great while but usually goes away when I leave and 
come back but this time it happens each time.  Anyone ever get this weird 
character that may know of a solution?  Thanks. 

~|
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:331347
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Setting windows directory security with ColdFusion

2010-03-04 Thread Ian Skinner

If one was to build an application that could be creating directories on 
a windows system.  Is there any way to set specific permissions on that 
newly created directory.  I understand that the  tag has 
the ability to set the UNIX permissions.  But, of course, windows is not 
so simple.
If this is at all possible, would it matter if the directories being 
created where on a file server and not directly on the web server.

TIA
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:331346
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: CF Debugger for application scoped CFC

2010-03-04 Thread Dorioo

Don't know if it's supposed to work, but I have experienced it _not_
working once the CFC is in memory.

Told myself that the debugger processes files used in the request.
Once the CFC is memory, no files are parsed for it and so the debugger
does not fire. I'd love to be wrong though.

- Gabriel

On Thu, Mar 4, 2010 at 11:05 AM, Brook Davies  wrote:
>
> Hi Jochem,
>
> The debugging service itself starts and is running. The debugger does not
> break on the breakpoints. Sorry I should have been more clear. I did put the
> breakpoints in before caching. Should this work?
>
> Brook
>
> -Original Message-
> From: Jochem van Dieten [mailto:joch...@gmail.com]
> Sent: March-03-10 11:50 PM
> To: cf-talk
> Subject: Re: CF Debugger for application scoped CFC
>
>
> On 3/4/10, Brook Davies wrote:
>> I just set up the eclipse based CF debugger from adobe. Works fine on a
> CFM,
>> but doesn't start for an application scoped CFC.
>
> What do you mean exactly with "doesn't start"? Do you mean that th
> debug server doesn't start? Or do you mean that breakpoints you set
> are not being triggered?
> If the latter, did you put the breakpoints in before caching your cfc
> in the application scope?
>
> Jochem
>
>
> --
> Jochem van Dieten
> http://jochem.vandieten.net/
>
>
>
> 

~|
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:331345
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: How do people transfer data between databases nowdays?

2010-03-04 Thread Matthew Smith

I've had issues where it puts the view creation before the tables that the
view uses, causing an error when run.  Just keep an eye out for that.

On Wed, Mar 3, 2010 at 6:03 PM, Jason Fisher  wrote:

>
> Nice, I hadn't ever seen that tool before.  Can't wait to give it a
> spin.  Thanks!
>
>
>
> On 3/3/2010 5:08 PM, Matthew Smith wrote:
> > I use this.  Simple, works.
> >
> >
> http://www.microsoft.com/downloads/details.aspx?FamilyId=56E5B1C5-BF17-42E0-A410-371A838E570A&displaylang=en
> >
> > On Wed, Mar 3, 2010 at 12:23 AM, Mike Kear
>  wrote:
> >
> >
>
> 

~|
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:331344
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: CF Debugger for application scoped CFC

2010-03-04 Thread Brook Davies

Hi Jochem,

The debugging service itself starts and is running. The debugger does not
break on the breakpoints. Sorry I should have been more clear. I did put the
breakpoints in before caching. Should this work?

Brook

-Original Message-
From: Jochem van Dieten [mailto:joch...@gmail.com] 
Sent: March-03-10 11:50 PM
To: cf-talk
Subject: Re: CF Debugger for application scoped CFC


On 3/4/10, Brook Davies wrote:
> I just set up the eclipse based CF debugger from adobe. Works fine on a
CFM,
> but doesn't start for an application scoped CFC.

What do you mean exactly with "doesn't start"? Do you mean that th
debug server doesn't start? Or do you mean that breakpoints you set
are not being triggered?
If the latter, did you put the breakpoints in before caching your cfc
in the application scope?

Jochem


-- 
Jochem van Dieten
http://jochem.vandieten.net/



~|
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:331343
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Ionic Rewrite

2010-03-04 Thread Eric Roberts

OK.looks like the one I was using can't do what I want unless we pay $150
for it, so I am over to Ionic.  I am still not very clear on how to do
this.especially with the individual files for the virtual hosts.  The
instructions for this were a bit less than clear on how to accomplish this. 

 

So here's my structure.I have a folder that had the dll and the global INI
file and I have an IIRF.ini file in the directory that I have the site
pointed to (I put it in c:\inetpub\rewrite as a convenience).  The site is
in c:\intepub\wwwroot\job_posts.  When I do a
iirfstatus(http://localhost/job_posts/iirfstatus), it is looking for the
IIRF.ini in the  webroot and not the site root.  Is there something I need
to do to get it to see the IIRF.ini file in the site root?  I even tried
doing a dummy domain using the hosts file, so that I am not just going to a
subdirectory in the url and that didn't help.  Eventually I want this to be
delineated by dashes, but here is what I have using forward slashes.(not
very up on my reg ex :-\).

 

RewriteRule
^/job_posts/([^/]+)/?([^/]*)/?([^/]*)/?([^/]*)/?([^/]*)/?([^/]*.html)$
/job_posts/index.cfm?jobname=$1&company=$2&city=$4&state=$5&country=$6&clien
t=$7[L,QSA]

 

 

I really need so help with this and I am getting very frustrated with regex
as you can imagine.plus this doesn't do much as far as helping you debug, so
any assistance will be greatly appreciated.  Thanks in advance

 

Eric



~|
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:331342
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm