InterAKT Dynamic Data

The InterAKT Dynamic Data tool is a replacement for the standard dynamic data dialog. It is used in the MX Kollection 3, to provide a unified way of building mark-ups, or place holders. These are recordset A recordset is the result of executing an SQL query A query is a SQL command that will extract information from the tables of a database. Essentially, a query is a request for information from your database.. It is composed of multiple rows, each row having multiple columns. The columns presented in the query result depend on the column list declared in the query (they can belong to different tables). The number of rows and their order depend on the query conditions (WHERE, GROUP BY, HAVING, ORDER). The recordset acts as a source of dynamic data in web applications. fields, server or session A session is a way to preserve certain data across subsequent accesses of the same web application. The session object contains many variables to store user information on the web server in a location that you choose in special files. The session support allows you to register arbitrary numbers of variables to be preserved across requests. Sessions are specific to individual users. As a result, every user has a separate session and has access to a separate set of Session variables. variables, and other types of dynamic data that are replaced at runtime by their corresponding values.

The InterAKT Dynamic Data has an associated blue lightning icon that is displayed next to the interface field that can use it:

 

When used, it provides a user interface that allows selecting from one of the existing variable sources in page and automatically creates the mark-up code:

 

To set the dialog box options, follow the next steps:

  1. In the Get values from drop-down menu select the variable source. Available options are:

    ·  Transaction field
    ·  Recordset field
    ·  URL parameter
    ·  Form variable
    ·  Cookie
    ·  Session variable
    ·  Server variable
     

  2. Depending on the selection made in the Get values from drop-down menu, different options will be displayed for the other fields, as follows:
    ·  For Transaction field, a drop-down with all fields involved in the transaction is displayed.
    ·  For Recordset field, two drop-downs are shown: one listing the available recordsets, and another one listing the recordset fields.
    ·  For URL parameter, Form variable, Cookie, Session variable and Server variable, the Variable drop-down is shown, listing the available variables in the current category.

  3. In the Mark-up code text-box, the generated placeholder is displayed. This code will also be inserted into the page.

  4. The three buttons on the right of the interface offer you the next functionalities:
    ·  Click     OK when you are done configuring the dialog box.
    ·  Click Cancel to exit without the new settings to be applied.
    ·  The Help button takes you to this help page.

 

Related Topics

Login to Add New Note
Guenter  Schenk

Well, the best thing about Interakt´s underlying programming is - as usual - that´s it´s very easy to understand and to extend -- and that´s what I´ve done now with the {NOW}-stuff, because this one has one disadvantage :: all of Interakt´s date&time - conversions actually fetch the defined "screen date format", and this format can at times lead to unwanted results under some combined conditions:

1. when the screen date format is e.g. "31.12.2004"

2. when you´re uploading a file on the server (MX File Upload) based on a custom rename rule like what I tried first :: {NOW}_{KT_name}.jpg -- what will store the file as "31.12.2004_imagename.jpg", and this is not only quite unusual, but will also not
allow a traditional file sorting based on e.g. the file name.

well, and that´s why I just figured out a solution for this...

1. a new variable called "date_now_db_date" which does the following:

$date_now_db_date = KT_convertDate(date('Y-m-d'), "yyyy-mm-dd", $GLOBALS['KT_db_date_format']); // you see that it actually grabs the db_date_format rather than the screen date

2. extending the $dynamicDataFunction - array with 4 new entries:

'NOW_DB()' => $date_now_db_date,
'now_db()' => $date_now_db_date,
'NOW_DB' => $date_now_db_date,
'now_db' => $date_now_db_date,

Well, of course you can get the same effect by introducing a variable like:
$now = date("Y-m-d");
on top of the page and reuse it as suggested in the previous post (GLOBALS.now) -- but with this new dynamic data type your can happily forget about that and use a syntax like...
{NOW_DB}_{KT_name}.jpg
in your custom rename rule, what does translate into "2004-12-31_imagename.jpg".

Hope this helps  -- and of course I hope this will find it´s way into future MX releases so I won´t have to add this stuff with every new update ;-))

Günter
Cba

Hi, my name is Sebastian and my english is poor, but I´ll try to explain.

I have problems with permissions of the sub folders (created dynamic form recorset) with the php upload, i can set permissions of the main folder (example: files/) to 777, but how can i set permisions to sub folders (example: files/01/) created dynamic.

Thanks
ORN
10-03-2005

Question:
What if I just want to insert a normal variable as default, i.e. a string made in some script at the top of the page? In my case, I'd like to prepare today's date in PHP/MySQL format and place in a date field as default text?

Answer:
If you have defined a variable, say $i, in your page, and want to set the default value of a transaction field to the value of $i, you should use the following mark-up code: {GLOBALS.i}.

For your specific case, you can also use {NOW}. This will markup will return the current day. For a complete list of available markups, please read this page.