nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Read DCR values into a ASP Dim variable

Achim

Is it possible to get a DCR values into an ASP code in a TPL.

<%
Dim result
dim finalsql, finalresultSet

finalsql = "SELECT Page_Nav_Level2.PageID FROM Page_Nav_Level2 where Page_Nav_Level2.PageID='{iw_value name='dcr.PageId'}'"

%>

Please let me know if in any way its possible to pass the DCR value into a asp code or function.

Find more posts tagged with

Comments

LooseCannon

Since a DCR is nothing more than a XML file, you can access any values you want using DOM.

hemranga

HI
I guess it is possible to do this way. I am pasting an article here. if you want u can also chk out the same thing on the support Site
How to phrase asp code to use interwoven XML tags to access presentation templat
Knowledge Base Article: 2105
Type: Tech Note

Synopsis
Currently, the presentation templates have the following asp codes:

<%
id="eric"

Article Number / URL
https://support.interwoven.com/kb/kb_show_article2.asp?ArticleID=2105"

All the best
Hemanth R
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "dsn=i-content; uid=sa; pwd"
SqlQuery = "SELECT fd_no FROM i_user WHERE fd_id
= '" & id & "'"
Set rsCheck = Conn.Execute(SqlQuery)
%>

It seems that you can't leave spaces in the search string in the where clause of the SQL statement.

Details

The where clause should be written as:

where fd_id = "{iw_value name='$id'/}