doumisha5081
2016-02-22 05:59
浏览 856
已采纳

在postgresql中的存储过程中创建静态数组

I need to write below PHP code in stored procedure

$arrintArTriggerIds = array();

if( CApplicationStage::PRE_QUALIFICATION == $this->getAdo()->m_objApplication->getApplicationStageId() && CApplicationStatus::APPROVED == $this->getAdo()->m_objApplication->getApplicationStatusId() ) {

    $arrintArTriggerIds = array( CArTrigger::PRE_QUALIFICATION );

}

And I need to pass this $arrintArTriggerIds array to select query with where conditions.
This array may contain values like ar_trigger_id IN (102, 103) etc.

Please help me with this. Thanks in advance!

图片转代码服务由CSDN问答提供 功能建议

我需要在存储过程中编写以下PHP代码

   $ arrintArTriggerIds = array(); 
 
if(CApplicationStage :: PRE_QUALIFICATION == $ this-> getAdo() - > m_objApplication-> getApplicationStageId()&& CApplicationStatus :: APPROVED == $ this-&gt  ; getAdo() - > m_objApplication-> getApplicationStatusId()){
 
 $ arrintArTriggerIds = array(CArTrigger :: PRE_QUALIFICATION); 
 
} 
   
 
  

我需要传递这个 $ arrintArTriggerIds 数组来选择查询条件。
这个数组可能包含 ar_trigger_id IN(102,103)之类的值 等等。

请帮帮我。 谢谢提前!

  • 写回答
  • 好问题 提建议
  • 追加酬金
  • 关注问题
  • 邀请回答

2条回答 默认 最新

相关推荐 更多相似问题