Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.
Solved
how can I write a \ to a mysql field via vb.net
Posted on 2011-03-10
I have a variable IniLoc which is populated from a datagridview, the result being "D:\FTPROOT\FRED" Thats no problem.
Later on in my code I want to write this back to my database and I use myCommand.Connection = conn
myCommand.CommandText = "INSERT INTO `incidentmon` (`Subject`, `IncidentDate`, `IncidentFolder`,`Status` ) VALUES ('" & Subject & "', '" & NewDate & "', '" & IniLoc & "\" & Subject & "', 'Processing');"
subject = Test for this example.
And sure enough it writes back to the database, however, the IniLoc field that is written back appears as
"D:FTPROOTFREDTest"
How can I get it to write back including the \'s in the right places?
Later on in my code I want to write this back to my database and I use myCommand.Connection = conn
myCommand.CommandText = "INSERT INTO `incidentmon` (`Subject`, `IncidentDate`, `IncidentFolder`,`Status` ) VALUES ('" & Subject & "', '" & NewDate & "', '" & IniLoc & "\" & Subject & "', 'Processing');"
subject = Test for this example.
And sure enough it writes back to the database, however, the IniLoc field that is written back appears as
"D:FTPROOTFREDTest"
How can I get it to write back including the \'s in the right places?
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
2-
2
5 Comments
or use parameters instead of building the SQL like this ad-hoc.
using parameters will also avoid sql injection. ...
using parameters will also avoid sql injection. ...
Thanks folks,
I get the idea os using the \\'s that not a problem, however, the string comes from somewhere else and only contains single \'s. Any ideas how I can turn my \'s in the string to \\'s in the string ?
(so it goes from D:\FTPROOT\FRED to D:\\FTPROOT\\FRED)
I get the idea os using the \\'s that not a problem, however, the string comes from somewhere else and only contains single \'s. Any ideas how I can turn my \'s in the string to \\'s in the string ?
(so it goes from D:\FTPROOT\FRED to D:\\FTPROOT\\FRED)
Thanks Again,
I've cracked it. Simple case of useing another string and replacing the \ with a \\
string2 = string1.replace("\" , "\\")
Did the job.
I've cracked it. Simple case of useing another string and replacing the \ with a \\
string2 = string1.replace("\" , "\\")
Did the job.
though this is a simple method to solve the \ problem, you will run into sql injection sooner or later:
http://www.google.lu/search?q=sql+injection&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-US:official&client=firefox-a
for your own safety, better change to SqlCommand + SqlParameter programming:
http://www.csharp-station.com/Tutorials/AdoDotNet/Lesson06.aspx
presuming you work with SQL Server database, but the concept is the same for other database systems .
http://www.google.lu/search?q=sql+injection&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-US:official&client=firefox-a
for your own safety, better change to SqlCommand + SqlParameter programming:
http://www.csharp-station.com/Tutorials/AdoDotNet/Lesson06.aspx
presuming you work with SQL Server database, but the concept is the same for other database systems .
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
XML Literals are a great way to handle XML files and the community doesn’t use it as much as it should. An XML Literal is like a String (http://msdn.microsoft.com/en-us/library/system.string.aspx) Literal, only instead of starting and ending with w…
Since .Net 2.0, Visual Basic has made it easy to create a splash screen and set it via the "Splash Screen" drop down in the Project Properties. A splash screen set in this manner is automatically created, displayed and closed by the framework itsel…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB.
To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses
Course of the Month4 days, 11 hours left to enroll
661 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.