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: "Brug, Herco van -Syntegra NL" <H.vanBrug AT syntegra.nl>
  • To: TDS Development Group <freetds AT franklin.oit.unc.edu>
  • Subject: Re: 255 char limit in result queries
  • Date: Mon, 13 Nov 2000 12:07:13 +0100

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

-----------------------------





Archive powered by MHonArc 2.6.24.

Top of Page