Hash Variables: Difference between revisions
No edit summary |
No edit summary |
||
Line 1: | Line 1: | ||
There are a number of places Hash | There are a number of places Hash Cookies can be used... | ||
In each of these situations, nuBuilder does a search and replace. | In each of these situations, nuBuilder does a search and replace. | ||
With all currently available Hash | With all currently available Hash Cookies and any you use, before it is run. | ||
There are 4 Hash | There are 4 Hash Cookies always available. | ||
#USER_ID | #USER_ID | ||
#USER_GROUP_ID | #USER_GROUP_ID | ||
Line 14: | Line 14: | ||
To find what other Hash | To find what other Hash Cookies are available for use, you can run [[PHP#nuHash|nuHash()]] inside your code. | ||
==PHP== | ==PHP== | ||
Hash | Hash Cookies allow you to customise your [[Procedures|PHP code]]. | ||
Example of using Hash | Example of using Hash Cookies in PHP. | ||
<source lang="php"> | <source lang="php"> | ||
Line 31: | Line 31: | ||
==HTML== | ==HTML== | ||
Hash | Hash Cookies allow you to customise your HTML [[Objects]]. | ||
The Hash | The Hash Cookies available to HTML Objects are the same as those available on '''Before Edit'''. | ||
Example of using Hash | Example of using Hash Cookies in HTML. | ||
<source lang="html"> | <source lang="html"> | ||
Line 64: | Line 64: | ||
==Report Labels== | ==Report Labels== | ||
Using Hash | Using Hash Cookies allows you to have changing titles on [[Report_Designer#Object_Properties|Report Labels]]. | ||
An example of using Hash | An example of using Hash Cookies in a Report Label. | ||
<source lang="html"> | <source lang="html"> | ||
Revision as of 23:23, 10 September 2017
There are a number of places Hash Cookies can be used...
In each of these situations, nuBuilder does a search and replace.
With all currently available Hash Cookies and any you use, before it is run.
There are 4 Hash Cookies always available.
- USER_ID
- USER_GROUP_ID
- HOME_ID
- GLOBAL_ACCESS
To find what other Hash Cookies are available for use, you can run nuHash() inside your code.
PHP
Hash Cookies allow you to customise your PHP code.
Example of using Hash Cookies in PHP. <source lang="php">
$s = "CREATE TABLE #TABLE_ID# SELECT * FROM invoice";
nuRunQuery($s);
</source>
HTML
Hash Cookies allow you to customise your HTML Objects.
The Hash Cookies available to HTML Objects are the same as those available on Before Edit.
Example of using Hash Cookies in HTML. <source lang="html">
<iframe
width="560" height="315" src="#cus_youtube#" frameborder="0" allowfullscreen>
</iframe>
</source>
Custom SQL
All Custom SQL used in nuBuilder Forte. <source lang="sql">
CREATE TABLE #TABLE_ID# SELECT * FROM customer;
</source>
SQL Builder
Any Clause in the Clauses Subform in the SQL Builder.
<source lang="html">
= '#RECORD_ID#'
</source>
Report Labels
Using Hash Cookies allows you to have changing titles on Report Labels.
An example of using Hash Cookies in a Report Label. <source lang="html">
Sales Between #from_date# And #to_date#
</source>