255 char limit in result queries

Brug, Herco van -Syntegra NL H.vanBrug at syntegra.nl
Mon Nov 13 06:07:13 EST 2000


cool :) here's more info:
name            type    length
Proj_nr         56      4
Rel_nr          56      4
Gebruiker_nr    52      2
Psrt_nr         52      2
Proj_status     39      45
Order_nr        38      4
Proj_oms        39      45
Proj_toel       35      16
Proj_antwoord   35      16
Datum_in        61      8
Tijd_in         111     8
Datum_af        111     8
Tijd_af         111     8
Locatie         39      45
Afdeling        39      45
Telefoon        39      45
Contactpersoon  39      45
Sorteerveld     39      10
Proj_cdatum     111     8
Proj_cid        38      2
Proj_mdatum     111     8
Proj_mid        38      2
i couldnt find the type 35 data types in my sql docs (nor the 38 or 39 so i
probably dont have the complete docs)
hope this helps
 


-----Original Message-----
From: Brian Bruns [ mailto:camber at ais.org <mailto:camber at ais.org> ]
Sent: vrijdag 10 november 2000 15:29
To: TDS Development Group
Subject: [freetds] Re: 255 char limit in result queries


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


---
You are currently subscribed to freetds as: [H.vanBrug at syntegra.nl]
To unsubscribe, forward this message to
$subst('Email.Unsub')

-----------------------------
The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material. Any review, retransmission, dissemination or other use of, or
taking of any action in reliance upon, this information by persons or
entities other than the intended recipient is prohibited. If you received
this in error, please contact the sender and delete the material from any
computer.
-----------------------------
Op al onze rechtsverhoudingen, aanbiedingen en overeenkomsten waaronder
Syntegra goederen en diensten levert zijn met uitsluiting van alle andere
voorwaarden onze algemene voorwaarden van toepassing. Deze worden u op
aanvraag direct kosteloos toegezonden. Tevens kunt u deze vinden via onze
homepage http://www.syntegra.nl
-----------------------------
On all offers and agreements under which Syntegra supplies goods or services
of whatever nature, the general terms and conditions from Syntegra Groep
B.V. exclusively apply. The general terms and conditions shall be promptly
submitted to you on your request. You can also find these via our homepage
http://www.syntegra.nl
-----------------------------

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.ibiblio.org/pipermail/freetds/attachments/20001113/e0129673/attachment.html 


More information about the FreeTDS mailing list