RE: [PHP-WIN] MSSQL inserting into a table with a valid result set

According to your last email, i can accomplish my goal, by doing: insert into tablename select xxxxx where xxxx is another table i presume. I don't have another table, all I have is a valid $result from running a query. I see what you mean, the thing is that one query is from 1 remote db and the second query (insert command) is on another remote db. -- Gerardo S. Rojas mailto: grojas@strategicinc.com -----Original Message----- From: Svensson, B.A.T. (HKG) [mailto:B.A.T.Svensson@lumc.nl] Sent: Friday, March 12, 2004 12:26 PM To: php-windows@lists.php.net Subject: RE: [PHP-WIN] MSSQL inserting into a table with a valid result set I don't understand your question. On Fri, 2004-03-12 at 16:42, Gerardo Rojas wrote: > Can i do a select from a PHP: resource (positive MSSQL result identifier) > > > -- > Gerardo S. Rojas > mailto: grojas@strategicinc.com > > > -----Original Message----- > From: Svensson, B.A.T. (HKG) [mailto:B.A.T.Svensson@lumc.nl] > Sent: Thursday, March 11, 2004 3:25 PM > To: 'php-windows@lists.php.net ' > Subject: RE: [PHP-WIN] MSSQL inserting into a table with a valid result > set > > > You can do a insert into with a SELECT instead of VALUE, > but the attribute in the select must agree with the table > definition. > > > -----Original Message----- > From: Gerardo Rojas > To: php-windows@lists.php.net > Sent: 11-3-2004 21:54 > Subject: [PHP-WIN] MSSQL inserting into a table with a valid result set > > I have a valid result set from running a simple query. Is there a way > of inserting this into an existing table or creating a new table with > the result set? All ideas are welcome! > > MSSQL Server 2000 > PHP 4.3.4 > Windows 2000 pro > IIS 5.0 > > > -- > Gerardo S. Rojas > mailto: grojas@strategicinc.com > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php