Insert users in a select

Question

Insert users in a select

Navigation

#1 by (2 votes)

0

I have this query

getAnalisisDetalladoSelect: function(req, res, next){
        sql.connect(config)
            .then(function() {
                var usuarios = null;
                var request = new sql.Request();
                request.query("SELECT Sk_Codigo_Usuario from Sk_Usuarios")
                    .then(function(recordset) {
                        usuarios = recordset['recordset'];
                        console.log('Recordset: ' + recordset);
                        console.log('Affected: ' + request.rowsAffected);
                        sql.close();
                        res.render('menu/analisisDetallado', { ListUsuario: usuarios });

                    })
                    .catch(function(err) {
                        console.log('Request error: ' + err);
                    });
            })
            .catch(function(err) {
                if (err) {
                    console.log('SQL Connection Error: ' + err);
                }
            });

    }

Which brings me the users and I must enter them in a select

td
  select(name="myselection")
      each option, Usuarios in ListUsuario
        option(value= "#{Usuarios.Sk_Codigo_Usuario}") option

some help how to put the each to fill the select

nodejs

asked by Eduard 23.06.2017 в 21:53

source

1 answer

Problems printing a jx ajax Check the existence of a file

score 2 · Accepted Answer

If you are using pug in your view you must have a for to scroll through your recordset that you send as a UserList parameter.

You should do something like this:

select#usuario.form-control(autofocus, required)
  option
    for usuario in ListaUsuario
      option(value=usuario.id) #{usuario.nombre}

You must keep in mind that in pug it is important to know how many spaces or tabs exist between each element, it is very special in when to devise the html.