Questions tagged as 'sql-select'

Tagged questions
1
answer

Error in query linq

I'm trying to query the table below from my database. Thisqueryisperformedusingthemethodbelow:public void compraAcoes(float cepf, string codigo, int quantidade) { string cd = codigo; try { float cpf; BuscaNet bus...
asked by 01.06.2014 / 22:02
1
answer

Extract xml tag from a varchar (max)

Hello, I have a series of xml records in a varchar (max) column and I need to extract the <MT_USADA>16 MB</MT_USADA> tag, for example: <?xml version="1.0" encoding="utf-8"?> <consulta xmlns:xsd="http://www.w3.org...
asked by 26.06.2018 / 22:04
2
answers

Login form returning error!

I have a login form that returns the following ERROR :    You have an error in your SQL syntax; check the manual that   correspond to your MySQL server version for the right syntax to use   near 'as value FROM olmp_cadparaprova WHERE email =...
asked by 30.10.2017 / 11:22
4
answers

Loading values from a select in my GridView

My DAL that does Select and saves it in type list using System; using System.Data; using System.Collections.Generic; using System.Linq; using System.Web; using MySql.Data; using MySql.Data.MySqlClient; using Geax1.Model; namesp...
asked by 24.09.2014 / 17:41
1
answer

SELECT command denied to user

   Error: SELECT command denied to user 'bank'@'xxx.xx.xx.xx' for table ' This error only happens in my hosting, it is running locally perfectly, I am querying 2 databases in a single query using: 'banco'.'table' ... Is it user permiss...
asked by 05.07.2014 / 03:40
1
answer

MySQL query problems

I am having difficulty querying between 4 tables, being them. States > Municipalities > Deaths > Population The query is returning the value of the population with a higher than true number ... Can anyone help me with this query? se...
asked by 05.10.2016 / 21:43
3
answers

No select error using mysqli_query

I've done a php to list the rooms, but I'm having difficulty listing them, if anyone can help me, I would appreciate it. <?php $link = mysqli_connect("localhost","root","","hotel"); $result = mysqli_query("SELECT descricao FROM quartos WHER...
asked by 08.06.2015 / 21:53
1
answer

SQL statement error

I have the following DB: WhenIrunthefollowingQuery:SELECTtbCelula.*FROM(((tbTiposMonitorizacaoINNERJOINtbMonitorizacaoProjONtbTiposMonitorizacao.TM_ID=tbMonitorizacaoProj.MP_T_ID)INNERJOINtbListaConformidadesONtbMonitorizacaoProj.MP_ID=tbListaC...
asked by 11.12.2015 / 11:28
2
answers

Formatting / masking CPF in MySQL or PDO

I have a "cpf" field in my table. This field can be of type INT or VARCHAR, in case I need to change it to solve my problem. In it there are only numerical values, without the dashes and without hyphen (.-). In PHP, when I'm going to call dat...
asked by 16.02.2016 / 22:58
2
answers

INNER JOIN does not return bank result

I'm trying to use this code: SELECT * FROM tb_trabalhador INNER JOIN tb_detalhe_trabalhador ON Tb_trabalhador.id = tb_detalhe_trabalhador.tb_trabalhador_id And it returns the result in white. Is there a way to get around this with anothe...
asked by 24.02.2014 / 10:32