xbill
|
| Posted: 08/30/2002, 3:01 PM |
|
|
|
|
 |
xbill
|
| Posted: 08/30/2002, 3:02 PM |
|
Hi-
I have been working the Bookstore example
with Mysql/PHP4 templates on CodechargeStudio.
On the AdminEditorials page- the table is built
with a SQL data source. I got this runtime error
when I went to the page:
Database error: Invalid SQL: SELECT COUNT(*) FROM bs_editorial_categories INNER JOIN ( bs_editorials LEFT JOIN bs_items ON bs_editorials.item_id = bs_items.item_id) ON bs_editorial_categories.editorial_cat_id = bs_editorials.editorial_cat_id
MySQL Error: 1064 (You have an error in your SQL syntax near '( bs_editorials LEFT JOIN bs_items ON bs_editorials.item_id = bs_items.item_id) ' at line 1)
Session halted.
It looks like mysql does not like the inner join-
has anyone else seen this error before?
thanks,
-bill
|
|
|
|
Andrew
|
| Posted: 08/31/2002, 5:50 AM |
|
Yes, I've had this problem. The INNER JOIN ... ON syntax is only supported on more recent versions of MySQL.
Nicole gave a good workround that I have found successful, but it does mean re-creating the SQL sources:
http://www.gotocode.com/disc_viewt.asp?mid=13806&s_topic=+JOIN&
Andrew
|
|
|
|
|
