Hello, On 12/31/2002 09:57 AM, [EMAIL PROTECTED] wrote:
The definitive answer is no, despite I don't see why not. It seems to be a problem with PHP.I'm trying to run a parameterised query in MS Access using odbc_prepare and odbc_execute but to no avail.The error message I'm getting is: Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1., SQL state 07001 in SQLExecute in c: \inetpub\wwwroot\test\access_db.php on line 17 I've read conflicting messages saying that this paramaterised queries with Access do or don't work. Any definitive answer?
Anyway, you may want to try Metabase which is a PHP abstraction package for developing portable PHP database applications. It supports prepared queries. It comes with a ODBC driver and a sub-driver specialized in Microsoft Access.
Metabase is Open Source and is available here:
http://www.phpclasses.org/metabase
There is a version that is about to be released that includes the specialized ODBC MS Access driver but that is only available for beta testing here:
http://groups.yahoo.com/group/metabase-dev/files/beta/
--
Regards,
Manuel Lemos
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php