Announce: Maccess 1.9.1 Has Been Released

[Marek Chlup]

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 queries
* creation of Web links and definition of CSS styles for all values in
  output
* ability to format numbers, dates, and times
* input and data update

Home Page:
--
http://www.chlup.net/products/software/maccess/
There's a screenshots and online demo.

Changes:

Maccess is now compatible with Mozilla. Many features are available from
Mozilla: drag and drop when creating a query, click and sort, a context
menu, filter highlighting rows, and formatting values. Rendering output
was improved for text Web browsers (such as links). Special settings
were added for query forms. Many codes were rewritten. Maccess now uses
owner XML transformation code to produce HTML and TXT formats. The
transformation code uses the libxml2 library.

Bye
Marek


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

group by concat

[Marek Chlup]

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 is ok, but concat(col1,col1,col2) is stupid

I change col1 to varchar(155):
SELECT col1,col2 FROM Table1 GROUP BY concat(col1,col2);
- return 48 rows - it is ok

My platform: Linux x86, MySQL 3.23.39, table is myisam format.

Is it bug or feature?

Thanks
Marek


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Mysql and transactions and perl DBI

[Marek Chlup]

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-disconnect;

Perl error:
Transactions not supported by database at /usr/lib/perl5/5.6/i386-linux/DBI.pm line 433

I use:
Debian GNU/Linux sid (i386)
MySQL 3.23.31
DBI 1.14
BDB::mysql 1.2215
table Pokus is BerkeleyDB type

Thanks for your answer.

Bye
Marek



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php