Re: simple one..... from HTML to SQL to HTML... i lose my new lines

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



Justin,

I believe that a simple replace statement should solve your problems.
If I am not mistaken, it is stored in SQL as Chr(13). You should be
able to do a replace command and replace the Chr(13) with a <BR> tag.

Let me know if this helps. I know the following is what is used when a
datagrid is populated:

<asp:TemplateColumn HeaderText="myField" Visible="True">
<ItemTemplate>
<%# myDataSet.FieldValue("myField", Container).
Replace(Chr(13), "<br>") %>
</ItemTemplate>
</asp:TemplateColumn>

Aaron

.



Relevant Pages

  • Re: Report Problems
    ... here is the SQL for the query I'm using for it currently- I had to make ... Aaron ... Prev by Date: ...
    (microsoft.public.access.reports)
  • Re: Product Vs Product
    ... things about their system that they didn't know using Idera. ... For pure stand-alone SQL Performance monitoring and analysis, ... Aaron, I see your name endorsing one of them so you can only respond if ... Thanks, I didn't know Aaron had a blog on it, I just saw his name ...
    (microsoft.public.sqlserver.server)
  • Re: I think I have a huge problem
    ... Aaron ... >> Queue Length Alert on NEWSERVER". ... >> I have good internet connectivity. ...
    (microsoft.public.windows.server.sbs)
  • Re: Windows Ada database support.
    ... But you can translate into SQL. ... : My_ Fancy_DB.Execute ("BAZ ...")? ... a container that refers to my object. ...
    (comp.lang.ada)
  • Re: Error 170
    ... Aaron, Using your suggestion created another error - doubtlessly due to ... I think I'll have another look at stored procedures. ... > If you're creating dynamic SQL anyway, ...
    (microsoft.public.sqlserver.programming)