#341·squirrel

error when using sqlx

Author: keeprockin2019Created Nov 14, 2022Updated Jan 17, 2025
query :=  sq.sq.Select(`COALESCE(MAX(ID),0)`).From(`channel`)
if len(name) != 0 {
     query = query.Where(sq.Eq{"name":name})
}
if true {
   query = query.Where(sq.Eq{"active":active})
}
// result
// sql  = SELECT COALESCE(MAX(ID),0) FROM channel WHERE name = ?
// args = []interface{} & 0 = xxxx
sql,args,err := query.ToSql()
if err != nil {
   return err
}
err = sqlx.GetContext(ctx,&data,sql,args...)
if err != nil{
    // output
    // pq: syntax error at end of input
}