Search ERROR: org.postgresql.util.PSQLException: ERROR: column "_name" does not exist

SELECT category_id, _name AS name, has_content, has_child FROM category WHERE status = 'Active' AND parent_id = 1 AND category_id <> 3 ORDER BY has_child, order_seq

ERROR: org.postgresql.util.PSQLException: ERROR: column article._name does not exist

SELECT article.article_id, article._name AS name, article._summary AS summary, to_char(article._update_time, 'MM/DD') AS UT FROM article JOIN article_category ON article.article_id = article_category.article_id WHERE article_category.category_id = 3 AND _status = 'Active' ORDER BY article._priority DESC, _update_time DESC LIMIT 5

What's NewChinese Edition

Events and Issues
© 2005 財團法人台灣智庫 Taiwan Thinktank

台北市 100 中正區愛國西路九號八樓 電話 +886-2-2370-6987 傳真 +886-2-2370-6994 連絡我們
9 Aiguo W. Rd. 8th Fl., Taipei 100, Taiwan Phone +886-2-2370-6987 Fax +886-2-2370-6994 Contact Us