Re: error in your SQL syntax

Hi Mark,

This is not a bug and should really have been submitted to the users 
lists. You have a single quote (') in your text and the has ended the 
text string you were trying to place in the column,.. hence MySQL is 
trying to interpret the "s ability to communicate and to respond..." as 
SQL.  You need to escape the quote by putting a backslash (\) before it.

Cheers,

    Paul.

Mark Gnaster wrote:
> This is the error message when I attempt to submit an job application: Could
> not run the query: 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 's ability to communicate and to respond to a specific directive. Some
> projects i' at line 1 
>
>  
>
> I submitted the following resume:
>
>  
>
> Mark G. Gnaster
>
>  
>
>  
>
> 4217 Link Dr. 
>
> Brighton, Michigan 48114
>
> (810) 229-4188
>
> EMAIL: [email protected]    
>
>  
>
>  
>
> QUALIFICATIONS
>
>  
>
>  
>
> Strong written and communication ability
>
> Excellent Computer Skills
>
> Completion of an accredited Graduate Library Program
>
> Experience in Library, Museum and Archival environment
>
>  
>
>  
>
> EDUCATIONAL RECORD
>
>  
>
>  
>
> Wayne State University of Detroit, Michigan 
>
>  
>
> Master of Library and Information Science (1999 - 2003)
>
> Degree includes additional study for Archival Certification
>
>  
>
>              <http://www.lisp.wayne.edu/> Wayne State University Library and
> Information Science Program
>
>  
>
>  
>
> Graduate Program in Interdisciplinary Studies (1996 - 1998)
>
>  
>
>             President of College of Lifelong Learning Student Senate
> (1998 - 1999)
>
>  
>
> Bachelor of Interdisciplinary Studies (1985 - 1995)
>
>  
>
>
> Additional Professional Educational Training
>
>
>  
>
> Introduction to Preservation Technologies: Options - 0.5 CEU (2001)
>
>  
>
> Henry Ford Community College of Dearborn, Michigan
>
>  
>
> Associate in Applied Science (1977 - 1982)
>
>  
>
> Apprenticeship Training Program (1977 - 1999)
>
>  
>
>  
>
> LIBRARY EXPERIENCE
>
>  
>
>  
>
> General Library and Archival Duties (1999 - 2003)
>
>  
>
>  <http://wwnet.net/~ocphs/index.html> Oakland County Pioneer & Historical
> Society of Pontiac, Michigan
>
>  
>
> Duties: Volunteer work in a library, archive, and museum environment. My
> experience thus far includes manuscript processing, cataloging, indexing,
> and finding aid experience. 
>
>  
>
>  
>
> CAREER EXPERIENCE
>
>
>  
>
>
>  
>
> Social Media Analyst (2009 - Present)
>
>  
>
>             Converseon Incoporated, New York, NY
>
>  
>
> Duties: Measure and report user trends in social media. Identify and analyze
> traffic from social media, including blogs, social network sites, message
> forums, bookmarking sites, micro media sites and photo sharing sites. 
>
>  
>
> Media Analyst (2008-2009)
>
>             
>
>             PRIME Research International, Ann Arbor, Michigan
>
>  
>
> Duties: Analysis of US and international media coverage to provide clients
> with strategically relevant information and competitive intelligence for
> their public relations programs. Automotive clients include those in North
> America, Canada, Australia and India.
>
>             
>
>  
>
> Substitute Teacher - K-5 (2008 - Present)
>
>             
>
> Educational Teaching Solutions, Detroit, Michigan
>
>  
>
> Duties: Responsible for the control of classroom assigned. Follow lesson
> plan left by full-time teacher if supplied; maintain records of attendance
> and seating, have lesson plans prepared for students, and leave
> communication for the regular teacher of the day's lessons covered and any
> problems incurred while doing so.
>
>  
>
>  
>
>  
>
>  
>
>  
>
>  
>
>  
>
> Faculty Instructor (2008 - Present)
>
>             
>
>             Wayne State University of Detroit, Michigan
>
>  
>
> Duties: Teach part-time classes in Labor Studies Program. Students are
> comprised of various members of the labor force in the Metro Detroit Area.
> Classes taught with first-hand experience in labor relations, courses are
> offered in a variety of formats and lengths. Workshops run two to three
> hours in length. Case histories, simulations, and up-to-date materials give
> participants the chance to learn new skills and refine old ones.
>
>  
>
>
>  
>
>
>  
>
>
>  
>
>
>  
>
>
> Reader / Evaluator (2008 - Present)
>
>
>             
>
>             Measurement Inc. Ypsilanti, Michigan 
>
>  
>
> Duties: Score essays for content, organization, grammatical convention,
> and/or the student's ability to communicate and to respond to a specific
> directive. Some projects involve scoring test items in math, science, social
> studies, or other subject areas. The tests scored come from many different
> states and from students at all grade levels, elementary through college,
> depending on the project.
>
>  
>
> Advance Cost Estimator (1995 - 2008)            
>
>  
>
> DaimlerChrysler Corporation of Detroit, Michigan
>
>  
>
> Duties: Design cost estimation of automotive vehicle components. This
> includes those parts manufactured within the corporation, and analysis of
> outside supplier manufactured parts.
>
>  
>
> Journeyman Template Maker (1986 - 1995)
>
>  
>
> Chrysler Corporation of Warren, Michigan
>
>  
>
> Duties: Research and Retrieval of engineering change information from CATIA
> (Computer Aided Three-dimensional Interactive Application) System. This
> information guided me in creating accurate tooling layout aids for
> Journeyman Die makers. This assisted them to complete tooling modifications
> in production tools critical to the manufacture of repeatable quality
> stampings used in the assembly of automobiles, sport utility vehicles, and
> trucks.
>
>  
>
>  
>
>  
>
>  
>
>  
>
> Journeyman Die maker (1981 - 1986)
>
>  
>
>             Chrysler Corporation of Warren, Michigan
>
>  
>
> Duties: Preventive maintenance of production tools for stamping to include
> die construction, layout and maintenance of tools during peak production
> periods.
>
>  
>
>  
>
> Data Telecommunications Center Operator (1982 - 1984)
>
>  
>
>             United States Army 
>
>  
>
> Duties:  Attendance in technical school for Data Telecommunications Center
> Operator training at Fort Gordon in Augusta, Georgia. Upon completion of
> same, I received orders to my permanent duty station of Fort Hood in
> Killeen, Texas. There, I assumed the role of Communications Security Clerk,
> for the duration of my tour of duty.
>
>  
>
> Die maker Apprentice (1977 - 1981)
>
>  
>
>             Chrysler Corporation of Detroit, Michigan and Warren, Michigan
>
>  
>
> Duties: Completion of required hours of training in bona fide Die making
> apprenticeship, to include two years of schooling on a part-time status
> within the framework of training.
>
>  
>
> Press Operator (1971 - 1977)
>
>  
>
>             Chrysler Corporation of Detroit, Michigan
>
>  
>
> Duties: Large stamping press operator, floor assistant to production
> supervisor and Die Helper to assist Journeyman Die makers by preparing
> stamping dies for maintenance and/or fabrication.
>
>  
>
>  
>
>  
>
>
> PROFESSIONAL MEMBERSHIPS
>
>
>  
>
>  
>
> Member of National Trust for Historic Preservation -              (2001 -
> present)
>
>  
>
> Member of Society of American Archivists (SAA)      -           (2000 -
> 2003)
>
>  
>
> Secretary of WSU/SAA Student Chapter  -          (2000 - 2001) 
>
>  
>
>  
>
> Member of American Society for Indexing              -               (2008 -
> present)
>
>  
>
>             
>
>             C2009 Mark Gnaster 
>
>  
>
>  
>
>  
>
>  
>
> Please advise. Thanks. 
>
>  
>
> Regards,
>
> Mark Gnaster
>
>
>   


-- 
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe:    http://lists.mysql.com/[email protected]