Getting row from database through functoid

[zash74]

Hello,
I am new to BT2004 and trying to achieve this in my map file with no success. I've stored proc that returns 2 column from the database. what functoid should i use to get more than 1 value back and mapped it to different destination schema. Is there anyother better way to call stored proc and map returned fields to destination schema.

thnx.
ZA

 

[SgtPeppa]

I am sorry, the databse lookup functoid only supports to return 1 record.

You should write your own .NetComponent for that!

Sorry!

Stephan

 

[zash74]

Stephan,
Thanks for reply, i also get one record from the stored proc but it has multiple columns. How do i map all column to destination nodes. e.g. my SP returns ID, Name, Address. How do i map these three values to destination through functoid.
I've created method in another assembly that calls SP and returns above columns and I am calling that method from script functoid but i dont know how can i map multiple return values from functoid to destination schema. The work around i did is concatenate all column and return string from that method and extract column in other three functoid and map it to destination schema.

What is the best way to get values from SP and map it to destination schema.

Thnx
ZA