Monday, 15 July 2013

How can I convert this query in pare.com query language for android? -



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