Problem importing to Memo field

B

bourgui

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!
 
B

bourgui

BUMP!

Hi all!

So, no-one has any idea?
Or even a workaround?

Thanks in advance!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top