How to save a Memo field in Access
| From: | (CESBRON S.) | Date: | Wed, 04 Oct 2000 07:32:18 +0000 |
| Subject: | How to save a Memo field in Access | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-3290@lists.php.net to get a copy of this message | ||
Hi,
I'd like to know if someone can tell me how to store a Memo field in my
Access database.
I'm using PHP 4.0.2 on IIS 5.0 / Win2000, database connection via ODBC.
I tried the following statements, none works.
$sql = "UPDATE $table set Divers='$Divers' WHERE ID_etudiant=$ID;";
$sql = "UPDATE $table set Divers=\"$Divers\" WHERE ID_etudiant=$ID;";
$sql = "UPDATE $table set [Divers]=[$Divers] WHERE ID_etudiant=$ID;";
I'd like to save some text which can also contain carrier return character,
therefore I think that a Memo field is the best way to do it. If you've got
another suggestion, I'm interrested in it!!!
Could anyone point me out ?
Stéphane Cesbron
Chargé du développement Internet/Intranet
Groupe E.S.C. Nantes Atlantique
8 route de la Jonelière
B.P. 31222
44312 Nantes Cedex 3
Tél : 02.40.37.34.47