Difference between revisions of "Hash Variables"

From nuBuilderForte
Jump to: navigation, search
(Custom SQL)
(SQL Builder)
Line 53: Line 53:
 
Any '''Clause''' in the '''Clauses''' Subform in the [[SQL Builder]].
 
Any '''Clause''' in the '''Clauses''' Subform in the [[SQL Builder]].
  
<source lang="html">
+
    = '#RECORD_ID#'
= '#RECORD_ID#'
+
</source>
+
  
 
==Report Labels==
 
==Report Labels==

Revision as of 16:53, 17 June 2020

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.

  1. USER_ID
  2. USER_GROUP_ID
  3. HOME_ID
  4. 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.


  <iframe 
     width="560" 
     height="315" 
     src="#cus_youtube#" 
     frameborder="0" allowfullscreen>
   </iframe>

Custom SQL

All Custom SQL used in nuBuilder Forte.

  CREATE TABLE #TABLE_ID# SELECT * FROM customer;

SQL Builder

Any Clause in the Clauses Subform in the SQL Builder.

   = '#RECORD_ID#'

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>