change nulls?

Results 1 to 3 of 3

Thread: change nulls?

  1. #1
    Curtis Guest

    Default change nulls?

    when I do a Request.Form("field") and then try to append it into a database I get an error if it is null.<BR>I&#039;ve tried:<BR>if isnull(Request.Form("field")) then<BR>var1 = " "<BR>else<BR>var1 = Request.Form("field") <BR>end if<BR><BR>how can I just leave it blank?<BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default I assume

    you are using an ACCESS db? If so set the field in the db to accept zero value.

  3. #3
    Join Date
    Dec 1969

    Default You need to go in to the database...

    open the table in design view, and set the offending field to accept zero length strings.

Posting Permissions

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