MySQL Updating a database table from another table
A quick article on how to populate a database column from another table using a string comparison.
Knowledge base / Since 1999
Scripts, systems & field notes.
Practical solutions and technical notes from CRM platforms, workflow automation, APIs, databases and the systems around them.
Advanced search638 entries
Two icons created on Android
If you're installing an app and it creates two icons:
MessageBox or AlertDialog in Android Java
A quick article on how to display a OK/Cancel popup which I use as a message to the user for debug purposes.
Basic Android App using Google Maps and Current Location
I am writing an app for a tablet running Android and wanted to include a Google Map. The following exercise focuses solely on creating an app which opens Google Maps at your current location. How? I couldn't find any instructions using the tools I had (Android Studio) which is why I've written this article.
A quick run through of setting up an export process in SITS
"Quick" may not be the right word, so this is a somewhat summarized article on how to get data out of SITS, up to running the monitors and populating an OUTPUT table in the SITS database. Note that this does not include steps thereafter in the Staging or Target destination which will be specific to your business requir...
T-SQL functions to convert Strings to Tables
These were in a solution and I thought I'd note them on my site so I can refer to them more easily. How?
Add attribute xsl:nil=true on empty elements using XSLT
An article on how to declare an XML element as NULL using the attribute "xsi:nil". I'm going to use a very short example by providing a blank date of birth value: -- What I have: // -- What I want:
XML Schema Reference
XSD Elements Element Explanation all Specifies that the child elements can appear in any order. Each child element can occur 0 or 1 time annotation Specifies the top-level element for schema comments any Enables the author to extend the XML document with elements not specified by the schema anyAttribute Enables the aut...
SITS: Export field code and name
You might be able to work it out from the online manuals but it took me a while, we wanted to bring back both the code and the lookup value in our XML to our Staging environment.
Loading more notes...
No more notes to load.