ASP - update a null or blank date?

  • Thread starter Thread starter stuckinj2
  • Start date Start date
S

stuckinj2

Guest
I am using ASP and trying to update a ms access database with a null date. Not all date fields will have any data. Or a date field may have a date and the date can be changed to blank/null. I have search all over and cannot find the solution.
Any help or direction will be much appriciated.
set datefld = Null does not work. That would be far too easy.
Could it be something in the access db settings or ODBC or my IIS??
 
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open "c:/webdata/northwind.mdb"
conn.Execute "Update tblSample set dateNULL = NULL WHERE ID = 10"
%>
---------
In case you are in the table design with the cursor on the date field, you can modify date required (true/false) in the General tab under the table fields)
I am not sure whether there might be a possibility of a multi field index, where the content of an index field is required to be not NULL
 
Back
Top