Skip to content

Instantly share code, notes, and snippets.

View byronferguson's full-sized avatar

Byron Ferguson byronferguson

View GitHub Profile
<div ui-view="root">
<nav ui-view="navbar">NAV</nav>
<section ui-view="app">
<main ui-view="content">CONTENT</main>
<aside ui-view="sidebar">SIDEBAR</aside>
</section>
<footer ui-view="footer">FOOTER</footer>
</div>
{
"prebuild": [
"angular",
"angular-ui-router",
"angular-utf8-base64",
"ng-fastclick"
],
"paths": {
<section md-content id="main" role="main" layout="row" layout-align="space-around start" layout-padding>
<article flex="15" ui-view="body" style="background-color:red;" layout="column" layout-align="start center" layout-padding>
<img width="125" height="125">
<h4 class="md-subhead">Byron Ferguson</h4>
Olathe South High School
</article>
<article flex="50" ui-view="body" style="background-color:orange;" layout="column" layout-align="start center" layout-padding>
<section class="md-whiteframe-z1">
<md-toolbar class="md-primary md-default-theme">
'use strict';
angular.module('app.interview').controller('interviewCtrl', function ($scope, $stateParams, $modal) {
var vm = this;
vm.tooltip = '<h1>interviewPageTooltip <code>HTML</code></h1>';
vm.open = function () {
var modelInstance = $modal.open({
animation: true,
@byronferguson
byronferguson / eventExport
Created October 27, 2015 15:20
#1242 subquery error on second SELECT run
SELECT post_date AS event_post_date,
post_title AS event_title,
fnStripTags(post_content) AS event_content,
CONCAT('http://www.kcstudio.org/event/',post_name) AS event_URL,
(SELECT meta_value FROM wp_postmeta WHERE wp_postmeta.meta_key = 'thumbnailURL' AND wp_postmeta.post_id = wp_posts.ID) AS event_thumbnail_URL,
(SELECT (CASE meta_value WHEN meta_value REGEXP '^[[:digit:]]+$' THEN meta_value ELSE CONCAT('$', meta_value) END ) FROM wp_postmeta WHERE wp_postmeta.meta_key = '_EventCost' AND wp_postmeta.post_id = wp_posts.ID) AS event_cost,
(SELECT DATE_FORMAT(meta_value, '%W') FROM wp_postmeta WHERE wp_postmeta.meta_key = '_EventStartDate' AND wp_postmeta.post_id = wp_posts.ID) AS event_start_day,
(SELECT DATE_FORMAT(meta_value, '%M %D, %Y') FROM wp_postmeta WHERE wp_postmeta.meta_key = '_EventStartDate' AND wp_postmeta.post_id = wp_posts.ID) AS event_start_date,
(SELECT TIME_FORMAT(meta_value, '%r') FROM wp_postmeta WHERE wp_postmeta.meta_key = '_EventStartDate' AND wp_postmeta.post_id = wp_po
@byronferguson
byronferguson / app.scripts.json
Last active October 28, 2015 20:14
Current Gulp build process
{
"prebuild": [
"angular",
"angular-animate",
"angular-ui-router",
"angular-bootstrap",
"angular-bootstrap-tpls",
"angular-utf8-base64",
"ng-fastclick"
struct
Detail [empty string]
ErrNumber 0
Message Object of type class java.lang.String cannot be used as an array
StackTrace coldfusion.runtime.NonArrayException: Object of type class java.lang.String cannot be used as an array at coldfusion.runtime.Cast._List(Cast.java:1378) at cfQuestionFormats2ecfm1914422829$funcSINGLE.runFunction(C:\ColdFusion11\cfusion\wwwroot\myccmajors\test\includes\QuestionFormats.cfm:12) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:383) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:334) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:231) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:2845) at cfoptions2ecfm700512126.runPage(C:\ColdFusion11\cfusi
[
{
"oID": 369,
"oValue": 40,
"tValue": ""
},
{
"oID": 370,
"oValue": 20,
"tValue": ""
SELECT (sr.studentResponseValue * cw.categoryWeightValue) AS weightedResponse
, cw.occupationalCategoryID AS cID
, iqo.interviewQuestionOptionID AS oID
FROM dbo.StudentResponseTable AS sr
INNER JOIN dbo.InterviewQuestionOptionTable AS iqo
ON (sr.interviewQuestionOptionID = iqo.interviewQuestionOptionID)
AND (sr.studentID = @studentID)
AND (iqo.interviewQuestionOptionActive = 1)
INNER JOIN dbo.CategoryWeightTable AS cw
ON (sr.interviewQuestionOptionID = cw.interviewQuestionOptionID)
studentID cID studentRank suggestedRank
459 5 1 1
459 25 2 3
459 3 3 2
459 7 4 11
459 20 NULL 4
459 19 NULL 5
459 4 NULL 6
459 2 NULL 7
459 14 NULL 8