Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DBlookup Problem

Status
Not open for further replies.

sonalimss

IS-IT--Management
Dec 7, 2005
24
IN
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


 
If SNO Column:Row:input is a number in the Type Tree you need to do numbertotext(SNO Column:Row:input )
 
Thanks Janhes its working now...

sonali
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top