Multipage form incorrect INTEGER value

This post has been deleted.

You probably aren't passing a correct integer value to filter the recordset or identify the updated record on the third page. You didn't upload the files, so I couldn't actually look at the code to see if I could spot the issue. When do you get the error on page 3? As the page loads or after you press the update button? That would tell you if the issue is in the recordset or the update code.

I have tried, but do not understand what is wrong.

It looks like your recordset is filtering with the form post value: BokningRefnr

But after you click the update button that form element doesn't exist.

You could probably just move the recordset code on liens 21-26 below the update code and that would fix the problem since you redirect after the update.

Make sure to remove the blank line of code since that can interfere with redirects.

I suspect you are referring to the Bokning_update3.php document. Unfortunately this does not seem to help. I still get error messages: "incorrect INTEGER value:" after clicking the update button.

It implies that you are trying to update an INTEGER field in your database but submitting a non integer value. Can I get a URL with steps to reproduce? What are you entering on each page? What are the data types for the BokningAvbokningAntal, BokningAvbokningDatum, and BokningRefnr columns in your database?

ok lets try!

Update the 4 references to: WADAUpdateRecordID and change them to: BokningRefnr

You are trying to update the record based on the submitted value of that field and it doesn't exist on the first page.

Sorry I don't follow. 4 references? What page are talking about?

Do a find and replace on the page:
Bokning_update3.php

It will appear 4 times.