467,149 Members | 1,244 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,149 developers. It's quick & easy.

How work with html-table included in ntext-field

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
  • viewed: 3980
6 Replies
Expert 4TB

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
Yes, exactly!
Microsoft Sql Server 2005!
Jan 19 '09 #3
Expert 2GB
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
Ok, but how can i transform html code into xml to work with it as with xml?
Jan 20 '09 #5
Expert 2GB
An HTML code is a form of XML.
Jan 20 '09 #6
ОК! 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.

Similar topics

5 posts views Thread by Peter | last post: by
19 posts views Thread by Chris Allen | last post: by
11 posts views Thread by Pater Maximus | last post: by
4 posts views Thread by Steven Green | last post: by
2 posts views Thread by Chris | last post: by
9 posts views Thread by chandramohan.mani@gmail.com | last post: by
11 posts views Thread by Robert Baer | last post: by
4 posts views Thread by E | last post: by
24 posts views Thread by Dennis | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.