RE: Multi-Level CFTREE from a query?

2007-07-19 Thread Blum, Jason (SAA)
You didn't used to be able to do this easily in SQL Server, though I
think you can now.

In Oracle, it's easy using the START WITH and CONNECT BY syntax:

http://www.adp-gmbh.ch/ora/sql/connect_by.html



-Original Message-
From: Greg Luce [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, July 17, 2007 1:46 PM
To: CF-Talk
Subject: Re: Multi-Level CFTREE from a query?

Joe Celko's nested tree model works nicely. It was in the book SQL For
Smarties I believe.

Greg

On 7/17/07, Richard Colman [EMAIL PROTECTED] wrote:

 Does anyone know of an example of how to populate a multi-lvel CFTREE
 control from a query. There are doc examples showing hard coding the
 levels, but I can't seem to find one showing how to populate from a
 query.

 TNX if you can provide a pointer.

 Rick Colman

 



~|
ColdFusion 8 beta – Build next generation applications today.
Free beta download on Labs
http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta

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


Next Capitol Hill User Group (CHUG) Meeting: 7/25/07 3:00 PM

2007-07-14 Thread Blum, Jason (SAA)
Folks, please feel free to forward this on to friends, colleagues,
distribution lists on the House side, LOC, other agencies, anyone
around Capitol Hill doing web application development:



If you're interested in ColdFusion, Flex, ActionScript, JavaScript,
AJAX, XML and web application development in general, please join us
at the next meeting of the http://www.capitolhillusergroup.org/:

Wednesday July 25th 3-5 PM in the Dirksen Senate Office Building,
Room 192

When we last CHUGged, we talked shop and demoed ten new features of
ColdFusion MX8 (due out any old day now!)

At our next meeting, Matt's going to walk us through prototyping in
Flex, Jason's going to play a bit with the Google AJAX Feed API and
Brad's going to show off something Top Secret.

And if you've been working on something you'd like to share, just let
us know - the stage is yours!

We'll also list our top ten ColdFusion/Flex resources on the web and
hand out some slick Adobe swag!

We'll talk about some news highlights, recap the CFUnited and
FlexManiacs conferences and try to settle on a recurring date and time
for future CHUG meetings.

Please RSVP at
http://www.capitolhillusergroup.org/index.cfm?event=showRSVPFormmeeting
ID=BBADC841-F364-7101-6613B3AE80885568

And if you cant make it, you might keep in touch on our mailing list
at http://groups.google.com/group/capitolhillusergroup

~|
ColdFusion MX7 and Flex 2 
Build sales  marketing dashboard RIA’s for your business. Upgrade now
http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT

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


Next meeting of the Capitol Hill User Group: 6/19 3PM

2007-06-12 Thread Blum, Jason \(SAA\)
Capitol Hill User Group (CHUG)

Organizational Meeting and ColdFusion 8
6/19/07 3:00 PM
Senate Dirksen Office Building - Room 192

In our next meeting we'll deal with some organizational issues, and we
want to hear from YOU so we make sure the group best meets your needs.
We'll also demo some of the great new features in ColdFusion 8.

Note: anyone with anything to do with web development on Capitol Hill is
welcome.  Dirksen is open to the public.  All are welcome!

RSVP at http://www.capitolhillusergroup.org/




~|
ColdFusion MX7 and Flex 2 
Build sales  marketing dashboard RIA’s for your business. Upgrade now
http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT

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


RE: Inaugural Meeting of the Capitol Hill User Group with Special Guests Ben Forta, Tim Buntel and Adam Wayne Lehman!

2007-05-14 Thread Blum, Jason \(SAA\)
Just a reminder:

The inaugural meeting of the Capitol Hill User Group (CHUG) is THIS
Thursday at 1 PM in room 138 of the Dirksen Senate Office Building!

Ben Forta, Tim Buntel and Adam Wayne Lehman are confirmed!

RSVP http://www.capitolhillusergroup.org/ to be notified if anything
changes.

And join the CHUG mailing list at
http://groups.google.com/group/capitolhillusergroup to be notified of
future events.

Hope you can make it and feel free to pass this on!




-Original Message-
From: Blum, Jason (SAA) 
Sent: Tuesday, May 01, 2007 1:14 PM
To: cf-talk@houseoffusion.com
Subject: Inaugural Meeting of the Capitol Hill User Group with Special
Guests Ben Forta, Tim Buntel and Adam Wayne Lehman!



RSVP at http://www.capitolhillusergroup.org/


Please join us at the inaugural meeting of the Capitol Hill User Group
(CHUG), an Adobe User Group for U.S. Federal Government web developers
who use or are interested in using Adobe web development technologies.

We'll be focusing on development tools and languages like ColdFusion,
Flex, ActionScript and Apollo, but hope to touch on the broader areas of
Development Frameworks, XML, Web Services, Design Patterns and Object
Oriented Programming in general.

Ben Forta, Tim Buntel and Adam Wayne Lehman will be on hand to give us a
sneak peak of the next version of ColdFusion: MX8, AKA: Scorpio.

All skill levels are welcome!

We'll meet in room 138 of the Dirksen Senate Office Building, May 17,
from 1 to 3pm.

Be sure and RSVP at http://www.capitolhillusergroup.org/ to be notified
of any changes.

And consider subscribing to the CHUG mailing list at
http://groups.google.com/group/capitolhillusergroup to be notified of
future happenings.




~|
Create Web Applications With ColdFusion MX7  Flex 2. 
Build powerful, scalable RIAs. Free Trial
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS 

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


Inaugural Meeting of the Capitol Hill User Group with Special Guests Ben Forta, Tim Buntel and Adam Wayne Lehman!

2007-05-01 Thread Blum, Jason \(SAA\)
RSVP at http://www.capitolhillusergroup.org/


Please join us at the inaugural meeting of the Capitol Hill User Group
(CHUG), an Adobe User Group for U.S. Federal Government web developers
who use or are interested in using Adobe web development technologies.

We'll be focusing on development tools and languages like ColdFusion,
Flex, ActionScript and Apollo, but hope to touch on the broader areas of
Development Frameworks, XML, Web Services, Design Patterns and Object
Oriented Programming in general.

Ben Forta, Tim Buntel and Adam Wayne Lehman will be on hand to give us a
sneak peak of the next version of ColdFusion: MX8, AKA: Scorpio.

All skill levels are welcome!

We'll meet in room 138 of the Dirksen Senate Office Building, May 17,
from 1 to 3pm.

Be sure and RSVP at http://www.capitolhillusergroup.org/ to be notified
of any changes.

And consider subscribing to the CHUG mailing list at
http://groups.google.com/group/capitolhillusergroup to be notified of
future happenings.




~|
Upgrade to Adobe ColdFusion MX7
The most significant release in over 10 years. Upgrade  see new features.
http://www.adobe.com/products/coldfusion?sdid=RVJR

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


RE: getLineNumber()?

2006-04-05 Thread Blum, Jason \(SAA\)
Sandra, Dave, Sir Isaac,

Thanks for throwing out some ideas.

Not an urgent question - just poking around.

Thanks - J


-Original Message-
From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 04, 2006 6:18 PM
To: CF-Talk
Subject: RE: getLineNumber()?

 I notice the line number is given in the error scope.

 Does anyone happen to know whether its possible to grab
 the
 line number without throwing (and recovering from) an
 error?

 I.E.  Something like this

 7.
 8.
 9.   CFOUTPUT
 10.  #getCurrentLineNumber()#
 11.  /CFOUTPUT
 12.
 13.

 outputs:

 10

 I don't think there's anything built-in to do this - it's
 figured out by the
 compiler, I think.

 However, you could probably write a function or custom tag
 that (very
 inefficiently) uses CFFILE to read the file in question,
 find the number of
 lines in the file up to the point of that tag, and
 displays that number.

The problem you'd have with this is that there probably wouldn't be
any way to reliably output that value more than once without feeding
in the instance of the function in each call to it. I.e.
#getLineNumber(1)# -- #getLineNumber(2)#, etc... I assume you wouldn't
ever use this within a CFC.


s. isaac dealey 434.293.6201
new epoch : isn't it time for a change?

add features without fixtures with
the onTap open source framework

http://www.fusiontap.com
http://coldfusion.sys-con.com/author/4806Dealey.htm




~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236992
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


getLineNumber()?

2006-04-04 Thread Blum, Jason \(SAA\)
I notice the line number is given in the error scope.

Does anyone happen to know whether its possible to grab the line number
without throwing (and recovering from) an error?

I.E.  Something like this

7.  
8.
9.  CFOUTPUT
10. #getCurrentLineNumber()#
11. /CFOUTPUT
12.
13.


outputs:

10




-Jason

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236942
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


SQL syntax for Supertypes-Subtypes AKA Circular Reference AKA Entity Tree

2003-08-27 Thread Blum, Jason (SAA)
Hello,

Here's a puzzle for all you 'Joe Celko' types:

Am trying to figure out how to do on SQL Server something I can do in
Oracle.  I think this problem is variously known as Subtypes-Supertypes,
Circular Reference, Entity Tree, etc...

Given this data:

Columns: iEntityID, iSubEntityOf, sName
1 1 Mary 
2 2 1 Fritz 
3 3 1 John 
4 4 2 Abu 
5 5 2 Ludwig 
6 6 3 Abigail 
7 7 3 Josef 
8 8 6 Mark 
9 9 6 Ben 
10 10 6 Habib 
11 11 9 Paul 
12 12 11 Mahatma

I want to graphically represent the tree in this data - i.e. Mary is the
boss; Fritz and John report to Mary; Abu and Ludwig report to Fritz;
etc...

The important thing is that the SubEntityOf column is kind of a foreign
key to the primary key EntityID, such that the tree can be infinitely
deep.

I used to be able to do this in Oracle using:

CFQUERY NAME=GetEntities DATASOURCE=MyDatasource
SELECT iEntityID, iSubEntityOf, sName
FROM Mytable
WHERE NOT iEntityID
START WITH iEntityID=1
CONNECT BY PRIOR iEntityID=iSubEntityOf
/CFQUERY

But I can't use these functions in SQL Server...

Thanks!

-Jason
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com


RE: Congressional Data

2003-08-26 Thread Blum, Jason (SAA)
Hey Chuck,

The House maintains 

http://xml.house.gov/Members/mbr107.xml

but I don't know where the 108th congress is.

We have
http://www.senate.gov/general/contact_information/senators_cfm.xml 

We are working towards publishing web services out to our constituents.

-Jason

---
Jason Blum
Senior Information Technology Specialist
Enterprise Systems Support
U.S. Senate Sergeant at Arms
Washington D.C.  20510-7294
Tel.: (202) 224-4425
Pager: (202) 224-7889 #0073
---





Subject: Congressional Data
From: Chuck Rodgers [EMAIL PROTECTED]
Date: 
Thread:
http://www.houseoffusion.com/cf_lists/index.cfm?method=messagesthreadid
=0forumid=4#134110

Hi,

I did that and searching for congress data or congressional data did not
turn up anything.

Chuck Rodgers

- Original Message - 
From: Bryan Stevenson [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, August 20, 2003 12:14 PM
Subject: Re: Congressional Data


 I seem to recall this data being asked for a year or so ago on this
 list.might want to check the archives

 Bryan Stevenson B.Comm.
 VP  Director of E-Commerce Development
 Electric Edge Systems Group Inc.
 t. 250.920.8830
 e. [EMAIL PROTECTED]

 -
 Macromedia Associate Partner
 www.macromedia.com
 -
 Vancouver Island ColdFusion Users Group
 Founder  Director
 www.cfug-vancouverisland.com
 - Original Message -
 From: Chuck Rodgers [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Wednesday, August 20, 2003 8:46 AM
 Subject: OT: Congressional Data


  Hi,
 
  I am working with an association that wants to do some advocacy work
with
 their members.  We are looking for data for zip codes and
congressional
 districts to do lookups for Representatives in Congress.  Anyone have
any
 experience finding this kind of data?
 
  Thanks
 
  Chuck Rodgers
 
 
 



~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm


RE: Overlapping Security Sandboxes in MX?

2003-08-25 Thread Blum, Jason (SAA)
Hey Richard,

It's definitely not a looney idea.  I have been wondering the same
thing.

-J



Subject: Overlapping Security Sandboxes in MX?
From: Richard Heiser [EMAIL PROTECTED]
Date: Mon, 25 Aug 2003 05:26:51 -0700 (PDT)
Thread:
http://www.houseoffusion.com/cf_lists/index.cfm?method=messagesthreadid
=26634forumid=4#133924

Hello!

I teach a few ColdFusion classes and have to admin the
CF Server in a lab I share with other instructors.  I
am thrilled with MX's security sandboxes but
profoundly disappointed by the folks at MM apparently
missing what to me seems like the next obvious step:
overlapping security sandboxes: sandboxes that don't
necessarily override extensions that are called by
their local templates: Templates in Security Sandbox A
are denied access to resource C.  But templates in
sandbox A can invoke or call or include
templates in security sandbox B which are granted
access resource C.

So each student codes in a sandbox that has alone
access to some resource.  And their assignment is to
first expose that resource to classmates as a CFC, and
second to invoke everyone else's CFC's.

But think also about the implications for coordinating
a team of developers: everyone works on his or her own
black box and is essentially forced to build off
each others' code because they are not able to access
certain core resources in their own code.

So far, none of this can be achieved except via web
services.  All code called, invoked or included by a
template is subject to THAT template's local security
sandbox settings.  Sigh...

So what does everyone think?  Would this be totally
amazing?  Or is it just looney?  Anyone have any idea
how I might bounce this off someone up at MM?

Cheers!

-Richard


~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm


RE: clarification

2003-08-14 Thread Blum, Jason (SAA)
Brian Simmons at CentraSoft.com is always quick to respond if you have
any concerns about their questions.

-j

-Original Message-
From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] 
Sent: Saturday, August 09, 2003 8:46 PM
To: CF-Talk
Subject: clarification

Does anyone know what this will output and why?

#5 * True + yes - (Y  'Es')#


Possible answers are: 
0, 1, 5, Yes, An Error Will Be Shown


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: An ISP's Dream: Extensions in one sandbox, client code in another

2003-08-04 Thread Blum, Jason (SAA)
Hey Jochem,

Really appreciate your thoughts on this...

Suppose you do want all of your students to be able to experiment with
CFML.  You want them to learn about SQL perhaps within the confines of
QoQ.  But you know they come and go every year and aren't around long
enough to learn advanced best practices.  SO you do things like enforce
strict tag attributes and have CFAdmin check all locks.

But they're not really ready to write complex stored procedures and
outer joins with nested selects or something.  So, you package these in
custom tags and disable their CFQUERY to prevent them from even trying
it.

CFML is so wonderful because it is so easy to pick up.  But it is
powerful and as the language evolves, it might be helpful to make the
security framework even more flexible to allow a campus ISP to perhaps
host tiered contribution groups.  (If you hang my server, you get
bumped down to the novice group where you can only call custom tags...)

Am trying to think of better examples.  Again, thanks.





-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED] 
Sent: Monday, August 04, 2003 4:37 AM
To: CF-Talk
Subject: Re: An ISP's Dream: Extensions in one sandbox, client code in
another

Blum, Jason (SAA) wrote:
 
 Yes, the CFEXECUTE was a bad example.  Suppose instead you hosted all
a
 University's various colleges' websites on one server.

Make that fraternities and student societies and I do :-)


 None of them had
 particularly good developers and instead of teaching them all SQL and
 relational database theory

