Skip to Content Skip to Menu

🎃 Happy Halloween! Treat yourself with an awesome discount on memberships! Get 20% off now with code SPOOKY-2024!

Executing stored procedures in CB

  • eciudad
  • eciudad
  • OFFLINE
  • Posts: 209
  • Thanks: 19
  • Karma: 0
9 years 3 months ago #267196 by eciudad
Replied by eciudad on topic Executing stored procedures in CB
Thank Krileon,

I made the change and I got this:

"The requested page can't be found.

An error has occurred while processing your request.

You may not be able to visit this page because of:

an out-of-date bookmark/favourite
a mistyped address
a search engine that has an out-of-date listing for this site
you have no access to this page
Home Page

If difficulties persist, please contact the System Administrator of this site and report the error below.

#1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[cb:parse function="clean" method="int"]832[/cb:parse], '' )' at line 1 SQL=call proc_build_father_treeplus([cb:parse function="clean" method="int"]832[/cb:parse], '' )"

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

  • krileon
  • krileon
  • ONLINE
  • Posts: 48477
  • Thanks: 8281
  • Karma: 1443
9 years 3 months ago #267228 by krileon
Replied by krileon on topic Executing stored procedures in CB
You need to enable Format Functions under the Parameters tab.


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.

  • eciudad
  • eciudad
  • OFFLINE
  • Posts: 209
  • Thanks: 19
  • Karma: 0
9 years 3 months ago #267234 by eciudad
Replied by eciudad on topic Executing stored procedures in CB
Thank you Krileon . I set it up and I do not get the error anymore. I am doing my testing and validation. I will advise.

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

Moderators: beatnantkrileon
Powered by Kunena Forum