Questions tagged as 'sql'

Tagged questions
2
answers

Error in Insert ... Values using oracle error 00936

I'm trying to make an insert into a table and it always gives me the error 00936 that says missing expression when it arrives at the cmd.executenonquery command line. Can someone help me? Code that I have: using (OracleConnection conn = new...
asked by 26.04.2016 / 19:08
0
answers

Error connecting to SQLServer using JAVA JDBC

I'm using the sqlserver lib and my connection class is down here: public class conexao{ //sqlsever private static final String USUARIO2 = "usuario"; private static final String SENHA2 = "senha"; private static final String URL2 = "jdbc:...
asked by 26.04.2016 / 19:34
1
answer

Return Date data according to the month

I have developed the following function: public function get_agendas() { $this->db->select("*, EXTRACT(MONTH FROM data) as mes_referencia, count(id) as total_registros"); $this->db->where("data >=", date("Y-m-d")); $...
asked by 04.04.2016 / 02:59
1
answer

Convert the result value of the sql query

I have the query that return me two results where I would like to format it to come in the proper format. How could I do that? select *, sum(valor) as ValorSoma, count(pedido) as QtdPedido from tb_vendas where idvendas > 0 and data_venda be...
asked by 12.04.2016 / 21:04
1
answer

Make a table condition type in MySql

Hello, I'm setting up a hotel bank in MySql and would like to know how to add a condition for checkin and specific checkout date so there is no duplication of reservations in the period booked by the hotel. guest. Thank you! Lizypanta     
asked by 30.03.2016 / 20:25
0
answers

INNER JOIN returning error

I'm trying an INNER JOIN between 3 tables plus error returns, I do not know what's wrong. Query: SELECT aa.arq_arqid, aa.arq_nome, aa.arq_nomecrip, aa.arq_datetime, u_usuarios_u_userid a_area_a_areaid FROM arq_arquiv...
asked by 18.03.2016 / 03:18
1
answer

Error writing data from some tables by application

I have an application in asp.net mvc which, among other functions, registers personal data of clients. We recently switched database access from one server to another, which has a copy of the database from the previous server. The problem is...
asked by 18.04.2016 / 16:00
1
answer

Combobox + Arraylist + SQL

Hello, I have the following problem in question: I made an array list to list data in a combo box, but it only lists the data in the first table, in the case: "catdesc", which is the description of a car category, whether it is Sports, etc. B...
asked by 19.04.2016 / 03:35
2
answers

View data from a database in modals

I made a table to present 2 data from the database, and then on each line I put an icon so that when I clicked it there would appear a modal with the information of that line of type: <? $sql = mysql_query("SELECT a.n_proces...
asked by 19.04.2016 / 01:59
1
answer

retrieve DateTime in MySQL between current date

In my database I have 2 fields: "start_date" and "end_date". From a current DateTime, I need to select all dates that are in the range where date_time > = start_date AND date_time < = end_data. I did the following query and it did not work...
asked by 15.03.2016 / 13:24