Click here to Skip to main content
15,896,207 members

Comments by Mostafa Mohamed (Top 6 by date)

Mostafa Mohamed 10-May-14 9:36am View    
@thatraja
i changed the column name
Mostafa Mohamed 9-May-14 15:15pm View    
@thatraja

cursor.execute(statement)
psycopg2.ProgrammingError: syntax error at or near "name"
LINE 1: INSERT INTO Product (Product name) VALUES (['Service'])

this is the compiler Error
Mostafa Mohamed 9-May-14 13:34pm View    
@thatraja No
the same Error is appear , no error is solved
Mostafa Mohamed 9-May-14 13:30pm View    
@thatraja <br>
 <br>
i missed(product_name) is column name <br>
now that can i do to run script

the same error is appear when i try to run
Mostafa Mohamed 9-May-14 12:51pm View    
@thatraja thanks for replay

i solve this error but i get another

cursor.execute(statement)
psycopg2.ProgrammingError: syntax error at or near "name"
LINE 1: INSERT INTO Product (Product name) VALUES (['Service'])

when i try to run this

statement = 'INSERT INTO Product (Product name) VALUES (' + str(row) + ')'
cursor.execute(statement)