London will be playing host to it’s own PauseOnError on October 20-21 at the Park Plaza Sherlock Holmes Hotel in Baker Street. It’s going to be the same format as the previous Pause events in New York and Portland, but with a few minor differences. Primarily, this boils down to using conference rooms instead of presenting in hotel rooms. As Pause on Error is an unconference, it’s a much more self organising event than others such as FileMaker Devcon.
Read more…
While NULL is a concept familiar to SQL users FileMaker developers tend to have little exposure to the idea. Effectively NULL is the value given to a field who has no known value. It is distinct from an empty field or a field that contains the text NULL. NULL has some interesting characteristics most based around the fact that NULL ≠ NULL so SELECT * where field = NULL will never return any values; NULL never equals anything even itself. To test for NULL within MySQL the IS NULL function is used.
Read more…
One of FileMaker’s great strengths in the ability to convert a standard layout into a web page. Instant Web Publishing is a great way to get a database driven web site up and running if you have no knowledge on how to build a web site and connect it to a database.
Read more…
This was originally intended to be a blog on useful tips to get around the limitations of PHP’s bind variable methods when using prepared statements, however the ‘short introduction’ got a little out of hand, so instead you’ve got a post about using prepared SQL statements with PHP (which is probably a more interesting choice of topic for most people anyway).
Read more…
Just a quick post from me today, to recommend jsFiddle. It’s an online service that allows you to quickly try out Javascript ideas and share them with other developers. The mileage you will get out of this for development I (would imagine) is small – but as a learning and sharing resource its fantastic!
Read more…
Recently a client requested we capture webpages for them. As a marketing company recording evidence of the exposure they gained their clients is key requirement. They had for many years manually stitched screenshots together. While cheap this approach was incredibly time consuming, tedious and prone to mistakes.
Read more…
Recently I’ve spent some time looking at FileMaker’s internal SQL support. In this article I discuss how we can use FileMaker scripting to add and delete tables from a FileMaker database.
Read more…
We’ve just taken the covers off the redesigned Cortela’s website – www.cortela.com.
Read more…
That’s easy I hear you say. If you have two fields on a layout, enter data into the first field and the second field has a drop down menu with only the values that relate to the first field.
We have all done this, the drop down menu shows related values from a relationship which is based on the first field.
Enter find Mode, enter a value into field 1 and the drop down menu still shows the expected values. All good.
Read more…
The more I use jQuery the more I realise that I really should have checked out the source code a while back – rather than just viewing the framework as some kind of magical black box of Javascript wonder (not that jQuery isn’t full of wonder of course!). Thinking about how jQuery (and Javascript) works has helped me greatly in deciding good ways to do things.
Read more…
