What is the correct CF syntax for a contains query. I have no problem using the "like" statement, but I cannot get "contains" to work. I am building a search to allow the user to enter a partial.
Here is what I tried: <cfif len(form.description) gt 0> and description contains (description,'%#Form.description#%') </cfif> Error: Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'purchased = no and description contains (description,'%g%')'. The error occurred in C:\CFusionMX7\wwwroot\cfdocs\donor_search_action.cfm: line 37 35 : <cfif len(form.description) gt 0> 36 : and description contains (description,'%#Form.description#%') 37 : </cfif> 38 : 39 : order by donor -------------------------------------------------------------------------------- SQL SELECT * FROM HamCom05 where purchased = no and description contains (description,'%g%') order by donor Thanks, Bill ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:2750 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
