DBlookup Problem

[sonalimss]

Hai All,
Iam using DBLOOKUP function to retrieve a field called sname where sno is 1001
from the oracle database..

map is executing while iam Hard coding "1001" instead of using "+SNO Column:Row:input+" in this way

=valid(dblookup("select sname from student1 where sno= ' "+"1001"+" ' ","-MDQ Database_QueryFile1.mdq -DBNAME updat -TE+"),FAIL("FAILED DURING SELECTING COUNTRY_NAME"))

Map execution failed using in this way
=valid(dblookup("select sname from student1 where sno= ' "+SNO Column:Row:input+" ' ","-MDQ Database_QueryFile1.mdq -DBNAME updat -TE+"),FAIL("FAILED DURING SELECTING sname"))


and the error it shows is

M120 ERROR:
Map: updat Output: SNAME Column:dbcard
SNO Column:Row:input is an invalid operand.


Kindly Help me

 

[janhes]

If SNO Column:Row:input is a number in the Type Tree you need to do numbertotext(SNO Column:Row:input )

 

[sonalimss]

Thanks Janhes its working now...

sonali