Problem updating MS Access memo field with asp

Hi all,

I have an asp page that uploads files and updates an Access database
with client-entered info.

The problem I have is this: the upload script I have uses binaryread to
upload the files (no big surprise there), which means after the upload
I can't access my form's items with 'Request.Form' but with
'uploadObjName.Form'. That's fine.
Except that, in my form, I have a number of 'TextArea' inputs that I
usually import into Access memo fields (using 'rsItem.Fields("MyMemo")
= Request.Form("MyTextArea")).
When I try importing after the upload however (i.e. after the
binaryread), the database field will not be updated, but no error is
returned either (using the code 'rsItem.Fields("MyMemo") =
uploadObjName.Form("MyTextArea") ).

If I change the field type to text, it will import properly (but I
can't use a text field as those entries are usually much longer than
255 characters)

Anybody know how I can get my memo to accept the input? do I need to
cast 'uploadObjName.Form("MyTextArea")' into a different format
somehow?
(keep in mind I can't just invert the order I'm uploading and updating
the database since you can't use 'BinaryRead' or 'Request.Form' once
you've used the other)

Thanks in advance!

Bourgui

.

Relevant Pages

  • Re: I lose data, when I try to save a loaded DataTable on the click of another button in an asp.net
    ... that allows for the upload of an excel sheet into the database. ... I have an upload button and a save button. ... which is bound to a GridView for previewing before ... protected void Upload_Click(object sender, EventArgs e) ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Im about to commit matrimony (now with link)
    ... Keep tweaking the CV and upload new versions if the old ... with Wboserve yesterday, but their upload pages were borked. ... database and run several different filters against it. ... There's still an awful lot of COBOL code around and universities don't teach ...
    (uk.rec.sheds)
  • Re: form to email document
    ... >> append the Session ID for that user Session to the file name. ... >> name uploaded.This can come from a simple text file or a database. ... >>> I was hoping for something like the procedure used to upload a form, ...
    (microsoft.public.frontpage.programming)
  • Re: Can you Upload a file and update a db on 1 form?
    ... You will need to create a form, then submit it to the database, then in the next step in the process ... allow the user to upload a file and then update the record that was created in the first step, ... security update, then there is usually no charge for the call. ... > user to upload a newsletter and update the database with the same form. ...
    (microsoft.public.frontpage.programming)
  • Re: Listbox controls
    ... When the first time I upload the file into the database, ... 'Dim oConnection As New OleDbConnection ... Dim strFileUploadQuery As String = "INSERT INTO Attachments ...
    (microsoft.public.dotnet.languages.vb)