Search In
Both UNION and UNION ALL operators are used to combine the results of two or more SELECT statements. However the two differ as below:
1) UNION performs a DISTINCT on the result set, removing any duplicate rows.There is a performance hit when using
If you are using Dropbox.js for file uploading and wants to upload some specific extension type like csv, xls etc. Please follow the below code::
Dropzone.options.uploadcontact = {
maxFilesize: 10, // Mb
acceptedFiles: ".xls,.xlsx,.csv", //
CMS is the most important part of the Odoo/OpenERP. Its help to use in Odoo dynamic website.
CMS helps to make structure acts as a design foundation that you have to update over time to ensure compatibility within your CMS. For example see below
All the Odoo XML file starts with encoding specifications. After that, you have to write your code inside a <data> tag, placed into tag. For example you can see below code..
<xml version="1.0" encoding="utf-8">
<openerp>
<data
INSERT INTO SELECT statement:
INSERT INTO SELECT statement is used to copy data from existing table into another table.
Syntax-1:
INSERT INTO tablename2 SELECT * FROM tablename1;
Syntax-2
INSERT INTO tablename2 (columnname(s)) SELECT columnna
There must be a situation where we need to redirects all non www requests to www. We can easily redirect user from non-www to www url string using following ways. for example , if a user makes a request for http://mysite.com/param1/param2, so with th
Using php we can easily find difference in days excluding weekends. First take start date and end date and generate strtotime for these dates to convert into string. After manipulation using while loop we can easily get the count of week days excludi
Hello Readers ,
Suppose we have two three array it will search with all three arrays and return an array that contains the values from array 1 that are not present in rest of the array
Example :
<?php
$a1=array("a"=>"red","b"=>"green","
SPACE(N)
If you want to add spaces in a string then you can use SPACE function of mysql. SPACE function returns a string consisting of N space characters means SPACE will returns the white space equal to passed argument n, where n is a integer valu
RPAD(str,len,padstr)
RPAD mysql function returns the string str, right-padded with the string padstr to a length of len characters means if you want to get a string to a given length and if the length of string is sorter than add the given character
