Yes, I know that is true.
With a framework that is properly spread out however, often the inner query does not even know that the outer one is active.
The situation: list a bunch of hits from the database to be displayed in a table.
1) the query is constructed and handed to the framework to execute, as rows are returned they are given to the main application to display, however,
2) the main application decides that to properly show this record it must determine a few other things, then create the table row and return control to the framework. It wants to do this by creating a new select statement and running it.
It seems this is not possible if the framework tries to use a single global connection to the daemon, yes? no?
Can another connection be made?
thanks,
Don.
---
[EMAIL PROTECTED] wrote:
The parent-child type of query you want to make is generally accomplished through a JOIN. However, you say you have more data than you want to deal with at one time. Can you be more specific? What is the actual problem you are trying to solve? The more details you can give, the better the combined response will be.
Shawn Green Database Administrator Unimin Corporation - Spruce Pine
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
