PHsPeed forums

• PHsPeed forums
• PHsPeed (English)
• Bug reports
• Error when using MySql functions to calculate columns in DBQuery

• VictorUlloa

  • Joined: Mon May 31 2021, 09:32PM
    
  • Posts: 78
    

  
  

  3 months ago

  Fri May 31 2024, 10:00PM

  Options

  • Email
  • Print
  

  VictorUlloa

  • Joined: Mon May 31 2021, 09:32PM
    
  • Posts: 78
    

  
  

  Options

  • Email
  • Print

  
  3 months ago

  ---

  I can't use a sentence using MySQL functions to calculate some column in a DBQuery.

  Environment:
  PHsPeed V1.3.0 B7 - x64, PHP 7.4.5

  Steps to reproduce:
  Just add a DBQuery and set the SQL property to
  
  select concat('This is','a sample') as mycolumn
  
  Then generate code and try to run the form.  The field name ignores the alias, and is set to "concat('This is".  I tried a variety of functions, like "if" or "curdate", with same results.

  Workaround:
  Of course I could create a VIEW with the aliased column, but is not always feasible

   
• administrator

  • Joined: Thu Apr 28 2022, 12:26PM
    
  • Posts: 168
    

  
  

  3 months ago

  Fri May 31 2024, 10:00PMadministrator

  Options

  • Email
  • Print
  

  administrator

  • Joined: Thu Apr 28 2022, 12:26PM
    
  • Posts: 168
    

  
  

  Options

  • Email
  • Print

  
  3 months ago

  ---

  Reproduced and acknowledged! Progress can be followed on
  https://www.phspeed.com/bt/index.php?do=details&task_id=325

  The issue is fixed and you have received a link with the corrected IDE. Please verify. If ok we will deploy in the next release.
  Aducom Support