📖 ZKIZ Archives


太古d新聞有問題

1 : GS(14)@2014-08-14 00:17:28

http://zkiz.com/news.php?id=199856

Warning: implode(): Invalid arguments passed in /home/zkizcom78f/domains/zkiz.com/public_html/news.php on line 35Error Catched!

Message:
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 ')' at line 1

Query:
SELECT tid, title FROM zf_pages_tracing a, zf_contentpages b WHERE a.tid = b.id AND a.tag IN ()
2 : abbychau(1)@2014-08-18 23:01:57

fixed, 呢個新聞無tag?
3 : GS(14)@2014-08-19 00:04:25

應該是太古A、太古b號碼0019、0087做tag,但我check 過入公告本身就錯左。

這又引申出同一問題,當份公告描述顯示多於一間公司號碼時,個tag唔識spilt,出兩個號碼又唔夠長,咁就出錯
4 : abbychau(1)@2014-08-21 00:23:07

係呀, 好似hkex other 咁.
5 : GS(14)@2014-08-21 02:04:33

abbychau4樓提及
係呀, 好似hkex other 咁.


不如試下變個string 至15睇睇會唔會好少少,然後spilt 番咪得囉
PermaLink: https://articles.zkiz.com/?id=285021

Next Page

ZKIZ Archives @ 2019