query.Append(historyTable);
query.Append(L".TITLE LIKE '%");
query.Append(text);
- query.Append("%')");
+ query.Append("%' ESCAPE '/')");
query.Append(" OR ");
query.Append(L"(");
query.Append(historyTable);
query.Append(L".ADDRESS LIKE '%");
query.Append(text);
- query.Append("%')");
+ query.Append("%' ESCAPE '/')");
query.Append(" ORDER BY VISITDATE DESC");
query.Append(historyTable);
query.Append(L".TITLE LIKE '%");
query.Append(text);
- query.Append("%')");
+ query.Append("% 'ESCAPE '/')");
query.Append(" OR ");
query.Append(L"(");
query.Append(historyTable);
query.Append(L".ADDRESS LIKE '%");
query.Append(text);
- query.Append("%')");
+ query.Append("%' ESCAPE '/')");
query.Append(" ORDER BY VISITDATE DESC");
r = HistoryPresentationModel::ExecuteQuery(query, count);
result
HistoryPresentationModel::GetMostVisitedSites(ArrayList& pHistoryList)
{
-
int count = -1;
String query;
String historyTable(HISTORY_DATA_TABLE);