Reply to thread

Message: [QUOTE="David, post: 2879195"] Cool, You can probably see that I have a function to build the cmd.parameters. I am passing the value (even if it is null) into the parameters. In my function, I am now checking if the passed parameter is null and if so, convert it to DBNull.Value. In thoery, it will make my code slightly slower I suppose (being checked for every parameter being passed) but I think it is a much better way of coding around the problem. Incidentally, I tried with a value that doesn't exist in my DB. This worked even though no returned records. That means that the value was meant to be a DBNull, not just any old null (quite what the difference is between them, I don't know.) -- Best regards, Dave Colliver. [URL]http://www.AshfieldFOCUS.com[/URL] ~~ [URL]http://www.FOCUSPortals.com[/URL] - Local franchises available [/QUOTE]