Forums
This topic is locked
PAU cannot insert form with empty file field
Posted 12 Feb 2007 17:53:18
1
has voted
12 Feb 2007 17:53:18 Chris Holloway posted:
I've run into a problem. If I have a form to insert or update with a file field in it. It works fine as long as I select something in the the file field.
If I try leave it blank... for example, I am only changing a photo's name but not the image file. It errors out
Microsoft VBScript runtime error '800a0005'
Invalid procedure call or argument
/ScriptLibrary/incPU3Class.asp, line 901
any ideas ?
Replies
Replied 12 Feb 2007 18:03:35
12 Feb 2007 18:03:35 Chris Holloway replied:
if I remove PAU, this is the error I get
Microsoft OLE DB Provider for ODBC Drivers error '80040e57'
[Microsoft][ODBC Microsoft Access Driver]Invalid string or buffer length
/admin/photo_edit.asp, line 60
Microsoft OLE DB Provider for ODBC Drivers error '80040e57'
[Microsoft][ODBC Microsoft Access Driver]Invalid string or buffer length
/admin/photo_edit.asp, line 60
Replied 13 Feb 2007 05:15:06
13 Feb 2007 05:15:06 Javier Castro replied:
I had to give up using PAU to update with file fileds. What I did is use only a text field for the file name and created an upload form to upload files without using the database. That way I can use my edit form to change the file name and upload the file corresponding to my record. Also I can upload the same image corrected or modified and works fine. Perhaps not as elegant but works and my clients have not complained once.
<img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>
<img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>