close ad
Install the LAtest Updates to Work with CC 2017 and CC 2018
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

update page not updating

Thread began 1/20/2011 10:10 am by davidp420108 | Last modified 1/20/2011 11:08 am by davidp420108 | 1120 views | 9 replies |

davidp420108

update page not updating

Hi again.
I tried to get fancy and make a multiple page insert form. the problem is that it is not updating the fields that I added. basically I tore apart the insert page made by DA and put it on three pages. the second page shows the info from page 1, plus the new fields. page three show page 1 and two info, ad then adds the options for adding photos.

it's broken...the page 2 shows the info correctly form page 1, making me think it is seeing the correct record. but no luck in updating the record after page 1.

by the way, i may have monkeyed it up a bunch as i tried to fix it, but i am stuck. please help.

Attached Files
inventory_Insert_2.zip
Sign in to reply to this post

Jason ByrnesWebAssist

all form processing must occur on the forms action page.

you have the form on inventory_Insert_2.php set to post to inventory_Insert_3.php. this will bypass the update record behavior that you added to the inventory_Insert_2.php page.

Sign in to reply to this post

davidp420108

I changed the <form action> to the inventory_Insert_2.php. Is this what you are referring to?

still no update of information.

Sign in to reply to this post

Jason ByrnesWebAssist

1) edit the WADAInsertRecordID form element to capture the Inventory_ID query string variable that is passed over:

php:
<input name="WADAInsertRecordID" type="hidden" id="WADAInsertRecordID" value="<?php echo(isset($_GET['Inventory_ID'])?$_GET['Inventory_ID']:""); ?>" />



2) In the update record behavior, do not bind the Inventory_ID column to a value. the primary key column should be given a value, it will get it's value from the database.

Sign in to reply to this post

davidp420108

Just starting to learn PHP

I think the number of closing ) is wrong or I need another ( in the code you supplied. I don't know where it goes.

how about between the ? and the $_GET to read ?($_GET

thanks.

Sign in to reply to this post

Jason ByrnesWebAssist

in your form, you have a hidden form element:

php:
<input name="WADAInsertRecordID" type="hidden" id="WADAInsertRecordID" value="" />



find that element and edit it to:

php:
<input name="WADAInsertRecordID" type="hidden" id="WADAInsertRecordID" value="<?php echo(isset($_GET['Inventory_ID'])?$_GET['Inventory_ID']:""); ?>" />
Sign in to reply to this post

davidp420108

Just starting to learn PHP

I think the number of closing ) is wrong or I need another ( in the code you supplied. I don't know where it goes.

the page is now blank when it loads.

thanks.

Sign in to reply to this post

davidp420108

looked like to many closing ). page loads now. but still no update happening. should the fields be bound to the recordset or the upload form?

Sign in to reply to this post

Jason ByrnesWebAssist

they should be bound to the update form.

I think you may be making this more difficult on yourself than it needs to be.

Instead of inserting the form on the first page, then updating it on subsequent pages, you just do the insert once on the last page.

See the following post for details on creating a multi page form:
showthread.php?t=8911

Sign in to reply to this post

davidp420108

It's like you have know me my whole life. I am always making it more difficult. Thanks for the link. I will check it out.

David

Sign in to reply to this post
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...