Re: [PHP-DB] problem in PHP with ADODB connection, Microsoft JET

[Ruprecht Helms]

Hi  Jason Wong,

>> --
>> Warning: Invoke() failed: Exception occurred. Source: Microsoft JET
>> Database Engine Description: Syntax error in FROM clause.
>> -
> 
> The error is quite explicit:  "Syntax error in FROM clause"

please post the actual sql-query for correction. 

Regards,
Ruprecht

--
Ruprecht Helms IT-Service und Softwareentwicklung

Tel/Fax.:  +49[0]7621 16 99 16
Homepage:  http://www.rheyn.de
email:  [EMAIL PROTECTED]
--

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] problem in PHP with ADODB connection, Microsoft JET Database

[Jason Wong]

On Wednesday 19 February 2003 10:09, pei_world wrote:
> when I try to connection to the access file using Microsoft Jet Engine. it
> come up with following error!

>   $result = $conn->Execute($query)  I check the table is exists,and the query should be correct.

*should* be correct or IS correct? There's quite a difference.

> --
> Warning: Invoke() failed: Exception occurred. Source: Microsoft JET
> Database Engine Description: Syntax error in FROM clause.
> -

The error is quite explicit:  "Syntax error in FROM clause"

So unless the Jet Engine is lying or is buggy then you have an incorrectly 
formed query.

> can anyone help me?

Nobody can help you unless you post your query.

-- 
Jason Wong -> Gremlins Associates -> www.gremlins.biz
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *
--
Search the list archives before you post
http://marc.theaimsgroup.com/?l=php-db
--
/*
When it is not necessary to make a decision, it is necessary not to
make a decision.
*/


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php