Python Forum
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Query Syntax Error
#1
I have compared this code with similar queries that work. Can anyone see what I am missing that is causing the Syntax Error?

Error:
Exception has occurred: OperationalError (note: full exception trace is shown but execution is paused at: <module>) near "tagNo": syntax error File "/home/mark/Python Environments/FirstEnvProject/Bovine8.py", line 92, in insert_Cow self.c.execute(""" INSERT INTO cowTbl File "/home/mark/Python Environments/FirstEnvProject/Bovine8.py", line 665, in cow_saveAdd self.db.insert_Cow( File "/home/mark/Python Environments/FirstEnvProject/Bovine8.py", line 1316, in <module> (Current frame) CreateApp().run()
def insert_Cow(self,tagNo,tagClr,tagYr,type,des,
                        loc,locDte,birthDte,birthWt,weanDte,weanWt,sex,status,aquired,
                        aquiredDte,aquiredCst,disposition,dispDte,soldAmt,bredDte,
                        bullTagNo,bullTagClr,bullTagYr,actCalvDte,calfTagNo,calfTagClr,calfTagYr):
        self.c.execute(""" INSERT INTO cowTbl 

                           VALUES
                           tagNo=?,
                           tagClr=?,
                           tagYr=?,
                           type=?,
                           desc=?,
                           loc=?,
                           locDte=?,
                           birthDte=?,
                           birthWt=?,
                           weanDte=?,
                           weanWt=?,
                           sex=?,
                           status=?,
                           aquired=?,
                           aquiredDte=?,
                           aquiredCst=?,
                           disposition=?,
                           dispositionDte=?,
                           soldAmt=?,
                           bredDte=?,
                           bredByTag=?,
                           bredByTagClr=?,
                           bredByTagYr=?,
                           actCalvDte=?,
                           calfTagNo=?,
                           calfTagClr=?,
                           calfTagYr=?
                           """,
                           (tagNo,tagClr,tagYr,type,des,loc,locDte,birthDte,birthWt,weanDte,weanWt,sex,status,aquired,
                           aquiredDte,aquiredCst,disposition,dispDte,soldAmt,bredDte,
                           bullTagNo,bullTagClr,bullTagYr,actCalvDte,calfTagNo,calfTagClr,calfTagYr))
        self.con.commit()
Reply
#2
Probable should look a little closer at your query structure. I've tried unsuccessfully inserting data with that structure.
Doing something like:

def insert(*args):
    cur.execute('insert into cowTbl values (?,?,?,?)', args) # This structure works
    conn.commit()

insert(34, 'data45', 'data29', 'data34')
worked for me.
I welcome all feedback.
The only dumb question, is one that doesn't get asked.
My Github
How to post code using bbtags


Reply
#3
Problem resolved using your structure. thank you.
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Syntax error for "root = Tk()" dlwaddel 15 1,151 Jan-29-2024, 12:07 AM
Last Post: dlwaddel
Photo SYNTAX ERROR Yannko 3 370 Jan-19-2024, 01:20 PM
Last Post: rob101
  Syntax error while executing the Python code in Linux DivAsh 8 1,540 Jul-19-2023, 06:27 PM
Last Post: Lahearle
  Code is returning the incorrect values. syntax error 007sonic 6 1,204 Jun-19-2023, 03:35 AM
Last Post: 007sonic
  syntax error question - string mgallotti 5 1,284 Feb-03-2023, 05:10 PM
Last Post: mgallotti
  Syntax error? I don't see it KenHorse 4 1,236 Jan-15-2023, 07:49 PM
Last Post: Gribouillis
  Syntax error tibbj001 2 881 Dec-05-2022, 06:38 PM
Last Post: deanhystad
  Python-for-Android:p4a: syntax error in main.py while compiling apk jttolleson 2 1,828 Sep-17-2022, 04:09 AM
Last Post: jttolleson
  Mysql Syntax error in pymysql ilknurg 4 2,344 May-18-2022, 06:50 AM
Last Post: ibreeden
  Solving equation equal to zero: How to resolve the syntax error? alexfrol86 3 1,949 Feb-21-2022, 08:58 AM
Last Post: deanhystad

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020