CB Query Field issue

deltafidesign
OFFLINE
Posts: 341
Thanks: 19
Karma: 4

11 years 8 months ago - 11 years 8 months ago #220422 by deltafidesign

CB Query Field issue was created by deltafidesign

I need to show the value of a field into another field that I want to display into another tab on the profile.

I tryed to use a CB Query field:

SELECT `cb_otherfield` FROM `jos_comprofiler` WHERE `userid` = [user_id]

Nothing is displayed.

If I change table and column every works fine. Seems that it want show if I try to select values from comprofiler db tab.

A bug?

_____________

EDIT: I see that I cannot use a cb substitution into a Fields delimiter field to obtain this.

Last edit: 11 years 8 months ago by deltafidesign.

Please Log in or Create an account to join the conversation.

krileon
ONLINE
Posts: 48456
Thanks: 8280
Karma: 1443

11 years 8 months ago - 11 years 8 months ago #220429 by krileon

Replied by krileon on topic CB Query Field issue

"userid" doens't exist, correct usage is as follows.

Code:

SELECT `cb_otherfield` FROM `#__comprofiler` WHERE `user_id` = '[user_id]'

Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.

Last edit: 11 years 8 months ago by krileon.

The following user(s) said Thank You: deltafidesign

Please Log in or Create an account to join the conversation.

Moderators: beat, nant, krileon