You would be surprised how little CS students know about 
databases. I much prefer EE students as webmaster :-)


 you just gave them backend logins to a CMS
 which you then queried on the front end.  You even packaged that query
 in a custom tag or component.  It's all working so well that you now
 want to discourage new grad students from even trying their own sql
 queries in their code, but instead to tie only into your custom tag.

And this is the part that would not work (at least for us). The 
thing is that they all have different needs and they all want to 
integrate with different backend systems. The rowing society 
wants to tie his user db into a reservation system for the boats. 
Fraternities want to tie it into a database for bookkeeping the 
beer. Student houses want to tie it into a system to keep track 
of who will attend dinner.

And they are students, so they want to do it the hard way no 
matter how easy you make it.


 How do you keep the calling templates' sandbox restrictions from
 extending to their use of your custom tag?

You don't. Not in the way CF works (but I think it is a Java 
thing so you might have more luck with C customtags).

But in your scenario, why not just install PHPNuke for them and 
give them the admin password of that? If you don't want them to 
write code, why not go the whole way and write a content 
management system and let them use that, don't even give them FTP 
access to a server.

Jochem



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: An ISP's Dream: Extensions in one sandbox, client code in another

2003-08-04 Thread Blum, Jason (SAA)
Jochem and Michael,

Interesting ideas - thanks!

