Search

<cfquery name="search" datasource="userlogin">
Select
<cfif isDefined("form.user_level")>battle.*</cfif>
<cfif isDefined("form.money") AND isDefined("form.user_level")>, </cfif>
<cfif isDefined("form.money")>finance.* </cfif>
FROM
<cfif isDefined("form.user_level")>battle</cfif>
<cfif isDefined("form.money") AND isDefined("form.user_level")>,</cfif>
<cfif isDefined("form.money")>finance</cfif>
WHERE
<cfif isDefined("form.user_level")>
battle.user_level >= #form.llevel# AND battle.user_Level <= #Form.mlevel#</cfif>

<cfif isDefined("form.money") AND isDefined("form.user_level")>AND</cfif>

<cfif isDefined("form.money")>finance.pocket <= #form.lpocket# AND finance.pocket >= #Form.mpocket#</cfif>
</cfquery>

<cfquery name="getname" datasource="userlogin">
SELECT * from registration_info
WHERE user_id IN #search.User_id#
</cfquery>
<cfoutput query="getname">
#user_name#
</cfoutput>


and am getting this error

Error Executing Database Query.
[MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] In operator without () in query expression 'user_id IN 1'.

Just as it says.
This:
WHERE user_id IN #search.User_id#

Needs to be this:
WHERE user_id IN (#search.User_id#)