Menu

#6 Error when sorting w/ multiple criteria

open
nobody
5
2002-08-16
2002-08-16
Anonymous
No

When I attempted to sort results after searching by multiple (more
than two) criteria, I got a malformed SQL SELECT statement that
would not be processed. I discovered that this was caused by
multiple occurrences of the hidden "dbb_bool" input field in the
results page. Solved by moving the statement,

$order_by_input .= '<INPUT TYPE=hidden NAME=dbb_bool
VALUE="'.$FORM{dbb_bool}.'">';

in sub search of search.cgi so that it is only executed for the first
field ($first == 1) rather than for all subsequent fields.

Discussion


Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.