Database range inside range html template

[baskara8 (Riva Ananta Baskara)]

How to display range inside range from database to html template?

for col.Next(){
for col1.Next(){

}
}

[kennygrant]

You’d be better to convert your rows from the database into something meaningful like a slice of structs of a specific type, then pass that in to the template. Think of the template as just about presentation, not about logic for extracting data which should happen first in your handler.

So in handler something like:

rows, err := db.Query(q, age)
if err != nil {
        log.Fatal(err)
}
defer rows.Close()
for rows.Next() {
      ...scan into struct here
}

So if you need to do complex logic like nesting you can do it there, but it’s not something to attempt in a template.

Then in the template you can just do a normal range with your data:

{{ range .items }}
  .Name
{{ end }}