The Forum has been Updated
The code has been upgraded to the latest .NET core version. Please check instructions in the Community Announcements about migrating your account.
I'm cruising up close to 20K members. That list takes what seems an eternity to load when editing forum properties. It takes around thirty seconds to generate the page because of the "Allowed Member List". Has anyone converted this to a text box to add a member instead of pulling the entire list?
Posted
Yeah, but doesn't...
strSql = "SELECT MEMBER_ID, M_NAME "
need to be...
strSql = "SELECT MEMBER_ID, M_NAME, M_POSTS "
strSql = "SELECT MEMBER_ID, M_NAME "
need to be...
strSql = "SELECT MEMBER_ID, M_NAME, M_POSTS "
Posted
No, bobby. Why do you think it does?
Posted
Hmmm... just thought you had to select it from the DB before you could use it.
So if you use it in the "where" part that's good enough?
So if you use it in the "where" part that's good enough?
Posted
In the SELECT clause you need only to include the columns you want to have in the resulting recordset. You don't need to include a column that you will only use to apply a condition, like in this case, Bobby.
Posted
Ahhh.... gotcha. Thanks.