 |
 |
Find a programming school near you
php-db | 2002122
Date: 12/31/02
- Next message: Steve Cayford: "Re: [PHP-DB] SHOW PICTURE FROM DATABASE"
- Previous message: rblack <email protected>: "[PHP-DB] Parameterised queries in Access"
- In reply to: rblack <email protected>: "[PHP-DB] Parameterised queries in Access"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Hello,
On 12/31/2002 09:57 AM, rblack <email protected> 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
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
- Next message: Steve Cayford: "Re: [PHP-DB] SHOW PICTURE FROM DATABASE"
- Previous message: rblack <email protected>: "[PHP-DB] Parameterised queries in Access"
- In reply to: rblack <email protected>: "[PHP-DB] Parameterised queries in Access"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
