Python Forum
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
near "(": syntax error
#1
Heart 
Hi guys, I need little help with the code below. I want to edit the guest room, name or surname, but I get "near "(": syntax error".
Any help is appreciated, Thank you!

This is the table:
[Image: Screenshot-2021-06-01-at-15-25-38.png]

Code:
def editGuest():
    viewGuests()
    print("Choose room number:")
    roomNumber = input()
    print("You choose", roomNumber)
    try:
        cur = con.cursor()
        cur.execute("SELECT room,name,surname FROM Guest WHERE room = {}".format(roomNumber))
        rowz= cur.fetchone()
        print("ROOM", "\tNAME", "\tSURNAME")
        print(rowz[0],rowz[1],rowz[2])
        print("What would you like to change?")
        print("1 - Room, 2 - Guest Name, 3 - Guest Surname")
        userInput = input()
        if userInput == "1":
            print("Enter new room number")
            newRoom = input()
            cur.execute("UPDATE Guest(room) SET room = {} WHERE room = {}").format(newRoom, roomNumber)
            con.commit()
        elif userInput == "2":
            print("Enter new name")
            newName = input()
            cur.execute("UPDATE Guest(name) SET name = {} WHERE room = {}").format(newName,roomNumber)
            con.commit()
        elif userInput == "3":
            print("Enter new Surname")
            newSurname = input()
            cur.execute("UPDATE Guest(surname) SET surname = {} WHERE room = {}").format(newSurname,roomNumber)
            con.commit()
        else:
            print("Invalid Input")
    except sqlite3.Error as e:
        print(e)
Reply
#2
cur.execute("UPDATE Guest(room) SET room = {} WHERE room = {}").format(newRoom, roomNumber)
remove (room)
cur.execute("UPDATE Guest SET room = {} WHERE room = {}").format(newRoom, roomNumber)
The same applies to the other updates remove (name) and (surname)
Reply
#3
(Jun-09-2021, 02:29 PM)Yoriz Wrote:
cur.execute("UPDATE Guest(room) SET room = {} WHERE room = {}").format(newRoom, roomNumber)
remove (room)
cur.execute("UPDATE Guest SET room = {} WHERE room = {}").format(newRoom, roomNumber)
The same applies to the other updates remove (name) and (surname)

It updates the room, however, it doesn't update the name and surname. The error is :
No such column: NAME;
or
No such column: forSurname
cur.execute("UPDATE Guest SET name = {} WHERE room = roomNumber".format(newName))
cur.execute("UPDATE Guest SET surname = {} WHERE room = roomNumber".format(newSurname))
Reply
#4
Hi Maryan,
There are some things I do not understand. I believe your program or database table have changed since 2021-06-09.

(Jun-20-2021, 03:26 PM)Maryan Wrote:
Error:
No such column: NAME; or No such column: forSurname
This is weird. You never mentioned the column "forSurname" before.
And there is no column "NAME"? But then the query at line 8 ("SELECT room,name,surname FROM Guest WHERE room = {}") must also have failed.

(Jun-20-2021, 03:26 PM)Maryan Wrote:
Error:
cur.execute("UPDATE Guest SET name = {} WHERE room = roomNumber".format(newName)) cur.execute("UPDATE Guest SET surname = {} WHERE room = roomNumber".format(newSurname))
But these ar not the update statements from your program! You had:
cur.execute("UPDATE Guest(name) SET name = {} WHERE room = {}").format(newName,roomNumber)
So please show us the actual state:
  • give a description of the "Guest" table,
  • Create the smallest program to reproduce the error and show this,
  • Also show the complete error in the applicable tags.

And by the way. Using the old "format()" method is not the best way. Please study how to use bind variables in sqlite3. Like this.
cur.execute("UPDATE Guest(name) SET name = ? WHERE room = ?", (newName, roomNumber) )
Note: the second parameter must be a tuple. You should use this principle for reasons of security and performance.
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  I have a syntax error! rohes_kaugummi 3 326 Jun-23-2021, 05:24 PM
Last Post: deanhystad
  import module with syntax error Skaperen 7 357 Jun-22-2021, 10:38 AM
Last Post: Skaperen
Exclamation getting a syntax error and i don't know why ilikedofs 10 763 May-13-2021, 08:52 PM
Last Post: deanhystad
  Even number code syntax error MrCeez 1 413 May-02-2021, 06:43 PM
Last Post: Larz60+
  error in your SQL syntax Xuli 10 721 May-02-2021, 12:27 PM
Last Post: Xuli
  Function syntax error Changosoyyo 2 558 Mar-07-2021, 10:42 PM
Last Post: Changosoyyo
  Syntax error on line 29 manwithjeans 3 615 Feb-27-2021, 08:28 AM
Last Post: perfringo
  Invalid syntax error - need help fixing calgk01 3 665 Feb-23-2021, 08:41 PM
Last Post: nilamo
  Why do I get Syntax error? TechNitium 1 470 Jan-22-2021, 12:49 PM
Last Post: snippsat
  syntax error CompleteNewb 8 768 Jan-08-2021, 04:05 PM
Last Post: deanhystad

Forum Jump:

User Panel Messages

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