[thelist] MS ACCESS - Bypass limit on memo field >> outputing to a text file auto...

[Kevin]

> Message: 6
> Subject: RE: [thelist] MS ACCESS - Bypass limit on memo field
> charset="iso-8859-1"
> Date: Thu, 2 Aug 2001 15:01:50 -0400
> From: "Tab Alleman" <Tab.Alleman at RealMetros.com>
> To: <thelist at lists.evolt.org>
> Reply-To: thelist at lists.evolt.org
> I'd recommend storing the long data in .txt files, and store the
> path/name of the files in your access db.
> -----Original Message-----
> From: jon steele [mailto:jjsteele22 at yahoo.com]
> Sent: Thursday, August 02, 2001 2:45 PM
> To: TheList Evolt
> Subject: [thelist] MS ACCESS - Bypass limit on memo field
> Hi,
> I am using ColdFusion and Access and I was wondering if I can have a
> field with unlimited limit size. Memo is the largest but it still has a
> limit.
>
> The table in question is being created from ColdFusion, so I'd need to
> set this infinite limit from <cfquery>. This can probably be done from
> ASP (causs it's MS) but I need it from ColdFusion.
> I REALLY need to do this because I am storing long data, and it gets
> cut off.

I have been wondering what it would take to setup a textarea field in such a
manner
so that I can set the output to a text file for later retrieval.

Your mentioning the .txt document and access to hold the file path  brought
this one
back to the front of the file.

    "I have  a very long list of how to's floating around!   :-)  "

So with this in mind can you give an example of how I could set this up so
that when the user sends the webpage's textarea to my server I can
automatically reroute the output to a .txt file so as to by pass the
restrictions
of my database and then maybe a way to set a file path up so that I can
create dynamic web addressing for the files?

All of this material is theory or rather conceptualizing on my part. I still
have
quite a ways to go before I complete my languages C++, Java, CF certified
etc...

So any insight would be greatly appreciated
Thank You
Kevin