FreeTDS Development Group

[Brian Bruns <camber AT ais.org>]

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...
>