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.



om_prakash May 30th, 2005 01:10 AM


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

  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>")


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.