Just a guess, but this migh have to do with your transaction isolation
level.
Which DB are you using? UniVerse or UniData?
I assume that the ColdFusion app is using ODBC to connect to the DB?
Pamela J Robbins wrote:
Hi,
We have a Cold Fusion app that is using SQL queries. It's locking
records, unfortunately as many as 100 at a time. Is there a way to do
the query without locking records? We're not updating anything.
Pam
--
Geoffrey Mitchell
Programmer/Analyst
Home Decorator's Collection
314-684-1062
-------
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/