Skip to content

Instantly share code, notes, and snippets.

Dan Smith dansmith65

  • B.C. Canada
Block or report user

Report or block dansmith65

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
@dansmith65
dansmith65 / ListContains.fmfn
Created Jan 4, 2014
FileMaker Custom Function: ListContains ( ValueList ; ValuesToTestExistence )
View ListContains.fmfn
/* ListContains ( ValueList ; ValuesToTestExistence )
PURPOSE:
Test if all specified values exist in a list.
PARAMETERS:
ValueList (text) values to search in
ValuesToTestExistence (text) value(s) to search for
RETURNS:
@dansmith65
dansmith65 / VirtualBoxFixNIC.cmd
Created Dec 13, 2013
Fix issue with VirtualBox Host-Only Network adapter in Windows by adding *NdisDeviceType=1 to registry.
View VirtualBoxFixNIC.cmd
@ECHO OFF
ECHO.-------------------------------------------------------------------------------
ECHO.
ECHO. VirtualBoxFixNIC.cmd
ECHO.
ECHO. Created on 2013-DEC-13 by Dan Smith http://scr.im/dansmith
ECHO.
ECHO. Fix issue with VirtualBox Host-Only Network adapter in Windows by adding
ECHO. *NdisDeviceType=1 to registry.
ECHO.
@dansmith65
dansmith65 / GetDelimitedValue.fmfn
Last active Dec 29, 2015
In FileMaker, return value in specified location of delimited text.
View GetDelimitedValue.fmfn
/**
* =====================================
* GetDelimitedValue ( text ; delimiter ; occurrence )
*
* RETURNS:
* Value in specified location of delimited text.
*
* PARAMETERS:
* text = (text) delimited data
* delimiter = (text) single character used to separate values
@dansmith65
dansmith65 / XPath Parse With Namespace.java
Last active Dec 20, 2015
ScriptMaster function, for use in a FileMaker plug-in.
View XPath Parse With Namespace.java
// XPathParseWithNamespace ( someXML ; xpathQuery ; namespaceList )
// adapted from this code: http://www.java2s.com/Code/Java/XML/implementsNamespaceContext.htm
// and the prior XPath Parse function in ScriptMaster
import javax.xml.XMLConstants;
import javax.xml.namespace.NamespaceContext;
import javax.xml.xpath.XPath;
import javax.xml.xpath.XPathFactory;
import javax.xml.xpath.XPathConstants;
import javax.xml.xpath.XPathExpressionException;
@dansmith65
dansmith65 / ExecuteSQL
Last active Apr 2, 2018
ExecuteSQL template for FileMaker which allows for viewing the query in the data viewer while debugging, and testing for an error.
View ExecuteSQL
Let ( [
$sqlQuery =
"SELECT "
& SQLTableAndField ( field )
& "¶FROM "
& SQLTable ( field )
& "¶LEFT JOIN "
& SQLTable ( field )
& "¶ON "
& SQLTableAndField ( field )
You can’t perform that action at this time.