Python

Need wxpython, sqlite3, python help.

Please support our Python advertiser: Programming Forums - DaniWeb Sister Site

•

Join Date: Oct 2009

Posts: 10

Reputation: Megabyte89 is an unknown quantity at this point

Solved Threads: 0

Megabyte89 Megabyte89 is offline

Offline

Newbie Poster

Need wxpython, sqlite3, python help.

Oct 26th, 2009

OK I have a search script that suppose to search for information in my database. The problem I having is that I want the user to be able to enter a last name to search.

The only part that is giving me problems is this part, I'm stuck on this part.

 Help with Code Tags 
 Python Syntax (Toggle Plain Text) 
db.execute("SElECT fname, lname, phone, address, email from contacts WHERE lname = (results)")
db.execute("SElECT fname, lname, phone, address, email from contacts WHERE lname = (results)")

Traceback (most recent call last):
File "C:/Users/Panic/Desktop/Contacts/search.py", line 46, in OnStart
db.execute("SElECT fname, lname, phone, address, email from contacts WHERE lname = (results)")
sqlite3.OperationalError: no such column: results

Here is the rest of the code that I am not having problems with.

 Help with Code Tags 
 Python Syntax (Toggle Plain Text) 
#Importing modules
 
import os
import wx
import sqlite3
import Database
 
#Creating a class
 
class search(wx.Frame):
    def __init__(self):
        wx.Frame.__init__(self, None, -1, 'Search', size = (400,100))
        panel = wx.Panel(self, -1)
 
#Centering the frame
 
        self.Centre()
 
#Creating input fields
 
        searchLabel = wx.StaticText(panel, -1, "          Search:")
        self.search = wx.TextCtrl(panel, -1, "Enter last name")
        searchLabel.SetFont(wx.Font(10, wx.SWISS, wx.NORMAL, wx.NORMAL))
        self.search.SetInsertionPoint(0)
 
#Creating sizers
 
        sizer = wx.FlexGridSizer(cols = 8, hgap = 8, vgap = 8)
        sizer.AddMany([searchLabel, self.search])
        panel.SetSizer(sizer)
 
#Creating buttons and events
 
        start = wx.Button(panel, label = 'Start', pos = (225, 0), size = (80, 25))
        start.Bind(wx.EVT_BUTTON, self.OnStart, start)
 
        results = self.search.GetValue()
 
    def OnStart(self, event):
        dlg = wx.MessageBox("Start search?", 'Message', wx.YES_NO | wx.ICON_QUESTION)
 
        if (dlg == wx.YES):
 
            file = open (r'Database.py', 'r')
            exec(file.read())
            db.execute("SElECT fname, lname, phone, address, email from contacts WHERE lname = (results)")
 
 
        else:
            self.Destroy()
 
 
if __name__ == '__main__':
    myApp = wx.App()
    frame = search()
    frame.Show()
    myApp.MainLoop()
#Importing modules

import os
import wx
import sqlite3
import Database

#Creating a class

class search(wx.Frame):
    def __init__(self):
        wx.Frame.__init__(self, None, -1, 'Search', size = (400,100))
        panel = wx.Panel(self, -1)

#Centering the frame

        self.Centre()

#Creating input fields

        searchLabel = wx.StaticText(panel, -1, "          Search:")
        self.search = wx.TextCtrl(panel, -1, "Enter last name")
        searchLabel.SetFont(wx.Font(10, wx.SWISS, wx.NORMAL, wx.NORMAL))
        self.search.SetInsertionPoint(0)

#Creating sizers

        sizer = wx.FlexGridSizer(cols = 8, hgap = 8, vgap = 8)
        sizer.AddMany([searchLabel, self.search])
        panel.SetSizer(sizer)

#Creating buttons and events

        start = wx.Button(panel, label = 'Start', pos = (225, 0), size = (80, 25))
        start.Bind(wx.EVT_BUTTON, self.OnStart, start)

        results = self.search.GetValue()

    def OnStart(self, event):
        dlg = wx.MessageBox("Start search?", 'Message', wx.YES_NO | wx.ICON_QUESTION)

        if (dlg == wx.YES):

            file = open (r'Database.py', 'r')
            exec(file.read())
            db.execute("SElECT fname, lname, phone, address, email from contacts WHERE lname = (results)")
            

        else:
            self.Destroy()


if __name__ == '__main__':
    myApp = wx.App()
    frame = search()
    frame.Show()
    myApp.MainLoop()

Thanks to anyone who can lend help with this.

•

Join Date: Jul 2008

Posts: 1,070

Reputation: jlm699 is a jewel in the rough

Solved Threads: 268

jlm699

Offline

Knows where his Towel is

Oct 26th, 2009

•

Originally Posted by Megabyte89

Thanks to anyone who can lend help with this.

You've simply forgotten to put the value of results into the string. Instead you mistakenly typed the name results. Here's how you should use string formatting to add the value:

 Help with Code Tags 
 python Syntax (Toggle Plain Text) 
db.execute("SElECT fname, lname, phone, address, email from contacts WHERE lname = (%s)" % results)
db.execute("SElECT fname, lname, phone, address, email from contacts WHERE lname = (%s)" % results)

HTH

1. Use Code Tags.
2. Homework? Show Effort.
3. Keep discussions on the forum: no PMs

•

Join Date: Jul 2009

Posts: 4

Reputation: strider1066 is an unknown quantity at this point

Solved Threads: 1

strider1066 strider1066 is offline

Offline

Newbie Poster

Oct 26th, 2009

I believe there may be two problems. Results appears to be undefined within the function. Either pass in results as an argument or use self.results. (The original definition of results should also be made in the method above.

Secondly, the syntax of the pysqlite statement appears to be incorrect try..

 Help with Code Tags 
 Python Syntax (Toggle Plain Text) 
            db.execute("SElECT fname, lname, phone, address, email from contacts WHERE lname = %s" % self.results)
            db.execute("SElECT fname, lname, phone, address, email from contacts WHERE lname = %s" % self.results)

Thread Tools	Search this Thread
Show Printable Version Email this Page

DaniWeb Message

Cancel Changes