newbie:sql update
| From: | Apollo | Date: | Mon, 10 Feb 2003 09:04:37 +0000 |
| Subject: | newbie:sql update | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-18425@lists.php.net to get a copy of this message | ||
Hi,
I'm trying out some few things about updating a database...
$connection = odbc_pconnect("OpusDB","","",SQL_CUR_USE_ODBC);
// define the rows that are going to be extracted
odbc_exec($connection,"UPDATE DeptMaster SET Counter=Counter+1
WHERE DeptDesc='$mydepartment'");
here's the error:
Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Operation must
use an updateable query., SQL state S1000 in SQLExecDirect in
c:\inetpub\wwwroot\TMPlvv9ya34u1.php on line 16
I am trying this out on an IIS in XP with the MSACCESS database...
Pls. help. Thanks.