I'm doing a look up like this: <cfquery datasource="#DSN#" name="GetResults"> SELECT Formation, Play, BallCarrier, YardsGained, Result FROM PlaysCalled WHERE (((PlaysCalled.Formation)="#Form.Formation#") AND ((PlaysCalled.Play)="#Form.Play#") AND ((PlaysCalled.BallCarrier)="#Form.BallCarrier#")); </cfquery>
In some cases, the Ball Carrier's name has a single quote in it. In these cases, the search doesn't find them. So for instance, it finds "Bob Jones" but not "D'Quan Black." Do I use cfqueryparam to resolve this? I'm using cfqueryparam when I insert the data into the database, but when I use the line: <cfqueryparam value="#Trim(GetPlay.BallCarrier)#" cfsqltype="CF_SQL_LONGVARCHAR"> it doesn't find anything. Thanks, Jim ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345144 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm