One of my customers wanted to have spoken text on his webpage. Having no idea about Flash & Co. I found this neat solution: Use a WordPress-Plugin to do the job. Tutorial: http://www.macloo.com/examples/audio_player/ Download necessary stuff: http://www.1pixelout.net/download/audio-player.zip MP3 for testing: Tusch!
Archive for the ‘Snippets’ Category
A nice shortcut I came across to update content in a mySQL-table without writing a script to do it – which was the first thing that came to my mind… Case: I had many HTML-snippets in a CMS table called ‘freepages’ containing hard coded domain-names in URLs to images etc. Now guess what happened as [...]
A neat little trick to prevent pesky spam-bots from flooding your form-based applications with garbage: Use a simple token in the session to block bots from submitting data to your forms. It works like this: 1.) Generate a random token when the form is displayed, remember it in your session and put it into a [...]
I have been struggeling many times to do initial filling of databases for projects – especially if the data is a deliverable of a customer and the database structure is already fixed. So I built a VBA macro that generates SQL statements for creation of tables and data inserts from a given XLS-file. The idea [...]
This is a short 4-liner in VBA to be used as macro in Excel to remove linebreaks contained inside of cell-content. VBA to remove linebreaks from inside of cells in Excel
I was looking for a solution to automatically set HTTP-links as transparent rectangles of the size of every page of a given pdf-document containing the pagenumbers as parameter. This is a nice way to link normal webpages and PDF-docs. I used it in a project for an online catalogue which runs as a ‘web-app’ from [...]





RSS