|
Hi all,
In Visual Basic 6 I'm trying to insert data into a db that is retrieved from a file. When I execute the insert statement ("Connection.Execute") I receive some errors because there are records that have apostrophes. How can I escape this character?
Thanks in advance,
Marc Soleda
... she said you are the perfect stranger she said baby let's keep it like this... Dire Straits
|
|
|
|
|
Let me gues, you''re concatenting SQL statements together like this:
Dim sql As String
sql = "INSERT INTO table field1, field2, field3 VALUES ('" & textbox.text & "', '" & textbox2.text & "' " & textbox3.text & "')"
This is completely the wrong way to do it and you'll run into escaping problems, like you've discovered, and you also open yourself up to SQL Injection attacks.
Use parameterized queries and you won't have this problem at all.
See this[^] article by Collin Angus Mackay for more information.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Hi Dave, now after reading the article I'm more concerned about the escaping the apostrophes and I've parameterised the query.
Thanks,
Marc Soleda
... she said you are the perfect stranger she said baby let's keep it like this... Dire Straits
|
|
|
|
|
Yeah, the Parameter class takes care of escaping any characters that need it itself, as well as checking for certain types of injection attacks.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
You escape apostrophes with apostrophes.
For example, this string...
"Bob's Data"
...becomes this...
"Bob''s Data"
|
|
|
|
|
Ok, but is there a function to do it or do I have parse the string to look for the apostrophe?
... she said you are the perfect stranger she said baby let's keep it like this... Dire Straits
|
|
|
|
|
There's no function to convert it for you. But it's really easy to do it yourself. Try using this...
Public Function StringToSql(sBuf As String) As String
StringToSql = Replace(sBuf, "'", "''")
End Function
|
|
|
|
|
Let me reiterate that unless you take Dave's advice, you'll solve the problem today, but have more grief in the future, because you're choosing to do things the wrong way.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
Thanks Chris, your persistence have convinced me to take the rigth way.
... she said you are the perfect stranger she said baby let's keep it like this... Dire Straits
|
|
|
|
|
thnx 4 da help actually i required that when i add data into a dataset it is automatically sorted and then saved into a dataset during run time (if i can get the code for help it'l b a gr8 help)
FRAZ SOOMRO
|
|
|
|
|
i want a sample tutorial (or code) in vb.net that demonstrate on parallel port proghramming for doing simple program?????
|
|
|
|
|
That's rather vauge. What are you doing with the parallel port?
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
i want to connect a small motor (simple) to the parallel port and control it by using a vb.net program??
i want a sample program and howto connect it??![Rose | [Rose]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/rose.gif)
|
|
|
|
|
Well, since this is a very specific, and relatively rare, project, you're probably going to have to do your own research. The "perfect" example, with everything you want, probably doesn't exist in one place.
I suggest Googling for "parallel port motor" for any information. You'll probably have to piece together your project from various sources.
You can start with this[^] one, right here on Code Project.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
ok
i want a very simple code how to control parallel port so i can on/off the led only??
VB.NET
|
|
|
|
|
From a motor to an LED... There's nothing simple about it, no matter what you do. The parallel port hardware is completely abstracted from your code. You MUST have a Ring 0 .DLL to get to the hardware FOR your code.
You can find an example at http://www.logix4u.net/[^]. Be be warned, you STILL have to do your own research to get any example to work. Trial and error is the best teacher.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
For the hardware connection to the parallel ports and some sample code in C, see this website:
http://www.phanderson.com
About half way down the page are some books/workbooks he wrote about connecting hardware motors and such to the parallel port and programming them with the PC. The code won't apply, but he gives some great circuits and theory. I have both books and they are an excellent intro to controlling stuff with the parallel port.
"Use of a PC Printer Port for Control and Data Acquisition - Volume 1"
"Use of a PC Printer Port for Control and Data Acquisition - Volume 2"
|
|
|
|
|
Hi Guys!! How can i retrieve my own machine Ip Address. Plz help me fast. i need it right now!!
Thanx. Bye!
Devraj Raut!!!
|
|
|
|
|
|
just go into the command prop and type ipconfig press enter and you will see your own ipaddress.. how that helps..
Nab
|
|
|
|
|
command prompt that is..type "ipconfig" without quotes,, press enter and thats it
Nab
|
|
|
|
|
|
Devraj Raut wrote: Plz help me fast. i need it right now!!
And people in Hell need ice-water.
This is an all-volunteer effort. Making time sensitive demands like this is just plain rude. You'd get faster results if you Googled it yourself, something like "VB.NET get host ip address".
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
how can we sort a dataset directly without using the dataview in VB.NET
i'l appreciate if the code is also supplied
FRAZ SOOMRO
|
|
|
|
|
why dont u retrieve sorted results from database only
using query like these:
for descending order:
select * from <tablename> order by <columnname> desc
for ascending order
select * from <tablename> order by <columnname> desc
abhinav
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
