HI I am using Nhibernate 2.0, my data contains sql string character ' , hence the HQL is failing(below is the HQL that failed)
How can I handle this error?I don't want to change the data.. Message : !Could not execute: select FROM PersonHistory AS PH WHERE PH.Company.CompanyName = 'FRANK'S' and PH.FirstName = 'Brandon' and PH.LastName = 'Odom' and PH.ChargeCode = ''! could not execute query [ select personhist0_.PersonHistoryID as PersonHi1_17_, personhist0_.PersonGuid as PersonGuid17_, personhist0_.PersonHistoryGuid as PersonHi3_17_, personhist0_.SponsorName as SponsorN4_17_, personhist0_.MainLocationName as MainLoc26_17_, personhist0_.WorkingLocationID as Working27_17_, personhist0_.WorkingLocationName as Working28_17_, personhist0_.LastUpdatedBy as LastUpd29_17_, personhist0_.LastUpdatedDate as LastUpd30_17_ from POB_PERSON_HISTORY personhist0_, POB_COMPANIES company1_ where (company1_.CompanyName='FRANK' S ' and PH.FirstName = ' Brandon ' and PH.LastName = ' Odom ' and PH.ChargeCode = ' and personhist0_.CompanyID=company1_.CompanyID)] Inner Message : Incorrect syntax near 'S'. Exception Type : NHibernate.ADOException InnerException Type : NHibernate.ADOException --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/nhusers?hl=en -~----------~----~----~----~------~----~------~--~---
