Issue with SPs returning name-value pairs

Issue with SPs returning name-value pairs

Post by don hu » Fri, 23 May 2003 11:04:21



this is an older closed thread
http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&threadm=9...

i'm just wondering if this got included in 9.4

thanks

 
 
 

Issue with SPs returning name-value pairs

Post by Jonathan Leffle » Fri, 23 May 2003 13:01:32



> this is an older closed thread
> http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&threadm=9...

> i'm just wondering if this got included in 9.4

Yes.

Quote:> thanks

You're welcome.

--
Jonathan Leffler                   #include <disclaimer.h>

Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/

 
 
 

1. Issue with SPs returning name-value pairs

Hi,

I have written an test SP, which returns me a
character field, and a numeric field. When I execute
the SP using dbaccess, the fields have a heading
"(expression)".

I would like to have the return from SP in a name
value format. something like "Name  Radha Krishna"
"Age 24", instead of "(expression) Radha Krishna"
"(expression) 24".

Can someone help??

Radha krishna,


__________________________________________________
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/

2. Clipper (dBase III) and Organigram Report Generator needed!

3. name/value pairs in a table, need help with reporting techniques

4. Need help --if Possible

5. Extracting name value pairs from an XML string

6. Error 0 occurred. No description was returned by server 'AU_AAPCAT001'

7. PL/SQL Code: Parsing Name Value Pairs.

8. ado return /output parameters

9. Modelling items with attribute name/value pairs

10. Retrieving SQL Server SPs Return Recordset Column Names

11. Two Process Instances Using SQL 6.5 SPs Return Different Values

12. Return value from SPs

13. How to pivot a table of name/value pairs based on the lastest timestamp for a given pair?