RE: Newbie Question: listing open issues regardless of project

["Kraer, Joseph" <suppressed>]

Shawn, Glen, and everyone else,

Thank you very much!  I do believe that I have enough material to work
on it now!

I appreciate your help very much!

Joseph "Tito" Kraer
Business Systems Analyst
Taylor, Bean & Whitaker Mortgage Corp

-----Original Message-----
From: Gleb Paharenko [mailto:suppressed 
Sent: Tuesday, December 06, 2005 11:03 AM
To: suppressed
Subject: Re: Newbie Question: listing open issues regardless of project

Hello.



So it is clear now, that you should have 16 columns and to build

dynamically the column headings. The usual way to do such things

in SQL is prepared statements. See:

  http://dev.mysql.com/doc/refman/5.0/en/sqlps.html



And good example of how to use them (though it is an article about

stored routines) here:

  http://dev.mysql.com/tech-resources/articles/mysql-storedproc.html



You will need to use user variables as well:

  http://dev.mysql.com/doc/refman/5.0/en/example-user-variables.html



CONCAT function:

  http://dev.mysql.com/doc/refman/5.0/en/string-functions.html



Control flow functions:

  http://dev.mysql.com/doc/refman/5.0/en/control-flow-functions.html



Correlated subqueries:

  http://dev.mysql.com/doc/refman/5.0/en/correlated-subqueries.html



Hope that'll be enough to make your query work.







Kraer, Joseph wrote:

> Gleb,

> 

> What I need to have is a total of 16 columns: issue ID, priority,

> assigned (to), project name, category, status, last update date,

> summary, product name, project name (not the same as before), change

> requester, change type, requested completion date, lead, developer,

> impacted dept.

> 

> I have no problems generating the first eight or the last columns.
The

> seven in between are the issue as they are not columns per se.  They
are

> cells in different tables.  I need to extract the contents of certain

> cells, based on certain IDs, to be used as the column headings in the

> output to my query.  Then, I need to look into other tables to fill

> those columns.  This is what I need help with: how do I generate those

> columns?  I guess they could be generated separately and then I could

> put both of my outputs together.  Unfortunately, time is running out.

> 

> TIA,

> 

> Joseph "Tito" Kraer

> Business Systems Analyst

> Taylor, Bean & Whitaker Mortgage Corp

> 

> -----Original Message-----

> From: Gleb Paharenko [mailto:suppressed

> Sent: Tuesday, December 06, 2005 6:52 AM

> To: suppressed

> Subject: Re: Newbie Question: listing open issues regardless of
project



-- 
For technical support contracts, goto
https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   suppressed
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
       <___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/suppressed


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/suppressed