[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 882
  • Last Modified:

In Not Null

Hi,

Would like to know what the proper function is called for not null... i currently have:

<% IF IsNotNull(RS("memPersonalTraining")) Then %>
      <h2><% =RS("txtFirstName") %>&nbsp;<% =RS("txtLastName") %></h2>
      <% =RS("memPersonalTraining") %>
<% END IF %>

But it comes up with...
Microsoft VBScript runtime error '800a000d'

Type mismatch: 'IsNotNull'

/includes/main_content/staff_detail.asp, line 23


Thanks,
Carl
0
net-workx
Asked:
net-workx
  • 2
1 Solution
 
str_kaniCommented:
I used this function in my asp program... Check whether you could make use of it.
function check_empty(arg1)
        if arg1="" or isnull(arg1)then
                response.write ("Not Specified")
        else
                response.write (arg1)
        end if
end function
0
 
DreamMasterCommented:
<% IF Not IsNull(RS("memPersonalTraining")) Then %>
      <h2><% =RS("txtFirstName") %>&nbsp;<% =RS("txtLastName") %></h2>
      <% =RS("memPersonalTraining") %>
<% END IF %>

This should work...

Regards,
Max.
0
 
DreamMasterCommented:
Glad to have been helpful..

Regards,
Max.
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now