henplus icon indicating copy to clipboard operation
henplus copied to clipboard

Patch: set_var_from_query command

Open tbk303 opened this issue 14 years ago • 2 comments

help set-var-from-query SYNOPSIS: set-var-from-query [ ]

DESCRIPTION: Wit is retrieved from the sql query. The first colomn from the first row is used to set the variable. Variables are expanded in any command you issue on the commandline. Variable expansion works like on the shell with the dollarsign. Both forms, $VARNAME and ${VARNAME}, are supported. If the variable is not set, then the text is left untouched. So if there is no variable $VARNAME, then it is not replaced by an empty string but stays '$VARNAME'. This is because some scripts use wierd identifiers containting dollars (esp. Oracle scripts) If you want to quote the dollarsign explicitly, write two dollars: $$FOO means $FOO Requires valid session.

https://gist.github.com/759803

tbk303 avatar Dec 30 '10 13:12 tbk303

Submitted:

Nobody/Anonymous ( nobody ) - 2008-03-25 14:29:54 UTC

neurolabs avatar Dec 31 '10 16:12 neurolabs

There is the beanshell integration, which makes this and more possible. We should try to get the beanshell integration into the master repo.

neurolabs avatar Dec 31 '10 16:12 neurolabs