Hello, Can this be done? I have a table where they need to sort by date. The column is a datetime filed to sort dates correctly. we also need to be able to update the date, delete the date (make null) or keep the date null on an insert. Keeping the dat null on insert is fairly easy, but what if they want to sdelete the date? Adding blank form field defaults to 1/1/1900 in the db. Can an insert of NULL be written in SQL? I tried he obvious... <@IFEMPTY <@ARG date>>NULL<@ELSE><@ARG date>>/@IF>, <@IFEMPTY <@ARG date>>DbNull.value<@ELSE><@ARG date>>/@IF>, etc...
Has anyone done this before? Thanks! ---------------------------------------- To unsubscribe from this list, please send an email to [email protected] with "unsubscribe witango-talk" in the body.
