quote:

---

Originally posted by GauravBhabu

I think the code works but seems to be not working because of the where condition in the sql

strSql = strSql & " WHERE FORUM_MEMBERS.M_PHOTO_URL <> ''"

---

strSql = "SELECT M.MEMBER_ID, M.M_PHOTO_URL, M.M_NAME, "
strSql = strSql & "M.M_FIRSTNAME, M.M_LASTNAME, M.M_AGE "  
strSql = strSql & "FROM " & strMemberTablePrefix & "MEMBERS M "
'strSql = strSql & "WHERE M.M_PHOTO_URL <> ''"