How can I convert this query in pare.com query language for android? -
select videoid, videoname, userid dbo.tblvideo (userid in (select touserid dbo.tblfriends tblfriends_2 (fromuserid = '1') , (requeststatus = 'f'))) or (userid in (select fromuserid dbo.tblfriends tblfriends_1 (touserid = '1') , (requeststatus = 'f')));
did seek utilize rawquery string?
string query = "select videoid, videoname, userid\n" + "from dbo.tblvideo\n" + "where (userid in\n" + " (select touserid\n" + " dbo.tblfriends tblfriends_2\n" + " (fromuserid = ?) , (requeststatus = ?))) or\n" + " (userid in\n" + " (select fromuserid\n" + " dbo.tblfriends tblfriends_1\n" + " (touserid = ?) , (requeststatus = ?)));"; cursor cursor = mysqllitedatabase.rawquery(query, new string[]{"1","f","1","f"});
android
No comments:
Post a Comment