Questions tagged as 'sql'

Tagged questions
0
answers

Filter data from a report in Jasperreports (Ireport) netbeans sql

I am doing a project for which I have several reports; I have already managed to visualize them all complete by means of a jsp ; however, I want to give the user the option to filter data. For example, in my sales report I want to filter my dat...
asked by 31.10.2018 / 04:43
0
answers

Insert in postgres

insert into ciudad values( (nextval('id_ciudad_sequence')), -> Primer valor viene de una sequencia ('Barcelona','Una ciudad bonita','España', -> hasta aqui son campos normales '{"(default,El palacio,7,(calle,1,00000))"}') ->Empieza la...
asked by 31.10.2018 / 20:58
1
answer

Query Sql to show it in a DropDownList

I want to make a selection list by means of a DropDownList but it does not generate anything, I do not know if I have any errors Protected Sub DropDownList4_SelectedIndexChanged(sender As Object, e As EventArgs) Handles DropDownList4.Sel...
asked by 29.10.2018 / 16:55
2
answers

Name of Variable session according to query variable

I want to create variables $_SESSION according to the name of the data that brings me from a query while ($row = oci_fetch_assoc($validacion)){ borrado($row["ID_CENTRAL"]); $_SESSION['echo $row["ID_CENTRAL"];'] = $row["ID_CENTRA...
asked by 26.10.2018 / 17:06
0
answers

How to put a field of a horizontal select in sql that does not duplicate data SqlServer

select Paciente= HC.IdPaciente , Fecha_Adm = CONVERT(char(10), E.FechaAdmision, 101), Activo = Case when E.Estado = 'Activo' then 1 end, Anulado = Case when E.Estado = 'Anulado' then 1 end, Estado = Case when E.Estado = 'Anulado' then 'Solo Anu...
asked by 29.10.2018 / 20:32
0
answers

SQL Trigger in Stroed procedure - activate trigger after using sp

Suppose I have a very simple stored procedure , which performs a select , but I want to make a trigger that is activated every time I use that stored procedure . Does anyone know exactly how to do something like that?...
asked by 27.10.2018 / 01:40
1
answer

I can not get and send the data id of a combobox in JAVA pattern MVC to SQL

THIS IS MY JSP "INSERT": <% ProfesionalBE profesional = new ProfesionalBE(); profesional.setNombre(request.getParameter("nombre")); profesional.setApellido(request.getParameter("apellido")); profesional.setCorreo(request....
asked by 27.10.2018 / 01:33
0
answers

A record in SQL is inserted twice from ASP.NET C #

** <button runat="server" id="cmdSavep" class="btn btn-success" onserverclick="savepago">Guardar</button>              SqlConnection conn = new SqlConnection(); SqlCommand...
asked by 30.10.2018 / 18:33
0
answers

Show a Report of JasperReport (Ireport) to a user in java netbeans jsp-servlet

0 vote against Favourite you will see I have a problem, I must from a button in a jsp, send a call to a report that I have made in jasperreport before and be displayed in a pdf window to the user. I have tried several ways but it does not wor...
asked by 30.10.2018 / 06:01
0
answers

sql error with php

I want to connect sql server with php, I have the following error:    ****** Connection could not be established. Array ([0] => Array ([0] => 08001 [SQLSTATE] => 08001 [1] = > 2 [code] = > 2 [2] = & [[Microsoft] [ODBC   Driver 11 for SQ...
asked by 27.10.2018 / 01:10