Forums: Dropzone.com: Error and Bug Reports:
Search engine

 


maretus  (D License)

Mar 22, 2001, 3:34 AM
Post #1 of 2 (810 views)
Shortcut
Search engine Quote | Reply

I tried to search the skydiver database to find people who jump small Velocities, so I made a search with attributes: Main = Velocity, Sort Order = Ascending, Sort = Mainsize and received following error:
------------------------------
CGI ERROR
==========================================
Error Message : Unable to query database. Reason: parse error near 'ascend
LIMIT 0, 15
' at line 5. Query:
SELECT ID,FirstName,LastName,NickName,Region,Country,Address,City,State,ZIPcode,Phone,Fax,Email,ICQ,Website,URL,Dropzone,License,Number,Jumps,SL,AFF,IAD,Tandem,Pro,Org,Back,Chest,Seat,Lap,Rig,Main,Mainsize,Res,Ressize,AAD,Rigother,Mainother,Resother,AADother,Firstchoice,Secondchoice,Photo,Date,Userid,Modified,Category FROM Skydivers
WHERE
Main LIKE '%Velocity%'
ORDER BY 32 ascend
LIMIT 0, 15

Script Location : /usr/local/etc/httpd/cgi-bin/skydivers/db.cgi
Perl Version : 5.00503
Setup File : db.cfg
User ID : 5bf897704511d70c
----------------------------------------



Craig

Mar 23, 2001, 5:54 PM
Post #2 of 2 (796 views)
Shortcut
Re: Search engine [In reply to] Quote | Reply

Try looking at the post I left <A HREF="http://www.dropzone.com/cgi-bin/forums/showflat.pl?Cat=&Board=bug_reports&Number=4320&page=0&view=collapsed&sb=5" target="_new">HERE</A> and see if this helps.

Craig




Forums : Dropzone.com : Error and Bug Reports

 


Search for (options)