Skip to content

Instantly share code, notes, and snippets.

@robgcf
robgcf / gist:601da8bb5fcbe95bd8f62f64aa0bec0f
Created October 13, 2017 21:05
select with a subquery
select p.proposalname, p.proposalid, p.createdDate, u.lname, u.fname, p.clientid, c.clientname, cust.customername, ct.lname + ', ' + ct.fname as contactname,
e.eventname, e.eventid, (
select top 1 activityDate
from proposalActivity
where proposalid = <cfqueryparam value="#arguments.proposalid#" cfsqltype="cf_sql_integer">
and contactid > 0
order by activityDate desc
) as activityDate
from proposals p
etc etc etc
// Here's the javscript:
var myDropzone = new Dropzone(".dropzone"); // this causes an error: "dropzone is already attached"
Dropzone.options.myDropzone = {
dictDefaultMessage: "Drop files here or Click to upload",
paramName: "file",
maxFilesize: 5
};
@robgcf
robgcf / gist:86a996d640f86aa412b4
Created April 30, 2014 20:41
Slatwall reload
reload=true&update=true
@robgcf
robgcf / gist:9a9f2d53839e537d2b48
Created April 30, 2014 16:53
Mura Apply DB Updates
?appreload&applydbupdates
Use when Mura core gets out of sync with the database.