Hi,
My database table contains many records with the same value for the field
"batchnum", and I want to extract the batch numbers and list them in an HTML
table.
SELECT * ... will give me thousands of records, which I don't want. SELECT
DISTINCT Batchnum gives the correct result, but I cannot seem to convince
DBIx::Recordset to do it.
Using:
$fdat{'!fields'} = 'Distinct Batchnum';
- ignores the "distinct" phrase.
$fdat{'$fields'} = 'Distinct Batchnum';
- produces NO results although according to debug log query is executed.
--- for info, preceding lines:
use DBIx::Recordset ;
$DBIx::Recordset::Debug = 8;
$DBIx::Recordset::PreserveCase=1;
$DBIx::Recordset::FetchsizeWarn=0;
--- execute line:
*BatchData = DBIx::Recordset -> Execute (\%fdat);
Can someone please explain?
TiA.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
