Take a look at the "nolock" query hint. On 8/27/07, Pamela J Robbins <[EMAIL PROTECTED]> 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 > > -- > Pamela J Robbins New Bolton Center > Senior Programmer Analyst School of Veterinary Medicine > [EMAIL PROTECTED] University of Pennsylvania > 610-925-6438 > ------- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ >
-- Don Kibbey ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/