Front end logic in a webpage1)when i check a check box and submit a page the value that should be getting saved to a datetime feild is getdate() (This logic works ok)2)When i dont check the check box and submit the webpage a default value of 1/1/1900 should be getting saved but null is getting inserted instead(Not Working)3)This particular datetime feild should only get updated if i check the checkbox and submit the page and should not be updated if i dont check the check box(This logic also working ok)Below is the SQL i have been using for the above three conditionsdetdate =COALESCE(NULLIF(@detdate,'19000101'),detdate),
How do i modify the above code to accomplish the second condition above
Default value notbeing saved using NULLIF
Posted - 2011-10-11 : 12:40:20
