My code makes de select and prints <nil> for each row

[amichelins]

My code makes de select and prints for each row

[CODE] db, err := sql.Open("ora", "user/[email protected]:1521/ORCL") defer db.Close()

rows, err := db.Query("SELECT A4_FILIAL, A4_COD, A4_NOME  FROM SA4010")
defer rows.Close()

if err != nil {
	fmt.Printf("%s", err)
	return
}

for rows.Next() {
	rows.Scan(rowP)
	fmt.Printf("%v", rowP[0])
	//fmt.Printf("{%v} -- {%v} ", rowP[0], rowP[1])
}

[/CODE] How to get columns values?

[tgulacsi]

What is rowP ?

If you know the column types, then

for rows.Next() {
  var fil, nome string
  var cod int64
  if err = rows.Scan(&fil, &cod, &nome); err != nil {
    return err
  }
  fmt.Printf("%q, %d, %q", fil, cod, nome)
}

[amichelins]

RowP is => rowP := make([]interface{}, 3) I test your code and work perfectly. thanks!!!!

[amichelins]

I can return from rows.Scan to and struct? The struct : type tabspreco struct { Filial string Codpro string Codtab string Preco float32 } The select: SELECT DA1_FILIAL AS Filial, DA1_CODPRO AS Codpro, DA1_CODTAB AS Codtab, DA1_PRCAR AS Preco FROM DA1010 WHERE DA1_FILIAL = '01' AND DA1_CODTAB = '068'

Each field has the name os struct element.

var Tabs2 tabspreco err = rows.Scan(&Tabs2)

Is that possivel?

[tgulacsi]

rows.Scan(&Tabs2.Filial, &Tabs2.Codpro, &Tabs2.Codtab, &Tabs2.Preco)

or use a helper like github.com/jmoiron/sqlx or github.com/kisielk/sqlstruct

[amichelins]

Thanks alot. I install github.com/jmoiron/sqlx and solve the problem.