如何检测是否没有结果

发布于 2025-02-04 04:20:00 字数 318 浏览 2 评论 0原文

我的代码

stmt.bind({$ticket:"ABCD1245"});
while (stmt.step()) console.log(stmt.get());

给出了[1]之类的结果，这是正确的

stmt.bind({$ticket:"ABCD1245a"});
while (stmt.step()) console.log(stmt.get());

，根本没有结果，这是可以的，因为不存在记录。

我如何检测是否找到记录，我尝试了stmt.numrows，但看起来不支持。

原文

My code

stmt.bind({$ticket:"ABCD1245"});
while (stmt.step()) console.log(stmt.get());

gives a result like [1], that is correct

stmt.bind({$ticket:"ABCD1245a"});
while (stmt.step()) console.log(stmt.get());

gives no result at all, which is ok, because no record exist.

How do i detect if no record was found, i tried like stmt.numrows, but looks like thats not supported.

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

红颜悴 2025-02-11 04:20:00

我以这种方式修复了它，想使用stmt.num_rows

ticket= "ABCD1245A";
        stmt.bind({$ticket:ticket});
        if(stmt.step()){
            console.log(stmt.get());
            console.log(ticket+' found');
            while (stmt.step()) console.log(stmt.get());
        }else{
            console.log('No result for '+ticket);
        }

I fixed it this way, would like to use stmt.num_rows

ticket= "ABCD1245A";
        stmt.bind({$ticket:ticket});
        if(stmt.step()){
            console.log(stmt.get());
            console.log(ticket+' found');
            while (stmt.step()) console.log(stmt.get());
        }else{
            console.log('No result for '+ticket);
        }

回复收藏 0 原文

~没有更多了~