jason kufner wrote: > I'm at zero hour with a project and I just discovered an "issue" with > SQL (the language, not the database):
Considering that SQL has been around for almost as long as I live I find it hard to believe it is an issue with the language. More likely it is a user error. > Is there some way I can escape the text? Use cfqueryparam. > I know the underling coded works -I looped over 55 records just fine > until I hit this one with the parentheses. That sounds like: I know my function for multiplication works, I multiplicated 55 numbers with 0 correctly until I tried to multiply with something else. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
