ravenfrost
Last Activity: Feb 22 '08, 02:47 PM
Joined: Apr 16 '07
Location:
-
Why would you use inner join if we're only working with one table here/ Maybe there's another use to INNER JOIN that I don't know about? Thanks. -
This actually wasn't exactly what I was looking for. The result from this would be sally, chuck & mark. The results show who has a dog OR a lizard. But, I'm really looking to see who has a dog AND a lizard, thus only returning sally Thoughts?Leave a comment:
-
thanks a lot it worked good!Leave a comment:
-
Need help with SQL query
Hello, if you look at the image below you can see an example table. Lets say I want to know which owners own a lizard and a dog. Lets call the table test. Select Owner from test Where Pet... I don't how the rest would go. I'm in a stump here. Any suggestions would help. Thanks.
... -
Fore some reason the trim isn't removing the carriage return. The first variable in teh array doesn't ahve it, but all other variables have a carraige return before them.
...Code:Dim strComputer, arrComputers() As String arrComputers = txtEndpoints.Text.Split(Environment.NewLine) Dim i As Integer = 0 For i = LBound(arrComputers) To UBound(arrComputers) strComputer = Trim(arrComputers(i))Leave a comment:
-
Only problem I'm having is that it's keeping the carriage returns within the string. Any way to get rid of those?Leave a comment:
-
Thanks I'll give it a whirl!Leave a comment:
-
Read TextBox line by line
Hello,
I have a text box that I am entering items into line by line. I want to read in the data one line at a time into a variable through a loop. I know the textbox does not have a readline attribute, but is there any way I can read a textbox line by line, or should I be using a different control to do so? I'm using VB.Net. Thanks.
Sean Merron -
sql SELECT query using vb.net
Hello,
I'm trying to query a sql table to see if a value already exists.
...Code:strMAC = "11:22:33:44:55:66" Call MsgBox(QueryDB("SELECT * FROM main WHERE MAC = '" & strMAC & "'", conn)) Function QueryDB(ByVal sql As String, ByVal conn As SqlConnection) QueryDB = 0 Dim cmd As SqlCommand = Nothing Dim dr As SqlDataReader = Nothing
No activity results to display
Leave a comment: