On Tue, 2002-06-18 at 16:34, Umaa Rebbapragada wrote: > I'm noticing that the fetchall_arrayref method in DBI doesn't handle multple result >sets. For example, if I prepare a statement using this sql (for example): > > select * from A > select * from B
This is actually two separate SQL statements. To collect these into one result set, you must do something like select * from A UNION select * from B And the two selects must return the same kind of rows: same number of columns and same data type in each column. -- Jeff Boes vox 616.226.9550 ext 24 Database Engineer fax 616.349.9076 Nexcerpt, Inc. http://www.nexcerpt.com ...Nexcerpt... Extend your Expertise
