Gossamer Forum
Home : Products : DBMan SQL : Discussion :

How to sort Keydb in sql?

Quote Reply
How to sort Keydb in sql?
It just doesn;t work like the way the flat text version does.

This is what I typed:

I also try:

and this is the error:
In Reply To:
Error Message : Unable to query database. Reason: parse error near 'descend
LIMIT 0, 10
' at line 5. Query:
SELECT ID,create_time,HScode,Name,Email,Company,Address,City,State,Zip,Country,Phone,Fax,Homepage,Subject,Details,Offers,userid FROM Opportunity
ID >= 0
ORDER BY ID descend
LIMIT 0, 10

Script Location : /usr/home33/anteroma/public_html/cgi-bin/db/db.cgi
Perl Version : 5.00503
Setup File : offers.cfg
User ID : default
Anyone experience this?

The database is supposed to be displaying the latest data entry instead of the oldest.

Thanks, any information would be very appreciate it.

Subject Author Views Date
Thread How to sort Keydb in sql? santana 1775 Nov 12, 2000, 10:10 PM
Thread Re: How to sort Keydb in sql?
Bearwithme 1702 Nov 12, 2000, 11:04 PM
Post Cool
santana 1698 Nov 13, 2000, 12:06 AM