duanluo5096 2015-08-25 10:03
浏览 867
已采纳

我怎么能在执行err == sql.ErrNoRows时无法使用* sql.Row类型作为类型错误

I was trying to follow the example in the answer given here: Golang: How to check for empty array (array of struct)

on how to check if a database return is empty

So I have this:

err = db.QueryRow("SELECT FROM accounts WHERE steamid=?", steamid)
switch {
        case err == sql.ErrNoRows:
        case err != nil:
        default:
                //do stuff
}

But I get the error:

cannot use db.QueryRow("SELECT FROM accounts WHERE steamid=?", steamid) (type *sql.Row) as type error in assignment:
    *sql.Row does not implement error (missing Error method)

Not sure why it worked in his example but not when I try to implement it. Thanks.

  • 写回答

1条回答 默认 最新

  • douang4294 2015-08-25 10:09
    关注

    You've missed the Scan part of the example, which actually returns an error:

    err := db.QueryRow("SELECT ...").Scan(&id, &secret, &shortname)
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥20 matlab可以把多个二维图合成为三维瀑布图吗
  • ¥15 EEPROM,软件i2c
  • ¥500 求解读该段JS代码,需要知道是用干什么的
  • ¥20 qt4代码实现二进制文件读取显示,以及显示的内容进行搜索
  • ¥15 Labview获取LK-G3001数据
  • ¥15 我知道什么是混合树,但是怎么写代码啊
  • ¥50 开发板linux系统安装dpkg,apt函数库 有偿
  • ¥15 浏览器时间循环 交互事件和延时事件的 优先级与执行问题
  • ¥15 GD模块安装出错,libgd无法正常安装
  • ¥20 求有缘人帮我把笛卡尔坐标系转换为经纬度 有偿