Questions tagged as 'sql'

Tagged questions
2
answers

MySQL error "expects parameter 1 to be resource, boolean given in"

$query = "Select * from servico where ID_SERVICO = $id"; $result = mysql_query($query); if($row = mysql_fetch_array($result)) { $nome = $row['NOME']; if($nome == 'Marketing') { include ("servicos/marketing.php"); }...
asked by 07.08.2014 / 19:13
1
answer

problems running createNativeQuery

Hello everyone. I'm creating a project that handles user registration. In this project there will be several types of users. To simplify, let's call the types 1, 2 and 3. Depending on the type of user, the screens and features that he can access...
asked by 11.10.2016 / 14:39
1
answer

displaying photos by Repeater with sql server Using split

I can not load the photos in the repiter by making a car from the data bank, I can not find anything on the web related to this problem follow the cod         ASPX ImovelDetails <section class="slider-container"> &l...
asked by 11.10.2016 / 14:16
0
answers

data listing

It is only printing the first row of the database and I want it to print all the lines. <?php @session_start(); include_once $_SERVER['DOCUMENT_ROOT'] . '/PlanejamentoEstrategico/model/indoperacionais/Indoperacionais.php'; ?>...
asked by 22.08.2016 / 20:54
1
answer

Error Waiting for table level lock MySQL Java application

I have a Java swing application that uses the MySQL database, in its operation after some time spent in operation I noticed that the application crashed in some moments, it is necessary to restart the computer to be able to perform the process a...
asked by 15.09.2016 / 12:55
1
answer

2 FK SELECT on the same table

Given this scenario: Imagine a scenario in the field of oceanography, where table_A, in addition to the primary key, also needs to keep the direction of the wind (wind direction) and the direction of the wave (dir_condulation). Knowing that t...
asked by 15.09.2016 / 12:07
1
answer

Search Previous Record (Mileage)

I'm trying to set up a supply management report. I have a Supply Table with the following fields: DataAbastecimento, CódigoVeiculo, KmAbastecimento, Quantidade, Valor In the Report I am doing, I need to know the KM Traveled ... then follow...
asked by 15.09.2016 / 18:40
1
answer

Suggestion SQL generator in embedded system

I have an embedded system that stays in the client, but I need to develop a SQL generator that is free access to the consultants and invisible to the client, ie with a shortcut key it opens the SQL generator, but by path of the doubts the client...
asked by 17.08.2016 / 22:48
2
answers

MySQL error "expects parameter 1 to be resource, boolean given in"

$query = "Select * from servico where ID_SERVICO = $id"; $result = mysql_query($query); if($row = mysql_fetch_array($result)) { $nome = $row['NOME']; if($nome == 'Marketing') { include ("servicos/marketing.php"); }...
asked by 07.08.2014 / 19:13
0
answers

exceeded the 'max_user_connections' resource (current value: 3)

Good evening guys. Dude, I hate this mistake and I have no idea how to fix it. I'm closing the connection to the bank after each request, but it still goes on. I'm using PHP. Does anyone know how to fix this? exceeded the 'max_user_...
asked by 20.07.2016 / 03:29