multiple-value .Exec() in single-value context with Golang sql

Question

I am trying to update multiple values in a single row in an SQLite3 database using golang and the standard sql driver but am having trouble debugging the following error:

 command-line-arguments
./server.go:169: multiple-value updateStatement.Exec() in single-value context

The relevant code is as follows (irrelevant code has been omitted):

SQL Statement:

const (
    rsvpSubmit = "UPDATE rsvp SET Name = ?, Rsvp = ?, Guests = ?, Meal0 = ?, Meal1 = ?, Comments = ?, ModifiedAt = ? WHERE email = ?"
)

var (
    updateStatement *sql.Stmt
)

errr := updateStatement.Exec(
    r.FormValue("name"),
    r.FormValue("rsvp"),
    r.FormValue("guests"),
    r.FormValue("meal0"),
    r.FormValue("meal1"),
    r.FormValue("comments"),
    time.Now(),
    cookie.Value)

The database has the following columns (which the struct replicates):

    type User struct {
        Id         int
        Email      string
        Name       sql.NullString
        Rsvp       sql.NullInt64
        Guests     sql.NullInt64
        Meal0      sql.NullString
        Meal1      sql.NullString
        Comments   sql.NullString
        ModifiedAt sql.NullString
    }

Any help is greatly appreciated!

OneOfOne · Accepted Answer · 2014-10-03 16:27:19Z

4

Stmt.Exec is defined as:

func (s *Stmt) Exec(args ...interface{}) (Result, error)

if you don't care about the result then you can use _, err := updateStatement.Exec(...)

answered Oct 3, 2014 at 16:27

OneOfOne

100k22 gold badges195 silver badges187 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

multiple-value .Exec() in single-value context with Golang sql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related