diff options
Diffstat (limited to 'sqlite.go')
| -rw-r--r-- | sqlite.go | 16 |
1 files changed, 16 insertions, 0 deletions
@@ -879,6 +879,22 @@ func setProject (nid int) { } } +func getCustomerList() (outint []int, outstr []string) { + rows,err := db.Query("SELECT id, company, name FROM customers") + checkErr(err) + var id int + var comp string + var name string + for rows.Next() { + err = rows.Scan(&id, &comp, &name) + checkErr(err) + st := fmt.Sprintf("%s: %s",comp,name) + outint = append(outint,id) + outstr = append(outstr, st) + } + return +} + func allCustomers() { rows,err := db.Query("SELECT * FROM customers") //rows,err := db.Query("SELECT (id, company, name, address, satz, lastbill) FROM customers") |
