Passing Null value from empty text box on form

[nogero]

I have a simple html form that calls an asp page to process the data and do an insert into an SQL Server 2005 table.

The issue is that if a user leaves a field in the form blank an empty string (or blank space) gets inserted into the database field. I would like to have a Null inserted into the database if the html form field is left blank (My database table does accept NULL values).

I am not sure how to do this, any help would be appreciated. Thanks.. Can this be done on the html form side or does this need to be done in the .asp processing page?

 

[tsuji]

Just test the request (suppose being post and similarly for the get) object. If the posted value of the field with name "fieldname" is empty, replace it by null (reserved word).
[tt]
x=request.form("fieldname")
if trim(x)="" then
x=null
end if
[/tt]
Then use the x in the insert into statement as usual.