Memo field in Access
| From: | (CESBRON S.) | 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