Rank of languages

 

Classification of programming languages ​​for "August 2013" according  TIOBE

Making a JSF/Primefaces Field required based on condition

JSF required attribute based on condition for jsf or primeface component required="true" then

required="#{not empty bean.value1}" />
or
 required="#{bean.value1 != ' '}" />
or
 required="#{bean.value1 = = ' '}" />
or
if bean.vale is boolean

 required="#{bean.value3?true:false}" />
conditinal expression you can use

MySQL stored procedure vs function

The most general difference between procedures and functions is that they are invoked differently and for different purposes:

1. A procedure does not return a value. Instead, it is invoked with a CALL statement to perform an operation such as modifying a table or processing retrieved records.
2. A function is invoked within an expression and returns a single value directly to the caller to be used in the expression.
3. You cannot invoke a function with a CALL statement, nor can you invoke a procedure in an expression.

You can't mix in stored procedures with ordinary SQL, whilst with stored function you can.
e.g. SELECT get_foo(myColumn) FROM mytable is not valid if get_foo() is a procedure, but you can do that if get_foo() is a function. The price is that functions have more limitations than a procedure.
 

Syntax for routine creation differs somewhat for procedures and functions:

1. Procedure parameters can be defined as input-only, output-only, or both. This means that a procedure can pass values back to the caller by using output parameters. These values can be accessed in statements that follow the CALL statement. Functions have only input parameters. As a result, although both procedures and functions can have parameters, procedure parameter declaration differs from that for functions.
2. Functions return value, so there must be a RETURNS clause in a function definition to indicate the data type of the return value. Also, there must be at least one RETURN statement within the function body to return a value to the caller. RETURNS and RETURN do not appear in procedure definitions.
   
   • To invoke a stored procedure, use the CALL statement. To invoke a stored function, refer to it in an expression. The function returns a value during expression evaluation.
   • A procedure is invoked using a CALL statement, and can only pass back values using output variables. A function can be called from inside a statement just like any other function (that is, by invoking the function's name), and can return a scalar value.
   • Specifying a parameter as IN, OUT, or INOUT is valid only for a PROCEDURE. For a FUNCTION, parameters are always regarded as IN parameters.
   If no keyword is given before a parameter name, it is an IN parameter by default. Parameters for stored functions are not preceded by IN, OUT, or INOUT. All function parameters are treated as IN parameters.
   
   To define a stored procedure or function, use CREATE PROCEDURE or CREATE FUNCTION respectively:
   

   CREATE PROCEDURE proc_name ([parameters])
    [characteristics]
    routine_body
   
   
   CREATE FUNCTION func_name ([parameters])
    RETURNS data_type       // diffrent
    [characteristics]
    routine_body

   A MySQL extension for stored procedure (not functions) is that a procedure can generate a result set, or even multiple result sets, which the caller processes the same way as the result of a SELECT statement. However, the contents of such result sets cannot be used directly in expression.
   Stored routines are associated with a particular database, just like tables or views. When you drop a database, any stored routines in the database are also dropped.
   Stored procedures and functions do not share the same namespace. It is possible to have a procedure and a function with the same name in a database.
   In Stored procedures dynamic SQL can be used but not in functions or triggers.
   

   SQL prepared statements (PREPARE, EXECUTE, DEALLOCATE PREPARE) can be used in stored procedures, but not stored functions or triggers. Thus, stored functions and triggers cannot use Dynamic SQL (where you construct statements as strings and then execute them). (Dynamic SQL in MySQL stored routines)

   
   Some more interesting differences between FUNCTION and STORED PROCEDURE:
   
3. Stored procedure is precompiled execution plan where as functions are not. Function Parsed and compiled at runtime. Stored procedures, Stored as a pseudo-code in database i.e. compiled form.
4. Stored procedure has the security and reduces the network traffic and also we can call stored procedure in any no. of applications at a time. reference
5. Functions are normally used for computations where as procedures are normally used for executing business logic.
6. Functions Cannot affect the state of database (Statements that do explicit or implicit commit or rollback are disallowed in function) Whereas Stored procedures Can affect the state of database using commit etc.
   refrence: J.1. Restrictions on Stored Routines and Triggers
7. Functions can't use FLUSH statements whereas Stored procedures can do.
8. Stored functions cannot be recursive Whereas Stored procedures can be. Note: Recursive stored procedures are disabled by default, but can be enabled on the server by setting the max_sp_recursion_depth server system variable to a nonzero value. See Section 5.2.3, “System Variables”, for more information.
9. Within a stored function or trigger, it is not permitted to modify a table that is already being used (for reading or writing) by the statement that invoked the function or trigger. Good Example: How to Update same table on deletion in MYSQL?

Note: that although some restrictions normally apply to stored functions and triggers but not to stored procedures, those restrictions do apply to stored procedures if they are invoked from within a stored function or trigger. For example, although you can use FLUSH in a stored procedure, such a stored procedure cannot be called from a stored function or trigger. 

How to Get CodeIgniter Support for PHP in NetBeans?

To supports CodeIgniter in my favourite IDE Netbeans there is a NetBeans plugin under the Project Kenai
This plugin will allow us to create CodeIgniter projects right from NetBeans’ Create New PHP Project Wizard, also it’ll provide full auto-completion while you’re coding.
In this post I’ll explain how to get this plugin to work. First you should make sure that you have at least NetBeans 7.0 installed on your machine. Also go ahead and download the latest version of CodeIgniter (currently v 2.1.4).
1. From NetBeans go to Tools menu, then choose Plugins, and then select the Settings tab.
2. Click on the Add button on the window appeared from the last step.
3. Type any name you find appropriate, and for the URL paste one of these links depending on your NetBeans version, and click Ok.

• For NetBeans 7.0.1 use http://kenai.com/downloads/nbphpci/Latest_NetBeans701/updates.xml
• For NetBeans 7.1.1 use http://kenai.com/downloads/nbphpci/Latest_NetBeans711/updates.xml
• For NetBeans 7.1.2 use http://kenai.com/downloads/nbphpci/Latest_NetBeans712/updates.xml
• For NetBeans 7.2.0 use http://kenai.com/downloads/nbphpci/Latest_NetBeans720/updates.xml
• For NetBeans 7.3.0 use http://kenai.com/downloads/nbphpci/Latest_NetBeans730/updates.xml

4. Go to the Available Plugins tab, and search for CodeIgniter, two plugins should appear (Framework and Framework Repository), check both of them and click Install.
5. Go to Tools menu, and choose Settings. Then go to PHP tab. You should find a new tab for CodeIgniter, switch to it.
6. Under Base Files click Add type an appropriate name in the name field (I used CodeIgniter 2.1.4), and browse to the CodeIgniter’s zip file you downloaded earlier. Finally hit the Ok button.
7. Now restart NetBeans, and once it’s restarted try to create a new PHP project via the File menu.
8. Go through the few steps of creating a new project, and at the final step under PHP Frameworks you should find CodeIgniter there, check it and hit Finish.


There you have it! You can now start coding with CodeIgniter like a ninja!