I'm having a problem with the Editor. First, it seems to be working just fine, except...
When I create a large block of text in the Editor and then save that text in a SQL Server table, wherever the text ended a line, there is no blank character at the end of the line. I've attached a screen capture of the SQL server record and you can see (just above the red arrow) where there is no space between the word 'Homes' and the word 'Online', yet when I take this data out the record and display it on a web page, it displays just fine.
Here's my issue...after the editor contents are saved in the SQL database, I process the record searching for certain multi-word strings for some special editing issues involved in translation (without going into too much detail). If I search this stored string for 'Homes Online Network' the instance shown in the attached graphic is never found -- but it displays just fine with a space between the two words.
Is there some method I can use when retrieving the text field from the SQL database table that will allow my multi-word text search to be successful?
This is probably some kind of stupid question, but I do need the help. I've read the Editor documentation and searched the knowledgebase, but haven't found anything obvious that helps me.
Thanks in advance!
Lynn
When I create a large block of text in the Editor and then save that text in a SQL Server table, wherever the text ended a line, there is no blank character at the end of the line. I've attached a screen capture of the SQL server record and you can see (just above the red arrow) where there is no space between the word 'Homes' and the word 'Online', yet when I take this data out the record and display it on a web page, it displays just fine.
Here's my issue...after the editor contents are saved in the SQL database, I process the record searching for certain multi-word strings for some special editing issues involved in translation (without going into too much detail). If I search this stored string for 'Homes Online Network' the instance shown in the attached graphic is never found -- but it displays just fine with a space between the two words.
Is there some method I can use when retrieving the text field from the SQL database table that will allow my multi-word text search to be successful?
This is probably some kind of stupid question, but I do need the help. I've read the Editor documentation and searched the knowledgebase, but haven't found anything obvious that helps me.
Thanks in advance!
Lynn