Skip to Content.
Sympa Menu

freetds - Re: Certain query results cause segfaults

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Brian Bruns <camber AT ais.org>
  • To: TDS Development Group <freetds AT franklin.metalab.unc.edu>
  • Subject: Re: Certain query results cause segfaults
  • Date: Fri, 19 Apr 2002 22:34:46 -0400 (EDT)


Actually that is not a FreeTDS error that message comes straight from the
server, I believe the funciton you are looking for is 'substring' not
'substr', but again the better solution is to use 'set textsize'

Brian

On Fri, 19 Apr 2002, Casey Allen Shobe wrote:

> On Friday 19 April 2002 18:32, Casey Allen Shobe wrote:
> > I'm don't know where to go from here. Here's what the column properties
> > are: Data Type: text
> > Length: 2147483647
> > Precision: 2147483647
> > Is nullable: Yes
>
> I thought that this may be worked around with substr, so I tried:
> $test = sybase_query ('select substr(alert_text,4000,0) from alert',
> $piv_conn);
>
> Unfortunately, FreeTDS doesn't appear to accept that:
>
> Warning: Sybase: Server message: 'substr' is not a recognized function
> name.
> (severity 15, procedure N/A) in /www/htdocs/beta/cshobe/mssqltest.php on
> line
> 31
>
>





Archive powered by MHonArc 2.6.24.

Top of Page