> I wish that was our experience. We are in the processing
> of moving from CF5 to CF6.1. We have 10 applications to
> migrate. The code analyzer found few problem; however, we
> have been changing/testing code for 3 weeks on our MX
> development box because we ran into so many problems. I
> think the main issue is that we run CF on Unix against a
> Sybase database and there doesn't seem to be alot of
> people with that setup so we had several bugs with every
> driver we tried and had to wait for bug fixes from the
> vendors. After 3 weeks of changing code, we are about to
> move to our user acceptance environment. This has
> definitely been a painful upgrade with changing named
> parameters, differences in how NULL is handled,
> differences in how isDefined works, etc.
Just FYI (because I'm sure it's nothing you have the ability to
implement right away) but the onTap framework includes some code for
executing stored procedures with named parameters that's actually
simplified in comparison to <cfstorecproc> ... i.e.
<cfmodule template="#request.tapi.db.procedure()#" procedure="myproc"
data="#form#">
(form is the default)
or
request.tapi.sql.execute("myproc",attributes);
(attributes is the default)
it maps the keys in the structure to the names fo the procedure
parameters and it uses J2EE to accomplish the task, so ... barring the
usual driver bugs it ought to work with Sybase, although I haven't
tested the framework with Sybase... thus far just Oracle, MSSQL,
MSAccess and MySQL.
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://macromedia.breezecentral.com/p49777853/
http://www.sys-con.com/story/?storyid=44477&DE=1
http://www.sys-con.com/story/?storyid=45569&DE=1
http://www.fusiontap.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:194319
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
