Re: Coldfusion hosting question.

2007-09-22 Thread Dave l
the headers shouldnt cause a slowdown and it may not say your website but it still is probably on the same server and the point of doing the ping is to see where it is slowing down between your computer and the server which doesn't necessarily mean that it is either your computer or the server

Re: ColdFusion 8 memory usage

2007-09-22 Thread Dave l
are you by chance running these in VM settings? I have a cfm8 vps server and it runs real high but on my cfm 8 dedicated box its fine. Ok, we have ColdFusion 8 installed on several development machines. They all have the same JVM version 1.6.0_02, two are Vista and two are on XP. On my

Re: ColdFusion 8 memory usage

2007-09-22 Thread Jochem van Dieten
Dan Crouch wrote: Ok, we have ColdFusion 8 installed on several development machines. They all have the same JVM version 1.6.0_02, two are Vista and two are on XP. On my Vista machine, the task manager shows jrun.exe using right around 500,000K of memory. Another Vista machine shows it

Re: one for the SQL gurus

2007-09-22 Thread Kris Jones
You have to include category in your group by statement if you're selecting it. And you need it in the view because you are limiting the resultset based on it. Can you change your cfquery to something like: cfquery name=qryGetYear datasource=#request.site.dsn# SELECT LEFT(PublicationYear, 4) AS

Re: one for the SQL gurus

2007-09-22 Thread Kris Jones
Errr, rather that should be sum(bookcount) as bookcount, not sum(PBID) as PBID. Duh. SELECT LEFT(PublicationYear, 4) AS Year, sum(Bookcount) as Bookcount Cheers, Kris SELECT LEFT(PublicationYear, 4) AS Year, sum(PBID) as PBID You have to include category in your group by statement if

Re: Instantiating all objects within Application.cfm

2007-09-22 Thread James Holmes
Sorry, that's just completely wrong. Any page, anywhere on the server, can use your Application name and get your Application scope variables; this can't even be prevented with sandboxing. If I have access to createObject(java) (which can be sandboxed out), I can even use the service factory to

Re: Instantiating all objects within Application.cfm

2007-09-22 Thread Andrew Scott
Yes but guessing the application name is not easy... On 9/22/07, James Holmes [EMAIL PROTECTED] wrote: Sorry, that's just completely wrong. Any page, anywhere on the server, can use your Application name and get your Application scope variables; this can't even be prevented with sandboxing.

Re: Instantiating all objects within Application.cfm

2007-09-22 Thread James Holmes
If in doubt I can get all the app names from the application tracker factory object and get everything from all of them. On 9/22/07, Andrew Scott wrote: Yes but guessing the application name is not easy... -- mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/

urgent help required - using a users selection to select specific data

2007-09-22 Thread Toby King
Hi there I'm really stuck on this issue - have been trying to work it out for several hours so would really appreciate some input as to what I need to do. I have displayed on screen an option where a user can select a month of a year to select specific data. table form action=avgHours.cfm

RE: urgent help required - using a users selection to select specific data

2007-09-22 Thread Adkins, Randy
Ok so what's the problem ? -Original Message- From: Toby King [mailto:[EMAIL PROTECTED] Sent: Saturday, September 22, 2007 10:27 AM To: CF-Talk Subject: urgent help required - using a users selection to select specific data Hi there I'm really stuck on this issue - have been trying to

RE: urgent help required - using a users selection to select specific data

