Generally speaking a cfqueryparam value should never be surrounded by quotes -- the functionality of separating the content from the sql syntax is provided by the bind parameter, so if the server needs quotes to create the bind variable they're used somewhere else (outside the sql syntax)... You might be able to make the non-inflectional work with the contains statement by removing the single quotes around it. You'll never be able to use <cfqueryparam> as a portion of an SQL literal string, however, as the bind parameter must be the entire variable, beginning to end.
> Does anyone know if it is possible to use cfqueryparam to > bind a string to an MS SQL full-text search column? > Here's what I'm trying: > <cfquery name="VARIABLES.qrySomeQuery" > datasource="#REQUEST.DataSource#"> > SELECT * > FROM SomeTable > WHERE CONTAINS(SomeColumn_varchar, 'FORMSOF > (INFLECTIONAL, " <cfqueryparam > cfsqltype="cf_sql_varchar" > value="#VARIABLES.SomeString#"> ")') > </cfquery> > I get back the error: > [Macromedia][SQLServer JDBC Driver]Invalid parameter > binding(s). > The following non-inflectional form fails with the same > error: > WHERE CONTAINS(SomeColumn_varchar, '<cfqueryparam > cfsqltype="cf_sql_varchar" > value="#VARIABLES.SomeString#">') > I've tried cf_sql_char and cf_sql_longvarchar and get the > same results. > Thank you! > -James s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://macromedia.breezecentral.com/p49777853/ http://www.sys-con.com/author/?id=4806 http://www.fusiontap.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:204342 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
