SysBlog

<cfset var Local = structNew()>

<!--- create instance of edtftpj.jar custom FTP --->
<cfset Local.ftp = createObject( "java", "com.enterprisedt.net.ftp.FileTransferClient" ) />

<cfset Local.ftp.setRemoteHost( "test.com" ) />
<cfset Local.ftp.setUserName( "mirko" ) />
<cfset Local.ftp.setPassword( "*************" ) />
<cfset Local.ftp.connect() />

<cfset Local.ftp.changeDirectory('/mojfolder') />
<cfset Local.aFiles = ftp.directoryList(".") />
<!--- Proceed only if folder has contents --->
<cfif arrayLen(Local.aFiles)>
 <!--- Loop through ftp directory contents (files and folders) --->
<cfloop from="1" to="#arrayLen(Local.aFiles)#" step="1" index="Local.index">
 <!--- Download only files and not folders --->
<cfif Local.aFiles[Local.index].isFile()>
 <!--- Set the local file name and download to it --->
<cfset Local.cFileName = aFiles[Local.index].getName() />
<cfset Local.cLocalFile = Local.cLocalFolder & Local.cFileName />
<cfset Local.ftp.downloadFile( Local.cLocalFile, Local.cFileName ) />
 </cfif>
</cfloop>
</cfif>

<!--- Disconnect --->
<cfset Local.ftp.disconnect() />

https://stackoverflow.com/questions/19688365/coldfusion-cfftp-action-listdir-returns-nothing

ListQualify “oblači” elemente liste u neki znak ispred i iza elementa

Uvo dodaje jednostruki navodnik ispred i iza svakog elementa liste:

<cfset temp = ListQualify(myList,"'",",","CHAR")>

https://helpx.adobe.com/coldfusion/cfml-reference/coldfusion-functions/functions-l/listqualify.html

<cfset queryAddColumn(myQuery, “ime_i_prezime”, myQuery["Podaci"])>

Kreira u queryju novu kolonu “ime_i_prezime” i puni je sadržajem postojeće kolone “Podaci”

Problem: WHERE X = ako je dostupno A selektiraj A,  a ako nije selektiraj B ako je B dostupno, a ako nije ni B dostupno selektiraj C…

SELECT * FROM tbl_test WHERE  tbl_test.lang = (
COALESCE(
(SELECT TOP 1 lang FROM tbl_test2 WHERE  lang='mk' ),
(SELECT TOP 1 lang FROM tbl_test2 WHERE lang='en'),
'hr'
)

No što ako želimo selektirati ovako: ako je dostupno A selektiraj A,  a ako nije selektiraj B ako je B dostupno, a ako nije ni B dostupno selektiraj C ali ne u WHERE uvjetu nego u samom selectu:

SELECT
COALESCE(TBL1.partner_id,TBL2.partner_id) as partner_id,
COALESCE(TBL1.event_title,TBL2.event_title) as event_name,
COALESCE(TBL1.lang,TBL2.lang) as lang
FROM
(SELECT partner_id, lang, event_title FROM tbl_a WHERE tbl_a.lang = 'HR') AS TBL1
FULL OUTER JOIN
(SELECT tbl_a.partner_id,tbl_a.lang,tbl_a.event_title FROM tbl_a WHERE tbl_a.lang = 'EN') AS TBL2
ON TBL1.partner_id = TBL2.partner_id

ListFind traži točan traženi pojam kao item liste. Ni više ni manje.

listFind(“Date,Decimal,Image,Integer,Long Text,Rich Text,Simple Text”, “Text”)=0

ListContains traži pojavu pojma u dijelu itema liste.

listContains(“Date,Decimal,Image,Integer,Long Text,Rich Text,Simple Text”, “Text”)=5

http://nm1m.blogspot.si/2010/09/listfind-vs-listcontains.html

Problem: u bazi je datum u polju varchar u obliku yyyy-mm-dd i zanima nas sve gdje je taj datum između danas i za 30 dana

Rješenje: varchar castati kao date. Ali i getdate() castati kao date jer getdate() vraća datetime

SELECT * FROM tablica

WHERE DatumVarchar is not null

AND CAST(DatumVarchar  as date) >= DATEADD(d, 0, DATEDIFF(d, 0,  CAST(GETDATE() as date)))

AND CAST(DatumVarchar as date) <= DATEADD(d, 30, DATEDIFF(d, 0,  CAST(GETDATE() as date)))

Problem: Poredati rezultate SQL upita po nekom svojem poretku koji nema veze sa samim rezultatima sql upita.

Rješenje:

SELECT tbl_test.*
FROM tbl_test
INNER JOIN(
 VALUES
 (1,1),
 (3,2),
 (2,3),
 (4,4)
) AS dtbl_list (id, ordering) on tbl_test.id = dtbl_list.id
ORDER by dtbl_list.ordering

Source: https://stackoverflow.com/questions/866465/order-by-the-in-value-list

Problem:

var x = 123;

Zanima nas length varijable x.

Rješenje:

var x = 123;
x.toString().length;

// Initialize Foundation's equalizer on non-mobile
 $(window).on("load resize",function(e){
 var equalize = true;
 if ($(document).width() <= 640) {
 equalize = false;
 }
 $(document).foundation({
 equalizer : {
 equalize_on_stack: equalize
 }
 });
 });

Izvor:

https://foundation.zurb.com/forum/posts/6492-disable-data-equalizer-for-small

Problem: zanima nas popis proizvoda koji su dodani u košaricu unutar 24 sata. Dakle, ne 1 dan jer je između 23:00 i 01:00 drugi dan razlika od jednog dana, ali od samo dva sata.

Rješenje:

SELECT

TIMESTAMPDIFF (HOUR, tbl_kosarica.vrijeme_dodavanja, NOW())  as difference

FROM

tbl_kosarica

WHERE TIMESTAMPDIFF(HOUR, tbl_kosarica.vrijeme_dodavanja, NOW()) < 24