HolyWellFund.org released

For those of you in the music world, chances are most of you have heard about the Holywell Music room in Oxford. It is the oldest purpose built concert hall in England.

As with all decent concert venues, they need a bit of love and care every now and then – enter the Holywell Music Room Rennovation Appeal –

HolyWellFund.org

Go visit and see what they’re trying to achieve!

Intelligent Sustainable Energy

Intelligent Sustainable Energy now released: see the Drupal 6.x website here:
http://www.ise-oxford.com/

ISE is the creator of revolutionary technologies to help people reduce and manage their energy consumption. Faced with rising energy bills and increasing environmental pressures, consumers are keener than ever to reduce the amount of energy that they consume. However, whilst we can all follow simple rules such as turning off lights and not leaving the TV on standby, the reality is that most people do not have a clear understanding of how they use energy. ISE’s technology changes this giving you fully itemised energy bills just like the itemised phone bill that you get from your phone company.

Looping over a structure into a query

Thanks to CF-talk, have worked out a way to get my posted form structs into queries a little more easily;
It’s the “#testStruct[“UrlText_” & counter]#” syntax which was the key for me.. posted here for my own reference!

<cfset testStruct = structnew() />
<cfset testStruct.LinkText_1 = "Linktest1" />
<cfset testStruct.LinkText_2 = "Linktest2" />
<cfset testStruct.LinkText_3 = "Linktest3" />
<cfset testStruct.UrlText_1 = "Urltest1" />
<cfset testStruct.UrlText_2 = "Urltest2" />
<cfset testStruct.UrlText_3 = "Urltest3" />
<cfset TempLinkQ=QueryNew("linkname,url", "varchar,varchar")>

<cfdump var="#testStruct#" />

<cfset counter =1>
<cfloop list="#structKeyList(testStruct)#" index="key">
<cfif key CONTAINS "linktext" AND len(teststruct[key]) GTE 1>
<cfoutput>
<cfset QueryAddRow(TempLinkQ, 1)>
<cfset QuerysetCell(TempLinkQ, "linkname", "#testStruct["linkText_" & counter]#")>
<cfset QuerysetCell(TempLinkQ, "url", "#testStruct["UrlText_" & counter]#")>
</cfoutput>

<cfset counter=(counter+1)>
</cfif>
</cfloop>

<cfdump var="#TempLinkQ#">

Drupal 6 – output your primary links as a Site Map

This took me a while to find: In Drupal 6, I wanted to output the main Primary Links menu item, expanded, as a site map:

Simply add the following to a node (with PHP parsing ON!)

<?php 
$tree = menu_tree_all_data($menu_name = ‘primary-links’, $item = NULL);
print menu_tree_output($tree);
?>

Introducing the Hinksey Studio

I’ve just launched a new website for a new business venture of mine – producing limited edition prints…

Do have a look and let me know what you think!!

http://www.hinkseystudio.co.uk

It’s been really quite exciting to start this up – guess I’m officially grown up now 🙂

And of course, it’s all ColdFusion driven. But of course.

ColdFusion now free for Educators.. but…

ColdFusion 8 is now free for Educators.. but… you can’t use it on a production server. Oh well – good start though. It follows the Flex free for Educators program: https://freeriatools.adobe.com/

I’m still going through the conditions, but presumably this means I can use a development server in house with no 3 IP limitations – definitely a step forward.

It always felt painful as an a higher education department to think about having to buy twice the licenses just to power our in house dev server.

Adobe – go the whole hog! Release CF (and while you’re at it) the whole of Creative Suite free for educational use! You know you want to…go on go on go on etc.. I know, I’m dreaming.

CF8 + MAMP on OSX step by step

<p>Someone left a comment after my last cry for help about installing CF8 + apache on Mac, so I thought I’d quickly run through the steps I took.

Assuming you’re on the latest version of OSX, you *could* use the inbuilt Apache server. However, I’ve used MAMP, which is essentially a bundled version of Apache, MySQL, PHP.

1) Uninstall CF8 – If you’ve got it installed already (it’s just going to make this easier)

2) Download MAMP from here

3) Download the 32bit (not 64bit, as, although MacOSx is a 64bit OS, the connector on MAMP is 32bit) version of CF8 from adobe.com

4) Install MAMP in the usual way – don’t worry about CF yet – just get Apache + PHP working. NOTE – you only need MAMP, NOT MAMP pro. When configuring, set the apache + mySQL ports to their defaults. It should be now reading the files out of /applications/MAMP/htdocs when you go to http://localhost. If you don’t get the MAMP start screen, check that a) both the lights in the MAMP Application window are green, and then you’ve got web sharing turned OFF in Settings/Sharing in OSX

