我寫這封信，我正在獲取的列表中的應(yīng)用程序Facebook上的朋友使用Hackbook示例代碼，但現(xiàn)在我想獲取的名單Facebook上的朋友當(dāng)月的生日，讓我使用這個代碼的所有好友列表： public static void requestFriends(FacebookRequest facebookRequest) { Log.d(LOG_TAG, "requestFriends(" + ")"); String query = "select name, birthday, uid, pic_square from user where uid in (select uid2 from friend where uid1=me()) order by birthday_date"; Bundle params = new Bundle(); params.putString("method", "fql.query"); params.putString("query", query); FacebookUtility.asyncRunner.request(null, params, new FacebookRequestListener(FacebookRequestListener.FRIENDS, facebookRequest));}我仍然使用下面的代碼來獲取當(dāng)月生日的朋友列表： Calendar c = Calendar.getInstance(); int month = c.get(Calendar.MONTH)+ 1; String query = "select name, birthday, uid, pic_square from user where uid in " + "(select uid2 from friend where uid1=me())AND birthday_date >= '" + month + "/01' AND birthday_date <= '" + month + "/31' ORDER BY birthday_date ASC";但是我沒有任何記錄，我在哪里失蹤？
3 回答
慕妹3146593
TA貢獻(xiàn)1820條經(jīng)驗(yàn) 獲得超9個贊
使用此查詢以升序獲取當(dāng)前月份的Facebook朋友。
SELECT name, birthday, uid, pic_square FROM user WHERE uid in (SELECT uid2 FROM friend WHERE uid1=me())AND birthday_date >= '01/01/2013' AND birthday_date <= '31/01/2013' ORDER BY birthday_date
GCT1015
TA貢獻(xiàn)1827條經(jīng)驗(yàn) 獲得超4個贊
我同意您僅獲得一月的生日，我可以使用以下查詢字符串：String ModifyQuery =“ SELECT uid，name，pic_square，birthday_date來自用戶WHERE uid IN（SELECT uid2來自好友WHERE uid1 = me（））AND Birthday_date> = '01 / 01'AND Birthday_date <= '01 / 31'ORDER BY Birthday_date ASC“，但我想讓它更具動感..
- 3 回答
- 0 關(guān)注
- 750 瀏覽
添加回答
舉報
0/150
提交
取消