Questions tagged as 'mysql'

Tagged questions
1
answer

how do I pass this query [from mysql to sqlserver?

SELECT id_rubro, rubro, name_e AS Empresas FROM dbs_empresas, p_rubros WHERE rubro_id = id_rubro AND activa_e='Y' GROUP BY rubro ORDER BY rubro I get this error    Mens. 8120, Level 16, State 1, Line 1   Column 'e_rubros.id_rubro' is invali...
asked by 28.12.2017 / 23:21
0
answers

How to put the title and the votes in each item of the carousel?

Very good to all dear friends, I hope you help me with this. I have a voting system I LIKE OR I DO NOT LIKE and I wanted to put it on every item of the boostrap carousel. I have a database in which is a ID-MEGUSTA-NOMEGUSTA-TITULO in which the m...
asked by 28.12.2017 / 21:25
0
answers

The SelectCommand.Connection property has not been initialized. MySql

It turns out that I'm working with SignalR, where in the html view I make the following request to the client: var myHub = $.connection.myHub; var direccionWeb = $("#direccionWeb").val().toString(); $.connection.hub.url = dire...
asked by 27.12.2017 / 18:51
1
answer

Native development environment for Firebird databases

I am looking for a native development environment for Firebird databases, ie SQL Server Management for SQL Server or MySQL Workbench for MySQL. I hope you can help me. Greetings     
asked by 03.01.2018 / 17:23
0
answers

Query Was Empty why?

I have the following code and it appears on the screen at the beginning of the table: Query Was Empty $userId=$_SESSION['u_id']; $resultMyVouchers="SELECT oc.order_id, oc.order_amount, oc.coupon_id, oc.products_id, oc.purchased_by, oc.order_t...
asked by 04.01.2018 / 21:03
2
answers

Update text pattern in the entire database

I have the following scenario: I have mysql server and defined multiple database and tables. the some fields of these tables I have text that includes the name of documents Example 1: DocRel CCTR0000007 example 2: Memo el documento CCTR00...
asked by 04.01.2018 / 22:41
1
answer

Error: Base table or view not found (Laravel 5.5)

This is the error: "SQLSTATE[42S02]: Base table or view not found: 1146 Table 'codearte_site.posts' doesn't exist (SQL: select count(*) as aggregate from posts )"    It happens to me with all the projects that I have in larav...
asked by 22.12.2017 / 22:28
0
answers

Problem when inheriting PDO class in class Conexion

Greetings, I raise my problem. Create a class called Connection in which I have the constructor method that will contain my connection. I have two problems: 1- When creating the Connection class in this way: <?php class Conexion{ pr...
asked by 27.12.2017 / 03:03
1
answer

mySQL - LOAD DATA INFILE + format variables

Good morning, I am loading information from a txt file and, in doing so, I want to format all the variables in a column. In particular, I am in charge of DATETIME information, which comes as a string, and I want to give it the correct form...
asked by 27.12.2017 / 11:42
1
answer

Error when consulting data inheriting methods

Greetings guys. I am working on a project in PHP Oriented to objects with PDO, it turns out that I am doing the tests of the methods and I was presented with an error in the query by id. I proceed to explain my code: First I have my class Con...
asked by 26.12.2017 / 22:08