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 at the
beginning of the function which is messy and to me is asking for trouble,
especially if myVaria
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
>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 mi
>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
applicati
OK, managed to duplicate post and still screw it up!
The IN clause of the second query should be:
WHERE messageId IN (#ListGetAt(ValueList(getMessageIds.messageId), i)#)
This is only an illustration - it's probably worth creating the ValueList
outside the loop to avoid creating a large list mul
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.
T
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 wa
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 an
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. S
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 ev
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 ite
>http://www.bpurcell.org/blog/index.cfm?mode=entry&entry=967
Perfect!
Many thanks.
Ian
~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
http://www.houseoffusion.com/banners/view.cfm?banne
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/
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
>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 ap
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
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 e
>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 som
>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 ...
>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 nea
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 particu
>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
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:
You can then link to this URL directly and it will download as an excel spreadsheet.
Ian
>I'm using a combination of Flash and Coldfusion web services to ge
>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]
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.
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 - no
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]
[Us
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
[T
ter (released 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]
[Subscr
29 matches
Mail list logo