What is wrong here

8 posts Page 1 of 1
Contributors
User avatar
Kobra1984
Member
Member
Posts: 38
Joined: Mon Sep 05, 2011 1:01 pm

What is wrong here
Kobra1984
Code: Select all
Private Sub searchbox_TextChanged(sender As System.Object, e As System.EventArgs) Handles searchbox.TextChanged
        If searchby.Text = "Username" Then
            searchstr = "SELECT accountinfo.fname, accountinfo.lname, accounts.EMail " & _
                "FROM accountinfo WHERE Username like '%" & searchbox.Text & "%'"
        ElseIf searchby.Text = "Email" Then
            searchstr = "SELECT * FROM accounts WHERE EMail like '%" & searchbox.Text & "%'"
        ElseIf searchby.Text = "Last Name" Then
            searchstr = "SELECT * FROM accountinfo WHERE lname like '%" & searchbox.Text & "%'"
        ElseIf searchby.Text = "Phone" Then
            searchstr = "SELECT * FROM accountinfo WHERE phone like '%" & searchbox.Text & "%'"
        End If
        Dim fname, lname, EMail
        CONNECTION.Open()
        cmd = New MySqlCommand(searchstr, CONNECTION)
        dr = cmd.ExecuteReader()
        ListView1.Items.Clear()

        Do While dr.Read()

            fname = (dr.Item("fname").ToString())
            lname = (dr.Item("lname").ToString())
            EMail = (dr.Item("EMail").ToString())


            Dim lv As ListViewItem = ListView1.Items.Add(fname)
            lv.SubItems.Add(lname)
            lv.SubItems.Add(EMail)
        Loop
        dr.Close()
        CONNECTION.Close()
        cmd.Dispose()
    End Sub
Getting this error
mysql tables are accounts and accountinfo

accounts as the EMail in it
and accountinfo as fname and lname
Last edited by Kobra1984 on Wed Dec 14, 2011 11:07 pm, edited 2 times in total.
User avatar
muttley1968
Hardcore Programmer
Hardcore Programmer
Posts: 622
Joined: Thu Jun 17, 2010 11:54 pm

Re: What is wrong here
muttley1968
please give more info hows this being used n whats it for
User avatar
Kobra1984
Member
Member
Posts: 38
Joined: Mon Sep 05, 2011 1:01 pm

Re: What is wrong here
Kobra1984
updated
User avatar
muttley1968
Hardcore Programmer
Hardcore Programmer
Posts: 622
Joined: Thu Jun 17, 2010 11:54 pm

Re: What is wrong here
muttley1968
ohh well there should be a data source somewhere i would think and whats the error there is no error in that just code
User avatar
Kobra1984
Member
Member
Posts: 38
Joined: Mon Sep 05, 2011 1:01 pm

Re: What is wrong here
Kobra1984
error is
Unknown column 'accounts.EMail' in 'field list'
User avatar
muttley1968
Hardcore Programmer
Hardcore Programmer
Posts: 622
Joined: Thu Jun 17, 2010 11:54 pm

Re: What is wrong here
muttley1968
Check capitalization then if i were you or change field name


PS Plz look and comment on my program
viewtopic.php?f=38&p=59866#p59866
User avatar
Kobra1984
Member
Member
Posts: 38
Joined: Mon Sep 05, 2011 1:01 pm

Re: What is wrong here
Kobra1984
no thanks
User avatar
mandai
Coding God
Coding God
Posts: 2585
Joined: Mon Apr 26, 2010 6:51 pm

Re: What is wrong here
mandai
Do you have a column named EMail in the accounts table?

Does the error occur when searching in a specific column?

The error message does not show enough information.
8 posts Page 1 of 1
Return to “Help & Support”