datatable.select to find Null values

[chris123321]

I need to find the rows that have PlatformId, RoleCd, and ContactId as null values.

Here is the code:

foundRows = tdtReportPermissions.Select("PlatformID_F = '" & drUserInfo.IsPlatformIdNull & "'" & _
                                        " AND RoleCD_F  = '" & drUserInfo.IsUserRoleDescNull & "'" & " AND ContactID_F = '" & _
                                        drUserInfo.IsContactIdNull & "'")

The error I'm getting is: Cannot perform '=' operation on System.Int32 and System.String

 

[MacLeod72]

I believe you want:

foundRows = tdtReportPermissions.Select("PlatformID_F IS NULL AND RoleCD_F  = IS NULL AND ContactID_F = IS NULL")

--Rob

 

[jbenson001]

I belive it is just IS NULL with out the preceeding =

 

[MacLeod72]

You're right; I had cut-and-paste issues. The correct code is:

foundRows = tdtReportPermissions.Select("PlatformID_F IS NULL AND RoleCD_F IS NULL AND ContactID_F IS NULL")

Sorry!

--Rob

 

[jbenson001]

lol.. no problem..