RE: Newbie Question: listing open issues regardless of project

.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

RE: Newbie Question: listing open issues regardless of project

its value depending on the value in other field. Am I correct? Please provide a sample output (what you want to see in the results) in case I'm wrong. Now I'm not talking about syntax, but rather about sense of the query. Kraer, Joseph wrote: > I am sending this message to both Eventum

Newbie Question: listing open issues regardless of project

I am sending this message to both Eventum and MySQL support lists. I am trying to write a select statement in the MySQL Query Browser (v. 1.1.10) on my Eventum (v. 1.4) database; MySQL version is 4.0.21 (PHP is 4.3.10). My goal is to list certain data from all open issues, across projects, as wel

Newbie question to both lists on listing open issues regardless of project

I am trying to write a select statement in the MySQL Query Browser (v. 1.1.10) on my Eventum (v. 1.4) database; MySQL version is 4.0.21 (PHP is 4.3.10). My goal is to list certain data from all open issues, across projects, as well as listing some issue details contained in custom fields. I don't

RE: Newbie Question on Update

seph "Tito" Kraer Business Systems Analyst Taylor, Bean & Whitaker Mortgage Corp From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 30, 2005 12:13 PM To: Kraer, Joseph Cc: mysql@lists.mysql.com Subject: Re: Newbie Questio

Newbie Question on Update

I am trying to update a couple of rows in a table by doing the following: update table set column5 = number1 where column 1 = number2 and column1 = number3 but it is not working. I tried listing the conditions separated by commas (where column 1 = number2, column1 = number3) and also didn't work

RE: MySQL server has gone away

Mortgage Corp From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 16, 2005 4:39 PM To: Kraer, Joseph Cc: mysql@lists.mysql.com Subject: Re: MySQL server has gone away "Kraer, Joseph" <[EMAIL PROTECTED]> wrote on 11/16/2005 04

MySQL server has gone away

First let me say that I'm a newbie and that I've seen a few instances of this error in the list, but I haven't seen my case. I'm running WAMP5, v. 1.4.4. I'm trying to restore an Eventum v. 1.4 backup done with mysqldump in a LAMP machine. The restoration process invariably stops at line 517. I