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

recordset problems

Thread began 2/11/2014 9:38 am by Jamie | Last modified 2/11/2014 2:38 pm by Jason Byrnes | 499 views | 5 replies |

Jamie

recordset problems

Hi Jason

Am trying to figure out why 1 page shows/doesnt show data depending on the category selected.

1. http://www.hairmekanix.co.uk/detail-category-test.php?id=8 - All works as expected

2. http://www.hairmekanix.co.uk/detail-category-test.php?id=6 - no data is returned nor is the breadcrumb or section populated with the correct category name (in this case it should be 'Ethical Products')

3. http://www.hairmekanix.co.uk/detail-category-test.php?id=10 - This one is populating the section and breadcrumb categories but is only showing one product when there are 10+ items in the database associated with that category)

I have attached the file if you need it

thanks

Jamie

Sign in to reply to this post

Jason ByrnesWebAssist

I'll need to troubleshoot directly, see the private message section.

Sign in to reply to this post

Jamie

thanks Jason

Sign in to reply to this post

Jason ByrnesWebAssist

in your recordset, change the join type from:
INNER JOIN

to:
LEFT JOIN

since you dont have matches in all of the tables being joined, you are not getting all the results you are expecting.

see this page for more details on the different join types and their uses:

http://en.wikipedia.org/wiki/Join_(SQL)

Sign in to reply to this post

Jamie

thanks Jason. funnily enough I was going to be asking a question about INNER vs LEFT - will take a look at your reference material

thanks again

Jamie

Sign in to reply to this post

Jason ByrnesWebAssist

an INNER join requires a match on both sides.

Left join will return all records from both tables even if the table on the right has a NULL value.

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