| |
| |
| |
|
Page: 1 2 3 4
Comments:
<0> well, i'm glad you cleared that up, because it was not apparent until now
<1> It's a simple question. Do you know a less ugly way than sorting on floats to implement a column which represents a quickly rearrangable sort?
<0> the problem is you're asking two different questions without realising it (apparently)
<1> YuppieScm: which are those?
<1> zoul: cut it out.
<0> less ugly that sorting on floats - yes, on int
<1> the problem with using ints is that that makes rearrangability a serious problem for update behavior.
<2> StoneCydh you used the word "ugly".. it reminds zoul of all those trips to the mirror
<3> I told you not to tell anyone, jack***
<0> quickly re-arrangeable? why? a change in the ordering will be done by a person at a gui?
<2> ow you bish!
<1> YuppieScm: for all intents and purposes, yes
<1> YuppieScm: it's a little weirder than that, but pretty much, yeah
<1> the tool is here to help us find a more efficient arrangement for a huge bulk of tasks across a huge bulk of groups with diverse work skills
<0> it seems that it's not 'rearrangability' that you need, but the ability to amend the order values
<1> i don't understand the difference
<0> exacgtly
<4> work is a bitch, and then you die
<1> I'd appreciate being filled in
<2> then you would enjoy prison
<2> OH you meant somethign else
<0> StoneCydh : is there a one->one mapping between a 'task' and it's appearance in an ordered list? can a taks appear on two lists, or appear more than once in the same list?
<1> YuppieScm: it is one to one. This is a master list with no sublists, and no tasks share priorities.
<0> which rdbms?
<1> At the moment it's mysql, but if there's a portable answer it would be preferred.
<4> people should state they before they start asking questions
<4> it is one of the rules on join after all
<0> there isn't - thanks for playing
<1> Well, the float column is portable.
<1> Maybe there just isn't a better answer. :(
<2> MYSQL!?
<1> I dunno, it just seems like this ought to be a common enough need that SQL would model it.
<2> ****
<2> kill
<0> StoneCydh : that's what most people who use mysql say
<0> about pretty much everything
<2> which is why the topic says "NO MYSQL!"
<5> #mysql
<6> heh
<6> halo is an op there
<1> well, I also use sqlite and postgres
<1> it's just a question of what the administrators have on the server
<7> lol, today is monday, we install mysql on mondays
<7> and server set up on thursdays gets postgres
<8> and on wednesdays we get mssql or oracle
<7> heh
<1> wtf.
<1> so
<1> my problem won't get answered
<4> no StoneCydh, you use mysql
<1> because i've chosen to use an rdbms you guys don't like
<1> even though i want a portable solution?
<4> god doesn't like it
<8> that was fun
<9> haha, www.magazinet.no seems to be quite busy today, too bad the chose a crappy DB engine
<3> bleh
<10> hello all
<10> ohh
<10> thats not fare
<10> anyways
<10> i installed Sql server 2005
<10> how can i access the database?
<10> can't find anything
<11> ?
<4> that was interesting
<4> i'm going to ask a question, and if you don't answer in 30 seconds I'm leaving CoJoNEsX
<4> I pay good money for sql support
<4> I wish to speak with your boss
<4> :/
<12> heh
<13> if I have two columns, Total1 and Total2, and I want to add them together in a SELECT statement, how do I do that? SELECT Name, Date, Total1+Total2 as TotalValue FROM blah where blahID = 3?
Return to
#sql
or
Go to some related
logs:
#beginner
#3dsmax
#nhl
#computers
kourtiche
#politics
Windows.98SE.Final
script invite.tcl sql
plate spin vmware
#hardware
|
|