Questions tagged as 'sql'

Tagged questions
1
answer

Error returning mysql database data

I made a normal form that returns the data in HTML. So I decided to insert images into the database and then gave a warning:    "Notice: Array to string conversion in   E: \ sites \ htdocs \ progdesenv2 \ admin \ acao.php on line 14 " As f...
asked by 23.04.2015 / 23:46
1
answer

PHP return data from the database

I am trying to make a select in the database for testing, this select displays the user data after entering username and password. The error happens after select :    Warning: mysql_fetch_array () expects parameter 1 to be...
asked by 27.03.2015 / 12:11
1
answer

How to perform union operation

I'm trying to do an operation with this two query but I do not know how. select sum(total_atend) total_atend, sum(total_infect) total_infet From ( select count(atendime.tp_atendimento) total_atend, 0 total_infect from atendime, paciente wher...
asked by 13.02.2015 / 17:21
1
answer

Remove part without fixed size from an xml

Galera, I have this piece of XML and I need to remove the value (357122.40) that is between the < vMerc > xxxxxx < / vMerc > However, this value does not have a fixed size. ...<infCTeNorm><infCarga><vMerc>357122.4...
asked by 10.04.2015 / 20:15
1
answer

Displaying null results for mysql related tables

I need to create a relational query that returns records containing data from both the PERMISSION table and the USERS table. ALL PERMIT records must be displayed. When no records exist in the USER, NULL must be displayed. PERM_USU is used to rel...
asked by 18.02.2015 / 16:10
4
answers

SQL query with ID from a combobox - C #

I am building a small system where I created a Formulario where there is a Combobox that lists the names of employees stored in the database and a DataGrid that shows the services done by them (value, description and client...
asked by 25.02.2015 / 18:33
2
answers

Android: Problem fetching last id inserted with SQLiteDataBase (ORM Lite)

I'm having a problem executing a query (with ORMLite) that adds the return to 'lastConfiguration' in which you should get the last 'id' inserted in the Configuration table. The method that looks for the last configuration is as follows: publ...
asked by 23.02.2015 / 23:57
1
answer

Incremental key

People, I'm doing a web service with Java + Postgres. I set my table in Postgres as follows: CREATE TABLE usuario ( id serial NOT NULL, nome character varying(40), idade integer, CONSTRAINT usuario_pkey PRIMARY KEY (id) ) WITH ( OIDS...
asked by 16.03.2015 / 01:18
1
answer

How to select smaller record by field

How can I display the least factor by ID_ACORDO? SELECT LIGACOES.ID ,ACORDO.ID_ACORDO ,ACORDO.DATA as 'DATA_ACORDO' ,LIGACOES.time_of_contact AS 'DATA_LIGACAO' ,ACORDO.data-LIGACOES.time_of_contact as FATOR F...
asked by 07.07.2015 / 00:00
2
answers

Change SQL SERVER SA Password with Windows Admin Account

I received a machine with an instance of SQL Server 2008 installed, I can access that instance through SQL Server Management Studio Express with my Windows administrator account but I can not take any action within the instance due to not having...
asked by 17.12.2014 / 13:04