Hey all
This is the first time I am attempting this and have to do it
for a college project.
Basicly I have a small database setup and connected fine (all
tested and everything) And a table containing 5 columns
but when I try to insert new records into the database (Only
3 of the columns I want to), upon clicking submit it just takes me
to a blank page saying ''done'' at the bottom.
I have made sure its set to ''When inserted go to'' and its set
to the next page i want, but its not doing it.
Does anyone have any ideas? Sorry if this is too vauge but I
was thrown right in at the deep end with this and have no clue how
to troubleshoot these things.Problem inserting records
Can you post a link to the page or at least the code?
Does the row actually get inserted into your table?
It could be a myriad of things, like a table issue.
If you are not getting the insert to happen, check your table
set up? Are the fields you not populating set as NOT NULL. If they
are not getting a value and do not allow null values, the insert
will fail.
Other than seeing your code and a link, there is not much
else that I can guess about what is going wrong!Problem inserting records
There's the link to where I am having the problem
No nothing gets inserted at all, all I get is just a blank
page and nothing more unfortunatly
Change your browser to show error messages - CLick TOOLs -
Internet Options - Advanced - last item in browsing is ''Show
Friendly HTTP Error Messages'' make sure to UNcheck this.
Then check your db columns - go to your db and open design
view and set the columns to
''Allow Zero Length''-Yes and ''Required''-No
if you have a auto number make sure to click your form in the
behaviors panel and set the column to ignore
Subscribe to:
Post Comments
(Atom)
No comments:
Post a Comment