Parameters and Access
| From: | rblack at datavisibility dot co dot uk | Date: | Tue, 31 Dec 2002 11:57:59 +0000 |
| Subject: | Parameters and Access | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-129763@lists.php.net to get a copy of this message | ||
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@datavisibility.co.uk