How to save a Memo field in Access

From: 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

« previous php.db (#3290) next »