query
| From: | pei_world | Date: | Wed, 19 Feb 2003 19:53:33 +0000 |
| Subject: | query | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-25773@lists.php.net to get a copy of this message | ||
$conn = new COM("ADODB.Connection");
$conn->Open("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=$database");
$query = "SELECT * FROM user";
$result = $conn->Execute($query) or die("fail to connection to the
database!");
if ($result->RecordCount()!=-1){
//do something
}
--
Sincerely your;
pei_world ( .::IT::. )
"Pei_world" <pei_world@hotmail.com> wrote in message
news:20030219020900.95335.qmail@pb1.pair.com...
> when I try to connection to the access file using Microsoft Jet Engine. it
> come up with following error!
> can anyone help me?
>
> $result = $conn->Execute($query) <----error line
> I check the table is exists,and the query should be correct.
>
> ----------------------------------------------------------
> Warning: Invoke() failed: Exception occurred. Source: Microsoft JET
Database
> Engine Description: Syntax error in FROM clause.
> -----------------------------------------------------------------
> thx
> --
> Sincerely your;
>
> pei_world ( .::IT::. )
>
>