[thelist] ASP/SQL date database question

[Anthony Baratta]

"L. Floyd" wrote:
> 
> Forgive my ignorance, but I'm just stumped with this.  I have an Access
> database that I'm updating using ASP/VBScript.  One of the fields each
> record in the database is a date that initially is empty.  It's simple
> enuff to put a date in there, but I'm having difficulty making that
> field blank again!  Is there a way to simply remove the contents of that

I use MS SQL, not Access so this might not work for you:

	Update TableName Set DateField = Null Where RowID = 123


-- 
Anthony Baratta
President
KeyBoard Jockeys
                    South Park Speaks Version 3 is here!!!
                       http://www.baratta.com/southpark
                              Powered by Tsunami