Numbering Rows on Output

2005-11-28 Thread Hal Vaughan
I have a table that lists the tasks a program has to do. Lately I've found I can have an at-a-glance status report of how things are going on by writing a loop (in bash scripting, on Linux, btw) that uses mysql -e to display the list of tasks and their current state. It's quick and a lot

Re: Numbering Rows on Output

2005-11-28 Thread Dan Nelson
In the last episode (Nov 28), Hal Vaughan said: I have a table that lists the tasks a program has to do. Lately I've found I can have an at-a-glance status report of how things are going on by writing a loop (in bash scripting, on Linux, btw) that uses mysql -e to display the list of tasks

Re: Numbering Rows on Output

2005-11-28 Thread Hal Vaughan
On Monday 28 November 2005 04:45 pm, Dan Nelson wrote: In the last episode (Nov 28), Hal Vaughan said: I have a table that lists the tasks a program has to do. Lately I've found I can have an at-a-glance status report of how things are going on by writing a loop (in bash scripting, on

Re: Numbering rows

2005-05-17 Thread Harald Fuchs
In article [EMAIL PROTECTED], Mauricio Pellegrini [EMAIL PROTECTED] writes: Wow, that's simply magic!!! You couldn't imagine how many diferent things I've tried to solve this problem.. And when I thought it was impossible ...your solution worked just fine at once! God bless experienced

Re: Numbering rows

2005-05-13 Thread Harald Fuchs
In article [EMAIL PROTECTED], Mauricio Pellegrini [EMAIL PROTECTED] writes: This is the table I have Column Id is primary key and auto_numeric - Idorder itemvalue col_type - 1 3 15

Re: Numbering rows

2005-05-13 Thread Mauricio Pellegrini
Wow, that's simply magic!!! You couldn't imagine how many diferent things I've tried to solve this problem.. And when I thought it was impossible ...your solution worked just fine at once! God bless experienced people!! The reason for trying to do such a weird thing on col_type is that a

Numbering rows

2005-05-12 Thread Mauricio Pellegrini
Hi , I don't know if this is possible with Sql but I'm trying to set the row number into a field for each row. The complexity comes when I try to do that according to some grouping rules. I think I'll made myself more clear with a simple example: This is the table I have Column Id is primary