Did you really name a category type with an apostrophe in the database? Also what error do you receive when you run your query in the query analyzer? Keidrick Pettaway Web: http://www.kpettaway.com Twitter: http://twitter.com/kpett Linkedin: http://www.linkedin.com/pub/keidrick-pettaway/8/705/b58
-----Original Message----- From: ARUN KUMAR <[email protected]> Date: Sat, 26 Dec 2009 21:01:18 To: <[email protected]> Subject: Re: [DotNetDevelopment] Unclosed quotation mark before the character string ' ' Small Mistake in your query change like below Select a.Category_Id, a.Category_Name,b.umc,b.Magazine_Name,Magazine_Description From [magazine_category] a Inner Join magazine b on a.Category_Id = b.Category_Id and a.Category_Name = 'Men''s Interest' I have insert sigle quotes near 's' a.Category_Name = 'Men's Interest' a.Category_Name = 'Men''s Interest' 2009/12/26 nag <[email protected]> > hi friend im getting following error,wen i run > DropDownList1_OnSelectedIndexChanged event > > Line 1: Incorrect syntax near 's'. > Unclosed quotation mark before the character string ' '. > > here is my query > please help me to solve this > > Select a.Category_Id, > a.Category_Name,b.umc,b.Magazine_Name,Magazine_Description From > [magazine_category] a Inner Join magazine b on a.Category_Id = > b.Category_Id and a.Category_Name = 'Men's Interest' > -- Regards ******************* *C.Arun Kumar * *******************
