Query a database
Verified
Added by iNTERFACEWARE
Use conn:query() to select data from a table in a database
Source Code
-- connect to a SQLite database
conn = db.connect{
api = db.SQLITE,
name = 'test',
live = true
}
-- select data from a database table
local R = conn:query('SELECT * FROM Patient')
trace(R)
Description
Use conn:query() to select data from a table in a database
Usage Details
Use conn:query() to select data from a table in a database. The code connects to a SQLite database, you can substitute with any database connection.
How to use the snippet:
- Paste the query code into your script
Added by iNTERFACEWARE
Use node.append() to append a node to an XML node tree
Added by iNTERFACEWARE
Use node.isLeaf() to check if a node is a leaf node (has no children), works for all node types
Added by iNTERFACEWARE
Use node.isKey() to check if a node is the primary key for a database table, this method only for table node trees
Added by iNTERFACEWARE
Use node.isNull() to check if a node is null (not present), works for all node types
Added by iNTERFACEWARE
Code to connect to commonly used databases (connecting to other databases is very similar).
Added by iNTERFACEWARE
Use iguana.stopOnError(false) to prevent a channel from stopping when an error occurs
Added by iNTERFACEWARE
How to convert numbers and node trees to a to string representation, and how to convert a numeric strings to numbers
Added by iNTERFACEWARE
Convert a string to upper case with string.upper(), or lower case with string.lower()
Added by iNTERFACEWARE
How to convert an HL7 message to and from an XML representation, using chm.toXml{} and chm.fromXml{}
Added by iNTERFACEWARE
Convert characters to/from numeric codes, the codes will vary depending on the code page settings
Added by iNTERFACEWARE
Use node.childCount() to count the number of children for a specified node, works for all node types
Added by iNTERFACEWARE
How to create and unzip a bzip2 or gzip file, using filter.bzip2.deflate() and filter.bzip2.inflate() or gzip.deflate() and gzip.inflate()
Added by iNTERFACEWARE
Create a generic ACK by using a script in an LLP Listener component
Added by iNTERFACEWARE
How to create and unzip a zip file containing multiple files and directories, using filter.zip.deflate() and filter.zip.inflate()
Added by iNTERFACEWARE
How to create Error, Warning, Informational, and Debug log entries
Added by iNTERFACEWARE
Use os.fs.rmdir() to delete an empty directory, if the directory is not empty an error is returned
Added by iNTERFACEWARE
Use os.remove() to delete a file or directory, only an empty directory can be deleted
Added by iNTERFACEWARE
Use node.remove() to delete an element from a table,
Added by iNTERFACEWARE
Use table.remove() to delete an element from a table