Help with JOIN
4 posts by 3 authors in: Forums > CMS Builder
Last Post: March 24, 2009 (RSS)
By (Deleted User) - March 24, 2009
Hello,
I have a quick question, I'm using CMS Builder for a directory. I would like users of the directory to be able to list item that they sell. I do not know how to join the 2 tables so when someone clicks on "store1" only store1's items for sale display.
I am trying to do this in an iframe (is this the best way to do this?)
I hope I'm making sense in what I'm looking to do?
Thanks,
James
I have a quick question, I'm using CMS Builder for a directory. I would like users of the directory to be able to list item that they sell. I do not know how to join the 2 tables so when someone clicks on "store1" only store1's items for sale display.
I am trying to do this in an iframe (is this the best way to do this?)
I hope I'm making sense in what I'm looking to do?
Thanks,
James
Re: [DiscoverSC] Help with JOIN
By ross - March 24, 2009
Hi James
Thanks for the email!
I think I understand what you are looking for but let me know sure before we start going over code :).
Your site lists a bunch of products that are listed by different users. You want to be able to have a list that shows only one person's items. So you could have a link that says "Click here to see everything Bob is selling".
Does that sound about right? Let me know what you think and we'll go from there. Thanks!
Thanks for the email!
I think I understand what you are looking for but let me know sure before we start going over code :).
Your site lists a bunch of products that are listed by different users. You want to be able to have a list that shows only one person's items. So you could have a link that says "Click here to see everything Bob is selling".
Does that sound about right? Let me know what you think and we'll go from there. Thanks!
-----------------------------------------------------------
Cheers,
Ross Fairbairn - Consulting
consulting@interactivetools.com
Hire me! Save time by getting our experts to help with your project.
Template changes, advanced features, full integration, whatever you
need. Whether you need one hour or fifty, get it done fast with
Priority Consulting: http://www.interactivetools.com/consulting/
Cheers,
Ross Fairbairn - Consulting
consulting@interactivetools.com
Hire me! Save time by getting our experts to help with your project.
Template changes, advanced features, full integration, whatever you
need. Whether you need one hour or fifty, get it done fast with
Priority Consulting: http://www.interactivetools.com/consulting/
Re: [ross] Help with JOIN
By (Deleted User) - March 24, 2009
Hi Ross,
That is exactly correct.
Thanks for the quick reply,
James
That is exactly correct.
Thanks for the quick reply,
James
Re: [DiscoverSC] Help with JOIN
By Dave - March 24, 2009
Hi James,
The simplest way would be to use the built in search features described here:
http://www.interactivetools.com/docs/cmsbuilder/viewer_search.html
You can pass the record "num" of the store in the link to filter the results. So say you had a page called products.php that listed all your products. And your products section had a field called "storeNum" which loaded values from the Store section (using num as the value, and name as the label). You could show only the results from a specific store like this:
products.php?storeNum=2
Hope that helps! Let me know if that makes sense.
The simplest way would be to use the built in search features described here:
http://www.interactivetools.com/docs/cmsbuilder/viewer_search.html
You can pass the record "num" of the store in the link to filter the results. So say you had a page called products.php that listed all your products. And your products section had a field called "storeNum" which loaded values from the Store section (using num as the value, and name as the label). You could show only the results from a specific store like this:
products.php?storeNum=2
Hope that helps! Let me know if that makes sense.
Dave Edis - Senior Developer
interactivetools.com
interactivetools.com