Hi gvee, thats brilliant thank you. It makes more sense now. It almost feels like paper, stone, scissors - with the 'unknown' above all else.
I think i learn better when things are broken down like that.
Thank you for taking the time to explain that, much appreciated dude.
Also, i have realised why my oringinal code was not working. It was due to the placement of the VBScript that executed the SQL, but it has now been sorted, and a new error has come up:
Microsoft OLE DB Provider for ODBC Drivers error '80040e07'
[Microsoft][ODBC SQL Server Driver][SQL Server]Error converting data type varchar to int.
/aform/V3/default.asp, line 360
tyring to solve this now.
Thank you once again.
Regards
MG
Quote:
Originally Posted by gvee
What I've tried to do here is to highlight to you what a null is (an unknown value, not equal to anything) and how it differs from an blank string.
This is why we do not get a true or false value when comparing things to null; we get another unknown result!
Luckily, we can ask this question: Is this value unknown? I.e. is this value a null?
So if you look back at my first post in this thread, I have used a lovely function called IsNull() that performs this check.
I know we've taken a pretty windy route, but I hope it has explained to you why your intial code wasn't working as you'd expected.
As always, come back with any questions you have  |