Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
|
databaserawlookupdocumentation [2022/01/02 21:45] wikiadmin created |
databaserawlookupdocumentation [2022/01/02 21:57] (current) wikiadmin [Introduction] |
||
|---|---|---|---|
| Line 5: | Line 5: | ||
| ===Introduction=== | ===Introduction=== | ||
| - | This server is used with a [[DatabaseConnectionManagerDocumentation|Database Connection Manager]] to read a single value from a database table using a SQL Statement. | + | This server is used with a [[DatabaseConnectionManagerDocumentation|Database Connection Manager]] to read a single value from a database table using a SQL Statement. |
| + | |||
| + | ===Using in MIStudio=== | ||
| + | |||
| + | This Bean has a single input (Trigger) which executes the SQL Statement. The SQL Statement must return a single result (not a list or array). The SQL should be a SELECT or COUNT, or other similar statement. There are two outputs: Result and Status Message. The result of the SQL lookup will be sent to the Result output, and the Status Message can be used to monitor for errors. | ||
| + | |||
| + | ===Using in a Script=== | ||
| - | ===How This is Used=== | ||
| - | This Bean has a single input (Trigger) which executes the SQL Statement. The SQL Statement must return a a single result (not a list or array). The SQL should be a SELECT or COUNT, or other similar statement. There are two outputs: Result and Status Message. The result of the SQL lookup will be sent to the Result output, and the Status Message can be used to monitor for errors. | ||
| ===Configuration=== | ===Configuration=== | ||