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!

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#">

Incoming search terms:

  • coldfusion page not working apache mamp
  • coldfusion querynew date querySetCell {ts is an invalid date format

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.

Incoming search terms:

  • ColdFusion oxford OR oxfordshire

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.

Incoming search terms:

  • coldfusion mamp on listing directory
  • mamp cf8 snow leopard

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!

Incoming search terms:

  • 64 bit mod_jrun20 so download here
  • directory and filename of server binary apache
  • wsconfig command line

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…

Ray Camden on ColdFusion Certifications

Ray’s post on ColdFusion Certifications is pretty spot on: The one problem, on top of those outlined by Ray, that I’ve had over the years, is that very few certification courses have a decent break down on what exactly they expect you know.

Combined with the fact that there are so many features in CF which I’ll never need to touch, like exchange integration etc (well, not yet at least) that I fear the weighting in such an exam wouldn’t sit in my favour.

Perhaps they should move onto a peer review model where some assesses an application you’ve written? To me, that would prove you can a) analyse a problem b) come up with a solution and c) implement the solution in CF, along with the necessary skills such as MySQL.

Going insane installing Flexbuilder 3

I’ve spent *days* trying to figure this out – whilst installing Flexbuilder 3, I’d get continual errors on install, and when trying to run the .exe, I’d get:

java.lang.RuntimeException: No application id has been found

and

com.adobe.flexbuilder.standalone.product could not be found.

in the log.

But a solution has been found!
The problem was that I’m on a domain machine. When you install FB3, it’ll try and create folders in “My Documents” for configuration and preferences. My “My Documents” is a network share, mapped as part of being on the domain.

So it was trying to create folders where it either didn’t have permission, or just creating random duplicates in two places. Either way, the solution is to uninstall everything Flex related, log in to your machine as LOCAL administrator (i.e not on the domain) install FB3, log back out, and then it’ll be fine!

Not exactly user friendly :)

Incoming search terms:

  • product com adobe flexbuilder standalone product could not be found