maretus 0 #1 March 22, 2001 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 'ascendLIMIT 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 SkydiversWHERE Main LIKE '%Velocity%' ORDER BY 32 ascendLIMIT 0, 15Script Location : /usr/local/etc/httpd/cgi-bin/skydivers/db.cgiPerl Version : 5.00503Setup File : db.cfgUser ID : 5bf897704511d70c---------------------------------------- Quote Share this post Link to post Share on other sites
Craig 0 #2 March 24, 2001 Try looking at the post I left HERE and see if this helps.Craig Quote Share this post Link to post Share on other sites