Hi,
Maccess helps to analyse data in databases; it is a Web interface to
MySQL server. License is GPL.
Main features:
--
* user friendly query creation for MySQL server
* selective, grouped, and crosstab queries
* various outputs (XML, HTML, TXT, graphs)
* data ungrouping in grouped q
Hi!
My problem is when I use group by concat(col1,col2) when col1 and col2
is primary keys and col1 is varchar(255):
SELECT col1,col2 FROM Table1 GROUP BY concat(col1,col2);
-> return only one row - it is bad
SELECT col1,col2 FROM Table1 GROUP BY concat(col1,col1,col2);
-> return 48 rows - it
If you use perl try DBIx::XML_RDB:
http://www.xml.com/pub/a/2000/12/13/perlxmldb.html
(I don't tested this modul.)
You can try my soft Maccess :-) (with XML output):
http://www.meopta.com/products/software/maccess/
bye
Marek
- Original Message -
From: "Gorjan Todorovski" <[EMAIL PROT
Good morning!
Where is mistake?
my $dbh=DBI->connect("DBI:$driver:$database:$hostname",$user,$pass,{AutoCommit=>0});
my $sth=$dbh->prepare(q{
insert into
test.Pokus
(a,b)
values
(?,?)
});
foreach my $a ("a","b","c","d") {
$sth->execute($a,$a);
}
$dbh->commit;
$dbh->dis
