When I try to add a string to the end of an enum list I get the following
error message:
You have an error in your SQL syntax near '\','Historical
Knowledge','Chronological Thinking, Comprehension, Analysis and I' at line 1
The schema for the field is:
standards_topic enum('','Historical Knowledge','Chronological Thinking,
Comprehension, Analysis and Interpretation','Research
Capabilities','Foundations of Government','Functions of Government','Roles
of Citizens','International Relations','The World in Spatial Terms','Places
and Regions','Physical Systems','Human Systems','Environment and
Society','Uses of Geography','Issues-Analysis, Decision-Making, Planning and
Problem Solving') NOT NULL default 'Historical Knowledge',
What I'm trying to add is:
'Chronological Thinking','Comprehension, Analysis, and Interpretation'
Can you tell me why this is happening?
Cindy
[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
