new getNewInput

1 files changed, 16 insertions, 0 deletions

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")