Hi Jack
I've just deleted 840 unread WC messages... oh the shame... beginning of
semester here and I'm exhausted. :(
>didn't handle it). I was wondering if the ColdFusion tag "<CFTRANSACTION>"
>would supply rollback capabilities, but didn't do any testing.
On the CFTRANSACTION tag, I use it quite often and yes, it works well with
an Access DB, though it does cause the DB to grow. We now do regular (cron)
compressions as per instructions via Kathy (thankyou again).
Now whether functions in CF "give" functionality to another DB engine that
doesn't have that function.. I'm not so sure. One of the battles I been
fighting over the last few weeks is to do a our own simplified interface to
the mailing list software, Lyris. It uses Visual Fox Pro for it's DB. After
some unidentified problems I decided to buy the Lyris produced ODBC driver
rather than the Microsoft Visual Fox Pro ODBC driver which Lyris say has
bugs (they would, at US$1000 for their driver).
Unfortunately it has "technical limitations" such as "ODBC Minimum+ level
SQL", string data comparisons are case sensitive and who knows what else.
For example instead of using the simple CFUPDATE tag to insert a record I
have to use the proper full SQL INSERT query as the first doesn't work. I
also had problems with data types that I've never experienced before. And
as for transactions, it doesn't support them, and I've not bothered to try
and see if CF "fakes it" for me. I normally rip through this sort of thing
but I'm wasting a lot of time tring to work around the limitations of the
Lyris ODBC. Actually I've largely gone back to using the Lyris perl
interface module which does work well. So I'm doing forms in CF then off to
Perl to do the DB updates and back to CF to report and navigate.
ttfn
Bruce
____________________________________________________________________
--------------------------------------------------------------------
Join The NEW Web Consultants Association FORUMS and CHAT:
Register Today at: http://just4u.com/forums/
Web Consultants Web Site : http://just4u.com/webconsultants
Give the Gift of Life This Year...
Just4U Stop Smoking Support forum - helping smokers for
over three years-tell a friend: http://just4u.com/forums/
To get 500 Banner Ads for FREE
go to http://www.linkbuddies.com/start.go?id=111261
---------------------------------------------------------------------
