In order to insert value 0 in a field that is set as primary key for a MySQL table you need to execute the following query prior to any insert query: SET SQL_MODE = “NO_AUTO_VALUE_ON_ZERO”;
Tag Archives: snippets
Remove blank lines from a textarea using Prototype
Here is a Javascript function used to remove blank lines from a textarea…
Remove spaces from an input field with JavaScript
This is a small snippet to remove the spaces from an input field using JavaScript. It can be useful when you want a value without spaces, or when you want to replace the spaces from the input field with other characters.