Error Executing Database Query.
|
|
[Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 182) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
|
| |
The error occurred in F:\MedSeek\SiteMaker\websitefiles\henryfordhealth3282958\NavBar.cfm: line 940
Called from F:\MedSeek\SiteMaker\websitefiles\henryfordhealth3282958\NavBar.cfm: line 10
Called from F:\MedSeek\SiteMaker\websitefiles\henryfordhealth3282958\NavBar.cfm: line 1
Called from F:\MedSeek\SiteMaker\websitefiles\henryfordhealth3282958\body.cfm: line 454
Called from F:\MedSeek\SiteMaker\websitefiles\henryfordhealth3282958\body.cfm: line 1
Called from F:\MedSeek\SiteMaker\websitefiles\henryfordhealth3282958\NavBar.cfm: line 940
Called from F:\MedSeek\SiteMaker\websitefiles\henryfordhealth3282958\NavBar.cfm: line 10
Called from F:\MedSeek\SiteMaker\websitefiles\henryfordhealth3282958\NavBar.cfm: line 1
Called from F:\MedSeek\SiteMaker\websitefiles\henryfordhealth3282958\body.cfm: line 454
Called from F:\MedSeek\SiteMaker\websitefiles\henryfordhealth3282958\body.cfm: line 1
|
938 : <cfelse>
939 : AND (whoaccess is null or whoaccess like '%Everyone%' or whoaccess like '')
940 : </cfif>
941 : ORDER BY pageorder
942 : </cfquery>
|
|
| SQL |
SELECT graphic3, itemid, CASE pagekey WHEN 'link' THEN itemid2 ELSE itemid END AS LinkID,
LTRIM(RTRIM(sectionname)) as LinkText,
LTRIM(RTRIM(graphic1)) as AdditionalURLParams,
CASE LTRIM(RTRIM(graphic5))
WHEN '' THEN '' ELSE ' target="' + LTRIM(RTRIM(graphic5)) + '"' END AS Target,
CASE pagekey
WHEN 'outsidelink' THEN description
ELSE (pagetemplate + '?id=' + CAST(
CASE pagekey
WHEN 'link' THEN itemid2 ELSE itemid
END AS varchar) +
CASE LEFT(graphic1, 1)
WHEN '&' THEN LTRIM(RTRIM(graphic1)) ELSE '' END)
END AS LinkURL,
LTRIM(RTRIM(buttongraphic)) as buttongraphic,
whoaccess, 'Child' as LinkType
FROM webpages
WHERE parentitemid = 47997
AND pagekey <> 'buttonbarlink'
AND ((sectiontype <> 'defaultbuttonbar' and sectiontype <> 'buttonbar') or sectiontype is null)
AND sectionname <> 'Default Left Button Bar'
AND sectionname <> 'Default Top Button Bar'
AND sectionname <> 'Default Tab Bar'
AND makepublic = 't'
AND makepublicdate <{ts '2009-04-07 05:43:40'} and expiredate > '04/07/2009 23:23:59'
AND (whoaccess is null or whoaccess like '%Everyone%' or whoaccess like '')
ORDER BY pageorder
|
| DATASOURCE |
henryfordhealth3282958 |
| VENDORERRORCODE |
1205 |
| SQLSTATE |
40001 |
|
|
Please try the following:
|
| Browser |
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; Q312461) |
| Remote Address |
207.71.199.149 |
| Referrer |
|
| Date/Time |
07-Apr-09 05:43 AM |
|
