Questions tagged as 'sql'

0
answers

Class 'Db' not found

I have a php script that I pulled from Github - indieteq For SQL, but it turns out that when I try to include it in other files, whether with include, require, the files do not recognize the Db class You can see the php script link My co...
asked by 01.07.2018 / 21:12
1
answer

How to serialize PHP data by connecting to SQL to show in a select in html (Does not show the value)

I would like you to help me with this code that I am solving for a university project. It turns out that I have 3 Tables that I want to show it in different select I am working with the MVC, where we have a general controller, for this contro...
asked by 01.07.2018 / 18:23
0
answers

It does not show my saved data. (php / MySQL / SQL)

I have a form connected to MySQL but when I enter the information it does not register and it does not save it in MySQL. This is the code in PHP: <?php Include 'conexion.php'; $nombre=$_POST["nombre"]; $apellido=$_POST["apellido"];...
asked by 30.06.2018 / 02:49
1
answer

Help with epplus formulas (Excel) c #

I'm doing an excel in which I made some formula, but when I take a cell that is the result of a formula, to use it in another formula it shows me in the cell literally the formula. As it is highlighted in the colors yellow is the range...
asked by 29.06.2018 / 00:13
1
answer

ORACLE SQL CASE ERROR FROM KEYWORD

I am looking for solutions to the error that is presented to me at the time of writing this query (I am new to the platform, I regret the inappropriate documentation of the code): SELECT EVALUATION CASE WHEN EVALUATION = '1' THEN 'Malo'...
asked by 27.06.2018 / 05:56
0
answers

See images of mysql in jsp

a query when I want to see some images that I upload to mysql on my page does not show me the image, I do not understand the error I hope you can help me. Code to upload: String cadena1,usu,pass; int tamaño; Image i;...
asked by 30.06.2018 / 09:51
0
answers

SQL query does not filter by combo

I have a query in sql that according to a combo search by families of the product, work shifts or code of a product, both the code and the work shift if I do the query but by the group or product family no. could you help me I'm a bit new to SQL...
asked by 29.06.2018 / 16:53
0
answers

Report Viewer does not present data

I managed to do everything correctly in the Oracle connection and everything works for me, but when the web form appears, the report viewer reports nothing. This is my code: using System; using System.Data; using System.Data.OleDb; using Micro...
asked by 26.06.2018 / 21:05
0
answers

Get a particular date for each SQL ID

I am trying to get the next available date from a calculation that I show acontinuacion. That's the query I'm using but it does not work. SELECT DateID = ROW_NUMBER() over (order by B.Date_Key) ,C.FundDate FROM DIM_DATE B LEFT JOIN DIM_St...
asked by 25.06.2018 / 19:12
1
answer

How to relate from many to many in Eloquent (Laravel)

I am using MySQL as a database and Eloquent as ORM. I have been creating a page that is of food or dishes, in which I already have related the meals with the chef that prepare it, so I have them : Table foods (meals) publi...
asked by 16.07.2018 / 21:55