Aggregate Bug? with ColdFusion (8.0.1) Query of Queries

I've been having the following issue with CF8 Query of Queries on ColdFusion 8.0.2:

Iniital query resultset:

attraction_latitudeattraction_longitude
51.4808-0.155075
51.564617-0.092513
51.558144-0.316379

[More]

Google Maps: How to zoom...

The esiest way to zoom in and out on a Google Map, is to use the Mouse Wheel (up for zooming in, and down to zoom out).

Sometimes this isn't possible (by default mouse wheel zoom is disabled for API usage, and it's hard to use a mouse wheel when you're on a laptop with no mouse!)

In this case you can double click with the left button to zoom in (I'm sure everybody knew this) - but you can also zoom out by double clicking the right mouse button.

(And if you are using a Mac Book, then tough luck as Apple are still insisting that a right mouse button is superfluous!!!) (...waits for flames from Mac Fan Boys...)

CFAjaxProxy - don't add the .CFC file extension...

I've been getting the following CF error when attempting to use the CFAjaxProxy tag:

The specified CFC path.to.cfcname.cfc cannot be found

The specified CFC definitely existed, and all the mappings had been set up correctly.

I was calling it with the following code:

<cfajaxproxy cfc="path.to.cfcname.cfc" jsclassname="searchCFC">

I was tearing my hair out for about an hour, before I realised think CF not AJAX - the path to be supplied is in exactly the same format as all CFC references - i.e. excluding the .CFC file extension.

I'm sure this is completely obvious to most people (although at least one guy (thanks Andy) mentioned having done the same thing even today) - but its the obvious ones that seem to catch me out!!!

Weird issue trying to start a CF8 instance

Just had the following issue when trying to start a CF8 instance.

Within the windows services control panel, I clicked start for all of the instances (8) - and they all started except 1.

This was following some fairly in depth reconfiguring of the instances - involving changes to multiple configuration files, the registry, and (perhaps most tellingly) mapping each instance to use its own configuration file by un-registering the windows service, and then re-registering the service using the new config file.

During this process, jrunsvc will stop the service if it is currently running.

When I checked within the JRun {instance name}-out.log file within the instance which would not start, I saw the following error:

error JRun Naming Service unable to start on port 2914
java.net.BindException: Port in use by another service or process: 2914

[More]

How to change the default backup location in SQL Server2005

There doesn't appear to be a simple way of changing this setting from within SQL Server Management Studio.

you can however change this setting by modifying this registry key:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer\BackupDirectory

This is very handy if you are wanting to restore a load of databases from backup (e.g. when migrating databases from another server...)

64 bit CF8 Compatability issue (Completely irrelevant to most people)

There doesn't appear to be a 64bit driver for MS Access data sources.

I know - no-one in there right mind would use access for driving a website - but we still host a couple (literally) of sites which were created at least 6 years ago and have barely been changed since...

Solution: Import said databases into SQL Server...

SMTP Event Gateway???

Does anyone know of an SMTP event gateway for ColdFusion>

What I'm looking for, is a way of implementing helpdesk type functionality, whereby any emails to a certain domain are handled by ColdFusion according to a set of rules (e.g. create new issue - add comment to an exiting issue etc.)

It struck me that it should be relatively straightforward to handle incoming SMTP transmissions using a ColdFusion Event Gateway (seeing as SMTP is a relatively simple text based prtocol...) - and I wondered if anyone had already done it - and if not - why not? (I'm presuming I must have overlooked something that would make it more complicated than I anticipate...)

ColdFusion 8.01 on Windows - should I go 64 bit?

I'm in the process of specifying a new web server, which will be running ColdFusion 8.01 Enterprise (as well as IIS etc.).

The server will be running ~6 active instances of ColdFusion - and will initially be configured with 4GB RAM - with the option of upgrading in the future as required.

We will be using Windows 2003 Enterprise as the operating system.

What will the benefits and downsides be of going for the x64 OS compared with the x32 OS, taking the following into consideration:

  • The system will only be used as web application server
  • The system will initially be set up with 4GB RAM - and will never have more than 8GB.
  • The high number of instances of CF mean that if we did set the JVM Heap size over the ~1200 MB x32 limit, then we'd run a distinct possibility of running out of memory. (The reason for having so many instances of CF is to enable separation of CF Mail queues - 2 of the instances don't get any front end traffic at all, and are just responsible for sending out large batches of email)

Any advice would be appreciated...

A big thankyou to all those involved in Scotch on the Rocks

Got back home from Scotch on the Rocks - just wanted to publicly thank all those involved with Scotch on the Rocks.

In particular I want to thank Andy Allan and his wife Leanne for the huge amount of time and resource they have given to make this conference the best ever European ColdFusion conference, together with Kev, Stephen and others.

I also want to thank all the speakers - All the presentations I attended were interesting - and some were particularly relevant to where I am now as a developer.

The networking was great - it was particularly good to be able to chat with some of the guys who are leaders within the community - I think this can be even more valuable in many occasions than the sessions - as well as the interaction with Adobe staff.

Thanks Everyone.

How to change ColdFusion / JRun logging location

ColdFusion by default stores log files in 2 locations, dependant on the type:

[More]

Why does anyone use Yahoo email???

A word of advice for anyone using Yahoo mail:

Use Googlemail

Last night, I had to test the formatting of an email generated by our Email Marketing tool within Yahoo mail.

  • The first email I sent arrived immediately
  • The second email I sent did not arrive within an hour and a half
  • The third email I sent (20 minutes later) also did not arrive within that time frame
  • The fourth email I sent (over an hour later) arrived imediately

When I checked yahoo mail this morning, there were four unread emails - including one which had been sent at 16:30 the previous day - this mail took at least 8 hours to arrive!

This in itself should be more than enough to stop anyone using yahoo mail (This is definitely not an isolated instance, we have had several reports of this behaviour from our clients).

In addition, the following would also stop me using yahoo:

  • Extremely intrusive advertising, often taking over ~ 50% of the screen space.
  • The annoying this message was sent using yahoo mail - aren't we fantastic! message which yahoo seem to put into every outgoing email by default
  • When you set up a new account, Yahoo seem to "opt you in" to receive messages within various categories - without warning you that they are going to

Now I appreciate that some people don't get on with the googlemail interface - but if my 60+ year old mum can can cope with moving from yahoo to google (and actually prefers the googlemail interface) - then it can't be that hard!

Add on the fact that you can host email for your own domains there for free - and you get a whole lot of other functionality for free as well (Blackberry / mobile device / POP3 / IMAP access, integration with other Google services etc.) - and the advertising is non intrusive (and often relevant) - then I really can't understand why anyone would use a service which is as dysfunctional and annoying as yahoo's...

Rant over... for now...

More Entries

BlogCFC was created by Raymond Camden. This blog is running version 5.5.1, hosted by TalkWebSolutions.