x/website/_content/doc: missing error value in querying example

[denpeshkov]

What is the URL of the page with the issue?

https://go.dev/doc/database/querying

What is your user agent?

Safari 17.2.1

Screenshot

What did you expect to see?

func canPurchase(id int, quantity int) (bool, error) {
    var enough bool
    // Query for a value based on a single row.
    if err := db.QueryRow("SELECT (quantity >= ?) from album where id = ?",
        quantity, id).Scan(&enough); err != nil {
        if err == sql.ErrNoRows {
            return false, fmt.Errorf("canPurchase %d: unknown album", id)
        }
        return false, fmt.Errorf("canPurchase %d: %v", id, err)
    }
    return enough, nil
}

What did you see instead?

func canPurchase(id int, quantity int) (bool, error) {
    var enough bool
    // Query for a value based on a single row.
    if err := db.QueryRow("SELECT (quantity >= ?) from album where id = ?",
        quantity, id).Scan(&enough); err != nil {
        if err == sql.ErrNoRows {
            return false, fmt.Errorf("canPurchase %d: unknown album", id)
        }
        return false, fmt.Errorf("canPurchase %d: %v", id)
    }
    return enough, nil
}

[dmitshur]

CC @bradfitz, @kardianos.

[dmitshur]

Thanks for reporting. Adding Suggested label since this looks like a good small issue if someone would like to contribute a fix.

[gopherbot]

Change https://go.dev/cl/555016 mentions this issue: _content: fix code snippet