itlivewire dev blogJust another web development blog…

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’);

Been having  Stored Procedures problems on oracle lately keeps on getting errors, and its really hard to trace, especially when u don’t know where to start. good thing exception handling comes handy on oracle, here’s what I usually do to raise exceptions.

CREATE OR REPLACE PROCEDURE myproc IS
BEGIN
NULL; — do something here insert or update
EXCEPTION
WHEN OTHERS THEN
emesg := SQLERRM;
dbms_output.put_line(emesg);
END;

**************************************************************************************
The code is basic put he EXCEPTION on the end just beofre the end; then put
EXCEPTION
WHEN OTHERS THEN
emesg := SQLERRM;
dbms_output.put_line(emesg);

this means that any instance there is an exception pass the SQLERRM, the sql error message toemesg and print it using dbms_output.put_line

that is you simple and quick exception handing ang prblem tracing

more exception handling techniques available here http://www.psoug.org/reference/exception_handling.html

Eclipse PDT has been available for sometime not the best PHP IDE, maybe the best free PHP IDE, and for some looking for alternative to the pricey dreamweaver eclipse pdt should do the trick

Tools for PHP developers creating Web applications, including PHP Development Tools (PDT), Web Tools Platform, Mylyn and others. More…

download ECLIPSE PDT at http://www.eclipse.org/downloads/download.php?file=/technology/epp/downloads/release/galileo/R/eclipse-php-galileo-win32.zip

Eclipse is a popular JAVA IDE,  Eclipse is a fast JAVA IDE (Netbeans is slow), Eclipse has a new version.
And with the tradition of naming their releases with moons, the new version is to be called GALILEO.

From eclipse.org
The new features in the Galileo release reflect three important trends in the Eclipse community: 1) Expanding adoption of Eclipse in the enterprise, 2) innovation of Eclipse modeling technology and 3) advancement of EclipseRT runtime technology. Each project has published “new and noteworthy” documentation for their specific release.

Download eclipse galileo http://www.eclipse.org/downloads/

more at eclipse.org

See how ubuntu name their releases http://itlivewire.com/devblog/?p=43