Questions tagged as 'mysql'

Tagged questions
1
answer

How do I set a jcombobox in a PreparedStatement?

How do I make a jcombobox in this method? The Combobox would be in the type that the user is supposed to choose, I tried to make one but it did not work very well. And this method is in my main class and how do I set it to a PreparedStatement...
asked by 29.06.2015 / 22:57
2
answers

PHP and MySQL: Database does not update

Good afternoon everyone, I'm making a screen for editing personal information. My code for capturing the typed data is this: <?php require("../config/functions.php"); require("../classes/BDConnection.class.php"); require("../classes/Academi...
asked by 20.06.2015 / 19:54
2
answers

Problem inserting double value in MySQL

query += txtServidor.Text + "',";<br> query += double.Parse(txtVencimento.Text) + ",";<br> query += int.Parse(txtBanco.Text) + ",'";<br> INSERT INTO tbl_associados VALUES(10,'testando','001.318.555-55','categoria','ativo',...
asked by 30.03.2015 / 14:58
1
answer

mysql trigger if not update

I'm having a question when creating a trigger, I need it to be executed only if the field has not been updated: ProductIntegration, if any other field is updated it should be executed. DELIMITER $$ CREATE TRIGGER 'cadastro'.'trgProdutos' A...
asked by 25.03.2015 / 14:15
1
answer

Page Calendar By Week

I am developing a Specific Agenda for a client but I'm not sure how to page the calendar per week. The schedule works much more I do not know how to page now date_default_timezone_set('America/Sao_Paulo'); $data1 = date('d/m/Y'); $hora1 = date...
asked by 14.01.2015 / 02:34
1
answer

Group data related to a column

I have the following code SELECT t2.conta_nome as operacao, t1.provedor_nome as operadora, perfil, count(*) as total FROM asteriskcdrdb.cdr_tarifacao a INNER JOIN telefonia.provedor t1 ON a.operadora = t1.provedor_id INNER JOIN te...
asked by 22.11.2014 / 15:10
1
answer

MySQL Query - Trasnposition

I have the following query: SELECT despesa.codRequisicao, despesa.histDespesa, despesa.despesaPassagem, despesa.despesaTaxi, despesa.despesaHotel, despesa.despesaRefeicao, despesa.despesaOutros FROM...
asked by 22.10.2014 / 13:32
1
answer

Problems retrieving data from Mysql

I'm trying to retrieve data from Mysql database for a form, I was able to retrieve some data but others display - Resource id #7/#4 PHP: @$id = $_GET['v']; $res=mysql_query("select * from login where cdlogin = '$id'"); $res_pes=m...
asked by 23.05.2015 / 05:45
1
answer

How could I trigger an action in a PHP script with a link?

How could I trigger an action in a PHP script from a link? <ul class="categorias"> <li><a href="">Lançamentos</a></li> <li><a href="">Vista Panorâmica</a></li> <li><a h...
asked by 16.10.2014 / 02:51
1
answer

Connection with 3g unstable blocked in C #

Personal I have a system, which uses a table in mysql to check if there is an update for it, It happens that in certain moments, it is necessary that the modem is reconnected so that the system can do these operations web, someone knows the reas...
asked by 06.02.2015 / 13:54