Re: Parameterised queries in Access

Hello, On 12/31/2002 09:57 AM, rblack@datavisibility.co.uk wrote:

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?

The definitive answer is no, despite I don't see why not. It seems to be a problem with PHP. 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