SQL Syntax ?

All ApPHP DataGrid script bugs discussion. Questions and requests here.
Please, use a $debug_mode = true; before you say "Why Nothing Works ?!" (solves 90% of all issues)

Moderators: ne_moj, zewa, vadimako, ne_moj, zewa, vadimako

cvillagra
Newbie
Newbie
Posts: 4
Joined: Sep 14th, '09, 20:45

SQL Syntax ?

Postby cvillagra » May 23rd, '14, 04:58

Errors:

1) INSERT INTO stock (code, brand, vendorcode, desc, Pic1) VALUES ('a', 'b', 'c', 'd', 'washer.jpg')
[nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'desc, Pic1) VALUES ('a', 'b', 'c', 'd', 'washer.jpg')' at line 1]

Im using DataGrid Version 7.49

administrator
Site Admin
Site Admin
Posts: 5990
Joined: Jan 7th, '09, 23:18
Contact:

Re: SQL Syntax ?

Postby administrator » May 25th, '14, 04:59

desc is a reserved word in SQL, you cannot use it as a column name.
The best solution is to rename this column.


Return to “ApPHP DataGrid {bugs}”