Questions tagged as 'sql'

2
answers

Problem with mysqli_fetch_object ()

Good afternoon friends and colleagues. I have the following code that gives me:    Warning: mysqli_fetch_object () expects parameter 1 to be   mysqli_result, boolean given Can you help me? function login($u = "", $c = "", $forzar = fals...
asked by 21.12.2016 / 17:49
3
answers

Insert data from a DataTable into an SQL table

I need help on how to INSERT data from a DataTable to an SQL table. The code of my DataTable is as follows: public DataTable dtDetalle = new DataTable("Detalle"); public DataTable filldata() { dtDetalle.Columns.Add("idProducto", Type.GetT...
asked by 30.07.2016 / 17:47
1
answer

Save each row in an array when submitting a form

I'm doing a form that takes information from a mysql database and php shows it in a form with checkboxes, my question is this: How do I save each selected row in an array? This is the code that creates each row of the form: while($row =...
asked by 03.08.2016 / 02:25
2
answers

The input string does not have the correct format. C #

First of all sorry for so many questions that for many of you must be insignificant things I imagine, (apprentice mistakes say) The subject is like this: I have properties, each property has date ranges (start date and end date) I did the follow...
asked by 15.07.2016 / 23:03
1
answer

Concaten fields from a subquery

I have the following query in sql sever 2014 CREATE TABLE #TEMPTABLE ( ID INT, DATACOLUM VARCHAR(5) ) INSERT INTO #TEMPTABLE VALUES (1,'A'),(1,'B'),(1,'C'),(2,'D'),(3,'E'),(4,'F') SELECT TB.ID, STUFF((SELECT ',' + D...
asked by 24.05.2017 / 19:18
1
answer

Update [closed] does not work

I have a table plazas with the attributes NUMPLAZA , OCUPACION , IDusuario I want to change the value of OCUPACION to OCUPADO using the following query from php: elseif ($row['Cargo'] == "directivo2") {...
asked by 24.05.2017 / 14:35
1
answer

How to add +1 one to a Name in case of repeated registration?

I have a column called NOMBRE . In this there are three patients called "Juan". What I want is to distinguish them by adding a number followed after their name. Something like this: Juan1 Or if there were 30252 records called Juan, pu...
asked by 16.09.2016 / 06:05
1
answer

Php and sql query

I have a problem with an sql query with php, I need to calculate the total of units sold by vendor, I am limiting the number of records to show because the database has hundreds of records, and I am just trying out the query. But when making...
asked by 19.07.2016 / 23:30
1
answer

Create query with LIKE parameterized? (JAVA / UcanAccess)

Good! I come here with a small question: How exactly could a query be written using a Like and be parameterized? I'm using UcanAccess with JAVA. I have a window in my program that requires the use of Like. Try first by writing it "normal" i...
asked by 28.10.2016 / 16:19
1
answer

PHP connection with DBISAM

For several days I have tried to connect to a DBISAM database but I have not managed it, download and install odbc driver and I do excel tests and it works perfect but when I try PHP it gives me an error, this is the script I'm using: <?php...
asked by 04.04.2016 / 23:26