Where can I find documentation for the Merant drivers that ship with CF5?
Specifically, we're trying to work out the kinks with the dBase driver.
>From some initial testing, there's definitely a big difference in the way
this driver is parsing queries that were working fine with the older MS Jet
drivers. A couple of examples:
<cfquery name="myQuery" datasource="somedBaseDSN">
SELECT table1.*, table2.something, table3.somethingelse
FROM (table1 INNER JOIN table2 ON table2.key1 = table1.key1)
LEFT JOIN table3 ON table3.somefield = table1.somefield
WHERE table1.id = #somevalue#
</cfquery>
produces the error:
[MERANT][ODBC dBase driver]Cannot open file 'D:\DATA\(.DBF'.
Apparently it see's the first paren as a table name???
Even simpler:
<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.
Is there some stricter form of ODBC syntax that we need to adhere to?
Anyway, these drivers ARE documented somewhere, right?
Thanks,
Jim
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
