You've got to double-up your double-quotes, or use single quotes to surround
them...

replace(qStockItems.Symbol,"""","","ALL")
replace(qStockItems.Symbol,'"','','ALL')

both should work.

-nathan strutz

ps, you don't need #'s in your variables when they're inside cf functions or
inside <cfset> and <cfif> tags.

  -----Original Message-----
  From: Eric Creese [mailto:[EMAIL PROTECTED]
  Sent: Thursday, January 29, 2004 11:32 AM
  To: CF-Talk
  Subject: Replacing Characters

  I need to strip "(double quote) out of a string of characters. I tried the
following but it bombed. Can anyone steer me in the right direction?

  <cfset newsym=replace(#qStockItems.Symbol#,""","","ALL")>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to