SSScout Posted September 7, 2009 Share Posted September 7, 2009 I tried to "spin off" a new thread, but got this in reply: Microsoft OLE DB Provider for ODBC Drivers error '80040e14' [Microsoft][ODBC SQL Server Driver] Line 1: Incorrect syntax near 'em'. /forums/post_library.asp, line 91 Happened more than once. Waited. Tried changing the title, the message, same thing. ?Que? Link to comment Share on other sites More sharing options...
packsaddle Posted September 8, 2009 Share Posted September 8, 2009 The irony is that you just DID spin a new thread...successfully. When I've had this problem in the past, it was because I had an illegal character in the title somewhere. Could that be the problem for yours as well? Link to comment Share on other sites More sharing options...
Beavah Posted September 9, 2009 Share Posted September 9, 2009 Yah, da system doesn't like apostrophes in titles, eh? Every time I get that message it's because I tried to use an apostrophe in a title. Beavah Link to comment Share on other sites More sharing options...
SSScout Posted September 9, 2009 Author Share Posted September 9, 2009 Apostrophe. As in ownership? Like "Scout's Own"? Or "Apostrophe's use Doesn't preclude Contraction's use"? Link to comment Share on other sites More sharing options...
AlFansome Posted September 9, 2009 Share Posted September 9, 2009 Apostrophe/single-quote as in: What's up with Jimmy's tent? Double quotes are OK. As a (possible) workaround, try using two single quotes instead of one where desired to see if that works: What''s up with Jimmy''s tent? Depending upon what's going on behind the scenes with the parsing and database statements, the two single-quotes may magically turn into a single one. The technical reason for the glitch is that a single quote is used as a string delimiter in SQL Server database statements and if code is not in place to look for and properly deal with single quotes in certain fields, then single quotes will mess up the database command used to create the topic. Link to comment Share on other sites More sharing options...
SSScout Posted September 9, 2009 Author Share Posted September 9, 2009 Thank you! I've learned my one new thing for the day. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now