Re: Newbie Question: listing open issues regardless of project

[Gleb Paharenko <suppressed>]

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