Clarification in DB value fetch - Xpath

50 views
Skip to first unread message

Karthikeyan Sivanantham

unread,
Jan 10, 2012, 5:39:09 AM1/10/12
to RedDot CMS Users, bose...@gmail.com, kpoovalurs...@inautix.co.in
When i am fetching a value from DB using DB-read, and trying to write
the value using dynament, without using read dynament, the value is
displaying in the html page. This is not happening in other projects
in same liveserver

Please advise on this issue whether any mistake in coding or is there
any configuration changes needs to be done

Code snippet for Reference

<rde-dm:rdb mode="query" alias="DB-read" sql="SELECT REGR_SITE_USR_ID
AS USERID FROM RIUT_REGR_SITE_USR WHERE
REGR_SITE_USR_ID='[#session:username#]' and USR_TY_CD='AN'" rde-
id="04"/>
<rde-dm:attribute mode="write" source="request" attribute="UserID"
value="[#xpath:rde-node('04') //USERID/text()#]"/>

Here in this code UserID is displaying in html page.

Guy Rogers

unread,
Jan 31, 2012, 4:28:01 PM1/31/12
to reddot-c...@googlegroups.com, bose...@gmail.com, kpoovalurs...@inautix.co.in
Karthick were you able to get a solution for this issue?

Nik S.

unread,
Feb 7, 2012, 12:24:37 PM2/7/12
to RedDot CMS Users
Hi Karthikeyan,

What version of LiveServer/Delivery Server are you using?

I don't see a problem with your code. To further troubleshoot the
issue, please add the standard report-tag attribute/parameter to the
RDB DynaMent and provide us with the XML produced by the RDB
DynaMent:

<rde-dm:rdb
mode="query"
alias="DB-read"
sql="SELECT REGR_SITE_USR_ID AS USERID FROM RIUT_REGR_SITE_USR WHERE
REGR_SITE_USR_ID='[#session:username#]' and USR_TY_CD='AN'"
rde-id="04"
report-tag="rdb-dynament-report" />

-Nik

On Jan 10, 5:39 am, Karthikeyan Sivanantham <bose....@gmail.com>
wrote:
Reply all
Reply to author
Forward
0 new messages