Re: CF7 Enterprise Manager timeouts

2006-01-13 Thread Cliff Meyers
>You need to switch the timeout off to be guaranteed of it definately
>completing. Obviously on a more powerful machine you won't get this
>issue.

Thanks, that did the trick!  I'd set the timeout to 900 seconds initially and 
it seemed to timeout well before that which is a little strange.  I unchecked 
the box and tried to add the instance again and it completed in about 7 mins 
(420 seconds).  A little strange that it didn't work the first time but no 
biggie.

>Being that you're not supposed to use the default "cfusion" instance
>in production this "shouldn't" cause you any problems :)

This is just a laptop for presentations and only has 256 MB of RAM.  The only 
sense of "production" it has is not crashing on me during my preso next week.  
LOL.  Thanks for the help!


-Cliff

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229524
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


CF7 Enterprise Manager timeouts

2006-01-13 Thread Cliff Meyers
I have CF 7.01 in JRun multiserver mode running on an older laptop that we use 
for presentations.  I'm trying to create a new CF instance using the Enterprise 
Manager in the CF admin.  It runs for a while and then errors out somewhere 
during step 3 out of 4 (Deploying).  This is the error message I receive:

""
The request has exceeded the allowable time limit Tag: cfoutput
""

Is there any way to increase the timeout for this operation so that it can 
complete successfully?  I increased the request timeout on the settings page to 
900 seconds but this particular page doesn't seem to respond to that threshold 
anyhow... I'm assuming it might have the request timeout manually set in the CF 
code running it.

Thanks so much for any help/suggestions.


-Cliff

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229506
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


Re: Client side encryption (like CF7 Admin) in CF6.1

2005-05-17 Thread Cliff Meyers
This definitely looks like it should work... thank you :)

-Cliff