I think I have done a poor job of describing the scenario.  Ben Forta's
Maybe We Should Try a Separation (CFDJ Vol 4 Issue 10) really got me
to thinking: there are so many good reasons for code reuse (faster
development time, centralized (policable) code, easier debugging,
etc.)  But getting developers to tie into existing resources is
hopeless, particularly when your community of developers comes and goes
and is rarely around long enough to really respond to your efforts to
get them to reuse codes and build off each others' functionality.

So forget about my scattered scenario and emphasis on databases: just
consider this question: How could you set up a server architecture
(whether internally via security sandboxes or externally via web service
syndication servers) that would encourage a development culture whose
members were free to develop however whatever they wanted, but faced
strong incentives to first utilize each others' reusable code?

Remember two things:

First, the community we are considering suffers from frequent turn
around.  Some of its members are pretty clever - most just want to get
something up and aren't always that interested in looking under the
hood.

Second, Their needs in functionality are generally pretty uniform.  Sure
they have their own data and different presentation layers.  But they
all have the same basic poll, announcements, staff directory kinds
of features on their website.

In other words, one good developer could probably do 95% of all the
functionality they need.

So how best to not merely advertise what that developer has done, but go
further and place strong incentives in their development methodology to
consider tying first into that developers' components and other
extensions?

