Home / user-3115

Ivxn's questions

Martin Hope
Ivxn
Asked: 2022-07-02 08:55:31 +0800 CST
  • 2

I want to pass the result of an Entity query to a datatable, but I haven't been able to because it gives me an error the way I'm doing it using CopyToDataTable()

'Cannot convert an object of type 'System.Data.Entity.Infrastructure.DbQuery 1[<>f__AnonymousType41[System.Int32]]' to type 'System.Collections.Generic.IEnumerable`1[System.Data.DataRow]'.'

the code I use is:

    public DataTable QueryResultados()
    {
        string situacion;
        if (RadCmbAccion.SelectedValue == "1")
        {
            situacion = "4";
        }
        else
        {
            situacion = "3";
        }

        string valoresCtas = regresa_lista().ToString();

        CatalogoContainer entidad = new CatalogoContainer();        

        IEnumerable<DataRow> query = (IEnumerable<DataRow>)(from c in entidad.CUENTA
                       join ct in entidad.CUENTA_TIPO
                       on c.id_CUENTA_TIPO equals ct.id_CUENTA_TIPO
                       join ffp in entidad.FORMA_PAGO
                       on c.id_FORMA_PAGO equals ffp.id_FORMA_PAGO
                       join cs in entidad.CUENTA_SITUACION
                       on c.id_CUENTA_SITUACION equals cs.id_CUENTA_SITUACION
                       where c.id_CUENTA_SITUACION.Equals(situacion) && valoresCtas.Contains(c.id_CUENTA.ToString())
                       select new
                       {
                           c.id_CUENTA
                       });

        DataTable boundTable = (query.CopyToDataTable());
        return boundTable;
    }

Does anyone know how to correct this error?

c#
Martin Hope
Ivxn
Asked: 2020-04-09 07:44:04 +0800 CST
  • 2

How could I further optimize this update query, since I have to update 200,000 records and the oracle session ends and I cannot update anything, not even by placing ROWNUM

I get the error: ORA-00028: your session has been killed

UPDATE TMP_IOP_AJUSTE_TRF_RCBD_PSTVS P
SET P.PLAZA = (SELECT T.NOMCAS FROM TMP_IOP_AJUSTE_TRF_RCBD2_TEST T WHERE T.SEQ=P.SEQ)
WHERE P.NUM_DEC IN ('E422') AND P.PLAZA IS NULL AND  ROWNUM <=10000

enter image description here

oracle
Martin Hope
Ivxn
Asked: 2020-01-03 16:33:34 +0800 CST
  • 2

How can I do an update so that it updates several values, my query is

    UPDATE ACL_FAC SET ID_CARGA = 
(SELECT SEQUENCIA FROM ACL_FAC WHERE ID_CARGA IN (4005946,
4005947,
4005948,
4005949,
4005950)AND SEQUENCIA IN(680456522,
680482070,
680561046,
680561049,
680562329)
) 
WHERE ID_CARGA IN (4005946,
4005947,
4005948,
4005949,
4005950)AND SEQUENCIA IN(680456522,
680482070,
680561046,
680561049,
680562329)

what I want to do is update the ID_CARGA field placing the value that has SEQUENCE but this is for several values, with one value if possible but with several values ​​as the example generates an error

The subquery returned more than one value, which is not correct when followed by =, !=, <, <=, >, >= or when used as an expression.

sql
Martin Hope
Ivxn
Asked: 2020-08-30 10:12:39 +0800 CST
  • 3

How can I pass this queryto Oracle?, I'm updating a field from table A through inner jointable B:

UPDATE ATA
SET A.ID_IN = B.id_in
FROM TMP_TRF_ALL ATA
INNER JOIN items B
on ATA.seq=B.seq
WHERE ATA.PROCESADO = 1
AND  ATA.EXT = '213'
AND B.ID_COMPANY='1'

I have done this, but it is not correct because it does not update and it is as if I wanted to update the field ID_INof the table items, when in fact I want to update the field ID_INof the tableTMP_TRF_ALL 

UPDATE 
(SELECT ATA.id_in as T1IV,B.id_in AS T2IV FROM TMP_TRF_ALL ATA  INNER JOIN items B 
on ATA.seq=B.seq 
WHERE ATA.PROCESADO = 1 AND  ATA.EXT = '213' AND B.ID_COMPANY='1')T
SET T.T1IV=T.T2IV
oracle
Martin Hope
Ivxn
Asked: 2020-10-04 09:31:02 +0800 CST
  • 2

I have a page to update where it brings me the data according to the record that I have selected, I have numeric fields that I have validated with a function for separating thousands and decimals, but in which method should I place the function so that when loading the values, numbers automatically I formatted the value without needing to do a focusin, focusOut, keypress or keyup

function formatearNumero(nStr) {
    nStr += '';
    x = nStr.split(',');
    x1 = x[0];
    x2 = x.length > 1 ? '.' + x[1] : '';
    var rgx = /(\d+)(\d{3})/;
    while (rgx.test(x1)) {
            x1 = x1.replace(rgx, '$1' + ',' + '$2');
    }
    return x1 + x2;
}
<input id="txtValor">

javascript
Martin Hope
Ivxn
Asked: 2020-08-30 08:19:38 +0800 CST
  • 3

I have an html table inside a div with Y scrolling, inside the table I have a header that I want to be fixed, how can I make the header of the table stay fixed knowing that the table is inside a div.

    div.tableContainer {
        width: 90%; /* table width will be 99% of this*/
        height: 320px; /* must be greater than tbody*/
        overflow: auto;
        margin: 0 auto;
    }

    table {
        width: 97%; /*100% of container produces horiz. scroll in Mozilla*/
        border: none;
        border-spacing: 0px;
        background-color: transparent;
    }

        table > tbody {
            overflow: auto;
            height: 280px;
            overflow-x: hidden;
        }

            table > tbody tr {
                height: auto;
            }
<div class="tableContainer">
<table role="table">
    <thead role="rowgroup">
        <tr role="row">
            <th role="columnheader">First Name</th>
            <th role="columnheader">Last Name</th>
            <th role="columnheader">Job Title</th>
            <th role="columnheader">Favorite Color</th>
            <th role="columnheader">Wars or Trek?</th>
            <th role="columnheader">Secret Alias</th>
            <th role="columnheader">Date of Birth</th>
            <th role="columnheader">Dream Vacation City</th>
            <th role="columnheader">GPA</th>
            <th role="columnheader">Arbitrary Data</th>
        </tr>
    </thead>
    <tbody role="rowgroup">
        <tr role="row">
            <td role="cell">James</td>
            <td role="cell">Matman</td>
            <td role="cell">Chief Sandwich Eater</td>
            <td role="cell">Lettuce Green</td>
            <td role="cell">Trek</td>
            <td role="cell">Digby Green</td>
            <td role="cell">January 13, 1979</td>
            <td role="cell">Gotham City</td>
            <td role="cell">3.1</td>
            <td role="cell">RBX-12</td>
        </tr>
        <tr role="row">
            <td role="cell">The</td>
            <td role="cell">Tick</td>
            <td role="cell">Crimefighter Sorta</td>
            <td role="cell">Blue</td>
            <td role="cell">Wars</td>
            <td role="cell">John Smith</td>
            <td role="cell">July 19, 1968</td>
            <td role="cell">Athens</td>
            <td role="cell">N/A</td>
            <td role="cell">Edlund, Ben (July 1996).</td>
        </tr>
        <tr role="row">
            <td role="cell">Jokey</td>
            <td role="cell">Smurf</td>
            <td role="cell">Giving Exploding Presents</td>
            <td role="cell">Smurflow</td>
            <td role="cell">Smurf</td>
            <td role="cell">Smurflane Smurfmutt</td>
            <td role="cell">Smurfuary Smurfteenth, 1945</td>
            <td role="cell">New Smurf City</td>
            <td role="cell">4.Smurf</td>
            <td role="cell">One</td>
        </tr>
        <tr role="row">
            <td role="cell">Cindy</td>
            <td role="cell">Beyler</td>
            <td role="cell">Sales Representative</td>
            <td role="cell">Red</td>
            <td role="cell">Wars</td>
            <td role="cell">Lori Quivey</td>
            <td role="cell">July 5, 1956</td>
            <td role="cell">Paris</td>
            <td role="cell">3.4</td>
            <td role="cell">3451</td>
        </tr>
        <tr role="row">
            <td role="cell">Captain</td>
            <td role="cell">Cool</td>
            <td role="cell">Tree Crusher</td>
            <td role="cell">Blue</td>
            <td role="cell">Wars</td>
            <td role="cell">Steve 42nd</td>
            <td role="cell">December 13, 1982</td>
            <td role="cell">Las Vegas</td>
            <td role="cell">1.9</td>
            <td role="cell">Under the couch</td>
        </tr>
        <tr role="row">
            <td role="cell">Captain</td>
            <td role="cell">Cool</td>
            <td role="cell">Tree Crusher</td>
            <td role="cell">Blue</td>
            <td role="cell">Wars</td>
            <td role="cell">Steve 42nd</td>
            <td role="cell">December 13, 1982</td>
            <td role="cell">Las Vegas</td>
            <td role="cell">1.9</td>
            <td role="cell">Under the couch</td>
        </tr>
        <tr role="row">
            <td role="cell">Captain</td>
            <td role="cell">Cool</td>
            <td role="cell">Tree Crusher</td>
            <td role="cell">Blue</td>
            <td role="cell">Wars</td>
            <td role="cell">Steve 42nd</td>
            <td role="cell">December 13, 1982</td>
            <td role="cell">Las Vegas</td>
            <td role="cell">1.9</td>
            <td role="cell">Under the couch</td>
        </tr>
        <tr role="row">
            <td role="cell">Captain</td>
            <td role="cell">Cool</td>
            <td role="cell">Tree Crusher</td>
            <td role="cell">Blue</td>
            <td role="cell">Wars</td>
            <td role="cell">Steve 42nd</td>
            <td role="cell">December 13, 1982</td>
            <td role="cell">Las Vegas</td>
            <td role="cell">1.9</td>
            <td role="cell">Under the couch</td>
        </tr>
        <tr role="row">
            <td role="cell">Captain</td>
            <td role="cell">Cool</td>
            <td role="cell">Tree Crusher</td>
            <td role="cell">Blue</td>
            <td role="cell">Wars</td>
            <td role="cell">Steve 42nd</td>
            <td role="cell">December 13, 1982</td>
            <td role="cell">Las Vegas</td>
            <td role="cell">1.9</td>
            <td role="cell">Under the couch</td>
        </tr>
        <tr role="row">
            <td role="cell">Captain</td>
            <td role="cell">Cool</td>
            <td role="cell">Tree Crusher</td>
            <td role="cell">Blue</td>
            <td role="cell">Wars</td>
            <td role="cell">Steve 42nd</td>
            <td role="cell">December 13, 1982</td>
            <td role="cell">Las Vegas</td>
            <td role="cell">1.9</td>
            <td role="cell">Under the couch</td>
        </tr>
        <tr role="row">
            <td role="cell">Captain</td>
            <td role="cell">Cool</td>
            <td role="cell">Tree Crusher</td>
            <td role="cell">Blue</td>
            <td role="cell">Wars</td>
            <td role="cell">Steve 42nd</td>
            <td role="cell">December 13, 1982</td>
            <td role="cell">Las Vegas</td>
            <td role="cell">1.9</td>
            <td role="cell">Under the couch</td>
        </tr>
    </tbody>
</table>

</div>

html
Martin Hope
Ivxn
Asked: 2020-05-22 11:14:18 +0800 CST
  • 3

I have doubts that my SP is correct since I don't know if it should be used only once begin tryand those instructions, apart from that, it returns a 1 but it doesn't do the update:

ALTER PROCEDURE [dbo].[SP_EliminarVariableFormula]
    @IdVariableElimina int, @ValorElimina varchar(100)
AS
BEGIN
    -- SET NOCOUNT ON added to prevent extra result sets from interfering with SELECT statements.
    SET NOCOUNT ON;

    DECLARE  @Activo bit = 0    


    if @ValorElimina <> '' 
    BEGIN TRY
        BEGIN TRAN  
            UPDATE ValoresDeVariables SET Activo=@Activo WHERE IDVariable=@IdVariableElimina AND ValorDeVariable=@ValorElimina
        COMMIT TRAN
        SELECT 1
    END TRY
    BEGIN CATCH
        ROLLBACK TRAN
        SELECT 0, 'Hubo un error.'
    END CATCH
    else
    BEGIN TRY
        BEGIN TRAN  
            UPDATE ValoresDeVariables SET Activo=@Activo WHERE IDVariable=@IdVariableElimina
        COMMIT TRAN
        SELECT 1
    END TRY
    BEGIN CATCH
        ROLLBACK TRAN
        SELECT 0, 'Hubo un error.'
    END CATCH
END
sql
Martin Hope
Ivxn
Asked: 2020-11-28 18:06:08 +0800 CST
  • 4

I have one stored procedurethat makes a select. I use this SPfor a search form which, if no search parameters are passed, returns all the records. Otherwise some fields are filtered as dates that are of type DATE. In any case, I have to send the fields, if they are not with values, I would have to send them with NULL. The problem is that, as I pass type values DATE​​in NULL, it gives me an error that it cannot be converted. I have tried to do it in the following way, but I have not been able to fill my GV. Is there another way to do this?

protected void BtnSearch_Click(object sender, EventArgs e)
{
    try
    {
        SqlConnection con = new SqlConnection(Util.ObtenerCadenaConexion("ConnectionString"));
        SqlCommand cmd = new SqlCommand();
        cmd.CommandText = "ProcListarAnuncio";
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.AddWithValue("@Titulo", txtTitulo.Text.Trim() == "" ? null : txtTitulo.Text.Trim());
        cmd.Parameters.AddWithValue("@FechaDesde", txtFechaI.Text.Trim() == "" ? null : txtFechaI.Text.Trim());
        cmd.Parameters.AddWithValue("@FechaHasta", txtFechaF.Text.Trim() == "" ? null : txtFechaF.Text.Trim());
        cmd.Connection = con;
        con.Open();
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        DataTable dt = new DataTable();
        da.Fill(dt);
        GridView1.DataSource = dt;
        GridView1.DataBind();    

    }
}
c#
Martin Hope
Ivxn
Asked: 2020-11-25 11:47:22 +0800 CST
  • 6

I am using the JQuery autocomplete library. Currently I have a function that decodes HTML entities of type numeric -> &#209;, but what I don't know is how to integrate entities of this type -> into the function &amp;.

My function:

function decodificarEntidadesHTMLNumericas(texto) {
    return texto.replace(/&#(\d{1,8});/g, function(m, ascii) {
        return String.fromCharCode(ascii);
    });
}

I don't know how to integrate the regular expression so that it decodes both cases.

javascript
Martin Hope
Ivxn
Asked: 2020-11-18 10:41:46 +0800 CST
  • 3

I have a problem with the presentation of the content of the matches that are shown in a textbox with the JQuery autocomplete library since my text has ñand puts strange symbols, I think it is not decoding my text well but I do not know how to correct this problem.

I make an AJAX call to a page that returns the match results and I feel like the problem is in the AJAX:

<script>
    $(document).ready(function () {
        $("#btnBusca").css({ 'display': 'none' });
        $("#filtroBusqueda").change(function () {
            var op = $(this).val();

            switch (op) {

                case "rs":
                    $("#rs").css({ 'display': 'block' });
                    $("#ln").css({ 'display': 'none' });
                    $("#nc").css({ 'display': 'none' });
                    $("#btnBusca").css({ 'display': 'block' });
                    break;
                case "ln":
                    $("#ln").css({ 'display': 'block' });
                    $("#rs").css({ 'display': 'none' });
                    $("#nc").css({ 'display': 'none' });
                    $("#btnBusca").css({ 'display': 'block' });
                    break;
                case "nc":
                    $("#nc").css({ 'display': 'block' });
                    $("#rs").css({ 'display': 'none' });
                    $("#ln").css({ 'display': 'none' });
                    $("#btnBusca").css({ 'display': 'block' });
            }
        });

        $("#txtRazon").autocomplete({
            source: function (request, response) {
                $.ajax({
                    type: "post",
                    url: "coincidenciaRazonSocial",                    
                    dataType: "json",
                    data: {
                        q: request.term
                    },
                    success: function (data) {
                        response($.map(data, function (item) {
                            return {
                                label: item.nombre,
                                value: item.nombre,
                            }
                        }));
                    }
                });
            }
        });

    });
</script>
<div>
    <h5><span class="glyphicon glyphicon-th"></span> Búsqueda</h5>
    <form id="formularoBuscar" method="post" class="form-horizontal " action="#">

        <div class="row">
            <div class="col-lg-12 col-md-12 col-sm-12 col-xs-12">
                <div class="form-group">
                    <label class="col-lg-1 control-label">Filtro</label>
                    <div class="col-lg-11">
                        <select name="filtroBusqueda" id="filtroBusqueda" class="form-control">
                            <option value="" disabled selected>Seleccione Opción</option>
                            <option value="rs"> x Razón social</option>
                            <option value="ln">x Línea</option>
                            <option value="nc">x Número cuenta</option>
                        </select>
                    </div>
                </div>
            </div>
        </div>

        <div id="rs" style="display: none">
            <div class="row">
                <div class="col-lg-12 col-md-12 col-sm-12 col-xs-12">
                    <div class="form-group">
                        <label class="col-lg-1 control-label">Razón social</label>
                        <div class="col-lg-11">
                            <input type="text" class="form-control" id="txtRazon" />
                        </div>
                    </div>
                </div>
            </div>
        </div>

        <div id="ln" style="display: none">
            <div class="row">
                <div class="col-lg-12 col-md-12 col-sm-12 col-xs-12">
                    <div class="form-group">
                        <label class="col-lg-1 control-label">Número telefonico</label>
                        <div class="col-lg-11">
                            <input type="text" class="form-control" id="txtTelefono" />
                        </div>
                    </div>
                </div>
            </div>
        </div>

        <div id="nc" style="display: none">
            <div class="row">
                <div class="col-lg-12 col-md-12 col-sm-12 col-xs-12">
                    <div class="form-group">
                        <label class="col-lg-1 control-label">Número cuenta</label>
                        <div class="col-lg-11">
                            <input type="text" class="form-control" id="txtCuenta" />
                        </div>
                    </div>
                </div>
            </div>
        </div>

        <div class="row">
            <div class="col-lg-12 col-md-12 col-sm-12 col-xs-12">
                <div class="form-group" id="btnBusca">
                    <label class="col-lg-1 control-label"></label>
                    <div class="col-lg-11">
                        <button type="button" id="btnBuscarAdenda">Buscar</button>
                    </div>
                </div>
            </div>
        </div>
    </form>
</div>

my json that returns Same text in the JSON with Ñ

javascript
Martin Hope
Ivxn
Asked: 2020-11-05 11:05:42 +0800 CST
  • 5

How can I loop through the rows of an HTML table and get the values ​​with a button?

I have an example of a table that gets me the specific value of a cell when I click on the row, but what I require is that when I click on an ok button I get the values ​​row x row:

<!DOCTYPE html>
<html>

<head>
  <meta charset="utf-8">
  <script src="http://ajax.googleapis.com/ajax/libs/jquery/2.1.1/jquery.min.js" type="text/javascript"></script>

  <script>
    $(document).ready(function() {
      $("#ok").click(function() {
        var valores = "";

        $(this).parents("tr").find("#numero").each(function() {
          valores += $(this).html() + "\n";
        });
        console.log(valores);
        alert(valores);
      });


      $(".boton").click(function() {

        var valores = "";

        // Obtenemos todos los valores contenidos en los <td> de la fila
        // seleccionada
        $(this).parents("tr").find("#numero").each(function() {
          valores += $(this).html() + "\n";
        });
        console.log(valores);
        alert(valores);
      });
    });
  </script>
 
  <table border="1" cellspacing="0" cellpadding="5" id="tbl">
    <thead>
      <tr>
        <td>Nombre 1</td>
        <td>Nombre 2</td>
        <td>Apellido 1</td>
        <td>Mantenimiento</td>
      </tr>
    </thead>
    <tr>
      <td id="numero">Kevin</td>
      <td>Joseph</td>
      <td>Ramos</td>
      <td class="boton">coger valores de la fila</td>
    </tr>
    <tr>
      <td id="numero">Viviana</td>
      <td>Belen</td>
      <td>Rojas</td>
      <td class="boton">coger valores de la fila</td>
    </tr>
    <tr>
      <td id="numero">Junior</td>
      <td>Gerardo</td>
      <td>Nosé</td>
      <td class="boton">coger valores de la fila</td>
    </tr>
  </table>
  <br>
  <form action="">
    <label for="">Nombre</label>
    <input type="button" value="ok" id="ok" class="boton">
  </form>
</body>

</html>

javascript
Martin Hope
Ivxn
Asked: 2020-10-07 10:48:02 +0800 CST
  • 4

I have a button that calls a JS function, but I have not been able to send more than one parameter

                           $("#msgPrueba").html('<script>$("#exampleModalx").modal({backdrop: "", keyboard: false});</script><div class="modal fade" id="exampleModalx" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel">' +
'<div class="modal-dialog" role="document">'+
'<div class="modal-content">'+
'<div class="modal-header">'+
'<button type="button" class="close" data-dismiss="modal" aria-label="Close">
<span aria-hidden="true">&times;</span></button>'+
'<h4 class="modal-title" id="exampleModalLabel">
<span style="font-size:14px">:: Factura '+ factura +' ;;</style>' +
'</div>'+
'<div class="modal-body">'+
'<center><img src="../Images/ok.jpg" width="70px" height="60px"/><br/>"' + data + '"</center>' +
'<center><img src="../Images/ok.png" width="30px" height="30px"/><br/><br/>' + data + '<br/><span style="font-size:12px;color:green">Serie(s) guardada(s) exitosamente</span></center>'+
'</div>'+
'<div class="modal-footer">'+                
'<button type="button" class="btn btn-default" id="btnCerrarModal" onClick="facturaSer( "' + factura + '","SI")"  data-dismiss="modal">Cerrar</button>' +
'</div>'+
'</div>'+
'</div>'+
'</div>');

and my function is

function facturaSer(varfactura, varplazos) {
    alert(varplazos);

    var fact = varfactura
        //alert(fact);
        var cargando = $("#muestraSeccion").html("<center><img  src='../Images/cargando1.gif' height='50px' width='50px'/><br/>Un momento por favor...<center>");

    $.ajax({
        type: 'POST',
        url: 'buscaFactura',
        data: {
            "factura": fact
        },
        success: function (resultado) {
            //cargando.hide();
            $("#muestraSeccion").hide().html(resultado).fadeIn("fast");

        },
        error: function (jqXHR, textStatus, errorThrown) {
            console.log(jqXHR, textStatus, errorThrown);
            if (jqXHR.status === 0) {

                alert('Not connect: Verify Network.=(');

            } else if (jqXHR.status == 404) {

                alert('Requested page not found [404].');

            } else if (jqXHR.status == 500) {

                alert('Error Interno del Servidor [500].');

            } else if (textStatus === 'parsererror') {

                alert('Requested JSON parse failed.');

            } else if (textStatus === 'timeout') {

                alert('Time out error.');

            } else if (textStatus === 'abort') {

                alert('Ajax request aborted.');

            } else {

                alert('Uncaught Error: ' + jqXHR.responseText);

            }

        }
    });
}

and I get an error VM540 inicioEmpresariales:2 Uncaught SyntaxError: Unexpected token }, am I calling the function correctly?

javascript
Martin Hope
Ivxn
Asked: 2020-08-02 08:14:58 +0800 CST
  • 4

I have an html table and in each record I place a checkbox. How could I do so that when I select some records with the checkbox I get the data of the row to send them through a form?

$(document).ready(function(){
$("input[type=checkbox]:checked").each(function(){
	//cada elemento seleccionado
	alert($(this).val());
});
});
<html>
<head>
<script src="http://ajax.aspnetcdn.com/ajax/jQuery/jquery-1.12.4.min.js"></script>
</head>
<body>
<form id="formulario" name="formulario" action="">
<table>
<tr>
<td><input type="checkbox" name="elemento1" value="1"/></td>
<td>aaa</td>
<td>bbb</td>
<td>ccc</td>
</tr>
<tr>
<td><input type="checkbox" name="elemento2" value="2"/></td>
<td>ddd</td>
<td>eee</td>
<td>fff</td>
</tr>
<tr>
<td><input type="checkbox" name="elemento3" value="3"/></td>
<td>ggg</td>
<td>hhh</td>
<td>iii</td>
</tr>
<tr>
<td><input type="checkbox" name="elemento4" value="4"/></td>
<td>jjj</td>
<td>kkk</td>
<td>lll</td>
</tr>
<tr>
<td><input type="checkbox" name="elemento5" value="5"/></td>
<td>mmm</td>
<td>nnn</td>
<td>ooo</td>
</tr>
<tr>
<td><input type="checkbox" name="elemento6" value="6"/></td>
<td>ppp</td>
<td>qqq</td>
<td>rrr</td>
</tr>
<tr>
<td><input type="checkbox" name="elemento7" value="7"/></td>
<td>sss</td>
<td>ttt</td>
<td>uuu</td>
</tr>
<tr>
<td><input type="checkbox" name="elemento8" value="8"/></td>
<td>vvv</td>
<td>www</td>
<td>xxx</td>
</tr>
<tr>
<td><input type="checkbox" name="elemento9" value="9"/></td>
<td>yyy</td>
<td>zzz</td>
<td>AAA</td>
</tr>
<tr>
<td><input type="checkbox" name="elemento10" value="10"/></td>
<td>BBB</td>
<td>CCC</td>
<td>DDD</td>
</tr>
</table>
<input type="submit" value="seleccionar" onclick=""/>
</form>
</body>
</html>

In the previous example I only get the check value but not the whole row. What could I do?

javascript
Martin Hope
Ivxn
Asked: 2020-07-26 08:45:59 +0800 CST
  • 3

I get an address from a textbox with JQUERY, but it is a long string which is "Calle y No:XXXXXXXXXColonia:XXXXXXXXXMunicipio:XXXXXXXXXEstado:XXXXXXXXXCP:XXXXXX", from which I want to omit "Calle y No:","Colonia:", "Municipality:", "State:" and "CP:", I am applying the split function

        var element = $("#txtDomicilio").val();
        var fecha = element.split('Calle y No:');
        var fecha1 = element.split('Colonia:');
        var fecha2 = element.split('Municipio:');
        var fecha3 = element.split('Estado:');
        var fecha4 = element.split('CP:');
        alert('Fecha formateada: ' + fecha);
        alert('Fecha formateada: ' + fecha1);
        alert('Fecha formateada: ' + fecha2);
        alert('Fecha formateada: ' + fecha3);
        alert('Fecha formateada: ' + fecha4);

but that way it only omits me for var fecha = element.split('Calle y No:');Street and No:, but not Colonia:, Municipality: ..., How can I make it omit what I have in the split functions? all at once and not separately as I have it

enter image description here

javascript
Martin Hope
Ivxn
Asked: 2020-06-29 09:34:57 +0800 CST
  • 4

How can I center my bootstrap form, since everything is on the right, maybe I am placing the size of the cells wrong, this is my code

<form class="form-horizontal" style="margin:0 auto">
  <div class="form-group">
    <label class="col-lg-8 control-label">Nombres</label>
    <div class="col-lg-4">
      <input type="text" class="form-control" name="nombre" />
    </div>
  </div>

  <div class="form-group">
    <label class="col-lg-8 control-label">Apellidos</label>
    <div class="col-lg-4">
      <input type="text" class="form-control" name="apellido" />
    </div>
  </div>

  <div class="form-group">
    <label class="col-lg-8 control-label">Correo Electrónico</label>
    <div class="col-lg-4">
      <input type="text" class="form-control" name="email" />
    </div>
  </div>

  <div class="form-group">
    <label class="col-lg-8 control-label">Teléfono Celular</label>
    <div class="col-lg-4">
      <input type="text" class="form-control" name="telefono_cel" />
    </div>
  </div>

  <div class="form-group">
    <div class="">
      <button type="submit" class="btn btn-success left">Registrarse</button>
    </div>
  </div>

</form>

enter image description here

bootstrap
Martin Hope
Ivxn
Asked: 2020-06-18 07:20:25 +0800 CST
  • 3

I have a problem in JAVASCRIPT since I make an external file with a function that when pressing the option of a menu redirects me to a page, when calling the function in the onclick event I make reference to my function that is in the external JS but it marks me the browser that is not defined, my JS file is called eventosJS.js that I include but the function is not detected

$(document).ready(function() {
  function myFunction(url) {

    $.ajax({
      url: url,
      type: 'POST',
      beforeSend: function() {
        $("#muestraSeccion").html("<center><img src='../Images/cargando1.gif' height='50px' width='50px'/><br/>Un momento por favor...</center>");
        $("#muestraInicio").hide();
      },

      success: function(response) {
        $("#muestraSeccion").html(response).hide().fadeIn('fast');
      },
      error: function(xhr, error) {

          if (xhr.status === 0) {
            return ($("#mensajeError").html("<center>No conectado.\nPor favor verifica tu conexión a la red.</center>"));
          } else if (xhr.status == 404) {
            return ($("#muestraSeccion").html("<center><img src='../Images/error404.png' width='500px' height='350px' class='img img-responsive'/></center>").hide().fadeIn('slow'));
          } else if (xhr.status == 500) {
            return ($("#muestraSeccion").html("<center><img src='../Images/error500.png' width='500px' height='350px' class='img img-responsive'/></center>").hide().fadeIn('slow'));
          } else if (error === 'parsererror') {
            return ($("#mensajeError").html('<center>Falló la conversión JSON.</center>'));
          } else if (error === 'timeout') {
            return ($("#mensajeError").html('<center>Error time out.</center>'));
          } else if (error === 'abort') {
            return ($("#mensajeError").html('<center>Peticion Ajax cancelada.</center>'));;
          } else {
            return ($("#mensajeError").html('<center>Uncaught Error.\n' + xhr.responseText + '</center>'));
          }
        }
        //complete: function () { $("#divCargandoFormAdmin").fadeOut('slow'); }
    });
  };
});
<html>

<head>
  <title>@PageData("Title")</title>
  @RenderSection("head", required:=False)

  <link href="../Content/misEstilos.css" rel="stylesheet" />
  <link rel="stylesheet" href="http://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css">
  <link rel="stylesheet" href="https://rawgit.com/Eonasdan/bootstrap-datetimepicker/master/build/css/bootstrap-datetimepicker.min.css" />
  <link href="http://ajax.googleapis.com/ajax/libs/jqueryui/1.8/themes/base/jquery-ui.css" rel="stylesheet" type="text/css" />
  <!-- jQuery library -->
  <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.12.2/jquery.min.js"></script>
  <script src="../Scripts/jquery.validate.js"></script>
  <script src="http://ajax.aspnetcdn.com/ajax/jquery.validate/1.11.1/jquery.validate.min.js"></script>
  <script src="http://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/js/bootstrap.min.js"></script>
  <script src="../Scripts/moment.js"></script>
  <script src="../Scripts/bootstrap-datetimepicker.min.js"></script>
  <script src="https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap-wizard/1.2/jquery.bootstrap.wizard.js"></script>
  <script src="../Scripts/eventosJs.js"></script>

</head>

<body>
  <div class="container-fluid" style="padding-top: 10px">
    <!-- Static navbar -->
    <nav class="navbar navbar-default" style="padding:5px">
      <div class="container-fluid">
        <div class="navbar-header">
          <button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#navbar" aria-expanded="false" aria-controls="navbar">
            <span class="sr-only">Toggle navigation</span>
            <span class="icon-bar"></span>
            <span class="icon-bar"></span>
            <span class="icon-bar"></span>
          </button>
          <a class="navbar-brand">
            <span style="padding: 5px 5px 5px 5px; border-radius: 5px; box-shadow: 0 0 5px 3px orange;">
                            <img src="../Images/logof.png" width="60px" height="30px" style="margin-top: -10px;" /></a></span>
        </div>
        <div id="navbar" class="navbar-collapse collapse">
          <ul class="nav navbar-nav">
            <li class="active"><a href="#" onclick="myFunction('registro.html')"><span class="glyphicon glyphicon-plus"></span> Registrar Factura</a>
            </li>

            <li class="active"><a href="#" onclick="myFunction('Almacen.html')"><span class="glyphicon glyphicon-plus"></span> Registrar Series</a>
            </li>

          </ul>
          <!-- opciones parte izquierda-->
          <ul class="nav navbar-nav navbar-right">
            <li><a href="../cerrarSesion">Cerrar sesión <span class="glyphicon glyphicon-off"></span></a>
            </li>
          </ul>
        </div>
        <!--/.nav-collapse -->
      </div>
      <!--/.container-fluid -->
    </nav>
  </div>
  <div class="container-fluid" id="maximoPagina">
    @RenderBody()
  </div>
</body>

</html>

javascript
Martin Hope
Ivxn
Asked: 2020-06-11 13:52:19 +0800 CST
  • 7

When I show a JS alert, it redirects me to the top of my page and all the information of a form is lost and what I want is for it to show the alert but not redirect or reload. How can I avoid the redirection, after accepting the alert? , the alert is the common one, so I have not added any parameters

    $("#btnagregarSIM").click(function() {

      var cantidadTotalSim = $("#txtValorTotalSim").val();
      var cantidadArticulo = $("#txtValorTotalArticulo").val();
      var facturaSim = $("#txtFacturaSIM").val();
      var cantidadSim = $("#txtCantidadsim").val();
      var idSim = $("#cmbSim").val();
      var descripcionSim = $("#cmbSim option:selected").html();

      var x = parseFloat(cantidadTotalSim) + parseFloat(cantidadSim);

      if (x <= cantidadArticulo) {
        if (cantidadTotalSim <= cantidadArticulo) {
          fn_agregarSIM(facturaSim, cantidadSim, idSim, descripcionSim);
        } else {
          alert("Revisa que la cantidad de SIM sea la misma que la cantidad de Articulos")
        }
      } else {
        alert("La cantidad de SIM no puede ser mayor que la cantidad total de articulos.");
      }

    });
javascript
Martin Hope
Ivxn
Asked: 2020-05-27 06:58:15 +0800 CST
  • 3

I have an element html selector comboboxof which when they select an option it is inserted in a textareaHow can I validate that textareaa repeated option is not inserted in it?

I tried to validate with the code below, but I couldn't:

            $("#accesoriosEquipo").change(function () {

                $("#accesoriosEquipo option:first").val();
                              

                if ($('#accesoriosEquipo').val() == $("#accesoriosElegidos").val()) {
                    alert("Opción ya elegida")
                } else {
                    //alert("ok");
                    if ($("#accesoriosElegidos").val() == "") {
                        $('#accesoriosElegidos').val($('#accesoriosEquipo').val());
                    } else {
                        $('#accesoriosElegidos').val($('#accesoriosElegidos').val() + "\n" + $("#accesoriosEquipo").val());
                    }

                }

            });

javascript
Martin Hope
Ivxn
Asked: 2020-04-21 10:18:03 +0800 CST
  • 7

I use VB.NET and SQL, how can I make a SQL query to obtain the records by year and month only? since normal queries are usually made by year, month and day, in this case I want to search for the records of '2016-10'

mysql