Skip to Content Skip to Menu

🕒 Save Time and Effort with CB Editor Assistant: Effortlessly create and refine content in Joomla 3, 4, & 5.
🎁 Limited Offer: Enjoy a 5-day FREE trial and save up to 30% afterward!
Try It!

Cbquery - 2 databases?

  • nerdyjedi
  • nerdyjedi
  • OFFLINE
  • Posts: 6
  • Thanks: 0
  • Karma: 0
7 years 4 months ago #296746 by nerdyjedi
Cbquery - 2 databases? was created by nerdyjedi
Does cbquery have the ability to look at 2 databases at the same time? Have a membership system on the same server but in a different database. The joomla username matches the membership_id on the external database and I'd like to show the corresponding expiration date from the external db.
Thanks for the help!

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

  • nerdyjedi
  • nerdyjedi
  • OFFLINE
  • Posts: 6
  • Thanks: 0
  • Karma: 0
7 years 4 months ago #296763 by nerdyjedi
Replied by nerdyjedi on topic Cbquery - 2 databases?
Never mind, figured out another way to do it

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

  • krileon
  • krileon
  • ONLINE
  • Posts: 48707
  • Thanks: 8319
  • Karma: 1447
7 years 4 months ago #296785 by krileon
Replied by krileon on topic Cbquery - 2 databases?
Use External mode to query an external database then use substitutions to substitute in information about the user from the current database. See the below regarding substitutions usage information.

www.joomlapolis.com/documentation/279-community-builder/tutorials/18353-using-substitutions-throughout-cb

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.

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

Moderators: beat, nant, krileon
Powered by Kunena Forum