This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
WITH mint_cte | |
( | |
id, | |
user_identity, | |
questiontext, | |
choicetext, | |
value, | |
minttype, | |
userguid | |
) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
///////////////////////////////////// | |
// Variables //////////////////////// | |
// AP to analyse | |
var apName = "Upper Floor"; | |
// Timeframe to filter | |
var startTime = new Date("1 Feb 2015 16:35:33"); | |
var endTime = new Date("1 April 2015 16:35:33"); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Private Sub NewData_Click() | |
'Select sheet by name | |
Sheets("OriginalData").Select | |
'Get total rows in column 'a' | |
RowCount = Cells(Cells.Rows.Count, "a").End(xlUp).Row | |
'Select range from K2 to O and clear contents | |
Range("K2:O" & RowCount).Select | |
Selection.ClearContents | |
'Variable to determin a new row | |
NewRow = 0 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
$loop = ''; | |
$print = ''; | |
for ($loop = 0; $loop -le 100; $loop++) | |
{ | |
$print += [string]$loop + '%@'; | |
} | |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
DECLARE @FormName VARCHAR( 100 ); | |
SET @FormName = 'Your Form Name'; | |
DECLARE @Xmldata XML = (SELECT txtschoolid | |
FROM tblpupilmanagementpupils | |
WHERE intsystemstatus = '1' | |
AND txtform = @FormName | |
FOR xml path( '' )); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// How many hours to summarize | |
var hours = 1400; | |
// User to summarize | |
var user = "Ipad"; | |
var users = db.user.find({ | |
"hostname": new RegExp(user) | |
}); | |
for (var j = 0; j < users.length(); j++) { | |
var user = users[j]; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<style> | |
.STMmenuBar { | |
min-height: 64px; | |
display: inline-block; | |
} | |
.STMmenuBar img { | |
display: none; | |
padding: 3px; | |
border: 1px solid black; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<!--Place the below code snippet just before the closing body tag | |
in the 'YourFFInstallation\Templates\YourTemplateFolder\defaul.xsl' file.--> | |
<!--Load Velocity.js - either from CDN (as below) or your preferred location (local etc).--> | |
<script src="//cdnjs.cloudflare.com/ajax/libs/velocity/1.1.0/velocity.min.js"></script> | |
<script src="//cdnjs.cloudflare.com/ajax/libs/velocity/1.1.0/velocity.ui.min.js"></script> | |
<script> | |
$(window).load(function () { | |
var images = $(".STMmenuBar a img "); | |
images.velocity("transition.flipYIn ", { |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
################################################# | |
$smtpServer="Your SMTP Server" | |
$from = "Your From Email Address" | |
$emailaddress = "Your Send To Email Addressk" | |
$subject = "The reportingServicesReportSelection.asp file has changed" | |
$body = "The reportingServicesReportSelection.asp file has changed, you need to re-add the script" | |
$strReference = "Your Path To An Original Copy Of The File" | |
$strDifference = "Your Path To a Deployed Copy Of The File" | |
################################################# |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<!--Add this line to the form with id="form1" in the reportingServicesReportSelection.asp | |
located in "iSAMS\iSAMS.Framework\modules\StudentManagement\current" --> | |
<input type="hidden" name="userName" id="userName" value="" /> |