> And Isaac, I won't damn you. ;)
Mighty kind of you Dave. :)
Although ... I'm not sure about Oracle, but I know that with SQL
Server you can (maybe not with all JDBC drivers, but I'm pretty sure I
have with at least one) use more than one sql statement in a single
cfquery without the semicolons. I hadn't noticed that semicolons had
changed -- though that may also depend on the individual JDBC
driver... I remember having some show-stopper problems when I tried to
use cfqueryparam with the Merant drivers for Oracle that shipped with
CFMX, although I was developing and testing locally with the JDBC
drivers from Oracle and having no problems. Unfortunately in my case
the client didn't go for using the Oracle drivers even though I
believe they're superior in just about every respect. I think there
was a later hotfix for the cfqueryparam issue.
s. isaac dealey 954.927.5117
new epoch : isn't it time for a change?
add features without fixtures with
the onTap open source framework
http://www.sys-con.com/story/?storyid=44477&DE=1
http://www.sys-con.com/story/?storyid=45569&DE=1
http://www.fusiontap.com
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
- ODBC vs JDBC sql syntax differences Samuel R. Neff
- Re: ODBC vs JDBC sql syntax differences Jochem van Dieten
- Re: ODBC vs JDBC sql syntax differences Dave Carabetta
- Re: ODBC vs JDBC sql syntax differences S . Isaac Dealey
- Re: ODBC vs JDBC sql syntax differences S . Isaac Dealey
- Re: ODBC vs JDBC sql syntax differences Dave Carabetta