RE: [PHP-WIN] newbie:sql update
| From: | HKG) | Date: | Mon, 10 Feb 2003 14:26:53 +0000 |
| Subject: | RE: [PHP-WIN] newbie:sql update | ||
| References: | 1 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-18430@lists.php.net to get a copy of this message | ||
There exists an know bug with ODBC that generates
SQL STATE S1000 (== General Error). I think a
workarounds can be found (somewhere) at www.MSDN.com.
> -----Original Message-----
> From: Apollo [mailto:amcogal@hotpop.com]
> Sent: Monday, February 10, 2003 10:05 AM
> To: php-windows@lists.php.net
> Subject: [PHP-WIN] newbie:sql update
>
>
> 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.
>
>
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>