I'm trying to show links within a category that have a detailed page via search.cgi.
I'm thinking in something like this:
/search.cgi?CategoryID=<category_id>&isDetail=1&query=something
What should I put in the "query" ? I tried with a "*" or "ALL" and I get the following (for category 9):
Search (14874): Fatal: query: Can't execute: SELECT count(*) FROM Links WHERE ID in () and (( CategoryID = "9")) (You have an error in your SQL syntax near ') and (( CategoryID = "9"))' at line 1) at admin/Links/DBSQL.pm line 1492
Any guidance?
I'm thinking in something like this:
/search.cgi?CategoryID=<category_id>&isDetail=1&query=something
What should I put in the "query" ? I tried with a "*" or "ALL" and I get the following (for category 9):
Search (14874): Fatal: query: Can't execute: SELECT count(*) FROM Links WHERE ID in () and (( CategoryID = "9")) (You have an error in your SQL syntax near ') and (( CategoryID = "9"))' at line 1) at admin/Links/DBSQL.pm line 1492
Any guidance?