RE: [PHP] MSSQL 7.0 and PHP
| From: | Nick Richardson | Date: | Wed, 24 Oct 2001 04:55:16 +0000 |
| Subject: | RE: [PHP] MSSQL 7.0 and PHP | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-72046@lists.php.net to get a copy of this message | ||
my understanding (and i could be totally wrong) is varchar only accepts
values up to 255 (so does char). To get larger than that you have to use
'text' (i.e. create table <name> (<column> text not null......);
-----Original Message-----
From: Franco Breciano [mailto:fbrecia@fi.uba.ar]
Sent: Tuesday, October 23, 2001 7:59 PM
To: php-general@lists.php.net
Subject: [PHP] MSSQL 7.0 and PHP
I'm using php to retrieve a Query from a SQLServer 7.0 database.
My code is this one:
$base = mssql_select_db($db,$conexion);
$sql="SELECT MarcasSolicitante FROM Marcas";
$result = mssql_query($sql,$conexion);
while ($myrow = mssql_fetch_array($result))
{
$mensaje= $myrow["MarcasSolicitante"];
?>
<p><strong><font size="4"><u>Mensaje:</u></strong>
   </u> <font
size="3"><?echo $mensaje;?> </font></a></P>
<hr>
<....>
<....>
The problem is that the field MarcasSolicitante in the database is
VarChar(7000), and php receives a Char(255), what I'm I doing wrong? Isi
there any parameter I can modify in order to retrieve correctly the fields??
Thanks in advance
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net
For additional commands, e-mail: php-general-help@lists.php.net
To contact the list administrators, e-mail: php-list-admin@lists.php.net