Questions tagged as 'mysql'

Tagged questions
1
answer

How to limit display of records according to parameters

I have a problem and the solution I am trying to apply does not seem to be the right one, I need to show some results of certain products limiting this display, I have the following sql that generates the grupos of products: p> SE...
asked by 21.10.2016 / 14:00
1
answer

CONCAT not working

SELECT indicativo_ja_registrado, qra, fez_contato, DATE_FORMAT(data_qso, '%d/%m/%y') AS data_qso, DATE_FORMAT(data_agora, '%d/%m/%Y') AS data_agora, TIMESTAMPDIFF(YEAR, data_qso, data_agora) AS Anos, TIMESTAMPDIFF(MONTH, data_qso + INTERVAL...
asked by 01.12.2016 / 15:38
1
answer

Programmatically change the date displayed in a DatePicker control?

I'm trying to display data from a field of a MySQL table in a DatePicker control. The code is as follows: if (dataGridProdutos.SelectedIndex != -1) { DateTime selectedDate; DataRowView selectedRecord = (DataRowView)dataGr...
asked by 01.12.2016 / 19:38
1
answer

Error adding more than one given mysql function in javascript intel XDK with PHP

I'm using the following function: $( document ).ready(function() { var $server; $server = 'http://localhost/mobile/DatabaseXDK/database/www/'; $('#inclusao').on('click', function(){ $nome = $('#nome').val(); $.ajax...
asked by 17.01.2017 / 04:40
2
answers

Search a table in MySQL with Java

I'm having trouble trying to fetch something from the table, I'm a newbie so I did it the way I know. Button code: livros.setPesquisarLivro(txtLivro.getText()); try { modelo.setNumRows(0); for (ObjetoLivro c : livroDAO....
asked by 16.01.2017 / 14:23
1
answer

MySQL Function returning NULL

My function does not work for anything in this world SQL looks like this: - Function used to return the remaining space of a chosen folder. - DELIMITER $$ CREATE FUNCTION tamanhoRestante (_idPasta INT) RETURNS INT BEGIN DECLARE lpas...
asked by 07.11.2016 / 15:36
2
answers

Insert with monthCalendar in MySql database and C #

I need to make a insert of date with monthCalendar in C# in database MySQL , except that the date format of MySQL is ( yyyy-MM-dd ) and I've already modified the code: I changed the input mode (% with%)...
asked by 06.11.2016 / 12:51
3
answers

Show Number of items per category in virtual store?

I have a question: I have several categories on my site and would like you to show how many items you have in each category. Example: You're like this: Accessories Toys Games Computers I want it to look like this: Accessor...
asked by 07.11.2016 / 12:27
1
answer

Spring boot with error connecting to mysql

I created a test project by Spring Tool Suite to create a REST server that will connect to a local mysql database, when I start the app in error when trying to connect to mysql: java.sql .SQLException: Access denied for user '' @ 'localhost' (u...
asked by 12.10.2016 / 20:26
2
answers

How to enter polylines in Google maps api v3 with dates saved in the database

I'm trying to show in google maps api v3 polylines that are stored in my database Here is the connection to the conf.inc.php database: <?php define('HOST','localhost'); define('USER','xxxx'); define('PASS','xxxxx'); define('DBSA','polili...
asked by 11.10.2016 / 17:22