ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.
One of a set of tools we're offering as a way to say thank you for being a part of the community.
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?
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.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Join & Write a Comment Already a member? Login.
Well, all of us have seen the multiple EXCEL.EXE's in task manager that won't die even if you call the .close, .dispose methods. Try this method to kill any excels in memory. You can copy the kill function to create a check function and replace the …
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…
Watch the video of Kernel Migrator for SharePoint, which demonstrate the process easily of migration from SharePoint to SharePoint, OneDrive for Business & Google Drive servers, Public Folder to SharePoint, File Server to SharePoint. The tool has va…
Suggested Courses
Course of the Month7 days, 3 hours left to enroll
590 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.