acogitosis

After upgrading NetBeans to 6.5 the -post-compile task I added so JiBX bindings are compiled stopped working for me throwing an exception about bindings not found at runtime.

The solution to this is to disable “Compile on Save” feature in project properties.

Can You tell a difference between

SELECT *, format(Data_ur, "yyyy-mm-dd") AS Datur FROM Czlonkowie

and

SELECT *, format(Data_ur, 'yyyy-mm-dd') AS Datur FROM Czlonkowie

?

It turns out that when using ODBC to connect to Microsoft Access database (in an mdb file), one has to use single quotes when writing function parameters. The first statement runs fine from the Access itself, but when called through the ODBC (for instance when using PHP and PDO) it returns empty set (it doesn’t even throw an exception).

The second statement (with single quotes) runs fine through ODBC. Worth remembering.

Sometimes Your customer just has that bloody hosting with IIS and MSSQL database instead of good old Apache+MySQL. I used to use SqlBuddy on Windows, but after switching to Linux I had hard time finding a nice GUI frontend to MSSQL (SqlBuddy fails to work under Wine).

Along came JDBC

There’s a really nice universal JDBC GUI frontend called SquirrelSQL. Just download and java -jar installer.jar and select MSSQL plugin. Then download jTDS driver and unzip the JAR somewhere. Run Squirrel SQL using its .sh script and double click “Microsoft MSSQL Server JDBC driver”. Add jtds-v.e.r.jar to Extra Class Path and change Class Name to net.sourceforge.jtds.jdbc.Driver and Example URL to jdbc:jtds:sqlserver://<server_name>.

Then create new alias, test and… voila!

Od ponad 2 lat korzystamy w domu z VoIP (najpierw był to Halonet, a teraz IPFon) zamiast stacjonarnego telefonu. Ostatnio - jako że przeszedłem na Linuxa i musiałem zainstalować Windows w maszynie wirtualnej, co wiązało się z telefoniczną aktywacją w Microsofcie - okazało się że są problemy z korzystaniem z wybierania tonowego - zaskakiwało tylko co któreś wciśnięcie klawisza, więc aktywacja (9 grup po 6 cyfr!!) Windowsa okazała się niewykonalna.

Technicy z IPFona doradzili taką prostą zmianę w ustawieniach bramki VoIP:

DTMF Tx METHOD zmienić z AUTO na INFO

Pomogło!

Gosh, this blog gets too technical I guess I need to start writing some kind of non-IT journal here. You know, the teenage-pink-blog style

Anyway, more for my own reference.

CodeIgniter is a nice and nonintrusive PHP application framework that I’ve grown to like and use it (also commercially). The problem is integrating its MVC with external applications such as CMSes.

Here’s a quick hack I’ve done to make this possible:

1. Create “external” subdirectory under “system” directory of CodeIgniter installation.
2. Place attached files there.
3. Open “system/libraries/Loader.php” file and patch it like this: find line 681 and change

global $OUT;
$OUT->set_output(ob_get_contents());


to

global $OUT;
if (!isset($OUT)) $OUT = $GLOBALS[’ci_external_out’];
$OUT->set_output(ob_get_contents());

4. For example of use, see attached index.php file, basically to call a controller method, just do this:

require_once 'ciexternal.php';
echo ci_external(’controller’, ‘method’);