|
HuwR
Forum Admin
United Kingdom
20584 Posts |
 Posted - 04 March 2001 : 07:00:58
|
for an explanation of the problem, see
http://forum.snitz.com/forum/link.asp?TOPIC_ID=5872
Cause of problem.
If you are iterating through a recordset which contains Memo fields, the memo field(s) should always be the last field in the select clause.
Fix:
look for this line
'## Forum_SQL - Get all topics from DB
strSql ="SELECT " & strMemberTablePrefix & "MEMBERS.M_NAME, " & strTablePrefix & "REPLY.REPLY_ID, " & strTablePrefix & "REPLY.R_AUTHOR, " & strTablePrefix & "REPLY.TOPIC_ID, " & strTablePrefix & "REPLY.R_MESSAGE, " & strTablePrefix & "REPLY.R_DATE "
change it as follows
'## Forum_SQL - Get all topics from DB
strSql ="SELECT " & strMemberTablePrefix & "MEMBERS.M_NAME, " & strTablePrefix & "REPLY.REPLY_ID, " & strTablePrefix & "REPLY.R_AUTHOR, " & strTablePrefix & "REPLY.TOPIC_ID, " & strTablePrefix & "REPLY.R_DATE, " & strTablePrefix & "REPLY.R_MESSAGE "
|
|
Forum Locked
Topic Locked
