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/

Reply via email to