mssql driver ( https://github.com/denisenkom/go-mssqldb ) doesn't yet support output variables, though I have support planned for go1.9. You can use rdb (I currently use it in a line of business application), but I would recommend you use https://github.com/denisenkom/go-mssqldb if possible (select your output vars in SQL text if that is an option) as that will supersede rdb/ms and database/sql will supersede rdb.
On Tue, Apr 4, 2017 at 5:27 AM <dharampalsingh.banga...@gmail.com> wrote: > Hi Kiril, > > Were you able to get this working , I am also struggling to get the Output > parameters working with mssql driver . > > @Daniel - can i use this http://godoc.org/bitbucket.org/kardianos/rdb > > > > Thanks, > Dharam > > On Wednesday, May 7, 2014 at 2:29:48 PM UTC+1, Kiril wrote: > > Hi guys, > Does anyone know how to execute mysql stored procedure with output > parameters? > > I use github.com/go-sql-driver/mysql > > > email:= v.Get("email") > > pss:= v.Get("pss") > > > var userId string > > var errorCode int > > > // Execute the query > > rows, err := db.Query("CALL User_Register(?,?,?,?)", email,pss,errorCode, > userId) > > if err != nil { > > panic(err.Error()) > > } > > > I do know how to pass regular params and how to get the field's value from > select in one row\rows > > > > in my case, errorCode and userId will be output. > > > > thanks in advance > > -- > You received this message because you are subscribed to a topic in the > Google Groups "golang-nuts" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/golang-nuts/5AJyGW9d9Wg/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > golang-nuts+unsubscr...@googlegroups.com. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "golang-nuts" group. To unsubscribe from this group and stop receiving emails from it, send an email to golang-nuts+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