Seems to me the best way would be to put everyone in one sandbox denied
certain tags and ports, etc...  but let them all post, per your
developers' approval, concise reusable code into another sandbox without
restrictions.  

Think of the implications for users both novice and advanced, for the
administrators' responsibility to ensure a secure and available
environment!

-Jason




-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED] 
Sent: Monday, August 04, 2003 8:35 AM
To: CF-Talk
Subject: Re: An ISP's Dream: Extensions in one sandbox, client code in
another

Michael T. Tangorre wrote:
 Just plan for it... have two databases running on
 a server so when one is mangled you can switch to the other one and
vice
 versa Now in a real world situation, resources are limited to some
 extent or should be anyway.

We have long since adopted the position that it is easier to just 
buy extra harddisks as to set, maintain, measure and enforce 
quota on disk use, bandwidth use and databases :-)
(If university provides you with a bunch of switch ports and 
power plugs for free, business rules change quite a lot.)

Jochem




~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: CFC Addressing

2003-08-03 Thread Blum, Jason (SAA)
Hi Sean,

Thank you - I see what you mean.  Actually the same is true even within
a single instance between multiple security sandboxes.

It's such a shame because ISP's would benefit so enormously from the
ability to not allow clients to query a database (i.e. restricting it in
their sandbox) - but allowing them to invoke a CFC in another sandbox
that could query that database.  Certainly you can do this invoking the
CFC as a Web Service.

But invoking it without having to run up and down the protocol stack
would be awfully nice!

Thanks for your thoughts on this...

-Jason

