Problem making an UPDATE statement with ACCESS
| From: | Roberto Sartor | Date: | Fri, 06 Oct 2000 09:50:48 +0000 |
| Subject: | Problem making an UPDATE statement with ACCESS | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-3378@lists.php.net to get a copy of this message | ||
Did you try without ";"?
I mean:
$sql = "UPDATE $table set Divers='voiture' WHERE
ID_etudiant=$ID";
Ciao
Roberto
> -----Messaggio originale-----
> Da: scesbron@escna.fr [mailto:scesbron@escna.fr]
> Inviato: venerdì 6 ottobre 2000 10.55
> A: php-db@lists.php.net
> Oggetto: [PHP-DB] Problem making an UPDATE statement with ACCESS
>
>
> Hi all,
>
> I'm getting trouble when using an update statement within an ACCESS
> database via ODBC. The plateform I use is PHP 4.0.2 / IIS 5.0
> / Win2000.
>
> Here's this statement :
>
> $sql = "UPDATE $table set Divers='voiture' WHERE
> ID_etudiant=$ID;";
> or
> $sql = "UPDATE $table set Divers='$Divers'
> WHERE ID_etudiant=$ID;";
>
> I also tried with :
> $sql = "UPDATE $table set Divers=\"voiture\"
> WHERE ID_etudiant=$ID;";
>
> and I'm still having the following error message :
>
> Warning: SQL error: [Microsoft][Pilote ODBC Microsoft Access]
> Erreur de
> syntaxe dans l'instruction UPDATE., SQL state 37000 in
> SQLExecDirect in
> xxxnew.php on line 126
>
>
> Any ideas about what that could be ???
>
> 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
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net
> For additional commands, e-mail: php-db-help@lists.php.net
> To contact the list administrators, e-mail:
> php-list-admin@lists.php.net
>