I sent a previous question about having problems with SQL statements
using parameters not working in MySQL when they worked in Access. I am
using the ODBC driver and ADO and have had no problems at all to date.
Upon some further research the problem seems limited to SELECT
statements. Updates, Inserts and Deletes all work fine, but the SELECT
statement returns an 'unspecified error'
I can execute the following DELETE statement fine:
DELETE FROM Bio WHERE BioID = ?
However, the SELECT statement:
SELECT * FROM Bio WHERE BioID = ?
returns with an 'unspecified error'
Can anyone provide some insight into this? Thanks in advance for your help.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php