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