473,394 Members | 1,700 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,394 software developers and data experts.

How work with html-table included in ntext-field

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>
  26.  
Question: How can i extract data from this ntext-field to further work with that data? Please, help!
Jan 19 '09 #1
6 4259
Atli
5,058 Expert 4TB
Hi.

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
Nadina
4
Yes, exactly!
Microsoft Sql Server 2005!
Jan 19 '09 #3
ck9663
2,878 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
Nadina
4
Ok, but how can i transform html code into xml to work with it as with xml?
Jan 20 '09 #5
ck9663
2,878 Expert 2GB
An HTML code is a form of XML.
Jan 20 '09 #6
Nadina
4
ОК! Would you be so kind, please, give me an example on SQL, how can i get all table headings?
Jan 21 '09 #7

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

Similar topics

5
by: Peter | last post by:
L.S. I am developing a PHP-login script (on Lycos Tripod) that uses Session to pass on variables. Below is the entire (stripped) structure that I use. It opens a page where you can Set and Read...
19
by: Chris Allen | last post by:
Hi I'm new to PHP and I'm trying to create a Login Form. Once the user has logged in then he shouldn't have to log in again. The trouble is I'm getting a new session ID between every page and so...
11
by: Pater Maximus | last post by:
I am trying to implement the recipe listed at http://aspn.activestate.com/ASPN/Cookbook/Python/Recipe/211886 However, I can not get to first base. When I try to run import urllib...
4
by: Steven Green | last post by:
I did a clean install of Windows XP on my computer and my javascript will not work. I've tried all types of browsers, I've download the Service pack 1 for XP and IE. I have download java from...
2
by: Chris | last post by:
Im hoping someone can help me understand why this works? Requirement: Navigate DOM through javascript to perform DHTML actions. Issue: GIANT html document, up to 4MB in size, thousands and...
9
by: chandramohan.mani | last post by:
Does Event handlers work in netscape. If yes means can anyone please help me. <HTML><SCRIPT LANGUAGE="JScript"> function mouseclick() { alert("I was clicked on " +...
4
by: Chris Lane | last post by:
Hi, I have an HTML RESET button and Web Control Button that posts back to the server. Problem is the reset button doesn't work after the postback occurs. Any ideas or suggestions as to why this...
11
by: Robert Baer | last post by:
The following passes the test as valid, and the mouseover for the six indicated areas also work. I need various areas to link to another page, including the six mentioned. However either the MAP...
4
by: E | last post by:
I am having trouble with setTimeout working on a second call to the setTimeout function from a second page which is an html page. Here is the scenario. I have a web page and onload it calls a...
24
by: Dennis | last post by:
I'm trying to use FindCrontrol and it will not work. Here is the code: Dim DisplayPanel As Panel DisplayPanel = CType(FindControl("pnlName"), Panel) No matter how I do it - I've tried...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.