Solo Entrepreneur | Lead Software Architect
When using postgres, we sometimes need to find fields that match multiple like queries. In this situation we can use like any. Making use of the any expression. Example: select * from some_table where some_field like any ( select '%'||some_other_field||'%' from some_other_table );
Here’s a fix for anyone looking to free the up and down keys when using jquery ui’s autocomplete on a textarea.
A lot of websites are after your money to subscribe to their service. A lot of their traffic comes from marketing emails. Most people read their emails on their phone, leading to a problem. Price tables are designed for full screen PC browsing… Enter the responsive pricing tables. Demo: Enjoy...
When using spring”s handy ReflectionTestUtils to set a field on an AOP proxied object, it has trouble setting fields on the proxy object (complaining that “field not found”). In this case you need to unwrap the original object from the proxy. private Object unwrapProxy(Class clazz, Object proxy) { if(AopUtils.isAopProxy(proxy) &&...
Just a quick one for converting cells in epoch format to dates, I am using this for data pullled from mongodb. =ID_OF_CELL/86400000+DATE(1970,1,1)