|
 |
asp_databases thread: database
Message #1 by jay48202@y... on Wed, 16 Oct 2002 19:11:37
|
|
Hi,
I have a database in which fields are defined as real. any blank text box
submission is causing a zero to be stored in the database, This is
conflicting bcos, say if zero is actually to be stored. Is there a process
of overcoming this. I wanted to have a blank in the fields if I do not
enter any value. I am using ASP and SQL Server'2000.
Thanks,
Jay
Message #2 by "Ken Schaefer" <ken@a...> on Thu, 17 Oct 2002 12:54:50 +1000
|
|
Insert a NULL instead of what is being inserted by the user.
Cheers
Ken
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: <jay48202@y...>
Subject: [asp_databases] database
: I have a database in which fields are defined as real. any blank text box
: submission is causing a zero to be stored in the database, This is
: conflicting bcos, say if zero is actually to be stored. Is there a process
: of overcoming this. I wanted to have a blank in the fields if I do not
: enter any value. I am using ASP and SQL Server'2000.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Message #3 by Greg Griffiths <greg2@s...> on Thu, 17 Oct 2002 20:30:33 +0100
|
|
why not check the length of the field either using Javascript on the client
side or ASP on the server side and act accordingly.
At 19:11 16/10/02 +0000, you wrote:
>Hi,
>
>I have a database in which fields are defined as real. any blank text box
>submission is causing a zero to be stored in the database, This is
>conflicting bcos, say if zero is actually to be stored. Is there a process
>of overcoming this. I wanted to have a blank in the fields if I do not
>enter any value. I am using ASP and SQL Server'2000.
>
>Thanks,
>Jay
|
|
|
View Cart
