Sunday, July 12th, 2009
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";
Now you can successfully run the insert query with 0 set as value for a primary key, ...
Posted in MySQL, Programming | No Comments »
Wednesday, February 18th, 2009
Here is a JavaScript function used to remove blank lines from a textarea. This snippet is using the Prototype JavaScript framework
function removeBlankLines(field)
{
$(field).value=$(field).value.gsub(/\s+/, '\r\n');
}
You can use it with "onblur" attribute:
Posted in HTML, JavaScript, Programming | No Comments »
Wednesday, December 10th, 2008
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.
The JavaScript code:
function stripspaces(input)
{
input.value = input.value.replace(/\s/gi,"");
...
Posted in JavaScript, Programming | 1 Comment »
Home
