p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   Classic ASP Databases (http://p2p.wrox.com/forumdisplay.php?f=62)
-   -   get paragraph from database (http://p2p.wrox.com/showthread.php?t=29729)

vickyj May 25th, 2005 03:39 AM

get paragraph from database
 
I'm using memo fields to store some contents.
when i want to retrive contents from data then there is
no problem in displaying the contents.
But i want to print only first pragraph in one <td></td> ,second paragraph from another 'td' and so on.

so pls tell me the logic or code for this.

Thanks

vicky

om_prakash May 30th, 2005 01:10 AM

Hi,

what delimiter u r using while storing data in the database?

If you are using new Line Char, then this can be replaced with "<TD></TD>"


Om Prakash

raj_makro May 31st, 2005 07:59 AM

Hi
  Let me code what Prakash is saying. Say you are storing the data from memo field into variable mymemo and displaying it using
<%
  Response.write mymemo
%>
  To achieve required output, the same has to be modified as

<%
   Response.wrie replace(mymemo,vbcrlf,"</td><td>")
%>


Regards
Raj


All times are GMT -4. The time now is 06:17 PM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.