I had the same problem with a cold fusion page a while ago. It turned out
that it was nothing to do with cold fusion but actually because I didn't
have the latest version of the MDAC components installed onto my cold fusion
server. There was a bug in previous versions which meant only the first 255
characters of a vchar field were returned from a query. This could be your
problem if you are working on windows (and especially if your database is MS
SQL 7)...
hth,
Kelvin.
-----Original Message-----
From: Andrian Pervazov [mailto:[EMAIL PROTECTED]]
Sent: 18 April 2001 14:46
To: Dan Cleveland
Cc: Josh Seward; Daniel Furse; [EMAIL PROTECTED]
Subject: [PHP-WIN] MSSQL varchar fields truncation revisited
I'm still using 3.0.16 and when you have to display a varchar field in a
MSSQL table everything over 255 characters gets truncated (this affects
only selects, not inserts). I know that a workaround would be to
transform the fieldtype from varchar to text, but this isn't very
practical in the particular case. So, does anybody know if the problem
still exists in later versions of PHP or has been fixed? Other
suggestions and workarounds will be appreciated as well.
Andrian
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
