All posts by PF
SQL query – if value is null then return 1
The example from Stackoverflow.
SELECT orderhed.ordernum,
orderhed.orderdate,
currrate.currencycode,
coalesce(currrate.currentrate, 1) as currentrate
FROM orderhed
LEFT OUTER JOIN currrate
ON orderhed.company = currrate.company
AND orderhed.orderdate = currrate.effectivedate
http://stackoverflow.com/questions/14962970/sql-query-if-value-is-null-then-return-1
Detect main colors in an image with PHP
Today I’m working on a feature to detect the most used color on a image, so I can set up a variable value….
This is what i’v found…
http://stackoverflow.com/questions/10290259/detect-main-colors-in-an-image-with-php
Added a site to my CF…


Mauro Picotto feat. Riccardo Ferri – New Time New Place
As heard onDJ Pure at Live at Tranceescape.
Igor S – Airforce One
As heard on DJ Pure at Live at Tranceescape.
Patch and Protect Linux Glibc Getaddrinfo Stack-based Buffer Overflow Zero Day Vulnerability CVE-2015-7547 and CVE-2015-5229
A list of affected Linux distributions
- Red Hat Enterprise Linux Server 7
- Red Hat Enterprise Linux Server 6
- CentOS Linux 7
- CentOS Linux 6
- Debian Linux 6 squeeze
- Debian Linux 7 wheezy
- Debian Linux 8 jessie
- Ubuntu Linux 15.10
- Ubuntu Linux 14.04 LTS
- Ubuntu Linux 12.04 LTS
- SUSE Linux Enterprise Linux 11
- SUSE Linux Enterprise Linux 12
- openSUSE Leap 42.1
How to repair: http://www.cyberciti.biz/faq/linux-patch-cve-2015-7547-glibc-getaddrinfo-stack-based-buffer-overflow/
Some sounds for ‘day
bootstrap – can’t click on links on mobile
On mobile devices, and when using col-xs-12, the link on those divs weren’t working!
First, looks like theres is a order to put those classes
col-xs-12 col-sm-6 col-md-6
But the solution was to change the z-index of col-xs-12 as described here http://stackoverflow.com/questions/27886096/hyperlinks-not-working-on-xs-screens-in-bootstrap-v3-3-1.
.col-xs-12 {
z-index: 1;
}
8 years @ themeforest
