Use <cfqueryparam> this will do the correct stuff for ya ... MySQL reserves '\'

Paul Giesenhagen
QuillDesign
417-885-1375
http://www.quilldesign.com

  ----- Original Message -----
  From: Adkins, Randy
  To: CF-Talk
  Sent: Friday, October 01, 2004 3:18 PM
  Subject: CF and MySQL

  I guess this is more MySQL related but I am using CF to
  add data to the MySQL database.

  I have the field set as a varchar field and I am trying
  to add file paths to the field such as

  update this table
  set file_path = 'c:\mypath\thisfolder\thisdirectory'

  however when it is added to the field all of the
  slashes "\" are no longer part of the data.

  I am not stripping them.

  This is on a windows platform using MySQL 4

  Thanks for your help!
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Reply via email to