Questions tagged as 'sql'

2
answers

how to limit sql column information

Good evening, in a script I use I added this string to get some information, <div class="col"><b><?= $this->lang->line('imei');?>:</b> <?=$db['custom_field'];?></div> and the result is: {"494d4549...
asked by 30.11.2015 / 00:59
4
answers

How to check events between 2 dates in MySQL?

Knowing that I have a table called eventos , and this table has the columns id , titulo , inicio and fim . The inicio and fim columns are of type timestamp , where the start and end date and time of...
asked by 04.02.2014 / 20:30
2
answers

Join does not return as expected

I have the following scheme: tblpessoa with the fields: idPerson, name. tag with the fields: idCity, codCity, name, idPerformance (fk of the tblpessoa table), codeRegionCity (fk of the tblregiaoCity table). tblregiaoCity with the...
asked by 14.10.2015 / 14:50
1
answer

Sort by position of edited record (sql server)

When I enter a new record, I sort it by the last record entered. SELECT TOP(50) * FROM TB_CLIENTE_FORNECEDOR where status <> 'S' order by IDCLIENTEFORNECEDOR desc If I'm editing a record whose id is 10, I want to sort by this id.    ...
asked by 11.10.2015 / 02:49
1
answer

Because my LIMIT does not accept variable [duplicate]

ERROR: it simply does not query when I play in a foreach because LIMIT does not become the variable I declare Does anyone know how to do it? $cont = 2; $stm = $pdo->prepare('SELECT sol_camiseta.id, sol_camis...
asked by 11.10.2015 / 06:25
1
answer

Why a Stored Procedure generates different results if executed in Workbench and Java with JDBC

I have a Stored Procedure in MySQL that is working normally when I run from the Workbench, but when I execute this same procedure in Java / JBDC I am getting erroneous values different from those obtained in the Workbench. My Stored Procedure...
asked by 07.10.2015 / 21:07
0
answers

ERROR when selecting a simulation

I have a subscription problem. I have a screen that retrieves cycles that are open according to the course of the user and for each cycle of this already has a saved simulation, that is, a relationship. BEAN: @PostConstruct private vo...
asked by 05.11.2015 / 16:06
4
answers

What is the difference between INNER JOIN and OUTER JOIN?

What is the difference between INNER JOIN and OUTER JOIN ? Can you give me some examples?     
asked by 19.02.2014 / 03:32
1
answer

Save all PHP results to a single table in HTML

In my host it has an index.html with a form that is linked to a login.php that takes the results that the user typed and saved in an HTML table in the root of the site. The problem is that a table is created for each user and I want the data of...
asked by 25.09.2015 / 23:53
0
answers

Dependent check box

I have a problem and would like to know if you can help me. I have a CRUD that registers cycles, these cycles can have many courses. What I wanted to do exactly, is to validate the selectsOneRadios when registering an issue, that is choos...
asked by 01.11.2015 / 20:55