Updating to a MEMO field in ACCESS

[JohnnyPolite]

Hello,

I am using dreamweaver to make a web site with multiple update commands and I just realized that when I use a textarea and update to a memo field in Microsoft Access it transfers the information into the Access table. Yet, when I try to populate the textarea again, it comes up blank. The information is still there in the Access table, but the HTML textarea will not bring it up through ASP VBScript. When I switch the field properties in Access to a text field, the website can recall the information and populate the textarea.

The strange thing is that I am hooking up a database with preexisting information. The first time the textarea populated the field, it transmitted all the information fine. After my update command, it cannot recall it. Like I said, the update command transfers the information into the Access table just fine.

I appreciate any help on this. I have a deadline on this project that is fast approaching. This could put me over the edge.

Thanks again!!!

-JP

 

[JohnnyPolite]

As an addendum to this post, I tried posting the information a second time to the memo field and this time it erased the information and set the value to NULL.

And that is just no good.

So, to summarize, I can't recall from a memo field, I can transmit information once, and then subsequent updates set the value to null.

Ugh. Again, any help would be appreciated. Thanks.

-JP

 

[JohnnyPolite]

One last addendum...

I figured it out. Found a site that explained it was the order in which I was calling the fields and then the fact I have to put a memo into a local variable.

Phew.

Okay, thanks for reading.

-JP

 

[PaulBricker]

What code do you use to retrieve the info from the database? I use a textarea to post information to a database and then on another page, I retrieve that value from the memo field without any issues. What is the "update command"? Are you appending information to the memo field in the database? It would help to see what code you are using.

Paul