Salesforce Lightning Data Services

Thursday, 24 September 2020

Read or Modify Data with Record Form Base Components

accountCreator.html: (No recordId means "edit" mode and "create" record on submit.)


import { LightningElement } from 'lwc'; import { ShowToastEvent } from...

> Keep reading

ES2015 for Dummies

Thursday, 24 September 2020

New class syntax:

class CoolStuff extends ParentStuff { constructor(name) { = name; super(name); }

static methodName() { return 'I am static!'; }

printName() { return 'I am dynamic!'; }

get area() { return this.height * this.weight; ...

> Keep reading

MySQL Function for Making URL Names

Thursday, 03 September 2020

This function takes a text like "I Can't Cope with Socialists!" and transforms it to "i-cant-cope-with-socialists", suitable for URL names and similar. Preserves only letters (A-Z) and digits, removes double hyphens and makes everything lowercase.

CREATE FUNCTION mangle_name (str VARCHAR(255)) RETURNS...

> Keep reading

MySQL Function to Calculate Excel-style Dates

Tuesday, 18 October 2011

drop function if exists exceldate;

delimiter //

-- Function that returns an Excel-style or Delphi-style date value -- from a MySQL date. A date value of 0 represents 1899-12-30.</em> create function exceldate(p_date date) returns int sql security...

> Keep reading

Luhn (mod 10) Check Digit Algorithm in MySQL

Thursday, 13 October 2011

drop function if exists luhn; drop function if exists luhn_check;

delimiter //

-- Function that calculates a Luhn (mod 10) check digit from a numeric string. -- The behavior is undefined if the string contains anything else...

> Keep reading