This is all I thought we'd need to do as well, but I've so far found 68 queries that need to be rewritten because the syntax is just not supported when you go through JDBC instead of ODBC.
Ack! That sucks... sorry...
I believe that this particular form of join was generated by the query builder in CF Studio.
Ugh! That makes the issue even worse if the query builder is generating such non-portable SQL... I guess that's the downside of letting tools do stuff for you :(
So I stand by my "huge programming" statement. (I was as surprised as you no doubt are now)
And I stand corrected!
Good luck with the conversion...
Sean A Corfield -- http://www.corfield.org/blog/
"I have always wished that my computer would be as easy to use as my telephone. My wish has come true - I no longer know how to use my telephone."
-- Bjarne Stroustrup
--- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED]
MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
