- st=m_db->Prepare("SELECT IdentityID,Name,LocalMessageTrust,PeerMessageTrust,LocalTrustListTrust,PeerTrustListTrust,PublicKey FROM tblIdentity ORDER BY Name COLLATE NOCASE LIMIT "+startrowstr+","+rowsperpagestr+";");\r
+ sql="SELECT IdentityID,Name,LocalMessageTrust,PeerMessageTrust,LocalTrustListTrust,PeerTrustListTrust,PublicKey FROM tblIdentity";\r
+ if(namesearch!="")\r
+ {\r
+ sql+=" WHERE Name LIKE '%' || ? || '%'";\r
+ }\r
+ sql+=" ORDER BY Name COLLATE NOCASE LIMIT "+startrowstr+","+rowsperpagestr+";";\r
+ st=m_db->Prepare(sql);\r
+ if(namesearch!="")\r
+ {\r
+ st.Bind(0,namesearch);\r
+ }\r