Oninit cdi / Archive
Talk to an expert →

Re: table output order

Posted in 2000

Topics: Stored Procedures & SPL, Platform-Specific Issues

Obnoxio The Clown — — source: Informix-list mailing list archive (1991-1998)

From: Radu Dumitriu <radu@goldenclick.com> > >Don't be too rough on him@edu, he's learning (otherwise he wouldn't be >asking >that question ...). A good place to start learning is RTFM. Then ask questions. >Murray Wood wrote: > > > ORDER BY 1, 2, 3 > > The SQL Syntax manual! > > > > -----Original Message----- > > From: owner-informix-list@iiug.iiug.org > > [mailto:owner-informix-list@iiug.iiug.org]On Behalf Of Richard E. > > Hassler > > Sent: Friday, December 08, 2000 10:49 AM > > To: informix-list@iiug.org > > Subject: table output order > > > > I have the latest version of SE (7.?) running on an HP-UX version 10.2. > > > > I set up a table of 3 fields one of which is a sequencial number from > > 1-700. The sequential column is indexed. The data is loaded into the > > table in ascending order, i.e. 1 2 3 . . . > > > > When I do a 'select * from tablename' in SQL or do an escape in the > > sequential field in a PERFORM screen the rows are displayed in reverse > > order by sequential number, i.e. 700 699 698 . . . I would like them to > > list in ascending order, i.e. 1 2 3 . . . Is there any way to do this? ><< radu.vcf >> _____________________________________________________________________________________ Get more from the Web. FREE MSN Explorer download : http://explorer.msn.com

↪ replying to Obnoxio The Clown
malc_p@my-deja.com — — source: Informix-list mailing list archive (1991-1998)

In article <90qs5j$mgb$1@news.xmission.com>, "Obnoxio The Clown" <obnoxio@hotmail.com> wrote: > > From: Radu Dumitriu <radu@goldenclick.com> > > > >Don't be too rough on him@edu, he's learning (otherwise he wouldn't be > >asking > >that question ...). > > A good place to start learning is RTFM. Then ask questions. Seems to be silly season ATM re. Reading TFM. > > >Murray Wood wrote: > > > > > ORDER BY 1, 2, 3 > > > The SQL Syntax manual! > > > > > > -----Original Message----- > > > From: owner-informix-list@iiug.iiug.org > > > [mailto:owner-informix-list@iiug.iiug.org]On Behalf Of Richard E. > > > Hassler > > > Sent: Friday, December 08, 2000 10:49 AM > > > To: informix-list@iiug.org > > > Subject: table output order > > > > > > I have the latest version of SE (7.?) running on an HP-UX version 10.2. > > > > > > I set up a table of 3 fields one of which is a sequencial number from > > > 1-700. The sequential column is indexed. The data is loaded into the > > > table in ascending order, i.e. 1 2 3 . . . > > > > > > When I do a 'select * from tablename' in SQL or do an escape in the > > > sequential field in a PERFORM screen the rows are displayed in reverse > > > order by sequential number, i.e. 700 699 698 . . . I would like them to > > > list in ascending order, i.e. 1 2 3 . . . Is there any way to do this? > ><< radu.vcf >> > > ________________________________________________________________________ _____________ > Get more from the Web. FREE MSN Explorer download : http://explorer.msn.com > > Sent via Deja.com http://www.deja.com/ Before you buy.

↪ replying to Obnoxio The Clown
Richard E. Hassler — — source: Informix-list mailing list archive (1991-1998)

In article <90qs5j$mgb$1@news.xmission.com>, "Obnoxio The Clown" <obnoxio@hotmail.com> wrote: > From: Radu Dumitriu <radu@goldenclick.com> > > > >Don't be too rough on him@edu, he's learning (otherwise he wouldn't be > >asking > >that question ...). > > A good place to start learning is RTFM. Then ask questions. Thanks, you guys are the best. > > >Murray Wood wrote: > > > > > ORDER BY 1, 2, 3 > > > The SQL Syntax manual! > > > > > > -----Original Message----- > > > From: owner-informix-list@iiug.iiug.org > > > [mailto:owner-informix-list@iiug.iiug.org]On Behalf Of Richard E. > > > Hassler > > > Sent: Friday, December 08, 2000 10:49 AM > > > To: informix-list@iiug.org > > > Subject: table output order > > > > > > I have the latest version of SE (7.?) running on an HP-UX version > > > 10.2. > > > > > > I set up a table of 3 fields one of which is a sequencial number from > > > 1-700. The sequential column is indexed. The data is loaded into > > > the > > > table in ascending order, i.e. 1 2 3 . . . > > > > > > When I do a 'select * from tablename' in SQL or do an escape in the > > > sequential field in a PERFORM screen the rows are displayed in > > > reverse > > > order by sequential number, i.e. 700 699 698 . . . I would like them > > > to > > > list in ascending order, i.e. 1 2 3 . . . Is there any way to do > > > this? > ><< radu.vcf >> > > __________________________________________________________________________ > ___________ > Get more from the Web. FREE MSN Explorer download : > http://explorer.msn.com

↪ replying to Obnoxio The Clown
Ronald Cole — — source: Informix-list mailing list archive (1991-1998)

"Obnoxio The Clown" <obnoxio@hotmail.com> writes: > A good place to start learning is RTFM. Then ask questions. "The FM that can be R'd is not TFM." - some zen monk who donated to Al Gore's fund -- Forte International, P.O. Box 1412, Ridgecrest, CA 93556-1412 Ronald Cole <ronald@forte-intl.com> Phone: (760) 499-9142 President, CEO Fax: (760) 499-9152 My GPG fingerprint: C3AF 4BE9 BEA6 F1C2 B084 4A88 8851 E6C8 69E3 B00B