Re: [PHP-DB] Maximum field length with PHP 4.1.2/MSSQL v7 ?

2002-05-04 Thread Chris MacKenzie
"Frank M. Kromann" wrote: Many thanks Frank, changing from varchar to text did indeed fix the problem. On reflection, I do now remember reading about this on another mailing list, it's a pitty my memory failed me when I needed it the most :-) > The tool used to build the MSSQL extension for PHP

Re: [PHP-DB] Maximum field length with PHP 4.1.2/MSSQL v7 ?

2002-04-27 Thread pan
cc:'d to poster From: "Chris MacKenzie" <[EMAIL PROTECTED]> > > Either one of the unknown queries in edit_exam_question.inc > > is truncating the data or the url parameter is truncated, or > > dbconn.inc is the culprit. > > I've attached the two missing files, so this should help to diagnose > w

Re: [PHP-DB] Maximum field length with PHP 4.1.2/MSSQL v7 ?

2002-04-27 Thread Chris MacKenzie
pan wrote: > >Ah, sorry I didn't make it terribly clear. I meant that I only ever get > >a maximum of 255 chars returned. > > O.K. - then that makes it seem a truncation problem and not a > data definition problem. > > minor thing: in edit_exam_question.php there is > " print 'Select Correct

Re: [PHP-DB] Maximum field length with PHP 4.1.2/MSSQL v7 ?

2002-04-27 Thread pan
cc:'d to poster >Ah, sorry I didn't make it terribly clear. I meant that I only ever get >a maximum of 255 chars returned. O.K. - then that makes it seem a truncation problem and not a data definition problem. minor thing: in edit_exam_question.php there is " print 'Select Correct Answer:';

Re: [PHP-DB] Maximum field length with PHP 4.1.2/MSSQL v7 ?

2002-04-27 Thread Chris MacKenzie
pan wrote: > i.e., do you know the db.table.field in question is a column type meant > to hold the data you expect? You seem to be indicating a consistent > return of 255 when you ask for 400 - seems to be a clue about the > field specification. Ah, sorry I didn't make it terribly clear. I meant

Re: [PHP-DB] Maximum field length with PHP 4.1.2/MSSQL v7 ?

2002-04-27 Thread Chris MacKenzie
pan wrote: > > From: "Chris MacKenzie" <[EMAIL PROTECTED]> > > I've come across an interesting problem. I'm trying to retrieve some > > text data (in this case a question up to 400 chars), but each time I > > perform a select statement I only receive the first 255 chars. > > > > What's the go her

Re: [PHP-DB] Maximum field length with PHP 4.1.2/MSSQL v7 ?

2002-04-27 Thread bob parker
Pan, It looks as if you may be using FORM with method=get. If so try method=post to get the full data Bob Parker On Saturday 27 April 2002 20:35, you wrote: > From: "Chris MacKenzie" <[EMAIL PROTECTED]> > > > I've come across an interesting problem. I'm trying to retrieve some > > text data (in

Re: [PHP-DB] Maximum field length with PHP 4.1.2/MSSQL v7 ?

2002-04-27 Thread pan
From: "Chris MacKenzie" <[EMAIL PROTECTED]> > I've come across an interesting problem. I'm trying to retrieve some > text data (in this case a question up to 400 chars), but each time I > perform a select statement I only receive the first 255 chars. > > What's the go here, is this just another

[PHP-DB] Maximum field length with PHP 4.1.2/MSSQL v7 ?

2002-04-27 Thread Chris MacKenzie
Hi All, I've come across an interesting problem. I'm trying to retrieve some text data (in this case a question up to 400 chars), but each time I perform a select statement I only receive the first 255 chars. What's the go here, is this just another microsoft thing ? -- Rgds, Chris MacKenzie W