当我使用系统名称“proptype”时,我无法获取数据。
以下是我的DMQL2查询代码(使用PHRet):
$search = $rets->SearchQuery(
"Property",
tt_res,
"(dtlist=1990-01-01+), (proptype=1)",
array(
"Select" => "listno,taxes,taxid,status,premarket,ownertype,image,dtphoto,housenum,dirpre,street,dirpost,coordew,coordns,city,state,zip,nonstandaddress,latitude,longitude,proptype,style,listprice,agent,contact,contacttype,contactph1,totbathfull,totbathhalf,totbath,totbed,totsqf,publicremarks,taxid,taxes,dimacres,yearblt,featuresint,featuresext,dtlist,windows,heating,aircon,basmntfin,floor,proptype,lotfacts,roof,landscape,exterior,deck,patio,garage,capgarage,capcarport,inclusions,amenities,water,utilities,pool,zoningchar,cooling,heating,dtlist,schooldistrict,schoolelem,schooljunior,schoolprivate,schoolsenior,schoolother",
"Format" => "COMPACT",
"Count" => 1,
"Limit" => 99
)
);
如果我从搜索查询中删除(proptype=1),查询将返回数据。使用它(proptype=1),我得到以下错误:
Array ( [type] => rets [code] => 20203 [text] => Internal SQL error: 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 '1')))' at line 1 )
如果我输入(proptype='1'),我会得到以下错误:
Array ( [type] => rets [code] => 20203 [text] => Could not parse DMQL2 Query: Lookup PROPTYPE_16 defines no lookup type with value: ''1'' at or near position 94. [...(proptype= !-->'1')),((sta] )
根据我的理解,以及retsmd提供的信息,“proptype”或属性类型是LookupMulti(多值查找)解释类型。它还有6行,值为1-6。我不确定是否正确构造了查询的MultiValue Lookup。
有谁能帮我解释一下吗?我被难住了。