entityMap|0|type|LINK|mutability|MUTABLE|data|url|https://postgrest.org/en/stable/api.html#singular-or-plural|blocks|key|1qmp8|text|如果您希望结果不会有单个响应，则调用不带.single()的查询。那么你应该得到一个空的结果。|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|5p8s0|或者uid值不存在于您的数据库中！|fredl|尝试用.limit(1)替换.single()，|2jqpb|别忘了这个函数返回一个数组！所以你必须像这样获取数据，如果不存在数据，那么value.data将是一个空数组[]。|9i6dg|但是，如果您希望获得0行，则可能需要使用.maybeSingle()。|bv78a|请阅读：https://postgrest.org/en/stable/api.html#singular-or-plural|c3v7v^0|K|9|0|2|3|0|3|9|E|9|0|11|A|1I|2|0|K|E|0|4|1N|0|0^^$0|$1|$2|3|4|5|6|$7|8]]]|9|@$A|B|C|D|2|E|F|X|G|@$H|Y|I|Z|J|K]]|L|@]|6|$]]|$A|M|C|N|2|E|F|10|G|@$H|11|I|12|J|K]]|L|@]|6|$]]|$A|O|C|P|2|E|F|13|G|@$H|14|I|15|J|K]|$H|16|I|17|J|K]]|L|@]|6|$]]|$A|Q|C|R|2|E|F|18|G|@$H|19|I|1A|J|K]|$H|1B|I|1C|J|K]]|L|@]|6|$]]|$A|S|C|T|2|E|F|1D|G|@$H|1E|I|1F|J|K]]|L|@]|6|$]]|$A|U|C|V|2|E|F|1G|G|@]|L|@$H|1H|I|1I|A|1J]]|6|$]]|$A|W|C|-4|2|E|F|1K|G|@]|L|@]|6|$]]]]

If are expecting a result to not have a single response, call the query without <code>.single()</code>. You should get an empty result then.
Or maybe the <code>uid</code> value doesn't exit in your database!
Try to replace <code>.single()</code> with <code>.limit(1)</code>,
Don't forget this function returns an array! So you have to get the data like this <code>value.data[0]</code>, If no data exist then the <code>value.data</code> will be an empty array <code>[]</code>.
If you expect to get 0 rows though you might want to use <code>.maybeSingle()</code> instead.
Read this:
<a href="https://postgrest.org/en/stable/api.html#singular-or-plural" rel="nofollow noreferrer">https://postgrest.org/en/stable/api.html#singular-or-plural</a>

entityMap|blocks|key|5m23c|text|只是来澄清一下。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|49lhv|如果你使用single()过滤器，你的结果必须返回1并且只返回1个结果，否则它将失败。如果你想要多个返回值，你可以像这样去掉single()：|offset|length|style|CODE|68i3o|getResponse(String+uid)+async+{
++++await+client
++++++++.from("privChatRoom")
++++++++.select()
++++++++.eq('userID',+uid)
++++++++.execute()
++++++++.then((value)+{
++++++if+(value.error+==+null)+{
++++++++print('value.data:+${value.data}');
++++++}+else+{
++++++++print(value.error.message.toString());
++++++++print(value.error.hint.toString());
++++++}
++++});
++}|code-block|syntax|javascript|bh6er^0|0|5|8|1Q|8|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|O|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|P|9|@$E|Q|F|R|G|H]|$E|S|F|T|G|H]]|A|@]|B|$]]|$2|I|4|J|6|K|8|U|9|@]|A|@]|B|$L|M]]|$2|N|4|-4|6|7|8|V|9|@]|A|@]|B|$]]]]

Just here to clarify.
If you use <code>single()</code> filter, your result has to return 1 and only 1 result, and otherwise it will fail. If you want multiple return values, you can just get rid of the <code>single()</code> like this:
<pre class="lang-dart prettyprint-override"><code>getResponse(String uid) async {
 await client
 .from(&quot;privChatRoom&quot;)
 .select()
 .eq('userID', uid)
 .execute()
 .then((value) {
 if (value.error == null) {
 print('value.data: ${value.data}');
 } else {
 print(value.error.message.toString());
 print(value.error.hint.toString());
 }
 });
 }
</code></pre>

entityMap|blocks|key|bim7n|text|我不是flutter用户，但使用.single()的工作方式应该与在Javascript客户端中相同。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|9b4cs|.limit(1)+<=以数组[{id:123,firstname:'Harry',lastname:'Styles'}]的形式返回单个记录|b371v|.single()+<=将单个记录作为对象{id:123,firstname:'Harry',lastname:'Styles'}返回|26bh0^0|G|9|0|0|9|F|1A|0|0|9|L|18|0^^$0|$]|1|@$2|3|4|5|6|7|8|L|9|@$A|M|B|N|C|D]]|E|@]|F|$]]|$2|G|4|H|6|7|8|O|9|@$A|P|B|Q|C|D]|$A|R|B|S|C|D]]|E|@]|F|$]]|$2|I|4|J|6|7|8|T|9|@$A|U|B|V|C|D]|$A|W|B|X|C|D]]|E|@]|F|$]]|$2|K|4|-4|6|7|8|Y|9|@]|E|@]|F|$]]]]

I'm not a flutter user, but using <code>.single()</code> should work the same way as in the Javascript client.
<code>.limit(1)</code> &lt;= returns a single record as an array
<code>[{id:123,firstname:'Harry',lastname:'Styles'}]</code>
<code>.single()</code> &lt;= returns a single record as an object
<code>{id:123,firstname:'Harry',lastname:'Styles'}</code>

I am trying to print out multiple data from Supabase using flutter but it just isn't working
<pre><code>getResponse(String uid) async {
 await client
 .from(&quot;privChatRoom&quot;)
 .select()
 .eq('userID', uid)
 .single()
 .execute()
 .then((value) {
 if (value.error == null) {
 print('value.data: ${value.data}');
 } else {
 print(value.error.message.toString());
 print(value.error.hint.toString());
 }
 });
 }
</code></pre>
This is the error i get whenever i run this function
<pre><code>I/flutter ( 2326): JSON object requested, multiple (or no) rows returned
I/flutter ( 2326): null
</code></pre>
I have multiple row with the same uid that i want to get please how do i get it
EDIT: Found the answer i just had to remove <code>.single()</code>

supabase flutter get multiple data (JSON object requested, multiple (or no) rows returned)

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋 

腾讯云代码助手

CODING DevOps

Cloud Studio

SDK中心

API中心

命令行工具

 我尝试使用flutter从Supabase打印出多个数据，但就是不起作用 getResponse(String uid) async {    await client        .from("privChatRoom")        .select()        .eq('userID', uid)   ...

问supabase获取多个数据(请求JSON对象，返回多(或无)行)
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问supabase获取多个数据(请求JSON对象，返回多(或无)行)EN