-Original Message-
From: Sean A Corfield [mailto:[EMAIL PROTECTED] 
Sent: Sunday, August 03, 2003 1:54 AM
To: CF-Talk
Subject: Re: CFC Addressing

On Saturday, Aug 2, 2003, at 05:59 US/Pacific, Jason Blum wrote:
 Does anyone happen to know whether one's calling template and one's 
 CFCs can reside in separate security sandboxes?  For instance, could 
 an ISP put all client sites in one default security sandbox with few 
 permissions/tags/etc, but then allow them to tie into CFCs in another 
 sandbox that does have all permissions.  This would make security, 
 availability and code reuse realitic goals!

The security system is per instance, i.e., each CFMX instance has its 
own sandbox security. If you had multiple CFMX (for J2EE) instances on 
a server, you could define the same shared CFC directory as a custom 
tag path in each instance and therefore reuse CFCs across multiple 
instances. However, the security applied would be that for each 
individual CFMX instance, therefore the same CFCs would be subject to 
potentially different security rules in each CFMX instance.

Sean A Corfield -- http://www.corfield.org/blog/

If you're not annoying somebody, you're not really alive.
-- Margaret Atwood


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



An ISP's Dream: Extensions in one sandbox, client code in another

2003-08-03 Thread Blum, Jason (SAA)
This question was tacked on to another discussion, but thought I might
solicit more feedback by starting its own thread?

From an ISP's perspective, would it not be a God-send to put all clients
in one big, heavily restricted sandbox (no datasources, etc.) and all
datasource-accessing CFC's and other extensions in another sandbox to
which only the ISP administrator has posting rights?

We would aggressively advertise the contents of the latter to the
clients using UDDI or just some kind of MM Exchange kind of catalog.
Clients would always be free to develop their own CFC's and extensions,
but would rapidly find tying into existing middle layer functionality an
increasingly appealing alternative.

Or consider a simpler example: You don't want clients CFEXECUTING some
local executable.  But you do want to allow them to drop into their code
a custom tag that can execute that local executable because in that tag
you have some logic or something that lets you fix parameters or
something.

So far, testing suggests the calling template's sandbox restrictions
always override anything they call or invoke, except obviously a remote
web service - but what a shame to have to go up and down the protocol
stack...

Have I missed something fundamental or would this not be a boon to
ISP's?!

-Jason
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Get the mailserver that powers this list at 
http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: An ISP's Dream: Extensions in one sandbox, client code in another

2003-08-03 Thread Blum, Jason (SAA)
Hi Jochem,

Yes, the CFEXECUTE was a bad example.  Suppose instead you hosted all a
University's various colleges' websites on one server.  None of them had
particularly good developers and instead of teaching them all SQL and
relational database theory, you just gave them backend logins to a CMS
which you then queried on the front end.  You even packaged that query
in a custom tag or component.  It's all working so well that you now
want to discourage new grad students from even trying their own sql
queries in their code, but instead to tie only into your custom tag.
(This may sound very controlling, but the fact is you have no time to
play help desk to these kids, they come and go so frequently, why
rebuild the wheel when they can reuse code, etc., etc...  So you disable
CFQUERY in their sandbox, but of course not in the sandbox containing
the custom tags...

How do you keep the calling templates' sandbox restrictions from
extending to their use of your custom tag?

-Jason



-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED] 
Sent: Sunday, August 03, 2003 5:55 PM
To: CF-Talk
Subject: Re: An ISP's Dream: Extensions in one sandbox, client code in
another

Blum, Jason (SAA) wrote:
 
 From an ISP's perspective, would it not be a God-send to put all
clients
 in one big, heavily restricted sandbox (no datasources, etc.) and all
 datasource-accessing CFC's and other extensions in another sandbox to
 which only the ISP administrator has posting rights?

Apart from the fact that it can't be done because of the Java 
security model, what does it give you that sandboxes don't give 
you now?


 Or consider a simpler example: You don't want clients CFEXECUTING some
 local executable.

With a shared instance that is a very bad idea indeed.


 But you do want to allow them to drop into their code
 a custom tag that can execute that local executable because in that
tag
 you have some logic or something that lets you fix parameters or
 something.

I don't really see a reason why customers would want to run any 
executable at all. And if they want it really bad they can always 
get hosting running their own instance. Or go up and down the 
protocol stack.


 Have I missed something fundamental or would this not be a boon to
 ISP's?!

I would not want to be hosted on a server where I can't write my 
own logic to access databases and/or the file system.

Jochem




~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: grrrrr ... CFSchedule

2003-01-02 Thread Blum, Jason (SAA)
I have been using probes for all my scheduled tasks since moving up to
MX.  Probes are under tools in CF5, but I don't know if they offer the
same functionality.

I realize of course they are probably the same underlying engine - but
for some reason, I have not experienced any problem with probes even
though they are the same tasks as were not being run as scheduled tasks.

Well I have seen one problem - or quirk: probes that I have long since
deleted still show up as failing in the MX Application log.  I should
figure out why, but keeps getting pushed to the back burner given that
everything seems to be working fine.

-j




-Original Message-
From: Robert Bailey [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, January 02, 2003 3:51 PM
To: CF-Talk
Subject: RE: gr ... CFSchedule

I have always tested my schedule scripts by having it email me at the
end for testing, and executed it with CFSCHEDULE the first time around
just to make sure it was completing. Very helpful when you are on a
shared host and do not have access to the admin to make sure it was
added correctly

-Original Message-
From: Matt Robertson [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, January 02, 2003 12:48 PM
To: CF-Talk
Subject: RE: gr ... CFSchedule

Howard Owens wrote:
snip
Any suggestions on why the scheduled events trigger but don't produce
any results?

I've always been able to get it to work, but the formula for success has
not always been entirely straightforward.

This may sound strange at first, but have you tried waiting for 24 hours
to see if the thing kicks in?

I've had my server monitor running for months on my home-based cf
server.  Then I had to fiddle with something in cfschedule (I forget
what, exactly) for another task and suddenly the thing went dead as a
doornail.  Couldn't get it to restart despite tinkering with all kinds
of stuff.

After a bit I gave up and went on to other things, but was very
surprised to see it had fired up again the next day, beginning at the
start time of the event -- despite the fact that the starting *date* was
in the past.

I've also had success using '' action=UPDATE '' in my cfschedule
statement.

All of the above is for CF 4.5.1sp2.  As an aside MX scheduling behaved
just fine after an upgrade overtop of cf 4.5x.

Shots in the dark, maybe, but who knows...

---
Matt Robertson, MSB Designs, Inc.
http://mysecretbase.com - Retail
http://foohbar.org - ColdFusion Tools
---

 
 


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm



CFMX hangs periodically

2002-12-30 Thread Blum, Jason (SAA)
There has been a pretty serious discussion thread going on in the
ColdFusion Macromedia Online Forum since October: CFMX hangs
periodically:

http://webforums.macromedia.com/coldfusion/messageview.cfm?catid=143thr
eadid=468954

I'm too new to this community to recognize names of cf-talk participants
in the macromedia forums, so I was curious to know whether anybody here
has been experiencing problems with CFMX.  Maybe I missed such an
exchange already.

But, I'll try to summarize the CFMX hangs periodically discussion
thread:

Everybody seems to be running CFMX with at least updater 1 on 2K with
SP3.
Most are using IIS 5.0.  A few people said the problem was IIS and that
the webserver that comes bundled with MX was great.  Somebody else said
they saw the same problems in MX on Linux.
Basically, jrun.exe just stops running occasionally.  Thread counts on
the jrun.exe climbs very high.  Handle count also climbs very high.
Most report no spiking in CPU or memory or anything except queued
requests.

There was some of the usual talk about properly locking Application
variables and vulnerability to race conditions.  But I know I, for one,
am not using ANY Application variables right now because I have stripped
down my server to running a single application to see if it continues to
lock up occasionally - it does.

Some have tried scheduling a java garbage collection routine and
restarting jrun.exe.  Others have reported no success with this
solution.

Some report a correlation with heavy load.  Others, like myself, see no
such correlation (as I am typing, my server just locked up again.)  I
can inflict 2000% plus load testing on my box with no impact on
performance.  But then I can go home for a few hours and it'll
invariably fail before bedtime.

Some are using SQL Server - others Oracle.

I see that Lee Fuller actually did bring this up in this cf-talk mailing
list and according to his post in the forum, solved the issue by going
back to ColdFusion 5.  -This after working closely with MM support.

I guess I am just wondering if that's it...  I am really reluctant to do
this because many of my applications are built on CFMX components...
But maybe abandoning MX is the only solution???  Funny thing is, all of
my apps ran just fine on this same configuration for almost two months.
Nothing has changed.  NOTHING!

Anyway, this struck me as a pretty serious issue that Macromedia has not
really been addressing - but it seemed to not get much play time on
cf-talk so I thought I'd ask whats up?

-j











~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm



CFHTTP URL=https.....

2002-12-04 Thread Blum, Jason (SAA)
When I added USERAGENT=Mozilla/4.0 (compatible; MSIE 6.0; Windows NT
5.1) to the CFHTTP tag, I stopped having problems CFHTTP-ing https
pages...

But now I've got a new https page which keeps failing, though I can see
it in any browser.  Dumping CFHTTP gives me:

FileContent: Connection Failure
Text: Yes
StatusCode: unavailable

Anybody got any idea what I am doing wrong?

tx!



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm



RE: CF 5 Scheduler fails

2002-11-12 Thread Blum, Jason (SAA)
I've usually been able to get scheduled tasks to run ok, but they fail
eventually, often without anything in the scheduler log, as if their
execution was simply forgotten.  From what I've heard, the scheduler is
widely regarded as pretty unreliable.

I've had some success running templates from the NT, 2K or crontab
(UNIX) schedulers.  The only trick there is that you have to run them in
Netscape so that you can include a script to close the window onload.

I posted an earlier message inviting recommendations for better
solutions - am now scrolling through to see if anyone responded...

-J



-Original Message-
From: Bosky, Dave [mailto:Dave.Bosky;htcinc.net] 
Sent: Tuesday, November 12, 2002 8:24 AM
To: CF-Talk
Subject: CF 5 Scheduler fails

What's the deal with the scheduler function in cfadmin? Every task I
schedule to run fails. 
BROWSER DATETIME 11/11/02 23:59:36 
DETAIL DIAGNOSTICS Connection Failure. Status code unavailable. 
 MESSAGE Connection Failure. Status code unavailable. 

TEMPLATE C:\CFUSION\SCRIPTS\CFEXECTASK.CFM 
TYPE COM.ALLAIRE.COLDFUSION.HTTPFAILURE 

Thanks,
Dave




HTC Disclaimer:  The information contained in this message may be
privileged and confidential and protected from disclosure. If the reader
of this message is not the intended recipient, or an employee or agent
responsible for delivering this message to the intended recipient, you
are hereby notified that any dissemination, distribution or copying of
this communication is strictly prohibited.  If you have received this
communication in error, please notify us immediately by replying to the
message and deleting it from your computer.  Thank you.

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm



RE: CF 5 Scheduler fails

2002-11-12 Thread Blum, Jason (SAA)
That's rich!  We're running MX update 1 on 2K.  I'll try it out and
report back...

-Original Message-
From: Ryan Farrell [mailto:farrellt;nuovotech.com] 
Sent: Tuesday, November 12, 2002 10:41 AM
To: CF-Talk
Subject: RE: CF 5 Scheduler fails

After getting a few months of support from Allaire, we've been running a
weekly-scheduled series of scripts successfully for about a year now.
We
are CF 5 on Solaris.  The trick was to always schedule a task so that
the
start date was actually a week prior to when you wanted the task to
begin.
So, if I wanted something to run every Wednesday starting tomorrow, I
would
enter the task with a start date of last week.  I'm not sure if this
works
for daily or monthly events, but it is the official solution that we
received from the Allaire engineers.

Ryan

-Original Message-
From: Blum, Jason (SAA) [mailto:Jason_Blum;saa.senate.gov]
Sent: Tuesday, November 12, 2002 9:36 AM
To: CF-Talk
Subject: RE: CF 5 Scheduler fails


I've usually been able to get scheduled tasks to run ok, but they fail
eventually, often without anything in the scheduler log, as if their
execution was simply forgotten.  From what I've heard, the scheduler is
widely regarded as pretty unreliable.

I've had some success running templates from the NT, 2K or crontab
(UNIX) schedulers.  The only trick there is that you have to run them in
Netscape so that you can include a script to close the window onload.

I posted an earlier message inviting recommendations for better
solutions - am now scrolling through to see if anyone responded...

-J



-Original Message-
From: Bosky, Dave [mailto:Dave.Bosky;htcinc.net] 
Sent: Tuesday, November 12, 2002 8:24 AM
To: CF-Talk
Subject: CF 5 Scheduler fails

What's the deal with the scheduler function in cfadmin? Every task I
schedule to run fails. 
BROWSER DATETIME 11/11/02 23:59:36 
DETAIL DIAGNOSTICS Connection Failure. Status code unavailable. 
 MESSAGE Connection Failure. Status code unavailable. 

TEMPLATE C:\CFUSION\SCRIPTS\CFEXECTASK.CFM 
TYPE COM.ALLAIRE.COLDFUSION.HTTPFAILURE 

Thanks,
Dave




HTC Disclaimer:  The information contained in this message may be
privileged and confidential and protected from disclosure. If the reader
of this message is not the intended recipient, or an employee or agent
responsible for delivering this message to the intended recipient, you
are hereby notified that any dissemination, distribution or copying of
this communication is strictly prohibited.  If you have received this
communication in error, please notify us immediately by replying to the
message and deleting it from your computer.  Thank you.



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com



Referencing component packages

2002-11-12 Thread Blum, Jason (SAA)
Forta, New Riders and others all say that you can call put all your
components in one folder and then reference them just as you would an
include, style sheet, whatever.

But I am absolutely stumped on how to do this.  Have followed their
instructions very carefully and played with variations but cannot seem
to do it.

If
/MySite/index.cfm

wants to instate
/MySite/components/Query.cfc

then CFINVOKE COMPONENT=components/Query...
works great.

But going back up the directory structure, say from:

/MySite/admin/index.cfm
CFINVOKE COMPONENT=../components/Query...

seems to be impossible without setting up a mapping in CFAdmin...

I've tried dot notation, forward slashes, backward slashes, from the
wwwroot, from the root drive, ExpandPath, etc., etc

Anybody know what I am doing wrong???


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm



RE: Referencing component packages

2002-11-12 Thread Blum, Jason (SAA)
Yeah, that's what I would have thought.  And that's precisely that all
the books and MX documentation say.  But it isn't working for me...

Thanks for the response though!







-Original Message-
From: Marlon Moyer [mailto:marlon;mcmoyer.com] 
Sent: Tuesday, November 12, 2002 12:19 PM
To: CF-Talk
Subject: Re: Referencing component packages

I believe it should be

cfinvoke Component=mySite.components.query

Blum, Jason (SAA) wrote:

Forta, New Riders and others all say that you can call put all your
components in one folder and then reference them just as you would an
include, style sheet, whatever.

But I am absolutely stumped on how to do this.  Have followed their
instructions very carefully and played with variations but cannot seem
to do it.

If
/MySite/index.cfm

wants to instate
/MySite/components/Query.cfc

then CFINVOKE COMPONENT=components/Query...
works great.

But going back up the directory structure, say from:

/MySite/admin/index.cfm
CFINVOKE COMPONENT=../components/Query...

seems to be impossible without setting up a mapping in CFAdmin...

I've tried dot notation, forward slashes, backward slashes, from the
wwwroot, from the root drive, ExpandPath, etc., etc

Anybody know what I am doing wrong???




~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm



RE: WHYYYYY!!!!!!

2002-09-23 Thread Blum, Jason (SAA)

Maybe I can jump in on this thread with a related question - Dave and
others keep emphasizing that it isn't necessary to lock in MX.

I am using a large Application.Array for a number of values and strings
which I then loop through to output.  The array is being written to and
read from at least a dozen times a minute - I do this because I figured
it would be best to just keep it in memory given how frequently it gets
referenced.

But then I keep getting the same symptom - MX freezes up at 100% CPU
every four or five hours.  Plenty of memory and storage.

Again, not locking Application variables because I thought it was
unnecessary.

So,
1, is it in fact necessary in MX and
2, Is an Application.array the best place to store this kind of thing?

Thanks!

-Jason 




-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]] 
Sent: Monday, September 23, 2002 1:52 AM
To: CF-Talk
Subject: RE: WHY!!

 i havent used locks on session vars, havent
 needed to, and having never formally learned
 cf, not really 100% down with the thought
 process behind locking session var setting...

The thought process is very simple. If you're running CF 5 or earlier,
and
you're using session variables, and you don't lock them, bad things will
happen. Memory variables can be accessed by concurrent requests, and CF
doesn't handle that well, by default. While you might not think session
variables would be used by concurrent requests, there are many possible
cases in which more than one request from the same user might be running
concurrently.

 any good books on that topic?

A book would be overkill, just for this topic. If you're using CF 5 or
earlier, just follow these simple rules:

1. Dvery time you put Session, Application or Server in your code,
use
CFLOCK around it.

2. If you're using any version of CF which supports the SCOPE attribute
(4.5+, I think), use that with your CFLOCK tags around memory variables.

3. If you're reading a memory variable, use TYPE=READONLY in your
CFLOCK;
if you may change the variable's value, use TYPE=EXCLUSIVE.

4. There is no rule 4.

5. Reread rule 1.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444

: dream :: design :: develop :
MXDC 02 :: Join us at this all day conference for 
designers  developers to learn tips, tricks, best 
practices and more for the entire Macromedia MX suite.

September 28, 2002  ::  http://www.mxdc02.com/
(Register today, seats are limited!)
::


__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



CF from command line

2002-09-23 Thread Blum, Jason (SAA)

Ben Forta offers this tip on his website:

Invoke ColdFusion From the Command Line:  

ColdFusion usually processes requests received from clients (such as Web
browsers or WAP devices). But should you ever need ColdFusion to process
a page without initiating it from a browser you can do so via CF's CGI
interface - cfml.exe. Although intended to provide support for Web
servers not natively supported by ColdFusion, this command-line program
has another use in that it lets you initiate CF requests on demand.

http://www.forta.com/cf/tips/index.cfm?age=666


..Is this not available in MX?
__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Help troubleshooting MX freezing up each day

2002-09-18 Thread Blum, Jason (SAA)

Hey all!

Just wondering if anyone might have any suggestions on what to look for
in troubleshooting why my MX server freezes up each day.  (Win 2K, 1 GB
RAM, tons of free HD space - a brand new system.)

It's a dedicated server, only this one application running.

It is a kind of Enterprise monitoring system.  Ten templates each
contain various tests, like HTTP requests, directory counts, etc.  The
results of each test are saved to a large 2-d Application.array.  The
results are also appended to a log file.

All templates are scheduled tasks which run every five minutes, rarely
simultaneously as their schedules are offset by a minute.

Users request another template which just loops through that
Application.array to output all the test results in one place.  This
page also has javascript to refresh every 4 minutes.

Not using CFAdmin scheduler because too unstable.  Instead, Windows 2000
Scheduled tasks HTTP requests all templates through Netscape (because
Netscape permits Javascript to close window on pageload).

No datasources - all just Application variables and reading and writing
to files.

Very little traffic - less than an average of 5 requests a minute.

There are a couple client variables to toggle alarm on and off and other
preferences.  No session variables.

Whole system works great but just freezes up an average of once every
other day (never at the same time) - Restarting the MX server is all I
can do.

I am not locking Application variables because I thought it was
unnecessary in MX.

The only thing I can think of is that every once in a while, two
templates just happen to append to the same log file at the same time?
Or maybe you do have to lock Application variables?

I know there are probably a million things to look at - perhaps someone
could direct me to some good documentation on the subject?  I've looked
everywhere I can think of...

Thank you so much for any help anyone can provide!

-Jason
__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Help troubleshooting MX freezing up each day

2002-09-18 Thread Blum, Jason (SAA)

Thanks Marius - I agree and have added locks around file reads and
writes - will see how it works...

One follow up question though: I was under the impression that MX locks
file and variables reads/writes automatically.  

And indeed, Page 187 of CFML Reference says In the ColdFusion
Administrator, Server section, the Locking page sets locking options
according to scope...

I don't see any such section - does anyone know what they are talking
about?  I thought I was pretty familiar with the adminterface but don't
see this anywhere...

-jason



-Original Message-
From: Marius Milosav [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, September 18, 2002 9:02 AM
To: CF-Talk
Subject: Re: Help troubleshooting MX freezing up each day

While locking the applications doesn't hurt, I think you should lock the
cffile process (with named locks) when writing to the log file. This way
you
are single threading access to the file.

Marius Milosav
www.scorpiosoft.com
It's not about technology, it's about people.
Virtual Company (VICO) Application Demo
www.scorpiosoft.com/vicodemo/login.cfm

- Original Message -
From: Blum, Jason (SAA) [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, September 18, 2002 8:33 AM
Subject: Help troubleshooting MX freezing up each day


 Hey all!

 Just wondering if anyone might have any suggestions on what to look
for
 in troubleshooting why my MX server freezes up each day.  (Win 2K, 1
GB
 RAM, tons of free HD space - a brand new system.)

 It's a dedicated server, only this one application running.

 It is a kind of Enterprise monitoring system.  Ten templates each
 contain various tests, like HTTP requests, directory counts, etc.  The
 results of each test are saved to a large 2-d Application.array.  The
 results are also appended to a log file.

 All templates are scheduled tasks which run every five minutes, rarely
 simultaneously as their schedules are offset by a minute.

 Users request another template which just loops through that
 Application.array to output all the test results in one place.  This
 page also has javascript to refresh every 4 minutes.

 Not using CFAdmin scheduler because too unstable.  Instead, Windows
2000
 Scheduled tasks HTTP requests all templates through Netscape (because
 Netscape permits Javascript to close window on pageload).

 No datasources - all just Application variables and reading and
writing
 to files.

 Very little traffic - less than an average of 5 requests a minute.

 There are a couple client variables to toggle alarm on and off and
other
 preferences.  No session variables.

 Whole system works great but just freezes up an average of once every
 other day (never at the same time) - Restarting the MX server is all I
 can do.

 I am not locking Application variables because I thought it was
 unnecessary in MX.

 The only thing I can think of is that every once in a while, two
 templates just happen to append to the same log file at the same time?
 Or maybe you do have to lock Application variables?

 I know there are probably a million things to look at - perhaps
someone
 could direct me to some good documentation on the subject?  I've
looked
 everywhere I can think of...

 Thank you so much for any help anyone can provide!

 -Jason
 

__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Is it necessary to parse XML in order to use it as a dat

2002-09-05 Thread Blum, Jason (SAA)

I'm trying to code for both MX and 5

-Jason




-Original Message-
From: [EMAIL PROTECTED] at Internet
Sent: Wednesday, September 04, 2002 9:02 PM
To: CF-Talk [EMAIL PROTECTED] at Internet
Subject: RE: Is it necessary to parse XML in order to use it as a dat

What version CF you using?

-- Original Message --
From: Blum, Jason (SAA) [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
Date:  Wed, 04 Sep 2002 19:35:00 -0400

Another newbie question:

I am just trying to figure out how this whole xml thing works - I keep
seeing examples of serializing in WDDX in which the sample code creates
a text file like:

?xml version=1.0 ?
 contact_information
  person
 last_nameBlum/last_name
 first_nameJason/first_name
  /person
  person
 last_nameCostanza/last_name
 first_nameGoerge/first_name
  /person
 /contact_information

and then serializes it... and then takes output and deserializes it back
into a structure.

At what point does this involve parsing  Isn't WDDX just recognizing
the beginning and end tags and forming a structure out of them dumbly
without being aware of what those tags mean?  That's all I'm after
because then I can loop through the structure and output it different
ways...

I guess I understood the whole point of XML to be to allow the client to
do that outputting in different ways but since I can't assume the
client is the latest version of IE, I figured I should do it for them by
hitting the server.

When I hear talk of installing a parser in ColdFusion, my head spins,
particularly because all I want to do is access this xml file like a
datasource and I know I could just write a custom tag to create a
structure out of the fields...

That said, I know I am missing the point so I figured who better to
ask then the cf community!

Thanks for your help!

-Jason


__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Is it necessary to parse XML in order to use it as a datasou

2002-09-04 Thread Blum, Jason (SAA)

Another newbie question:

I am just trying to figure out how this whole xml thing works - I keep
seeing examples of serializing in WDDX in which the sample code creates
a text file like:

?xml version=1.0 ?
 contact_information
  person
 last_nameBlum/last_name
 first_nameJason/first_name
  /person
  person
 last_nameCostanza/last_name
 first_nameGoerge/first_name
  /person
 /contact_information

and then serializes it... and then takes output and deserializes it back
into a structure.

At what point does this involve parsing  Isn't WDDX just recognizing
the beginning and end tags and forming a structure out of them dumbly
without being aware of what those tags mean?  That's all I'm after
because then I can loop through the structure and output it different
ways...

I guess I understood the whole point of XML to be to allow the client to
do that outputting in different ways but since I can't assume the
client is the latest version of IE, I figured I should do it for them by
hitting the server.

When I hear talk of installing a parser in ColdFusion, my head spins,
particularly because all I want to do is access this xml file like a
datasource and I know I could just write a custom tag to create a
structure out of the fields...

That said, I know I am missing the point so I figured who better to
ask then the cf community!

Thanks for your help!

-Jason
__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



*** Scheduled Tasks in CFAdministrator ***

2002-08-27 Thread Blum, Jason (SAA)

Hello all!

Has anyone else had trouble with the reliability of scheduled tasks in
CFAdministrator?

I am running nine of them, all more or less identical (just simple HTTP
requests to make sure certain servers are up and running), repeating
every half hour.

And they pretty much work fine, except that every day or two, one (never
the same one) stops running for hours.  According to the scheduler log,
it just literally stops being executed.

I guess I could schedule them in Windows 2000 task scheduler, but I
don't know how to do that for a specific URL - anybody?

Thanks!

-Jason
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists