Empty row in DB -table
Question
When doing exactly as you tell in the tutorial I get the file uploaded but in the database an emty row is inserted. It gets its ID but no columns are filled. Whats up whith that? Answer
Please make sure you bind all form field with the database fields in the Insert Record Server Behavior. You also need to bind there the file upload field with the database field where you need to store the filename in.
When doing exactly as you tell in the tutorial I get the file uploaded but in the database an emty row is inserted. It gets its ID but no columns are filled. Whats up whith that? Answer
Please make sure you bind all form field with the database fields in the Insert Record Server Behavior. You also need to bind there the file upload field with the database field where you need to store the filename in.
Comments
???
Sorry newbie here. I'm not sure I quite understood the second part of the answer. I have already bound the form field with the database fields in the Inser Record Server Behaviour. But how do you bind the file upload file with the data base field?
RE: ???
Just select the file field name fmfile and then point to the column of your database where you want to store its name.......
I did all this but the rows on my database are still empty. the picture was uploade fine.
RE: RE: ???
RE: RE: RE: ???
I create a new database... The first one have a table named art_news and it uploads the image but no the others fields to the database. So I check the database create a new one with all the database fields without any special characters.
Ex.:
Table name: artnews
Fields: idnews, newspic, newscont, newsdate
Database name equal a news.mdb created on access 2002/XP and then converted to access 97.
It works fine now.
You must me logged in to write a comment.