Merge software supports a wide range of tags which includes task statuses, assignees, due dates, priorities, labels, and custom fields. These tags help users to organise, manage and track their tasks efficiently.
One of the key features is < $RDB='[Database type:]Database name[:Host][,User[,Password]]' > which allows you to connect to an alternative database. By default, parameters are taken from the configuration file. If two parameters are given in the first token, the database type takes precedence. Predefined databases from merge.conf can also be utilized, with < $RDB='SYSTEM' > for system database and < $RDB='DEFAULT' > for the application database as defined in merge.conf. In cases where the system database (SESSION_DB) is not defined, a system-wide definition will apply.
Another fantastic feature is < $RS='SQL statement' > which lets you perform a non-query SQL statement. < $RQ='SELECT SQL statement' > allows you to perform a query, with the first row of the result immediately available. This query can then be iterated with < $RLOOP > tags. To re-perform the query, simply use < $RERUN >.
< $RLOOP[.LIMIT=number] > allows you to perform a loop over fetched query elements, with the last row remaining valid after iteration. You can also limit the iteration number. Dereferencing a column from the current fetch is easy with < $RSQL.variable >, and < $RINDEX > substitutes for the number of the row currently fetched. To fetch another row and increment the index, use < $RFETCH >. < $RSTATE > Returns the SQL state of the last statement, and < $REMPTY > Returns a boolean value of whether the last query yielded an empty set. Finally, to destroy an engine, simply use < $RDISCONNECT >.
Overall, HTML::Merge::Tags is an essential tool for any software developer, and with its extensive range of tags and features, you can take your database connectivity to the next level.
Version 3.54: N/A