Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
harshal_in
Aged Yak Warrior
633 Posts |
 Posted - 2003-05-08 : 02:28:15
|
| Hi,One of the columns has the datatype ntext and it stores html in it.When it is read through a record set in Vb it gives some error and does not display the text.But if the same text from the column is selected and assigned to a variable it shows proper results.Is there any special syntax while working with HTML in columns?thnxs,Regards, Harshal.Expect the UnExpected |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2003-05-08 : 02:37:14
|
| If you use text, ntext or image fields in your database and you want to select them through ADO, you need to have that column LAST in your select list.Damian |
 |
|
|
harshal_in
Aged Yak Warrior
633 Posts |
Posted - 2003-05-08 : 03:57:09
|
quote:
If you use text, ntext or image fields in your database and you want to select them through ADO, you need to have that column LAST in your select list.Damian
that is fine but is there any special syntax when we are dealing with HTML in a field?Expect the UnExpected |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2003-05-08 : 08:01:41
|
| HTML syntax ? SQL Syntax ? VB Syntax ? Cobol Syntax ? Fortran Syntax ? Perl Syntax ? Python Syntax ?Damian |
|
|
|
harshal_in
Aged Yak Warrior
633 Posts |
Posted - 2003-05-10 : 05:51:05
|
quote:
HTML syntax ? SQL Syntax ? VB Syntax ? Cobol Syntax ? Fortran Syntax ? Perl Syntax ? Python Syntax ?Damian
What's wrong????       Expect the UnExpected |
|
|
|
harshal_in
Aged Yak Warrior
633 Posts |
Posted - 2003-05-13 : 07:58:19
|
| I think that I have the solution for this,when the text which is in html format is selected in sql server it is parsed and shown properly,it takes and physical enter in the code for enter and not CRLFwe were using some crlf for entering in a new row which was not working properly.Expect the UnExpected |
|
|
|
Arnold Fribble
Yak-finder General
1961 Posts |
Posted - 2003-05-13 : 08:21:00
|
| I don't understand this. It shouldn't make any difference to the output of an HTML renderer whether you use CRs, LFs or CRLF pairs to indicate line breaks. And outside the content of a <PRE> element, all sequences of whitespace characters are rendered the same.HTML 4.01 section 9.3.2 Controlling line breaks"A line break is defined to be a carriage return (
), a line feed (
), or a carriage return/line feed pair." |
|
|
|
|
|
|
|
|
HTML sselection Question