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-28 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 what I've

[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

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

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

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 here, is this just

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 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 'a align=leftSelect Correct

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 'a align=leftSelect