%1 Parameter Problem

Hi,I've got the following query for Userpermission:select nvl(kf.lastname,'n/a') as lastname, dt.name as itemname, dta.permissions as permission, kf.OWNERID as ownerid, dvd.owner as owner, dvd.FILETYPE as Documenttype from DversData dvd, kuaf kf, dtree dt, dtreeacl dta where dta.RIGHTID in (select id from kuaf) AND dta.parentid = dt.parentid AND dta.rightid = kf.ID AND kf.lastname = %1Inputs: User Please select an UserParameter%1: UserinputAutoliverportDB Oracle 9.xLL9.5.0When I run this query I can selct an User an after this I receive an Error "Livelink Error: Error processing request. [Error fetching record.] "When I replace %1 with an Username in cleartext it works:select nvl(kf.lastname,'n/a') as lastname, dt.name as itemname, dta.permissions as permission, kf.OWNERID as ownerid, dvd.owner as owner, dvd.FILETYPE as Documenttype from DversData dvd, kuaf kf, dtree dt, dtreeacl dta where dta.RIGHTID in (select id from kuaf) AND dta.parentid = dt.parentid AND dta.rightid = kf.ID AND kf.lastname = 'Meier'Can anyone give me an tip?Thank you!

Find more posts tagged with

Comments

Bhupinder_Singh

Message from Bhupinder Singh <bsingh@opentext.com> via eLink

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">eLink

Change the last part from kf.lastname=%1 to kf.id=%1

- Bhupinder

From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Wednesday, March 14, 2007 11:24 AM
To: eLink Recipient
Subject: %1 Parameter Problem

%1 Parameter Problem

Posted by pstegl (Stegl, Peter) on 03/14/2007 11:20 AM

Hi,
I've got the following query for Userpermission:

select nvl(kf.lastname,'n/a') as lastname, dt.name as itemname, dta.permissions as permission, kf.OWNERID as ownerid, dvd.owner as owner, dvd.FILETYPE as Documenttype from DversData dvd, kuaf kf, dtree dt, dtreeacl dta where dta.RIGHTID in (select id from kuaf) AND dta.parentid = dt.parentid AND dta.rightid = kf.ID AND kf.lastname = %1

Inputs: User Please select an User
Parameter%1: Userinput
Autoliverport

DB Oracle 9.x
LL9.5.0

When I run this query I can selct an User an after this I receive an Error "Livelink Error: Error processing request.
[Error fetching record.] "

When I replace %1 with an Username in cleartext it works:

select nvl(kf.lastname,'n/a') as lastname, dt.name as itemname, dta.permissions as permission, kf.OWNERID as ownerid, dvd.owner as owner, dvd.FILETYPE as Documenttype from DversData dvd, kuaf kf, dtree dt, dtreeacl dta where dta.RIGHTID in (select id from kuaf) AND dta.parentid = dt.parentid AND dta.rightid = kf.ID AND kf.lastname = 'Meier'

Can anyone give me an tip?
Thank you!