title: Backslashes disapearing after my vb.net query to Mysql
body: <p>I'm having some problems, when I do my query from my vb.net program to my mysql DB the data is sent, but its missing some things, let me explain.</p>
  
  <p>My query is pretty simple I'm sending a file path to my DB so that after I can have a php website get the data and make a link with the data from my DB, but when I send my data the results look like this...</p>
  
  <pre><code>    \server_pathappsInst_pcLicences_ProceduresDivers    estCheck_list.doc
  </code></pre>
  
  <p>which should look like</p>
  
  <pre><code>    \\server_path\apps\Inst_pc\Licences_Procedures\Divers\test\Check_list.doc
  </code></pre>
  
  <p>I don't know if its my code that's not good or my configurations on my mysql server please help...</p>
  
  <p>Here's my code</p>
  
  <pre><code>    'Construct the sql command string 
          cmdString = "INSERT into procedures(Nom, Lien_Nom, Commentaires) VALUES('" &amp; filenameOnly_no_space_no_accent &amp; "', '" &amp; str_Lien_Nom_Procedure &amp; "', '" &amp; str_commentaires_Procedure &amp; "')"
  
          ' Create a mysql command 
          Dim cmd As New MySql.Data.MySqlClient.MySqlCommand(cmdString, conn)
  
          Try
              conn.Open()
              cmd.ExecuteNonQuery()
              conn.Close()
          Catch ex As MySqlException
              MsgBox("Error uppdating invoice: " &amp; ex.Message)
          Finally
              conn.Dispose()
          End Try
  </code></pre>
  
  <hr>
  
  <p>Sorry I got a call and could continue my comment so here's the rest :X</p>
  
  <p>Well I guess that would work, but my program never uses the same path since in uploading a file on a server, so this time the document I wanted to upload was this path </p>
  
  <pre><code>      \\Fsque01.sguc.ad\apps\Inst_pc\Licences_Procedures\Divers\test\Check_list.doc 
  </code></pre>
  
  <p>but next time its going to be something else so I can't hard code the paths, I was looking more of a SQL query which that I might not know, since I already thought about searching my string and if it finds a backslash it adds another one, but I feel its not a good way to script the whole thing...</p>
  
  <p>Anyway thanks a lot for your help</p>