put a {NOLOCK} after each table you are selecting from. I believe that will
do it.
-----Original Message-----
From: Guy Bibby [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 23, 2000 9:11 PM
To: [EMAIL PROTECTED]
Subject: odbc sql server 7.0 error
hi
has anyone got any ideas on the attached error message? nt 4, sp6a, cf4.0
sql server 7.0 sp?
Cheers
Guy
Error Diagnostic Information</H4>
<P>ODBC Error Code = 40001 (Serialization failure)
<P>
<P>[Microsoft][ODBC SQL Server Driver][SQL Server]Your transaction
(process ID #9) was deadlocked with another process and has been
chosen as
the deadlock victim. Rerun your transaction.
<P>
<P>Data Source = "datasourcename"
<P>SQL = "select JobAd.*, LogoLink.logoURLname, LogoLink.logoURL
From
JobAd, JobAdLogoLink, LogoLink Where Hold = 'Active' and JobAd.SDate
<=
{ts '2000-05-24 12:15:00'} and JobAd.ID in (select distinct
jobadclassification.jobid From JobAdClassification Where
JobAdClassification.GroupID = 8 ) and JobAd.ID =
JobAdLogoLink.JobAdID and
JobAdLogoLink.LogoLinkID = LogoLink.ID order by JobAd.jobtitle ASC"
--
Guy Bibby
Ubiquity Software Limited
+64 9 309 1921
http://www.ubiquity.co.nz
Internet and Database Integration
----------------------------------------------------------------------------
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
-----------------------------------------------------------------------
THIS E-MAIL AND ITS ATTACHMENTS ARE INTENDED ONLY FOR THE USE OF
THE INDIVIDUAL OR ENTITY WHO IS THE INTENDED RECIPIENT AND MAY CONTAIN
INFORMATION THAT IS PRIVILEGED, CONFIDENTIAL AND EXEMPT FROM
DISCLOSURE OR ANY TYPE OF USE UNDER APPLICABLE LAW.
IF THE READER OF THIS E-MAIL IS NOT THE INTENDED RECIPIENT,
OR THE EMPLOYEE, AGENT OR REPRESENTATIVE RESPONSIBLE
FOR DELIVERING THE E-MAIL TO THE INTENDED RECIPIENT,
YOU ARE HEREBY NOTIFIED THAT ANY DISSEMINATION, DISTRIBUTION,
COPYING, OR OTHER USE OF THIS E-MAIL IS STRICTLY PROHIBITED.
IF YOU HAVE RECEIVED THIS E-MAIL IN ERROR, PLEASE REPLY IMMEDIATELY
TO THE SENDER AND DESTROY THIS MESSAGE. OPINIONS, CONCLUSIONS
AND OTHER INFORMATION IN THIS MESSAGE THAT DO NOT RELATE
TO THE OFFICIAL BUSINESS OF RECRUITSOURCE, INC. SHALL BE
UNDERSTOOD AS NEITHER GIVEN NOR ENDORSED BY IT.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
