Empty record display "empty" character
Posted: Fri Jan 21, 2005 9:49 am
Hi,
Running PHP and MSSQL.
In some table, my column isempty (NULL doesn't not appear but the cell is empty), let's say the column is called "data"
When I perform a SELECT and display the record of "data" on my page for the user to edit, the text input looks empty, but when I try to enter a new text, i notice that tere is already an "empty" character.
This is causing me problem, as user can edit this field or not if they want, but I perform a "number" check to allow only numbers for the field.
So if i try to save the form, even without modifyfing anything, the "error number" is triggerered as it can see that there is this empty character...
Any idea?
Sorry if it's not clear.
S
Running PHP and MSSQL.
In some table, my column isempty (NULL doesn't not appear but the cell is empty), let's say the column is called "data"
When I perform a SELECT and display the record of "data" on my page for the user to edit, the text input looks empty, but when I try to enter a new text, i notice that tere is already an "empty" character.
This is causing me problem, as user can edit this field or not if they want, but I perform a "number" check to allow only numbers for the field.
So if i try to save the form, even without modifyfing anything, the "error number" is triggerered as it can see that there is this empty character...
Any idea?
Sorry if it's not clear.
S