Re: HTMLEncode problems on null values...

  •  10-11-2005, 2:39 PM

    Re: HTMLEncode problems on null values...

    You could also modify your sql statement to use the isnull() function...  this would place the onus on the db server (where it belongs)...

    In the select statement, you'd have something like:  select id, isnull(fldName,'') where... etc.  The isnull function returns the contents of the field if it ISN'T null, and the 2nd parameter (empty) if it is.
View Complete Thread