|
AFAIK the same is true for PHP+MySQL, you need single quotes (be careful not to include extraneous spaces!)
Example:
...VALUES (" & positionbx.Text & ", " & usernamebx.Text & ", ... should be changed to
...VALUES ('" & positionbx.Text & "', '" & usernamebx.Text & "', ...
When in doubt, print the final SQL statement (e.g. using Console.WriteLine) so you can have a real look.
Luc Pattyn [Forum Guidelines] [My Articles]
The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.
|
|
|
|
|
Thanks! Got it to work. Uhh, what about deleting the current selected one, or making a list box with the contents? Perhaps deleting by ID?
|
|
|
|
|
Unless there is a serious need and reason to do otherwise, you should delete by ID.
"There's no such thing as a stupid question, only stupid people." - Mr. Garrison
|
|
|
|
|
When using ShowPopup() method in vb 2005 professional edition application , to display Arabic text Popup window , at run time we get the text displayed in incorrect characters. what can i do to solve this problem .
does the Popup Window in vb 2005 support Arabic language ?
Please help me .
modified on Thursday, June 4, 2009 10:34 AM
|
|
|
|
|
What is ShowPopup ? Is this a web question or is this is nasty VB shortcut to an actual .NET method ?
Christian Graus
Driven to the arms of OSX by Vista.
Please read this[ ^] if you don't like the answer I gave to your question.
"! i don't exactly like or do programming and it only gives me a headache." - spotted in VB forums.
|
|
|
|
|
It ain't a VB shortcut. It's got to be something on the JavaScript side.
|
|
|
|
|
I thought so, but google gave me nothing, so.....
Christian Graus
Driven to the arms of OSX by Vista.
Please read this[ ^] if you don't like the answer I gave to your question.
"! i don't exactly like or do programming and it only gives me a headache." - spotted in VB forums.
|
|
|
|
|
Maybe you should try Google again. Top of the search results list for ShowPopup it gave me this:
http://msdn.microsoft.com/en-us/library/system.windows.forms.help.showpopup.aspx[^]
which is exactly what the OP is asking about in the subject line of his post. Microsoft seem to think it's a .NET method, and I guess they should know.
Unfortunately, I can't help with the original question about Arabic characters since I've never done any RTL stuff.
|
|
|
|
|
Weird. I searched VB.NET ShowPopup and got nothing. I take solace in the fact that Dave had never heard of it either.
Christian Graus
Driven to the arms of OSX by Vista.
Please read this[ ^] if you don't like the answer I gave to your question.
"! i don't exactly like or do programming and it only gives me a headache." - spotted in VB forums.
|
|
|
|
|
No, I haven't. I don't even use the Help class. And from the OP's description, it didn't look like he was either. It looked more like a description of a problem with showing a normal window.
|
|
|
|
|
I have this program below when i click this the text in textbox1 should replace the value of x
as a command line variable but this isn't happening.
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
Dim x As String
x = TextBox1.Text
Shell("un.cmd x", AppWinStyle.NormalFocus, False)
End Sub
Any help would be great.
please respond asap.
thanks.
|
|
|
|
|
Try this:
Shell("un.cmd " & x, AppWinStyle.NormalFocus, False)
|
|
|
|
|
I says "file not found" while debugging, and crashes.
|
|
|
|
|
Sorry,
I first wrote this:
Shell("un.cmd" & x, AppWinStyle.NormalFocus, False)
Then edited my comment to this (with a space after un.cmd ):
Shell("un.cmd " & x, AppWinStyle.NormalFocus, False)
Try the one with the space.
You were putting your variable in your code as a string, not the variable name.
|
|
|
|
|
Thanks that worked but when my variable i.e text in the textbox1 contains spaces only first word is shown.
this is what i want to actually do.
@echo off
7zr a -mx9 "%1".7z "%1".ecm
pause
this is a batch program to create archives of any file give as first argument to it.
now what i want to do is that i want do the same using vb so that i don't need an extra batch program.
Can you please tell me how to doing by replacing the varibles %1 as variable x
something like this
dim x as string
x = textbox1.text
shell("7zr a -mx9 "x".7z "x".ecm")
thanks.
|
|
|
|
|
If your file name has spaces in it, I believe you have to surround the filename with double quotes. You'd want something like this:
Shell("7zr a -mx9 " & """" & x & ".7z" & """" & " " & """" & x & ".ecm")
|
|
|
|
|
Thank you very much it worked.
|
|
|
|
|
can you please explain how it was done.
Thanks.
|
|
|
|
|
Shell("7zr a -mx9 " & """" & x & ".7z" & """" & " " & """" & x & ".ecm")
"7zr a -mx9 " is the call to your program, the space after the 9 is to get ready for the first parm.
& """" concats a double quote
& x concats your variable file name
& ".7z" concats the extension
& """" concats a double quote
& " " concats a space to get ready for the next parm
& """" concats a double quote
& x concats your variable file name
& ".ecm" concats the extension
So...looks like I forgot to put the last quote in... you need one more of these:
& """" for the last double quote.
When your x variable is set to My File ...this would be the output:
7zr a -mx9 "My File.7z" "My File.ecm"
|
|
|
|
|
thanks Now i Figured it out.
|
|
|
|
|
The Shell statement is deprectated and is only there for backward compatibility of upgraded VB6 code. Use the Process class instead.
|
|
|
|
|
Do you mean diagnostics.process.start ?
But that doesn't wait for process to finish.
|
|
|
|
|
Striker.dbz wrote: that doesn't wait for process to finish
That must have been an excellent reason for coming up with an entire class; lots of useful methods are available.
Luc Pattyn [Forum Guidelines] [My Articles]
The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.
|
|
|
|
|
Did you bother to read the documentation on the Process class or even look through the Intellisense list after you typed Process. ?? Maybe that WaitForExit method might be useful for something...
|
|
|
|
|
Can you please elaborate i am very new to programming?
Thanks.
modified on Thursday, June 4, 2009 3:03 AM
|
|
|
|