Questions tagged as 'sql'

Tagged questions
1
answer

my query in sql does not recognize the parameter I sent from javascript

good afternoon programmers I have a doubt and I hope you help me I am developing a system in javascript and php and sqlserver, the problem is as follows this is the part of php in which he sent the javascript parameter that is "USU" and...
asked by 01.08.2018 / 22:27
0
answers

SQL: Replace (Access)

|ID|cuenta| |ID|cuenta| |1 |"312" | |1|"0" | |2 | "422"|---------> |2|"312" | |3 | "55" | |3|"422" | Hello, I am looking for a query that can replace a data from one record with another from the same colum...
asked by 20.07.2018 / 18:07
1
answer

Know which checkbox in a cycle have been selected?

My question is how can I know which checkboxes have been selected to update the text type input that contains that checkbox? looks like this: the table and the checkbox is inside a loop which prints as many tables as the sql query ha...
asked by 19.07.2018 / 20:12
1
answer

Register data from nested tables with transaction VB.NET

My problem: I have a database and several related tables, inside a button I want to add more than two tables instantly in nested form: I explain: (In this example) I have a main and a secondary table, they are related, and what I want to d...
asked by 23.07.2018 / 23:34
0
answers

Warning: sqlsrv_has_rows () expects parameter 1 to be resource, boolean given (using inner join)

I need help with this, I did not come across any surprises until I had to perform a inner join . It's the first time I use one with php. Maybe my syntax is incorrect. <!doctype html> <html> <head> <meta charset="utf-8">...
asked by 24.07.2018 / 03:41
0
answers

use shadowbox.js with variable href which is loaded from sql and json

Hello friends, I hope you can help me, what happens is that I try to show a sahdowbox from javascript and json code and I make a sql connection through a webmethod. The way I'm trying to show the shadowbox is like this: <br> $.ajax({...
asked by 07.08.2018 / 20:12
0
answers

How to group records from a parent record?

I'm doing the list of pages to be able to add permissions to that user, but I have some inconveniences regarding the listing. What I want to do is list the pages according to the parent record and separate them by a space. Here I have the...
asked by 18.07.2018 / 16:39
0
answers

SQL query from python does not return the entire table

Currently in my SQLite, I have a Person table like the following: And another table Age like the following: The Person table is traversed with the following method: def print_tabla_person(cursor): for fila in SQL_ge...
asked by 18.07.2018 / 10:15
0
answers

How to send Spring MVC a JSON of a formula with ExtJS (6.2.0)?

I'm making a Login using Spring MVC and ExtJS version 6.2.0. It does not work for me and I have already surfed without finding the solution since I pick up the username and password and supposedly send it to my Spring driver and there process th...
asked by 21.07.2018 / 16:31
1
answer

Place boundary in relation one to many php laravel

I'm doing an app in laravel, but I get to a situation where the DB relationship is one to many users - articles, so my problem is that I want to place a limit that users can only add max 5 articles, I've been looking for, but nothing I try to tr...
asked by 25.07.2018 / 18:10