USE <CFQUERYPARAM> Pascal Peters Macromedia Certified Instructor Certified ColdFusion (5.0) Advanced Developer Certified Web Developer LR Technologies, Belgium Tel +32 2 639 68 70 Fax +32 2 639 68 99 Email [EMAIL PROTECTED] Web www.lrt.be
>From: "Kevin Langevin" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: CF-Talk <[EMAIL PROTECTED]> >Subject: Inserting single quotes into SQL Server... >Date: Mon, 12 Nov 2001 16:33:21 -0500 > >Hi all- > >I've beaten this problem before, but even looking at code that seems to >work >fine from previous projects, I can't see what I'm doing wrong. > >I want to insert a string into a record in a SQL Server 2000 DB. The string >contains a customer's name. If the customer's name contains an apostrophe, >the insert dies. It works fine in another app, but I can't see what I'm >doing differently. I'm not escaping anything or doing anything special, >from what I can see. > >Anyone have any standard ways of inserting strings into SQL which may or >may >not contain single quotes? > > >Kevin Langevin >Web Guy In Charge >UsWebGuys >954-327-5780 > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
