Jim-
I can't help you with your first problem, (and it looks like some people
already have) but I may be able to help you with your second.
> <cfquery name="myQuery" datasource="somedBaseDSN">
> SELECT table1.*, table2.something
> FROM table1 INNER JOIN table2 ON table2.key1 = table1.key1
> WHERE table1.id = #somevalue#
> </cfquery>
> gives an error:
> [MERANT][ODBC dBase driver]Extra characters at end of query: INNER.
I had the same problem when I started using the Native Sybase drivers; they
didn't like "INNER JOIN", either. You may end up having to code your
queries old-skool:
SELECT table1.*, table2.something
FROM table1, table2
WHERE (table2.key1 = table1.key1)
AND (table1.id = #somevalue#)
Also, there is a different syntax for LEFT/RIGHT OUTER JOINs:
SELECT table1.*, table2.something
FROM table1, table2
WHERE (table2.key1 *= table1.key1)
AND (table1.id = #somevalue#)
That's a LEFT. A RIGHT is the same, but with a '=*' instead.
HTH,
-R
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
