逃生&SOQL 中的(与号) [英] Escaping & (ampersand) in SOQL
问题描述
我有这段代码可以在 Salesforce 上搜索数据:
I have this piece of code to search for data on Salesforce:
代码:
$campaign_name = 'A & B Campaign';
$search = 'FIND {'.$campaign_name.'} IN NAME FIELDS RETURNING CAMPAIGN(ID)';
$searchResult = $mySforceConnection->search($search);
var_dump('$searchResult: ' . print_r($searchResult, true));
错误:
mismatched character '&' expecting '}'
我尝试使用 preg_replace
、htmlentities
,我一直遇到同样的错误,我该怎么做才能搜索包含 &<的字符串/代码>?
I tried to use preg_replace
, htmlentities
, I keep getting the same error, what can I do to be able to search for strings containing &
?
谢谢.
推荐答案
你需要一个斜线,像这样:FIND {A \&B}
(顺便说一下,这是一个有效的 SOSL 搜索;))
You need a slash, like that: FIND {A \& B}
(that's a valid SOSL search by the way ;))
Scroll to bottom of https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_sosl_examples.htm for more info.
不知道是否有内置的 php 函数可以为您执行此操作.最坏的情况是使用 str_replace
、preg_replace
等创建您自己的实用程序.
No idea if there's a built-in php function that would do this for you. Worst case create your own utility function with str_replace
, preg_replace
etc.
这篇关于逃生&SOQL 中的(与号)的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!