stevewithington

USE {YOUR-SAP-DBNAME-GOES-HERE};
GO

SELECT
  D3L.POSITION      AS SOURCE_COLUMN_POSITION
  , D2L.TABNAME     AS SOURCE_TABLE_NAME
  , D2T.DDTEXT      AS SOURCE_TABLE_DESC
  , D3L.FIELDNAME   AS SOURCE_COLUMN_NAME
  , D4T.DDTEXT      AS SOURCE_COLUMN_DESC
  , D4T.REPTEXT     AS SOURCE_COLUMN_HEADER

stevewithington

Powershell: Create/Add Windows System DSN via .CSV Import

You can create/add/update/get a Windows System DSN pretty easily with Powershell.

Example dsn.csv file

Database, SystemDSN, Server
AAA, AAA_DSN, SomeIP\User

ChristopherA

Brew Bundle Brewfile Tips

Copyright & License

Unless otherwise noted (either in this file or in a file's copyright section) the contents of this gist are Copyright ©️2020 by Christopher Allen, and are shared under spdx:Creative Commons Attribution Share Alike 4.0 International (CC-BY-SA-4.) open-source license.

Sponsor

If you more tips and advice like these, you can become a monthly patron on my GitHub Sponsor Page for as little as $5 a month; and your contributions will be multipled, as GitHub is matching the first $5,000! This gist is all about Homebrew, so if you like it you can support it by donating to them or becoming one of their Github Sponsors.

croaky

import * as React from 'react'
// routing, etc.

import { Reset } from '~/ui/shared/Reset'

export class App extends React.Component {
  public render() {
    return (
      <div>
        <title>Dashboard</title>

berkedel

How to solve dyld: Library not loaded: /usr/local/opt/icu4c/lib/libicui18n.60.dylib

brew uninstall --ignore-dependencies node icu4c
brew install node

stevewithington

<!--- 
  save this file somewhere under your theme (e.g, custom/tracking-form.cfm), 
  then use [m]$.dspThemeInclude('custom/tracking-form.cfm')[/m] to display it
--->
<form id="trackingform" method="post">
    <div class="form-group">
        <label for="trackingnumber">Tracking Number</label>
        <input type="text" name="trackingnumber" class="form-control" placeholder="Enter tracking number ..." />
    </div>
    

stevewithington

/*

  Mura forms are loaded asynchronously. So, if you wish to run some scripts, you need
  to use a special method to `reopen` the form, and add your scripts using
  
  `Mura.DisplayObject.Form.reopen({})`
  
  The most commonly needed examples are described below.

*/

mattlevine

Super Simple CaaS Example

This is just an example to build upon and in no way represents best practice. You most like would use a web component framework like React.js or Vue.js with Mura.js rather than vanilla js.

For this to work:

1. You must be on Mura 7.1.137 or greater

2. set your site's contentRenderer.cfc's this.hashURLs=true;

mattlevine

DOCKER FIRST (Webinar)

7.1 was designed with a Docker first work flow in mind.

Docker allows increased support for Continuous Deployment and Testing, Multi-Cloud Platforms, Environment Standardization and Version Control. As well as better Isolation and Security (stolen from https://dzone.com/articles/5-key-benefits-docker-ci)

taitems

// Open form and submit enquire for `rego`
function getInfo(rego) {
	horseman
	  .userAgent('Mozilla/5.0 (Windows NT 6.1; WOW64; rv:27.0) Gecko/20100101 Firefox/27.0')
	  .open(url)
	  .type('#registration-number-ctrl input[type=text]', rego)
	  .click('.btn-holder input')
	  .waitForSelector('.ctrl-holder.ctrl-readonly')
	  .html()
	  .then(function(body) {