Duplicate entry \'8333026\' for key \'jos_fb_whoisonline.PRIMARY\' SQL=INSERT INTO jos_fb_whoisonline (`userid` , `time`, `what`, `task`, `do`, `func`,`link`, `userip`, `user`) \n VALUES (\'0\', \'1714275245\', \'Profile Data from CB\',\'\',\'\',\'view\',\'https://www.ari-soft.com/index.php?option=com_kunena&Itemid=54&catid=28&func=view&id=1612&lang=en\', \'18.218.38.125\', \'0\')
Profile Data from CB
(0 viewing)
| | |
TOPIC: Profile Data from CB
|
Profile Data from CB 15 Years, 1 Month ago
|
Karma: 0
|
Here is what I am trying to do:
CB Profiles are set up with service fields for each day of the week so businesses can select which services they provide on each day of the week. Monday: service1, service2, and/or service3. Tuesday: service1, service2, and/or service3. etc.
What I would like to do is set up a service1 page which has 7 tabs:Mon, Tues, Wed, etc. Monday Tab would pull from the profile and show a list of all Profile Names who selected service1 for Monday. Tuesday Tab would pull from the profile and show a list of all Profile Names who selected service1 for Tuesday.
This way, a user who needs service3 on Wednesday can pull up a list of providers who provide service3 on Wednesday.
Will these components accomplish this?
|
|
|
|
|
Re:Profile Data from CB 15 Years, 1 Month ago
|
Karma: 748
|
Hello,
If you can create SQL queries which will be select data for specified service and day then you can use 'ARI JTabView' plugin and create tabs for each day and place in tab 'ARI SQL Table' plugin which will be load data for this day.
Regards,
ARI Soft
|
|
|
|
|
Re:Profile Data from CB 15 Years ago
|
Karma: 0
|
Thank you for the reply. 7 tabs work great with a tweak to the template. The sample query was copied and works. A list of members is displayed.
How do I filter the query to show those members who selected a certain check box pertaining to a certain day? I can pay for your assistance.
Here is some info:
Type: Check Box (Multiple)
Tab: Service
Name: cb_monday
Value: service1
|
|
|
Last Edit: 2009/04/02 06:23 By RebelFlicks.
|
|
Re:Profile Data from CB 15 Years ago
|
Karma: 748
|
Hello,
We are going to add possibility used variables in SQL query for ARI SQL Table plugin in one the next release, it can resolve your problem. But now that implement filtering needs aditional coding, you can use PHP Direct plugin and PHP code for generate SQL query with filtering parameters.
Regards,
ARI Soft
|
|
|
|
|
Re:Profile Data from CB 15 Years ago
|
Karma: 0
|
admin wrote:
We are going to add possibility used variables in SQL query for ARI SQL Table plugin in one the next release
When will that be?
|
|
|
|
|
Re:Profile Data from CB 15 Years ago
|
Karma: 748
|
We implement it within 1-2 months.
Regards,
ARI Soft
|
|
|
|
|
|
| | |