odbc sql server 7.0 error

[Guy Bibby]

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 &lt;=
        {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.