Insert and update issue

Hi there, I have a system where I am adding product options to a product. I have an Insert and an Update on the same page (wanted this method as its easier for the client to navigate around). The Insert works fine... but then I have 2 issues....

(the results are displayed on the same page - which is what i want so that client can update them (they are just tick boxes and a delete record link).

on the very first Insert the page doesnt display the newly inserted record (i noticed in the URL the product ID is missing...so I have to use the browser back button to come out of that page then reenter and then it appears)...however when I go and insert a second, third, forth..record for that same product..it updates the display of the page and all is fine (so the problem is ONLY on the first record being inserted for that product).

my second issue is that the update record doesnt do anything on that page...so I am wondering how I can get the insert and update to both work nicely on the same page.

here is the file in question....

regard in advance Chris

Insert redirect: step back from this for a moment and think about it. The important thing to realize is this:
the redirect link is created before the record is inserted

this means that it is impossible to set the redirect link to pass the product ID before the product has been inserted to the database.

You should redirect the insert to the detail page, then if you want to update, click the link to load the update page, it would require hand coding to look up the inserted product ID to be able redirect to the update page.


for the update, you are trying to update multiple records, so you will need to use the update multiple records behavior, not the update single records

Hi Jason thanks. I changed the update to a multi record update but getting this error :

Fatal error: Cannot redeclare WA_AB_getLoopedFieldName() (previously declared in C:\Server\www\dinky\WA_DataAssist\WA_AppBuilder_PHP.php:11) in C:\Server\www\dinky\webassist\database_management\wa_appbuilder_php.php on line 20

is this because I have used a repeat selection on another page and its trying to use the same variable.

delete the requirte once line that is trying to attach the webassist\database_management\ wa_appbuilder_php.php file.

is that because I have used Insert/Update that came with Secruity Assist and also Im now using Insert/Update that comes with Data Assist both using different references to appbuilder?

I have uploaded but its not updating the record unless I tick or untick ALL boxes down one column (for example for the records to update the code is forcing me to tick/untick all of "Price includeed boxes). bt I only want to tick one box per prodroduct depending on what I want to chose.

its so frustrating I thought I was getting good :( maybe lack of sleep is making me go wrong)

in the update form, the checkboxes do not have a checked value. you need to provide a checked value for the checkboxes to store in the database when that box is checked, otherwise, it wont send any thing to trigger the update.

Ive tried that but its still not working.....I have included the up to date file.. I know I have set something wrong but I think I have added so many that I am now lost in the code.

could you check the code file and see what I have overlooked :)

Chris

I started an incident for an eCart issue you are having, I will look into this issue at the same time.

Thanks Jason, as always i think I need to stand back and look at the logic when coding. Some many times I miss what can be considered so simple to others. Def a great learning experience talking and getting help with all you guys :)