doutuo6689 2015-06-22 23:52
浏览 427
已采纳

如何在SQL中存储空数组?

I am running into an issue with PHP/SQL

I tried to pass an empty array to SQL with oci_bind_array_by_name and

oci_bind_array_by_name($stid, ":c1", $array, 5, -1, SQLT_CHR);

will give me 'Maximum array length must be greater than zero' error

However, if I first detect the array length and skip obi_bind_array_by_name if array is empty, I will get error from SQL

'not all variables bound'

I need to store empty array sometimes to sql. I am not sure how to fix this. Any ideas?

  • 写回答

1条回答 默认 最新

  • duanmu5641 2015-06-23 10:38
    关注

    You still have to bind all your variable, even if they don't have a value so for

    select * 
    from t1 
    where t1.id = :1 
    

    You'd still have to set :1 to a value and if you want to ignore that condition do:

    select * 
    from t1 
    where (t1.id = '' or '' is '');
    

    assuming it was set to an empty string.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 pyqt6如何引用qrc文件加载里面的的资源
  • ¥15 安卓JNI项目使用lua上的问题
  • ¥20 RL+GNN解决人员排班问题时梯度消失
  • ¥15 统计大规模图中的完全子图问题
  • ¥15 使用LM2596制作降压电路,一个能运行,一个不能
  • ¥60 要数控稳压电源测试数据
  • ¥15 能帮我写下这个编程吗
  • ¥15 ikuai客户端l2tp协议链接报终止15信号和无法将p.p.p6转换为我的l2tp线路
  • ¥15 phython读取excel表格报错 ^7个 SyntaxError: invalid syntax 语句报错
  • ¥20 @microsoft/fetch-event-source 流式响应问题