Author |
Topic |
|
RichLondoner
Starting Member
United Kingdom
43 Posts |
Posted - 31 October 2003 : 07:04:49
|
Hi all,
Working fine with MS SQL and the Avatar Mod, but I have added the Poll Mod and now it will display the categories, and list the topics in any category, but as soon as I click on any of the topics I get:
ADODB.Recordset error '800a0cc1'
Item cannot be found in the collection corresponding to the requested name or ordinal.
topic.asp, line 142
I've looked at line 142 in the topic.asp and it says:
Member_Avatar = rsTopic("M_AVATAR_URL")
I've looked in the DB, and the M_AVATAR_URL field is there.
Has anybody got any ideas on how to solve this problem as I'm lost and don't really want to have to remove all the Poll Mod changes as it will take ages...
Thanks, Richard |
Richard Mills http://www.mysector.co.uk |
|
DavidRhodes
Senior Member
United Kingdom
1222 Posts |
Posted - 31 October 2003 : 07:30:25
|
make sure you added M_AVATAR_URL to the select statement, probably in a variable called strSql.
Upload a text version of your code and post the link here if you are still having problems |
The UK MkIVs Forum |
Edited by - DavidRhodes on 31 October 2003 07:32:25 |
|
|
RichLondoner
Starting Member
United Kingdom
43 Posts |
Posted - 31 October 2003 : 07:51:13
|
quote: Originally posted by DavidRhodes
make sure you added M_AVATAR_URL to the select statement, probably in a variable called strSql.
Upload a text version of your code and post the link here if you are still having problems
Thank you, just added the M_AVATAR_URL to the strSql = statement which the Poll Mod had changed and everything seems to be working fine... |
Richard Mills http://www.mysector.co.uk |
|
|
|
Topic |
|