Skip to Content.
Sympa Menu

freetds - Re: 255 char limit in result queries

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.oit.unc.edu>
  • Subject: Re: 255 char limit in result queries
  • Date: Fri, 10 Nov 2000 09:29:14 -0500 (EST)


Ok, try this instead:

select name, type, length from syscolumns where id=object_id('SUPPORTPROJECT')

Brian

On Fri, 10 Nov 2000, Brug, Herco van -Syntegra NL wrote:

>
> this is all i get:
>
> Name Owner Type When_created
> SUPPORTPROJECT dbo user table 29-12-99 17:36:42
>
> i assume that's no help but i dont know how else to run it ( i ran it as a
> stored procedure call. the sp_help_fulltext_tables was unknown).
>
> this is part of the code i use
> $id=mssql_connect("Support", "username", "");
> $db=mssql_select_db("Support");
> $r1=mssql_query("Select dbo.SUPPORTPROJECT.Proj_toel,
> dbo.SUPPORTPROJECT.Proj_antwoord FROM dbo.SUPPORTPROJECT
> Where (Proj_nr=$pn)",$id);
>
> where both Proj_toel and Proj_antwoord are defined as 'memo' fields when
> looked up in MSaccess.
> hope this helps cause i'm trying hard to get this to work on a linuxbox but
> sofar only the nt version works correctly...
>





Archive powered by MHonArc 2.6.24.

Top of Page