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

Insert does not work

Thread began 11/30/2015 10:14 am by Ron | Last modified 12/04/2015 12:04 pm by Ray Borduin | 339 views | 6 replies |

Ron

Insert does not work

Hello,

I can't seem to get insert to work. I used the webassist wizard and associated everything within the form. When I attempting to add a record, the contents of the form are cleared and nothing happens and the page reloads. The re-direct doesn't seem to work. I have attached the page in question. Please let me know what you find as my previous post was not replied to.

Sign in to reply to this post

Ray BorduinWebAssist

On line 5 you have:
if (isset($_POST["AddVariety"]) || isset($_POST["AddVariety_x"])) {

It should be:
if (isset($_POST["AddVarietyButton"]) || isset($_POST["AddVarietyButton_x"])) {

Sign in to reply to this post

Ron

This didn't seem to fix the problem. That code you identified as the problem was generated by We assist. I will investigate it further. As the problem is not fixed where can I find log files to help me identify the issue. IIS logs don't tell me anything. PHP or MySQL logs? I m having similar problems with Insert but I am assuming it is the same issue.

Sign in to reply to this post

Ray BorduinWebAssist

There wouldn't be any log files with errors... the issue was the code wasn't running at all because the trigger wasn't valid. If you open the insert or update server behavior and use the select list to choose the button press trigger associated with the form on the page it should generate the correct code.

Sign in to reply to this post

Ron

I am doing what you are suggesting and still nothing is being added. I am noticing that my DW CS6 is haning on a regular basis where I have to delete the configuration directory.

What other thoughts should I be looking at? As it stands nothing is being added. PLEASE HELP

Attached Files
variety_add.php
Sign in to reply to this post

Ray BorduinWebAssist

The code looks correct. If you give me a url where I can test and FTP access I can debug it for you. You may be able to debug it yourself by adding this below the update:

php:
if ((((isset($_POST["AddVarietyButton"]))?$_POST["AddVarietyButton"]:"") != "")) {

  var_dump($InsertQuery);
  die();
}



That will write information about the insert including any error messages that should lead you to what is causing the insert to fail.

Sign in to reply to this post

Ron

THANK YOU!!!!

After dumping the sql I found the error. There was an issue with my Auto-increment in my database. Took me all of 3 minutes to figure out once I read the output dump. Thread closed as fixed.

Sign in to reply to this post

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...