Help us test the new Databridge BETA with MySQLi support

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › General / Announcements › Dreamweaver › rs problem

rs problem

Thread began 1/09/2017 3:56 pm by Jamie | Last modified 1/11/2017 1:43 pm by Ray Borduin | 657 views | 6 replies |

1/09/2017 3:56 pm | #1 Jamie

rs problem

Hey Ray

Could you give me a hand with a recordset please?

On the attached product_update.php page the Categories rs is adding the parent category name in front of the sub category name (line 733) and on the product_results.php page (also attached) I am trying to do the same on line 351 but cannot get the WADAproducts rs to allow the parentcategory name as well as the sub category.

cheers

Jamie

1/09/2017 4:46 pm | #2 Ray BorduinWebAssist

If you update your recordset on line 151 to:

SELECT products.*, productcategories.*, productmanufacturers.*, productcategories_2.CategoryName AS parentcategoryname FROM  FROM products LEFT JOIN productcategories ON products.ProductCategoryID = productcategories.CategoryID LEFT OUTER JOIN productcategories AS productcategories_2 ON productcategories_2.CategoryID = productcategories.CategoryParentID LEFT JOIN productmanufacturers ON products.ProductManufacturerID = productmanufacturers.ManufacturerID

Then you should be able to refer to the parentcategoryname column when you need to below.

1/10/2017 12:25 am | #3 Jamie

cheers Ray but unfortunately that errors with the following:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'productcategories LEFT OUTER JOIN productcategories AS productcategories_2 ON pr' at line 1

SELECT products.*, productcategories.*, productmanufacturers.*, productcategories_2.CategoryName AS parentcategoryname FROM products LEFT JOIN productcategories ON products.ProductCategoryID = productcategories.CategoryID productcategories LEFT OUTER JOIN productcategories AS productcategories_2 ON productcategories_2.CategoryID = productcategories.CategoryParentID LEFT JOIN productmanufacturers ON products.ProductManufacturerID = productmanufacturers.ManufacturerID

1/10/2017 2:06 pm | #4 Ray BorduinWebAssist

Sorry I had a typo... I think it should have been:

SELECT products.*, productcategories.*, productmanufacturers.*, productcategories_2.CategoryName AS parentcategoryname FROM  FROM products LEFT JOIN productcategories ON products.ProductCategoryID = productcategories.CategoryID LEFT OUTER JOIN productcategories AS productcategories_2 ON productcategories_2.CategoryID = productcategories.CategoryParentID LEFT JOIN productmanufacturers ON products.ProductManufacturerID = productmanufacturers.ManufacturerID

1/10/2017 4:06 pm | #5 Jamie

cheers Ray. Now its not erroring but parentcategoryname is not showing in the bindings at all (and have refreshed etc)....

1/10/2017 6:32 pm | #6 Ray BorduinWebAssist

Have you tried typing it in manually after dragging a different column?

It looks like it is there. I'm not sure why it wouldn't show in the bindings.

1/11/2017 3:39 am | #7 Jamie

hmmm I had done that and it didnt work.

checked again this morning and its working fine..big thanks

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.