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 ref

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

2005-01-12 Thread Marcus Claesson
one table and keep the database structure (if you can call it that ;-)) as simple as possible. Many thanks for all your help 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: > &

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
kept them together in the output. Hope this one is a bit clearer. 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 > > hav

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 p