Invalid use of null error

[aman1234]

Hi guys

I am getting an error message at the following line of code. Any help would be much appreciated.

Please Login or Register  to view this content.

Thanks
Aman

[OllieB]

Aman,

Where to start;
- is the cn object valid?
- is the rs object valid?
- is a record returned by the sql statement?

If you answered all questions with yes then try

Please Login or Register  to view this content.

[aman1234]

Thanks Ollie. It worked perfectly.

[OllieB]

You are welcome. May I please ask you to mark this thread as solved and remember that you can click the star icon to add to my reputation if you are happy with my contribution.