Andrew I
|
| Posted: 08/12/2002, 5:19 AM |
|
CCS PHP + MySQL
Is there a way to specify that table joins in CCS-generated SQL do not use the 'JOIN..ON' syntax. That is, instead of:
..FROM Table1 JOIN Table2 ON Table1.ID = Table2.FKey
can CCS generate:
...FROM Table1, Table2 WHERE Table1.ID = Table2.FKey
(The version of MySQL on our servers doesn't support the JOIN..ON syntax).
There's something in the XML file for MySQL in CCS about Joins, but I don't know if this would do the trick.
Any help appreciated.
Andrew
|
|
|
 |
Nocole
|
| Posted: 08/13/2002, 6:56 AM |
|
Andrew,
add the necessary tables, but do not set relationship for them. Then add custom Where clause by clicking plus icon in the DataSource dialog->under Where section, select Expression parameter type and type in the custom where clause.
|
|
|
|
Andrew
|
| Posted: 08/13/2002, 7:28 AM |
|
Nicole,
That's an inspired answer. So simple (and almost obvious).
Thanks very much - you're wonderful.
Andrew
|
|
|
|
|
