Re: inserting null into DB

talk2raj55@xxxxxxxxx wrote:
hi

I am encountering a problem as follows:
I have a text box called fax no on the form,
its stored into the dbase as numeric data field
now the problem is that i can't insert a null value
into the numeric field,
(that is in the absence of fax no)
What can i do in such a case???
I need to insert null into the DB, if fax no is not provided
instead of stopping the whole insert query.

The answer depends on:
1. database type and version
2. the method you are using to insert the data - show us a code snippet


--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"


.

Relevant Pages
Loading