2007-09-22 Thread DataPacks.com
OK, and you need help with what?? -Original Message- From: Toby King [mailto:[EMAIL PROTECTED] Sent: September 22, 2007 10:27 AM To: CF-Talk Subject: urgent help required - using a users selection to select specific data Hi there I'm really stuck on this issue - have been trying to

RE: urgent help required - using a users selection to select specific data

2007-09-22 Thread Adkins, Randy
One issue, is your probably getting an error from: FORM.TIMEDATE_PERIOD does not exist. Unless the form is being submitted from a previous form. Are you submitting the form right back to itself? If not, then why do you need the CFIF statement in the OPTIONs If so, add a form parameter at the

Re: urgent help required - using a users selection to select specific data

2007-09-22 Thread Peter Tanswell
Hi there I'm really stuck on this issue - have been trying to work it out for several hours so would really appreciate some input as to what I need to do. I have displayed on screen an option where a user can select a month of a year to select specific data. table form

Re: urgent help required - using a users selection to select specific data

2007-09-22 Thread Greg Morphis
reminds me of http://www.homestarrunner.com/sbemail10.html On 9/22/07, Adkins, Randy [EMAIL PROTECTED] wrote: One issue, is your probably getting an error from: FORM.TIMEDATE_PERIOD does not exist. Unless the form is being submitted from a previous form. Are you submitting the form right

RE: urgent help required - using a users selection to select specific data

2007-09-22 Thread Adkins, Randy
I agree :-) I forgot about that site -Original Message- From: Greg Morphis [mailto:[EMAIL PROTECTED] Sent: Saturday, September 22, 2007 9:55 AM To: CF-Talk Subject: Re: urgent help required - using a users selection to select specific data reminds me of

RE: urgent help required - using a users selection to select specific data

2007-09-22 Thread Adkins, Randy
Are you having a problem or just don't know how to do the task? -Original Message- From: Peter Tanswell [mailto:[EMAIL PROTECTED] Sent: Saturday, September 22, 2007 9:55 AM To: CF-Talk Subject: Re: urgent help required - using a users selection to select specific data Hi there I'm

Re: urgent help required - using a users selection to select specific data

2007-09-22 Thread Peter Tanswell
Hi yes - the form is being resubmitted to itself. On 9/22/07, Adkins, Randy [EMAIL PROTECTED] wrote: One issue, is your probably getting an error from: FORM.TIMEDATE_PERIOD does not exist. Unless the form is being submitted from a previous form. Are you submitting the form right back to

RE: urgent help required - using a users selection to select specific data

2007-09-22 Thread Adkins, Randy
Ok are you getting an error when you first come to the page? -Original Message- From: Peter Tanswell [mailto:[EMAIL PROTECTED] Sent: Saturday, September 22, 2007 10:03 AM To: CF-Talk Subject: Re: urgent help required - using a users selection to select specific data Hi yes - the form

Re: urgent help required - using a users selection to select specific data

2007-09-22 Thread Peter Tanswell
I guess a bit of both - I know what I need to but have been struggling with what to do to get it working. Perhaps what I have asked is a bit over the top - if it is I apologise - if necessary if its more than a 5-10 min fix solution to agree a small consulting fee to get pointer to the right

Re: urgent help required - using a users selection to select specific data

2007-09-22 Thread Peter Tanswell
Nope not getting any error - its actually working the first part - can I email you off list and show you On 9/23/07, Adkins, Randy [EMAIL PROTECTED] wrote: Ok are you getting an error when you first come to the page? -Original Message- From: Peter Tanswell [mailto:[EMAIL

Re: Instantiating all objects within Application.cfm

2007-09-22 Thread Andrew Scott
not in cf8 you can't if it has been sandboxed right. On 9/22/07, James Holmes [EMAIL PROTECTED] wrote: If in doubt I can get all the app names from the application tracker factory object and get everything from all of them. On 9/22/07, Andrew Scott wrote: Yes but guessing the application

Re: urgent help required - using a users selection to select specific data

2007-09-22 Thread Greg Morphis
If I'm reading it right.. set up a form variable cfparam form.selectedMonth = / I'd define a CSS clss for hightlightedTD that alters the background color, or something Then during the output.. td class=cfif form.selectedMonth eq foo.selectedMonthhighlightedcfelsenormal/cfif#foo.data#/td

RE: urgent help required - using a users selection to select specific data

2007-09-22 Thread DataPacks.com
Peter How about passing the date (mm yy) as the URL variable instead of the date id, then just compare them. Use a cfparam above all this set to the current month and year so it display today by default. Then in your calendar table use the URL var and the query value to see if they're the same.

Re: Instantiating all objects within Application.cfm

2007-09-22 Thread Brian Kotek
I was talking about in CF code. Of course if the instance of CF isn't secured or is older then you can get at absolutely anything with the underlying Java objects. Basically, don't host anything sensitive on an unsecured, shared server. I assumed this was a well known rule, but maybe I was wrong.

ColdFusion Kavachart

2007-09-22 Thread Peter Tanswell
Hi there I'm just wondering if anyone has used KavaChart with ColdFusion before. I'm trying to finish off a chart but am struggling a little as I havent used this charting tool before. I look forward to any feedback. Thanks Toby

RE: one for the SQL gurus

2007-09-22 Thread Scott Stewart
Solved it last night I balied out on the view and did this cfquery name=qryGetYearList datasource=#request.site.dsn# SELECT TOP (100) PERCENT LEFT(PublicationYear, 4) AS Year, COUNT(PBID) AS BookCount FROM dbo.PsycBOOKS

Not getting emails

2007-09-22 Thread Steve Good
Anyone know who I should send an email to if I have not received any of the emails from the list since 9/6/07? I've already tried to unsubscribe and then subscribe again, but that didn't change anything. Thanks! ~Steve ~|

Re: one for the SQL gurus

2007-09-22 Thread Janet MacKay
AND (Active = 1) and category in (SELECT category FROM dbo.PsycBOOKS cfif categories is not where Category in ('0' cfloop list=#categories# index=x ,'#x#' /cfloop) /cfif ) Why the subquery? Just use IN with cfqueryparam list=true SELECT LEFT(PublicationYear, 4) AS [Year], COUNT(PBID) AS

Re: Instantiating all objects within Application.cfm

2007-09-22 Thread James Holmes
So was I - as long as I know the application name, a CFAPPLICATION tag anywhere on the machine can make any CF code part of your application. There is no folder restriction on this and no way to prevent it. On 9/22/07, Brian Kotek [EMAIL PROTECTED] wrote: I was talking about in CF code. Of

RE: one for the SQL gurus

2007-09-22 Thread Scott Stewart
Hi Janet, I tried this and it didn't work... ? -- Scott Stewart ColdFusion Developer SSTWebworks 4405 Oakshyre Way Raleigh, NC. 27616 (703) 220-2835 http://www.sstwebworks.com http://www.linkedin.com/in/sstwebworks -Original Message- From: Janet MacKay [mailto:[EMAIL PROTECTED]

Re: ColdFusion Kavachart

2007-09-22 Thread Paul Hastings
Peter Tanswell wrote: I'm just wondering if anyone has used KavaChart with ColdFusion before. I'm trying to finish off a chart but am struggling a little as I havent used this charting tool before. it's been a while, what seems to be the problem?

Re: ColdFusion Kavachart

2007-09-22 Thread Simon Horwith
any reason you're not using the built-in charting/graphing? Assuming you have a good reason, like Paul said, what's the actual problem? ~Simon Simon Horwith Adobe Community Expert Adobe Certified Master Instructor http://www.horwith.com Paul Hastings wrote: Peter Tanswell wrote: I'm

Re: Instantiating all objects within Application.cfm

2007-09-22 Thread Sean Corfield
On 9/22/07, James Holmes [EMAIL PROTECTED] wrote: So was I - as long as I know the application name, a CFAPPLICATION tag anywhere on the machine can make any CF code part of your application. There is no folder restriction on this and no way to prevent it. Just set your application name to the