Memo field in Access

From: Date: Thu, 05 Oct 2000 07:58:00 +0000
Subject: Memo field in Access
Groups: php.db 
Request: Send a blank email to php-db+get-3347@lists.php.net to get a copy of this message
Hi, I'm experiencing a problem with an Access database. I'm developping a new application which will enable student to store their resume on a MS Access based database. Therefore by the end of the formular form, I introduced a TEXTAREA field where students will be able to put anything about their leisure or ... I used a TEXTAREA to enable CR in this field, and I mapped it onto a Memo field in my database also to enable CR. My question is the followind : How can I update data into the database ? I tried the followings but 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;"; Any suggestion will be greatly appreciated ! Thanks Stéphane 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 (#3347) next »