5) So we’ll assume you’ve got the MAMP start page working. If you’ve got a different place for your installed websites (personally I’ve got a whole drive which I use as my ‘www’ root) change it now in the MAMP config. As directory browsing appears to be enabled by default in MAMP, you should be able to see the folders/files in whatever directory you point it to when you go to localhost.

6) Now for CF. Install CF with the following – Single Server Instance, and use the built in webserver (we’re not actually going to be using that for now, but I could never actually get the correct config in the installer to get it work on install)

7) Now open the ColdFusion Web Service Connector: You should be able to find this in Applications/ColdFusion (I’m actually writing this on a PC, so can’t check the location, sorry).

8) On the window which opens, click “Add” to add a configuration. Use the following settings:

jrun Host: localhost
jrun Server: ColdFusion
Web Server: Apache
Configuration Directory: /Applications/MAMP/conf/apache
Configure web server for ColdFusion 8 Applications: ticked

And this is the important bit, in Advanced:

Enable verbose logging for connector: unticked
Enable native OS memory allocator: unticked
Build Apache module from source using APache eXtenSion tool: unticked
Directory and file name of server binary: /Applications/MAMP/bin/apache2/bin/httpd
Directory and file name of server control script: /Applications/MAMP/bin/apache2/bin/apachectl

Now, CF *should* have done a couple of things. One is rewrite your httpd.conf file to include CF settings, such as .cfm files, and the second is turned on Web sharing under your OSX settings – you need to go back and turn OFF web sharing – the reason is, that is the inbuilt OSX apache server, and not the MAMP one. It gets a little confusing if you don’t do that, as you’ll see an Apache notice, but it won’t be running CF!

I then restart MAMP (if you’ve set the ports to defaults, it will require your password everytime, as if your port number is lower than 1000 it’s sort of quasi protected as a service on OSX).

You should now be able to go to localhost/CFIDE/administrator where it should run the migration script. You’ll then be good to go.

I’ll double check and add the proper file locations another time when I’m on my Mac.

Help! Installing MAMP + CF8 on Leopard

Ok, some help needed here:

I have a brand new Mac Pro at work; Running the latest and greatest version of OSX with all the security updates etc.

So I need to install CF locally, and have already installed MAMP.
MAMP I got working with no problems, and running on the default ports for MySQL + Apache.

Installed CF8, 64bit edition, and when installing, did the single server instance. I can’t remember if I specified the built in webserver, or tried to point it to MAMP, but post installation, I had nothing in the web server config, so set up the web server connector as follows:

jrun Host: localhost
jrun Server: ColdFusion
Web Server: Apache
Configuration Directory: /Applications/MAMP/conf/apache
Configure web server for ColdFusion 8 Applications: ticked

And in Advanced:

Enable verbose logging for connector: unticked
Enable native OS memory allocator: unticked
Build Apache module from source using APache eXtenSion tool: unticked
Directory and file name of server binary: /Applications/MAMP/bin/apache2/bin/httpd
Directory and file name of server control script: /Applications/MAMP/bin/apache2/bin/apachectl

Now, when I try and start MAMP, mySQL runs, but Apache itself won’t start.
I’ve checked that CF has written the appropriate lines into the http.conf file, which it has – it’s added the .cfm extensions etc.

When I try and start Apache via Terminal, I get this:

Syntax error on line 1114 of /Applications/MAMP/conf/apache/httpd.conf:
Cannot load /Applications/ColdFusion8/runtime/lib/wsconfig/1/mod_jrun20.so into server: cannot create object file image or add library

“mod_jrun20.so” does exist in that location.

Any ideas what to try next?

**update**
Now solved! – installed the 32bit version instead of the 64bit version, as MAMP ain’t got enough bits. 🙂
Thanks to Stephen Erat!

Good things, Ning.

I was initially skeptical about Ning – whose claims of being able to create your own social network without programming knowledge seemed a bit optimistic.

I take it all back. I finally got around to creating a network for a project which I was consulting on, and I’m really impressed. I think I got the whole thing up and running in about 6 minutes.

Obviously, that’s without much in the way of customisation, and I had the logo all done beforehand etc. but still, that’s pretty quick.

So Ning Pros:

  • Stupidly fast to set up
  • Initial site free
  • You can request the source code for customising – although you’re then on your own in terms of code updates
  • Good use of Groups/Forums/Social Profiling, and user management – you can lock down the whole thing to registered users if you want
  • Quite simply, this will do *most* people, if they want some community based system

Cons:

  • not so much a con, but you have to pay to remove adverts, use your own domain or subdomain, add extra bandwidth (100GB per month) etc – they’ve got to make their money somewhere I guess.
  • Every event seems to require a picture of some description, which seems pointless.
  • Some people are happy on facebook, and don’t want yet another social network

I’ve yet to really delve into the inner workings, APIs etc, but it seems all sensibly thought out so far.. Now if it was only written in CF…