Hello, I have this sproc:
CREATE PROCEDURE sp_cases_search @searchcriteria varchar(50) AS SELECT case_id, type into #search1 FROM Cases WHERE FREETEXT(*, '@searchcriteria') select c.*, t.topic from #search1 INNER JOIN cases c on c.case_id = #search1.case_id INNER JOIN case_topic ct ON c.case_id = ct.case_id INNER JOIN topics t on t.topic_id = ct.topic_id WHERE #search1.type = '1' GO and I am calling it from coldfusion: <cfstoredproc procedure="sp_cases_search" datasource="#Request.SubSite.TemplateVariables.ldf#" dbtype="OLEDB"> <cfprocparam type="in" dbvarname="searchcriteria" value="#criteria#" cfsqltype="CF_SQL_VARCHAR"> <cfprocresult name="search_cases" resultSet = "2"> </cfstoredproc> When i run this say with the word 'disability' I get nothing back however if i replace the @searchcriteria with the word 'disability' in the select statement I get the expected results. Is there something I need to do to the varible to pass it in to the function correctly? When I run it in the debugger it seems like it is just hanging on the select statement. Thanks Cynthia ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:6 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:6 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=<:emailid:>.<:userid:>.<:listid:> Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
