RE: [PHP-WIN] MSSQL inserting into a table with a valid result se t
| From: | HKG) | Date: | Sat, 13 Mar 2004 08:05:46 +0000 |
| Subject: | RE: [PHP-WIN] MSSQL inserting into a table with a valid result se t | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-23126@lists.php.net to get a copy of this message | ||
One can also do cross queries between database instances in
the same MS SQL server (but I don't think this was the case
in this case?). Anyhow, if a result set has been fetched from
the same MS SQL server, then one alternatively can do like this:
SELECT ...
FROM <db1>..<tablename1>, <db2>..<tablename2>
...
but of course one need to have the proper grants in all
databases in order to do this.
-----Original Message-----
From: Robert Twitty
To: Gerardo Rojas
Cc: Svensson, B.A.T. (HKG); php-windows@lists.php.net
Sent: 12-3-2004 20:17
Subject: RE: [PHP-WIN] MSSQL inserting into a table with a valid result set
Hi Gerardo
If I understand you correctly, you can use the odbtp extension to
do something like the following: