Couple things here. First off, you didn't say what your error is, but i know it's a parsing error. A single # by itself will throw off CF because it's looking for a #variable#. You can escape it by making it a double ##.
Second, this shouldn't even happen. Having a special character in a table or column name, other than the underscore _ is pretty bad design for a database. Name it order_number or order_no, or orderNumber, etc. No special chars. -nathan strutz Robert Orlini wrote: > 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:183522 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
