I've a SQL statement that works fine in Access 97, SQL Server 2000 and Query Analyzer. However when I put it onto my ASP page it is just simply as if it's being ignored. I think it has to do with the last part:
WHERE (UsersSkills.SkillID IS NULL)
It doesn't seem to do anything with the IS NULL part. I've tried '= NULL' I've tried IS 'NULL', = 'NULL', = "", IS "" but nothing seems to work.
It's really frustrating when something works everywhere else but not in the place it needs to! Anyone any ideas?
"Life is like a Ferrari, it goes to fast.
But that's ok, because you can't afford it anyway" - Jim Davis (Garfield)
WHERE (UsersSkills.SkillID IS NULL)
It doesn't seem to do anything with the IS NULL part. I've tried '= NULL' I've tried IS 'NULL', = 'NULL', = "", IS "" but nothing seems to work.
It's really frustrating when something works everywhere else but not in the place it needs to! Anyone any ideas?
"Life is like a Ferrari, it goes to fast.
But that's ok, because you can't afford it anyway" - Jim Davis (Garfield)