close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Multipage form incorrect INTEGER value

Thread began 4/06/2020 8:09 am by Jonas | Last modified 4/09/2020 1:12 pm by Ray Borduin | 76 views | 14 replies |

Jonas

Multipage form incorrect INTEGER value

This post has been deleted.

Ray BorduinWebAssist

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.

Sign in to reply to this post
Did this help? Tips are appreciated...

Jonas

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

Sign in to reply to this post

Ray BorduinWebAssist

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.

Sign in to reply to this post
Did this help? Tips are appreciated...

Jonas

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.

Sign in to reply to this post

Ray BorduinWebAssist

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?

Sign in to reply to this post
Did this help? Tips are appreciated...

Jonas

ok lets try!

Sign in to reply to this post

Ray BorduinWebAssist

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.

Sign in to reply to this post
Did this help? Tips are appreciated...

Jonas

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

Sign in to reply to this post

Ray BorduinWebAssist

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

It will appear 4 times.

Sign in to reply to this post
Did this help? Tips are appreciated...
loading

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...