Local function variables in CFC

Hi everyone, I find myself getting more and more wound up that variables set within a cfc function are not scoped to that function but to the entire cfc. I'm ending up with a whole series of cfset var myVariable = at the beginning of the function which is messy and to me is asking for

cfmail - is it vulnerable?

Hello, Just got a bunch of emails in my inbox this morning that had been sent from a contact form on one of my web sites. They all contained content a bit like this: deeper xxContent-Type: multipart/alternative; boundary=e00c35d22e0dba33a15957f33286efe8 MIME-Version: 1.0 Subject: idee is that a

Re: How to recognize robots

One bot loaded this page 15 times before it left! I don't want to rain on your parade, but I'd be very surprised if an email harvesting bot would be intelligent enough to parse that javascript and suck up the generated output. Remember that the Javascript has to be processed client side. I

Re: Paging through records

I've just been through this. I found that some of the threads in our forums were nearing 1000 messages, and the query containing all this was about 1.5Mb in size. The only snag with using a stored procedure for this is that it is very difficult to get a RecordCount for the entire query. The

Re: Paging through records

Hi, I've just been through this. I found that some of the threads in our forums were nearing 1000 messages, and the query containing all this was about 1.5Mb in size. The only snag with using a stored procedure for this is that it is very difficult to get a RecordCount for the entire query.

Re: Paging through records

OK, managed to duplicate post and still screw it up! The IN clause of the second query should be: WHERE messageId IN (cfloop from=#startRow# to=#endRow# index=i#ListGetAt(ValueList(getMessageIds.messageId), i)#/cfloop) This is only an illustration - it's probably worth creating the ValueList

Re: Paging through records

C'mon, this is just too inefficient: you're converting column messageId of query getMessageIds to a list in the loop! I did say that Ian ~| Logware (www.logware.us): a new and convenient web-based time tracking

Re: Cached query - Any way to tell when it was cached?

How about adding: getdate() AS cachedSince to the list of columns in the query. getdate() is a SQL Server function but most dbs should have an equivalent function. Ian ~| Discover CFTicket - The leading ColdFusion Help Desk

Re: SQLServer Connect problem - was it ever resolved?

Are you using Windows 2003? If so, have you updated SQL2000 to the very latest service pack? To quote Microsoft, Microsoft Windows Server™ 2003 supports only SQL Server 2000 with Service Pack 3 What they mean is that there is a bug in SQL on 2003 whereby it won't communicate across TCPIP.

Re: Are search engine safe URLs really necessary?

Google does treat SES URLs slightly differently in that it will spider pages at a significantly slower rate if it thinks the pages are dynamic. It is designed that way so that it doesn't bring the site down by over enthusiastic spidering. I redeveloped an existing application into fusebox, so

Re: Sessions being show to wrong users?

I'd back up Martin's theory of it being search engines indexing the site with the CFID/CFTOKEN in the URL. If two people follow that link within the session time out they will share the session. I now only use CFID/CFTOKEN in the URL from behind a log in page, or after someone has added an

Re: Java memory usage

Ooh, this is interesting - and timely as I'm currently wrestling with java.lang.outOfMemoryError errors at the moment. Is there any way of telling how much 'permanent' memory (as set by MaxPermSize) is being used? I read that if you have a lot of files in /cfusionmx/wwwroot/WEB-INF/cfclasses/

Re: Java memory usage

http://www.bpurcell.org/blog/index.cfm?mode=entryentry=967 Perfect! Many thanks. Ian ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application

Re: Sessions not exclusive

Are you passing round the CFID and CFTOKEN in the URL? If so, make sure nowhere links to your site with those tokens in the link - if two people click on the link within 20 minutes of each other (or whatever your session timeout is), they will share a session. We used to have this problem with

Re: upgrade site from FB2 to FB2

I don't have any sample code I can distribute, but request overhead is greatly reduced in FB4 due to some built-in caching mechanisms. True when compared to FB3, but I'm not so sure when compared to FB2. FB2 had no core code - the only request overhead was URL2Attributes. FWIW I migrated an app

Re: Single application - multiple users with differing specifications

Hi, I don't think this is particularly unusual... While department B wants additional features and won't use some of the existing, I am assuming that the features they share, and indeed the business rules behind them all are common. In that case, write an application that does everything for

Re: Single application - multiple users with differing specifications

Another thought. Whatever you do, bear in mind that department C and D will be along soon with their own requirements. You need to be able to design something whereby you can accomodate this without multiplying the amount of code you produce. It's probably worth thinking How will this look if

In One?

Hi, This has been bugging me for about 3 years now, and I've finally decided to see if I can beat it (er... well see if I can find someone else that can beat it :) I've got a db table with a typical category heirachy structure: categoryId, parentCategoryId, categoryName, etc.. Given a

Re: In One?

You could set your table up in a modified preorder tree traversal, so each node has a LFT and RGT numeric value. I've done this in several instances and it works great. Hey, thanks Dov, that's lovely. As far as I understand it so far, it does have the snag that if you make a change near the

Re: In One?

Cache the data (application-scope variable) then use local UDFs or a CFC to manage processing. Yes, I'm beginning to think this may be the best compromise. Particularly as, although there's about 18k categories, probably 10% of those are queried 90% of the time. So, following on from this ...

Re: AW: In One?

Check out the book trees and hierarchies in SQL for smarties by Joe Celko. ISBN: 1-55860-920-2 It gives a very good overview about how to treat trees in a SQL database. That's what I love about this business. You think you're the only one to have a particular problem, then you find out someone

Re: JRE

When you upgrade your JRE from the vanilla CFusionMX JRE there is no server folder in the bin folder of the system (Sun Java). I'm going through the same thing at the moment. It appears if you download the SDK, the JRE within there does have a server folder. If you install JRocket, that has a

Re: SOT: Action Canceled, XP Service Pack 2

I assume you're writing the html/xls file to disk here? How about generating the html as a normal request, then placing this at the top: cfcontent type=application/msexcel CFHEADER NAME=Content-Disposition VALUE=filename=report.xls You can then link to this URL directly and it will download as

Re: 100% CPU

Hi all, An interesting update to this thread. I posted a message to the forums on the Macromedia site, and it got picked up by someone at Macromedia. Anyway, after sending him the contents of a few log files, it looks like he's traced it to a bug in the ColdFusion client variable purging system.

Re: 100% CPU

got a link to the thread on MM forums so we can monitor that as well? Sorry - all the diagnosis happened via email. Ian [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

100% CPU

a few days ago), reinstalled ColdFusion, scandisked the drive and defragged. I wonder if anyone can give me any clues on what else to look for. Surely we should be able to get more traffic out of this spec machine? Many thanks Ian Buzer [Todays Threads] [This Message] [Subscription] [Fast

Re: 100% CPU

Hi vishnu, Thanks for the reply. Just to understand what this does Am I right in thinking this controls the cf scheduler? I'm fairly confident that our load problems are not related to scheduled requests as these occur overnight. Or does the scheduler have other implications? Thanks Ian

Re: 100% CPU

Hi Mack, You can try and get a stack trace to see what's happenning with CF when the problem occurs. http://www.macromedia.com/support/coldfusion/ts/documents/tn18339.htm Good info - I'll check this out. Thanks Ian [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User

Re: 100% CPU

Hi Andrew, Bill, We've been running ServersAlive for the last couple of years, which has been cycling the service automatically everytime the system slows and like you say, this has worked well as a backup. Trouble is, it was doing this about every 10 minutes when we had our recent problems -