How To Remove Spaces At The End Of Each Form Field?

What sort of spaces do you mean?

Sergey

i have a db in sql server fields with char ()

Change it to VARCHAR?

Sergey

is not possible because the DB is composed of many tables, in each table there are many fields.

thanks

The problem with CHAR fields is that they will be padded with spaces automatically every time you save your data. You cannot get rid of those spaces while you use CHAR fields.

Sergey

would be enough to remove the spaces in the focus of the field
// gotFOCUS

$(':input').focus(

function(){

$(this).css({'background-color' : '#FAFAD2'});

});

// lostFOCUS

$(':input').blur(

function(){

$(this).css({'background-color' : '#FFFFFF'});

});

Sergey

I solved in this way

the function under color also the field that has focus
// FOCUS ON FIELD

$(':input').focus(

function(){
// TRIM FIELD

var valoreCC = $.trim($(this).val() ) ;

this.value = valoreCC ;
// COLOR OF FIELD

$(this).css({'background-color' : '#FAFAD2'});

});
// OFF THE FIELD

$(':input').blur(

function(){

$(this).css({'background-color' : '#FFFFFF'});

});