Questions tagged as 'sql'

Tagged questions
0
answers

Select Advanced separated by hour

I set a SELECT to return some information from my separate table by time and date. Until that part everything is working correctly. Now I need it to select the same data only from another date, which is the same table. My SELECT...
asked by 29.07.2015 / 15:17
1
answer

Send sensor data to a bank

Hello, I am sending data from a sensor to a website through the URL. I want to transfer this data to a SQL database so I can display it in an ASP.NET application I made. Can anyone tell me how to transfer this data from url to database?  ...
asked by 05.08.2015 / 20:48
6
answers

Is it wrong to write byte of images in the database?

When should I make this direct recording at the bank? What are the situations? I know I can save the image path to the bank.     
asked by 11.04.2014 / 18:53
0
answers

Different results for query Mysql 5.1 and 5.7

We developed a project for a client using MySQL 5.1.68 and at the time of publication we identified that the client's hosting was version 5.7.4. Once the project has been published, we begin to see some strange behaviors in the results return...
asked by 01.09.2015 / 12:54
1
answer

Determining value within a pivot

I have a query where you are doing a pivot and it is bringing the correct records per month, however I would like to validate the amount of records per month that shows only employees who have >= 16 in every month! Today the qu...
asked by 18.09.2015 / 19:00
1
answer

Ms access 2 querys for the same comboboxes

Good to all I'm programming a database and I would like to have a kind of 3 querys. I'll try to be as accurate as possible. I have 2 combo boxes that are interconnected, in this case I specifically make and model, and when I choose the brand, it...
asked by 01.07.2015 / 22:13
1
answer

Stored procedure loop

I put this procedure, it makes the query inside the cursor right, but when I give select in SPA_VALOR_ACOMODACAO , it returns 0, which was set before loop_duracao . It looks like it's not entering loop_duracao . What would it b...
asked by 14.09.2015 / 21:08
0
answers

Load multi-attachements into multiple form attachments

I'm trying to create a function to upload multiple files at the same time but I think that because I'm choosing the next function does not really attach the file, but rather creates a preview. In my opinion, what's wrong with the code is:...
asked by 03.07.2015 / 17:49
1
answer

Multi attchement upload function

I'm trying to create a function to upload multiple files at the same time but even with only one I get an error. What can I be programming wrong? 'FILE DIALOG OPENS UPLOAD PANEL Private Sub Comando715_Click() Call Selectfile End Sub The fun...
asked by 03.07.2015 / 13:09
0
answers

forein key reference, with the Entity Framework

To have a difficulty doing an insert , because the EF indicates that there is an error in the table reference. But in my config , I indicate what is the foreing key . My config: public class TestDriveConfig : EntityTypeConfiguration<T...
asked by 14.08.2015 / 19:52