Questions tagged as 'sql'

Tagged questions
1
answer

Prestashop: Show products based on SQL

I need to show specific products through a sql that I already have and that works well. JQuery works perfectly for me, but with a button and PHP I do not really know how to do it. The fact is that I have 2 combos on the home page and...
asked by 24.01.2017 / 11:59
1
answer

Problem with the time when editing a java web application record using ejb + jsf?

I'm using Glassfish server 4.1.1, java EE7 web, jdk 1.8 and jsf 2.2 When editing or keeping a record the time or good date also differ between what is stored in the bdd (which is correct) and what the datatable shows (which is incorrect). The...
asked by 26.01.2017 / 21:36
1
answer

Make Previous Next page with mumer as in the image

I would like to split the select ItemID which is a maximum of 25000 records as well as this image but take only SELECT top 255 ItemID FROM PS_GameDefs.dbo.Items so as not to about loading the web. I would like to make this button and inte...
asked by 26.01.2017 / 14:14
1
answer

How to pivot 2 or more SQL Server columns?

I have queries that generate 2 temporary tables, which I need to obtain the total per center and break it down by installed and sold. The first query, creates a temporary table of the dates I need. This second query creates the queries and sa...
asked by 20.02.2017 / 16:42
2
answers

Wordpress: Post and user objects with the same ID

The project in which we are working requires assigning a personalized taxonomy to users who in turn are related to a custom post type, that is, we want to tag posts and users with the same custom term. The problem is that the user object gene...
asked by 20.01.2017 / 19:51
2
answers

how can I add several products to a woocommerce category?

I have been trying to add approximately 200 products to a category but I can not find the solution for this. Would there be any way to do directly from the wordpress dashboard? Or could it be done with SQL in the database?     
asked by 17.01.2017 / 16:46
1
answer

How to eliminate in two tables?

I am developing a fixed assets management system and I have two tables where there are low acquired assets, one tables is bajasaf and the other is distribdebajas . In bajasaf the information is saved as the id_baja, fecha_...
asked by 27.02.2017 / 18:59
2
answers

Error in SELECT with several tables WITH SQL SERVER

Good I am doing a query query only with a select with several tables this is my query in the image that I will attach the following error: DECLARE @Buscar AS VARCHAR(16) DECLARE @NCuota AS INTEGER SET @Buscar=('1010100368233') SET @NCuo...
asked by 16.02.2017 / 16:57
2
answers

Problem with preparedStatement

I'm trying to execute the following commands: stmt=con.prepareStatement("CREATE DATABASE ?"); stmt.setString(1, nombreBase); stmt.executeUpdate(); Doing about select or insert works but doing so with these commands does not al...
asked by 16.01.2017 / 17:30
0
answers

Problem with query and php / ajax

I wanted to ask for help with a problem that I have and I have not been able to find the error, in reality there are 2 problems: Problem 1: I have an error with the query, I have a syntax error (I do not know how to get there but before it di...
asked by 01.02.2017 / 00:21