How to use asp script to insert long text to a memo field


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: How to use asp script to insert long text to a memo field

  1. #1
    chakhorn T Guest

    How to use asp script to insert long text to a memo field


    Due to limited size of sql query string, I cannot update memo filed (in MS
    Access) with long text.
    so the statement Conn.execute("insert into tblhelpme values("memo.......(1000
    characters).............") did not work.
    Can I use other method to update memo field using asp script?

    Chakhorn T.

  2. #2
    Brett Guest

    Re: How to use asp script to insert long text to a memo field


    "chakhorn T" <chakhorn@yahoo.com> wrote:
    >
    >Due to limited size of sql query string, I cannot update memo filed (in

    MS
    >Access) with long text.
    >so the statement Conn.execute("insert into tblhelpme values("memo.......(1000
    >characters).............") did not work.
    >Can I use other method to update memo field using asp script?
    >
    >Chakhorn T.



    It's been awhile since I've used Access - but, I think you are limited to
    255 characters. (I think.) Hmmm....

  3. #3
    David Guest

    Re: How to use asp script to insert long text to a memo field


    "Brett" <brett@erevsolutions.com> wrote:
    >
    >"chakhorn T" <chakhorn@yahoo.com> wrote:
    >>
    >>Due to limited size of sql query string, I cannot update memo filed (in

    >MS
    >>Access) with long text.
    >>so the statement Conn.execute("insert into tblhelpme values("memo.......(1000
    >>characters).............") did not work.
    >>Can I use other method to update memo field using asp script?
    >>
    >>Chakhorn T.

    >
    >
    >It's been awhile since I've used Access - but, I think you are limited to
    >255 characters. (I think.) Hmmm....


    A memo field in an access database can hold up to 64,000 characters.......

    Dave


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center