Certain query results cause segfaults
Brian Bruns
camber at ais.org
Fri Apr 19 23:34:46 EDT 2002
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
>
>
More information about the FreeTDS
mailing list