variables.DSN = "commonspot-users";
var qryData = QueryNew("temp");
var groupStruct = StructNew();
var groupArray = ArrayNew(1);
SELECT ID, GroupName, Description, SourceDB, TransactionDate, GroupType
FROM idGroup
WHERE ID =
if ( qryData.RecordCount GT 0 )
groupArray = Application.ptForum.data.queryToArrayOfStructures(qryData);
if ( ArrayLen(groupArray) )
groupStruct = groupArray[1];
var groupName = getCSGroupInfoByGroupID(arguments.GroupID);
if ( Len(Trim(groupName)) EQ 0 )
groupName = '[group name error]';
var qryData = QueryNew("temp");
var groupNameList = '';
SELECT ID, GroupName
FROM idGroup
WHERE ID IN ()
if ( qryData.RecordCount GT 0 )
groupNameList = ValueList(qryData.GroupName);