Doctrine create a custom sql query

http://stackoverflow.com/questions/12862389/symfony2-doctrine-create-custom-sql-query

jQuery validation: change default error message

http://stackoverflow.com/questions/2457032/jquery-validation-change-default-error-message

Symfony cache warmup

php app/console cache:warmup --env=prod --no-debug

SQL method to replace repeating blanks with single blanks

Link : http://stackoverflow.com/questions/2182877/sql-method-to-replace-repeating-blanks-with-single-blanks

down voteaccepted

Here is a simple set based way that will collapse multiple spaces into a single space by applying three replaces. DECLARE @myTable TABLE (myTextColumn VARCHAR(50)) INSERT INTO @myTable VALUES ('0Space') INSERT INTO @myTable VALUES (' 1 Spaces 1 Spaces. ') INSERT INTO @myTable VALUES (' 2 Spaces 2 Spaces. ') INSERT INTO @myTable VALUES (' 3 Spaces 3 Spaces. ') INSERT INTO @myTable VALUES (' 4 Spaces 4 Spaces. ') INSERT INTO @myTable VALUES (' 5 Spaces 5 Spaces. ') INSERT INTO @myTable VALUES (' 6 Spaces 6 Spaces. ') select replace( replace( replace( LTrim(RTrim(myTextColumn)), --Trim the field ' ',' |'), --Mark double spaces '| ',''), --Delete double spaces offset by 1 '|','') --Tidy up AS SingleSpaceTextColumn from @myTable Your Update statement can now be set based: update @myTable set myTextColumn = replace( replace( replace( LTrim(RTrim(myTextColumn)), ' ',' |'), '| ',''), '|','') Use an appropriate Where clause to limit the Update to only the rows that have you need to update or maybe have double spaces. e.g. where 1<=Patindex('% %', myTextColumn) I have found an external write up on this method: REPLACE Multiple Spaces with One

Check if string contains only letters in javascript

Check this out : http://stackoverflow.com/questions/23476532/check-if-string-contains-only-letters-in-javascript

With /^[a-zA-Z]/ you only check the first character:

• ^: Assert postion at the beginning of the string
• [a-zA-Z]: match a single character present in the list below:
  • a-z: A character in the range between "a" and "z"
  • A-Z: A character in the range between "A" and "Z"

If you want to check if all characters are letters, use this instead:

/^[a-zA-Z]+$/.test(str);

• ^: Assert postion at the beginning of the string
• [a-zA-Z]: match a single character present in the list below:
  • +: Between one and unlimited times, as many as possible, giving back as needed (greedy)
  • a-z: A character in the range between "a" and "z"
  • A-Z: A character in the range between "A" and "Z"
• $: Assert postion at the end of the string (or before the line break at the end of the string, if any)

Or, using the case-insensitive flag i, you could simplify it to

/^[a-z]+$/i.test(str);

Or, since you only want to test, and not match, you could check for the opposite, and negate it:

!/[^a-z]/i.test(str);

10 Google chrome commands

Check this out :
http://www.thegeekstuff.com/2011/10/google-chrome-commands

Fonction Random SQL

Check this out : http://sql.sh/fonctions/rand