Re: Hosting Announcement

2008-07-13 Thread Mike Kear
Am I being too forward then to suggest another low cost alternative,
that DOESNT ban CFDUMP?   In fact there are only a very few
tags/functions we dont enable.   There are some that are disabled by
default, but if you want them, we'll enable them for you, after
setting up a sandbox for you.

We're not as low-cost as that offer was, but then we dont disable
essential tags like CFDUMP.

I agree that normally you wouldnt need to debug on a production
system, but as you say, William, what if something DOES go wrong on
the production box?   How do you debug the problem without all the
debugging tools.   On a production box you turn off the robust error
messages, so CFDUMP is very useful for quickly debugging problems.
Yes you can get by without - using CFTRY/CFCATCH to grab the errors
and sending them to yourself by email, but sometimes a CFDUMP is the
quick way to see what's going on if you are on a shared server.

Have a look at http://afpwebworks.com and see if that won't help you
out.  (Currently showing our server is CF7 but in fact new accounts
are going on a CF8 box, and we're changing everyone to CF8 in teh next
week or so)

Cheers
Mike Kear
Windsor, NSW, Australia
Adobe Certified Advanced ColdFusion Developer
AFP Webworks
http://afpwebworks.com
ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month



On Mon, Jul 14, 2008 at 3:53 PM, William Seiter <[EMAIL PROTECTED]> wrote:
> Their technical support knows and knew that the cfdump tag was not
> permitted, regardless of how it functions behind the scenes.  They should
> have shown that in their advertised list of tags they don't support.
>
> Of course I have a development environment.  The intention was to build a
> quick and easy system that wouldn't necessitate me to replicate everything.
> Besides, it isn't unheard of to have to debug a system after launching it to
> someone else's box.
>
> https://support.dailyrazor.com/index.php?_m=knowledgebase&_a=viewarticle&kba
> rticleid=293&nav=0,29,76
>
>
> William
>

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

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


RE: Hosting Announcement

2008-07-13 Thread William Seiter
Their technical support knows and knew that the cfdump tag was not
permitted, regardless of how it functions behind the scenes.  They should
have shown that in their advertised list of tags they don't support.

Of course I have a development environment.  The intention was to build a
quick and easy system that wouldn't necessitate me to replicate everything.
Besides, it isn't unheard of to have to debug a system after launching it to
someone else's box. 

https://support.dailyrazor.com/index.php?_m=knowledgebase&_a=viewarticle&kba
rticleid=293&nav=0,29,76


William

::William Seiter wrote:
::> I just found out (the hard way) that in addition to this:
::> On the shared ColdFusion servers you will have access to all tags and
::> functions except for the following:
::
::> CF Functions:
::
::> CreateObject(JAVA)
::>
::> They don't allow the 'CFDUMP' tag!!
::
::Most likely they do allow access to the cfdump tag, but cfdump is trying
::to inspect a variable by using a CreateObject("java", ...) internally.
::You could ask Adobe to fix that: http://adobe.com/go/wish/
::
::
::> Does any one have any experience with this company?  Is there a 'magic
::way'
::> to get them to turn on the 'CFDUMP' tag?
::
::What do you need cfdump for anyway? Don't you have a development
::environment?
::
::Jochem
::
::

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

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


Re: Multiple queries from a CFC? Drop in Array?

2008-07-13 Thread James Holmes
I'd return a struct. Put each query result into one key of the struct.

On Mon, Jul 14, 2008 at 12:43 PM, Ian Rutherford
<[EMAIL PROTECTED]> wrote:
> I am trying to move some of my database access to cfcs and am trying to 
> figure out how to get a set of five query results in a stored procedure out 
> of a cffunction. I think I would use an array but am having a hard time 
> visualizing how it would work.
>
> The stored proc returns:
>
> An order. Each order can have n parts. Each part can have n line items. The 
> order can also have multiple gift certificates and status comments attached 
> to it. I could loop through the order parts calling another cffunction to get 
> each piece but that would result in a lot of database calls that I don't 
> think I need to make. Am I right about using an array?

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

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

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


