Reset DB field to blank

Results 1 to 3 of 3

Thread: Reset DB field to blank

  1. #1
    Bob Newsome Guest

    Default Reset DB field to blank

    When I try to execute a line like:<BR><BR> objRS.("comment") = ""<BR><BR>then:<BR><BR> objRS.update<BR><BR>I receive the following courtesy message:<BR><BR> [Microsoft][ODBC Microsoft Access 97 Driver]<BR> Field &#039;survey.comment&#039; can&#039;t be a zero-length<BR> string.<BR><BR>I am trying to update an Access97 database field<BR>and after running the HTML form field contents<BR>through a filter removing commas, carriage<BR>returns, etc. I might end up with a zero length<BR>variable if the submitted field is empty. I know<BR>the obvous answer is to test for zero length and<BR>not update the field. The problem is how do I<BR>restore the database field to an empty state if it<BR>already contains something?<BR><BR>I would prefer not using a space character or<BR>something similar.<BR>

  2. #2
    Nils Bilhorn Guest

    Default RE: Reset DB field to blank

    Use null

  3. #3
    Bob Newsome Guest

    Default RE: Reset DB field to blank

    Thank you Nils, worked like a charm.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts