The pound sign in CF is reserved and you would need to escape it with another pound sign - if your column is called Order# then you should write Order## instead.
HTH, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server PrismAV - Virus scanning for ColdFusion applications >>> Find out how iMS Stacks up to the competition: >>> http://www.coolfusion.com/imssecomparison.cfm --- On Friday, November 05, 2004 1:52 PM, Robert Orlini scribed: --- > > I have this query: > > <CFQUERY datasource="wilsoncart" name="compare"> > Select from data > Where len(order#) = '5' > order by order# > </CFQUERY> > > I get an error on the ( > > It works in SQL Query Analyzer though. > > What can I use to get the length of that string which is numeric? > > Thx > > Robert O. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183523 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
