//$mail->Send(); - this is string sends email to site db administrators who has been selected in Site Database Notification Settings
C:\Claromentis\web\intranet\careuk\classes\CareUKSite.php and line 1657
Search
Thursday, 3 April 2008
Problem with Mysql 5.0.51
If you use Mysql 5.0.51 and use in sql query GROUP BY with ORDER BY without other tables then you not see correct result.
For example: Client side uses SQL query
"SELECT * FROM care_uk_sites cus, permissions p GROUP BY cus.id, cus.site_name, cus.division_id ORDER BY site_name ASC"
and old sql query used on admin side:
"SELECT * FROM care_uk_sites cus GROUP BY cus.id, cus.site_name, cus.division_id ORDER BY site_name ASC"
Currently we have SQL query with fixed bug:
SELECT * FROM care_uk_sites cus ORDER BY site_name ASC - this is the same SQL query but without GROUP BY, which is not need
For example: Client side uses SQL query
"SELECT * FROM care_uk_sites cus, permissions p GROUP BY cus.id, cus.site_name, cus.division_id ORDER BY site_name ASC"
and old sql query used on admin side:
"SELECT * FROM care_uk_sites cus GROUP BY cus.id, cus.site_name, cus.division_id ORDER BY site_name ASC"
Currently we have SQL query with fixed bug:
SELECT * FROM care_uk_sites cus ORDER BY site_name ASC - this is the same SQL query but without GROUP BY, which is not need
Monday, 21 January 2008
Linux Based Portal Open Framework
Claromentis - the customisable information framework written in PHP and developed on Linux - has confirmed the public status of their API and seen commercial projects extended by PHP developers from around the world
read more | digg story
read more | digg story
Sunday, 20 January 2008
I want mine! Incredible Self-Miniature Sculpture
Amazing Miniatures from Award Winning UK Artist Michelle Wibowo. Her Cakes is amazing too. I want mine !!!
read more | digg story
read more | digg story
Tuesday, 1 January 2008
Friday, 26 October 2007
Wednesday, 26 September 2007
Only2Clicks - a simple visual start page now has Bookmarklet !
User can now add links easily to your personalized page using new Bookmarklet feature from Only2Clicks a really simple visual start pages which has received a lot of buzz and continuously growing.
read more | digg story
read more | digg story
Subscribe to:
Posts (Atom)