Multiple queries from a CFC? Drop in Array?

2008-07-13 Thread Ian Rutherford
I am trying to move some of my database access to cfcs and am trying to figure 
out how to get a set of five query results in a stored procedure out of a 
cffunction. I think I would use an array but am having a hard time visualizing 
how it would work.

The stored proc returns:

An order. Each order can have n parts. Each part can have n line items. The 
order can also have multiple gift certificates and status comments attached to 
it. I could loop through the order parts calling another cffunction to get each 
piece but that would result in a lot of database calls that I don't think I 
need to make. Am I right about using an array? 

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

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


Re: Report Builder Question

2008-07-13 Thread Rob Parkhill
Mike,

So how is it passed to the report?  Through a Query?  Does each product
(item per invoice) have a set number of lines, or does each product take a
single line.  If it does, then you could just write a function in the report
that took the number of items passed and divide by the number of items per
page and then you can figure out the total number of pages.  Again, not sure
how the report is being hooked into the database, but I am sure that there
will be someway to get consistent footer into it.

Rob

On Sun, Jul 13, 2008 at 12:04 PM, Mike Greider <[EMAIL PROTECTED]>
wrote:

> Hi Rob. I have, but I may not be smart enough about this. The number of
> pages is totally dynamic. It is an invoice with N number of products with N
> number of lines of description per each. I tried using the page number that
> is evaluated at the report run time, but that isn't working as a print when
> condition. I thought something like this would be my best chance, but I
> couldn't quite figure it out?
>
> >Mike,
> >
> >Have you looked into the print when conditions for the band properties of
> >the footer?  If you were to know the max number of pages that were to be
> >generated for the invoice you could pass that as a var to the report and
> >then just do a print when condition on the calc.pagenumber function so
> that
> >it equalled whatever the max number of pages were going to be.
> >
> >That is where I would start anyways.
> >
> >Rob
> >
> >On Thu, Jul 10, 2008 at 7:13 PM, Dave Watts <[EMAIL PROTECTED]> wrote:
>
> 

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

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


Re: Hosting Announcement

2008-07-13 Thread Jochem van Dieten
William Seiter wrote:
> I just found out (the hard way) that in addition to this:
> On the shared ColdFusion servers you will have access to all tags and
> functions except for the following:

> CF Functions:

> CreateObject(JAVA)
> 
> They don't allow the 'CFDUMP' tag!!

Most likely they do allow access to the cfdump tag, but cfdump is trying 
to inspect a variable by using a CreateObject("java", ...) internally. 
You could ask Adobe to fix that: http://adobe.com/go/wish/


> Does any one have any experience with this company?  Is there a 'magic way'
> to get them to turn on the 'CFDUMP' tag?

What do you need cfdump for anyway? Don't you have a development 
environment?

Jochem

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

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


RE: Hosting Announcement

2008-07-13 Thread William Seiter
Holy Whatevers!!

I just found out (the hard way) that in addition to this:
On the shared ColdFusion servers you will have access to all tags and
functions except for the following:

CF Tags:
CFCOLLECTION
CFCONTENT
CFEXECUTE
CFLOG
CFOBJECT
CFOBJECTCACHE
CFREGISTRY

CF Functions:
SetProfileString
CreateObject(COM)
CreateObject(CORBA)
CreateObject(JAVA)

They don't allow the 'CFDUMP' tag!!

Does any one have any experience with this company?  Is there a 'magic way'
to get them to turn on the 'CFDUMP' tag?

Or are they just SFB to begin and end with??

William


--
William Seiter
ColdFusion Web Developer / Consultant
http://william.seiter.com
 
Free Website Trade Publication >> Website Magazine
http://www.websitemagazine.com/referrals/?id=51344&f=text2
Don't forget to answer the survey questions, it's a 10 second task ,
a very small request  for access to this  incredible resource.
 
