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,

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 t

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 s

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 expe

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 need

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

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 ke