On 5/16/05, Figy, Kam <[EMAIL PROTECTED]> wrote:
> http://pajhome.org.uk/crypt/md5/instructions.html
> 
> CF6.1 Hash() is MD5. There is a CF implementation of SHA-1 available off
> cflib.org if you want to use that instead.
> 
> I've got a framework that handles this kind of thing but it isn't public
> (yet - we're releasing it sometime soon).
> 
> /kam
> 
> -Original Message-
> From: Cliff Meyers [mailto:[EMAIL PROTECTED]
> Sent: Monday, May 16, 2005 10:15 AM
> To: CF-Talk
> Subject: Client side encryption (like CF7 Admin) in CF6.1
> 
> I noticed that on the admin login page for CF7 that there is some
> nifty client-side Javascript that encrypts your string using the SHA-1
> algorithm.  Presumably after the form posts to the server CF is using
> one of the new encryption algorithms available in 7.0 to decrypt the
> information and check against the admin password.  Is anyone aware of
> a Javascript library that would work with the encryption used in 6.1?
> I want to do something similar for one of my applications but our CF7
> upgrade is probably 3-6 months out.
> 
> Thanks,
> 
> -Cliff
> 
> 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206930
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


Client side encryption (like CF7 Admin) in CF6.1

2005-05-16 Thread Cliff Meyers
I noticed that on the admin login page for CF7 that there is some
nifty client-side Javascript that encrypts your string using the SHA-1
algorithm.  Presumably after the form posts to the server CF is using
one of the new encryption algorithms available in 7.0 to decrypt the
information and check against the admin password.  Is anyone aware of
a Javascript library that would work with the encryption used in 6.1? 
I want to do something similar for one of my applications but our CF7
upgrade is probably 3-6 months out.

Thanks,

-Cliff

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206778
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


Re: flash forms don't show

2005-05-07 Thread Cliff Meyers
I don't believe that ColdFusion actually writes any of those files to
the filesystem.  Rather, I think the embedded Flex engine that
generates these SWFs are routed through a Servlet that grabs the
request based on the file type requested and "streams" the SWF
directly to the browser.

Can you post the full HTTP headers from each response to the
ColdFusion template you're calling?  What I want to see is what URLs
the browser is requesting based on the URL that you're actually
invoking from the browser itself.


-Cliff



On 5/7/05, Alexander Appleton IV <[EMAIL PROTECTED]> wrote:
> so far.. that hasn't worked.. the http requests are dif.. one returns
> a 410 (the bad one..)
> 
> BAD:
> 
> http://localhost/projects/horatio/1034593532.mxml.cfswf
> GET /projects/horatio/1034593532.mxml.cfswf HTTP/1.0
> HTTP/1.x 410 Unknown
> Server: Microsoft-IIS/5.1
> 
> GOOD:
> 
> http://localhost/projects/horatio/includes/941399296.mxml.cfswf
> GET /projects/horatio/includes/941399296.mxml.cfswf HTTP/1.0
> HTTP/1.x 200 OK
> Server: Microsoft-IIS/5.1
> 
> I do have the debugging for flash on.. but do not really see anything
> relating to it in the debugging output...
> On 5/7/05, C. Hatton Humphrey <[EMAIL PROTECTED]> wrote:
> > > that sounds like it might work. I shall give it a go. I'll let you know, 
> > > thanks
> >
> > If that does not work then you might want to enable Flash Form
> > debugging to see if there is an error being generated.
> >
> > It's in the debugging settings of the Administrator.
> >
> >
> 
> 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205995
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


Re: High Load Server... how much more can it take?

2005-05-07 Thread Cliff Meyers
> Store your meaningless stuff in cookies.  Only use them in cases where
> you will never need to set the cookie and read back from it within the
> same template.  Never use them if you set them and cflocation to
> something else that needs to use the cookie value (both of these
> limitations can be overcome but why bother since...

"The documentation incorrectly states that setting cookie on the same
page you use cflocation would result in the cookie not being set. The
cookie will be set correctly.
Stephen M. Gilson
Macromedia"
http://livedocs.macromedia.com/coldfusion/6/CFML_Reference/Tags-pt166.htm

As of MX, the CFCOOKIE/CFLOCATION issue isn't a concern anymore, right?

> The above assumes you don't have situations where a race condition can
> arise.  This should be a rare thing in the session scope, but if its
> there you *will* have to lock the writes (only) to the session scope.

(Slightly OT) This is something I've wondered about for a while.  It's
obvious why you need to CFLOCK writes to the application scope since
there are likely to be many users accessing application scope
variables all over the place.  I've heard that locking session
variables is important if you use frames or if a user were to
repeatedly hit the refresh button on a page where session variables
are written to unlocked.  My question is, does CFLOCK scope=session
type=exclusive impact performance significantly?  Or for that matter,
would a type=readonly impact it as well?  I don't know enough about
CFLOCK and whether it's locking just that users' spot of shared memory
or the entire area of shared memory where session vars are stored.  If
it's the former I'd guess the performance impact is negligible, and in
the case of the latter I'd guess it's significant.  I've gotten in the
habit of locking session variables EVERYWHERE because of the serious
concerns pre-MX, but if this is having a negative impact on
performance I'm not aware of I'd appreciate it if someone would let me
know - thanks :)


-Cliff

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205970
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


Re: flash forms don't show

2005-05-07 Thread Cliff Meyers
Are the HTTP request headers generated identical when you call it the
normal vs. SES way?  You might be able to use the HTML BASE tag to
help you out here.  If I recall correctly, when I tried to implement
SES URLs with Fusebox it was a requirement to use the BASE tag in
order for the URLs to function 100% correctly.


-Cliff



On 5/6/05, Phillip P Rutherford II <[EMAIL PROTECTED]> wrote:
> i already posted the url for the flash file that is requested..
> 
> horatio/930449900.mxml.cfswf
> 
> but when the page is /index.cfm/p=client rather than
> /includes/client.cfm
> 
> it's just not loading the swf right.. or at all...
> 
> [06/May/2005:16:39:41 -0400] "GET /favicon.ico HTTP/1.0" 404 305
> [06/May/2005:16:39:42 -0400] "GET /horatio/index.cfm/p=client/
> HTTP/1.0" 200 1776
> [06/May/2005:16:39:43 -0400] "GET /CFIDE/scripts/masks.js HTTP/1.0" 200 9032
> [06/May/2005:16:39:43 -0400] "GET /CFIDE/scripts/cfformhistory.js
> HTTP/1.0" 200 1372
> [06/May/2005:16:39:43 -0400] "GET /CFIDE/scripts/cfformhistory.cfm
> HTTP/1.0" 200 1243
> [06/May/2005:16:39:43 -0400] "GET /horatio/930449900.mxml.cfswf HTTP/1.0" 410 
> 90
> [06/May/2005:16:39:44 -0400] "GET /favicon.ico HTTP/1.0" 404 305
> [06/May/2005:16:39:44 -0400] "GET /CFIDE/scripts/cfformhistory.swf
> HTTP/1.0" 200 2656
> 
> not using any mod_rewrite.. 
> 
> On 5/6/05, Cliff Meyers <[EMAIL PROTECTED]> wrote:
> > Maybe you can check your web server logs (or HTML source) to see what
> > URL is actually being requested by the browser when it tries to pull
> > in the Flash form?  If that provides meaningful info, you could
> > probably use a similar SES technique to make sure that the browser can
> > correctly find the file... are you using mod_rewrite?
> >
> > -Cliff
> >
> >
> > On 5/6/05, Phillip P Rutherford II <[EMAIL PROTECTED]> wrote:
> > > interesting... I just noticed, if I call my page directly... (it's an
> > > include..) it works fine.. but because I am using a form of SES it
> > > seems to kill it.. so this works fine
> > >
> > > /horatio/includes/client.cfm (flash form works..)
> > > /horatio/index.cfm/p=client (this does not...)
> > >
> > > any ideas on how to get around this?
> > >
> > > On 5/6/05, Phillip P Rutherford II <[EMAIL PROTECTED]> wrote:
> > > > for some reason my flash forms are /not/ showing up pages. If i change
> > > > format="xml" the forms work fine.. but if format="flash". I get an
> > > > output of all the code... but nothing is there.. src for the swf
> > > > shows:
> > > >
> > > > /horatio/930449900.mxml.cfswf
> > > >
> > > > so... if I look in that directory (on the server...) should i see a
> > > > file in there?
> > > >
> > > > i get nothing.
> > > > --
> > > > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-[ Triangle Area ColdFusion User Group ]-=
> > > > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-[ http://tacfug.org ]-=
> > > >
> > >
> > > --
> > > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-[ Triangle Area ColdFusion User Group ]-=
> > > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-[ http://tacfug.org ]-=
> > >
> > >
> >
> >
> 
> 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205944
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


Re: High Load Server... how much more can it take?

2005-05-06 Thread Cliff Meyers
> 1. Does 12,000,000 .cfm pages / month (distributed normally over the day, 
> peaking around 4 PM ET) seem like a lot for a single xeon 2.0?

Not sure on this.  Until you start coming close to maxing out the CPU
or memory, I'd say you should stick with your current hardware.

> 2. I'm not so sure that we're using RAM effectively, even with mysql set to 
> use lots of memory and cf set to cache lots of queries and pages.

Are you setting the MySQL memory usage in the my.cnf file?  How many
queries and pages is CF currently set to cache?

> 3.  Could the use of database client variables be causing peak hour 
> sluggishness?  I've always wondered what sort of performance hit using 
> database client variables has under load.  Would I get a noticable 
> improvement switching to cookie client variables?

This one raises a red flag to me.  If I'm not mistaken, the client
variables get updated (at a minimum) once per page view, since there
is a "last visited" variable that would presumably get set each time. 
And then of course the client variables need to be read into memory
each time as well.  I'd say this might be a quick and easy fix that
you could make right off the bat to see if it helps out.

Ultimately, we should try to find a way to get your mean CPU and
memory usage higher if possible.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205941
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


Re: Scheduled Task Listing

2005-05-06 Thread Cliff Meyers
I've found some languages that actually don't have a notion of Left()
or Right() so I find myself in more of a Mi() mindset so I don't get
disappointed.


-Cliff



On 5/6/05, Burns, John D <[EMAIL PROTECTED]> wrote:
> I've always been curious why people do mid(variable, 1,4)...Why not do
> Left(variable, 4) ? Is there some benefit found to doing it that way or
> is it lack of experience or is it just preference?
> 
> John Burns
> Certified Advanced ColdFusion MX Developer
> Wyle Laboratories, Inc. | Web Developer
>

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205900
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


Re: flash forms don't show

2005-05-06 Thread Cliff Meyers
Maybe you can check your web server logs (or HTML source) to see what
URL is actually being requested by the browser when it tries to pull
in the Flash form?  If that provides meaningful info, you could
probably use a similar SES technique to make sure that the browser can
correctly find the file... are you using mod_rewrite?


-Cliff



On 5/6/05, Phillip P Rutherford II <[EMAIL PROTECTED]> wrote:
> interesting... I just noticed, if I call my page directly... (it's an
> include..) it works fine.. but because I am using a form of SES it
> seems to kill it.. so this works fine
> 
> /horatio/includes/client.cfm (flash form works..)
> /horatio/index.cfm/p=client (this does not...)
> 
> any ideas on how to get around this?
> 
> On 5/6/05, Phillip P Rutherford II <[EMAIL PROTECTED]> wrote:
> > for some reason my flash forms are /not/ showing up pages. If i change
> > format="xml" the forms work fine.. but if format="flash". I get an
> > output of all the code... but nothing is there.. src for the swf
> > shows:
> >
> > /horatio/930449900.mxml.cfswf
> >
> > so... if I look in that directory (on the server...) should i see a
> > file in there?
> >
> > i get nothing.
> > --
> > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-[ Triangle Area ColdFusion User Group ]-=
> > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-[ http://tacfug.org ]-=
> >
> 
> --
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-[ Triangle Area ColdFusion User Group ]-=
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-[ http://tacfug.org ]-=
> 
> 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205899
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


Re: CFC from within another

2005-05-06 Thread Cliff Meyers
The error message you pasted above is a CFML parser error.  It sounds
like you're missing a closing CFFUNCTION tag in one of your
components.  I'd double-check your .cfc files... you probably just
forgot to close a tag somewhere. :)


-Cliff 



On 5/6/05, Chris Alvarado <[EMAIL PROTECTED]> wrote:
> Im getting an error that says
> 
> Context validation error for tag cffunction.
> The start tag must have a matching end tag. An explicit end tag can be 
> provided by adding . If the body of the tag is empty you can use 
> the shortcut .
> 
> I have a CFC and within that CFC I make a call to another, is this not 
> permitted?
> 
> The call is very simple . . .
> 
> 
> 
> 
> Thanks!
> 
> -chris.alvarado
> [ application developer]
> 4 Guys Interactive, Inc
> 
> --
> No virus found in this outgoing message.
> Checked by AVG Anti-Virus.
> Version: 7.0.308 / Virus Database: 266.11.5 - Release Date: 5/4/2005
> 
> 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205870
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


Re: ColdFusion v4.5.2 using cfmail to send authentication SMTP

2005-05-06 Thread Cliff Meyers
Username/password authentication for CFMAIL was introduced in CFMX
6.1.  Unfortunately it is not available in previous versions.  I know
that some people had written Java or C++ custom tags meant to serve as
a replacement for CFMAIL, but they might be hard to come by now that
CFMAIL is so much improved.


-Cliff



On 5/6/05, Eric Dawson <[EMAIL PROTECTED]> wrote:
> I have a coldfusion v4.5.2 server, and it doesn't seem like cfmail supports
> username/password authenticated SMTP.
> 
> Has anyone else encountered this?
> 
> Eric
> 
> 

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205833
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


Re: CFFILE destination error

2005-05-05 Thread Cliff Meyers
What about adding it as a mapped network drive to the server and
accessing it via e:\ or something similar?


On 5/5/05, Jared Rypka-Hauer - CMG, LLC <[EMAIL PROTECTED]> wrote:
> I can UNC directly from the Run... command to the text file in question, but
> CFFILE can't find it. The only thing I can think of to test this is using a
> privileged account (like a Domain Admin) that might give you higher privs to
> access remote files... but that's Really Not a Good Idea.
> 
> Sorry dude...
> 
> J
> 
> On 5/5/05, Daniel Kang <[EMAIL PROTECTED]> wrote:
> >
> > \\swintranet1\d$\Inetpub\wwwroot\RefPosting is the right destination,
> > but I am getting this error.
> >
> > What am I missing?
> >
> > The destination "\\swintranet1\d$\Inetpub\wwwroot\RefPosting"
> > specified in the CFFILE tag is invalid.
> >
> > The destination either does not exist or is not accessible by this tag.
> >
> > The error occurred in D:\Inetpub\WWWROOT\RefPosting\InsertData.cfm: line
> > 17
> >
> > 15 : Destination =
> > "\\swintranet1\d$\Inetpub\wwwroot\RefPosting"
> > 16 : action = "upload"
> > 17 : nameconflict ="overwrite"
> > 18 : filefield = "fileName">
> >
> > tia
> >
> 
> --
> ---
> -
> Buy SQLSurveyor!
> http://www.web-relevant.com/sqlsurveyor
> Never make your developers open Enterprise Manager again.
> 
> 

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205816
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


Re: Scheduled Task Listing

2005-05-05 Thread Cliff Meyers
Michael,


Since you're on a shared server, the CF server is going to treat your
scheduled task just like anyone else's.  If you use a consistent
naming convention for your tasks you could do some filtering after the
fact.  It's not bullet proof but maybe it'd work for you. Ex:

If you have scheduled tasks in the CF Admin named like so...

mike - task 1
mike - task 2
mike - task 3

Then just modify your code like this


  

#allTasks[i].task#

  



HTH,

Cliff



On 5/5/05, WebStop Internet Services <[EMAIL PROTECTED]> wrote:
> Is there a way to show the scheduled task for a particularly named task?
> 
> Say, I name all my tasks "Scheduled Task (variable number)"
> 
> How would I display all of the tasks with the name that started with
> the words "Scheduled Task"?
> 
> I have this so far, but I am on a shared server and other people's tasks are
> showing up and I only want to display the ones for the application I created
> that names them "Scheduled Task 1, Scheduled Task 2" etc...
> 
> Here is what I use to display currently scheduled tasks:
> 
> 
> 
> How do I discriminate between mine and everyone else's on the server?
> 
> Michael Pool
> Lowcountry Computers
> http://www.LowcountryComputers.com
> 
> 

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205805
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


Re: import from MySQL to MS SQL

2005-05-05 Thread Cliff Meyers
No problem :)  I used MySQL with CF as I was getting started in app
development but outgrew its feature set after a while.  One thing I
will say about PgSQL is that its syntax is much more Oracle-like
(read: ANSI compliant) than MySQL.  All that aside, no matter what
database you're using, at least we're all using the best app server,
right? ;)


-Cliff



On 5/5/05, Bryan Stevenson <[EMAIL PROTECTED]> wrote:
> Hey Cliff,
> 
> Thanks for the heads upwhile I may not prefer the "free" stuffI do
> try and keep up with product advancement (like MySQL 5 is strarting to get
> there)they'll be a time where I'm sure I'll be a MySQL advocate...but
> not yet ;-)
> 
> Cheers
> 
> Bryan Stevenson B.Comm.
> VP & Director of E-Commerce Development
> Electric Edge Systems Group Inc.
> phone: 250.480.0642
> fax: 250.480.1264
> cell: 250.920.8830
> e-mail: [EMAIL PROTECTED]
> web: www.electricedgesystems.com
> 
> 

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205759
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


Re: import from MySQL to MS SQL

2005-05-05 Thread Cliff Meyers
On 5/5/05, Bryan Stevenson <[EMAIL PROTECTED]> wrote:
>
> I'm just not a free kind of guyin my experience free means "free until
> you have to support it...then it costs more to fix issues than the tool ya
> would have paid for.
> 

There is commercial support available for PostgreSQL:

http://www.postgresql.org/support/professional_support

I'm not sure how it measures up against Oracle licensing, but if you
need piece of mind or an SLA my guess is that they'll be very willing
to work with you.  A lot of other corporate vendors won't give you the
time of day unless you're dropping major coin on their software and/or
special support contracts.


-Cliff Meyers

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205754
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


OT: Connecting Flex with Databases

2005-04-29 Thread Cliff Meyers
Matt,


There are three ways to connect to "data" in Flex:

1. HTTPService
2. WebService
3. RemoteObject (Java only)

An HTTPService call is as simple as specifying a URL that returns XML
data.  This could be any kind of page... a CFM, JSP, ASP... even a flat
XML file.

WebService can use any SOAP or REST web service.  These can be implemented
in any language that supports web services... Java, .NET... and of course
oru wonderful CFCs. :)

RemoteObject is used to directly call a compiled Java class that sits on
the same server as Flex.  It's very powerful because you're not using web
services as at, it's actually a binary protocol called AMF and it's
supposedly a good deal faster than web service calls as well.  However it
natuarlly imposes a lot of limitations and it's basically worthless if all
you do is write ColdFusion.

Whichever of the 3 methods above you choose, they have to connect to your
DB, pull out the data and return XML to the Flash Player client. 
WebService and RemoteObject essentially handle this for you, but if you
aren't comfortable working with them then you *could* set up CFM pages
that would spit out XML... but the power there is a lot more limited.

If you're interested in Flex, check out the Flex book by MM press and
"Essential Actionscript 2.0" by Moock.  They're both solid.  Also
tomlink.net has some good resources for some of the nuances you'll run
into when working with Flex.  And if you can afford the training from
MM... go for it.  I just finished the 3 course last week and learned A
LOT!  Also there is a useful mailing list called "Flexcoders" over at
Yahoo Groups.

Good luck :)


