Use of CLng with Null

After upgrading an 8.03 database and installing 9b1, default.asp dropped an exception around line 501. It seems it wasn't able to get the topic for any of the most recent posts. I wrapped lines 487-501 in an On Error Resume Next / On Error Goto 0 block, and got the same error again on line 583. Wrapping THOSE lines in On Error resolved the problem - the page displayed.

The problem goes away after posting a message in each forum using v9.

It seems the error just comes from v9 expecting something in the database which v8 doesn't put there; once v9 has a chance to put it there, all was well.

...

BTW, liking v9 verra much indeed. Excellent work on the File Manager, and quite a few things I'd had to hack in v8 are all fixed up. I do wish v9 would give me the OPTION of having case-sensitive passwords; we integrate with external authentication and as-is I have to go mod out all the LCase() functions around passwords.

FWIW, v9 is MUCH easier to integrate with our external user database, the way I have it (the external database) rigged; there's practically no modding of the code required apart from the LCase() thing. If you're interested, here's the current hack list:

- Remove FAQ button in status bar
- Change REGISTER button in status bar to go to MY reg page
- Removing LCase() in a few spots to permit case-sensitive passwords

Wow, that's it! I've got my user database (external) triggered to auto-create users, with passwords, in the WWF Authors table, so everything else works very snazzily.