Re: can't get the order I want after inserting new rows

2005-01-12 Thread Marcus Claesson
Thanks for your help guys! By looking at your solutions I understand how it's meant to work. The problem is that I'm using the older MySQL 3.23.58. And I'm bound to stick with that version since it's standard in most Redhat distributions, and the program I'm writing will be used on several of thos

Re: can't get the order I want after inserting new rows

2005-01-11 Thread SGreen
Marcus Claesson <[EMAIL PROTECTED]> wrote on 01/11/2005 11:05:49 AM: > Thanks for helping! > > > So you ARE having problems trying to change your sbj_count and > > hsp_count columns after adding information to your table your so that > > data is re-ranked according to some rule(s) you have. Exac

Re: can't get the order I want after inserting new rows

2005-01-11 Thread Michael Stassen
Marcus Claesson wrote: Hi Michael! Before the holiday you tried to help me with a problem that I had over-simplified and made more confusing than it was. I'll now try again, and also by giving the columns their right names. My table consists of parsed outputs from a bioinformatics tool called blast

Re: can't get the order I want after inserting new rows

2005-01-11 Thread Marcus Claesson
Thanks for helping! > So you ARE having problems trying to change your sbj_count and > hsp_count columns after adding information to your table your so that > data is re-ranked according to some rule(s) you have. Exactly, how do > you determine the new ranking? I could make a guess based on your

Re: can't get the order I want after inserting new rows

2005-01-11 Thread SGreen
Marcus Claesson <[EMAIL PROTECTED]> wrote on 01/10/2005 02:00:37 PM: > Hi Michael! > > Before the holiday you tried to help me with a problem that I had > over-simplified and made more confusing than it was. I'll now try again, > and also by giving the columns their right names. > > My table co

Re: can't get the order I want after inserting new rows

2005-01-10 Thread Marcus Claesson
Hi Michael! Before the holiday you tried to help me with a problem that I had over-simplified and made more confusing than it was. I'll now try again, and also by giving the columns their right names. My table consists of parsed outputs from a bioinformatics tool called blast. Every 'sbj_name' (w

Re: can't get the order I want after inserting new rows

2004-12-18 Thread Michael Stassen
Marcus Claesson wrote: Hi! I have a problem with getting the order I want on a table after new rows have been inserted. I try to simplify it...: Perhaps you have simplified too much, then, as I simply do not understand what you want. Comments and questions below. I want to have a one-to-one rela