|
pnonell
Starting Member
Spain
45 Posts |
 Posted - 01 August 2001 : 07:56:39
|
We think it´s only a SQL problem. We fix with this:
Inc_profile.asp
Line 100
strSql = strSql & ", " & strMemberTablePrefix & "MEMBERS.M_SIG"
strsql = strsql & ", " & strMemberTablePrefix & "MEMBERS.M_HOBBIES"
strsql = strsql & ", " & strMemberTablePrefix & "MEMBERS.M_LNEWS"
strsql = strsql & ", " & strMemberTablePrefix & "MEMBERS.M_QUOTE"
strsql = strsql & ", " & strMemberTablePrefix & "MEMBERS.M_BIO"
SQL Error: M_SIG must to be before M_hobbies, etc.
Pop_DELETE.ASP
' strSql = strSql & " WHERE " & strTablePrefix & "REPLY.T_STATUS <= 1 "
strSql = strSql & " WHERE " & strTablePrefix & "REPLY.R_STATUS <= 1 "
Change T_Status -> R_STATUS
Bye
Pedro Nonell
pnonell@reingex.com
www.reingex.com
In the next days we publish our Snitz forum |
|
Topic Locked
