Go Lang, Postgres: cannot get oid after Scan
I have 2 columns if table accounts:
oid and balance
By the next code I try to extract oid then balance:
// variable `id` comes from an another part
sqlstr := `SELECT * ` +
`FROM accounts ` +
`WHERE oid=` + id + `;`
q, err := db.Query(sqlstr)
if err != nil {
fmt.Println("Error: GetAccount n", err)
return Account{}, err
}
defer q.Close()
var _id string
var bal float64
q.Next()
q.Scan(&_id)
fmt.Println("_id ", _id)
q.Next()
q.Scan(&bal)
fmt.Println("bal ", bal)
After the first q.Next() I expected to extract oid and after the second to extract balance.
But every time after the first q.Next() and after the second I only get balance.
I tried to change sqlstr to the next:
sqlstr := `SELECT oid, balance ` +
`FROM accounts ` +
`WHERE oid=` + id + `;`
But I still cannot extract oid.
postgresql
go psql asked Nov 12 at 16:34
Alex Chaliy
748
add a comment |
I have 2 columns if table accounts:
oid and balance
By the next code I try to extract oid then balance:
// variable `id` comes from an another part
sqlstr := `SELECT * ` +
`FROM accounts ` +
`WHERE oid=` + id + `;`
q, err := db.Query(sqlstr)
if err != nil {
fmt.Println("Error: GetAccount n", err)
return Account{}, err
}
defer q.Close()
var _id string
var bal float64
q.Next()
q.Scan(&_id)
fmt.Println("_id ", _id)
q.Next()
q.Scan(&bal)
fmt.Println("bal ", bal)
After the first q.Next() I expected to extract oid and after the second to extract balance.
But every time after the first q.Next() and after the second I only get balance.
I tried to change sqlstr to the next:
sqlstr := `SELECT oid, balance ` +
`FROM accounts ` +
`WHERE oid=` + id + `;`
But I still cannot extract oid.
postgresql
go psql asked Nov 12 at 16:34
Alex Chaliy
748
add a comment |
I have 2 columns if table accounts:
oid and balance
By the next code I try to extract oid then balance:
// variable `id` comes from an another part
sqlstr := `SELECT * ` +
`FROM accounts ` +
`WHERE oid=` + id + `;`
q, err := db.Query(sqlstr)
if err != nil {
fmt.Println("Error: GetAccount n", err)
return Account{}, err
}
defer q.Close()
var _id string
var bal float64
q.Next()
q.Scan(&_id)
fmt.Println("_id ", _id)
q.Next()
q.Scan(&bal)
fmt.Println("bal ", bal)
After the first q.Next() I expected to extract oid and after the second to extract balance.
But every time after the first q.Next() and after the second I only get balance.
I tried to change sqlstr to the next:
sqlstr := `SELECT oid, balance ` +
`FROM accounts ` +
`WHERE oid=` + id + `;`
But I still cannot extract oid.
postgresql
go psql asked Nov 12 at 16:34
Alex Chaliy
748
I have 2 columns if table accounts:
oid and balance
By the next code I try to extract oid then balance:
// variable `id` comes from an another part
sqlstr := `SELECT * ` +
`FROM accounts ` +
`WHERE oid=` + id + `;`
q, err := db.Query(sqlstr)
if err != nil {
fmt.Println("Error: GetAccount n", err)
return Account{}, err
}
defer q.Close()
var _id string
var bal float64
q.Next()
q.Scan(&_id)
fmt.Println("_id ", _id)
q.Next()
q.Scan(&bal)
fmt.Println("bal ", bal)
After the first q.Next() I expected to extract oid and after the second to extract balance.
But every time after the first q.Next() and after the second I only get balance.
I tried to change sqlstr to the next:
sqlstr := `SELECT oid, balance ` +
`FROM accounts ` +
`WHERE oid=` + id + `;`
But I still cannot extract oid.
postgresql
go psql postgresql
go psql asked Nov 12 at 16:34
Alex Chaliy
748
asked Nov 12 at 16:34
Alex Chaliy
748
asked Nov 12 at 16:34
Alex Chaliy
748
asked Nov 12 at 16:34
Alex Chaliy
748
asked Nov 12 at 16:34
Alex Chaliy
748
748
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
Try this q.Scan(&_id, &bal), func (*Row) Scan has this signature:
func (r *Row) Scan(dest ...interface{}) error
It expects the the pointers to the values where it will store the queried data.
If you are only querying for a single row, there is func (*DB) QueryRow(). Then your code will simplify to
row := db.QueryRow(sqlstr)
err := row.Scan(&_id, &bal)
// err will be sql.ErrNoRows if no rows have been selected
answered Nov 12 at 17:16
ssemilla
3,077424
It says:sql: expected 1 destination arguments in Scan, not 2
– Alex Chaliy
Nov 13 at 12:01
What exact PG library are you using? Is it this one: github.com/lib/pq? How are you opening your database connection?
– ssemilla
Nov 13 at 12:04
Are you opening your DB connection like this:db, err := sql.Open("postgres", connStr)?
– ssemilla
Nov 13 at 12:06
I usegithub.com/lib/pqas DB driver, but to connect DB I usegithub.com/xo/dburl
– Alex Chaliy
Nov 13 at 12:07
1
So the solution is to useoid, balanceinstead of*in sql query string, to usedb.QueryRow()instead ofdb.Query(), and to userow.Scan(&_id, &bal)according tooid, balancein sql query string.
– Alex Chaliy
Nov 13 at 12:28
|
show 3 more comments
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53266413%2fgo-lang-postgres-cannot-get-oid-after-scan%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Try this q.Scan(&_id, &bal), func (*Row) Scan has this signature:
func (r *Row) Scan(dest ...interface{}) error
It expects the the pointers to the values where it will store the queried data.
If you are only querying for a single row, there is func (*DB) QueryRow(). Then your code will simplify to
row := db.QueryRow(sqlstr)
err := row.Scan(&_id, &bal)
// err will be sql.ErrNoRows if no rows have been selected
answered Nov 12 at 17:16
ssemilla
3,077424
It says:sql: expected 1 destination arguments in Scan, not 2
– Alex Chaliy
Nov 13 at 12:01
What exact PG library are you using? Is it this one: github.com/lib/pq? How are you opening your database connection?
– ssemilla
Nov 13 at 12:04
Are you opening your DB connection like this:db, err := sql.Open("postgres", connStr)?
– ssemilla
Nov 13 at 12:06
I usegithub.com/lib/pqas DB driver, but to connect DB I usegithub.com/xo/dburl
– Alex Chaliy
Nov 13 at 12:07
1
So the solution is to useoid, balanceinstead of*in sql query string, to usedb.QueryRow()instead ofdb.Query(), and to userow.Scan(&_id, &bal)according tooid, balancein sql query string.
– Alex Chaliy
Nov 13 at 12:28
|
show 3 more comments
Try this q.Scan(&_id, &bal), func (*Row) Scan has this signature:
func (r *Row) Scan(dest ...interface{}) error
It expects the the pointers to the values where it will store the queried data.
If you are only querying for a single row, there is func (*DB) QueryRow(). Then your code will simplify to
row := db.QueryRow(sqlstr)
err := row.Scan(&_id, &bal)
// err will be sql.ErrNoRows if no rows have been selected
answered Nov 12 at 17:16
ssemilla
3,077424
It says:sql: expected 1 destination arguments in Scan, not 2
– Alex Chaliy
Nov 13 at 12:01
What exact PG library are you using? Is it this one: github.com/lib/pq? How are you opening your database connection?
– ssemilla
Nov 13 at 12:04
Are you opening your DB connection like this:db, err := sql.Open("postgres", connStr)?
– ssemilla
Nov 13 at 12:06
I usegithub.com/lib/pqas DB driver, but to connect DB I usegithub.com/xo/dburl
– Alex Chaliy
Nov 13 at 12:07
1
So the solution is to useoid, balanceinstead of*in sql query string, to usedb.QueryRow()instead ofdb.Query(), and to userow.Scan(&_id, &bal)according tooid, balancein sql query string.
– Alex Chaliy
Nov 13 at 12:28
|
show 3 more comments
Try this q.Scan(&_id, &bal), func (*Row) Scan has this signature:
func (r *Row) Scan(dest ...interface{}) error
It expects the the pointers to the values where it will store the queried data.
If you are only querying for a single row, there is func (*DB) QueryRow(). Then your code will simplify to
row := db.QueryRow(sqlstr)
err := row.Scan(&_id, &bal)
// err will be sql.ErrNoRows if no rows have been selected
answered Nov 12 at 17:16
ssemilla
3,077424
Try this q.Scan(&_id, &bal), func (*Row) Scan has this signature:
func (r *Row) Scan(dest ...interface{}) error
It expects the the pointers to the values where it will store the queried data.
If you are only querying for a single row, there is func (*DB) QueryRow(). Then your code will simplify to
row := db.QueryRow(sqlstr)
err := row.Scan(&_id, &bal)
// err will be sql.ErrNoRows if no rows have been selected
answered Nov 12 at 17:16
ssemilla
3,077424
edited Nov 12 at 17:28
answered Nov 12 at 17:16
ssemilla
3,077424
answered Nov 12 at 17:16
ssemilla
3,077424
answered Nov 12 at 17:16
ssemilla
3,077424
3,077424
It says:sql: expected 1 destination arguments in Scan, not 2
– Alex Chaliy
Nov 13 at 12:01
What exact PG library are you using? Is it this one: github.com/lib/pq? How are you opening your database connection?
– ssemilla
Nov 13 at 12:04
Are you opening your DB connection like this:db, err := sql.Open("postgres", connStr)?
– ssemilla
Nov 13 at 12:06
I usegithub.com/lib/pqas DB driver, but to connect DB I usegithub.com/xo/dburl
– Alex Chaliy
Nov 13 at 12:07
1
So the solution is to useoid, balanceinstead of*in sql query string, to usedb.QueryRow()instead ofdb.Query(), and to userow.Scan(&_id, &bal)according tooid, balancein sql query string.
– Alex Chaliy
Nov 13 at 12:28
|
show 3 more comments
It says:sql: expected 1 destination arguments in Scan, not 2
– Alex Chaliy
Nov 13 at 12:01
What exact PG library are you using? Is it this one: github.com/lib/pq? How are you opening your database connection?
– ssemilla
Nov 13 at 12:04
Are you opening your DB connection like this:db, err := sql.Open("postgres", connStr)?
– ssemilla
Nov 13 at 12:06
I usegithub.com/lib/pqas DB driver, but to connect DB I usegithub.com/xo/dburl
– Alex Chaliy
Nov 13 at 12:07
1
So the solution is to useoid, balanceinstead of*in sql query string, to usedb.QueryRow()instead ofdb.Query(), and to userow.Scan(&_id, &bal)according tooid, balancein sql query string.
– Alex Chaliy
Nov 13 at 12:28
It says:
sql: expected 1 destination arguments in Scan, not 2– Alex Chaliy
Nov 13 at 12:01
It says:
sql: expected 1 destination arguments in Scan, not 2– Alex Chaliy
Nov 13 at 12:01
What exact PG library are you using? Is it this one: github.com/lib/pq? How are you opening your database connection?
– ssemilla
Nov 13 at 12:04
What exact PG library are you using? Is it this one: github.com/lib/pq? How are you opening your database connection?
– ssemilla
Nov 13 at 12:04
Are you opening your DB connection like this:
db, err := sql.Open("postgres", connStr)?– ssemilla
Nov 13 at 12:06
Are you opening your DB connection like this:
db, err := sql.Open("postgres", connStr)?– ssemilla
Nov 13 at 12:06
I use
github.com/lib/pq as DB driver, but to connect DB I use github.com/xo/dburl– Alex Chaliy
Nov 13 at 12:07
I use
github.com/lib/pq as DB driver, but to connect DB I use github.com/xo/dburl– Alex Chaliy
Nov 13 at 12:07
1
1
So the solution is to use
oid, balance instead of * in sql query string, to use db.QueryRow() instead of db.Query(), and to use row.Scan(&_id, &bal) according to oid, balance in sql query string.– Alex Chaliy
Nov 13 at 12:28
So the solution is to use
oid, balance instead of * in sql query string, to use db.QueryRow() instead of db.Query(), and to use row.Scan(&_id, &bal) according to oid, balance in sql query string.– Alex Chaliy
Nov 13 at 12:28
|
show 3 more comments
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53266413%2fgo-lang-postgres-cannot-get-oid-after-scan%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
