Re: Dynamic crosstab got me lost.

2012-11-20 Thread hsv
2012/11/19 05:05 +0100, Mogens Melander 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. And I was inspired to do some such thing to one of my views. This view

Re: Dynamic crosstab got me lost.

2012-11-20 Thread Mogens Melander
On Mon, November 19, 2012 17:02, Shawn Green wrote: > 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://stackoverf

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: Dynamic crosstab got me lost.

2012-11-18 Thread Mogens Melander
On Wed, November 14, 2012 09:23, Mogens Melander wrote: > Guru's > > I've been tasked with creating a report with information about > which images are related to each active article. The images > are descriptive icons visualizing different properties. > > Articles can be active 'on' or not '', and

Re: Dynamic crosstab got me lost.

2012-11-14 Thread Peter Brawley
nguage, such as PHP. -Original Message- From: Mogens Melander [mailto:mog...@fumlersoft.dk] Sent: Wednesday, November 14, 2012 12:23 AM To: mysql@lists.mysql.com Subject: Dynamic crosstab got me lost. Guru's I've been tasked with creating a report with information about which

RE: Dynamic crosstab got me lost.

2012-11-14 Thread Mogens Melander
sultset for the information, but the > layout is best done in a application language, such as PHP. > >> -Original Message- >> From: Mogens Melander [mailto:mog...@fumlersoft.dk] >> Sent: Wednesday, November 14, 2012 12:23 AM >> To: mysql@lists.mysql.com >>

RE: Dynamic crosstab got me lost.

2012-11-14 Thread Rick James
age- > From: Mogens Melander [mailto:mog...@fumlersoft.dk] > Sent: Wednesday, November 14, 2012 12:23 AM > To: mysql@lists.mysql.com > Subject: Dynamic crosstab got me lost. > > Guru's > > I've been tasked with creating a report with information about which images