fql join;我可以使用FQL加入两个表吗？ [英] fql join; can i join two tables with FQL?
本文介绍了fql join;我可以使用FQL加入两个表吗？的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
<！DOCTYPE html>
< html>
< body>
< div id =fb-root>< / div>
< a href =＃onclick =getPhotos（）; return false;>获取照片< / a>
< script src =http://connect.facebook.net/en_US/all.js>< / script>
< script>
FB.init（{appId：'yourAppID'，status：true，cookie：true，xfbml：true}）;
function getPhotos（）{
FB.login（function（response）{
if（response.session&& response.perms）{
var oneWeekAgo = Math.round（（new Date（）。setDate（new Date（）。getDate（） - 7））/ 1000）;
FB.api（
{
method：'fql .query'，
query：'SELECT pid，caption，aid，owner，link，src_big，src_small，created，modified FROM photo WHERE aid IN（SELECT aid FROM album WHERE owner IN（SELECT uid2 FROM friend WHERE uid1 =我创建了>'+ oneWeekAgo +'ORDER BY创建DESC LIMIT 20'
}，
函数（响应）{
alert（'照片：'+ JSON.stringify （回应））;
}
）;
}
}，{perms：'friends_photos'}）;
}
< / script>
< / body>
< / html>
解决方案
做这样的事情：
FB.api（{
方法：'fql.multiquery'，
查询：{
'query1' 'SELECT uid2 FROM friend WHERE uid1 = me（）'，
'query2'：'SELECT vid，owner，title，description FROM video WHERE owner IN（SELECT uid2 FROM＃query1）'
}
}，
函数（响应）{
//响应应该有2个对象，其中包含一个fql_result_set
//数组，其数据和您为查询输入的名称即'query1'）
alert（'照片：'+ JSON.stringify（响应））;
}）;
I have the following FQL I want to join with user table to add name field! How can I do that?After I test making normal left join I got error message (601 join not possible with FQL). How can I join and add name field????
<!DOCTYPE html>
<html>
<body>
<div id="fb-root"></div>
<a href="#" onclick="getPhotos();return false;">Get Photos</a>
<script src="http://connect.facebook.net/en_US/all.js"></script>
<script>
FB.init({ appId: 'yourAppID', status: true, cookie: true, xfbml : true });
function getPhotos() {
FB.login(function(response) {
if (response.session && response.perms) {
var oneWeekAgo = Math.round((new Date().setDate(new Date().getDate()-7)) / 1000);
FB.api(
{
method: 'fql.query',
query: 'SELECT pid, caption, aid, owner, link, src_big, src_small, created, modified FROM photo WHERE aid IN (SELECT aid FROM album WHERE owner IN (SELECT uid2 FROM friend WHERE uid1=me())) AND created > ' + oneWeekAgo + ' ORDER BY created DESC LIMIT 20'
},
function(response) {
alert('Photos: ' + JSON.stringify(response));
}
);
}
} , {perms:'friends_photos'});
}
</script>
</body>
</html>
解决方案
Do something like this:
FB.api({
method: 'fql.multiquery',
queries: {
'query1': 'SELECT uid2 FROM friend WHERE uid1 = me()',
'query2': 'SELECT vid, owner, title, description FROM video WHERE owner IN (SELECT uid2 FROM #query1)'
}
},
function(response) {
// response should have 2 objects in it, both containing an fql_result_set
// array with the data and the name you entered for the query (i.e. 'query1')
alert('Photos: ' + JSON.stringify(response));
});
这篇关于fql join;我可以使用FQL加入两个表吗？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
