Question about dealing with null values

Results 1 to 2 of 2

Thread: Question about dealing with null values

  1. #1
    Join Date
    Dec 1969

    Default Question about dealing with null values

    I am passing information from a database to fill out the fields in a form. If one of the database cells is null then the Error "Type mismatch: &#039;HTMLEncode&#039;" is encountered. I have tried setting the application variables to something like "?" or 9999 when a null comes back for any of the variables but the same error comes back. I would appreciate any insight into dealing with this issue. Thanks for any help.<BR>

  2. #2
    Join Date
    Dec 1969
    Los Angeles, CA

    Default Hmmm

    i guess the HTMLEncode requires a value<BR><BR><BR>many options <BR><BR>use isnull in SQL <BR>or <BR>HTMLEncode(recordset("Whatever") & "")<BR><BR><BR>but if you are filling in jsut regular controls, you MAY not really need to HTMLencode it<BR><BR>

Posting Permissions

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