Delete/Insert/update

3/15/2022 8:20 am | #1 birdscreen398247

On the page we worked on yesterday, I tried to duplicate the Delete/Insert/Update combo on the other field on the page (StateAnnualList), but it is not working.

Can you please take a look at it?

Rows 55 to 90.

Attached Files

BL_Annual_Lists_Edit_Form.php

3/15/2022 10:05 am | #2 Ray BorduinWebAssist

It looks right to me... probably a minor typo. If you give me a call I can debug it with you really quickly on the site and figure out what is going on.

Did this help? Tips are appreciated...

3/16/2022 7:31 am | #3 birdscreen398247

Everything is working now except when I submit, it displays the following:

"INSERT INTO birdlists (CountType, CountYear, CountArea, Quantity, BL_Birder_ID) Values ('Annual','2017','State',299,10) ON DUPLICATE KEY UPDATE Quantity = 299"

That is from line 88.

All of those values and field names are correct.

It DOES update the record, but then it shows that message and doesn't go to the GoTo page.

What is wrong?

Attached Files

BL_Annual_Lists_Edit_Form.php

3/18/2022 6:29 am | #4 Ray BorduinWebAssist

debug code has to be deleted from line 94:

die($ExecuteQuery->debugSQL());

Just remove that line.

Did this help? Tips are appreciated...

Email me with all replies to this thread

Title:

Public Message: (viewable by anyone reading this thread)
(do not cut and paste code into this field unless necessary, attach copies of your pages so they can be opened in Dreamweaver for debugging)

Quote message in reply?

Private Message: (viewable only by you, the person you are replying to, and WebAssist employees)
(only put truly private information in this area such as ftp details and phone numbers. Keep as much of your post public as possible)

These attachments are private (viewable only by you, the person you are replying to, and WebAssist employees)

Manage Attachments

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

Delete/Insert/update

3/15/2022 8:20 am | #1 birdscreen398247