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
Exclamation Invalid syntax error(Predict Ethereum Price) lulu43366 2 97 Sep-24-2021, 01:24 PM
Last Post: lulu43366
  Line 42 syntax error..Help!!1 patpython 4 277 Sep-01-2021, 03:22 PM
Last Post: deanhystad
  Unexplained Invalid syntax Error cybertooth 5 361 Aug-02-2021, 10:05 AM
Last Post: cybertooth
  I have a syntax error! rohes_kaugummi 3 533 Jun-23-2021, 05:24 PM
Last Post: deanhystad
  import module with syntax error Skaperen 7 609 Jun-22-2021, 10:38 AM
Last Post: Skaperen
Exclamation getting a syntax error and i don't know why ilikedofs 10 1,087 May-13-2021, 08:52 PM
Last Post: deanhystad
  Even number code syntax error MrCeez 1 573 May-02-2021, 06:43 PM
Last Post: Larz60+
  error in your SQL syntax Xuli 10 1,006 May-02-2021, 12:27 PM
Last Post: Xuli
  Function syntax error Changosoyyo 2 691 Mar-07-2021, 10:42 PM
Last Post: Changosoyyo
  Syntax error on line 29 manwithjeans 3 817 Feb-27-2021, 08:28 AM
Last Post: perfringo

Forum Jump:

User Panel Messages

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