Datalist

Posted on 09/12/2009 10:06:03

Hi DW-Devs,

The new datalist module enables us to use session and server variables in a sql-statement. But where can I find the overview of sessions and server variables to use in my statement. Non mentioned - non forgotten ;)

In my case I would like to use/extract the languageid - but a complete list would be preferred for future use and development...

Please provide me with the complete list asap - thanks in advance... ;)

/Morten

Replies

Posted on 11/12/2009 09:55:29

Hi Morten

For a complete list of server variables, please refer to this document from microsoft:
http://msdn.microsoft.com/en-us/library/ms524602.aspx

The collection of session variables however is variable, which is why we can't provide you with a list. This feature is mostly made for third party developers to gain access to your own session variables.

- Lasse

Posted on 11/12/2009 10:06:41

Thanks Lasse,

But this only gives me a overview of - as you write - server variables.
But what about session-data?

Im interessed in getting hold of a given pages SelectLangID, DW_Language and DW_Area.
The data are shown on my templates TestData.xml:

<Session-Ecom.SelectedLangID>LANG1</Session-Ecom.SelectedLangID>
<Session-DW_Language>1</Session-DW_Language>
<Session-DW_Area>1</Session-DW_Area>

Non of the above themes to work...!?

From the manual:
Request/Session variables
If you have used Request or Session variables in a condition, you will see a new window where you can enter one or more values to test whether the data list outputs any data. You can change the test values by right-clicking the data list and choose Change test values from the menu.

Is it not possible to get hold of that with the above example?

/Morten

Jeppe Eriksson Agger

Posted on 11/12/2009 13:56:15

Hi Morten

Those tags can be used to get the session variable name. The page template extender that renders those tags automatically prepend the "Session-" to the variable name.

So all you should need to do is take the tag, remove the "Session-" and use what's left as a session variable name in Data list.

I haven't tested this, but it should work as long as the session variable is defined in the context of the page you render the Data list on.

- Jeppe

Posted on 01/02/2010 13:12:43

Sweet - it works :)
Thanks!

Peter Munkholm

Posted on 14/12/2011 15:49:01

Did the @Session("DW_Area") stop working?

You must be logged in to post in the forum

Developer forum

Datalist

Replies