Forum
Log In
Home
Topic RSS
Related Topics
10:42
30/12/2010
Offline
Hi, Aplogies if this has been answered but I can't find it. When submitting a record for update I get this message in Fiddler:
Uncaught exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 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 '4483 = 'N', epirb = 'N', liferaft = 'N', gpsspot = 'N', sailindon = 'N' WHERE id' at line 1' in C:\wamp\www\sailtimorleste\jqgrid\php\jqGridPdo.php:62
It appears that the automatically generated SQL statement has been truncated? Is there a limit on the length/number of field names? If so, is it configurable?
Thanks, Chris
01:47
30/12/2010
Offline
OK I have identified the issue - MySQL does not like numeric column names. Apparently back ticks (e.g. `1234`) will work but renaming the columns with alphanumeric names seems the best solution for use with jqGrid.
Most Users Ever Online: 715
Currently Online:
47 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
OlegK: 1255
markw65: 179
kobruleht: 144
phicarre: 132
YamilBracho: 124
Renso: 118
Member Stats:
Guest Posters: 447
Members: 11373
Moderators: 2
Admins: 1
Forum Stats:
Groups: 1
Forums: 8
Topics: 10592
Posts: 31289
Newest Members:
, razia, Prankie, psky, praveen neelam, greg.valainis@pa-tech.comModerators: tony: 7721, Rumen[Trirand]: 81
Administrators: admin: 66
