Welcome to iNTERFACEWARE’s code repository – a place to find and share official and community-submitted code. Our goal is to provide useful and commonly used interfaces, modules, code snippets, and to encourage the members of our community to learn, share and help each other with their projects.
Added by iNTERFACEWARE
How to parse an XML message using xml.parse()
Added by iNTERFACEWARE
Using date and time functions with some formatting examples
Added by iNTERFACEWARE
Execute programs and batch files, you can also load results from a directory listing etc.
Added by iNTERFACEWARE
Wraps the (old style) database apis to give a connection object with methods, from 5.5.1 it is superseded by the new database connection methods
Added by iNTERFACEWARE
Escapes strings to make them safe to use in SQL for various databases, from 5.5.1 it is superseded by the by the builtin conn:quote() method
Added by iNTERFACEWARE
Convert characters to/from numeric codes, the codes will vary depending on the code page settings
Added by iNTERFACEWARE
Find the position of the first instance of a string (pattern) within a string, returns the start and end indices
Added by iNTERFACEWARE
Use string.gsub() to find and replace one or more instances of text within a string
Added by iNTERFACEWARE
Using # or string.len() to find the length of a string, the result is the same
Added by iNTERFACEWARE
Convert a string to upper case with string.upper(), or lower case with string.lower()
Added by iNTERFACEWARE
Use the string.split() function to split a string into parts separated by a specified delimiter
Added by iNTERFACEWARE
Use string.sub() to return part of a string, by specifying the start and end positions
Added by iNTERFACEWARE
Use conn:query() to select data from a table in a database
Added by iNTERFACEWARE
Use conn:execute() to insert data into a database table
Added by iNTERFACEWARE
Use conn:execute() to update a database table
Added by iNTERFACEWARE
Use conn:merge{} to merge data into a database
Added by iNTERFACEWARE
Use iguana.isTest() to prevent code from running in the editor
Added by iNTERFACEWARE
Use iguana.isTest() to allow code to run in the editor but not in the live channel
Added by iNTERFACEWARE
Get the name or guid for the current channel by using iguana.channelName() or iguana.channelGuid()
Added by iNTERFACEWARE
Use iguana.channelConfig{} to get configuration information for a channel, you can use either guid or channel name to specify the channel