Questions tagged as 'select'

Tagged questions
1
answer

Limit and Offset for web paging in SQL Server

I'm working with PHP and I have about 8000 records currently in DB. As it is for a web page, I need to make a pagination to be viable reading the data. As I understand it, I have to do something similar to limit and offset to...
asked by 28.11.2016 / 13:35
1
answer

Select with re occurrences of a period record

I need to know if a record has occurred again in a 7-day period. For this, I have a table that saves the records and the date of occurrence. For example: Registro: x | Data: 13/03/2017 Registro: y | Data: 14/03/2017 Registro: x | Data: 17/03/2...
asked by 04.05.2017 / 16:14
1
answer

How to pass Pervasive SELECT DB parameter

I'm having to work with Pervasive database, so I'm having trouble passing a parameter to make a SELECT I've tried using: DBCmd.Parameters.Add("@inicio", PsqlDbType.VarChar).Value = date_inicio; DBCmd.Parameters.Add("@fim", PsqlDbType...
asked by 02.04.2017 / 00:03
0
answers

Insert Sequential Number in a C #

I have this table called ArticleBarCode : IntheCodecolumnIneedtoenterasequentialnumber,ieIhavetoreadthemaximumnumberthatisthereandinsertthenextonethatisavailable!Ihavetousethefollowinglineofcodetoseewhattheavailablevalueis:SELECTISNULL(MAX...
asked by 27.04.2017 / 17:52
1
answer

How to keep option after refresh - asp.net

I have a select, some options and a jquery code that does not change the select, updates the screen with the data of the chosen option. The question is, how do I maintain the option after the window.location? Note: I'm using Asp.Net Code...
asked by 30.03.2017 / 22:39
1
answer

Verifying that the database column value contains only numbers in the select

I need to find out if the value of a given column of the database contains only numbers in the select itself, because if it is numeric, I need to display the value of another column. I use an ORACLE database. Can anyone help me with this p...
asked by 30.03.2017 / 19:55
0
answers

Customize select and understand CSS effect

see this example I'm doing about customizing a select and an input link Note the effect of the input, click on the text box and you will see that the bottom edge has a nice smooth effect, even beauty. The problem is that I am not able...
asked by 22.03.2017 / 21:38
1
answer

doubts with select and angular Js

I'm using select and angularJs, my selectize is set up like this : no controller //configurando o select mrdicamento $scope.selectize_medicamento = { plugins: { 'remove_button': { label: '' } }, max...
asked by 06.01.2017 / 08:21
0
answers

How to dynamically initialize a select2 in angularjs

Hello everyone, I'm using the select2 plugin in my project. I need to create multiple selects2 dynamically, by angular. I have a vector of objects (with id, name) and I need from an event, in a function to generate a select to of each object, be...
asked by 25.10.2016 / 22:34
0
answers

PIVOT Help - SELECT SQL [closed]

I have a table with the data: unidade tipo valor 1 2 10,00 1 3 15,00 2 2 16,00 3 3 10,00 3 1 25,00 I need to make a select pivot that swallows me unidade tipo1 tipo2 tipo3...
asked by 16.09.2016 / 16:58