-Cliff



Subject: OT: Connecting Flex with Databases
From: Mark Drew <[EMAIL PROTECTED]>
Date: Fri, 29 Apr 2005 08:29:39 +0100
Thread:
http://www.houseoffusion.com/cf_lists/index.cfm/method=messages&threadid=39940&forumid=4#205044

Sorry for the off-topic

I have been playing with flex, and one thing that is missing from my
brain is how I can connect it to a database. I presume most of the
data connection stuff is done via XML and JSP? is this correct? We
cant use our CFC's?

Are there any examples out there? I have been working through the
tutorials but the JSP files just output XML .. and I needed to know
how to actually connect to a DB

Any pointers apreciated!

Again.. sorry for OT!!

-- 
Mark Drew

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205066
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


adminapi and j2ee packaging

2005-03-29 Thread Cliff Meyers
Steve,


I suppose now that I've thought about it more it does make sense: using 
Ant to build the .war files from .cfm template collections should work 
fine provided that you give Ant the correct classpaths it needs to find 
all the Java libraries that implement the CF runtime.

Although it violates my sense of a truly "clean" deployment where each 
..war takes exactly what it needs, I'm not too worried that there are 
extra datasources and such in the .war file.  We'll likely be doing 
sourceless deployment anyways which means that if anyone were to try and 
edit code on our test, QA, stage or production servers that they'd have 
a heck of a time :)

