Questions tagged as 'sql'

0
answers

Error inserting records in SQL Server (BULK INSERT)

I have a problem inserting the records of a table with the BULK INSERT command. BULK      Insert product from 'C: \ csv \ products.csv' with (firstrow = 2, fieldterminator = ', ', rowterminator =' \ n ') This is the error that com...
asked by 23.10.2018 / 05:48
2
answers

SQL date format

I have created the following table in a SQL database: create table session( SessionId int auto_increment unique, SessionIni datetime, SessionFin datetime, UsHGTAG int, PcId int, primary key (SessionId) ); How...
asked by 28.08.2018 / 07:31
0
answers

Update BD record from a modal with javascript

Good I am doing modifications of the Bd from manners. I have everything done but it returns an error that I could not do the update, any suggestions ??? The data to the modal sent them like this: <script> $(document).ready(fun...
asked by 16.08.2018 / 00:31
1
answer

get a data of the last insert made

The case is as follows, I have two related tables in postgres, understand Urbanization and Houses in Urbanizacion we have the following data idurb(PK-NoIncremental,varchar)| nombreurb | calle | idcasas(el campo idcasas es una FK ) and...
asked by 23.10.2018 / 04:11
1
answer

Change a value of a specific row of my bd

I am trying to access the table of my bd, to change a value "revision" (now it is worth 1 and I want to pass to 2) of a specific row using its id. Although the error gives me at the time of ending the connection, I think I'm doing the query w...
asked by 14.08.2018 / 14:06
3
answers

I must consult a field in a table and see if there is a value

In a table I have the CM1_CUENTA field where a user can have many accounts but I need to know if among all of them exists the numbers 2365xxxx or 53152001 to perform an action and if none exists, perform another action. consulta2 = "SELECT * F...
asked by 10.08.2018 / 22:39
0
answers

Update to an SQL Column with Excel inormation

I'm really not sure how to attack this problem. I have a users table: id nombre dato 1 juan 1a 2 pedro 2b 3 paco 3c An Excel document with the name document : A 1 01a 2 02b 3 03c My intention is that through a PH...
asked by 22.08.2018 / 19:08
2
answers

System check if there were payments from the 1st to the 5th of each month

is a condominium payment system and it is required to show if the owners paid in the range of 1 to 5 of each month I have the following but it does not do anything to me, it remains blank and the table does have data <?php session_st...
asked by 01.09.2018 / 23:37
0
answers

Error when registering object with list of objects with reference to other objects obtained from another context ENTITY FRAMEWORK C #

I'm having a problem. This is my domain: Class1 List classes2; Class2 Class3 class3; Class4 class4; To create class 2, I consult a context that returns Class 3 and Class 4 (both 2 already exist) After creating it (class2),...
asked by 30.08.2018 / 17:37
3
answers

can not read property 'value' of undefined

I'm trying to make a quick add button to the cart but I have a problem and it is that I get the error:    Can not read property 'value' of undefined ' I am using ajax and php. I do not know what the problem could be, that is why I come to...
asked by 17.08.2018 / 21:11