sybperl-l Archive

From: "Craig Tyler" <ctyler at xtrasource dot com>
Subject: Re: Supressing formatting
Date: Aug 2 2000 8:41PM

I discovered my malfunction. I was using CS_TRUE in my ct_fetch()

My execute of:
CREATE PROCEDURE dbo.test_proceedure
AS
    BEGIN
       select ''
    select ''
   select 'Hello!'
   select ''
   select ''
    END

Was returning:
COL(1)

COL(1)

COL(1)
Hello!
COL(1)

COL(1)

COL(1)
0



----- Original Message -----
From: "Michael Peppler" 
To: "SybPerl Discussion List" 
Sent: Wednesday, August 02, 2000 12:09 PM
Subject: Re: Supressing formatting


> Craig Tyler writes:
>  > I am using sybperl to call stored proceedures. Right now the data from
these
>  > proceedures is returned with lots of formatting information (column
>  > separators and column names), but I don't want/need that extra
information
>  > returned. I assume there is some way to disable this, but I can't seem
to
>  > find it. Does the ability to do this exist?
>
> I'm not sure I understand. In sybperl there should be no formatting at
> all - you just get the data back for each column in the select
> statement(s) that you execute (or that are executed in stored procs
> that you run).
>
> Are you using isql?
>
> Michael
> --
> Michael Peppler         -||-  Data Migrations Inc.
> mpeppler@peppler.org    -||-  http://www.mbay.net/~mpeppler
> Int. Sybase User Group  -||-  http://www.isug.com
> Sybase on Linux mailing list: ase-linux-list@isug.com
>
>