If I do a query on a table which has a column of the 'text' type, I get the following error: "Positioned request cannot be performed because result set was generated by a join condition". This is on a simple select with a join between two tables.
I'm using a wrapper class from codeproject.com to connect to the database and perform queries (http://www.codeproject.com/database/odbcrecordset.asp). Queries on the net regarding the error come back mostly with web pages about people trying to do updates on a join, but this is just is just a regular select query. If I change the text to a varchar, the error disappears but the varchar type is limited to 255 characters. If I just do a select on one table (with a 'text' column), there is also no error. Only on a join. Has anyone every seen this issue before? Regards, Collin --------------------------------------------------------------------- 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
