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