Questions tagged as 'query'

Tagged questions
2
answers

How to mount query in PDO with items before concatenated

The question is as follows, in mysql we can concatenate a query and then perform the search, as follows: $cidades = '&& (cidade = 100 || cidade = 101 || cidade = 102)'; $order = 'id ASC'; $sql = 'SELECT * FROM tabela WHERE status = 1...
asked by 13.10.2015 / 22:45
0
answers

Unidac uniQuery component does not return keygenerator value

I'm having trouble inserting into Firebird using Devart's uniQuery component (Delphi 7 with Unidac). The field that is the primary key is in the fieds of the query and the configuration of the component is like this: CAMPO_ID : ProviderFlags...
asked by 25.11.2015 / 19:36
1
answer

User not found in PHP login with BD

I'm trying to login to the system using PHP database but, even using the correct email and password, it does not connect. I think I'm really not finding the record, since it goes through the query but not through the next if. Follow the Login...
asked by 25.09.2015 / 01:08
1
answer

PHP script script from MS Sql for My Sql

Good afternoon. How can I make a query in MS Sql and insert the values into a My Sql table through PHP? Looking at this data, can you do this insertion? #--> conexao mysql require_once("mysql.php"); #--> conexao mssql...
asked by 23.10.2015 / 18:42
0
answers

Multiple queries with a single connection

I'm doing a site where on the same page I need to do several queries, in mysqli. When I run the site on xampp perfect wheel. but not on the web server. Only the first query comes and not one error. It's as if I did not give a sql->cl...
asked by 04.07.2015 / 20:03
0
answers

Perform a String Query

Personal I have the following method and Query: mt_dispositivo = MtDispositivo .where("id_conta = 28 or id_conta = 29 or id_conta = 30 or id_conta = 36") .select('nome, data_criacao, data_atualizacao, tipo_conexao, is_online, status_at...
asked by 10.07.2015 / 16:15
1
answer

Export from SQL to Excel and perform SyntaxError error: unexpected ',', expecting end-of-input

I made this Query MtDispositivo.where("id_conta = 28 or id_conta = 29 or id_conta = 30 or id_conta = 36") This Query returns all the accounts that contain the IDs: 28, 29, 30 and 36. Could you give me a hint of how I perform the code in...
asked by 30.06.2015 / 18:54
0
answers

Problem with aggregate function, using CreateQuery from Hibernate

In a Packaging, a fk Packaging refers to the 'parent', the larger packaging. EX: let's say that inside a package B fit 10 packages A. A packing record A will have in your package the packing B in which it will be inserted. There is a query...
asked by 30.07.2015 / 21:42
0
answers

How to plot multivariate functions with various constraints in the 3D plane with Wolfram Alpha?

I'm studying Calculus II at UFRN and I'm having a difficult time analyzing certain shapes in the 3D plane and so I decided to use Wolfram and its API to help me with my studies. This is a problem with an exercise list: Iwouldliketoplotonthewo...
asked by 10.04.2015 / 06:15
2
answers

How to separate records into blocks for parallel processing?

I have a table in SQL Server that makes the control of messages to be sent and a routine in C# , configured in a Cron, that selects the pending messages, sends and marks as sent. What I'm implementing is the ability to configure...
asked by 20.04.2018 / 21:18