Author Archives: gherardobertini

GooglePlay – ExpManager – Trick to transfer backup

Unfortunately the develore of this app ExpManager has quit to support it. I was in trouble when I wanted to tranfer my data to new my smartphone. I found a trick. I suppose you have the APP in both smartphones … Continue reading

Posted in Uncategorized | Leave a comment

Symfony Doctrine Concurrency

I used Optimistic-Locking here you can find the documentation: You can add in your entity the field version. Automatically doctrine will manage concurrency throwing an Exceprion. use Doctrine\ORM\Mapping as ORM; … /** * @var int * * @ORM\Column(name=”version”, type=”integer”, … Continue reading

Posted in Symfony | Tagged , , | Leave a comment

This is my solution to avoid constraint violation when you use Soft Delete Here is an interesting article that explain how unique index are treated by DB The field deletedAt as Datetime with NULL value can’t be part of … Continue reading

Posted on by gherardobertini | Leave a comment

SQL Access Equivalent MySQL Limit X, Y

In MySQL for paging a query we use SELECT * FROM {table} LIMIT X, Y In Access there is only SELECT TOP Y * FROM {table} to select first Y records of a query We can use this trick: First … Continue reading

Posted in Access, PHP, SQL | Tagged , , , , | Leave a comment

HTML JQuery – transform Inputbox into dropdown list (combobox)

Transform input textbox in combobox using JQuery and hide click out Demo

Posted in JQuery | Tagged , , | Leave a comment