itlivewire dev blogJust another web development blog…

keep your wordpress secure
A stitch in time saves nine. I couldn’t sew my way out of a bag, but it’s true advice for bloggers as well — a little bit of work on an upgrade now saves a lot of work fixing something later.

Right now there is a worm making its way around old, unpatched versions of WordPress. This particular worm, like many before it, is clever: it registers a user, uses a security bug (fixed earlier in the year) to allow evaluated code to be executed through the permalink structure, makes itself an admin, then uses JavaScript to hide itself when you look at users page, attempts to clean up after itself, then goes quiet so you never notice while it inserts hidden spam and malware into your old posts.

THE SOLUTION: UPGRADE TO WORDPRESS 2.8.4

Not many Pinoys know about digg.com, So it’s gonna be hard to explain what is http://www.pinoyscoop.com/, basically it’s a social news site where news articles are submitted by users, those users also have the ability to make that article popular or just bury it in the bottom, in short the success of the article depends on the users http://www.pinoyscoop.com/

Does the ordinary pinoy needs pinoyscoop? answer is not really it’s up to you, if you want fresh news or discover something new, pause from facebooking or doing your farms all day then read pinoy scoop

Content at pinoyscoop.com is not yet that interesting few articles have been submitted as of this writing BLOGGERS? where art thou? when you need one?

gmanews.tv a tv network took advantage and implemeted smartly the use of social technology in the case the use of facebook’s “update your status about an event”. They put up a live stream of Cory’s burial on the net and put a facebook sort of message box chat where you can update your status via the event which in this case is the live stream, This way pips browsing facebook at that time with friends who have recently updated their status via the gmanews live stream will also be informed that hey there is a live stream on the web let’s check it out.

Pretty awesome I should say
So here’s something I can do if I’m bored, need to hold my keyboard like a guitar for total satisfaction.
http://www.jamlegend.com/

Because the best things in life are FREE!

Frequency of word always tells a story, it tells us the emphasis

More info on the tag cloud here http://bit.ly/3uMfv

source: productive dreams

http://www.productivedreams.com/properties-that-were-impossible-to-implement-in-ie6/

source: regulargeek.com

Whether Rnd or Bank, Startup or Public companies, see what programming language they use often to build their apps

http://regulargeek.com/2009/07/21/what-programming-languages-do-jobs-require/

Java is on the top – From being a hype in the late 90′s, the code once deploy anywhere tagline did not work out, but its focus on enterprise core gained them respect attention and love

JavaScript placing 3rd – after 2nd placer C++, Only means one thing more and more apps are becoming web based.

Error Code : 1349
View’s SELECT contains a subquery in the FROM clause

It’s a long standing MYSQL BUG

You cannot do this!
*******************************************************************
DROP VIEW IF EXISTS `db`.`empmain_vw`;
CREATE
VIEW `db`.`empmain_vw`
AS
select * from (select * from employees group by salary) a;
********************************************************************
In the code above we are trying to build a view called empmain_vw
But an error appears
Error Code : 1349
View’s SELECT contains a subquery in the FROM clause

This means you cannot create a view with a SUBQUERY in the FROM clause, no no no…… ohh! no!

Simple workaround (double task) is to create a view of the subquery first, lets create empsalary_vw
*******************************************************************
DROP VIEW IF EXISTS `db`.`empsalary_vw`;
CREATE
VIEW `db`.`empsalary_vw`
AS
select * from employees group by salary;
********************************************************************

Then combine it with your previously wanna build view, so lets create again empmain_vw
*******************************************************************
DROP VIEW IF EXISTS `db`.`empmain_vw`;
CREATE
VIEW `db`.`empmain_vw`
AS
select * from empsalary_vw;
********************************************************************

This one will work now coz there is no subquery in the FROM clause

The bug has been there i think for a long time, other DBMS is capable creating views even with subquery on clause oracle and etc.

Document Object Model or DOM for short, is just a fancy term for “everything on your website”. It includes every table, image, link, form field, etc. on your page ALL HTMP ELEMENTS. JavaScript enables us to manipulate any element on the page in real time.

I will show in this example how to manipulate DOM elements faster inside the loop, making elements display fast on the page.  You only need a firebug console to try it.

First: The tradional way of manipulating DOM elements inside a loop
var tdelem=”";

console.time(‘oldloop’);

for (i=0;i<=1000;i++){

tdelem = “#div” + i;
$(tdelem).html(‘hello’);
$(tdelem).css(‘color’,'red’);

}
console.timeEnd(‘oldloop’);