How can insert the date field BLANK in sql server ?
How can update the date filed BLANK in sql server ?

I want to insert blank date but sql server not insert blank date record why ?
In the sql server date save ie. "01/01/1900"
When I insert BLANK DATE why ?


INSERT CODE
------------------------
isql1="insert into drawings (name,date_recd,dtype,location) values ("
isql2="'" & dname & "',"
isql3="'"& date_recd &"',"
isql4="'"& date_recd &"',"
isql5="'" & dtype & "',"
isql6="'" & location & "')"

isql=isql1+isql2+isql3+isql4+isql5+isql6

cn.Execute isql


UPDATE CODE
-----------------------
usql1="update drawings set "
usql2="name='"& name1 &"',"
usql3="date_recd='"& date_recd &"',"
usql4="location='"& location &"',"
usql5="dtype='"& dtype &"' where dwg_count="&dwg_count


usql=usql1+usql2+usql3+usql4+usql5

cn.execute usql

Please check the date filed.

Mateen

What do you mean by 'blank date'? Specifically, what do you mean by the term 'blank'?. A string (char or varchar) column can take on a value of a zero length string, or the blank character, two meanings I might assign to the term 'blank'. For other datatypes, the term 'blank' really has no meaning.

Specifically, the datetime datatype cannot be blank as I have defined it above. If you attempt to assign a date value of '' (or the string ' '), it will instead take on the value of date 0 , which is 1/1/1900.

When you say 'blank date', do you mean NULL? Any column which has the null attribute set will allow a null value, but null isn't at all the same thing as 'blank' (whatever you might mean by that).

To insert or update a null value in the manner you are attempting, use the keyword 'null' (without quotation marks), e.g.:
Similarly for your update code.

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com

Thanks for your response.
Yes I mean NULL, some time I need to insert NULL in the date_Recd and some time I need to insert date in the date_Recd field.

It give the following error.

Error Type:
Microsoft OLE DB Provider for SQL Server (0x80040E14)
There are fewer columns in the INSERT statement than values specified in the VALUES clause.
The number of values in the VALUES clause must match the number of columns specified in the INSERT statement.
/pweb/tp_drawings/add_drawing2a.asp, line 62

isql1="insert into drawings (name,date_recd,dtype,location) values ("
isql2="'" & dname & "',"

isql3="NULL,"
isql4="'" & date_recd & "',"

isql5="'" & dtype & "',"
isql6="'" & location & "')"

''isql7="insert into sectors (name,sect_area,loc_type) values ("
''isql8="'" & sname & "',"
''isql9="'" & sect_area & "',"
''isql10="'" & loc_type & "')"

isql=isql1+isql2+isql3+isql4+isql5+isql6

cn.Execute isql // line 62


date_recd is only one column. There may be this condition apply ?

if date_Recd="date" then
isql4="'" & date_recd & "',"
else
isql4="NULL,"



if yes how ? I apply this condition but it always inter NULL value.

You have four columns and five values...

Try this:

Jonax made a little mistake, the If should be like this
Stéphane Lajoie

... indeed he did ;) - thanks for pointing it out ...

Thanks