In the end I think I'll be very happy to use Ant.  We are a pretty large 
shop with many, many Java developers that have expertise in these sorts 
of things.  We're in the process of shifting all our developers over to 
a local CF developer edition and then using Subversion for version 
control (finally).  The new features available in CF7 gave me an 
opportunity to find a more regimented technique for building out of SVN. 
  Thanks for all your help!


-Cliff





~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:200391
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


Re: adminapi and j2ee packaging

2005-03-28 Thread Cliff Meyers
Does Ant have the "awareness" to take a directory full of .cfm's and bundle it 
into a .war file?  What about things like datasources, custom tag paths, mail 
server settings, etc etc?  I'll admit I don't know a lot about the Ant tool, 
but it just doesn't seem intuitive to me that it would be able to do that on 
its own.  I know that the entire CF app server is a J2EE app, but the process 
that MM uses to build that tool must have some intelligence as to the Java 
libaries that CF uses to do its thing, etc.  If someone from MM can yell at me 
and tell me I'm wrong, I'd be thrilled!


>Cliff, I'm interested why you want to use CFCs to automate this process when
>there are already other powerful tools that will do this for you.  Foremost
>is Ant which can be completely automated, even via ColdFusion.  In fact,
>writing a CFC to build WARs would be a neat tool (gears turning here).  It
>could provide a nice UI to the Ant build structure... Etc, etc.  Just writing
>down ideas at this point.
>
>Anyway, the reason I ask is that I've found the build tool in the admin to
>not be flexible at all and even doesn't work under certain circumstances.

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:200369
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


adminapi and j2ee packaging

2005-03-28 Thread Cliff Meyers
(I posted this on the MM forums too... very curious if anyone has an answer)

