Mike,
This looks like it's the same problem that pops up when you don't have TOPICS.T_MESSAGE as the last field in the SELECT statement when using SQL Server.
I tested it on an Access Database (and with MSDE) and I don't have this problem.
Here is what the code looks like in the SELECT statment in pop_profile.asp:
(It's in both goEdit and goModify)
strSql = strSql & ", " & strMemberTablePrefix & "MEMBERS.M_SIG"
strsql = strsql & ", " & strMemberTablePrefix & "MEMBERS.M_HOBBIES, " & strMemberTablePrefix & "MEMBERS.M_LNEWS "
strsql = strsql & ", " & strMemberTablePrefix & "MEMBERS.M_QUOTE, " & strMemberTablePrefix & "MEMBERS.M_BIO "
You might try moving "MEMBERS.M_SIG" after "MEMBERS.M_BIO " and see if that works.
Edited by - Richard Kinser on 01 February 2001 18:32:17
Forum Locked
Topic Locked
Posted - 01 February 2001 : 17:17:00
