From e9bad489128dd526b44b08cc3bed6cce1cb731da Mon Sep 17 00:00:00 2001
From: Nikolaus Gotsche <n@softwarefools.com>
Date: Thu, 4 Oct 2018 01:00:25 +0200
Subject: new getNewInput

---
 sqlite.go | 16 ++++++++++++++++
 1 file changed, 16 insertions(+)

(limited to 'sqlite.go')

diff --git a/sqlite.go b/sqlite.go
index 1907ddd..37de159 100644
--- a/sqlite.go
+++ b/sqlite.go
@@ -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")
-- 
cgit v1.2.3