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
net-workxAsked:
Who is Participating?
 
DreamMasterConnect With a Mentor Commented:
<% IF Not IsNull(RS("memPersonalTraining")) Then %>
      <h2><% =RS("txtFirstName") %>&nbsp;<% =RS("txtLastName") %></h2>
      <% =RS("memPersonalTraining") %>
<% END IF %>

This should work...

Regards,
Max.
0
 
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:
Glad to have been helpful..

Regards,
Max.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.