Unable to pass slice of int to dbx.In()

[byanjiong]

When passing []int to dbx.In(), the compiler give error as such:

sql: converting argument $3 type: unsupported type []int, a slice of int

How can I pass a slice in the dbx.In()?

numberList := []int{ 1, 2, 3}
err = rs.Tx().Select().Where(dbx.And(dbx.HashExp{"creator": rs.UserID(), "status": "a"}, dbx.In("role", numberList ))).OrderBy("modified").All(&customer)

tried ->

• dbx.In("role", numberList)
• dbx.In("role", numberList...)

can't really get it done... may please advise...

[qiangxue]

It should be dbx.In("role", numberList...)

[byanjiong]

A snapshot of my dbx usage. It works well until I use the dbx.In() together with []int. May try to have a look? :)

Anyway, a very very good package... user friendly x1000...

[qiangxue]

I see. I think this is how Go works. You need to declare your numberList to be []interface{}.

[byanjiong]

Yes, it works by declaring []interface. Thank you...