I'll create a button, which when I click it, it reads a JPEG image and can convert it to PDF and save to disk.
I would like a hint in source code so I can start this project.
Thank you very much.
I have a table of this format
RELATIONS
-----------------
ID | ID_1 | ID_2
All in INT and ID is auto incremental.
It is filled in this way:
ID | ID_1 | ID_2
-----------------
1 | 1 | 5
-----------------
2 | 5 | 1
--...
I have a BIG problem in a SELECT:
I have two Tables' adwords_performance 'and' analytics_transaction 'and I need to do a SELECT by adding columns' adwords_performance.clicks ', '< strong> adwords_performance.impressions 'and' analytics...
Let's say I have a table named ALUNOS , with 3 columns, ID , NAME , SOBRENOME
And I want to get all the names, but in a way that does not double if one student has the same surname as another student.
I have a Endereco table that serves both Funcionario and Vendor:
1 Funcionario possui 1 Endereco
1 Fornecedor possui 1 Endereco
How do I create this relationship without having inconsistencies?
The code is as follows:
SELECT data
FROM lista
WHERE data BETWEEN '01-08-2015'
AND '05-08-2015';
The problem is that the date column is a varchar and I would like to use it as a date
I have the following beginning of function sql that I will use for a procedures / function recreation system in C #
Create Function dbo.JN_FN_DataAtual(@TESTE INT)
And I created the regular expression
(?si)\bCREATE\s*\bFUNCTION?\s*(?&l...
How to store the last 100 searches made to a site (PHP / MYSQL) divided by country (eg store the last 100 searches for Macedonian books). Search is a simple simple field:
<input type="text" id="search" name="search" placeholder="Search" /&g...
We have the culture to only make logical exclusions in the application, maintaining 2 fields where 1 is the deletion date and another one that receives 'S' or 'N'.
When we perform searches for undeleted records, we do something like:
select...
I'm making an update to table A which will receive values from Table B
as a.codigo = B.folha
When running the routine below, it is slow and nothing happens for a long time. There are 500,000 lines. It's normal or I have to wait or the...