I want to access the  Packaging & Deployment area of the CF Administrator
programatically so that we can automate the building of CFapps into .war
files. I noticed that this isn't available via any of the CFCs listed in
the adminapi documentation. Are there plans to add a CFC with this
functionality? Is there a way I can do it with CFHTTP?  The latter
approach sounds messy; having a CFC would be great. Thanks!


-Cliff Meyers

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:200199
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


CFCHART throws -1 error

2005-03-25 Thread Cliff Meyers
I'm using CFMX 6.1 on Solaris 9.  Occassionally a page I have that uses
CFCHART will throw an error message that says "-1" and doesn't provide any
more details.  It seems to only happen on JPG pie charts, and only when
the number of wedges in the chart exceeds roughly 15.  However it's
consistent, because right now I'm looking at a chart that has 22 wedges. 
Here are some of the error details:


"Error","jrpp-693","03/25/05","12:23:16","xgs_im_reporting","-1 The
specific sequence of files included or processed is:
/tendo/websites/xgs_im_reporting/htdocs/whitepaperReportWebByJobTitle.cfm
"
java.lang.ArrayIndexOutOfBoundsException: -1
at com.gp.image.image.BImage.fillAnyPolygon(BImage.java)
at com.gp.image.image.BImage.fillPolygon(BImage.java)
at com.gp.image.image.BGraphics.fillPolygon(BGraphics.java)
at java.awt.Graphics.fillPolygon(Graphics.java:751)
at com.gp.webcharts3D.chart.pie.ExPieArc.fill(ExPieArc.java)
at com.gp.webcharts3D.chart.pie.ExPieSlice.fillArc(ExPieSlice.java)
at com.gp.webcharts3D.chart.pie.ExPieSlice.draw3D(ExPieSlice.java)
at
com.gp.webcharts3D.chart.pie.ExPieModel.drawSlices(ExPieModel.java)
at com.gp.webcharts3D.chart.pie.ExPieModel.draw(ExPieModel.java)
at com.gp.webcharts3D.chart.ExPieChart.draw(ExPieChart.java)
at com.gp.webcharts3D.chart.ExDiagramChart.paint(ExDiagramChart.java)
at com.gp.image.plugins.ImChartBuilder.build(ImChartBuilder.java)
at com.gp.image.plugins.ImImageBuilder.saveAs(ImImageBuilder.java)
at com.gp.image.server.IcImageServer.saveAs(IcImageServer.java)
at com.gp.image.server.cache.IcFileImage.(IcFileImage.java)
at com.gp.image.server.IcImageServer.__newImage(IcImageServer.java)
at com.gp.image.server.IcImageServer._newImage(IcImageServer.java)
at com.gp.image.server.IcImageServer.newImage(IcImageServer.java)
at com.gp.image.server.IcImageCache.getImage(IcImageCache.java)
at com.gp.image.server.IcImageServer.getImage(IcImageServer.java)
at com.gp.image.ExServerComponent.getImageTag(ExServerComponent.java)
at
coldfusion.graph.GraphingServiceImpl$2.run(GraphingServiceImpl.java:319)
at java.security.AccessController.doPrivileged(Native Method)
at
coldfusion.graph.GraphingServiceImpl.generateGraph(GraphingServiceImpl.java:314)
at coldfusion.tagext.io.ChartTag.doEndTag(ChartTag.java:428)
at
cfwhitepaperReportWebByJobTitle2ecfm2084405069._factor1(/tendo/websites/xgs_im_reporting/htdocs/whitepaperReportWebByJobTitle.cfm:154)
at
cfwhitepaperReportWebByJobTitle2ecfm2084405069._factor3(/tendo/websites/xgs_im_reporting/htdocs/whitepaperReportWebByJobTitle.cfm:151)
at
cfwhitepaperReportWebByJobTitle2ecfm2084405069._factor4(/tendo/websites/xgs_im_reporting/htdocs/whitepaperReportWebByJobTitle.cfm:150)
at
cfwhitepaperReportWebByJobTitle2ecfm2084405069._factor5(/tendo/websites/xgs_im_reporting/htdocs/whitepaperReportWebByJobTitle.cfm:119)
at
cfwhitepaperReportWebByJobTitle2ecfm2084405069.runPage(/tendo/websites/xgs_im_reporting/htdocs/whitepaperReportWebByJobTitle.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(Unknown Source)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:62)
at
coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:107)
at
coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:80)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:47)
at
coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:52)
at
coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:35)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:43)
at
coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.CfmServlet.service(CfmServlet.java:105)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at
jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:252)
at
jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527)
at
jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:192)
at
jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:348)
at
jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451)
at
jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:294)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)


If anyone can provide insight I'd really appreciate it. 

cftransaction behavior

2005-03-22 Thread Cliff Meyers
I've noticed some behavior from CFTRANSACTION that I wouldn't quite 
expect.  Here is some pseudo code:


"""
CFSET transactionSuccess=false

CFTRANSACTION action=BEGIN

CFTRY

many CFQUERY tags

CFSET transactionSuccess=true

CFCATCH

CFTRANSACTION action=ROLLBACK

/CFCATCH

/CFTRY


CFIF transactionSuccess

CFTRANSACTION action=COMMIT

/CFIF

/CFTRANSACTION
"""


If I comment out the "CFTRANSACTION action=COMMIT" tag and the query 
completes without errors, the data is still written to the database. 
Shouldn't I have to explicitly use COMMIT in order for the data to be 
saved?  At first glance it seems that the only time I'd want to ROLLBACK 
is in the event of an error, but if this is the expected behavior I'm 
not sure why I'd ever need to use CFTRANSACTION action=COMMIT.  Anyone 
have any ideas?

I'm using CFMX 6.1 on Solaris 9 with Oracle 9i Release 2.


-Cliff


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199669
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


Re: CFCs and webroots

2005-03-16 Thread Cliff Meyers
>Since aliases can't exist outside a server config of some sort, an
>alias (apache) or a virtual directory (IIS) will look in the webroot
>of the site to which it is attached.

Thanks for responding!  So just to make sure I'm clear on what you mean, going 
back to my prior example...

(vhost) http://www.test.com -> /sites/site1
(alias) http://www.test.com/othersite -> /sites/site2

If I make a call like:

