{\r
clear();\r
\r
- int tempint;\r
- SQLite3DB::Statement st=m_db->Prepare("SELECT BoardID FROM tblBoard ORDER BY BoardName;");\r
+ int boardid=0;\r
+ std::string boardname="";\r
+ std::string boarddescription="";\r
+ std::string dateadded="";\r
+ std::string savereceivedstr="";\r
+ bool savereceived=false;\r
+ int highmessageid=0;\r
+ int lowmessageid=0;\r
+ int messagecount=0;\r
+ std::string addedmethod="";\r
+\r
+ SQLite3DB::Statement st=m_db->Prepare("SELECT tblBoard.BoardID, BoardName, BoardDescription, DateAdded, HighMessageID, LowMessageID, MessageCount, SaveReceivedMessages, AddedMethod FROM tblBoard LEFT JOIN vwBoardStats ON tblBoard.BoardID=vwBoardStats.BoardID ORDER BY BoardName COLLATE NOCASE;");\r
st.Step();\r
\r
while(st.RowReturned())\r
{\r
- st.ResultInt(0,tempint);\r
- push_back(Board(tempint));\r
+ st.ResultInt(0,boardid);\r
+ st.ResultText(1,boardname);\r
+ st.ResultText(2,boarddescription);\r
+ st.ResultText(3,dateadded);\r
+ st.ResultInt(4,highmessageid);\r
+ st.ResultInt(5,lowmessageid);\r
+ st.ResultInt(6,messagecount);\r
+ st.ResultText(7,savereceivedstr);\r
+ st.ResultText(8,addedmethod);\r
+\r
+ if(savereceivedstr=="true")\r
+ {\r
+ savereceived=true;\r
+ } \r
+ else\r
+ {\r
+ savereceived=false;\r
+ }\r
+\r
+ push_back(Board(boardid,boardname,boarddescription,dateadded,lowmessageid,highmessageid,messagecount,savereceived,addedmethod));\r
st.Step();\r
}\r
}\r