Question

[SSScout 1615]

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?

 

 

 

[packsaddle 753]

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?

[Beavah 205]

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

 

[SSScout 1615]

Apostrophe. As in ownership? Like "Scout's Own"? Or "Apostrophe's use Doesn't preclude Contraction's use"?

[AlFansome 10]

 

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.

 

[SSScout 1615]

Thank you! I've learned my one new thing for the day.