Have you ever read a book that changed your life?
Go to: http://www.winninginthemargins.com
Use PassKey: GoldenGrove
You'll be glad you did.
 
 

::-Original Message-
::From: William Seiter [mailto:[EMAIL PROTECTED]
::Sent: Monday, July 07, 2008 1:16 PM
::To: CF-Talk
::Subject: Hosting Announcement
::
::
::http://www.dailyrazor.com
::
::Daily Razor is having a HUGE sale today (July 7).
::
::Whatever plan you choose, you will get 4X the value!!  Want a plan that
::can host 32 websites, choose the starter plan and the 8 domains becomes 32
::domains.
::
::I am not affiliated with them (just a customer), so I wouldn't mind if you
::mention me in the comments section, but I don't think I get any credit for
::referrals.
::
::This is a great increase in value.
::
::William Seiter
::
::
::

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

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


Re: JVM auto-restart on Out of Memory error?

2008-07-13 Thread Wil Genovese
>I'd like to set our JVMs to automatically restart when we get a Java out of
>memory error. I believe I had this before at another job, but now can't find
>the JVM options for this (CFMX 7.02, JVM 1.4.2_11, on Windows 2003 Server).
>
>Sun describes some great options, but they're on later JVM versions. I may
>be able to use -XX:OnError=";" for running user commands
>on fatal error, but I was wondering what other possibilities there are.
>
>Thank you,
>Chris

There are many reasons to be running short on memory.  I've seen runaway 
queries that return far more records that expected cause memory to ramp up.  
Others have asked how much are your storing in memory. This is critical to know 
and well as knowing how much memory you have configured in your jvm.config file 
for overall JVM memory and for the various other memory settings and garbage 
collection settings.  Also, the version of JVM matters.  Move up to the newest 
version of 1.4.2_1x.  We've been using 1.4.2_16 with very few issues.  In my 
opinion everything before _13 had way too many problems.

You need to do a few things.  Monitor the server 24/7 to see what the cause of 
the memory shortage may be. Check out Seefusion or fusion reactor. Both record 
24/7 and can profile your JDBC connections as well as the rest of CF memory and 
requests.  The other (cheap?) option is to continuously what your CF logs, but 
somethings like large query result sets just won't be recorded in a log file.  
Upgrade your JVM and figure out the best memory settings for your usage.  Some 
apps need to use more memory due to the sheer size of the app and the number of 
users on at a time.  I know we usually have 4k to 7k user sessions at any given 
point in time and our JVM memory hovers around 500mb to 600mb of memory used at 
any given time.

As far as your first question, if you were running Linux I have BASH scripts 
that monitor CF for memory usage and timeouts and can restart the CF service if 
needed.  I wrote these scripts for the same reasons. We needed something to 
handle the server restarts at all hours of the day or night while we debugged 
millions of lines of CF code in hundreds of CF applications.  In the Windows 
Services panel I think you can define actions to take when the service becomes 
unresponsive.  I've never tried this feature, but it might work.  Just select 
the Coldfusion service and view properties.  There is a tab for Recovery.  Of 
course, since your using Server 2003 it may be a bit different. I've never used 
that version of Windows server.  I switched to almost all non-windows 
computers.  

Cheers and good luck.
Wil Genovese
Sr. Web Application Developer 

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

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


RE: Report Builder Question

2008-07-13 Thread Dave Watts
> That is interesting. I do not have experience with the CFPDF 
> tag, just the report builder. In combining the signature 
> page, is it smart enough to put it at the bottom of the page, 
> and only a new page if there is not enough room?

No, you can only add a new page.

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

Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!

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

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


Re: Report Builder Question

2008-07-13 Thread denstar
JasperReports is built right into coldfusion.

You can create a jasperreport JRXML file using iReport, and use
createObject to run the report, etc.

I don't do it any more because report generation takes such a toll on
the server, and it's just waay better to have report stuff running
on a separate server, pulling from a replication database.  So now I
use JasperServer, and it's KICK ASS!

For anyone doing a lot of reporting, I'd recommend it.  Simply the best!

But if you're "stuck" with pure CF, and need to do those common
reporting things that are just impossible with reportbuilder, then
createObject and jasperrepoerts might be the way to go, because you
can build the reports with iReport, which is a STELLAR report-builder
(cross platform y todo).

HIH,
:Denny

-- 
If an injury has to be done to a man it should be so severe that his
vengeance need not be feared.
Niccolo Machiavelli

On Sun, Jul 13, 2008 at 10:04 AM, Mike Greider <[EMAIL PROTECTED]> wrote:
> Hi Rob. I have, but I may not be smart enough about this. The number of pages 
> is totally dynamic. It is an invoice with N number of products with N number 
> of lines of description per each. I tried using the page number that is 
> evaluated at the report run time, but that isn't working as a print when 
> condition. I thought something like this would be my best chance, but I 
> couldn't quite figure it out?
>
>>Mike,
>>
>>Have you looked into the print when conditions for the band properties of
>>the footer?  If you were to know the max number of pages that were to be
>>generated for the invoice you could pass that as a var to the report and
>>then just do a print when condition on the calc.pagenumber function so that
>>it equalled whatever the max number of pages were going to be.
>>
>>That is where I would start anyways.
>>
>>Rob
>>
>>On Thu, Jul 10, 2008 at 7:13 PM, Dave Watts <[EMAIL PROTECTED]> wrote:
>
> 

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

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


Re: Report Builder Question

2008-07-13 Thread Mike Greider
Hi Rob. I have, but I may not be smart enough about this. The number of pages 
is totally dynamic. It is an invoice with N number of products with N number of 
lines of description per each. I tried using the page number that is evaluated 
at the report run time, but that isn't working as a print when condition. I 
thought something like this would be my best chance, but I couldn't quite 
figure it out?

>Mike,
>
>Have you looked into the print when conditions for the band properties of
>the footer?  If you were to know the max number of pages that were to be
>generated for the invoice you could pass that as a var to the report and
>then just do a print when condition on the calc.pagenumber function so that
>it equalled whatever the max number of pages were going to be.
>
>That is where I would start anyways.
>
>Rob
>
>On Thu, Jul 10, 2008 at 7:13 PM, Dave Watts <[EMAIL PROTECTED]> wrote: 

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

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


Re: Report Builder Question

2008-07-13 Thread Mike Greider
That is interesting. I do not have experience with the CFPDF tag, just the 
report builder. In combining the signature page, is it smart enough to put it 
at the bottom of the page, and only a new page if there is not enough room?

Mike

>> Does anyone know how to either (a) get a page footer to only 
>
>I'm not aware of any way to do this from within the report builder, but you
>can take the generated PDF report and use the CFPDF tag to assemble a new
>PDF from your report and a separate signature page. This is covered in the
>Adobe "Advanced ColdFusion 8" course. I can provide a code sample when I
>return to my office, if necessary. If you do this, though, the signature
>page will be the last page; it won't be appended to the last page of your
>report.
>
>Dave Watts, CTO, Fig Leaf Software
>http://www.figleaf.com/
>
>Fig Leaf Software provides the highest caliber vendor-authorized
>instruction at our training centers in Washington DC, Atlanta,
>Chicago, Baltimore, Northern Virginia, or on-site at your location.
>Visit http://training.figleaf.com/ for more information! 

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

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


Re: IsDefined()

2008-07-13 Thread Dominic Watson
> so cf will always be undefined until there is a page refresh?.

Close. When you output the form you are simply outputting HTML for the
*client* to process; that's it (so yes, the variables are not
available). When the client sends a POST or GET request using the
form, those variables are sent over http to the *server*  (ie.
ColdFusion) and are then available. If they refresh the page, they are
simply requesting the same original request and so the variables will
still not be available.

HTH

Dominic

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

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

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