I understand what you're saying. And to verify I ran through a 4th and 5th time. The last two times I took careful notes every step of the way. The 4th time I went through the complete tutorial and noted everything. The 5th time through I stopped as there is no point going far because there are problems from the get go.
Keep in mind that the steps below are from the Integrating Data Bridge and eCart how to you directed me to and said to follow.
My notes are in **[brackets]**
Connect to your database
1. In Dreamweaver, make sure your site is selected
2. Click Window > Databases
3. Click the Add Database (+) button
4. Click MySQL Connection
5. Enter your Connection name, MySQL server, User name, Password, and Database as per your specific setup
6. Click OK
**[I did not have any issues here]**
Create pages in Data Bridge
1. Click WebAssist > Database > DataAssist Pages in the menu bar
2. Select Product Administration from the Application Type list
3. Ensure the database connection you just made is selected from the Connection list
4. Check the Create the database table for me checkbox if it isn't already checked **[this automatically checks if you choose Product Administration in the Application Type list - although I did verify it remained checked before clicking Finish below]**
5. Take note of the database table name that is created for the admin pages **[Products with an upper case "P"]**
6. Click Finish to make the pages
7. Close all pages that were opened
****** ISSUE NUMBER ONE ******
**[During my 5th attempt I decided to upload all files WA created at this point to the server and test. The files were everything in the admin, images, SpryAssets, and webassist directories. The Connections folder was already uploaded to the server during step 1 above. Also I verified that the Products table was in fact created in the database with an upper case "P". There were 24 columns in it. I tried to use the products_insert.php page to add a product to the database and it does NOT work. Upon clicking the Submit button the page appears to refresh and nothing is added to the database. I can manually add a product into the database and see it fine in the search, detail and results pages. I also see the info in the update page however updating gives the same results as the insert page.] This was the same results I had in the first 4 attempts at the tutorial. I'd expect a working set of pages from a tutorial.]**
On to the second issue
Create your Product Catalog pages
1. Click WebAssist > Database > DataAssist Pages in the menu bar
2. Select Product Catalog from the Application Type list
3. Ensure the database connection you just made is selected from the Connection list
4. Uncheck the Create the database table for me checkbox if it is checked **[unchecked by default if you choose Product Catalog from the Application Type list - however I double checked this prior to clicking Finish below]**
5. Verify the database table is the same as the one created for the admin pages **[It is Products with an upper case "P". The Key Column is set to ProductID. This should verify that the correct table (the only table) is selected.]**
6. Click the Manage Pages tab
7. Select the Results page
8. Click the Edit button
9. Uncheck the Include delete button in results list checkbox
10. Click OK
11. Select the Detail page
12. Click the Edit button
13. Uncheck the Include delete button in details list checkbox
14. Click OK
15. Click Finish to make the pages
16. Close all pages that were opened
******ISSUE NUMBER TWO*****
**[Actually everything appears fine at this point, only the one Products table shows in the database and no changes were made to it. The admin insert and update pages don't work of course still. However this is the point were the javascript error is initiated since the users products pages are created. The SELECT statements of both details and results pages have products (lower case "p"). These are the defaults from WA as used in the tutorial. I made absolutely sure the settings in the wizards are correct. There is something in the process that it making this happen.]**
I don't think there is any point on going through the rest of the tutorial as I think these are the reasons the rest is not working for me. I guess I want to know if I am really doing something wrong or if there is a problem in these steps or the process?
I'll try to muddle along the process creating these from scratch as I was prior to being led to the tutorial and see how it goes. I think I have a better understanding of the process at least.
Thanks.
