Philip Arnold - ASP wrote: > >It is not the only way, and it isn't a guaranteed way unless > >you rewrite your replace statements for each RDBMS. Each RDBMS > >uses different escape characters/sequences and delimiters. > > > >Use cfqueryparam. > > This is of course impossible if you're building your SQL in a string > first and then running one TSQL query
Not being able to use cfqueryparam (or cfprocparam, which is also a typed variable) is a very good reason not to do that. Apart from that, using TSQL already confines you to using one specific RDBMS, so the exception I mentioned applies. Although I still doubt that somebody not being a full-time DBA would know all the intricacies of the escape characters/sequences and delimiters. 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
