Re: large number of data in MSSQL
| From: | sysadmin at cheezy dot net | Date: | Thu, 12 Jul 2001 16:24:00 +0000 |
| Subject: | Re: large number of data in MSSQL | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-8286@lists.php.net to get a copy of this message | ||
There is a sample of how to do this on the PHP manual page on COM. For those
lazy folks, here's some code that I have already used.
+ + + + +
$dbConn = new COM("ADODB.Connection") or die ("ouch!");
$dbConn->Open("Provider=SQLOLEDB; Data Source=server1; Initial Catalog=Pubs;
User ID=dbo; Password=");
$recordset = $dbConn->Execute($sql);
while (! $recordset->EOF) {
// *** here's the only real problem with using the ADO object
// you *have* to use two lines of code to extract the value.
$field = $recordset->Fields("fieldname");
print $field->value;
$recordset->MoveNext();
}
$recordset->Close();
$dbConn->Close();
+ + + + + +
hth,
-james.
To: php-windows@lists.php.net
Date: Thu, 12 Jul 2001 11:57:23 +0800
From: gary
Subject: Re: [PHP-WIN] large number of data in MSSQL
Hi Dario, Thank you. I would like to know how to use ADO in MSSQL 7.0. Can
you
tell me, please?
Gary