• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
New mySQL Exception
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

New mySQL Exception

  • Subject: New mySQL Exception
  • From: James Cicenia <email@hidden>
  • Date: Wed, 20 Apr 2005 13:59:20 -0500
When I use the built in D2W search component I am now getting this exception:

com.webobjects.jdbcadaptor.JDBCAdaptorException: EvaluateExpression failed: : Next exception:SQL State:42000 -- error code: 1064 -- msg: Syntax error or access violation, message from server: "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 ''\'' at line 1"
Reason:
EvaluateExpression failed: <com.webobjects.jdbcadaptor.JDBCExpression: "SELECT t0.actual_cost_to_date, t0.add_date, t0.add_user_id, t0.approved_budget, t0.assigned_pm_resource_id, RTRIM(t0.assumptions), t0.budget_health, RTRIM(t0.budget_source), RTRIM(t0.business_objective), t0.business_urgency, RTRIM(t0.cancel_authority), t0.cancel_date, RTRIM(t0.cancel_reason), t0.complexity, RTRIM(t0.concept), t0.current_estimate_to_complete, t0.current_rollout_date, RTRIM(t0.dependency), t0.estimated_start_date, t0.final_rollout_date, t0.group_code_id, RTRIM(t0.hard_due_date_flag), RTRIM(t0.hard_start_date_flag), t0.health_override, t0.health_override_last_date, t0.health_override_last_user_id, t0.implementation_plan_id, t0.initial_cost_estimate, t0.initiation_date, t0.init_meeting_complete_due_date, RTRIM(t0.init_meeting_complete_flag), t0.key_portfolio_skill_set_id, t0.landscape_id, t0.last_mod_date, t0.last_mod_user_id, t0.last_milestone_completed_id, t0.last_topic_post, t0.milestone_health, RTRIM(t0.off_hold_authority), t0.off_hold_date, RTRIM(t0.off_hold_reason), RTRIM(t0.on_hold_authority), t0.on_hold_date, RTRIM(t0.on_hold_reason), t0.original_rollout_date, t0.overall_health, t0.pipeline_date, RTRIM(t0.plan_comments), t0.plan_complete_due_date, RTRIM(t0.plan_complete_flag), t0.portfolio_customer_id, t0.portfolio_id, t0.project_measure_id, t0.project_state_id, RTRIM(t0.regulatory_criteria), t0.requested_due_date, RTRIM(t0.roll_back_authority), t0.roll_back_date, RTRIM(t0.roll_back_reason), t0.row_id, t0.scope_statement_id, RTRIM(t0.sponsor_approval_flag), t0.sponsor_resource_id, t0.submitted_date, t0.submitter_resource_id, RTRIM(t0.title), RTRIM(t0.top_initiative_override_flag), RTRIM(t0.top_initiative_score_flag), RTRIM(t0.tracking_number), RTRIM(t0.type) FROM portfolio_project t0 WHERE UPPER(t0.title) LIKE UPPER(?) ESCAPE '\'" withBindings: 1:"the%"(title)>: Next exception:SQL State:42000 -- error code: 1064 -- msg: Syntax error or access violation, message from server: "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 ''\'' at line 1"

It doesn't like ESCAPE '\'

Funny thing is I don't remember changing anything and it was working before.

Any thoughts?
James Cicenia
 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      (email@hidden)
Help/Unsubscribe/Update your Subscription:

This email sent to email@hidden
  • Follow-Ups:
    • Re: New mySQL Exception SOLVED
      • From: James Cicenia <email@hidden>
  • Prev by Date: D2W Custom component
  • Next by Date: browser doesn't open
  • Previous by thread: SOLVED] Re: D2W Custom component
  • Next by thread: Re: New mySQL Exception SOLVED
  • Index(es):
    • Date
    • Thread