From line# 158 to line#195:
select case SortMethod
case "nameasc"
strSql4 = " ORDER BY M_NAME ASC"
case "namedesc"
strSql4 = " ORDER BY M_NAME DESC"
case "avatarasc"
strSql4 = " ORDER BY M_AVATAR_URL ASC"
case "avatardesc"
strSql4 = " ORDER BY M_AVATAR_URL DESC"
case "genderasc"
strSql4 = " ORDER BY M_SEX ASC, M_NAME ASC"
case "genderdesc"
strSql4 = " ORDER BY M_SEX DESC, M_NAME DESC"
case "levelasc"
strSql4 = " ORDER BY M_TITLE ASC, M_NAME ASC"
case "leveldesc"
strSql4 = " ORDER BY M_TITLE DESC, M_NAME ASC"
case "lastpostdateasc"
strSql4 = " ORDER BY M_LASTPOSTDATE ASC, M_NAME ASC"
case "lastpostdatedesc"
strSql4 = " ORDER BY M_LASTPOSTDATE DESC, M_NAME ASC"
case "lastheredateasc"
strSql4 = " ORDER BY M_LASTHEREDATE ASC, M_NAME ASC"
case "lastheredatedesc"
strSql4 = " ORDER BY M_LASTHEREDATE DESC, M_NAME ASC"
case "dateasc"
strSql4 = " ORDER BY M_DATE ASC, M_NAME ASC"
case "datedesc"
strSql4 = " ORDER BY M_DATE DESC, M_NAME ASC"
case "countryasc"
strSql4 = " ORDER BY M_COUNTRY ASC, M_NAME ASC"
case "countrydesc"
strSql4 = " ORDER BY M_COUNTRY DESC, M_NAME ASC"
case "postsasc"
strSql4 = " ORDER BY M_POSTS ASC, M_NAME ASC"
case else
strSql4 = " ORDER BY M_POSTS DESC, M_NAME ASC"
end select
where you have M_NAME, you will have to replace M_FIRSTNAME and M_LASTNAME. For example, if you have M_NAME ASC, you need to replace it by M_FIRSTNAME ASC, M_LASTNAME ASC
HTH
Topic Locked
Posted - 25 July 2003 : 15:18:22
