I'm geeting the following message:
Microsoft VBScript runtime error '800a005e'
Invalid use of Null: 'CINT'
on this line:
If CINT(rsSecondary.Fields("subjectid").Value) = CINT(rsMain.Fields("subjectid").Value) then
Response.Write (rsSecondary.Fields("MSGBID") & rsSecondary.Fields("subject"))
My first record set rsSecondary just does a select of 4 fields
My second record set does a select of 6 fields then I'm trying to display results where the subjectid fields are joined
I've never had this error before so I'm a little unsure where to start - I should say I get data displayed but only the first two records out of five that should get displayed in my test db then I get the error message. Also, all my subjectids are less then 100 so it's not like I have to change to CLNG