entering NULL into SQL db

Results 1 to 2 of 2

Thread: entering NULL into SQL db

  1. #1
    Join Date
    Dec 1969

    Default entering NULL into SQL db

    I have a form for users to complete. Not all the fields are required. If someone leaves a field blank, how can I enter that as a null into the database? I know I can do a check first to see if the field is blank, and if it is not enter it at all. But I think there is a way to enter a null

  2. #2
    Jason Miller Guest

    Default RE: entering NULL into SQL db

    Generally I&#039ve found that the server gets annoyed when you try that. When necessary, I use a character or somesuch (&amp;nbsp;) which will be parsed back out when I query the DB for info.<BR><BR>Hope it helps.

Posting Permissions

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