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:
?db=offers&uid=default&view_records=1&ID=*&sb=ID&so=descend

I also try:
?db=offers&uid=default&view_records=1&ID=*&sb=0&so=descend

and this is the error:
In Reply To:
CGI ERROR
==========================================
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
WHERE
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.


__________________________
SantanaBlank
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