By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,766 Members | 1,281 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,766 IT Pros & Developers. It's quick & easy.

How work with html-table included in ntext-field

P: 4
Hi to All!
I have one problem...
There is a field ntext-type! In this field html-code containing table description is written. For example,
Expand|Select|Wrap|Line Numbers
  1. <div class=ExternalClass8B4D385BBA104BFD8B227489826266F7>
  2. <div>
  3. <table style="display:inline;font-size:1em;width:500px;border-collapse:collapse;height:54px" border=0>
  4. <tbody>
  5. <tr>
  6. <td class=ms-rtetablecells style="vertical-align:top">
  7. <div align=center>Place of work</div></td>
  8. <td class=ms-rtetablecells style="vertical-align:top">
  9. <div align=center>Position</div></td>
  10. <td class=ms-rtetablecells style="vertical-align:top">
  11. <div align=center>Period</div></td></tr>
  12. <tr>
  13. <td class=ms-rtetablecells style="vertical-align:top">
  14. <div>Bank</div></td>
  15. <td class=ms-rtetablecells style="vertical-align:top">
  16. <div>Manager</div></td>
  17. <td class=ms-rtetablecells style="vertical-align:top">
  18. <div>01.08.2005 -30.06.2008</div></td></tr>
  19. <tr>
  20. <td class=ms-rtetablecells style="vertical-align:top">
  21. <div>Training Center</div></td>
  22. <td class=ms-rtetablecells style="vertical-align:top">
  23. <div>programmer</div></td>
  24. <td class=ms-rtetablecells style="vertical-align:top">
  25. <div>01.07.08 - </div></td></tr></tbody></table></div></div>
Question: How can i extract data from this ntext-field to further work with that data? Please, help!
Jan 19 '09 #1
Share this Question
Share on Google+
6 Replies

Expert 5K+
P: 5,058

There is no such thing as a nText data type in MySQL.

What kind of SQL server are you using?
Microsoft SQL Server perhaps?

Let me know and I will move this over to the right place.
Jan 19 '09 #2

P: 4
Yes, exactly!
Microsoft Sql Server 2005!
Jan 19 '09 #3

Expert 2.5K+
P: 2,878
SQL Server 2005 can support XML data type. An HTML code is an informal XML data. Read more about ithere

Happy Coding!

-- CK
Jan 20 '09 #4

P: 4
Ok, but how can i transform html code into xml to work with it as with xml?
Jan 20 '09 #5

Expert 2.5K+
P: 2,878
An HTML code is a form of XML.
Jan 20 '09 #6

P: 4
ОК! Would you be so kind, please, give me an example on SQL, how can i get all table headings?
Jan 21 '09 #7

Post your reply

Sign in to post your reply or Sign up for a free account.