Re: Dynamic crosstab got me lost.

2012-11-19 Thread hsv
2012/11/19 04:49 -0800, Jan Steinman > SELECT main.code > , IF(iconstandardrel.icon = 4,1,0) AS 'internationalt_produkt.eps' > , IF(iconstandardrel.icon = 3,1,0) AS 'god_vaerdi.eps' > , IF(iconstandardrel.icon = 2,1,0) AS 'for_miljoeets_skyld.eps' > , IF(iconstandardrel.icon = 1,1,0) AS '

Re: Dynamic crosstab got me lost.

2012-11-19 Thread Shawn Green
On 11/19/2012 9:02 AM, Mogens Melander wrote: On Mon, November 19, 2012 13:49, Jan Steinman wrote: From: "Mogens Melander" So, I got a little further with my problem. I found an article on: http://stackoverflow.com/questions/3122424/dynamic-mysql-query-view-for-crosstab Describing how to do

Re: Dynamic crosstab got me lost.

2012-11-19 Thread Mogens Melander
On Mon, November 19, 2012 13:49, Jan Steinman wrote: >> From: "Mogens Melander" >> >> So, I got a little further with my problem. I found an article >> on: >> >> http://stackoverflow.com/questions/3122424/dynamic-mysql-query-view-for-crosstab >> >> Describing how to do the dynamic generation of S

Re: Dynamic crosstab got me lost.

2012-11-19 Thread Jan Steinman
> From: "Mogens Melander" > > So, I got a little further with my problem. I found an article > on: > > http://stackoverflow.com/questions/3122424/dynamic-mysql-query-view-for-crosstab > > Describing how to do the dynamic generation of SQL statements. That's > all good, kind of. The resulting SQ

Re: ERROR 2013 (HY000): - Why ?

2012-11-19 Thread Claudio Nanni
On 11/19/2012 10:27 AM, walter harms wrote: hi List, i get occasionally the following error: ERROR 2013 (HY000): Lost connection to MySQL server at 'sending authentication information', system error: 32 $ perror 32 OS error code 32: Broken pipe Just to start. If you want help you should inc