Help with SQL query construction

2007-12-03 Thread Marcus Claesson
Hi! I have a SQL query construction question that I hope someone can help me with. After comparing a bunch of DNA fragments (see name below) with a larger reference sequence I get a ordered list ranked according to similarities, and with start/stop co-ordinates where the fragments map to the

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

2005-01-12 Thread Marcus Claesson
and effort!! Marcus On Tue, 2005-01-11 at 17:08, [EMAIL PROTECTED] wrote: 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

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-10 Thread Marcus Claesson
. Many thanks! Marcus On Sat, 2004-12-18 at 21:25, Michael Stassen wrote: 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

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

2004-12-16 Thread Marcus Claesson
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...: I want to have a one-to-one relationship between 'name' and 'full'. Every 'name' (or'full') have one or more 'parts'. The higher the 'score' the lower the 'full', but for my