[jilly]

when I try to search for a game, either by using the search box, or by clicking a letter, I get an error msg. I am using vb3.7 RC2
from clicking an alphabet letter:
mySQL query error: select g.*, c.password from games_list as g
left join games_cats as c on (g.gcat = c.c_id)
where g.active = 1 and trim(password)='' and gtitle like 'M%' and gcat IN (1,)
order by added ASC

mySQL error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
order by added ASC' at line 3
mySQL error code:
Date: Thursday 17th of April 2008 05:42:30 PM

and here is when I try to search through the search box
mySQL query error: select g.*, c.password from games_list as g
left join games_cats as c on (g.gcat = c.c_id)
where g.active = 1 and trim(password)='' and gtitle like '%marble%' and gcat IN (1,)
order by added ASC

mySQL error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
order by added ASC' at line 3
mySQL error code:
Date: Thursday 17th of April 2008 05:46:13 PM