createObject("component","SomeFramework.SomeComponent")

from within the context of "/othersite" it means that ColdFusion will be "smart 
enough" to look here for my CFC?

/sites/site1/SomeFramework/SomeComponent.cfc

I can drop MachII in my custom tags folder and (as you'd expect) CF can always 
find it, but if I want to write two separate apps and have them share CFCs 
between the two  it'd be convenient to if CF did have the functionality I 
described...

Thanks again!


-Cliff

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199074
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


CFCs and webroots

2005-03-16 Thread Cliff Meyers
I was reading the documentation for "Specifying the CFC location" (
http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/buildi45.htm) and
wanted to pose a question.  If I'm accessing a web site via an "alias"
(that's the Apache terminology) such as this:

http://www.test.com -> /sites/site1/
http://www.test.com/otherdir -> /sites/site2/

What happens when ColdFusion searches "the web root" of my site?  Does it
just calculate how many levels deep the URL looks to be from the web root,
go up that number of directories, and then look for the CFC name or
package path that I've specified?


-Cliff


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199031
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


cfchart and cfchartdata question. Kindly help!

2005-03-14 Thread Cliff Meyers
Try this:

select
  count(*),
  jobPriority
from
  call
where
  logdatetime >= @x + '00:00:00'
and
  logdatetime <= @x + '23:59:59'
group by
  jobPriority


-Cliff



Subject: cfchart and cfchartdata question. Kindly help!
From: cf coder <[EMAIL PROTECTED]>
Date: Mon, 14 Mar 2005 09:26:39 -0400
Thread:
http://www.houseoffusion.com/cf_lists/index.cfm/method=messages&threadid=38961&forumid=4#198644

thanks Cliff for the reply. That did occur to me and its probably the only
way to do
it. However, I don't know how to build the select sql query. From what I
understand
when using the count() function, I can't any other column name in the select.

select count(*), jobPriority from call
where logdatetime >= @x + '00:00:00' and logdatetime <= @x + '23:59:59'

How do I get the query to return the count of jobs logged in a day and for
each job
return the jobPriority. Is there a way to do this?

Regards,
cfcoder

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:198706
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


cfchart and cfchartdata question. Kindly help!

2005-03-14 Thread Cliff Meyers
You should be able to accomplish what you're looking for just by adding 3
data series to the chart you're building.  The most straightforward way to
do it would probably be to modify your stored procedure to take another
input parameter called "status" so you could view the results for a
particular status type.  Then drop all 3 sets of results into the chart as
their own series.  The attribute for CFCHART you'll want to play around
with is "seriesPlacement" which can have values of "default, cluster,
stacked, percent."  That will control how the different data points get
displayed.

Good luck!


-Cliff

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:198640
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


Apache + CFMX7 + J2EE

2005-03-04 Thread Cliff Meyers
When deploying ColdFusion apps to a J2EE server as a .war file is there 
a way to adjust the JRun connector for Apache to also forward requests 
for images, stylesheets, etc?  I just installed CFMX7 in the JRun 
multiserver config but when I access it via Apache all the images are 
broken since mod_jrun20 doesn't know to forward those kinds of requests 
to JRun.  I tried modifying the "AddHandler" and "JRunConfig 
Ignoresuffixmap" directives but didn't have any luck.  Can anyone offer 
advice?


-Cliff


~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197565
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


title for CFCHART?

2005-02-24 Thread Cliff Meyers
Does anyone know if there is a workaround for tnot being able to put a
title inside charts generated by CFCHART?  In many cases my users are
downloading the chart to slap into a Powerpoint or Excel file but without
a title it can be confusing to remember exactly what the chart is
representing.  Apart from manipulating the image with the Java 2D Graphic
API I can't think of anything else, but thought maybe you all might have
some ideas.  I'm running CFMX 6.1 at the moment.  Anyone know if this
feature is added in v7?


-Cliff

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196404
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


one more time: Struts and ColdFusion

2005-01-31 Thread Cliff Meyers
Figured I'd give this one another try in case someone with an answer 
missed it...

note: I posted this on CF-Talk first but then decided this might be a
better stop to ask.  Apologies for the duplication...

I found this article the other day and decided to give it a go:

Streamlining Application Development Using Struts in ColdFusion MX
http://www.macromedia.com/devnet/mx/coldfusion/articles/struts.html

I downloaded the developer edition of CFMX 6.1 and installed it inside of
JRun 4 (as an EAR).

I downloaded the code from the article and put the following things in
these places:

cfDemo.jar
servlet.jar
struts.jar
xalan.jar
xerces.jar
struts-*.tld (6 files)

inside of C:\JRun4\servers\cfusion\cfusion-ear\cfusion-war\WEB-INF\lib

struts-config.xml
added struts lines to web.xml

inside of
C:\JRun4\servers\cfusion\cfusion-ear\cfusion-war\WEB-INF

login.cfm
welcome.cfm

inside of
C:\JRun4\servers\cfusion\cfusion-ear\cfusion-war\cfm

The cfusion server starts and stops fine, but when a make a request like:

http://localhost:8300/do/welcome

the server just completely hangs. I'd really like to see this in action,
any help would be greatly appreciated. Thanks!!


-Cliff


~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192458
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


cfeclipse

2005-01-31 Thread Cliff Meyers
Guys,


Another option is to find a tool that can map a remote site (via FTP, 
SFTP, WebDAV, etc) to a mapped drive on Windows.  I found one called 
WebDrive which does the job nicely.  Unfortunately it costs $40 but if 
you have a little cash to drop it's a nifty tool:

http://www.webdrive.com

I just create a CFML or Simple Project with Eclipse, and then when it 
asks me where to save the files, I just browse to the network drive.  If 
you're on Linux or another OS where open source protocol tools are more 
readily available you probably wouldn't even need WebDrive.


-Cliff


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192454
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


Struts and ColdFusion

2005-01-28 Thread Cliff Meyers
I found this article the other day and decided to give it a go:

Streamlining Application Development Using Struts in ColdFusion MX
http://www.macromedia.com/devnet/mx/coldfusion/articles/struts.html

I downloaded the developer edition of CFMX 6.1 and installed it inside of
JRun 4 (as an EAR).

I downloaded the code from the article and put the following things in
these places:

cfDemo.jar
servlet.jar
struts.jar
xalan.jar
xerces.jar
struts-*.tld (6 files)

inside of C:\JRun4\servers\cfusion\cfusion-ear\cfusion-war\WEB-INF\lib

struts-config.xml
added struts lines to web.xml

inside of
C:\JRun4\servers\cfusion\cfusion-ear\cfusion-war\WEB-INF

login.cfm
welcome.cfm

inside of
C:\JRun4\servers\cfusion\cfusion-ear\cfusion-war\cfm

The cfusion server starts and stops fine, but when a make a request like:

http://localhost:8300/do/welcome

the server just completely hangs. I'd really like to see this in action,
any help would be greatly appreciated. Thanks!!

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192105
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


REPOST: CFHEADER/CFCONTENT over SSL on IIS with IE

2004-12-13 Thread Cliff Meyers
Subject: REPOST: CFHEADER/CFCONTENT over SSL on IIS with IE
From: Dave Watts <[EMAIL PROTECTED]>
Date: Sun, 12 Dec 2004 19:48:18 -0500
Thread:
http://www.houseoffusion.com/cf_lists/index.cfm/method=messages&threadid=37080&forumid=4#187302

> Perhaps there's a problem with the Content-Disposition header. You might
> want to try "inline" instead of "attachment".

Dave,


Thanks for the recommendation.  Unfortunately I've tried that and it
doesn't work either.  I tried varying the type in CFCONTENT as well and
continued to get the same result over and over.  It's maddening... this
behavior only slows up when you mix Windows IE, SSL and IIS.  For cripe's
sake, it works on the *Mac* flawlessly!

Can anyone recommend a good tool (either standalone or plugin for IE) that
will allow me to see the HTTP response headers for a particular request? 
That way I could at least compare the headers generated for a "regular"
file download and then tweak my CFHEADER statement(s) to match.  Thanks a
bunch.


-Cliff

~|
Special thanks to the CF Community Suite Silver Sponsor - New Atlanta
http://www.newatlanta.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187342
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


REPOST: CFHEADER/CFCONTENT over SSL on IIS with IE

2004-12-12 Thread Cliff Meyers
Hey guys,


I posted this on Friday, didn't get a response.  Figured I'd try it again.


I have a simple text file that I want to force-download for users of a web
application.  I've set up the following code:





When I run the code in IE, I get the "File Download" dialog box as you'd
expect.  When I either try to open or save the file, I get this error
message:

"Internet Explorer cannot download act_download_key.cfm from www.anyhost.com.

Internet Explorer was not able to open this internet site... blah blah"

This site is being served over HTTPS.  When I adjust the IIS configuration
to allow requests over HTTP, the code magically works without issues.
Furthermore Firefox can open/save the file without problems over either
HTTP or HTTPS.  I'm assuming this is some idiosyncrasy with IE when using
CFCONTENT/CFHEADER over an SSL site.  Thanks for your help.


-Cliff Meyers

~|
Special thanks to the CF Community Suite Silver Sponsor - CFDynamics
http://www.cfdynamics.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187295
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


Re: SQL Query

2004-12-10 Thread Cliff Meyers
On Fri, December 10, 2004 2:44 pm, Jason Smith said:
> This code works fine with a access database, since converting the entire
> cf
> application to a live SQL database it has been the beginning of a
> nightmare. I'm not real familiar with access but it seems they have some
> really strange ways to check dates and whatnot.

I've found that SQL Server 2000 handles dates in this format:

'm/d/'

It treats it like a string (not a numeric type) so you have to enclose it
in single quotes within the query itself.

Typically I create a ColdFusion date object using CreateDate(), then
convert that to a string using DateFormat(mydate, "m/d/").


-Cliff


~|
Special thanks to the CF Community Suite Silver Sponsor - RUWebby
http://www.ruwebby.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187068
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


Re: Preventing users CFINSERTing duplicate records

2004-12-10 Thread Cliff Meyers
CK,


ALTER TABLE
  jobs
ADD CONSTRAINT
  myuniqueindex1
UNIQUE
  (co_id, co_name);

That should do it.  It creates a unique index across those two columns so
that no row can have identical values.  The database will throw an error
if you attempt to insert a non-unique row.

Alternatively, you could declare the PRIMARY KEY across both columns since
it implies unique values.


-Cliff



On Fri, December 10, 2004 2:35 pm, Chris Kavanagh said:
> Hello list!
>
> Well, that's it really.  What's the best way to prevent a user from
> inserting duplicate records?
>
> FYI in this case it's going into a MySQL table that has only two
> columns:
>
> --
> co_id co_name
> [PKey]
> --
>
> Thanks!
> CK.
>
>
> 

~|
Special thanks to the CF Community Suite Silver Sponsor - New Atlanta
http://www.newatlanta.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187066
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


CFHEADER/CFCONTENT over SSL with IE

2004-12-10 Thread Cliff Meyers
I have a simple text file that I want to force-download for users of a web
application.  I've set up the following code:





When I run the code in IE, I get the "File Download" dialog box as you'd
expect.  When I either try to open or save the file, I get this error
message:

"Internet Explorer cannot download act_download_key.cfm from www.anyhost.com.

Internet Explorer was not able to open this internet site... blah blah"

This site is being served over HTTPS.  When I adjust the IIS configuration
to allow requests over HTTP, the code magically works without issues. 
Furthermore Firefox can open/save the file without problems over either
HTTP or HTTPS.  I'm assuming this is some idiosyncrasy with IE when using
CFCONTENT/CFHEADER over an SSL site.  Thanks for your help.


-Cliff Meyers

~|
Special thanks to the CF Community Suite Silver Sponsor - RUWebby
http://www.ruwebby.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187029
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


Re:CF on Linux

2003-11-13 Thread Cliff Meyers
Yves,

This may be the godsend I've been waiting for!  Thanks for letting me know.  I'll probably be ordering it myself.

-Cliff

>I'd like to point out that on the DRK 3, MM has released a Verity app for
>Linux based on Lucene.
>
>I've ordered it and am waiting to try it out.
>
>Yves
>  -Original Message-
>  From: Cliff Meyers [mailto:[EMAIL PROTECTED]
>  Sent: 13 novembre 2003 09:50
>  To: CF-Talk
>  Subject: Re:CF on Linux
>
>
>  The install process on Linux is very painless especially on RedHat since
>the cfinstaller will automatically build your Apache connector for you.  I'm
>not sure if the cfinstaller will do that on the other distros.
>
>  I've been running CF on Linux for 3 years and the platform is rock solid
>and noticeably faster than on the Windows systems I've used.  I just
>upgraded to CFMX 6.1 (making a big jump from 4.5) and things seem to
>generally be running rather well.  However the lack of Verity support is a
>major disappointment and has actually spurred me begin to looking at
>migrating to Tomcat or JBoss instead of CF.  The nice thing about open
>source app servers is that the generally work on any Linux distro.
>
>  -Cliff
>
>  >Hi all,
>  >
>  >I'm a long time CF on Windows user who's thinking of dabbling with
>  >Linux as a possible future server platform.
>  >
>  >While my Cold Fusion skills are quite high, I'm a pretty basic Linux
>  >user. I can set up a box and know my way around the file system , but
>  >have never had to configure a web server from scratch.
>  >
>  >How does the CF install experience compare to that of Windows? Am I
>  >looking at hours of fiddling around with config files and pulling my
>  >hair out? Or will I be leaning back in my chair sipping daiquiris and
>  >pressing the 'y' key every now and then?
>  >
>  >The target platform I'm looking at if RedHat 7.3, running Tomcat. A
>  >client has specifically requested this config.. is it sensible? I've
>  >noticed that Tomcat isn't officially supported by MM, though they have
>  >a few technotes on the install process.
>  >
>  >Thanks, bye!
>  >
>  >---
>  >Ryan Sabir
>  >Newgency Pty Ltd
>  >2a Broughton St
>  >Paddington 2021
>  >Sydney, Australia
>  >Ph (02) 9331 2133
>  >Fax (02) 9331 5199
>  >Mobile: 0411 512 454
>  >http://www.newgency.com/index.cfm?referer=rysig
>  >
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re:CF on Linux

2003-11-13 Thread Cliff Meyers
The install process on Linux is very painless especially on RedHat since the cfinstaller will automatically build your Apache connector for you.  I'm not sure if the cfinstaller will do that on the other distros.

I've been running CF on Linux for 3 years and the platform is rock solid and noticeably faster than on the Windows systems I've used.  I just upgraded to CFMX 6.1 (making a big jump from 4.5) and things seem to generally be running rather well.  However the lack of Verity support is a major disappointment and has actually spurred me begin to looking at migrating to Tomcat or JBoss instead of CF.  The nice thing about open source app servers is that the generally work on any Linux distro.

-Cliff

>Hi all,
>
>I'm a long time CF on Windows user who's thinking of dabbling with
>Linux as a possible future server platform.
>
>While my Cold Fusion skills are quite high, I'm a pretty basic Linux
>user. I can set up a box and know my way around the file system , but
>have never had to configure a web server from scratch.
>
>How does the CF install experience compare to that of Windows? Am I
>looking at hours of fiddling around with config files and pulling my
>hair out? Or will I be leaning back in my chair sipping daiquiris and
>pressing the 'y' key every now and then?
>
>The target platform I'm looking at if RedHat 7.3, running Tomcat. A
>client has specifically requested this config.. is it sensible? I've
>noticed that Tomcat isn't officially supported by MM, though they have
>a few technotes on the install process.
>
>Thanks, bye!
>
>---
>Ryan Sabir
>Newgency Pty Ltd
>2a Broughton St
>Paddington 2021
>Sydney, Australia
>Ph (02) 9331 2133
>Fax (02) 9331 5199
>Mobile: 0411 512 454
>http://www.newgency.com/index.cfm?referer=rysig 
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re:How to deal with RH 7/8/9 EOL [was: CF on Linux]

2003-11-13 Thread Cliff Meyers
We've been running RedHat (since 6.2) with ColdFusion (since 4.5) for about 3 years now.  There are a few different paths I've been investigating lately for Linux:

>From what I've read the first core release of Project Fedora was a disappointment and had quite a few bugs in it.  Since Fedora isn't likely to be supported by any major applications (including CF) it's probably not a viable long term option anyways for anyone who wants apps that are actually supported.

I've been looking into purchasing a license for RedHat Enterprise Linux ES but the 349 USD price tag coupled with annual costs for a subscription is somewhat daunting, at least when you're used to using a free OS.  SUSE Standard Server 8 is another option but their price is 449 USD.  RedHat's main partnerships look to be Dell and Oracle whereas SUSE has a strong IBM partnership and is now owned by Novell (who also owns Ximian).  If you have a preference towards any of those companies' hardware or software it might be something to consider.  Of course there are plenty of other Linux distros but very few of them have much enterprise support.

I'm commited to Linux more than anything else.  MM's commitment to Linux however seems to be wavering.  Although the Verity support isn't maintained by MM that entire suite of tools in unusable on any modern Linux OS.  I'd like to see MM consider offering the Lucene engine for Linux users in place of Verity.

Ultimately I'll probably stick with RedHat and pay the fee or find a suitable Linux distro that works well with the rest of my open source stack (Apache, MySQL and PostgreSQL).  As far as the app server is concerned it's likely that I'll be making a migration to Tomcat with 6-12 months and converting our existing code base (about 50% CF and 50% PHP) to a unified Java code base.  The issues I've been having with Verity since upgrading to CFMX 6.1 have left a very bad taste in my mouth and a far less positive view of CF and MM that I previously held.

-Cliff
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Verity problems

2003-11-13 Thread Cliff Meyers
Hello,

I'm having some problems with Verity that I thought perhaps someone may be able to shed some light on.  I'm running CFMX 6.1 on RedHat 7.2 (with the compat-libstdc++-6.2 RPM installed for Verity compatibility).

I indexed about 20 text files using the CF Admin and that appeared to be successful (there were no errors in the sysinfo.log file inside the collection).

However, when I run a search (type = simple) against the collection I am always getting all 20 records returned.  No matter what I put in the cfsearch critera attribute - even if it's a total nonsense string - I get all 20 records back.  Furthermore, the result set has an empty string under the score column for each row.

Can anyone offer some assistance here?  I posted on CF-Linux also but it doesn't seem like I'll be getting a response on this one.  Thanks so much for your help.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]