Gossamer Forum
(Advanced Search)
for
Home : Products : DBMan SQL : Discussion :

How to sort Keydb in sql?

Nov 12, 2000, 10:10 PM
santana
User (86 posts)
Nov 12, 2000, 10:10 PM
Views: 2377
Shortcut
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 2377 Nov 12, 2000, 10:10 PM
Thread Re: How to sort Keydb in sql? 		Bearwithme 2284 Nov 12, 2000, 11:04 PM
Post Cool 		santana 2280 Nov 13, 2000, 12:06 AM