except codeigniter

By
Buscando una manera de conseguir un INNER JOIN TABLE2 ON TABLE1.ID!=TABLE2.ID, encontre que eso no era posible, entonces segui buscando y encontre EXCEPT, pero solo funciona para sql server y oracle creo, pero para mysql no, asi que buscando encontre esto:

$consulta='select table1.* from table1
where not exists (
select table2.idt1
from table2 where table1.idt1=table2.idt1
)'


me funciono, no lo encontre en codeigniter, asi que lo puse como:

$this->db->query($consulta);

recien me entero de esto, seguire posteando lo que aprendo.

Comments

Post a Comment

Popular posts from this blog

add header image itextsharp c#

By
Image
I thought that when you set the margins on ITextSharp document, you set also the margin for the header. but then I realized the margins are just the margins, and there is no headers by default on ITextSharp. In order to add a header in ITextSharp, you have to use PageEvent. And implement the class HeaderFooterFDA2, you can rename that class. To avoid header overlaps your content, when there are a lot of content that break on a new page. You have to set an additional margin on the method WriteSelectedRows(), in my case I added + 70 units. I hope It helps you.
Read more

Basketball in Peru

By
Image
The basketball in Peru is growing, thanks to the globalization, this beautiful sport is getting more fans and a lot of young players. History In the 70´s and early 80's the peruvian basketball was at his peak, they won some southamerica championships, and played at the FIBA world cup. In the 90's until 2022, basketball had many problems, the worst was the disaffiliation of FIBA in 2021. Nowadays In 2023 the national basketball federation was reborn. They organized the u17 national championship, the national league which is the most ranked competition in Peru. And they are on their way to get their affiliation to FIBA again. There is still no professional league but They are in progress. So far the best leagues are "Liga de Basketball de Lima" and "Liga de Basketball de Arequipa". To summarize, Peru is a growing basketball nation, they need a lot of support to get a better basketball environment. All the help is welcomed. If you want to know more about peruvi...
Read more