The code that does the fetch is a PREPARE and EXECUTE. I have tried the SQL with substitutable values (putting my search terms in the EXECUTE), creating the SQL with the search terms JOINed before the PREPARE, and finally, a pure hard-coded SQL with not variables and all return one row.

I've also tried 'selectall_array(sql-string)' and it too returns one row.

I can see in the DBI trace that MySQL is returning one row so it doesn't matter how I output the data, there's still just one row returned.

Thanks for all of the advice! Dave Dave