php-db | 2002122

[PHP-DB] Parameterised queries in Access From: rblack <email protected>
Date: 12/31/02

Hi All,

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?

Win XP
Apache 1.3.24
PHP 4.2.3
Access ODBC driver: 4.00.6019.00

Thanks

Richy

==========================================
Richard Black
Senior Developer, DataVisibility Ltd - http://www.datavisibility.com
Tel: 0141 951 3481
Email: rblack <email protected> 

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