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 'AND w_id=wp_w_id ORDER BY wp_role,wp_id' at line 1
SQL:
SELECT work.*,wp_a_id,wp_role,wp_workdisplay FROM work,work_people WHERE w_id= AND w_id=wp_w_id ORDER BY wp_role,wp_id


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 '' at line 1
SQL:
SELECT * FROM work WHERE w_id=


Mormon Literature Database -
Notice: The Mormon Literature & Creative Arts database has moved to mormonarts.lib.byu.edu.


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 'ORDER BY wpb_order, 0+wpb_pubyear' at line 1
SQL:
SELECT * FROM work_publications WHERE wpb_w_id= ORDER BY wpb_order, 0+wpb_pubyear


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 'ORDER BY wpb_order, 0+wpb_pubyear' at line 1
SQL:
SELECT * FROM work_publications WHERE wpb_w_id= ORDER BY wpb_order, 0+wpb_pubyear


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 'AND l_parent_w_id=w_id AND l_type='Published In' ORDER BY l_type,0+l_volume,l_is' at line 1
SQL:
SELECT link.*,w_title,w_subtitle,w_genre,w_type FROM link,work WHERE l_child_w_id= AND l_parent_w_id=w_id AND l_type='Published In' ORDER BY l_type,0+l_volume,l_issue,l_period,0+l_itemnumber,0+l_pages


 

Genre:  
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 'OR l_child_w_id=' at line 1
SQL:
SELECT * FROM link WHERE l_parent_w_id= OR l_child_w_id=


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 'AND l_parent_w_id=w_id AND l_type!='Published In' ORDER BY l_type,0+REPLACE(l_vo' at line 1
SQL:
SELECT link.*,w_title,w_genre,w_type,w_subtitle,w_type,w_subgenres FROM link,work WHERE l_child_w_id= AND l_parent_w_id=w_id AND l_type!='Published In' ORDER BY l_type,0+REPLACE(l_volume,'[',''),l_issue,l_period,0+l_itemnumber,0+REPLACE(l_pages,'[','')


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 'AND l_child_w_id=w_id ORDER BY l_type,0+REPLACE(l_volume,'[',''),l_issue,l_per' at line 2
SQL:
SELECT link.*,w_title,w_genre,w_subtitle,w_type,w_subgenres FROM link,work WHERE l_type='Published In' AND l_parent_w_id= AND l_child_w_id=w_id ORDER BY l_type,0+REPLACE(l_volume,'[',''),l_issue,l_period,0+l_itemnumber,0+REPLACE(l_pages,'[','')


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 'AND l_child_w_id=w_id ORDER BY l_type,0+l_volume,l_issue,l_period,0+l_itemnumber' at line 1
SQL:
SELECT link.*,w_title,w_subtitle,w_genre,w_type FROM link,work WHERE l_type!='Published In' AND l_parent_w_id= AND l_child_w_id=w_id ORDER BY l_type,0+l_volume,l_issue,l_period,0+l_itemnumber,0+l_pages






Total Queries: 10. Total Execution Time: 0.004 sec.
Copyright © 2003 Brigham Young University. All Rights Reserved.

Feedback: GideonBurton@byu.edu