<HELP>How to put many lines of input int

Results 1 to 2 of 2

Thread: <HELP>How to put many lines of input int

  1. #1
    Fucoid Guest

    Default <HELP>How to put many lines of input int

    I want to pass whole text inside textarea (of course, many lines of input separated by &#060;cr&#062;) into a single cell inside ACCESS database table. Please let me know how...<BR>Thank you very much.<BR>Fucoid

  2. #2
    peterjl@austec.net.au Guest

    Default RE: <HELP>How to put many lines of input

    The Access Db field has to be defined as a Memo field. Memo fields can hold up to 32,768 characters.<BR><BR>Assuming that you input comes from a form field named "myBlob"" and you have created the memo field of the same name in you database, you first open a connection to the database and open a recordset (rs) for the table you want to add the text to. Then you just do this:<BR><BR> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;rs.AddNew<B R> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;rs("MyBlob" ) = Request.Form("myBlob")<BR> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;rs.Update

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts