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: Fri, 10 Nov 2000 10:51:31 +0100



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

-----Original Message-----
From: Brian Bruns [mailto:camber AT ais.org]
Sent: dinsdag 7 november 2000 15:03
To: TDS Development Group
Subject: [freetds] Re: 255 char limit in result queries



run 'sp_help <tablename>' and post the output. That should be sufficient.
Make sure you give the query also.

Thanks,

Brian

On Tue, 7 Nov 2000, Brug, Herco van -Syntegra NL wrote:

> i'm not sure how to look up the table definition (as i am not the su of
the
> database server). in ms-access it tells me the fields i'm looking for are
of
> type 'memo'.
> i tried the convert(text,db.table.field) but that returns nothing.
according
> to my sql book this would convert a variable named 'text' to the 'field'
> charactertype. i dont think my book is right because if i try to convert
it
> to something else but 'text', the server tells me that's not a correct
> datatype.
>
> -----Original Message-----
> From: Brian Bruns [mailto:camber AT ais.org]
> Sent: vrijdag 3 november 2000 15:21
> To: TDS Development Group
> Subject: [freetds] Re: 255 char limit in result queries
>
>
>
>
> On Fri, 3 Nov 2000, Brug, Herco van -Syntegra NL wrote:
>
> > ok after some trial and error i set it with mssql_query("set textsize
> > 10000\nSelect * from something");
> > this still limited the result to 255 chars. setting it to 10 (!) did
limit
> > it to 10 chars so the thing works but only to make it smaller, not
bigger
> > than 255 chars.......
> > the field i'm querying btw is a 'memo' field with undefined length, not
a
> > normal textfield (which may be limited to 255 chars by definition?).
could
> > this have something to do with it?
> >
>
> That could have a lot to do with it. Please post the table definition
> (ddl) and I'll see what I can do. Unfortunately I don't have access to a
> 6.5 version of SQL Server, so I'll have to try it out under 7.0. BTW you
> might try 'select convert(text, mymemofield) from mytable' and see if
> that's any different.
>
> Brian
>
>
>
> ---
> 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
> -----------------------------
>
>
> ---
> You are currently subscribed to freetds as: [camber AT ais.org]
> To unsubscribe, forward this message to
$subst('Email.Unsub')
>


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